| | |
| | | public List<MesInvItemArnDetail> GetDetails(WarehouseQuery query) |
| | | { |
| | | // 查询 |
| | | return Db.Queryable<MesInvItemArnDetail, MesItems, MesUnit>( |
| | | (c, t, u) => new object[] |
| | | return Db.Queryable<MesInvItemArnDetail, MesItems, MesUnit>((c, t, u) => |
| | | new object[] |
| | | { |
| | | JoinType.Left, |
| | | c.ItemNo == t.ItemNo && c.Company == t.Company && |
| | |
| | | // 查询 |
| | | var result = Db |
| | | .Queryable<MesQaItemsDetect01, MesInvItemArn, MesInvItemArnDetail, |
| | | MesItems, MesUnit, MesQaItemsDetectDetail5>( |
| | | (a, d, b, c, t, z) => new object[] |
| | | MesItems, MesUnit, |
| | | MesQaItemsDetectDetail5>((a, d, b, c, t, z) => new object[] |
| | | { |
| | | JoinType.Inner, d.BillNo == a.LotNo, |
| | | JoinType.Inner, d.Id == b.Mid && b.ItemNo == a.ItemNo, |