From dc00dcd986589c2f19160e711b819f1080576344 Mon Sep 17 00:00:00 2001
From: Ben Lin <maobin001@msn.com>
Date: 星期三, 05 六月 2024 14:14:35 +0800
Subject: [PATCH] 登录更新

---
 Tiger.Business/MES/Biz.Route.cs |   33 ++++++++++++++++++++++++++++++++-
 1 files changed, 32 insertions(+), 1 deletions(-)

diff --git a/Tiger.Business/MES/Biz.Route.cs b/Tiger.Business/MES/Biz.Route.cs
index b397e91..5af0a87 100644
--- a/Tiger.Business/MES/Biz.Route.cs
+++ b/Tiger.Business/MES/Biz.Route.cs
@@ -10,7 +10,6 @@
 using System.Linq;
 using Newtonsoft.Json;
 using Tiger.IBusiness;
-using static Tiger.Business.Biz;
 using Microsoft.AspNetCore.Http;
 
 namespace Tiger.Business
@@ -342,6 +341,38 @@
                 }
                 return await Task.FromResult(result);
             }
+
+            /// <summary>
+            /// 鍒犻櫎宸ヨ壓璺嚎
+            /// </summary>
+            /// <param name="routeId"></param>
+            /// <returns></returns>
+            public async Task<ApiAction> DeleteRoute(string routeId) {
+                var result = new ApiAction();
+                try
+                {
+                    //鏌ヨ鏄惁宸茬粡鏈夊伐鍗曞湪鐢ㄦ垨鑰呮湁缁戝畾浜у搧
+
+                    var db = Db;
+                    var dbTran = db.UseTran(() =>
+                    {
+                        db.Deleteable<MES_ROUTE_NODE>(false).Where(x => x.ROT_ID == routeId).ExecuteCommand();
+                        db.Deleteable<MES_ROUTE_EDGE>(false).Where(x => x.ROT_ID == routeId).ExecuteCommand();
+                        db.Deleteable<MES_ROUTE_NODE_ACT>(false).Where(x => x.ROT_ID == routeId).ExecuteCommand();
+                        db.Deleteable<MES_ROUTE>().Where(x => x.ID == routeId).ExecuteCommand();
+                    });
+                    if (!dbTran.IsSuccess)
+                    {
+                        result.IsSuccessed = false;
+                        result.LocaleMsg = new($"鍒犻櫎宸ヨ壓璺嚎寮傚父");
+                    }
+                }
+                catch (Exception ex)
+                {
+                    result.CatchExceptionWithLog(ex, "鍒犻櫎宸ヨ壓璺嚎寮傚父");
+                }
+                return await Task.FromResult(result);
+            }
         }
     }
 }

--
Gitblit v1.9.3