| | |
| | | |
| | | public List<MesInvItemInCDetails> GetInvItemInCDetails(decimal? pid) |
| | | { |
| | | var result = Db.Queryable<MesInvItemInCDetails, MesItems, MesUnit>( |
| | | (g, c, d) => new JoinQueryInfos( |
| | | var result = Db |
| | | .Queryable<MesInvItemInCDetails, MesItems, MesUnit>((g, c, d) => |
| | | new JoinQueryInfos( |
| | | JoinType.Left, |
| | | g.ItemNo == c.ItemNo && g.Company == c.Company && |
| | | g.Factory == c.Factory, JoinType.Inner, |
| | |
| | | if (invItemIns.Status == 1) throw new Exception("入库单已审核,不能重复推送"); |
| | | |
| | | var materials = Db.Queryable<MesInvItemInCItems, MesItems, MesUnit, |
| | | MesInvItemArnDetail>( |
| | | (g, c, d, a) => new JoinQueryInfos( |
| | | JoinType.Left, |
| | | g.ItemNo == c.ItemNo && g.Company == c.Company && |
| | | g.Factory == c.Factory, JoinType.Inner, |
| | | d.Id == Convert.ToDecimal(c.ItemUnit), |
| | | JoinType.Inner, |
| | | a.Ebeln == g.WorkNo && a.WorkLine == g.EbelnLineNo |
| | | && g.CbillNo == a.CbillNo |
| | | ) |
| | | ).Where((g, c, d, a) => g.BillNo == billNo).Select<Material>( |
| | | (g, c, d, a) => new Material |
| | | MesInvItemArnDetail>((g, c, d, a) => new JoinQueryInfos( |
| | | JoinType.Left, |
| | | g.ItemNo == c.ItemNo && g.Company == c.Company && |
| | | g.Factory == c.Factory, JoinType.Inner, |
| | | d.Id == Convert.ToDecimal(c.ItemUnit), |
| | | JoinType.Inner, |
| | | a.Ebeln == g.WorkNo && a.WorkLine == g.EbelnLineNo |
| | | && g.CbillNo == a.CbillNo |
| | | ) |
| | | ).Where((g, c, d, a) => g.BillNo == billNo) |
| | | .Select<Material>((g, c, d, a) => new Material |
| | | { |
| | | FstockId = g.DepotCode, |
| | | FuintId = d.Fnumber, |