From 5707781039b9d902ce1d2d6727fba65bbab14574 Mon Sep 17 00:00:00 2001 From: 啊鑫 <t2856754968@163.com> Date: 星期六, 13 九月 2025 17:02:06 +0800 Subject: [PATCH] 异常单回滚 --- WebApi/Gs.BaseInfo/Services/MesUnitManager.cs | 30 ++++++++++++------------------ 1 files changed, 12 insertions(+), 18 deletions(-) diff --git a/WebApi/Gs.BaseInfo/Services/MesUnitManager.cs b/WebApi/Gs.BaseInfo/Services/MesUnitManager.cs index 4ac3b0b..ce8d21e 100644 --- a/WebApi/Gs.BaseInfo/Services/MesUnitManager.cs +++ b/WebApi/Gs.BaseInfo/Services/MesUnitManager.cs @@ -38,31 +38,25 @@ var _sbBy = new StringBuilder(query.sortName + " " + query.sortOrder); var totalCount = 0; - var itemsList = Db.Queryable<MesUnit, MesUnit, MesUnit>((a, b, c) => - new object[] + var itemsList = Db.Queryable<MesUnit, MesUnit, MesUnit>( + (a, b, c) => new object[] { JoinType.Left, a.Id == b.Id, JoinType.Left, a.Id == c.Id } ) - .Select((a, b, c) => new MesUnit + .Select((a,b,c) => new MesUnit { - Fforbidstatus = a.Fforbidstatus + ":" + - (a.Fforbidstatus == "A" ? "姝e父" : "绂佺敤"), - Fcurrentunitid = b.Fname, - Fbaseunit = c.Fname, + Fforbidstatus = a.Fforbidstatus + ":" + (a.Fforbidstatus == "A" ? "姝e父" : "绂佺敤"), + Fcurrentunitid=b.Fname, + Fbaseunit=c.Fname, DataType = a.DataType + ":" - + SqlFunc.IF(a.DataType == "Z") - .Return("鏆傚瓨") - .ElseIF(a.DataType == "A") - .Return("鍒涘缓") - .ElseIF(a.DataType == "B") - .Return("瀹℃牳涓�") - .ElseIF(a.DataType == "C") - .Return("宸插鏍�") - .ElseIF(a.DataType == "D") - .Return("閲嶆柊瀹℃牳") - .End(a.DataType) + + SqlFunc.IF(a.DataType == "Z").Return("鏆傚瓨") + .ElseIF(a.DataType == "A").Return("鍒涘缓") + .ElseIF(a.DataType == "B").Return("瀹℃牳涓�") + .ElseIF(a.DataType == "C").Return("宸插鏍�") + .ElseIF(a.DataType == "D").Return("閲嶆柊瀹℃牳") + .End(a.DataType) }, true) .Where(_sbWhere.ToString()) .OrderBy(_sbBy.ToString()) -- Gitblit v1.9.3