| | |
| | | var db = SqlSugarHelper.GetInstance(); |
| | | //return db.Queryable<SysDepartment>().ToList(); |
| | | return db |
| | | .Queryable<Womdaa, MesLine, QsQaItemXj, SysDepartment>( |
| | | (a, b, c, d) => |
| | | .Queryable<Womdaa, MesLine, QsQaItemXj, |
| | | SysDepartment>((a, b, c, d) => |
| | | new JoinQueryInfos(JoinType.Left, |
| | | a.Daa002 == b.Id.ToString(), |
| | | JoinType.Inner, a.Daa001 == c.BillNo, |
| | |
| | | public List<MesLine> GetLines(string deptCode) |
| | | { |
| | | var db = SqlSugarHelper.GetInstance(); |
| | | var mesLines = db.Queryable<Womdaa, MesLine, QsQaItemXj>( |
| | | (a, b, c) => |
| | | 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)) |