| | |
| | | int HCaveQty = mainList[0].HCaveQty; |
| | | int HMouldDotCheckRuleInterID= mainList[0].HMouldDotCheckRuleInterID; |
| | | int HMouldMaintainRuleInterID= mainList[0].HMouldMaintainRuleInterID; |
| | | int HNowSupID = mainList[0].HNowSupID; |
| | | int HNowSupTypeID = mainList[0].HNowSupTypeID; |
| | | |
| | | |
| | | |
| | |
| | | ",HMaterID,HMaterNumber,HMouldType,HUnitID" + |
| | | ",HOutComDate,HOutComNo,HDeptID,HSupID,HSupNumber" + |
| | | ",HPrintQty,HMouldStatus,HWhID,HRoutingID,HCaveQty" + |
| | | ",HBomID,HVersion,HSPGroupID,HSPID,HDesignLife" + |
| | | ",HBomID,HVersion,HSPGroupID,HSPID,HDesignLife,HNowSupID,HNowSupTypeID" + |
| | | ",HUseLife,HLeaveLife,HProdQty,HProdWeight,HMouldOWNER,HSaveLife,HMouldDotCheckRuleInterID,HMouldMaintainRuleInterID" + |
| | | ") " + |
| | | " values('" + BillType + "','" + BillType + "'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" + |
| | |
| | | "," + HMaterID + ",'" + HMaterNumber + "'," + HMouleTypeID + "," + HUnitID + |
| | | ",'" + HOutComDate + "','" + HOutComNo + "'," + HDeptID + "," + HSupID + ",'" + HSupNumber + "'" + |
| | | "," + HPrintQty + ",'" + HMouldStatus + "'," + HWHID + "," + HRoutingID +","+ HCaveQty+ |
| | | "," + HBOMID + ",'" + HVersion + "'," + HSPGroupID + "," + HSPID + ",'" + HDesignLife + "'" + |
| | | "," + HBOMID + ",'" + HVersion + "'," + HSPGroupID + "," + HSPID + ",'" + HDesignLife + "','" + HNowSupID+"','"+ HNowSupTypeID+"'"+ |
| | | ",'" + HUseLife + "','" + HLeaveLife + "','" + HProdQty + "','" + HProdWeight + "','" + HMouldOWNER + "','" + HSaveLife + "','" + HMouldDotCheckRuleInterID+"','"+ HMouldMaintainRuleInterID+"'"+ |
| | | ") "); |
| | | |
| | |
| | | int HCaveQty = mainList[0].HCaveQty; |
| | | int HMouldDotCheckRuleInterID = mainList[0].HMouldDotCheckRuleInterID; |
| | | int HMouldMaintainRuleInterID = mainList[0].HMouldMaintainRuleInterID; |
| | | |
| | | int HNowSupID = mainList[0].HNowSupID; |
| | | int HNowSupTypeID = mainList[0].HNowSupTypeID; |
| | | |
| | | //若MAINDI重复则重新获取 |
| | | oCN.BeginTran(); |
| | |
| | | ",HMouldDotCheckRuleInterID="+ HMouldDotCheckRuleInterID.ToString()+ |
| | | ",HMouldMaintainRuleInterID=" + HMouldMaintainRuleInterID.ToString() + |
| | | ",HMouldOWNER='" + HMouldOWNER + "'" + |
| | | ",HNowSupID="+HNowSupID.ToString()+ |
| | | ",HNowSupTypeID="+HNowSupTypeID.ToString()+ |
| | | ",HProdWeight=" + HProdWeight.ToString() + |
| | | " where HInterID=" + HInterID.ToString()); |
| | | |