| | |
| | | var newPalletInfo = await Db.Queryable<SysPallets>().FirstAsync(m => m.IsDel == "0" && m.PalletNo == palletNoNew && m.Status == "0"); |
| | | if (newPalletInfo == null) |
| | | { |
| | | var pinStockDetails = Db.Queryable<DataStockDetail>().Where(m => m.IsDel == "0" && m.PalletNo == palletNoNew &&(m.SkuNo != stockDetail.SkuNo || m.LotNo != stockDetail.LotNo)).ToList(); |
| | | throw Oops.Bah("新托盘信息不存在!"); |
| | | } |
| | | if (newPalletInfo.Status == "0") |
| | | { |
| | | var pinStockDetails = Db.Queryable<DataStockDetail>().Where(m => m.IsDel == "0" && m.PalletNo == palletNoNew && (m.SkuNo != stockDetail.SkuNo || m.LotNo != stockDetail.LotNo)).ToList(); |
| | | if (pinStockDetails.Count(m => m.SONo != notice.SONo) > 0) |
| | | { |
| | | throw Oops.Bah("新托盘信息不存在或已被使用!"); |
| | | throw Oops.Bah("一个托盘只能接受一个出库单拼托!"); |
| | | } |
| | | } |
| | | else |
| | |
| | | } |
| | | else |
| | | { |
| | | var locateStr = stockDetail.LocatNo; |
| | | //更改储位状态为空储位 |
| | | var locate = Db.Queryable<SysStorageLocat>().First(m => m.IsDel == "0" && m.LocatNo == locateStr); |
| | | if (locate != null) |
| | | { |
| | | locate.Status = "0"; |
| | | Db.Updateable(locate).ExecuteCommand(); |
| | | } |
| | | stockDetail.WareHouseNo = ""; |
| | | stockDetail.RoadwayNo = ""; |
| | | stockDetail.AreaNo = ""; |
| | | stockDetail.LocatNo = ""; |
| | | |
| | | stockDetail.SONo = soNo; |
| | | stockDetail.UDF5 = "1"; |
| | | await Db.Updateable(stockDetail).ExecuteCommandAsync(); |
| | |
| | | pinStockDetail.LockQty += pickQty; |
| | | await Db.Updateable(pinStockDetail).ExecuteCommandAsync(); |
| | | } |
| | | } |
| | | } |
| | | |
| | | //添加操作日志记录 |
| | | var k = new OperationSOServer().AddLogOperationSo("PDA模块", "拣货拼托", soNo, "拣货", $"在PDA上对出库单号为:{soNo}的原托盘码为:{palletNo},新托盘码为:{palletNoNew}的拣货拼托操作", userId); |
| | |
| | | string skuName = boxInfos.First().SkuName; |
| | | |
| | | // 验证是否车间线边仓库 |
| | | var areaList = new List<string>() { "B06", "B07", "B09" }; |
| | | var areaList = new List<string>() { "B06", "B07", "B09", "B24" }; |
| | | if (!areaList.Contains(stockDetail.AreaNo)) |
| | | { |
| | | throw Oops.Bah("托盘不是车间托盘!"); |
| | |
| | | await Db.Updateable(stockDetail).ExecuteCommandAsync(); |
| | | } |
| | | stock.Qty -= pickQty; |
| | | //stock.LockQty -= pickQty; |
| | | stock.LockQty -= pickQty; |
| | | if (stock.Qty <= 0) |
| | | { |
| | | await Db.Deleteable(stock).ExecuteCommandAsync(); |
| | |
| | | } |
| | | |
| | | // 验证是否车间线边仓库 |
| | | var areaList = new List<string>() { "B06", "B07", "B09" }; |
| | | var areaList = new List<string>() { "B06", "B07", "B09", "B24" }; |
| | | if (!areaList.Contains(stockDetail.AreaNo)) |
| | | { |
| | | throw Oops.Bah("托盘不是车间托盘!"); |