| | |
| | | |
| | | resultModel.Success = 0; |
| | | resultModel.Message = "成功"; |
| | | |
| | | //提交事务 |
| | | Db.CommitTran(); |
| | | |
| | | return resultModel; |
| | | } |
| | | switch (taskInfo.OrderType) |
| | |
| | | IsBale = "0", |
| | | IsBelt = "0", |
| | | |
| | | PalletStatus = "1", |
| | | PalletStatus = "2", |
| | | |
| | | IsDel = "0", |
| | | CreateUser = 0, |
| | |
| | | sd1.LocatNo = locatInfo.LocatNo;//储位地址 |
| | | sd1.CompleteTime = comTime; |
| | | sd1.InspectStatus = "0";//待检验 |
| | | sd1.PalletStatus = "1";//预混 |
| | | sd1.PalletStatus = "2";//半成品 |
| | | |
| | | //修改库存明细 |
| | | Db.Updateable(sd1).ExecuteCommand(); |
| | |
| | | resultModel.Message = "起始储位信息不存在!"; |
| | | return resultModel; |
| | | } |
| | | //目标储位信息 |
| | | var endLocatInfo = Db.Queryable<SysStorageLocat>().First(w => w.LocatNo == taskInfo.EndLocat && w.IsDel == "0"); |
| | | if (endLocatInfo == null) |
| | | { |
| | | resultModel.Message = "目标储位信息不存在!"; |
| | | return resultModel; |
| | | } |
| | | //库存明细 |
| | | var sd2 = Db.Queryable<DataStockDetail>().First(w => w.PalletNo == taskInfo.PalletNo); |
| | | if (sd2 == null) |
| | |
| | | sd2.InspectQty = 0; |
| | | sd2.ASNNo = ""; |
| | | sd2.ASNDetailNo = null; |
| | | sd2.WareHouseNo = endLocatInfo.WareHouseNo;//所属仓库 |
| | | sd2.RoadwayNo = endLocatInfo.RoadwayNo;//所属巷道 |
| | | sd2.AreaNo = endLocatInfo.AreaNo;//所属区域 |
| | | sd2.LocatNo = endLocatInfo.LocatNo;//储位地址 |
| | | sd2.WareHouseNo = "";//所属仓库 |
| | | sd2.RoadwayNo = "";//所属巷道 |
| | | sd2.AreaNo = "";//所属区域 |
| | | sd2.LocatNo = "";//储位地址 |
| | | sd2.CompleteTime = comTime; |
| | | //修改库存明细 |
| | | Db.Updateable(sd2).ExecuteCommand(); |
| | |
| | | startLocatInfo.Status = "0";//空储位 |
| | | //修改起始储位状态 |
| | | Db.Updateable(startLocatInfo).ExecuteCommand(); |
| | | |
| | | endLocatInfo.Status = "1";//有物品 |
| | | //修改目标储位状态 |
| | | Db.Updateable(endLocatInfo).ExecuteCommand(); |
| | | |
| | | break; |
| | | #endregion |
| | |
| | | sd3.RoadwayNo = endLocatInfo2.RoadwayNo;//所属巷道 |
| | | sd3.AreaNo = endLocatInfo2.AreaNo;//所属区域 |
| | | sd3.LocatNo = endLocatInfo2.LocatNo;//储位地址 |
| | | if (endLocatInfo2.AreaNo == "A01")//洁净区 |
| | | if (endLocatInfo2.AreaNo.Contains("01"))//洁净区 |
| | | { |
| | | sd3.PalletStatus = "0"; |
| | | } |
| | | else if (endLocatInfo2.AreaNo == "A02")//预混区 |
| | | else if (endLocatInfo2.AreaNo.Contains("02"))//预混区 |
| | | { |
| | | sd3.PalletStatus = "1"; |
| | | } |
| | | else if (endLocatInfo2.AreaNo == "A03")//半成品区 |
| | | else if (endLocatInfo2.AreaNo.Contains("03"))//半成品区 |
| | | { |
| | | sd3.PalletStatus = "2"; |
| | | } |
| | | else if (endLocatInfo2.AreaNo == "A04")//脏桶区 |
| | | else if (endLocatInfo2.AreaNo.Contains("04"))//脏桶区 |
| | | { |
| | | sd3.PalletStatus = "3"; |
| | | sd3.LotNo = "";//批次 |
| | | sd3.SkuNo = ""; |
| | | sd3.SkuName = ""; |
| | | sd3.InspectStatus = "0";//待检验 |
| | | } |
| | | } |
| | | if (taskInfo.Type == "1")//出库任务 |
| | | else if (taskInfo.Type == "1")//出库任务 |
| | | { |
| | | //起始储位信息 |
| | | var startLocatInfo2 = Db.Queryable<SysStorageLocat>().First(w => w.LocatNo == taskInfo.StartLocat && w.IsDel == "0"); |
| | |
| | | sd3.AreaNo = "";//所属区域 |
| | | sd3.LocatNo = "";//储位地址 |
| | | } |
| | | else if (taskInfo.Type == "2")//移库任务 |
| | | { |
| | | //起始储位信息 |
| | | var startLocatInfo2 = Db.Queryable<SysStorageLocat>().First(w => w.LocatNo == taskInfo.StartLocat && w.IsDel == "0"); |
| | | if (startLocatInfo2 == null) |
| | | { |
| | | resultModel.Message = "起始储位信息不存在!"; |
| | | return resultModel; |
| | | } |
| | | startLocatInfo2.Status = "0";//空储位 |
| | | //修改起始储位状态 |
| | | Db.Updateable(startLocatInfo2).ExecuteCommand(); |
| | | |
| | | //目标储位信息 |
| | | var endLocatInfo2 = Db.Queryable<SysStorageLocat>().First(w => w.LocatNo == taskInfo.EndLocat && w.IsDel == "0"); |
| | | if (endLocatInfo2 == null) |
| | | { |
| | | resultModel.Message = "目标储位信息不存在!"; |
| | | return resultModel; |
| | | } |
| | | endLocatInfo2.Status = "1";//有物品 |
| | | //修改目标储位状态 |
| | | Db.Updateable(endLocatInfo2).ExecuteCommand(); |
| | | |
| | | sd3.WareHouseNo = endLocatInfo2.WareHouseNo;//所属仓库 |
| | | sd3.RoadwayNo = endLocatInfo2.RoadwayNo;//所属巷道 |
| | | sd3.AreaNo = endLocatInfo2.AreaNo;//所属区域 |
| | | sd3.LocatNo = endLocatInfo2.LocatNo;//储位地址 |
| | | sd3.Status = "0"; |
| | | if (endLocatInfo2.AreaNo.Contains("01"))//洁净区 |
| | | { |
| | | sd3.PalletStatus = "0"; |
| | | sd3.Status = "0"; |
| | | } |
| | | else if (endLocatInfo2.AreaNo.Contains("02"))//预混区 |
| | | { |
| | | sd3.PalletStatus = "1"; |
| | | } |
| | | else if (endLocatInfo2.AreaNo.Contains("03"))//半成品区 |
| | | { |
| | | sd3.PalletStatus = "2"; |
| | | } |
| | | else if (endLocatInfo2.AreaNo.Contains("04"))//脏桶区 |
| | | { |
| | | sd3.PalletStatus = "3"; |
| | | sd3.LotNo = "";//批次 |
| | | sd3.SkuNo = ""; |
| | | sd3.SkuName = ""; |
| | | sd3.InspectStatus = "0";//待检验 |
| | | } |
| | | } |
| | | //修改库存明细 |
| | | Db.Updateable(sd3).ExecuteCommand(); |
| | | |