From 0aa0370049c5499367394f494e8c804941cedcbc Mon Sep 17 00:00:00 2001
From: Ben Lin <maobin001@msn.com>
Date: 星期四, 22 八月 2024 14:20:39 +0800
Subject: [PATCH] 工单管理更新

---
 Tiger.Business.MES/BIZ/BIZ_MES_WO.cs |   54 +++++++++++++++++++++++++++++++++++++++++++++++++++++-
 1 files changed, 53 insertions(+), 1 deletions(-)

diff --git a/Tiger.Business.MES/BIZ/BIZ_MES_WO.cs b/Tiger.Business.MES/BIZ/BIZ_MES_WO.cs
index 59cd2ad..e4039bb 100644
--- a/Tiger.Business.MES/BIZ/BIZ_MES_WO.cs
+++ b/Tiger.Business.MES/BIZ/BIZ_MES_WO.cs
@@ -103,7 +103,6 @@
             var result = new ApiAction();
             try
             {
-                WoContext.RemoveBatch(input.WoBatch.BATCH_NO);
                 //淇濆瓨鍓嶇殑鍒ゆ柇,骞剁敓鎴愭壒娆″彿
                 var _wo = await Biz.Db.Queryable<BIZ_MES_WO>().Where(x => x.ORDER_NO == input.Wo.ORDER_NO).FirstAsync();
                 //if (_wo.STATUS > (int)BIZ_MES_WO.STATUSs.Init)
@@ -125,6 +124,14 @@
                     result.LocaleMsg = new($"宸ュ崟涓嬪彂鐨勬暟閲忚秴杩囧伐鍗曡鍒掓暟閲忥紝涓嶈兘涓嬪彂锛�");
                     return result;
                 }
+                if (!Biz.Db.Queryable<BIZ_MES_WO_BATCH>().Any(x => x.ORDER_NO == input.Wo.ORDER_NO && x.ACT_LINE == input.WoBatch.ACT_LINE && x.STATUS==(int)BIZ_MES_WO_BATCH.STATUSs.Closed))
+                {
+                    result.IsSuccessed = false;
+                    result.LocaleMsg = new($"宸ュ崟鍦ㄧ嚎浣揫{input.WoBatch.ACT_LINE}]鏈夋病瀹屽伐鐨勫伐鍗曟壒娆★紝涓嶈兘涓嬪彂锛�");
+                    return result;
+                }
+                WoContext.RemoveBatch(input.WoBatch.BATCH_NO);
+
                 var _batchWos = await Biz.Db.Queryable<V_MES_WO_BATCH>().Where(x => x.ORDER_NO == input.WoBatch.ORDER_NO).ToListAsync();
                 if (_batchWos.Count > 0)
                 {
@@ -201,5 +208,50 @@
             }
             return result;
         }
+
+        /// <summary>
+        /// 鏇存柊宸ュ崟鎵规鐘舵��
+        /// </summary>
+        /// <param name="input"></param>
+        /// <returns></returns>
+        /// <exception cref="NotImplementedException"></exception>
+        public async Task<ApiAction> UpdateWoBatchStatus(BizMesWoInput input)
+        {
+            var result = new ApiAction();
+            try
+            {
+                //淇濆瓨鍓嶇殑鍒ゆ柇,骞剁敓鎴愭壒娆″彿
+                var _wo = await Biz.Db.Queryable<BIZ_MES_WO_BATCH>().Where(x => x.BATCH_NO == input.WoBatch).FirstAsync();
+                if (_wo != null)
+                {
+                    _wo.STATUS = input.Status < 0 ? _wo.STATUS : input.Status;
+                    if (input.Status == (int) BIZ_MES_WO_BATCH.STATUSs.Paused) {
+                        WoContext.RemoveBatch(input.WoBatch);
+                    }
+                }
+                else
+                {
+                    result.IsSuccessed = false;
+                    result.LocaleMsg = new($"宸ュ崟鎵规[{input.WoBatch}]涓嶅瓨鍦�");
+                    return result;
+                }
+
+                var db = Biz.Db;
+                var dbTran = db.UseTran(() =>
+                {
+                    db.Updateable(_wo, input.UserId).ExecuteCommand();
+                });
+                if (!dbTran.IsSuccess)
+                {
+                    result.IsSuccessed = false;
+                    result.LocaleMsg = new($"鏇存柊宸ュ崟鎵规鐘舵�佸紓甯�");
+                }
+            }
+            catch (Exception ex)
+            {
+                result.CatchExceptionWithLog(ex, "鏇存柊宸ュ崟鎵规鐘舵�佸紓甯�");
+            }
+            return result;
+        }
     }
 }

--
Gitblit v1.9.3