| | |
| | | ",HMaterEmpID=" + omodel.HMaterEmpID + |
| | | ",HMachineSpeed=" + omodel.HMachineSpeed + |
| | | ",HWaterRush=" + omodel.HWaterRush + |
| | | ",HWaterQty=" + omodel.HWaterQty + |
| | | ",HHuaGun='" + omodel.HHuaGun + |
| | | "',HWaterQty=" + omodel.HWaterQty + |
| | | ",HWaterRate=" + omodel.HWaterRate + |
| | | " where HInterID=" + lngBillKey.ToString(); |
| | | } |
| | |
| | | mainSql = "Insert Into Kf_ICStockBillMain" + |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HDate,HYear,HPeriod,HRemark,HMainSourceInterID,HMainSourceBillNo,HMainSourceBillType,HMaker,HMakeDate,HSupID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID,HKeeperID,HDeptID,HExplanation,HInnerBillNo,HRedBlueFlag" + |
| | | ",HICMOInterID,HICMOEntryID,HICMOBillNo,HProcExchInterID,HProcExchEntryID,HProcExchBillNo,HMaterID,HMaterName,HVerNo,HModel,HModel2,HPieceQty,HCusID,HWeight,HLong,HSingleWeight,HMaterSumWeight,HMaterEmpID" + |
| | | ",HMachineSpeed,HWaterRush,HWaterQty,HWaterRate) " + |
| | | ",HMachineSpeed,HWaterRush,HHuaGun,HWaterQty,HWaterRate) " + |
| | | " values(" + |
| | | "'" + this.BillType + |
| | | "','" + omodel.HBillSubType + |
| | |
| | | "," + omodel.HMaterEmpID + |
| | | "," + omodel.HMachineSpeed + |
| | | "," + omodel.HWaterRush + |
| | | "," + omodel.HWaterQty + |
| | | ",'" + omodel.HHuaGun + |
| | | "'," + omodel.HWaterQty + |
| | | "," + omodel.HWaterRate + |
| | | ")"; |
| | | } |