| | |
| | | try |
| | | { |
| | | DataSet Ds = oCn.RunProcReturn("Exec h_p_Sc_MESBeginWorkBill_AfterSaveCtrl " + HInterID.ToString() + "," + HICMOInterID.ToString() + "," + HICMOEntryID.ToString() + ",'" + HICMOBillNo + "'," + OperationType.ToString(), "h_p_Sc_MESBeginWorkBill_AfterSaveCtrl"); |
| | | LogService.Write("开工:2.6.1"); |
| | | |
| | | if (Ds == null || Ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | sReturn = "保存后判断失败!"; |
| | |
| | | } |
| | | else |
| | | { |
| | | LogService.Write("开工:2.6.2"+ Ds.Tables[0].Rows[0]["HBack"]); |
| | | if (DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HBack"]) == 1) |
| | | { |
| | | LogService.Write("开工:2.6.3"); |
| | | sReturn = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRemark"]); |
| | | LogService.Write("开工:2.6.4"); |
| | | return false; |
| | | } |
| | | } |
| | |
| | | { |
| | | try |
| | | { |
| | | LogService.Write("开工:2.2"); |
| | | DataSet ds; |
| | | //得到mainid |
| | | omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo); |
| | |
| | | { |
| | | return false; |
| | | } |
| | | |
| | | LogService.Write("开工:2.3"); |
| | | //主表 |
| | | oCn.RunProc("Insert Into Sc_MESBeginWorkBillMain " + |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HBillStatus,HDate,HMaker,HMakeDate" + |
| | |
| | | oCn.RunProc(subSql); |
| | | } |
| | | |
| | | |
| | | LogService.Write("开工:2.4"); |
| | | //再次验证 保存是否 合理 |
| | | ds = oCn.RunProcReturn("exec h_p_JIT_MESBeginWorkBill_SaveCtrl @HInterId=" + omodel.HInterID + "", "h_p_JIT_MESBeginWorkBill_SaveCtrl"); |
| | | if (ds == null || ds.Tables[0].Rows.Count <= 0) |
| | |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | |
| | | //保存后控制 |
| | | if (!AfterSave(omodel.HInterID, omodel.HICMOInterID, omodel.HICMOEntryID, omodel.HICMOBillNo, 1, ref sReturn)) |
| | | { |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | LogService.Write("开工:2.5"); |
| | | |
| | | //获取最近的上模单 把工单跟模具进行绑定 |
| | | ds = oCn.RunProcReturn(@"select HICMOInterID,HICMOEntryID,HSourceInterID,HSourceEntryID,HSourceID from Sc_ICMOBillStatus_Tmp where HInterID=" + omodel.HMainSourceInterID.ToString(), "Sc_ICMOBillStatus_Tmp"); |
| | |
| | | } |
| | | } |
| | | } |
| | | |
| | | LogService.Write("开工:2.6 " + omodel.HInterID + "," + omodel.HICMOInterID + ", " + omodel.HICMOEntryID + ", " + omodel.HICMOBillNo + ", 1"); |
| | | //保存后控制 |
| | | if (!AfterSave(omodel.HInterID, omodel.HICMOInterID, omodel.HICMOEntryID, omodel.HICMOBillNo, 1, ref sReturn)) |
| | | { |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | LogService.Write("开工:2.7"); |
| | | sReturn = omodel.HInterID.ToString(); |
| | | oCn.Commit(); |
| | | return true; |