| | |
|---|
| | | foreach (var j in itemOutItems) |
|---|
| | | { |
|---|
| | | // 校验子表对应采购订单的供应商编码 |
|---|
| | | var c_SuppNo = Db.Queryable<MesRohIn, MesSupplier>( |
|---|
| | | (roh, supp) => new JoinQueryInfos( |
|---|
| | | var c_SuppNo = Db.Queryable<MesRohIn, MesSupplier>((roh, supp) => |
|---|
| | | new JoinQueryInfos( |
|---|
| | | JoinType.Left, |
|---|
| | | roh.Supplier == supp.Id.ToString() |
|---|
| | | )) |
|---|
| | |
|---|
| | | public List<MesInvItemOutCDetails> GetScanBarcode(WarehouseQuery query) |
|---|
| | | { |
|---|
| | | return Db.Queryable<MesInvItemOutCDetails, MesInvItemBarcodes, MesItems, |
|---|
| | | MesDepots>( |
|---|
| | | (b, bar, c, d) => new |
|---|
| | | JoinQueryInfos( |
|---|
| | | JoinType.Left, b.ItemBarcode == bar.ItemBarcode, |
|---|
| | | JoinType.Left, b.ItemNo == c.ItemNo && |
|---|
| | | b.Company == c.Company && |
|---|
| | | b.Factory == c.Factory, |
|---|
| | | JoinType.Left, b.DepotCode == d.DepotCode && |
|---|
| | | b.Company == d.Company && |
|---|
| | | b.Factory == d.Factory |
|---|
| | | )) |
|---|
| | | MesDepots>((b, bar, c, d) => new |
|---|
| | | JoinQueryInfos( |
|---|
| | | JoinType.Left, b.ItemBarcode == bar.ItemBarcode, |
|---|
| | | JoinType.Left, b.ItemNo == c.ItemNo && |
|---|
| | | b.Company == c.Company && |
|---|
| | | b.Factory == c.Factory, |
|---|
| | | JoinType.Left, b.DepotCode == d.DepotCode && |
|---|
| | | b.Company == d.Company && |
|---|
| | | b.Factory == d.Factory |
|---|
| | | )) |
|---|
| | | .Where((b, bar, c, d) => b.ItemOutId == query.id) |
|---|
| | | .Select((b, bar, c, d) => new MesInvItemOutCDetails |
|---|
| | | { |
|---|
