| | |
|---|
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HBillStatus,HDate,HMaker,HMakeDate" + |
|---|
| | | ",HYear,HPeriod,HRemark" + |
|---|
| | | ",HSourceID,HICMOInterID,HICMOBillNo,HICMOQty,HProcExchInterID,HProcExchEntryID" + |
|---|
| | | ",HProcExchBillNo,HProcExchQty,HMaterID,HFirstCheckEmp" + |
|---|
| | | ",HProcExchBillNo,HProcExchQty,HMaterID,HFirstCheckEmp,HMainProcID" + |
|---|
| | | ") " + |
|---|
| | | " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "'," + omodel.HBillStatus.ToString() + ",'" + omodel.HDate + "','" + DBUtility.ClsPub.CurUserName + "',getdate()" + |
|---|
| | | "," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "'" + |
|---|
| | | "," + omodel.HSourceID.ToString() + "," + omodel.HICMOInterID.ToString() + ",'" + omodel.HICMOBillNo + "'," + omodel.HICMOQty.ToString() + "," + omodel.HProcExchInterID.ToString() + "," + omodel.HProcExchEntryID.ToString() + |
|---|
| | | ",'" + omodel.HProcExchBillNo + "'," + omodel.HProcExchQty.ToString() + "," + omodel.HMaterID.ToString() + "," + omodel.HFirstCheckEmp.ToString() + |
|---|
| | | ",'" + omodel.HProcExchBillNo + "'," + omodel.HProcExchQty.ToString() + "," + omodel.HMaterID.ToString() + "," + omodel.HFirstCheckEmp.ToString() + "," + omodel.HMainProcID + |
|---|
| | | ") "); |
|---|
| | | //插入子表 |
|---|
| | | foreach (Model.ClsQC_PatrolProcCheckBillSub oSub in DetailColl) |
|---|
