| | |
|---|
| | | |
|---|
| | | var query = db |
|---|
| | | .Queryable<QsQaItemXj, Womdaa, MesLine, |
|---|
| | | MesItems, SysUser,Womcaa>((s, a, c, b, us,ca) => |
|---|
| | | MesItems, SysUser,Womcaa,SysDepartment>((s, a, c, b, us,ca,d) => |
|---|
| | | new JoinQueryInfos( |
|---|
| | | JoinType.Inner, s.BillNo == a.Daa001, |
|---|
| | | JoinType.Left, a.Daa015 == c.LineNo, |
|---|
| | | JoinType.Left, s.ItemId == b.Id, |
|---|
| | | JoinType.Left, us.Fcode == s.CreateBy, |
|---|
| | | JoinType.Left, ca.Caa020 == a.Daa021 |
|---|
| | | JoinType.Left, ca.Caa020 == a.Daa021, |
|---|
| | | JoinType.Left, d.Departmentcode == c.Departmentcode |
|---|
| | | ) |
|---|
| | | ) |
|---|
| | | //.WhereIF(lineNo != null && lineNo.Length > 0, |
|---|
