优化代码格式，添加到货标识和查询条件

啊鑫

2025-06-05 44a7c47a724c154c54e256727c75e79d31fd42e2

 StandardPda/MES.Service/service/QC/SuspendService.cs

@@ -13,12 +13,12 @@
        var db = SqlSugarHelper.GetInstance();
        //return db.Queryable<SysDepartment>().ToList();
        return db
            .Queryable<Womdaa, MesLine, QsQaItemXj, SysDepartment>(
                (a, b, c, d) =>
                    new JoinQueryInfos(JoinType.Left,
                        a.Daa002 == b.Id.ToString(),
                        JoinType.Inner, a.Daa001 == c.BillNo,
                        JoinType.Left, b.Departmentcode == d.Departmentcode))
            .Queryable<Womdaa, MesLine, QsQaItemXj,
                SysDepartment>((a, b, c, d) =>
                new JoinQueryInfos(JoinType.Left,
                    a.Daa002 == b.Id.ToString(),
                    JoinType.Inner, a.Daa001 == c.BillNo,
                    JoinType.Left, b.Departmentcode == d.Departmentcode))
            .Where((a, b, c, d) => b.LineName != null &&
                                   statusArray.Contains(a.Daa018))
            .GroupBy((a, b, c, d) => new
@@ -36,11 +36,10 @@
    public List<MesLine> GetLines(string deptCode)
    {
        var db = SqlSugarHelper.GetInstance();
        var mesLines = db.Queryable<Womdaa, MesLine, QsQaItemXj>(
                (a, b, c) =>
                    new JoinQueryInfos(JoinType.Left,
                        a.Daa002 == b.Id.ToString(),
                        JoinType.Inner, a.Daa001 == c.BillNo))
        var mesLines = db.Queryable<Womdaa, MesLine, QsQaItemXj>((a, b, c) =>
                new JoinQueryInfos(JoinType.Left,
                    a.Daa002 == b.Id.ToString(),
                    JoinType.Inner, a.Daa001 == c.BillNo))
            .Where((a, b, c) => b.LineName != null &&
                                statusArray.Contains(a.Daa018)
                                && b.Departmentcode == deptCode)