From 35afcfe07fef52f74a2079fdb5977a87f88ddbb6 Mon Sep 17 00:00:00 2001
From: Ben Lin <maobin001@msn.com>
Date: 星期二, 17 十二月 2024 20:40:47 +0800
Subject: [PATCH] 提交前检查是否岗位、工单和不良代码

---
 Tiger.Business.MES/Transaction/PackingNode.cs |   40 ++++++++++++++++++++++++++++++++--------
 1 files changed, 32 insertions(+), 8 deletions(-)

diff --git a/Tiger.Business.MES/Transaction/PackingNode.cs b/Tiger.Business.MES/Transaction/PackingNode.cs
index c6dde95..4621164 100644
--- a/Tiger.Business.MES/Transaction/PackingNode.cs
+++ b/Tiger.Business.MES/Transaction/PackingNode.cs
@@ -66,7 +66,7 @@
                     if (Steps.IsNullOrEmpty() || !IsFinishNodeSteps)
                     {
 
-                        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 && q.BATCH_NO == s.BATCH_NO))
+                        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();
 
@@ -116,7 +116,7 @@
                                     action.IsSuccessed = false;
                                     //action.LocaleMsg = new($"鏉$爜[{0}]鏄浇鍏锋潯鐮侊紝璇锋壂鎻忚浇鍏蜂腑鐨勪骇鍝佹潯鐮佺户缁寘瑁呮搷浣�");
                                     action.LocaleMsg = new("MES.Transaction.PackingNode.Submit.OnlyMinPackage", input.SN);
-                                    return action;
+                                    return SetOutPutMqttMsg(action, input.Locale);
                                 }
                                 var curPkg = Context.ContainsKey("CurPackage") ? Context["CurPackage"] as WipPkg : null;
                                 if (!curPkg.IsNullOrEmpty() && !curPkg.IsFinished && curPkg.WorkBatch != curSNs.First().Batch.BATCH_NO)
@@ -126,7 +126,7 @@
                                     action.IsSuccessed = false;
                                     //action.LocaleMsg = new($"姝e湪鍖呰宸ュ崟鎵规[{0}]鐨勪骇鍝侊紝璇峰厛瀹屾垚褰撳墠鍖呰鍚庡啀鎵弿鍏朵粬鎵规[{1}]鐨勪骇鍝乕{2}]");
                                     action.LocaleMsg = new("MES.Transaction.PackingNode.Submit.BatchError", curPkg.WorkBatch, curSNs.First().Batch.BATCH_NO, input.SN);
-                                    return action;
+                                    return SetOutPutMqttMsg(action, input.Locale);
                                 }
                                 if (curSNs.First().Batch.ACT_LINE != CurLine.LINE_CODE)
                                 {
@@ -148,7 +148,7 @@
                                             action.Data.OperInfo = new();
                                             action.IsSuccessed = result.IsSuccessed;
                                             action.LocaleMsg = result.LocaleMsg;
-                                            return action;
+                                            return SetOutPutMqttMsg(action, input.Locale);
                                         }
                                     }
                                     //鏇存柊CurBatch
@@ -264,10 +264,12 @@
             {
                 action.Data.ShortMsg = new("宸ュ簭寮傚父", ShortMessage.Types.Error);
                 action.Data.OperInfo = CurOperInfo(input.Locale);
+                RemoveCurSnFromCurPackage(Context.ContainsKey("CurPackage") ? (Context["CurPackage"] as WipPkg).Item : null);
+                ResetNode();
                 //action.CatchExceptionWithLog(ex, $"鍖呰宸ュ簭锛氭彁浜ゆ搷浣滄暟鎹紓甯�");
                 action.CatchExceptionWithLog(ex, Biz.L("MES.Transaction.PackingNode.SubmitException"));
             }
-            return action;
+            return SetOutPutMqttMsg(action, input.Locale);
         }
 
         /// <summary>
@@ -304,7 +306,7 @@
                         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).Where(q => q.STATUS < MES_WIP_DATA.STATUSs.Finished.GetValue()).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()
@@ -403,6 +405,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())
@@ -424,7 +427,7 @@
                         {
                             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;
                         }
                         //濡傛灉鏈夋彁浜や笉鑹�
@@ -622,6 +625,7 @@
             catch (Exception ex)
             {
                 action.Data.ShortMsg = new("宸ユ寮傚父", ShortMessage.Types.Error);
+                RemoveCurSnFromCurPackage(Context.ContainsKey("CurPackage") ? (Context["CurPackage"] as WipPkg).Item : null);
                 ResetNode();
                 //action.CatchExceptionWithLog(ex, $"{curNode.NODE_NAME}锛氬伐搴忚妭鐐瑰伐姝ユ彁浜ゆ暟鎹紓甯革紝璇锋鏌ュ伐搴忚妭鐐硅缃�");
                 action.CatchExceptionWithLog(ex, Biz.L("MES.Transaction.PackingNode.NodeSubmitException", curNode.NODE_NAME));
@@ -658,7 +662,7 @@
                 //鏉$爜瀹屽伐
                 foreach (var wipSN in CurWipSNs)
                 {
-                    wipSN.STATUS = MES_WIP_DATA.STATUSs.Finished.GetValue();
+                    wipSN.FINISHED_FLAG = "Y";
                     wipSN.NODE_ID = curNode.ID;
                     wipSN.NODE_NAME = curNode.NODE_NAME;
                     wipSN.OPER_CODE = curNode.OPER_CODE;
@@ -857,6 +861,26 @@
             NodeCmd = null;
         }
 
+        public void RemoveCurSnFromCurPackage(WipPkgItem pkgItem)
+        {
+            if (!pkgItem.IsNullOrEmpty())
+            {
+                var delItem = pkgItem.Items.Where(q => CurWipSNs.Any(sn => q.WipSNs.ContainsKey(sn.ID))).ToList();
+                if (delItem.Any())
+                {
+                    pkgItem.Items.RemoveAll(q => CurWipSNs.Any(sn => q.WipSNs.ContainsKey(sn.ID)));
+                    pkgItem.IsFinished = false;
+                }
+                else
+                {
+                    foreach (var item in pkgItem.Items)
+                    {
+                        RemoveCurSnFromCurPackage(item);
+                    }
+                }
+            }
+        }
+
         public override bool Close(bool needSaveHistoryLog = false)
         {
             //needSaveHistoryLog = true;

--
Gitblit v1.9.3