| | |
| | | return db |
| | | .Queryable<Womdaa, MesLine, QsQaItemXj, SysDepartment>( |
| | | (a, b, c, d) => |
| | | new JoinQueryInfos(JoinType.Left, a.Daa002 == b.Id.ToString(), |
| | | 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 && |
| | |
| | | var db = SqlSugarHelper.GetInstance(); |
| | | var mesLines = db.Queryable<Womdaa, MesLine, QsQaItemXj>( |
| | | (a, b, c) => |
| | | new JoinQueryInfos(JoinType.Left, a.Daa002 == b.Id.ToString(), |
| | | 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) |