From a1bb51e7a4c60de2000eaddc5fbc862d3aa0c3b8 Mon Sep 17 00:00:00 2001
From: Ben Lin <maobin001@msn.com>
Date: 星期二, 30 四月 2024 15:14:20 +0800
Subject: [PATCH] MES实体更新

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

diff --git a/Tiger.Business/MES/Biz.Route.cs b/Tiger.Business/MES/Biz.Route.cs
index ad36fd3..9a5f25b 100644
--- a/Tiger.Business/MES/Biz.Route.cs
+++ b/Tiger.Business/MES/Biz.Route.cs
@@ -48,9 +48,9 @@
             /// <summary>
             /// 鑾峰彇宸ヨ壓璺嚎鍥惧舰鏁版嵁
             /// </summary>
-            /// <param name="routerCode"></param>
+            /// <param name="routerId"></param>
             /// <returns></returns>
-            public async Task<ApiAction<RouteData>> GetRouteData(string routerCode)
+            public async Task<ApiAction<RouteData>> GetRouteData(string routerId)
             {
                 var res = new ApiAction<RouteData>();
                 RouteData rotData = new RouteData();
@@ -58,12 +58,12 @@
                 {
                     //宸ヨ壓璺嚎
                     var route = await Db.Queryable<MES_ROUTE>()
-                        .WhereIF(!string.IsNullOrEmpty(routerCode), x => x.ROT_CODE.Equals(routerCode))
+                        .WhereIF(!string.IsNullOrEmpty(routerId), x => x.ROT_CODE.Equals(routerId))
                         .OrderBy(x => x.CREATE_TIME).FirstAsync();
                     rotData.route = route;
                     //鑺傜偣
                     var nodes = await Db.Queryable<MES_ROUTE_NODE>()
-                        .WhereIF(!string.IsNullOrEmpty(routerCode), x => x.ROT_CODE.Equals(routerCode))
+                        .WhereIF(!string.IsNullOrEmpty(routerId), x => x.ROT_ID.Equals(routerId))
                         .ToListAsync();
                     foreach (var node in nodes)
                     {
@@ -86,7 +86,7 @@
 
                     //杈�
                     var edges = await Db.Queryable<MES_ROUTE_EDGE>()
-                        .WhereIF(!string.IsNullOrEmpty(routerCode), x => x.ROT_CODE.Equals(routerCode))
+                        .WhereIF(!string.IsNullOrEmpty(routerId), x => x.ROT_ID.Equals(routerId))
                         .ToListAsync();
                     foreach (var edge in edges)
                     {
@@ -144,10 +144,10 @@
                     var dbTran = db.UseTran(() =>
                     {
                         var y = db.Storageable(routeEdge)
-                           .WhereColumns(t => new { t.EDGE_CODE, t.GHOST_ROW })
+                           .WhereColumns(t => new { t.ID, t.GHOST_ROW })
                            .ToStorage();
                         y.AsInsertable.ExecuteCommand();
-                        y.AsUpdateable.IgnoreColumns(x => x.ID).ExecuteCommand();
+                        y.AsUpdateable.ExecuteCommand();
                     });
                     if (!dbTran.IsSuccess)
                     {
@@ -176,10 +176,10 @@
                     var dbTran = db.UseTran(() =>
                     {
                         var y = db.Storageable(routeNode)
-                           .WhereColumns(t => new { t.NODE_CODE, t.GHOST_ROW })
+                           .WhereColumns(t => new { t.ID, t.GHOST_ROW })
                            .ToStorage();
                         y.AsInsertable.ExecuteCommand();
-                        y.AsUpdateable.IgnoreColumns(x => x.ID).ExecuteCommand();
+                        y.AsUpdateable.ExecuteCommand();
                     });
                     if (!dbTran.IsSuccess)
                     {

--
Gitblit v1.9.3