| | |
| | | |
| | | #endregion |
| | | |
| | | #region 验证储位状态是否正常 |
| | | |
| | | var locat = Db.Queryable<SysStorageLocat>().First(a=>a.IsDel == "0" && a.LocatNo == result.LocatNo); |
| | | if (locat == null) |
| | | { |
| | | throw new Exception("未获取到对应储位信息,请检查!"); |
| | | } |
| | | if (locat.Status != "1") |
| | | { |
| | | throw new Exception("当前储位不是有物品,请检查!"); |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | //获取库存明细信息 |
| | | var stockDetail = Db.Queryable<DataStockDetail>().Where(s => s.IsDel == "0" && s.PalletNo == palletNo).ToList(); |
| | | //验证库存明细信息是否存在 |
| | |
| | | item.AreaNo = "";//所属区域更改(改为空) |
| | | Db.Updateable(item).ExecuteCommand(); |
| | | } |
| | | //变更储位状态 |
| | | locat.Status = "0";//储位更改(改为空储位) |
| | | Db.Updateable(locat).ExecuteCommand(); |
| | | |
| | | //出库流水(更改状态) |
| | | var allot = Db.Queryable<BllExportAllot>().Where(m => m.IsDel == "0" && m.Status == "1" && m.PalletNo == palletNo && m.SONo == soNo).ToList(); |
| | | |