| | |
| | | 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; //鏇存柊鍚屾壒鐢熸垚鐨勬潯鐮佹暟 |
| | |
| | | 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; //鏇存柊鍚屾壒鐢熸垚鐨勬潯鐮佹暟 |
| | |
| | | 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; //鏇存柊鍚屾壒鐢熸垚鐨勬潯鐮佹暟 |
| | |
| | | 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 " + |
| | |
| | | ",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() |
| | |
| | | + ", " + 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 + "'" + ")"); |
| | | |
| | | } |
| | | } |