| | |
| | | } |
| | | |
| | | //更新库存表信息 |
| | | var items = MainDB.Queryable<WMS_ITEM>().Where(q => SqlFunc.Subqueryable<BIZ_U9_ASN_SN>().Where(s => s.SN == q.SN && receipt.SnList.Select(sn => sn.SN).Contains(s.SN)).Any()).ToList(); |
| | | var items = MainDB.Queryable<WMS_ITEM>().Where(q => SqlFunc.Subqueryable<BIZ_U9_ASN_SN>().Where(s => s.SN == q.SN && s.ORDER_NO == order.ORDER_NO && finishNotSubmit.Select(d => d.LINE_NO).Contains(s.LINE_NO)).Any()).ToList(); |
| | | var historys = new List<WMS_ITEM_HIS>(); |
| | | foreach (var item in items) |
| | | { |
| | |
| | | item.TRANS_LINE = receipt.SnList.First(q => q.SN == item.SN).LINE_NO; |
| | | historys.Add(new WMS_ITEM_HIS(item, @$"送货单[{order.ORDER_NO}]的条码[{item.SN}]生成收货单[{receipt.ORDER_NO}],待检验完成后可入库")); |
| | | } |
| | | var pkgs = MainDB.Queryable<WMS_ITEM_PKG>().Where(q => SqlFunc.Subqueryable<BIZ_U9_ASN_SN>().Where(s => s.SN == q.SN && receipt.SnList.Select(sn => sn.SN).Contains(s.SN)).Any()).ToList(); |
| | | var pkgs = MainDB.Queryable<WMS_ITEM_PKG>().Where(q => SqlFunc.Subqueryable<BIZ_U9_ASN_SN>().Where(s => s.SN == q.SN && s.ORDER_NO == order.ORDER_NO && finishNotSubmit.Select(d => d.LINE_NO).Contains(s.LINE_NO)).Any()).ToList(); |
| | | foreach (var item in pkgs) |
| | | { |
| | | item.AUTH_ORG = receipt.AUTH_ORG; |