| | |
| | | } |
| | | } |
| | | |
| | | //车间pda拣货 |
| | | //车间pda拣货 - 标签 |
| | | public async Task ChejianPick(string palletNo, string boxNo, int userId) |
| | | { |
| | | Db.BeginTran(); |
| | |
| | | } |
| | | if (string.IsNullOrEmpty(boxNo)) |
| | | { |
| | | throw Oops.Bah("追溯条码和拣货数量不能同时输入"); |
| | | throw Oops.Bah("箱码不可为空"); |
| | | } |
| | | |
| | | //箱码明细 |
| | |
| | | boxInfos = await boxInfo.ToListAsync(); |
| | | |
| | | //库存明细 |
| | | var stockDetail = await Db.Queryable<DataStockDetail>().FirstAsync(m => m.IsDel == "0" && m.PalletNo == palletNo && m.SkuNo == boxInfos.First().SkuNo && m.LotNo == boxInfos.First().LotNo); |
| | | var stockDetail = await Db.Queryable<DataStockDetail>() |
| | | .FirstAsync(m => m.IsDel == "0" && m.PalletNo == palletNo |
| | | && m.SkuNo == boxInfos.First().SkuNo && m.LotNo == boxInfos.First().LotNo); |
| | | if (stockDetail == null) |
| | | { |
| | | throw Oops.Bah("未查询到该托盘分配的库存明细信息!"); |
| | | } |
| | | |
| | | // 验证是否车间线边仓库 |
| | | var areaList = new List<string>() { "B06", "B07", "B09" }; |
| | | if (!areaList.Contains(stockDetail.AreaNo)) |
| | | { |
| | | throw Oops.Bah("托盘不是车间托盘!"); |
| | | } |
| | | |
| | | //库存总表 |
| | | var stock = await Db.Queryable<DataStock>().FirstAsync(a => a.IsDel == "0" && a.SkuNo == stockDetail.SkuNo && a.LotNo == stockDetail.LotNo); |
| | | var stock = await Db.Queryable<DataStock>() |
| | | .FirstAsync(a => a.IsDel == "0" && a.SkuNo == stockDetail.SkuNo && a.LotNo == stockDetail.LotNo); |
| | | if (stock == null) |
| | | { |
| | | throw Oops.Bah("未查询到该托盘分配的库存信息!"); |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | var pickQty = boxInfos.Sum(m => m.Qty); |
| | | |
| | | // 删除箱任务 |
| | | await Db.Deleteable(boxInfos).ExecuteCommandAsync(); |
| | | |
| | | |
| | | //删除或修改库存明细 |
| | |
| | | { |
| | | await Db.Updateable(stock).ExecuteCommandAsync(); |
| | | } |
| | | |
| | | var num2 = await Db.Queryable<DataStockDetail>().CountAsync(m => m.IsDel == "0" && m.PalletNo == palletNo); |
| | | if (num2 <= 0) |
| | | { |
| | |
| | | } |
| | | |
| | | //添加操作日志记录 |
| | | var k = new OperationSOServer().AddLogOperationSo("PDA模块", "车间出库", boxNo, "拣货", $"在PDA上对箱号为:{boxNo}的托盘码为:{palletNo}的拣货操作", userId); |
| | | var k = new OperationSOServer().AddLogOperationSo("PDA模块", "车间出库", |
| | | boxNo, "拣货", $"在PDA上对箱号为:{boxNo}的托盘码为:{palletNo}的拣货操作", userId); |
| | | Db.CommitTran(); |
| | | } |
| | | catch (AppFriendlyException e) |