| | |
| | | ",HSupID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" + |
| | | ",HKeeperID,HDeptID,HExplanation,HInnerBillNo,HRedBlueFlag" + |
| | | ") " + |
| | | " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" + |
| | | " values('" + this.BillType + "','" + omodel.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" + |
| | | ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + DBUtility.ClsPub.CurUserName + "',getdate()" + |
| | | ", " + omodel.HSupID.ToString() + "," + omodel.HWHID.ToString() + "," + omodel.HSCWHID.ToString() + "," + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() + "," + omodel.HSecManagerID.ToString() + |
| | | ", " + omodel.HKeeperID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'," + DBUtility.ClsPub.BoolToString(omodel.HRedBlueFlag) + |
| | |
| | | ",HMachineSpeed,HWaterRush,HWaterQty,HWaterRate) " + |
| | | " values(" + |
| | | "'" + this.BillType + |
| | | "','" + this.HBillSubType + |
| | | "','" + omodel.HBillSubType + |
| | | "'," + omodel.HInterID.ToString() + |
| | | ",'" + omodel.HBillNo + |
| | | "','" + omodel.HDate + |
| | |
| | | ",'" + omodel.HRemark + |
| | | "'," + omodel.HProcExchInterID + |
| | | ",'" + omodel.HProcExchBillNo + |
| | | "','" + "3772" + |
| | | "','" + (string.IsNullOrEmpty(omodel.HMainSourceBillType) == true ? "3772" : omodel.HMainSourceBillType) + |
| | | "','" + DBUtility.ClsPub.CurUserName + |
| | | "',getdate()" + |
| | | "," + omodel.HSupID.ToString() + |