| | |
| | | int HNowSupTypeID = mainList[0].HNowSupTypeID; |
| | | int HMadeSupID = mainList[0].HMadeSupID; |
| | | string HMouldClass = mainList[0].HMouldClass; |
| | | |
| | | int HNowWHID = mainList[0].HNowWHID; |
| | | int HNowSPID = mainList[0].HNowSPID; |
| | | |
| | | //主表 |
| | | oCN.RunProc("Insert Into Gy_MouldFileMain " + |
| | |
| | | ",HPrintQty,HMouldStatus,HWhID,HRoutingID,HCaveQty" + |
| | | ",HBomID,HVersion,HSPGroupID,HSPID,HDesignLife,HNowSupID,HNowSupTypeID" + |
| | | ",HUseLife,HLeaveLife,HProdQty,HProdWeight,HMouldOWNER,HSaveLife,HMouldDotCheckRuleInterID,HMouldMaintainRuleInterID,HBarCode,HMadeSupID" + |
| | | ",HMouldClass) " + |
| | | ",HMouldClass,HNowWHID,HNowSPID) " + |
| | | " values('" + BillType + "','" + BillType + "'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" + |
| | | "," + HYear + "," + HPeriod + ",'" + HRemark + "','" + HMaker + "',getdate()" + |
| | | ",'" + HMouldNo + "','" + HName + "','" + HModel + "','" + HModel2 + "','" + HDiameter + "'" + |
| | |
| | | "," + HPrintQty + ",'" + HMouldStatus + "'," + HWHID + "," + HRoutingID + "," + HCaveQty + |
| | | "," + HBOMID + ",'" + HVersion + "'," + HSPGroupID + "," + HSPID + ",'" + HDesignLife + "','" + HNowSupID + "','" + HNowSupTypeID + "'" + |
| | | ",'" + HUseLife + "','" + HLeaveLife + "','" + HProdQty + "','" + HProdWeight + "','" + HMouldOWNER + "','" + HSaveLife + "','" + HMouldDotCheckRuleInterID + "','" + HMouldMaintainRuleInterID + "','" + HBarCode + "'," + HMadeSupID + |
| | | ",'"+ HMouldClass + "') "); |
| | | ",'"+ HMouldClass + "'," + HNowWHID + "," + HNowSPID + ") "); |
| | | |
| | | |
| | | //子表 |
| | |
| | | int HNowSupTypeID = mainList[0].HNowSupTypeID; |
| | | int HMadeSupID = mainList[0].HMadeSupID; |
| | | string HMouldClass = mainList[0].HMouldClass; |
| | | int HNowWHID = mainList[0].HNowWHID; |
| | | int HNowSPID = mainList[0].HNowSPID; |
| | | |
| | | //若MAINDI重复则重新获取 |
| | | oCN.BeginTran(); |
| | |
| | | ",HProdWeight=" + HProdWeight.ToString() + |
| | | ",HBarCode='" + HBarCode.ToString() + "'" + |
| | | ",HMadeSupID=" + HMadeSupID + |
| | | ",HNowWHID=" + HNowWHID + |
| | | ",HNowSPID=" + HNowSPID + |
| | | " where HInterID=" + HInterID.ToString()); |
| | | |
| | | //修改子项目代码 |
| | |
| | | { |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_MouldFileList where hmainid=" + HInterID, "h_v_Gy_MouldFileList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_MouldFile_Edit where hmainid=" + HInterID, "h_v_Gy_MouldFile_Edit"); |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |