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