From 3f364634b79a0f97a550c54f67313dfc0cfd4cb5 Mon Sep 17 00:00:00 2001 From: Rodney Chen <rodney.chen@hotmail.com> Date: 星期三, 27 十一月 2024 22:16:01 +0800 Subject: [PATCH] 一大波签入来了 --- Tiger.Business.MES/Transaction/CollectNode.cs | 267 +++++++++++++++++++++++++++++++++++++++++++--------- 1 files changed, 219 insertions(+), 48 deletions(-) diff --git a/Tiger.Business.MES/Transaction/CollectNode.cs b/Tiger.Business.MES/Transaction/CollectNode.cs index b8bf30e..880b248 100644 --- a/Tiger.Business.MES/Transaction/CollectNode.cs +++ b/Tiger.Business.MES/Transaction/CollectNode.cs @@ -43,56 +43,69 @@ //宸ユ鍒楄〃涓虹┖鎴栬�呭伐搴忚妭鐐瑰伐姝ユ湁鏈畬鎴愭椂锛屼紭鍏堝畬鎴愬伐搴忚妭鐐瑰伐姝� if (Steps.IsNullOrEmpty() || !IsFinishNodeSteps) { + var wosns = MainDB.Queryable<BIZ_MES_WO_BATCH, BIZ_MES_WO_SN>((q, s) => new JoinQueryInfos(JoinType.Inner, q.ORDER_NO == s.WORK_ORDER && q.BATCH_NO == s.BATCH_NO)) + .ByAuth(input.AuthOption)//.Where((q, s) => s.STATUS < BIZ_MES_WO_SN.STATUSs.Finished.GetValue()) + .Where((q, s) => s.SN == input.SN || s.FLOW_SN == input.SN || s.TRAY_SN == input.SN).Select((q, s) => new { Batch = q, SN = s }).ToList(); //鍏堝垽鏂綋鍓嶅伐鍗曚笉涓虹┖涓斿綋鍓嶅矖浣嶅湪褰撳墠宸ュ崟鏄笉鏄绔欙紝濡傛灉鏄垯涓嶅厑璁稿彉鏇村綋鍓嶅伐鍗曪紝灏濊瘯鎶婃潯鐮佺粦瀹氬埌褰撳墠宸ュ崟 if (!CurBatch.IsNullOrEmpty() && CurBatch.IsFirstNode(PostCode)) { //鏇存柊CurBatch CurBatch?.Update(); - //鎻愪氦鏁版嵁 - action = NodeSubmit(action, input); - //鏇存柊宸ュ簭淇℃伅 - if (!action.IsSuccessed) + + var wosn = wosns.FirstOrDefault(q => q.Batch.ORDER_NO == CurBatch.WO.ORDER_NO && (q.SN.STATUS == BIZ_MES_WO_SN.STATUSs.Finished.GetValue() || q.SN.STATUS == BIZ_MES_WO_SN.STATUSs.Scrap.GetValue())); + if (!wosn.IsNullOrEmpty()) { - var info = WoContext.GetSnOperInfo(input.SN).Data; - info.InputQty = CurOperInfo(input.Locale).InputQty; - action.Data.OperInfo = info; + action.Data.ShortMsg = new($"浜у搧{wosn.SN.STATUS.GetEnumDesc<BIZ_MES_WO_SN.STATUSs>()}", ShortMessage.Types.Error); + action.Data.OperInfo = new(); + action.IsSuccessed = false; + //action.LocaleMsg = new($"杩涚珯鎵弿閿欒锛屾潯鐮乕{0}]{1}", input.SN); + action.LocaleMsg = new("MES.Transaction.CollectNode.Submit.SnStatusError", input.SN, wosn.SN.STATUS.GetEnumDesc<BIZ_MES_WO_SN.STATUSs>()); } - else if (!IsFinishAllSteps) + else { - action.Data.OperInfo = SetOperNodeInfo(CurOperInfo(input.Locale)); + //鎻愪氦鏁版嵁 + action = NodeSubmit(action, input); + //鏇存柊宸ュ簭淇℃伅 + if (!action.IsSuccessed) + { + var info = WoContext.GetSnOperInfo(input.SN).Data; + info.InputQty = CurOperInfo(input.Locale).InputQty; + action.Data.OperInfo = info; + } + else if (Steps.Any() && !IsFinishAllSteps) + { + action.Data.OperInfo = SetOperNodeInfo(CurOperInfo(input.Locale)); + } } } //褰撳墠宀椾綅鍦ㄥ綋鍓嶅伐鍗曚笉鏄绔欙紝鍒欐煡鎵炬潯鐮佸凡缁戝畾鐨勫伐鍗曞綋浣滃綋鍓嶅伐鍗� else { - var wosns = Biz.Db.Queryable<BIZ_MES_WO_BATCH, BIZ_MES_WO_SN>((q, s) => new JoinQueryInfos(JoinType.Inner, q.ORDER_NO == s.WORK_ORDER)) - .ByAuth(input.AuthOption).Where((q, s) => s.STATUS < BIZ_MES_WO_SN.STATUSs.Finished.GetValue()) - .Where((q, s) => s.SN == input.SN || s.FLOW_SN == input.SN || s.TRAY_SN == input.SN).Select((q, s) => new { Batch = q, SN = s }).ToList(); - //鏌ユ壘鍒版潯鐮佸凡缁戝畾鐨勫伐鍗� - if (!wosns.IsNullOrEmpty()) + if (wosns.Any(q => q.SN.STATUS < BIZ_MES_WO_SN.STATUSs.Finished.GetValue())) { - if (wosns.First().Batch.ACT_LINE != CurLine.LINE_CODE) + var curSNs = wosns.Where(q => q.SN.STATUS < BIZ_MES_WO_SN.STATUSs.Finished.GetValue()); + if (curSNs.First().Batch.ACT_LINE != CurLine.LINE_CODE) { action.Data.ShortMsg = new("浜х嚎閿欒", ShortMessage.Types.Error); action.Data.OperInfo = new(); action.IsSuccessed = false; //action.LocaleMsg = new($"鏉$爜[{0}]宸插湪浜х嚎[{1}]鎶曞叆鐢熶骇锛岃鍦ㄦ纭矖浣嶆壂鎻�"); - action.LocaleMsg = new("MES.Transaction.PackingNode.Submit.NotCorrectLine", input.SN, wosns.First().Batch.ACT_LINE); + action.LocaleMsg = new("MES.Transaction.PackingNode.Submit.NotCorrectLine", input.SN, curSNs.First().Batch.ACT_LINE); } else { - if (CurBatch?.Batch?.ORDER_NO != wosns.First().Batch.ORDER_NO) + if (CurBatch?.Batch?.ORDER_NO != curSNs.First().Batch.ORDER_NO) { //鏉$爜宸茬粦瀹氱殑宸ュ崟涓嶇瓑浜庡綋鍓嶅伐鍗曞垯閲嶆柊閫夋嫨宸ュ崟 - var result = await SelectOrder(new() { AuthOption = input.AuthOption, OrderNo = wosns.First().Batch.ORDER_NO }); + var result = await SelectOrder(new() { AuthOption = input.AuthOption, OrderNo = curSNs.First().Batch.ORDER_NO }, curSNs.First().Batch.BATCH_NO); if (!result.IsSuccessed) { action.Data.ShortMsg = new("宸ュ崟寮傚父", ShortMessage.Types.Error); action.Data.OperInfo = new(); action.IsSuccessed = result.IsSuccessed; action.LocaleMsg = result.LocaleMsg; - return action; + return SetOutPutMqttMsg(action, input.Locale); } } //鏇存柊CurBatch @@ -114,23 +127,36 @@ //鏌ユ壘涓嶅埌鏉$爜宸茬粦瀹氱殑宸ュ崟 else { - //娌℃湁褰撳墠宸ュ崟锛屽垯鍏堥�夋嫨宸ュ崟鍚庡啀鎵弿鏉$爜 - if (CurBatch.IsNullOrEmpty()) + var lastSn = wosns.OrderByDescending(q => q.SN.UPDATE_TIME).FirstOrDefault(); + if (!lastSn.IsNullOrEmpty()) { - action.Data.ShortMsg = new("鏈�夋嫨宸ュ崟", ShortMessage.Types.Error); + action.Data.ShortMsg = new($"浜у搧{lastSn.SN.STATUS.GetEnumDesc<BIZ_MES_WO_SN.STATUSs>()}", ShortMessage.Types.Error); action.Data.OperInfo = new(); action.IsSuccessed = false; - //action.LocaleMsg = new($"鏈�夋嫨宸ュ崟锛岃鍏堥�夋嫨瑕佺敓浜х殑宸ュ崟"); - action.LocaleMsg = new("MES.Transaction.CollectNode.Submit.NotSelectOrderException"); + //action.LocaleMsg = new($"杩涚珯鎵弿閿欒锛屾潯鐮乕{0}]{1}", input.SN); + action.LocaleMsg = new("MES.Transaction.CollectNode.Submit.SnStatusError", input.SN, lastSn.SN.STATUS.GetEnumDesc<BIZ_MES_WO_SN.STATUSs>()); } - //鏈夊綋鍓嶅伐鍗曚笖涓嶆槸鎶曞叆锛屽垯鎻愮ず鏉$爜鏈姇鍏ョ敓浜э紝璇峰厛鍘婚绔欐壂鎻� else { - action.Data.ShortMsg = new("鏈姇鍏ョ敓浜�", ShortMessage.Types.Error); - action.Data.OperInfo = new(); - action.IsSuccessed = false; - //action.LocaleMsg = new($"鏉$爜[{input.SN}]灏氭湭鎶曞叆鐢熶骇锛岃鍏堝幓棣栫珯鎵弿", input.SN); - action.LocaleMsg = new("MES.Transaction.CollectNode.Submit.NotInputException", input.SN); + //娌℃湁褰撳墠宸ュ崟锛屽垯鍏堥�夋嫨宸ュ崟鍚庡啀鎵弿鏉$爜 + if (CurBatch.IsNullOrEmpty()) + { + action.Data.ShortMsg = new("鏈�夋嫨宸ュ崟", ShortMessage.Types.Error); + action.Data.OperInfo = new(); + action.IsSuccessed = false; + //action.LocaleMsg = new($"鏈�夋嫨宸ュ崟锛岃鍏堥�夋嫨瑕佺敓浜х殑宸ュ崟"); + action.LocaleMsg = new("MES.Transaction.CollectNode.Submit.NotSelectOrderException"); + } + //鏈夊綋鍓嶅伐鍗曚笖涓嶆槸鎶曞叆锛屽垯鎻愮ず鏉$爜鏈姇鍏ョ敓浜э紝璇峰厛鍘婚绔欐壂鎻� + else + { + + action.Data.ShortMsg = new("鏈姇鍏ョ敓浜�", ShortMessage.Types.Error); + action.Data.OperInfo = new(); + action.IsSuccessed = false; + //action.LocaleMsg = new($"鏉$爜[{input.SN}]灏氭湭鎶曞叆鐢熶骇锛岃鍏堝幓棣栫珯鎵弿", input.SN); + action.LocaleMsg = new("MES.Transaction.CollectNode.Submit.NotInputException", input.SN); + } } } } @@ -198,7 +224,7 @@ //action.CatchExceptionWithLog(ex, $"閲囬泦宸ュ簭锛氭彁浜ゆ搷浣滄暟鎹紓甯�"); action.CatchExceptionWithLog(ex, Biz.L("MES.Transaction.CollectNode.SubmitException")); } - return action; + return SetOutPutMqttMsg(action, input.Locale); } /// <summary> @@ -210,21 +236,33 @@ public ApiAction<SubmitOutput> NodeSubmit(ApiAction<SubmitOutput> action, SubmitInput input) { var curNode = CurBatch.GetNode(PostCode); + try { + //宸ュ簭鑺傜偣閫昏緫澧炲姞濡傛灉鏍瑰熀褰撳墠宀椾綅鎵句笉鍒板搴斿伐搴忕殑鏃跺�欒鎶ラ敊 + if (curNode.IsNullOrEmpty()) + { + action.Data.ShortMsg = new("鏈煡宸ュ簭", ShortMessage.Types.Error); + action.IsSuccessed = false; + //action.LocaleMsg = new($"宀椾綅[{0}]鍦ㄥ伐鍗昜{1}]宸ヨ壓璺嚎涓壘涓嶅埌瀵瑰簲鐨勫伐搴忥紝璇锋鏌ュ伐鍗曞伐鑹鸿矾绾夸腑宸ュ簭涓庡矖浣嶇殑缁戝畾鍏崇郴鏄惁姝g‘"); + action.LocaleMsg = new("MES.Transaction.CollectNode.NodeSubmit.OperateNodeError", PostCode, CurBatch.WO.ORDER_NO); + return action; + } + var curNodeSetting = CurBatch.GetNodeSetting(curNode); + //褰撳伐姝ュ垪琛ㄤ负绌猴紝鍒欐墽琛屽綋鍓嶅伐搴忕殑蹇呰閫昏緫褰撲綔绗竴涓伐搴忚妭鐐癸紝瀹屾垚鍚庢寜闇�姹傚垱寤哄悗缁殑宸ユ鍒楄〃 if (Steps.IsNullOrEmpty()) { BeginAt = DateTime.Now; //鍒ゆ柇宸ュ崟瀹炴椂鐘舵�佸垽鏂槸鍚﹀彲浠ョ敓浜� - var woStatus = CurBatch.CheckCanProduce(curNode); + var woStatus = CurBatch.CheckCanProduce(curNode, curNodeSetting); if (!woStatus.IsSuccessed) { woStatus.Data.ShortMsg = new("宸ュ崟寮傚父", ShortMessage.Types.Error); return woStatus; } - var wipSNs = Biz.Db.Queryable<MES_WIP_DATA>().IncludesAllFirstLayer().Where(q => q.SN == input.SN || q.FLOW_SN == input.SN || q.TRAY_SN == input.SN).ToList(); + var wipSNs = MainDB.Queryable<MES_WIP_DATA>().IncludesAllFirstLayer().Where(q => q.SN == input.SN || q.FLOW_SN == input.SN || q.TRAY_SN == input.SN).Where(q => q.FINISHED_FLAG != "Y").ToList(); if (wipSNs.IsNullOrEmpty()) { var wipSN = new MES_WIP_DATA() @@ -242,6 +280,7 @@ HOLD_FLAG = "N", REWORK_FLAG = CurBatch.WO.ORDER_TYPE == BIZ_MES_WO.ORDER_TYPEs.Rework.GetValue() ? "Y" : "N", FINISHED_FLAG = "N", + UNBIND_FLAG = "N", INV_FLAG = "N", DFT_FLAG = "N", DFT_COUNT = 0, @@ -296,7 +335,7 @@ } //鏇存柊宸ュ崟鏉$爜鏄庣粏淇℃伅 - var woSNs = CurBatch.WoSNs.Where(q => wipSNs.Any(w => q.SN == w.SN)).ToList(); + var woSNs = CurBatch.WoSNs.Where(q => wipSNs.Any(w => q.WIP_ID == w.ID)).ToList(); foreach (var woSN in woSNs) { woSN.AUTH_ORG = CurBatch.WO.AUTH_ORG; @@ -319,6 +358,7 @@ wipSN.POST_CODE = CurPosition.POST_CODE; wipSN.OPER_CODE = curNode.OPER_CODE; wipSN.SEGMENT = curNode.SEGMENT; + wipSN.UNBIND_FLAG = "N"; wipSN.OPERATION_TIME = DateTime.Now; var curShiftPeriod = GetShiftPeriodForNow(); if (!curShiftPeriod.IsNullOrEmpty()) @@ -328,19 +368,19 @@ wipSN.PRD_CODE = curShiftPeriod.Period.PRD_CODE; } //濡傛灉鏄姇鍏ョ珯 - if (curNode.IS_INPUT == "Y") + if (curNodeSetting.IS_INPUT == "Y") { - var woSN = woSNs.First(q => q.SN == wipSN.SN); + var woSN = woSNs.First(q => q.WIP_ID == wipSN.ID); woSN.STATUS = BIZ_MES_WO_SN.STATUSs.Inputed.GetValue(); wipSN.STATUS = MES_WIP_DATA.STATUSs.Input.GetValue(); wipSN.INLINE_DATE = DateTime.Now; } //濡傛灉鏄骇鍑虹珯 - if (curNode.IS_OUTPUT == "Y") + if (curNodeSetting.IS_OUTPUT == "Y") { - var woSN = woSNs.First(q => q.SN == wipSN.SN); + var woSN = woSNs.First(q => q.WIP_ID == wipSN.ID); woSN.STATUS = BIZ_MES_WO_SN.STATUSs.Finished.GetValue(); - wipSN.STATUS = MES_WIP_DATA.STATUSs.Finished.GetValue(); + wipSN.STATUS = MES_WIP_DATA.STATUSs.Output.GetValue(); wipSN.OUTLINE_DATE = DateTime.Now; } //濡傛灉鏈夋彁浜や笉鑹� @@ -386,8 +426,16 @@ OBA_BATCH = wipSN.OBA_BATCH, LOCK_BATCH = wipSN.LOCK_BATCH, }; + wipSN.Defects.Add(defect); CurDefects.Add(defect); } + } + + //浜у搧琚垽鏂笉鑹悗涓嬬嚎锛屽苟浠庡伐鍗曚腑绉婚櫎姝e湪鐢熶骇鐨勬潯鐮� + if (CurDefects.Any() && curNodeSetting.IF_DFT_OFFLINE == "Y") + { + woStatus.Data.ShortMsg = new("浜у搧涓嬬嚎", ShortMessage.Types.Error); + return OfflineIfDefect(action, wipSNs, input.Locale); } //宸ュ崟寮�宸� @@ -398,7 +446,7 @@ CurWipSNHiss.Clear(); foreach (var wipSN in wipSNs) { - var his = new MES_WIP_HIS(wipSN, $"宸ュ崟[{wipSN.WORK_ORDER}]鏉$爜[{wipSN.SN}]鍦ㄥ矖浣峓{wipSN.POST_CODE}]杩囩珯宸ュ簭[{wipSN.NODE_NAME}]鎴愬姛"); + var his = new MES_WIP_HIS(wipSN, $"宸ュ崟[{wipSN.WORK_ORDER}]鏉$爜[{wipSN.SN}]鍦ㄥ矖浣峓{wipSN.POST_CODE}]杩囩珯宸ュ簭[{wipSN.NODE_NAME}]鎴愬姛锛圱ransId锛歿TransID}锛�"); wipSN.History.Add(his); CurWipSNHiss.Add(his); } @@ -408,7 +456,7 @@ var _wipSns = wipSNs.Clone(); var _wipHiss = CurWipSNHiss.Clone(); var _defect = CurDefects.Clone(); - var _curNode = curNode.Clone(); + var _curNodeSetting = curNodeSetting.Clone(); var _Batch = CurBatch.Batch.Clone(); //鍒濆鍖栧伐姝ュ垪琛� @@ -433,13 +481,13 @@ db.Storageable(_defect, UserCode).ExecuteCommand(); } //濡傛灉鏄姇鍏ョ珯 - if (_curNode.IS_INPUT == "Y") + if (_curNodeSetting.IS_INPUT == "Y") { db.Updateable<BIZ_MES_WO>().SetColumns(q => q.INPUT_QTY == q.INPUT_QTY + _woSns.Count).Where(q => q.ORDER_NO == _Batch.ORDER_NO).ExecuteCommand(); db.Updateable<BIZ_MES_WO_BATCH>().SetColumns(q => q.INPUT_QTY == q.INPUT_QTY + _woSns.Count).Where(q => q.BATCH_NO == _Batch.BATCH_NO).ExecuteCommand(); } //濡傛灉鏄骇鍑虹珯 - if (_curNode.IS_OUTPUT == "Y") + if (_curNodeSetting.IS_OUTPUT == "Y") { db.Updateable<BIZ_MES_WO>().SetColumns(q => q.OUTPUT_QTY == q.OUTPUT_QTY + _woSns.Count).Where(q => q.ORDER_NO == _Batch.ORDER_NO).ExecuteCommand(); db.Updateable<BIZ_MES_WO_BATCH>().SetColumns(q => q.OUTPUT_QTY == q.OUTPUT_QTY + _woSns.Count).Where(q => q.BATCH_NO == _Batch.BATCH_NO).ExecuteCommand(); @@ -544,16 +592,139 @@ /// <returns></returns> public ApiAction<SubmitOutput> DoIfFinishAllSteps(ApiAction<SubmitOutput> action, string locale) { + var operInfo = SetOperNodeInfo(CurOperInfo(locale)); + Action endAction = null; + + //濡傛灉褰撳墠鏉$爜宸茬粡璧板埌娴佺▼缁堢偣鍒欒褰曟潯鐮佸畬宸� + if (operInfo.IsReachedEndNode) + { + //鏇存柊宸ュ崟鏉$爜鏄庣粏淇℃伅 + var woSNs = CurBatch.WoSNs.Where(q => CurWipSNs.Any(w => q.WIP_ID == w.ID)).ToList(); + foreach (var woSN in woSNs) + { + woSN.STATUS = BIZ_MES_WO_SN.STATUSs.Finished.GetValue(); + } + var curNode = CurBatch.Nodes.First(q => q.OPER_CODE == "EndNode"); + //鏉$爜瀹屽伐 + foreach (var wipSN in CurWipSNs) + { + wipSN.FINISHED_FLAG = "Y"; + wipSN.NODE_ID = curNode.ID; + wipSN.NODE_NAME = curNode.NODE_NAME; + wipSN.OPER_CODE = curNode.OPER_CODE; + wipSN.SEGMENT = curNode.SEGMENT; + } + + var wipHiss = new List<MES_WIP_HIS>(); + foreach (var wipSN in CurWipSNs) + { + var his = new MES_WIP_HIS(wipSN, $"宸ュ崟[{wipSN.WORK_ORDER}]鏉$爜[{wipSN.SN}]鍦ㄥ矖浣峓{wipSN.POST_CODE}]杩囩珯宸ュ簭[{wipSN.NODE_NAME}]鎴愬姛锛圱ransId锛歿TransID}锛�"); + wipSN.History.Add(his); + wipHiss.Add(his); + } + + //鍒涘缓鍙橀噺鍏嬮殕瀵硅薄鐢ㄤ簬浼犲叆DBSubmitAction涓繚瀛樺綋鍓嶉渶瑕佹殏瀛樼殑鏁版嵁鍊� + var _woSns = woSNs.Clone(); + var _wipSns = CurWipSNs.Clone(); + var _wipHiss = wipHiss.Clone(); + //淇濆瓨鏁版嵁 + endAction = () => + { + //浣跨敤缁熶竴鐨勪簨鍔B瀵硅薄 + var db = GetCommitDB(); + //鏁版嵁淇濆瓨閫昏緫 + db.Storageable(_woSns, UserCode).ExecuteCommand(); + db.Storageable(_wipSns, UserCode).ExecuteCommand(); + db.Storageable(_wipHiss, UserCode).ExecuteCommand(); + }; + } + //淇濆瓨鏁版嵁搴� - SaveStepsCommitActionToDB(); + SaveStepsCommitActionToDB(endAction); //淇濆瓨鎴愬姛锛岃繑鍥炶繃绔欐秷鎭� - CurOperInfo(locale).InputQty += CurWipSNs.Count; - action.Data.OperInfo = SetOperNodeInfo(CurOperInfo(locale)); - action.Data.ShortMsg = new("杩囩珯鎴愬姛", ShortMessage.Types.Success); + operInfo.InputQty += CurWipSNs.Count; + action.Data.OperInfo = operInfo; + action.Data.ShortMsg = new(CurWipSNs.Any(q => q.DFT_FLAG == "Y") ? "涓嶈壇杩囩珯" : "鑹搧杩囩珯", ShortMessage.Types.Success); //action.LocaleMsg = new($"宸ュ崟[{CurWipSN.WORK_ORDER}]鐨勬潯鐮乕{CurWipSN.SN}]鍦ㄥ矖浣峓{CurWipSN.POST_CODE}]宸ュ簭[{CurWipSN.NODE_NAME}]杩囩珯鎴愬姛锛岀姸鎬乕{CurWipSN.STATUS.GetEnumDesc<MES_WIP_DATA.STATUSs>()}]"); action.LocaleMsg = new("MES.Transaction.CollectNode.ScanSn.PassSuccess", CurWipSNs.First().WORK_ORDER, CurSN, CurWipSNs.First().POST_CODE, CurWipSNs.First().NODE_NAME,CurWipSNs.First().STATUS.GetEnumDesc<MES_WIP_DATA.STATUSs>()); - + + + //濡傛灉褰撳墠鏉$爜宸茬粡瀹屽伐锛屾鏌ュ綋鍓嶅伐鍗曟壒娆″拰宸ュ崟鏄惁瀹屽伐 + if (action.Data.OperInfo.IsReachedEndNode) + { + CurBatch.CheckIsComplete(UserCode); + } + + //閲嶇疆宸ュ簭 + ResetNode(); + return action; + } + + /// <summary> + /// 浜у搧琚垽鏂笉鑹悗涓嬬嚎 + /// </summary> + /// <param name="action"></param> + /// <returns></returns> + public ApiAction<SubmitOutput> OfflineIfDefect(ApiAction<SubmitOutput> action, List<MES_WIP_DATA> wipSNs, string locale) + { + var operInfo = SetOperNodeInfo(CurOperInfo(locale)); + operInfo.CurNode = wipSNs.FirstOrDefault()?.NODE_NAME; + operInfo.NextNode = "涓嬬嚎閫�搴�"; + + //鏇存柊宸ュ崟鏉$爜鏄庣粏淇℃伅 + var woSNs = CurBatch.WoSNs.Where(q => wipSNs.Any(w => q.WIP_ID == w.ID)).ToList(); + foreach (var woSN in woSNs) + { + woSN.STATUS = BIZ_MES_WO_SN.STATUSs.Offline.GetValue(); + } + + //鏉$爜涓嬬嚎 + foreach (var wipSN in wipSNs) + { + wipSN.STATUS = MES_WIP_DATA.STATUSs.Offline.GetValue(); + wipSN.UNBIND_FLAG = "Y"; + } + + var wipHiss = new List<MES_WIP_HIS>(); + foreach (var wipSN in wipSNs) + { + var his = new MES_WIP_HIS(wipSN, $"宸ュ崟[{wipSN.WORK_ORDER}]鏉$爜[{wipSN.SN}]鍦ㄥ矖浣峓{wipSN.POST_CODE}]宸ュ簭[{wipSN.NODE_NAME}]鍥犱笉鑹痆{wipSN.Defects.FirstOrDefault()?.DFT_NAME}]涓嬬嚎锛圱ransId锛� {TransID} 锛�"); + wipSN.History.Add(his); + wipHiss.Add(his); + } + + //鍒涘缓鍙橀噺鍏嬮殕瀵硅薄鐢ㄤ簬浼犲叆DBSubmitAction涓繚瀛樺綋鍓嶉渶瑕佹殏瀛樼殑鏁版嵁鍊� + var _woSns = woSNs.Clone(); + var _wipSns = wipSNs.Clone(); + var _wipHiss = wipHiss.Clone(); + var _defect = CurDefects.Clone(); + //浣跨敤缁熶竴鐨勪簨鍔B瀵硅薄 + var db = GetCommitDB(); + //淇濆瓨鏁版嵁搴� + var dbTran = db.UseTran(() => + { + //鏁版嵁淇濆瓨閫昏緫 + db.Storageable(_woSns, UserCode).ExecuteCommand(); + db.Storageable(_wipSns, UserCode).ExecuteCommand(); + db.Storageable(_wipHiss, UserCode).ExecuteCommand(); + db.Storageable(_defect, UserCode).ExecuteCommand(); + }); + if (!dbTran.IsSuccess) + { + //鎶涘嚭寮傚父 + throw dbTran.ErrorException; + } + + //浠庡伐鍗曚腑绉婚櫎姝e湪鐢熶骇鐨勬潯鐮� + CurBatch.RemoveWipSn(wipSNs, UserCode); + + //淇濆瓨鎴愬姛锛岃繑鍥炶繃绔欐秷鎭� + action.Data.OperInfo = operInfo; + action.Data.ShortMsg = new("涓嬬嚎閫�搴�", ShortMessage.Types.Warning); + //action.LocaleMsg = new($"宸ュ崟[0]鐨勬潯鐮乕1]鍦ㄥ矖浣峓2]宸ュ簭[3]鍥犱笉鑹痆4]涓嬬嚎锛岀姸鎬乕5]"); + action.LocaleMsg = new("MES.Transaction.TestNode.OfflineIfDefect", wipSNs.First().WORK_ORDER, CurSN, wipSNs.First().POST_CODE, wipSNs.First().NODE_NAME, wipSNs.First().Defects.FirstOrDefault()?.DFT_NAME, wipSNs.First().STATUS.GetEnumDesc<MES_WIP_DATA.STATUSs>()); + //閲嶇疆宸ュ簭 ResetNode(); return action; -- Gitblit v1.9.3