| | |
|---|
| | | } |
|---|
| | | //========================================================= |
|---|
| | | |
|---|
| | | //获取最近的上模单 把工单跟模具进行绑定 |
|---|
| | | ds = oCn.RunProcReturn(@"select HICMOInterID,HICMOEntryID,HSourceInterID,HSourceEntryID,HSourceID from Sc_ICMOBillStatus_Tmp where HInterID=" + omodel.HMainSourceInterID.ToString(), "Sc_ICMOBillStatus_Tmp"); |
|---|
| | | |
|---|
| | | if (ds.Tables[0].Rows.Count > 0) |
|---|
| | | { |
|---|
| | | string HICMOInterID = ds.Tables[0].Rows[0]["HICMOInterID"].ToString(); |
|---|
| | | string HICMOEntryID = ds.Tables[0].Rows[0]["HICMOEntryID"].ToString(); |
|---|
| | | string HSourceInterID = ds.Tables[0].Rows[0]["HSourceInterID"].ToString(); |
|---|
| | | string HSourceEntryID = ds.Tables[0].Rows[0]["HSourceEntryID"].ToString(); |
|---|
| | | string HSourceID = ds.Tables[0].Rows[0]["HSourceID"].ToString(); |
|---|
| | | |
|---|
| | | ds = oCn.RunProcReturn(@"select HMouldID from Sc_MouldUpperBillMain a |
|---|
| | | inner join Sc_MouldUpperBillSub b on a.HInterID = b.HInterID where HICMOInterID=" + HICMOInterID + " and HICMOEntryID=" + HICMOEntryID + " and HProcExchInterID=" + HSourceInterID + " and HProcExchEntryID=" + HSourceEntryID + " and HSourceID=" + HSourceID + " order by HMakeDate desc", "Sc_MouldUpperBillMain"); |
|---|
| | | if (ds.Tables[0].Rows.Count > 0) |
|---|
| | | { |
|---|
| | | oCn.RunProc("update Sc_ICMOBillStatus_Tmp set HMouldID= " + ds.Tables[0].Rows[0]["HMouldID"].ToString() + " where HInterID=" + omodel.HMainSourceInterID.ToString()); |
|---|
| | | } |
|---|
| | | |
|---|
| | | } |
|---|
| | | |
|---|
| | | sReturn = omodel.HInterID.ToString(); |
|---|
| | | oCn.Commit(); |
|---|
| | | return true; |
|---|
