| | |
| | | //添加出库单 |
| | | foreach (var d in model.Detail) |
| | | { |
| | | if (d.Qty < 1) |
| | | if (d.Qty <= 0) |
| | | { |
| | | throw new Exception("出库数量必须大于0"); |
| | | } |
| | |
| | | //更新出库单 |
| | | foreach (var d in model.Detail) |
| | | { |
| | | if (d.Qty < 1) |
| | | if (d.Qty <= 0) |
| | | { |
| | | throw new Exception("出库数据必须大于0"); |
| | | } |
| | |
| | | var allot = new AllotLocation(); |
| | | |
| | | #region 集合 |
| | | |
| | | |
| | | Db.BeginTran(); |
| | | try |
| | | { |
| | |
| | | { |
| | | s.Status = "1"; |
| | | } |
| | | |
| | | |
| | | var sd = Db.Updateable(s).UpdateColumns(it => new { it.LockQty, it.Status }).ExecuteCommand(); |
| | | |
| | | } |
| | |
| | | notice.Status = "3";//正在执行 |
| | | } |
| | | } |
| | | |
| | | |
| | | notice.UpdateUser = userId; |
| | | notice.UpdateTime = DateTime.Now; |
| | | var zd = Db.Updateable(notice).ExecuteCommand(); |
| | |
| | | } |
| | | } |
| | | } |
| | | if(string.IsNullOrEmpty(newAddress)) |
| | | if (string.IsNullOrEmpty(newAddress)) |
| | | { |
| | | //已有物品的巷道 |
| | | var roadwayHave = Db.Queryable<DataStockDetail>().Where(w => w.IsDel == "0" && w.WareHouseNo == "W01").GroupBy(g => g.RoadwayNo).Select(s => s.RoadwayNo).ToList(); |
| | |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | } |
| | | } |
| | | |
| | |
| | | else |
| | | { |
| | | // 取最上面一排 |
| | | location = slotModel[0].LocatNo; |
| | | location = slotModel[0].LocatNo; |
| | | } |
| | | |
| | | bl = true; |
| | |
| | | |
| | | } |
| | | |
| | | var endLocateList = Db.Queryable<SysStorageLocat>().Where(m => m.IsDel == "0" && (m.AreaNo == "B02" || m.AreaNo == "B05")).Select(m => m.LocatNo).ToList(); |
| | | //所属区域集合 |
| | | List<string> areNolist = new List<string>() { "B01", "B02", "B05" }; |
| | | var endLocateList = Db.Queryable<SysStorageLocat>().Where(m => m.IsDel == "0" && areNolist.Contains(m.AreaNo)).Select(m => m.LocatNo).ToList(); |
| | | //判断是否是原辅料出库任务 货架储位=》平库储位 |
| | | if (endLocateList.Contains(task.EndLocat) && PalletType == "0") |
| | | { |