| | |
|---|
| | | throw new Exception("未查询到任务信息"); |
|---|
| | | } |
|---|
| | | //获取对应库位信息 |
|---|
| | | var startlocat = Db.Queryable<SysStorageLocat>().First(a => a.IsDel == "0" && a.WareHouseNo == "W01" && a.LocatNo == task.StartLocat); |
|---|
| | | //var startlocat = Db.Queryable<SysStorageLocat>().First(a => a.IsDel == "0" && a.WareHouseNo == "W01" && a.LocatNo == task.StartLocat); |
|---|
| | | var startlocat = Db.Queryable<SysStorageLocat>().First(a => a.IsDel == "0" && a.LocatNo == task.StartLocat); |
|---|
| | | if (startlocat == null) |
|---|
| | | { |
|---|
| | | throw new Exception("未查询到储位信息"); |
|---|
| | | } |
|---|
| | | startlocat.Status = "0";//修改分配信息状态 |
|---|
| | | //获取储位信息 |
|---|
| | | var locat = Db.Queryable<SysStorageLocat>().First(a => a.IsDel == "0" && a.WareHouseNo == "W01" && a.LocatNo == task.StartLocat); |
|---|
| | | //var locat = Db.Queryable<SysStorageLocat>().First(a => a.IsDel == "0" && a.WareHouseNo == "W01" && a.LocatNo == task.StartLocat); |
|---|
| | | var locat = Db.Queryable<SysStorageLocat>().First(a => a.IsDel == "0" && a.LocatNo == task.StartLocat); |
|---|
| | | //获取移库任d务对应目标储位信息 |
|---|
| | | SysStorageLocat endlocat = new SysStorageLocat(); |
|---|
| | | if (task.Type == "2") |
|---|
| | | { |
|---|
| | | endlocat = Db.Queryable<SysStorageLocat>().First(a => a.IsDel == "0" && a.WareHouseNo == "W01" && a.LocatNo == task.EndLocat); |
|---|
| | | //endlocat = Db.Queryable<SysStorageLocat>().First(a => a.IsDel == "0" && a.WareHouseNo == "W01" && a.LocatNo == task.EndLocat); |
|---|
| | | endlocat = Db.Queryable<SysStorageLocat>().First(a => a.IsDel == "0" && a.LocatNo == task.EndLocat); |
|---|
| | | if (endlocat == null) |
|---|
| | | { |
|---|
| | | throw new Exception("未查询到目标储位信息"); |
|---|
| | |
|---|
| | | //获取库存 |
|---|
| | | var datastock = Db.Queryable<DataStock>().First(a => a.IsDel == "0" && a.SkuNo == stockDetail.SkuNo); |
|---|
| | | //获取储位信息 |
|---|
| | | var locate = Db.Queryable<SysStorageLocat>().First(a => a.IsDel == "0" && a.WareHouseNo == "W01" && a.LocatNo == stockDetail.LocatNo); |
|---|
| | | //var locate = Db.Queryable<SysStorageLocat>().First(a => a.IsDel == "0" && a.WareHouseNo == "W01" && a.LocatNo == stockDetail.LocatNo); |
|---|
| | | var locate = Db.Queryable<SysStorageLocat>().First(a => a.IsDel == "0" && a.LocatNo == stockDetail.LocatNo); |
|---|
| | | |
|---|
| | | //判断是否为空托盘 |
|---|
| | | if (stockDetail.SkuNo == "100099") |
|---|
