From 4eab704b733002d37ad9c097dcd6f4f8c4fb9e36 Mon Sep 17 00:00:00 2001
From: Ben Lin <maobin001@msn.com>
Date: 星期四, 25 七月 2024 16:37:32 +0800
Subject: [PATCH] 更新工单状态

---
 Tiger.Business.MES/BIZ_MES_WO.cs |   44 ++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 44 insertions(+), 0 deletions(-)

diff --git a/Tiger.Business.MES/BIZ_MES_WO.cs b/Tiger.Business.MES/BIZ_MES_WO.cs
index e32dbbd..c4f57de 100644
--- a/Tiger.Business.MES/BIZ_MES_WO.cs
+++ b/Tiger.Business.MES/BIZ_MES_WO.cs
@@ -12,6 +12,7 @@
 using Tiger.IBusiness;
 using Microsoft.AspNetCore.Http;
 using Tiger.Model.Entitys.MES.BizMesWoBatch;
+using Tiger.Model.Entitys.MES.BizMesWo;
 
 namespace Tiger.Business.MES
 {
@@ -156,5 +157,48 @@
             }
             return result;
         }
+
+        /// <summary>
+        /// 鏇存柊宸ュ崟鐘舵��
+        /// </summary>
+        /// <param name="input"></param>
+        /// <returns></returns>
+        /// <exception cref="NotImplementedException"></exception>
+        public async Task<ApiAction> UpdateWoStatus(BizMesWoInput input)
+        {
+            var result = new ApiAction();
+            try
+            {
+                //淇濆瓨鍓嶇殑鍒ゆ柇,骞剁敓鎴愭壒娆″彿
+                var _wo = await Biz.Db.Queryable<BIZ_MES_WO>().Where(x => x.ORDER_NO == input.WorkOrder).FirstAsync();
+                if (_wo != null)
+                {
+                    _wo.STATUS = input.Status < 0 ? _wo.STATUS : input.Status;
+                    _wo.ROUTE_STATUS = input.RouteStatus;
+                }
+                else
+                {
+                    result.IsSuccessed = false;
+                    result.LocaleMsg = new($"宸ュ崟[{input.WorkOrder}]涓嶅瓨鍦�");
+                    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