From 799a463b41e84aa265f109035c08892614ea9fd8 Mon Sep 17 00:00:00 2001 From: kyy <3283105747@qq.com> Date: 星期四, 24 七月 2025 21:12:32 +0800 Subject: [PATCH] 首检排序 --- MES.Service/service/QC/SuspendService.cs | 18 +++++++++--------- 1 files changed, 9 insertions(+), 9 deletions(-) diff --git a/MES.Service/service/QC/SuspendService.cs b/MES.Service/service/QC/SuspendService.cs index bc6fbef..17ed102 100644 --- a/MES.Service/service/QC/SuspendService.cs +++ b/MES.Service/service/QC/SuspendService.cs @@ -13,11 +13,11 @@ var db = SqlSugarHelper.GetInstance(); //return db.Queryable<SysDepartment>().ToList(); return db - .Queryable<MesSchemeResult, MesLine, QsQaItemXj, SysDepartment>( - (a, b, c, d) => - new JoinQueryInfos(JoinType.Left, a.LineNo == b.LineNo, - JoinType.Inner, a.BillNo == c.BillNo, - JoinType.Left, b.Departmentcode == d.Departmentcode)) + .Queryable<MesSchemeResult, MesLine, QsQaItemXj, SysDepartment>((a, + b, c, d) => + new JoinQueryInfos(JoinType.Left, a.LineNo == b.LineNo, + JoinType.Inner, a.BillNo == c.BillNo, + JoinType.Left, b.Departmentcode == d.Departmentcode)) .Where((a, b, c, d) => a.PmoveMk == 0 && b.LineName != null && statusArray.Contains(a.ProcStatus)) .GroupBy((a, b, c, d) => new @@ -34,10 +34,10 @@ public List<MesLine> GetLines(string deptCode) { var db = SqlSugarHelper.GetInstance(); - var mesLines = db.Queryable<MesSchemeResult, MesLine, QsQaItemXj>( - (a, b, c) => - new JoinQueryInfos(JoinType.Left, a.LineNo == b.LineNo, - JoinType.Inner, a.BillNo == c.BillNo)) + var mesLines = db + .Queryable<MesSchemeResult, MesLine, QsQaItemXj>((a, b, c) => + new JoinQueryInfos(JoinType.Left, a.LineNo == b.LineNo, + JoinType.Inner, a.BillNo == c.BillNo)) .Where((a, b, c) => b.LineName != null && statusArray.Contains(a.ProcStatus) && b.Departmentcode == deptCode) -- Gitblit v1.9.3