From b7ede349929b44bd664d059728919f6c8eede66a Mon Sep 17 00:00:00 2001
From: ch <37327@LLOOCCY>
Date: 星期四, 30 三月 2023 09:39:44 +0800
Subject: [PATCH] 1

---
 WebAPI/Controllers/仓存管理/条码生成/Sc_BarCodeController.cs |   40 ++++++++++++++++++++++++++++++++++++++--
 1 files changed, 38 insertions(+), 2 deletions(-)

diff --git "a/WebAPI/Controllers/\344\273\223\345\255\230\347\256\241\347\220\206/\346\235\241\347\240\201\347\224\237\346\210\220/Sc_BarCodeController.cs" "b/WebAPI/Controllers/\344\273\223\345\255\230\347\256\241\347\220\206/\346\235\241\347\240\201\347\224\237\346\210\220/Sc_BarCodeController.cs"
index a0cea38..8225dbe 100644
--- "a/WebAPI/Controllers/\344\273\223\345\255\230\347\256\241\347\220\206/\346\235\241\347\240\201\347\224\237\346\210\220/Sc_BarCodeController.cs"
+++ "b/WebAPI/Controllers/\344\273\223\345\255\230\347\256\241\347\220\206/\346\235\241\347\240\201\347\224\237\346\210\220/Sc_BarCodeController.cs"
@@ -708,6 +708,13 @@
             int k = 0;
             int n = 0;                  //鍚屼竴鎵圭敓鎴愭潯鐮佷腑鐨勭鍑犳潯
             string sTMNumber = "";      //鏉$爜鑷畾涔夊墠缂�
+
+            string HCoilNO = "";
+            string HFurnaceNO = "";
+            string HFactory = "";
+            decimal HAuxQty = 0;
+            string HheatNO = "";
+
             DataSet Ds;
             msg2 = msg2.Replace("\\", "");
             msg2 = msg2.Replace("\n", "");  //\n
@@ -720,6 +727,12 @@
                     HNumber = DBUtility.ClsPub.isStrNull(ordrlist[j].HMaterID);
                     HMaterNumber = DBUtility.ClsPub.isStrNull(ordrlist[j].HMaterNumber);
                     HBatchNo = ClsPub.isStrNull(ordrlist[j].HBatchNo);
+
+                    HCoilNO = ClsPub.isStrNull(ordrlist[j].HCoilNO);
+                    HFurnaceNO = ClsPub.isStrNull(ordrlist[j].HFurnaceNO);
+                    HFactory = ClsPub.isStrNull(ordrlist[j].HFactory);
+                    HAuxQty = ClsPub.isLong(ordrlist[j].HAuxQty);
+                    HheatNO = ClsPub.isStrNull(ordrlist[j].HheatNO);
                     //鏃ユ湡鑾峰彇鏂瑰紡
                     sDate = DateTime.Now.ToString();
                     //
@@ -990,6 +1003,12 @@
                         barcode.HInnerBillNo2 = ordrlist[j].HInnerBillNo;
                         barcode.HMaker2 = ordrlist[j].HMaker;
                         barcode.HGiveAwayFlag2 = ordrlist[j].HGiveAwayFlag;
+
+                        barcode.HCoilNO = ordrlist[j].HCoilNO;
+                        barcode.HFurnaceNO = ordrlist[j].HFurnaceNO;
+                        barcode.HFactory = ordrlist[j].HFactory;
+                        barcode.HAuxQty = ordrlist[j].HAuxQty;
+                        barcode.HheatNO = ordrlist[j].HheatNO;
                         ListRows.Add(barcode);
                         k = k + 1;
                         n = n + 1;
@@ -1030,6 +1049,14 @@
             string HInnerBillNo = "";
             bool HGiveAwayFlag = false;
             Int64 HEntryID = 0;
+
+            string HCoilNO2 = "";
+            string HFurnaceNO2 = "";
+            string HFactory2 = "";
+            decimal HAuxQty2 = 0;
+            string HheatNO2 = "";
+            DateTime HProduceDate;
+            DateTime HExpiryDate;
             try
             {
                 oCN.BeginTran();
@@ -1074,6 +1101,14 @@
                         HSeOrderBillNo = ClsPub.isStrNull(ListRows[i].HSeOrderBillNo2);
                         HInnerBillNo = ClsPub.isStrNull(ListRows[i].HInnerBillNo2);
                         HGiveAwayFlag = ClsPub.isBool(ListRows[i].HGiveAwayFlag2);
+
+                        HCoilNO2 = ClsPub.isStrNull(ListRows[i].HCoilNO);
+                        HFurnaceNO2 = ClsPub.isStrNull(ListRows[i].HFurnaceNO);
+                        HFactory2 = ClsPub.isStrNull(ListRows[i].HFactory);
+                        HAuxQty2 = ClsPub.isLong(ListRows[i].HAuxQty);
+                        HheatNO2 = ClsPub.isStrNull(ListRows[i].HheatNO);
+                        HProduceDate = ClsPub.isDate(ListRows[i].HProduceDate);
+                        HExpiryDate = ClsPub.isDate(ListRows[i].HExpiryDate);
                         oCN.RunProc("insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HMaterID,HUnitID,HQty" +
                                     ",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HinitQty" +
                                     ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HEndQty " +
@@ -1081,7 +1116,8 @@
                                     ",HCusID,HCusType,HEndDate,HWorkLineName,HBarCodeDate " +
                                     ",HSTOCKORGID,HOWNERID,HSeOrderBillNo,HInterID,HEntryID " +
                                     ",HGiveAwayFlag " +
-                                    ",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo " +
+                                    ",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo" +
+                                    ",HCoilNO,HFurnaceNO,HFactory,HAuxQty,HheatNO,HProduceDate,HExpiryDate " +
                                     ") values ("
                                     + "'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HQty2.ToString()
                                     + ",'" + HBatchNo2 + "'," + HSupID.ToString() + "," + HGroupID.ToString() + ",'" + ClsPub.CurUserName + "',getdate()," + HPrintQty.ToString() + "," + HQty2.ToString()
@@ -1090,7 +1126,7 @@
                                     + ", " + HCusID.ToString() + ",'" + HCusType + "','" + HEndDate.ToShortDateString() + "','" + HWorkLineName + "','" + sDate + "'"
                                     + ", " + HOrgID.ToString() + "," + HOrgID.ToString() + ",'" + HSeOrderBillNo + "'," + HInterID.ToString() + "," + HEntryID.ToString() + ""
                                     + ", " + DBUtility.ClsPub.BoolToString(HGiveAwayFlag)
-                                    + ",'" + HMaterName + "','" + HMaterModel + "','" + HPinfan + "'," + HAuxPropID.ToString() + ",'" + HMTONo + "','" + HInnerBillNo + "')");
+                                    + ",'" + HMaterName + "','" + HMaterModel + "','" + HPinfan + "'," + HAuxPropID.ToString() + ",'" + HMTONo + "','" + HInnerBillNo + "','" + HCoilNO2 + "','" + HFurnaceNO2 + "','" + HFactory2 + "'," + HAuxQty2 + ",'" + HheatNO2 + "','" + HProduceDate + "','" + HExpiryDate + "'" + ")");
 
 
                         //HNumber = ClsPub.isStrNull(grdSub.Rows[i].Cells[HMaterID2Col].Value);

--
Gitblit v1.9.1