| | |
|---|
| | | ,HYear,HPeriod,HRemark,HMaker,HMakeDate,HChecker,HCheckDate |
|---|
| | | ,HSeOrderBillNo,HSeOrderInterID,HSeOrderEntryID,HEmpID,HCusID |
|---|
| | | ,HCenterID,HPlanQty,HDeptID,HMaterID,HUnitID,HBomID,HPlanBeginDate,HPlanEndDate,HBillStatus |
|---|
| | | ,HOWNERID,HOWNERTYPEID) |
|---|
| | | ,HOWNERID,HOWNERTYPEID,HComboXSLX) |
|---|
| | | values('3710'," + mainList[0].HInterID + ",'" + mainList[0].HBillNo + "','" + mainList[0].HDate + "'," + mainList[0].HPRDORGID + |
|---|
| | | "," + DateTime.Now.Year + "," + DateTime.Now.Month + ",'" + mainList[0].HRemark + "','" + mainList[0].HMaker + "',getdate(),'" + mainList[0].HMaker + "',getdate()" + |
|---|
| | | ",'" + mainList[0].HSeOrderBillNo + "'," + mainList[0].HSeOrderInterID + "," + mainList[0].HSeOrderEntryID + "," + mainList[0].HEmpID + "," + mainList[0].HCusID + |
|---|
| | | "," + mainList[0].HCenterID + "," + mainList[0].HPlanQty + ",0,0,0,0,'','',2" + |
|---|
| | | "," + mainList[0].HOWNERID + ",'" + mainList[0].HOWNERTYPEID + "') "); |
|---|
| | | "," + mainList[0].HOWNERID + ",'" + mainList[0].HOWNERTYPEID + "','" + mainList[0].HComboXSLX + "') "); |
|---|
| | | //涓昏〃 |
|---|
| | | oCN.RunProc(@"Insert Into Sc_ICMOBillMain |
|---|
| | | (HBillType,HInterID,HBillNo,HDate,HPRDORGID |
|---|
| | | ,HYear,HPeriod,HRemark,HMaker,HMakeDate,HChecker,HCheckDate |
|---|
| | | ,HSeOrderBillNo,HSeOrderInterID,HSeOrderEntryID,HEmpID,HCusID |
|---|
| | | ,HCenterID,HPlanQty,HDeptID,HMaterID,HUnitID,HBomID,HPlanBeginDate,HPlanEndDate,HBillStatus |
|---|
| | | ,HOWNERID,HOWNERTYPEID) |
|---|
| | | ,HOWNERID,HOWNERTYPEID,HComboXSLX) |
|---|
| | | values('3710'," + mainList[0].HInterID + ",'" + mainList[0].HBillNo + "','" + mainList[0].HDate + "'," + mainList[0].HPRDORGID + |
|---|
| | | "," + DateTime.Now.Year + "," + DateTime.Now.Month + ",'" + mainList[0].HRemark + "','" + mainList[0].HMaker + "',getdate(),'" + mainList[0].HMaker + "',getdate()" + |
|---|
| | | ",'" + mainList[0].HSeOrderBillNo + "'," + mainList[0].HSeOrderInterID + "," + mainList[0].HSeOrderEntryID + "," + mainList[0].HEmpID + "," + mainList[0].HCusID + |
|---|
| | | "," + mainList[0].HCenterID + "," + mainList[0].HPlanQty + ",0,0,0,0,'','',2" + |
|---|
| | | ","+ mainList[0].HOWNERID + ",'"+ mainList[0].HOWNERTYPEID + "') "); |
|---|
| | | ","+ mainList[0].HOWNERID + ",'"+ mainList[0].HOWNERTYPEID + "','" + mainList[0].HComboXSLX + "') "); |
|---|
| | | //淇濆瓨涓昏〃 |
|---|
| | | foreach (var oSub in subList) |
|---|
| | | { |
|---|
