MES-WEB-API.git

			@@ -6,9 +6,11 @@
			using System;
			using System.Collections.Generic;
			using System.Data;
			using System.IO;
			using System.Linq;
			using System.Net;
			using System.Net.Http;
			using System.Web;
			using System.Web.Http;
			using WebAPI.Models;

			@@ -131,6 +133,10 @@
			{
			list.Add("å¯ä¸æ¡ç ");
			list.Add("æ¹æ¬¡æ¡ç ");
			}
			else if (sCapName == "æµ·è¯")
			{
			list.Add("åç§æ¡ç ");
			}
			else
			{
			@@ -522,6 +528,8 @@
			return ordrlist;
			}



			public object HSourceOrderList1(DataTable dt, HSouceOrderList ordrlist, string HBarCodeType,string HSourceBillType)
			{
			oSystemParameter.ShowBill(ref DBUtility.ClsPub.sExeReturnInfo);
			@@ -589,6 +597,16 @@
			ordrlist.HGiveAwayFlag = 0;
			}
			}
			if (HSourceBillType == "æ¶æéç¥å" \|\| HSourceBillType == "éè´è®¢å")
			{
			if (oSystemParameter.omodel.WMS_CampanyName == "æµ·è¯") //ç³»ç»åæ° å®¢æ·å®å¶ååç§° ç©ºç½ä¸ºéç¨
			{
			ordrlist.HSourceBillSEQ = dt.Rows[i]["HSEQ"].ToString();
			ordrlist.HFactory = dt.Rows[i]["å®¢æ·ç¼å·"].ToString();
			ordrlist.HCoilNO = dt.Rows[i]["æ¬¾å·"].ToString();
			ordrlist.HFurnaceNO = dt.Rows[i]["åç»"].ToString();
			}
			}
			}
			if (HSourceBillType == "éè´§éç¥å")
			{
			@@ -621,7 +639,7 @@
			//æ ¹æ®TABLEåå¥çé¢(åºå¥åºåæ®)
			private object Sub_WriteInForm_InOut(DataTable dt, HSouceOrderList ordrlist, string HBarCodeType, string HSourceBillType)
			{

			oSystemParameter.ShowBill(ref DBUtility.ClsPub.sExeReturnInfo);
			for (int i = 0; i < dt.Rows.Count; i++)
			{
			ordrlist.HQty = dt.Rows[i]["å¯çææ¡ç æ°é"].ToString();
			@@ -654,6 +672,20 @@
			ordrlist.HMTONo = dt.Rows[i]["è®¡åè·è¸ªå·"].ToString();
			ordrlist.HDate = dt.Rows[i]["æ¥æ"].ToString();
			ordrlist.HShowDate = DateTime.Now.ToString();

			if(HSourceBillType=="éè´å¥åºå")
			{
			if(oSystemParameter.omodel.WMS_CampanyName=="æµ·è¯") //ç³»ç»åæ° å®¢æ·å®å¶ååç§° ç©ºç½ä¸ºéç¨
			{
			ordrlist.HInnerBillNo = dt.Rows[i]["éè´è®¢åå·"].ToString();
			ordrlist.HSupID = dt.Rows[i]["HSupID"].ToString();
			ordrlist.HSupNumber = dt.Rows[i]["ä¾åºåä»£ç "].ToString();
			ordrlist.HSupName = dt.Rows[i]["ä¾åºå"].ToString();
			ordrlist.HFactory = dt.Rows[i]["å®¢æ·ç¼å·"].ToString();
			ordrlist.HCoilNO = dt.Rows[i]["æ¬¾å·"].ToString();
			ordrlist.HFurnaceNO = dt.Rows[i]["åç»"].ToString();
			}
			}
			}
			return ordrlist;
			}
			@@ -801,12 +833,13 @@
			long HMaterID = DBUtility.ClsPub.isLong(ordrlist[i].HMaterID); // ç©æåç
			string HBatchNo = DBUtility.ClsPub.isStrNull(ordrlist[i].HBatchNo); // æ¹å·
			long HAuxPropID = DBUtility.ClsPub.isLong(ordrlist[i].HAuxPropID); // è¾å©å±æ§ID
			string HMTONo = DBUtility.ClsPub.isStrNull(ordrlist[i].HMTONo); //è®¡åè·è¸ªå·
			double HSourceQty = DBUtility.ClsPub.isDoule(ordrlist[i].HMinQty); // æºåæ°é
			double HQty = DBUtility.ClsPub.isDoule(ordrlist[i].HQty); // æ°é
			double HMinQty = DBUtility.ClsPub.isDoule(ordrlist[i].HMinQty); // æå°åè£æ°
			if (HMaterID != 0)
			{
			DataSet oDsCheck = oCN.RunProcReturn("exec h_p_Gy_BarCodeBill_AddCheck " + HSno.ToString() + ",'" + HBarCodeType + "','" + HSourceBillNo + "'," + HMaterID.ToString() + ",'" + HBatchNo + "'," + HAuxPropID.ToString() + "," + HSourceQty.ToString() + "," + HQty.ToString() + "," + HMinQty.ToString() + "," + HOrgID.ToString() + ",'" + SourceQtyCtl + "'", "h_p_Gy_BarCodeBill_AddCheck");
			DataSet oDsCheck = oCN.RunProcReturn("exec h_p_Gy_BarCodeBill_AddCheck_New " + HSno.ToString() + ",'" + HBarCodeType + "','" + HSourceBillNo + "'," + HMaterID.ToString() + ",'" + HBatchNo + "'," + HAuxPropID.ToString() + ",'" + HMTONo + "'," + HSourceQty.ToString() + "," + HQty.ToString() + "," + HMinQty.ToString() + "," + HOrgID.ToString() + ",'" + SourceQtyCtl + "'", "h_p_Gy_BarCodeBill_AddCheck_New");
			if (oDsCheck == null && oDsCheck.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			@@ -845,7 +878,7 @@
			int HBQty = 0; //ç®±æ°
			double HQty = 0; //æ°é
			string WeiShu = ""; //å°¾æ°
			int LSH = 0; //æµæ°´å·
			Int64 LSH = 0; //æµæ°´å·
			string LSH2 = ""; //æµæ°´å·è½¬æ¢æåç¬¦
			string sDate = ""; //æ¥æ
			string sYear = ""; //å¹´
			@@ -935,7 +968,7 @@
			sTMNumber = HNumber + sYear + sPeriod + sDay;
			Ds = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæå¤§æµæ°´å·
			//oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'");
			LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]);
			LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]);
			}
			else if (CampanyName == "é£é¾")
			{
			@@ -952,7 +985,7 @@
			sTMNumber = HWorksNumber + HNumber + sYear + sPeriod + sDay;
			Ds = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæå¤§æµæ°´å·
			//oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'");
			LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]);
			LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]);
			}
			else if (CampanyName == "çä¸ç¥º") {
			var date = DateTime.Now.ToString("yyMMdd");//æ¥æ
			@@ -977,7 +1010,7 @@

			//sTMNumber = ordrlist[j].HMaterNumber + "-åè£æ è¯-" + date + "-" + ordrlist[j].HSupNumber + "-";
			Ds = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæå¤§æµæ°´å·
			LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]);
			LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]);
			}
			else if (HSourceBillTypeName == "çäº§å¥åºå")
			{
			@@ -1011,13 +1044,13 @@

			//sTMNumber = ordrlist[j].HMaterNumber + "-åè£æ è¯-"+ date + "-ç»ç»ä»£ç -";
			Ds = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæå¤§æµæ°´å·
			LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]);
			LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]);
			}
			else
			{
			sTMNumber = HOrgNumber + HNumber + sYear + sPeriod + sDay;
			Ds = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæå¤§æµæ°´å·
			LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]);
			LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]);
			}
			}
			else //éç¨æ¹æ³
			@@ -1026,7 +1059,7 @@
			sTMNumber = HOrgNumber + HNumber + sYear + sPeriod + sDay;
			Ds = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæå¤§æµæ°´å·
			//oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'");
			LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]);
			LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]);
			}
			}
			else if (HSelectBarCodeType == "åç§æ¡ç ")
			@@ -1050,7 +1083,7 @@
			sTMNumber = HMaterNumber + sYear + sPeriod + sDay;
			Ds = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæå¤§æµæ°´å·
			//oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'");
			LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]);
			LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]);
			LSHlen = 4;
			}
			else if (HSelectBarCodeType == "ä»ªå¨æåæ¡ç è§å") //å¦å¤å¤çäº
			@@ -1067,7 +1100,7 @@
			sTMNumber = HMaterNumber + HBatchNo;
			Ds = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæå¤§æµæ°´å·
			//oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'");
			LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]);
			LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]);
			LSHlen = 6;
			}
			else if (HSelectBarCodeType == "åéæºæ¡ç ")
			@@ -1077,7 +1110,7 @@
			sTMNumber = "1" + HModelName + HBarCodeDate + HBarCodeBatchNo + HYasuoji + "00";
			Ds = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæå¤§æµæ°´å·
			//oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'");
			LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]);
			LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]);
			LSHlen = 5;
			if (sTMNumber.Length != 16)
			{
			@@ -1094,7 +1127,7 @@
			sTMNumber = HMaterNumber.Replace(".", "") + HBarCodeDate + HBarCodeBatchNo;
			Ds = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæå¤§æµæ°´å·
			//oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'");
			LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]);
			LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]);
			LSHlen = 5;
			if (sTMNumber.Length != 18)
			{
			@@ -1110,7 +1143,7 @@
			sTMNumber = HICMOBillNo;
			Ds = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæå¤§æµæ°´å·
			//oCn.RunProc("exec h_p_WMS_SetMaxNo '" + sTMNumber + "'");
			LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]);
			LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]);
			LSHlen = 5;
			}
			else if (HSelectBarCodeType == "æçæ¡ç ")
			@@ -1119,7 +1152,7 @@
			//æ¡ç åç¼ = ç©æåç + å¹´ + æ + æ¥
			sTMNumber = HNumber + sYear + sPeriod + sDay;
			Ds = oCN.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæå¤§æµæ°´å·
			LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]);
			LSH = ClsPub.isLong(Ds.Tables[0].Rows[0][0]);
			}
			else
			{
			@@ -1184,6 +1217,40 @@
			return objJsonResult;
			}
			HBarCodeList barcode = new HBarCodeList();

			if (CampanyName == "æµ·è¯") //ç³»ç»åæ° å®¢æ·å®å¶ååç§°
			{
			string sHMTONo = ""; //è®¡åè·è¸ªå·
			string sHSourceBillNo = ""; //æºååå·
			string sHSourceBillSEQ = ""; //æºåè¡å·
			string sHSourceEntryID = ""; //æºååID
			string sSupNumber = ""; //ä¾åºåä»£ç
			string sHQty = ""; //æ°é

			sHMTONo = DBUtility.ClsPub.isStrNull(ordrlist[j].HMTONo);
			sHSourceBillNo = DBUtility.ClsPub.isStrNull(ordrlist[j].HBillNo);
			sHSourceBillSEQ = DBUtility.ClsPub.isStrNull(ordrlist[j].HSourceBillSEQ);
			sHSourceEntryID = DBUtility.ClsPub.isStrNull(ordrlist[j].HSubID);
			sSupNumber = DBUtility.ClsPub.isStrNull(ordrlist[j].HSupNumber);
			sHQty = DBUtility.ClsPub.isStrNull(HMinQty);

			if (DBUtility.ClsPub.isStrNull(ordrlist[j].HBillType) == "1102") //æºåï¼éè´è®¢å
			{
			//æ¡ç è§åï¼éè´è®¢ååå·@è¡å·@ç©æä»£ç @MTO@æ°é@ä¾åºåä»£ç
			TM = sHSourceBillNo + "@" + sHSourceBillSEQ + "@" + HMaterNumber + "@" + sHMTONo + "@" + sHQty + "@" + sSupNumber;
			}
			else if (DBUtility.ClsPub.isStrNull(ordrlist[j].HBillType) == "1103") //æºåï¼æ¶æéç¥å
			{
			//æ¡ç è§åï¼æ¶æéç¥åå·@åæ®ååç @ç©æä»£ç @MTO@æ°é@ä¾åºåä»£ç
			TM = sHSourceBillNo + "@" + sHSourceEntryID + "@" + HMaterNumber + "@" + sHMTONo + "@" + sHQty + "@" + sSupNumber;
			}
			else
			{
			//æ¡ç è§åï¼ç©æåç @MTO@æ¹æ¬¡å·@æ°é
			TM = HNumber + "@" + sHMTONo.Replace(" ","") + "@" + HBatchNo.Replace(" ","") + "@" + sHQty;
			}
			}

			barcode.HBarCode2 = TM;
			barcode.HEntryID2 = ClsPub.isStrNull(j + 1);
			barcode.HMaterID2 = ordrlist[j].HMaterID;
			@@ -1501,7 +1568,7 @@
			}
			#endregion

			#region æ¡ç åå¥æ¡ç ä¸»æ¡£
			#region æ¡ç è½¬åæ¡ç ä¸»æ¡£
			/// <summary>
			/// æ¡ç è½¬åæ¡ç ä¸»æ¡£
			/// </summary>
			@@ -1515,7 +1582,7 @@
			{
			var _value = msg["msg"].ToString();
			string msg1 = _value.ToString();
			string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
			string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.None);
			string msg2 = sArray[0].ToString();
			string HOrgType = sArray[1].ToString();
			string HSourceBillTypeName = sArray[2].ToString();
			@@ -1523,6 +1590,9 @@
			string CampanyName = sArray[4].ToString() == "xxx" ? "" : sArray[4].ToString();
			string UserName = sArray[5].ToString();
			string barCodeNo = sArray[6].ToString();
			string HFactory = sArray[7].ToString();
			string HCoilNO = sArray[8].ToString();
			string HFurnaceNO = sArray[9].ToString();
			ClsPub.CurUserName = UserName;

			//è·ååç
			@@ -1551,12 +1621,12 @@
			}
			else
			{

			string HBarCodeType = ClsPub.isStrNull(HSelectBarCodeType);
			// æ¡ç è½¬å
			msg2 = msg2.Replace("\\", "");
			msg2 = msg2.Replace("\n", ""); //\n
			List<HSouceOrderList> ordrlist = Newtonsoft.Json.JsonConvert.DeserializeObject<List<HSouceOrderList>>(msg2);
			LogService.Write(ordrlist[0]);
			// LogService.Write(ordrlist[0]);

			long HSourceInterID = string.IsNullOrEmpty(ordrlist[0].HMainID) == true ? 0 : ClsPub.isLong(ordrlist[0].HMainID);
			long HSourceEntryID = string.IsNullOrEmpty(ordrlist[0].HSubID) == true ? 0 : ClsPub.isLong(ordrlist[0].HSubID);
			@@ -1573,16 +1643,24 @@
			",@HMTONO = N'" + ordrlist[0].HMTONo + "'" +
			",@HBarCodeDate = N'" + ordrlist[0].HDate + "'" +
			",@HEmpID = " + ordrlist[0].HEmpID +
			",@HGroupID = " + ordrlist[0].HGroupID +
			",@HSourceInterID = " + HSourceInterID +
			",@HSourceEntryID = " + HSourceEntryID
			",@HSourceEntryID = " + HSourceEntryID +
			",@HBarCodeType = N'" + HBarCodeType + "'" +
			",@HSourceBillNo = N'" + ordrlist[0].HSourceBillNo + "'" +
			",@HMaker = N'" + ordrlist[0].HMaker + "'" +
			",@HFactory = N'" + HFactory + "'" +
			",@HCoilNO = N'" + HCoilNO + "'" +
			",@HFurnaceNO = N'" + HFurnaceNO + "'" +
			",@HInnerBillNo = N'" + ordrlist[0].HInnerBillNo + "'" +
			",@HSourceBillType = N'" + ordrlist[0].HBillType + "'" +
			",@HStockOrg = N'" + HOrgType + "'" +
			",@HInterID = N'" + ordrlist[0].HInterID + "'"
			, "h_p_SC_BarCode_Transfer");

			if((bool)ds1.Tables[0].Rows[0]["returntype"] == true)
			{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "[0000-1-037]è·åèµæºç»å®æ°æ®æåï¼";
			objJsonResult.Message = ds1.Tables[0].Rows[0]["mesg"].ToString();
			}
			else
			{
			@@ -1599,6 +1677,221 @@
			return objJsonResult;
			}
			return objJsonResult;
			}
			#endregion

			#region æ¡ç è½¬åæ¡ç ä¸»æ¡£(æ¹é)
			/// <summary>
			/// æ¡ç è½¬åæ¡ç ä¸»æ¡£(æ¹é)
			/// </summary>
			/// <param name="msg"></param>
			/// <returns></returns>
			[Route("Sc_BarCode/SaveBarCode_NoGenerate_Batch")]
			[HttpPost]
			public object SaveBarCode_NoGenerate_Batch([FromBody] JObject msg)
			{
			try
			{
			var _value = msg["msg"].ToString();
			string msg1 = _value.ToString();
			string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.None);
			string msg2 = sArray[0].ToString();
			string HOrgType = sArray[1].ToString();
			string HSourceBillTypeName = sArray[2].ToString();
			string HSelectBarCodeType = sArray[3].ToString();
			string CampanyName = sArray[4].ToString() == "xxx" ? "" : sArray[4].ToString();
			string UserName = sArray[5].ToString();
			string barCodeNoStrs = sArray[6].ToString(); // è¿éçæ¡ç æ¯ä¸æäº¤çåæ®åºåå¯¹åºçæ¡ç æ°ç»
			string HFactory = sArray[7].ToString();
			string HCoilNO = sArray[8].ToString();
			string HFurnaceNO = sArray[9].ToString();
			ClsPub.CurUserName = UserName;

			//è·ååç
			HInterID = DBUtility.ClsPub.CreateBillID_Prod(ModName, ref DBUtility.ClsPub.sExeReturnInfo);
			DAL.ClsGy_ORGANIZATIONS_View oClsGy_ORGANIZATIONS_View = new DAL.ClsGy_ORGANIZATIONS_View();
			HOrgNumber = "";
			if (oClsGy_ORGANIZATIONS_View.GetInfoByName(HOrgType))
			{
			HOrgID = oClsGy_ORGANIZATIONS_View.omodel.HItemID;
			HOrgNumber = DBUtility.ClsPub.isStrNull(oClsGy_ORGANIZATIONS_View.omodel.HNumber);
			}
			if (HOrgID == -1)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "[0000-2-055]éæ©ç»ç»æéè¯¯!";
			return objJsonResult;
			}
			if (!Sub_AllowSave(msg2, HSelectBarCodeType))//åæ®å®æ´æ§å¤æ
			{
			return objJsonResult;
			}
			if (HSelectBarCodeType == "ä»ªå¨æåæ¡ç è§å")
			{
			//å®¢æ·å®å¶
			}
			else
			{
			string HBarCodeType = ClsPub.isStrNull(HSelectBarCodeType);
			// æ¡ç è½¬å
			msg2 = msg2.Replace("\\", "");
			msg2 = msg2.Replace("\n", ""); //\n
			List<HSouceOrderList> ordrlist = Newtonsoft.Json.JsonConvert.DeserializeObject<List<HSouceOrderList>>(msg2);
			List<string> barcodeList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<string>>(barCodeNoStrs);
			// TODO éè¿InterID å EntryID ä»æ¡ç æ¡£æ¡ä¸æ¥è¯¢æ¯å¦æå·²çæçåæ® éæ°åä¸ä¸ªåå¨è¿ç¨ï¼å½å·²åå¨å¯¹åºçæ¡ç åæ®æ¶ï¼è¿åæ¡ç ä¸»æ¡£ä¸çæ¡ç æ¡£æ¡
			DataSet dsCache = oCN.RunProcReturn($@"select * from h_v_IF_BarCodeBillList a
			Inner Join Gy_BarCodeBill b on a.HItemID = b.HItemID
			where b.HSourceINterID = { ordrlist[0].HMainID } and b.HSourceEntryID = {ordrlist[0].HSubID}"
			, "h_v_IF_BarCodeBillList");
			if(dsCache.Tables[0].Rows.Count > 0)
			{
			objJsonResult.code = "2";
			objJsonResult.count = 1;
			objJsonResult.data = dsCache.Tables[0];
			objJsonResult.Message = "æ¡ç å·²åå¨!";
			return objJsonResult;
			}
			DataSet ds1 = new DataSet();
			for(int i=0; i<ordrlist.Count; i++)
			{

			long HSourceInterID = string.IsNullOrEmpty(ordrlist[i].HMainID) == true ? 0 : ClsPub.isLong(ordrlist[0].HMainID);
			long HSourceEntryID = string.IsNullOrEmpty(ordrlist[i].HSubID) == true ? 0 : ClsPub.isLong(ordrlist[0].HSubID);

			ds1 = oCN.RunProcReturn("exec h_p_SC_BarCode_Transfer " +
			"@HBarCodeNo = N'" + barcodeList[i] + "'" +
			",@HSubID = " + ordrlist[i].HSubID +
			",@HMaterID = " + ordrlist[i].HMaterID +
			",@HGiveAwayFlag = " + ordrlist[i].HGiveAwayFlag +
			",@HQty = " + ordrlist[i].HQty +
			",@HUnitID = " + ordrlist[i].HUnitID +
			",@HMinQty = " + ordrlist[i].HMinQty +
			",@HSupID = " + ordrlist[i].HSupID +
			",@HBatchNo = N'" + ordrlist[i].HBatchNo + "'" +
			",@HMTONO = N'" + ordrlist[i].HMTONo + "'" +
			",@HBarCodeDate = N'" + ordrlist[i].HDate + "'" +
			",@HEmpID = " + ordrlist[i].HEmpID +
			",@HSourceInterID = " + HSourceInterID +
			",@HSourceEntryID = " + HSourceEntryID +
			",@HBarCodeType = N'" + HBarCodeType + "'" +
			",@HSourceBillNo = N'" + ordrlist[i].HSourceBillNo + "'" +
			",@HMaker = N'" + ordrlist[i].HMaker + "'" +
			",@HFactory = N'" + HFactory + "'" +
			",@HCoilNO = N'" + HCoilNO + "'" +
			",@HFurnaceNO = N'" + HFurnaceNO + "'" +
			",@HInnerBillNo = N'" + ordrlist[i].HInnerBillNo + "'" +
			",@HSourceBillType = N'" + ordrlist[i].HBillType + "'" +
			",@HStockOrg = N'" + HOrgType + "'" +
			",@HInterID = " + ordrlist[i].HInterID
			, "h_p_SC_BarCode_Transfer");
			if ((bool)ds1.Tables[0].Rows[0]["returntype"] == false)
			{
			throw new Exception(ds1.Tables[0].Rows[0]["mesg"].ToString());
			}
			}

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = ds1.Tables[0].Rows[0]["mesg"].ToString();
			}
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "[3899-2-006]æ¡ç çæå¤±è´¥!" + e.Message;
			return objJsonResult;
			}
			return objJsonResult;
			}
			#endregion

			#region [è·åæ ç¾æå°æä»¤ CPCLæä»¤]
			[Route("Sc_BarCode/Get_BarCodePrintCode_CPCL")]
			[HttpGet]
			public object Get_BarCodePrintCode_CPCL(string HOrginationName, int HBillInterID, int HBillEntryID, string HViewName, string HBillSubType, int HInterID)
			{
			try
			{
			ds = oCN.RunProcReturn("exec h_p_getHBarCodePrintCode_CPCL N'" + HOrginationName + "'" +
			"," + HBillInterID + "," + HBillEntryID + ",N'" + HViewName + "',N'" + HBillSubType + "'," + HInterID, "h_p_getHBarCodePrintCode_CPCL");
			if((int)ds.Tables[0].Rows[0]["resultType"] == 1)
			{
			string resultMesg = ds.Tables[0].Rows[0]["payload"].ToString().Replace("\\r\\n", "\r\n");
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = resultMesg;
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "æå°æä»¤è·åå¤±è´¥!" + ds.Tables[0].Rows[0]["payload"];
			return objJsonResult;
			}
			}
			catch(Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "æå°æä»¤è·åå¤±è´¥!" + e.Message;
			return objJsonResult;
			}
			}
			#endregion

			#region [APP è·åæå°æ¨¡æ¿]
			public class PrintTemplate
			{
			public int Id { get; }
			public string OrgShort { get; }
			public string HBillSubtype { get; }
			public string Format { get; }
			public string Description { get; }
			public string[] Placeholder { get; }
			}

			[Route("Sc_BarCode/Get_BarCodeGenTemplate")]
			[HttpGet]
			public object Get_BarCodeGenTemplate(string HOrginationName, string HBillSubType)
			{
			try
			{

			string filePath = HttpContext.Current.Server.MapPath("~/Template");
			string fileFullPath = Path.Combine(filePath, "barCodeTemplateStorage.json");

			if (!File.Exists(fileFullPath))
			{

			throw new Exception($"æ¨¡æ¿æä»¶ä¸åå¨ï¼{fileFullPath}");
			}

			string jsonContent = File.ReadAllText(fileFullPath);
			var templates = JsonConvert.DeserializeObject<PrintTemplate[]>(jsonContent);

			var targetTemplate = templates.FirstOrDefault<PrintTemplate>(t => HOrginationName.Contains(t.OrgShort) && string.Equals(t.HBillSubtype, HBillSubType));
			if (targetTemplate != null)
			{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.data = JsonConvert.SerializeObject(targetTemplate);
			return objJsonResult;
			}
			else
			{
			throw new Exception($"æ²¡ææ¾å°å¯¹åºçæ¨¡æ¿");
			}
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "æå°æ¨¡æ¿è·åå¤±è´¥!" + e.Message;
			return objJsonResult;
			}
			}
			#endregion

			@@ -1797,6 +2090,7 @@
			barcode.HCusModel2 = ordrlist[i].HCusModel;
			barcode.HCusMaterName2 = ordrlist[i].HCusMaterName;
			barcode.HCheckEmpName2 = ordrlist[i].HCheckEmpName;
			barcode.HZZRQ = ordrlist[i].HZZRQ;
			ListRows.Add(barcode);

			n += 1; //æ´æ°åæ¹çæçæ¡ç æ°
			@@ -1901,6 +2195,7 @@
			barcode.HCusModel2 = ordrlist[i].HCusModel;
			barcode.HCusMaterName2 = ordrlist[i].HCusMaterName;
			barcode.HCheckEmpName2 = ordrlist[i].HCheckEmpName;
			barcode.HZZRQ = ordrlist[i].HZZRQ;
			ListRows.Add(barcode);

			n += 1; //æ´æ°åæ¹çæçæ¡ç æ°
			@@ -2005,6 +2300,7 @@
			barcode.HCusModel2 = ordrlist[i].HCusModel;
			barcode.HCusMaterName2 = ordrlist[i].HCusMaterName;
			barcode.HCheckEmpName2 = ordrlist[i].HCheckEmpName;
			barcode.HZZRQ = ordrlist[i].HZZRQ;
			ListRows.Add(barcode);

			n += 1; //æ´æ°åæ¹çæçæ¡ç æ°
			@@ -2075,6 +2371,7 @@
			string HCusModel2 = ClsPub.isStrNull(ListRows[i].HCusModel2);
			string HCusMaterName2 = ClsPub.isStrNull(ListRows[i].HCusMaterName2);
			string HCheckEmpName2 = ClsPub.isStrNull(ListRows[i].HCheckEmpName2);
			string HZZRQ = ClsPub.isStrNull(ListRows[i].HZZRQ);
			oCN.RunProc("insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HBarCodeSubType,HMaterID,HUnitID,HQty" +
			",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HinitQty" +
			",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HEndQty " +
			@@ -2083,7 +2380,7 @@
			",HSTOCKORGID,HOWNERID,HSeOrderBillNo,HInterID,HEntryID " +
			",HGiveAwayFlag " +
			",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo" +
			",HCoilNO,HFurnaceNO,HFactory,HAuxQty,HheatNO,HProduceDate,HExpiryDate,HEmpID,HCusModel,HCusMaterName,HCheckEmpName " +
			",HCoilNO,HFurnaceNO,HFactory,HAuxQty,HheatNO,HProduceDate,HExpiryDate,HEmpID,HCusModel,HCusMaterName,HCheckEmpName,HZZRQ " +
			") values ("
			+ "'" + HBarCode + "','" + HBarCodeType + "','" + HBarCodeSubType + "'," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HQty2.ToString()
			+ ",'" + HBatchNo2 + "'," + HSupID.ToString() + "," + HGroupID2.ToString() + ",'" + ClsPub.CurUserName + "',getdate()," + HPrintQty.ToString() + "," + HQty2.ToString()
			@@ -2093,13 +2390,16 @@
			+ ", " + HOrgID.ToString() + "," + HOrgID.ToString() + ",'" + HSeOrderBillNo + "'," + HInterID.ToString() + "," + HEntryID.ToString() + ""
			+ ", " + DBUtility.ClsPub.BoolToString(HGiveAwayFlag)
			+ ",'" + HMaterName + "','" + HMaterModel + "','" + HPinfan + "'," + HAuxPropID.ToString() + ",'" + HMTONo + "','" + HInnerBillNo + "'"
			+ ",'" + HCoilNO2 + "','" + HFurnaceNO2 + "','" + HFactory2 + "'," + HAuxQty2 + ",'" + HheatNO2 + "','" + HProduceDate + "','" + HExpiryDate + "'," + HEmpID2.ToString() + ",'" + HCusModel2 + "','" + HCusMaterName2 + "','" + HCheckEmpName2 + "'" + ")");
			+ ",'" + HCoilNO2 + "','" + HFurnaceNO2 + "','" + HFactory2 + "'," + HAuxQty2 + ",'" + HheatNO2 + "','" + HProduceDate + "','" + HExpiryDate + "'," + HEmpID2.ToString() + ",'" + HCusModel2 + "','" + HCusMaterName2 + "','" + HCheckEmpName2 + "','" + HZZRQ + "'" + ")");

			}
			}
			//å¢å æ¡ç è¶è¿æªçæåè½æ§å¶

			//
			//èªå¨è£ç®±
			string sql_autoForBoxBill = "exec h_v_Gy_BarCode_AutoProductBarCodeBox " + HInterID.ToString();
			oCN.RunProc(sql_autoForBoxBill);

			oCN.Commit();
			List<Object> listobj = ListRows.ConvertAll(s => (object)s);//Listå®ä½ç±»è½¬æ¢ä¸ºobject
			@@ -2136,6 +2436,204 @@
			}
			}
			#endregion

			#region [app æ¡ç æç è·ååæ¡ç ]
			[Route("Sc_BarCode/SplitBarCode_Sub")]
			[HttpGet]
			public object SplitBarCode_Sub(string HBarCodeNo)
			{
			try
			{
			SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
			//æ¥è¯¢æ¡ç ä¿¡æ¯
			if (HBarCodeNo != null)
			{
			string prefix = HBarCodeNo.Trim() + "-";

			ds = oCn.RunProcReturn("SELECT * FROM h_v_Gy_SplitBarCode WITH(NOLOCK) WHERE HBarCode LIKE '" + prefix + "' + '%' AND HBarCode NOT LIKE '" + prefix + "' + '%-%' AND ISNUMERIC(RIGHT(HBarCode, LEN(HBarCode) - LEN( '" + prefix + "' ))) = 1 AND TRY_CAST(RIGHT(HBarCode, LEN(HBarCode) - LEN( '" + prefix + "' )) AS INT) IS NOT NULL ", "Gy_BarCodeBill");
			if (ds != null \|\| ds.Tables[0].Rows.Count >= 0)
			{
			// æ¾åºæå¤§åç¼æ°åï¼ç¨äºçæä¸ä¸ä¸ªç¼å·
			int maxSuffix = 0;
			foreach (DataRow row in ds.Tables[0].Rows)
			{
			string barCode = row["HBarCode"].ToString();
			string suffixPart = barCode.Substring(prefix.Length); // å - åçé¨å
			if (int.TryParse(suffixPart, out int num))
			{
			if (num > maxSuffix) maxSuffix = num;
			}
			}

			// çæä¸ä¸ä¸ªåç ç¼å·
			string nextBarCode = $"{HBarCodeNo}-{maxSuffix + 1}";

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucessï¼";
			objJsonResult.data = new
			{
			SubBarCodes = ds.Tables[0], // æ¡ç åºç¡ä¿¡æ¯
			NextBarCode = nextBarCode // ä¸ä¸ä¸ªçæçæ¡ç
			};
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "æ¡ç ç¼å·ä¸åå¨, æç¤º";
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "è¯·è¾å¥æ¡ç ç¼å·ææåæ¡ç æ°";
			objJsonResult.data = null;
			return objJsonResult;
			}

			}
			catch (Exception e) //æåºå¼å¸¸
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exceptionï¼" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region [appæ¡ç æç çæ]
			[Route("Sc_BarCode/SplitBarCode_Save")]
			[HttpPost]
			public object SplitBarCode_Save([FromBody] JObject msg)
			{
			try
			{
			ListModels oListModels = new ListModels();
			DAL.ClsGy_BarCodeBill_ChaiMa BillNew = new DAL.ClsGy_BarCodeBill_ChaiMa();
			var _value = msg["msg"].ToString();
			string msg1 = _value.ToString();

			string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
			string barcode = sArray[0].ToString(); //æ¡ç ç¼å·
			Double splitnum = Convert.ToDouble(sArray[1]); //æç æ°é
			string data = sArray[2].ToString(); //è¡¨ä½æ°æ®
			string user = sArray[3].ToString(); //ç¨æ·å

			data = data.Replace("\\", "");
			data = data.Replace("\n", ""); //\n

			List<Model.ClsGy_BarCodeEdit_Model> lsmain = new List<Model.ClsGy_BarCodeEdit_Model>();
			lsmain = oListModels.getObjectByJson_Gy_SplitBarCode(data);

			oCN.BeginTran();

			ds = oCN.RunProcReturn("select top 1 * from Gy_BarCodeBill where HBarCode='" + barcode + "'", "Gy_BarCodeBill");

			if (ds != null \|\| ds.Tables[0].Rows.Count > 0)
			{

			string sql = "insert into Gy_BarCodeBill (HInterID, HEntryID, HBarCode, HBarCodeType, HBarCodeSubType, HMaterID, HUnitID, HQty, HBatchNo, HSupID, HGroupID, HMaker, HMakeDate, " +
			"HPrintQty, HSourceInterID, HSourceEntryID, HSourceBillNo, HSourceBillType, HinitQty, HEndQty, HBarcodeQtys, HBarcodeNo, HDeptID, HWhID, HSPID, HRemark, " +
			"HCusID, HCusType, HEndDate, HWorkLineName, HBarCodeDate, HSTOCKORGID, HOWNERID, HSeOrderBillNo, HGiveAwayFlag, HMaterName, HMaterModel, " +
			"HPinfan, HAuxPropID, HMTONo, HInnerBillNo, HCoilNO, HFurnaceNO, HFactory, HAuxQty, HheatNO, HProduceDate, HExpiryDate, HEmpID, HCusModel, HCusMaterName, HCheckEmpName, HZZRQ" +
			") values (" +
			"'" + ds.Tables[0].Rows[0]["HInterID"].ToString() + "', " +
			"'" + (int.Parse(ds.Tables[0].Rows[0]["HEntryID"].ToString()) + 1).ToString() + "', " +
			"'" + lsmain[0].HBarCode.ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HBarCodeType"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HBarCodeSubType"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HMaterID"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HUnitID"].ToString() + "', " +
			"'" + splitnum + "', " +
			"'" + ds.Tables[0].Rows[0]["HBatchNo"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HSupID"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HGroupID"].ToString() + "', " +
			"'" + user + "', getdate(), " +
			"'" + ds.Tables[0].Rows[0]["HPrintQty"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HSourceInterID"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HSourceEntryID"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HSourceBillNo"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HSourceBillType"].ToString() + "', " +
			"'" + splitnum + "', " +
			"'" + ds.Tables[0].Rows[0]["HEndQty"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HBarcodeQtys"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HBarcodeNo"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HDeptID"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HWhID"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HSPID"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HRemark"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HCusID"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HCusType"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HEndDate"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HWorkLineName"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HBarCodeDate"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HSTOCKORGID"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HOWNERID"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HSeOrderBillNo"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HGiveAwayFlag"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HMaterName"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HMaterModel"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HPinfan"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HAuxPropID"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HMTONo"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HInnerBillNo"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HCoilNO"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HFurnaceNO"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HFactory"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HAuxQty"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HheatNO"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HProduceDate"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HExpiryDate"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HEmpID"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HCusModel"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HCusMaterName"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HCheckEmpName"].ToString() + "', " +
			"'" + ds.Tables[0].Rows[0]["HZZRQ"].ToString() + "'" +
			")";
			//æå¥æåæ¡ç
			oCN.RunProc(sql);
			//æ´æ°èæ¡ç çHQtyæ°é
			oCN.RunProc("update Gy_BarCodeBill set HQty= HQty-'"+splitnum+"' where HItemID="+ ds.Tables[0].Rows[0]["HItemID"].ToString());



			oCN.Commit();
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "ä¿åæåï¼";
			objJsonResult.data = 1;
			return objJsonResult;

			}
			else
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "ä¿åå¤±è´¥ï¼æªæ¥è¯¢å°æ¡ç ä¿¡æ¯";
			objJsonResult.data = 1;
			return objJsonResult;
			}
			}
			catch (Exception e)
			{
			oCN.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "ä¿åå¤±è´¥ï¼" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#endregion
			}
			}