| | |
| | | { |
| | | throw new Exception("未查到对应出库类型的物料"); |
| | | } |
| | | |
| | | if (type!="8") |
| | | { |
| | | skuList = skuList.Where(m => m != "100088").ToList(); |
| | | } |
| | | else |
| | | { |
| | | skuList = skuList.Where(m => m == "100088").ToList(); |
| | | } |
| | | //skuList = sku.Select(m => m.SkuNo).ToList(); |
| | | var stockRst = new StockServer(); |
| | | var stockDetailRst = new StockDetailServer(); |
| | |
| | | //库存明细 |
| | | var stockList = Db.Queryable<DataStockDetail>().Where(a => stockIds.Contains(a.Id)).ToList(); |
| | | |
| | | //分配信息 |
| | | var allots = Db.Queryable<BllExportAllot>().Where(m => m.IsDel == "0" && m.SODetailNo == detail.Id && m.Status == "0").ToList(); |
| | | |
| | | //库存总表 |
| | | //var stockz = Db.Queryable<DataStock>().First(d => d.IsDel == "0" && d.SkuNo == detail.SkuNo && d.LotNo == detail.LotNo); |
| | |
| | | { |
| | | throw new Exception("操作失败,出库数量超出库存数量!"); |
| | | } |
| | | //添加分配表信息 |
| | | var allot = new BllExportAllot |
| | | { |
| | | SONo = notice.SONo, |
| | | WaveNo = "", |
| | | SODetailNo = detail.Id, |
| | | StockId = st.StockId, |
| | | LotNo = stock.LotNo, |
| | | LotText = stock.LotText, |
| | | SupplierLot = stock.SupplierLot, |
| | | SkuNo = stock.SkuNo, |
| | | SkuName = stock.SkuName, |
| | | Standard = stock.Standard, |
| | | PalletNo = stock.PalletNo, |
| | | IsBale = stock.IsBale, |
| | | IsBelt = stock.IsBelt, |
| | | Qty = st.Qty, |
| | | CompleteQty = 0, |
| | | Status = "0", |
| | | LogisticsId = notice.LogisticsId, |
| | | IsAdvance = "0", |
| | | OutMode = "",//出库口 |
| | | |
| | | CreateUser = userId, |
| | | CreateTime = DateTime.Now |
| | | }; |
| | | allotList.Add(allot); |
| | | var bl = allots.FirstOrDefault(m => m.StockId == st.StockId); |
| | | if (bl == null) |
| | | { |
| | | //添加分配表信息 |
| | | var allot = new BllExportAllot |
| | | { |
| | | SONo = notice.SONo, |
| | | WaveNo = "", |
| | | SODetailNo = detail.Id, |
| | | StockId = st.StockId, |
| | | LotNo = stock.LotNo, |
| | | LotText = stock.LotText, |
| | | SupplierLot = stock.SupplierLot, |
| | | SkuNo = stock.SkuNo, |
| | | SkuName = stock.SkuName, |
| | | Standard = stock.Standard, |
| | | PalletNo = stock.PalletNo, |
| | | IsBale = stock.IsBale, |
| | | IsBelt = stock.IsBelt, |
| | | Qty = st.Qty, |
| | | CompleteQty = 0, |
| | | Status = "0", |
| | | LogisticsId = notice.LogisticsId, |
| | | IsAdvance = "0", |
| | | OutMode = "",//出库口 |
| | | |
| | | CreateUser = userId, |
| | | CreateTime = DateTime.Now |
| | | }; |
| | | allotList.Add(allot); |
| | | } |
| | | else |
| | | { |
| | | bl.Qty += st.Qty; |
| | | Db.Updateable(bl).ExecuteCommand(); |
| | | } |
| | | |
| | | //库存明细 |
| | | stock.LockQty += st.Qty; |
| | | stock.Status = stock.LockQty == stock.Qty ? "2" : "1"; |