SRM-WEBAPI.git - Gitblit

			@@ -585,6 +585,27 @@
			HSumQty = ClsPub.isDoule(oItemSub.HQty); //HWXQtyCol
			for (int i = 0; i < HBQty; i++)
			{
			LSH = LSH + 1;
			LSH2 = LSH.ToString();
			while (LSH2.Length < LSHlen) //如果流水号小于6位数前面补0
			{
			LSH2 = "0" + LSH2;
			}
			sDate = ClsPub.GetServerDate(0);
			sYear = ClsPub.isDate(sDate).Year.ToString().Substring(2, 2);
			sPeriod = "0" + ClsPub.isDate(sDate).Month.ToString();
			sPeriod = sPeriod.Substring(sPeriod.Length - 2, 2);
			sDay = "0" + ClsPub.isDate(sDate).Day.ToString();
			sDay = sDay.Substring(sDay.Length - 2, 2);
			//==================================
			TM = HNumber + sYear + sPeriod + sDay + LSH2;
			while (TM.Length < SumLen) //如果条码小于12位数前面补0
			{
			TM = "0" + TM;
			}
			//TM = "B" + TM;
			TM = "SRM" + "B" + TM;

			if (HSumQty - HMinQty > 0)
			{
			WeiShu = "";
			@@ -602,8 +623,6 @@
			}
			HMinQty = HSumQty;
			}
			TM = $"{oItemSub.HMaterID}#{HMinQty}";

			Model.ClsGy_BarCodeBill_WMS_Model bar = new Model.ClsGy_BarCodeBill_WMS_Model();
			bar.HBarCode = TM;
			bar.HMaterID = oItemSub.HMaterID;
			@@ -636,7 +655,6 @@
			foreach (Model.ClsGy_BarCodeBill_WMS_Model oItemSub2 in ls2)
			{
			//内箱
			//LogService.Write("循环第一次:" + oItemSub2.HSupID);
			if (ClsPub.isLong(oItemSub2.HMaterID) != 0)
			{
			long sMaterID = ClsPub.isLong(oItemSub2.HMaterID);
			@@ -696,7 +714,7 @@
			TM2 = "0" + TM2;
			}
			bar2.HMaterID = oItemSub2.HMaterID;
			bar2.HBarCode = oItemSub2.HBarCode.Split('#')[0] + "#" + HWXQty.ToString();
			bar2.HBarCode = oItemSub2.HBarCode + "-" + TM2;
			bar2.HUnitID = oItemSub2.HUnitID;
			bar2.HQty = HWXQty;
			bar2.HBatchNo = DBUtility.ClsPub.isStrNull(oItemSub2.HBatchNo);
			@@ -808,6 +826,246 @@
			oCn.RunProc(_sql);
			oCn.Commit();

			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "" + e.Message + DBUtility.ClsPub.sExeReturnInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}

			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "生成条码成功！";
			WebAPIController.Add_Log("条码下推", UserName, "生成条码");
			objJsonResult.data = null;
			return objJsonResult;
			}

			//检查是否已经生成条码
			public bool CheckBarCode(Int64 HSourceInterID, Int64 HSourceEntryID)
			{
			DataSet Ds;
			Ds = oCn.RunProcReturn("select * from Gy_BarCodeBill where HSourceInterID=" + HSourceInterID + " and HSourceEntryID=" + HSourceEntryID, "Gy_BarCodeBill");
			if (Ds == null)
			{
			return false;
			}
			if (Ds.Tables[0].Rows.Count == 0)
			{
			return true;
			}
			else
			{
			return false;
			}
			}

			[Route("GetBarcodeSaveBillOnlyInnerBox")]
			[HttpPost]
			/// <summary>
			/// 生成条码(仅内箱)
			/// </summary>
			/// <param name="msg"></param>
			/// <param name="msg2"></param>
			/// <returns></returns>
			public object GetBarcodeSaveBillOnlyInnerBox([FromBody] JObject msg)
			{
			var _value = msg["msg"].ToString();
			string msg1 = _value.ToString();
			string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
			string msg2 = sArray[0].ToString();
			string msg3 = sArray[1].ToString();
			//LogService.Write(msg3);
			string UserName = "";
			ListModels oListModels = new ListModels();
			try
			{
			List<Model.ClsCg_POInStockBillMain> lsmain = new List<Model.ClsCg_POInStockBillMain>();
			msg2 = msg2.Replace("\\", "");
			msg2 = msg2.Replace("\n", ""); //\n
			lsmain = oListModels.getObjectByJson_POInStockMain(msg2);
			foreach (Model.ClsCg_POInStockBillMain oItem in lsmain)
			{
			UserName = oItem.HMaker;
			}
			DAL.ClsWeb_BarCodeBill oBill = new DAL.ClsWeb_BarCodeBill();

			msg3 = msg3.Substring(1, msg3.Length - 2);
			msg3 = msg3.Replace("\\", "");
			msg3 = msg3.Replace("\n", ""); //\n

			List<Model.ClsGy_MaterialList_WMS_Model> ls = new List<Model.ClsGy_MaterialList_WMS_Model>();
			List<Model.ClsGy_BarCodeBill_WMS_Model> ls2 = new List<Model.ClsGy_BarCodeBill_WMS_Model>();
			List<Model.ClsGy_BarCodeBill_WMS_Model> ls3 = new List<Model.ClsGy_BarCodeBill_WMS_Model>();
			ls = oListModels.getObjectByJson_MaterialList(msg3);

			foreach (Model.ClsGy_MaterialList_WMS_Model oItemSub in ls)
			{
			if (CheckBarCode(oItemSub.HSourceInterID, oItemSub.HSourceEntryID) == false)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "已存在条码，不允许重复生成！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			if (msg2 != string.Empty)
			{
			if (oItemSub.HBQty == 0 \|\| oItemSub.HMinQty == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "内箱包装数不能为0！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			}
			}
			long linterid = Pub_Class.ClsPub.CreateBillID_SRMProd("8888", ref DBUtility.ClsPub.sExeReturnInfo);
			int LSHlen = 6; //流水号长度
			int SumLen = 10; //总长度
			string TM = ""; //条码
			int LSH = 0; //流水号
			string LSH2 = ""; //流水号转换成字符
			string sDate = ""; //日期
			string sYear = ""; //年
			string sPeriod = ""; //月
			string sDay = ""; //日
			DataSet Ds;
			SQLHelper.ClsCNSRM oCn = new SQLHelper.ClsCNSRM();
			Ds = oCn.RunProcReturn("exec GetLSH '" + DateTime.Today + "'", "GetLSH");
			LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]);
			foreach (Model.ClsGy_MaterialList_WMS_Model oItemSub in ls)
			{
			//内箱
			if (ClsPub.isLong(oItemSub.HMaterID) != 0)
			{
			var WeiShu = "";
			var HNumber = oItemSub.HMaterID.ToString();
			var HSumQty = ClsPub.isDoule(oItemSub.HQty);//产品数量
			var HMinQty = ClsPub.isDoule(oItemSub.HMinQty);//内箱包装数量
			var HBQty = ClsPub.isDoule(oItemSub.HBQty); //内箱数
			for (int i = 1; i <= HBQty; i++)
			{
			if ((double)i == HBQty)
			{
			WeiShu = "尾数";
			HMinQty = HSumQty - (HBQty - 1) * HMinQty;
			}
			//TM = $"{oItemSub.HMaterID}#{HMinQty}";
			TM = $"{oItemSub.HMaterID}";
			Model.ClsGy_BarCodeBill_WMS_Model bar = new Model.ClsGy_BarCodeBill_WMS_Model();
			bar.HBarCode = TM;
			bar.HMaterID = oItemSub.HMaterID;
			bar.HUnitID = oItemSub.HUnitID;
			bar.HQty = HMinQty;
			bar.HBatchNo = oItemSub.HBatchNo;
			bar.HKFDate = oItemSub.HKFDate;
			bar.HKFPeriod = oItemSub.HKFPeriod;
			bar.HKFDQDate = oItemSub.HKFDQDate;
			bar.HSourceInterID = oItemSub.HSourceInterID;
			bar.HSourceEntryID = oItemSub.HSourceEntryID;
			bar.HSourceBillNo = oItemSub.HSourceBillNo;
			bar.HSourceBillType = oItemSub.HSourceBillType;
			bar.HMinQty = oItemSub.HMinQty;
			bar.HSupID = oItemSub.HSupID;
			bar.HEndQty = WeiShu;
			bar.HMTONO = oItemSub.HMTONO;
			ls2.Add(bar);
			}
			}
			}
			string HBarCode = "";
			string HBarCodeType = "";
			Int64 HMaterID = 0;
			Int64 HUnitID = 0;
			double HQty2 = 0;
			string HBatchNo = "";
			Int64 HSupID = 0;
			Int64 HGroupID = 0;
			int HPrintQty = 0;
			Int64 HSourceInterID = 0;
			Int64 HSourceEntryID = 0;
			string HSourceBillNo = "";
			string HSourceBillType = "";
			Int64 HKFPeriod = 0;
			string HKFDate = "";
			string HKFDQDate = "";
			string HWei = "";
			string HMTONO = "";
			oCn.BeginTran();
			foreach (Model.ClsGy_BarCodeBill_WMS_Model oItemSub in ls2)
			{
			if (ClsPub.isLong(oItemSub.HMaterID) != 0)
			{
			HBarCode = oItemSub.HBarCode.ToString();
			HMTONO = ClsPub.isStrNull(oItemSub.HMTONO);
			HBarCodeType = "品种码";
			HMaterID = ClsPub.isLong(oItemSub.HMaterID);
			HUnitID = ClsPub.isLong(oItemSub.HUnitID);
			HQty2 = ClsPub.isDoule(oItemSub.HQty);
			HBatchNo = ClsPub.isStrNull(oItemSub.HBatchNo);
			HSupID = oItemSub.HSupID;
			//LogService.Write("HSupID:" + oItemSub.HSupID);
			HKFPeriod = ClsPub.isInt(oItemSub.HKFPeriod);
			HKFDate = ClsPub.isStrNull(oItemSub.HKFDate);
			HKFDQDate = ClsPub.isStrNull(oItemSub.HKFDQDate);
			HSourceInterID = ClsPub.isLong(oItemSub.HSourceInterID);
			HSourceEntryID = ClsPub.isLong(oItemSub.HSourceEntryID);
			HSourceBillNo = ClsPub.isStrNull(oItemSub.HSourceBillNo);
			HSourceBillType = ClsPub.isStrNull(oItemSub.HSourceBillType);
			HWei = ClsPub.isStrNull(oItemSub.HEndQty);
			string sql = "insert into Gy_BarCodeBill (HInterID,HBarCode,HBarCodeType,HMaterID,HUnitID,HQty,HKFDate,HKFPeriod,HKFDQDate" +
			",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HEndQty,HSupflag" +
			",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HMTONO " +
			") values ("
			+ linterid.ToString() + ",'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID + "," + HUnitID + "," + HQty2 + ",'" + HKFDate + "'," + HKFPeriod + ",'" + HKFDQDate
			+ "','" + HBatchNo + "'," + HSupID + "," + HGroupID + ",'" + ClsPub.CurUserName + "','" + DateTime.Today + "'," + HPrintQty + ",'" + HWei + "',1"
			+ "," + HSourceInterID + "," + HSourceEntryID + ",'" + HSourceBillNo + "','" + HSourceBillType + "','" + HMTONO + "')";
			oCn.RunProc(sql);
			sql = "exec setLSH '" + DateTime.Today + "'";
			oCn.RunProc(sql);
			}
			}
			foreach (Model.ClsGy_BarCodeBill_WMS_Model oItemSub in ls3)
			{
			//LogService.Write("循环第三次:" + oItemSub.HSupID);
			if (ClsPub.isLong(oItemSub.HMaterID) != 0)
			{
			HBarCode = oItemSub.HBarCode.ToString();
			HMTONO = ClsPub.isStrNull(oItemSub.HMTONO);
			HBarCodeType = "箱号内条码";
			HMaterID = ClsPub.isLong(oItemSub.HMaterID);
			HUnitID = ClsPub.isLong(oItemSub.HUnitID);
			HQty2 = ClsPub.isDoule(oItemSub.HQty);
			HBatchNo = ClsPub.isStrNull(oItemSub.HBatchNo);
			HSupID = oItemSub.HSupID;
			HKFPeriod = ClsPub.isInt(oItemSub.HKFPeriod);
			HKFDate = ClsPub.isStrNull(oItemSub.HKFDate);
			HKFDQDate = ClsPub.isStrNull(oItemSub.HKFDQDate);
			HSourceInterID = ClsPub.isLong(oItemSub.HSourceInterID);
			HSourceEntryID = ClsPub.isLong(oItemSub.HSourceEntryID);
			HSourceBillNo = ClsPub.isStrNull(oItemSub.HSourceBillNo);
			HSourceBillType = ClsPub.isStrNull(oItemSub.HSourceBillType);
			HWei = ClsPub.isStrNull(oItemSub.HEndQty);
			string sql = "insert into Gy_BarCodeBill (HInterID,HBarCode,HBarCodeType,HMaterID,HUnitID,HQty,HKFDate,HKFPeriod,HKFDQDate" +
			",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HEndQty,HSupflag" +
			",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HMTONO " +
			") values ("
			+ linterid.ToString() + ",'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID + "," + HUnitID + "," + HQty2 + ",'" + HKFDate + "'," + HKFPeriod + ",'" + HKFDQDate
			+ "','" + HBatchNo + "'," + HSupID + "," + HGroupID + ",'" + ClsPub.CurUserName + "','" + DateTime.Today + "'," + HPrintQty + ",'" + HWei + "',1"
			+ "," + HSourceInterID + "," + HSourceEntryID + ",'" + HSourceBillNo + "','" + HSourceBillType + "','" + HMTONO + "')";
			oCn.RunProc(sql);
			}
			}
			//暂时只回填关联数量
			string _sql = "exec H_p_SRM_BarCodeBill_Update_UpdateBillRelateData " + linterid.ToString();
			oCn.RunProc(_sql);
			oCn.Commit();
			}
			catch (Exception e)
			{
			@@ -950,7 +1208,7 @@
			return objjson;
			}
			DAL.ClsWeb_BarCodeBill oClsWeb_BarCodeBill = new DAL.ClsWeb_BarCodeBill();
			ds = oClsWeb_BarCodeBill.ShowBillSub6(DBUtility.ClsPub.isLong(sMsg), ShowItem, ref DBUtility.ClsPub.sExeReturnInfo);
			ds = ShowBillSub6(DBUtility.ClsPub.isLong(sMsg), ShowItem, ref DBUtility.ClsPub.sExeReturnInfo);
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			objjson.code = "0";
			@@ -978,6 +1236,28 @@
			return objjson;
			}
			}
			public DataSet ShowBillSub6(long lngBillKey, string sShowItem, ref string sReturn)
			{
			string str = "";
			try
			{
			string MvarItemKeySubForWeb4 = "h_v_Web_BarCodeBill_ForWeb2";
			str = string.Concat(new object[] { "Select ", sShowItem, " from ", MvarItemKeySubForWeb4, " Where HInterID=", lngBillKey.ToString(), " order by HEntryID " });
			DataSet set = oCn.RunProcReturn(string.Concat(new object[] { "Select ", sShowItem, " from ", MvarItemKeySubForWeb4, " Where HInterID=", lngBillKey.ToString(), " order by HEntryID " }), MvarItemKeySubForWeb4);
			if ((set == null) \|\| (set.Tables[0].Rows.Count == 0))
			{
			sReturn = "单据体未找到！";
			return null;
			}
			sReturn = "显示单据体成功！";
			return set;
			}
			catch (Exception exception)
			{
			sReturn = exception.Message + str;
			return null;
			}
			}
			[Route("GetHBarCodeShowBillMain")]
			[HttpGet]
			/// <summary>