| | |
| | | barcode.JMHSupNumber = ordrlist[j].JMHSupNumber; |
| | | barcode.JMHSupName = ordrlist[j].JMHSupName; |
| | | barcode.HTH = ordrlist[j].HTH; |
| | | barcode.HZQty = ordrlist[j].HZQty; |
| | | } |
| | | |
| | | barcode.HBarCode2 = TM; |
| | |
| | | string JMHSupNumber = ""; |
| | | string JMHSupName = ""; |
| | | string HTH = ""; |
| | | double HZQty = 0; |
| | | |
| | | try |
| | | { |
| | |
| | | JMHSupNumber = ClsPub.isStrNull(ListRows[i].JMHSupNumber); |
| | | JMHSupName = ClsPub.isStrNull(ListRows[i].JMHSupName); |
| | | HTH = ClsPub.isStrNull(ListRows[i].HTH); |
| | | HZQty = ClsPub.isDoule(ListRows[i].HZQty); |
| | | } |
| | | |
| | | HMaterID = ClsPub.isLong(ListRows[i].HMaterID2); |
| | |
| | | ",HBarcodeQtys,HBarcodeNo,HDeptID,HWhID,HSPID,HRemark " + |
| | | ",HCusID,HCusType,HEndDate,HWorkLineName,HBarCodeDate " + |
| | | ",HSTOCKORGID,HOWNERID,HSeOrderBillNo,HInterID,HEntryID " + |
| | | ",HGiveAwayFlag,JMHSupID,JMHSupNumber,JMHSupName,HTH" + |
| | | ",HGiveAwayFlag,JMHSupID,JMHSupNumber,JMHSupName,HTH,HZQty" + |
| | | ",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo" + |
| | | ",HCoilNO,HFurnaceNO,HFactory,HAuxQty,HheatNO,HProduceDate,HExpiryDate,HEmpID,HCusModel,HCusMaterName,HCheckEmpName,HBarCodeStatus " + |
| | | ") values (" |
| | |
| | | + ", " + HBarcodeQtys.ToString() + "," + HBarcodeNo.ToString() + "," + HDeptID.ToString() + "," + HWhID.ToString() + "," + HSPID.ToString() + ",'" + HRemark + "'" |
| | | + ", " + HCusID.ToString() + ",'" + HCusType + "','" + HEndDate.ToShortDateString() + "','" + HWorkLineName + "','" + sDate + "'" |
| | | + ", " + HOrgID.ToString() + "," + HOrgID.ToString() + ",'" + HSeOrderBillNo + "'," + HInterID.ToString() + "," + HEntryID.ToString() + "" |
| | | + ", " + DBUtility.ClsPub.BoolToString(HGiveAwayFlag)+",'"+ JMHSupID.ToString()+"','"+ JMHSupNumber+"','"+ JMHSupName+"','"+ HTH |
| | | + ", " + DBUtility.ClsPub.BoolToString(HGiveAwayFlag)+",'"+ JMHSupID.ToString()+"','"+ JMHSupNumber+"','"+ JMHSupName+"','"+ HTH + "','" + HZQty |
| | | + "','" + HMaterName + "','" + HMaterModel + "','" + HPinfan + "'," + HAuxPropID.ToString() + ",'" + HMTONo + "','" + HInnerBillNo + "'" |
| | | + ",'" + HCoilNO2 + "','" + HFurnaceNO2 + "','" + HFactory2 + "'," + HAuxQty2 + ",'" + HheatNO2 + "','" + HProduceDate + "','" + HExpiryDate + "'," + HEmpID2.ToString() + ",'" + HCusModel2 + "','" + HCusMaterName2 + "','" + HCheckEmpName2 + "','鍚堟牸'" + ")"); |
| | | } |