| | |
| | | string HMaterNumber = mainList[0].HMaterNumber; |
| | | string HSupNumber = mainList[0].HSupNumber; |
| | | long HPrintQty = mainList[0].HPrintQty; |
| | | |
| | | string HMouldOWNER = mainList[0].HMouldOWNER; |
| | | string HSaveLife = mainList[0].HSaveLife; |
| | | |
| | | //主表 |
| | | oCN.RunProc("Insert Into Gy_MouldFileMain " + |
| | |
| | | ",HOutComDate,HOutComNo,HDeptID,HSupID,HSupNumber" + |
| | | ",HPrintQty,HMouldStatus,HWhID,HRoutingID" + |
| | | ",HBomID,HVersion,HSPGroupID,HSPID,HDesignLife" + |
| | | ",HUseLife,HLeaveLife,HProdQty,HProdWeight" + |
| | | ",HUseLife,HLeaveLife,HProdQty,HProdWeight,HMouldOWNER,HSaveLife" + |
| | | ") " + |
| | | " values('" + BillType + "','" + BillType + "'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" + |
| | | "," + HYear + "," + HPeriod + ",'" + HRemark + "','" + HMaker + "',getdate()" + |
| | |
| | | ",'" + HOutComDate + "','" + HOutComNo + "'," + HDeptID + "," + HSupID + ",'" + HSupNumber + "'" + |
| | | "," + HPrintQty + ",'" + HMouldStatus + "'," + HWHID + "," + HRoutingID + |
| | | "," + HBOMID + ",'" + HVersion + "'," + HSPGroupID + "," + HSPID + ",'" + HDesignLife + "'" + |
| | | ",'" + HUseLife + "','" + HLeaveLife + "','" + HProdQty + "','" + HProdWeight + "'" + |
| | | ",'" + HUseLife + "','" + HLeaveLife + "','" + HProdQty + "','" + HProdWeight + "','" + HMouldOWNER +"',"+ "','" + HSaveLife + "'," + |
| | | ") "); |
| | | |
| | | |
| | |
| | | string HMaterNumber = mainList[0].HMaterNumber; |
| | | string HSupNumber = mainList[0].HSupNumber; |
| | | long HPrintQty = mainList[0].HPrintQty; |
| | | |
| | | |
| | | string HMouldOWNER = mainList[0].HMouldOWNER; |
| | | string HSaveLife = mainList[0].HSaveLife; |
| | | |
| | | |
| | | |
| | |
| | | ",HSupNumber='" + HSupNumber + "'" + |
| | | ",HPrintQty=" + HPrintQty.ToString() + |
| | | ",HMouldStatus='" + HMouldStatus + "'" + |
| | | ",HSaveLife='"+ HSaveLife+"'"+ |
| | | ",HWhID=" + HWHID.ToString() + |
| | | ",HRoutingID=" + HRoutingID.ToString() + |
| | | ",HBomID=" + HBOMID.ToString() + |
| | |
| | | ",HUseLife=" + HUseLife.ToString() + |
| | | ",HLeaveLife=" + HLeaveLife.ToString() + |
| | | ",HProdQty=" + HProdQty.ToString() + |
| | | ",HMouldOWNER='"+ HMouldOWNER+"'"+ |
| | | ",HProdWeight=" + HProdWeight.ToString() + |
| | | " where HInterID=" + HInterID.ToString()); |
| | | |