首检排序

kyy

2025-07-24 799a463b41e84aa265f109035c08892614ea9fd8

 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)