智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | show whitespace
chenhaozhe
15 小时以前 e9a84a2ca945afa4693306045bc244973ebe9835 
 WebAPI/Controllers/LMESController.cs


@@ -872,6 +872,14 @@


                    {


                        continue;


                    }


                    //更新流转卡子表生产资源


                    oCN.RunProc("update Sc_ProcessExchangeBillSub set HSourceID=" + hSourceID + " where HInterID=" + hSourceInterID + " and HEntryID=" + hSourceEntryID);


                    // 插入生产状态临时表


                    string SQL = $"exec h_p_Sc_ICMOBillStatus_Tmp_PGPL {hSourceInterID},{hSourceEntryID},{hSourceID},{hMoldID}";


                    oCN.RunProc(SQL);


                    //插入工序流转卡派工单


                    string SQL1 = $"exec h_p_Sc_ProcExchSendWorkBill_PG {hSourceInterID},{hSourceEntryID},{hSourceID},{hMoldID}";


                    oCN.RunProc(SQL1);


                    string sReturn = "";


                    if (oSystemParameter.ShowBill(ref sReturn) == true)


                    {


@@ -884,13 +892,7 @@


                            ds2 = oCN.RunProcReturn("exec h_p_OA_WorkLinkBill_Create " + hSourceInterID + "," + 3772, "h_p_OA_WorkLinkBill_Create");


                         }


                    }


                    oCN.RunProc("update Sc_ProcessExchangeBillSub set HSourceID=" + hSourceID + " where HInterID=" + hSourceInterID + " and HEntryID=" + hSourceEntryID);


                    // 插入生产状态临时表


                    string SQL = $"exec h_p_Sc_ICMOBillStatus_Tmp_PGPL {hSourceInterID},{hSourceEntryID},{hSourceID},{hMoldID}";


                    oCN.RunProc(SQL);


                    //插入工序流转卡派工单


                    string SQL1 = $"exec h_p_Sc_ProcExchSendWorkBill_PG {hSourceInterID},{hSourceEntryID},{hSourceID},{hMoldID}";


                    oCN.RunProc(SQL1);


                  




                    // 7. 提交事务


                    oCN.Commit();