| | |
| | | ",HPlanBillNo,HMaterName,HMaterModel,HQty,HSendType" + |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRecDeptID,HMaterNumber,HErrMsgBackTypeID,HHandleEmpID,HCloseFlag" + |
| | | ",HForm,HChangeNote,HNote,HBadProcMan,HQEMan,HSourceID,HShiftsID,HErrLev,HCenterID" + |
| | | ") " + |
| | | ",HICMOInterID, HICMOEntryID, HICMOBillNo, HProcExchInterID, HProcExchEntryID, HProcExchBillNo" + |
| | | ",HBarCode) " + |
| | | " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" + |
| | | "," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + DBUtility.ClsPub.CurUserName + "',getdate()" + |
| | | ",'" + omodel.HContext + "'," + omodel.HDeptID.ToString() + ",'" + omodel.HDescription + "','" + omodel.HSendMan + "','" + omodel.HReceiveMan + "'" + |
| | |
| | | ",'" + omodel.HPlanBillNo + "','" + omodel.HMaterName + "','" + omodel.HMaterModel + "'," + omodel.HQty.ToString() + ",'" + omodel.HSendType + "'" + |
| | | ",'" + omodel.HMainSourceInterID + "','" + omodel.HMainSourceEntryID + "','" + omodel.HMainSourceBillNo + "','" + omodel.HMainSourceBillType + "'" + |
| | | "," + omodel.HRecDeptID + ",'" + omodel.HMaterNumber + "'," + omodel.HErrMsgBackTypeID + ", " + omodel.HHandleEmpID + ", '" + "0" + |
| | | "','" + omodel.HForm + "','" + omodel.HChangeNote + "','" + omodel.HNote + "','" + omodel.HBadProcMan + "','" + omodel.HQEMan + "','" + omodel.HSourceID + "','" + omodel.HShiftsID + "','" + omodel.HErrLev + "','" + omodel.HCenterID + "') "); |
| | | "','" + omodel.HForm + "','" + omodel.HChangeNote + "','" + omodel.HNote + "','" + omodel.HBadProcMan + "','" + omodel.HQEMan + "','" + omodel.HSourceID + "','" + omodel.HShiftsID + "','" + omodel.HErrLev + "','" + omodel.HCenterID + "'" |
| | | + $",'{omodel.HICMOInterID}', '{omodel.HICMOEntryID}', '{omodel.HICMOBillNo}'" |
| | | + $",'{omodel.HProcExchInterID}', '{omodel.HProcExchEntryID}', '{omodel.HProcExchBillNo}', '{omodel.HBarCode}'" |
| | | + ") "); |
| | | //插入子表 |
| | | |
| | | foreach (Models.ClsOA_ErrMsgBackBillSub2 oSubSec in DetailColl2) |