11

啊鑫

2025-07-15 5dc3cc86f5835369cd830f2a83318b9a8d69cf69

 MES.Service/service/QC/SuspendService.cs

@@ -13,8 +13,8 @@
        var db = SqlSugarHelper.GetInstance();
        //return db.Queryable<SysDepartment>().ToList();
        return db
            .Queryable<MesSchemeResult, MesLine, QsQaItemXj, SysDepartment>(
                (a, b, c, d) =>
            .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))
@@ -34,8 +34,8 @@
    public List<MesLine> GetLines(string deptCode)
    {
        var db = SqlSugarHelper.GetInstance();
        var mesLines = db.Queryable<MesSchemeResult, MesLine, QsQaItemXj>(
                (a, b, c) =>
        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 &&