MES-WEB-API.git

			@@ -2829,6 +2829,7 @@
			HBarCode_Temp = HPOOrderBillMTO_TMN + "\|" + HMaterNumber_BarCode + "\|" + HInspectionDate_BarCode + "\|" + HQty_BarCode + "\|" + LSH;

			HBarCodeList barcode = new HBarCodeList();
			barcode.HSourceBillSEQ = ordrlist[i].HSourceBillSEQ; // 婧愬崟琛屽彿
			barcode.HBarCode2 = HBarCode_Temp;
			barcode.HBarCodeType2 = "鍞竴鏉＄爜";
			barcode.HBarCodeSubType2 = "";
			@@ -2974,10 +2975,10 @@
			string HInspectionDate = ListRows[i].HInspectionDate;
			int HInspectionCycle = ClsPub.isInt(ListRows[i].HInspectionCycle);
			string HReInspectionDate = ListRows[i].HInspectionDate;
			int HSourceBillSEQ = ClsPub.isInt(ListRows[i].HSourceBillSEQ);
			string HCustomBatchNo = ClsPub.isStrNull(ListRows[i].HInspectionDate).Replace("-","");
			string HBarCodeStatus = "姝ｅ父";
			string HPOOrderBillNoMTO = ClsPub.isStrNull(ListRows[i].HPOOrderBillMTO);

			string sql_produceBarCode = "insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HBarCodeSubType,HMaterID,HUnitID,HQty" +
			",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HinitQty" +
			",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HEndQty " +
			@@ -2987,7 +2988,7 @@
			",HGiveAwayFlag " +
			",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo" +
			",HCoilNO,HFurnaceNO,HFactory,HAuxQty,HheatNO,HProduceDate,HExpiryDate,HEmpID,HCusModel,HCusMaterName,HCheckEmpName,HCustomBatchNo,HBarCodeStatus,HOrderBillNo" +
			",HReInspectionFlag,HInspectionDate,HInspectionCycle,HReInspectionDate " +
			",HReInspectionFlag,HInspectionDate,HInspectionCycle,HReInspectionDate,HSourceBillSEQ " +
			") values ("
			+ "'" + HBarCode + "','" + HBarCodeType + "','" + HBarCodeSubType + "'," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HQty2.ToString()
			+ ",'" + HBatchNo2 + "'," + HSupID.ToString() + "," + HGroupID2.ToString() + ",'" + ClsPub.CurUserName + "',getdate()," + HPrintQty.ToString() + "," + HQty2.ToString()
			@@ -2999,6 +3000,7 @@
			+ ",'" + HMaterName + "','" + HMaterModel + "','" + HPinfan + "'," + HAuxPropID.ToString() + ",'" + HMTONo + "','" + HInnerBillNo + "'"
			+ ",'" + HCoilNO2 + "','" + HFurnaceNO2 + "','" + HFactory2 + "'," + HAuxQty2 + ",'" + HheatNO2 + "','" + HProduceDate + "','" + HExpiryDate + "'," + HEmpID2.ToString() + ",'" + HCusModel2 + "','" + HCusMaterName2 + "','" + HCheckEmpName2 + "','" + HCustomBatchNo + "','" + HBarCodeStatus + "','" + HPOOrderBillNoMTO + "'" +
			"," + HReInspectionFlag + "," + (HInspectionDate == null ? "null" : "'" + HInspectionDate + "'") + "," + HInspectionCycle + "," + (HReInspectionDate == null ? "null" : "'" + HReInspectionDate + "'") +
			"," + HSourceBillSEQ +
			")";

			oCN.RunProc(sql_produceBarCode);