| | |
| | | switch (model.Type) |
| | | { |
| | | case "0"://叫净桶 |
| | | pallet = stockDetail.Where(w => w.WareHouseNo == houseNo && w.PalletStatus == "0" |
| | | pallet = stockDetail.Where(w => w.WareHouseNo == houseNo && w.PalletStatus == "0" && w.Status == "0" |
| | | && (w.AreaNo.Contains("01") || w.AreaNo.Contains("11") || w.AreaNo.Contains("21") || w.AreaNo.Contains("31"))).OrderByDescending(o => o.CreateTime).First(); |
| | | if (pallet == null) |
| | | { |
| | | throw new Exception("暂无净桶可分配"); |
| | | } |
| | | } |
| | | pallet.Status = "2";//分配状态 0:待分配,1:部分分配 , 2:已分配 |
| | | //更新桶库存明细 |
| | | Db.Updateable(pallet).ExecuteCommand(); |
| | | |
| | | taskMsg = "设备叫净桶任务"; |
| | | break; |
| | | case "1"://叫料桶(混料) |
| | |
| | | throw new Exception("批次号为空!"); |
| | | } |
| | | //查找库存中是否有可用的此批次的混料桶 |
| | | pallet = stockDetail.Where(w => w.WareHouseNo == houseNo && w.PalletStatus == "1" && w.LotNo == model.LotNo |
| | | pallet = stockDetail.Where(w => w.WareHouseNo == houseNo && w.PalletStatus == "1" && w.Status == "0" && w.LotNo == model.LotNo |
| | | && (w.AreaNo.Contains("02") || w.AreaNo.Contains("12") || w.AreaNo.Contains("22") || w.AreaNo.Contains("32"))).OrderByDescending(o => o.CompleteTime).First(); |
| | | if (pallet == null) |
| | | { |
| | | throw new Exception("暂无混料桶可分配"); |
| | | } |
| | | pallet.LotNo = model.LotNo; |
| | | //更新桶库存明细维护批次号 |
| | | pallet.Status = "2";//分配状态 0:待分配,1:部分分配 , 2:已分配 |
| | | pallet.LotNo = model.LotNo;//批次号 |
| | | //更新桶库存明细 |
| | | Db.Updateable(pallet).ExecuteCommand(); |
| | | |
| | | taskMsg = "设备叫料桶混料任务"; |
| | |
| | | Db.Updateable(soNotice).ExecuteCommand(); |
| | | |
| | | //查找库存中是否有此批次的合格下料桶 |
| | | pallet = stockDetail.Where(w => w.WareHouseNo == houseNo && w.PalletStatus == "2" && w.LotNo == model.LotNo && w.InspectStatus=="1" |
| | | pallet = stockDetail.Where(w => w.WareHouseNo == houseNo && w.PalletStatus == "2" && w.Status == "0" && w.LotNo == model.LotNo && w.InspectStatus=="1" |
| | | && (w.AreaNo.Contains("03") || w.AreaNo.Contains("13") || w.AreaNo.Contains("23") || w.AreaNo.Contains("33"))).OrderByDescending(o => o.CompleteTime).First(); |
| | | if (pallet == null) |
| | | { |
| | | throw new Exception("暂无下料桶可分配"); |
| | | } |
| | | pallet.Status = "2";//分配状态 0:待分配,1:部分分配 , 2:已分配 |
| | | //更新桶库存明细 |
| | | Db.Updateable(pallet).ExecuteCommand(); |
| | | |
| | | taskMsg = "设备叫料桶下料任务"; |
| | | break; |
| | | case "3"://叫脏桶 |
| | | List<DataStockDetail> palletList = stockDetail.Where(w => w.WareHouseNo == houseNo && w.PalletStatus == "3" |
| | | List<DataStockDetail> palletList = stockDetail.Where(w => w.WareHouseNo == houseNo && w.PalletStatus == "3" && w.Status == "0" |
| | | && (w.AreaNo.Contains("03") || w.AreaNo.Contains("13") || w.AreaNo.Contains("23") || w.AreaNo.Contains("33"))).OrderByDescending(o => o.CompleteTime).ToList(); |
| | | if (palletList.Count <= 0) |
| | | { |
| | |
| | | //} |
| | | #endregion |
| | | |
| | | item.Status = "2";//分配状态 0:待分配,1:部分分配 , 2:已分配 |
| | | //更新桶库存明细 |
| | | Db.Updateable(item).ExecuteCommand(); |
| | | //起始储位地址信息 |
| | | var startLoction2 = Db.Queryable<SysStorageLocat>().First(w => w.IsDel == "0" && w.LocatNo == item.LocatNo); |
| | | if (startLoction2 == null) |
| | |
| | | stockDetail.WareHouseNo = endLocatInfo.WareHouseNo;//所属仓库 |
| | | stockDetail.RoadwayNo = endLocatInfo.RoadwayNo;//所属巷道 |
| | | stockDetail.AreaNo = endLocatInfo.AreaNo;//所属区域 |
| | | stockDetail.LocatNo = endLocatInfo.LocatNo;//储位地址 |
| | | stockDetail.Status = "0"; |
| | | stockDetail.LocatNo = endLocatInfo.LocatNo;//储位地址 |
| | | if (endLocatInfo.AreaNo.Contains("01") || endLocatInfo.AreaNo.Contains("11") || endLocatInfo.AreaNo.Contains("21") || endLocatInfo.AreaNo.Contains("31"))//洁净区 |
| | | { |
| | | stockDetail.PalletStatus = "0"; |
| | | stockDetail.Status = "0"; |
| | | stockDetail.Status = "0";//待分配 |
| | | } |
| | | else if (endLocatInfo.AreaNo.Contains("02") || endLocatInfo.AreaNo.Contains("12") || endLocatInfo.AreaNo.Contains("22") || endLocatInfo.AreaNo.Contains("32"))//预混区 |
| | | { |
| | | stockDetail.PalletStatus = "1"; |
| | | stockDetail.Status = "0";//待分配 |
| | | } |
| | | else if (endLocatInfo.AreaNo.Contains("03") || endLocatInfo.AreaNo.Contains("13") || endLocatInfo.AreaNo.Contains("23") || endLocatInfo.AreaNo.Contains("33"))//半成品区 |
| | | { |
| | | stockDetail.PalletStatus = "2"; |
| | | stockDetail.Status = "0";//待分配 |
| | | } |
| | | else if (endLocatInfo.AreaNo.Contains("04") || endLocatInfo.AreaNo.Contains("14") || endLocatInfo.AreaNo.Contains("24")|| endLocatInfo.AreaNo.Contains("34"))//脏桶区 |
| | | { |
| | |
| | | stockDetail.LotNo = "";//批次 |
| | | stockDetail.SkuNo = ""; |
| | | stockDetail.SkuName = ""; |
| | | stockDetail.Status = "0";//待分配 |
| | | stockDetail.InspectStatus = "0";//待检验 |
| | | } |
| | | //修改库存明细 |