| | |
| | | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// WCS申请空托出库 |
| | | /// </summary> |
| | | /// <param name="model"> </param> |
| | | /// <param name="userId"> </param> |
| | | /// <param name="url"> </param> |
| | | /// <returns></returns> |
| | | /// <exception cref="Exception"></exception> |
| | | public List<OutCommandDto> IssuePlnOutHouseWcs(OutModePalletVm model, int userId) |
| | | { |
| | | try |
| | | { |
| | | string strMsg = ""; |
| | | var outDto1 = new List<OutCommandDto>(); //先出库数据的集合(深度为1的储位) |
| | | var outDto2 = new List<OutCommandDto>(); //后出库数据的集合(深度为2的储位) |
| | | var moveDto = new List<OutCommandDto>(); //要移库数据的集合 |
| | | //获取当前时间 |
| | | DateTime serverTime = Db.GetDate(); |
| | | //获取库存明细是否小于等于该垛数 |
| | | string str = "select * from DataStockDetail where IsDel = '0' and SkuNo = '100099' and Status = '0' "; |
| | | var stockDetail = Db.Ado.SqlQuery<DataStockDetail>(str); |
| | | if (stockDetail.Count > 0) |
| | | { |
| | | //判断是否大于需要垛数 |
| | | if (stockDetail.Count < int.Parse(model.Num)) |
| | | { |
| | | throw new Exception("需要垛数大于库存垛数,请重新输入!"); |
| | | } |
| | | } |
| | | //获取库存总表信息 |
| | | var stock = Db.Queryable<DataStock>().First(s => s.IsDel == "0" && s.SkuNo == "100099"); |
| | | //验证库存总表是否为空 |
| | | if (stock == null) |
| | | { |
| | | throw new Exception("库存信息不存在,请核查!"); |
| | | } |
| | | |
| | | var com = new Common(); |
| | | Db.BeginTran(); |
| | | |
| | | //遍历库存信息 |
| | | foreach (var s in stockDetail) |
| | | { |
| | | //if (outDto1.Contains(m=>m.PalletNo == s.PalletNo) >0) |
| | | //{ |
| | | // continue; |
| | | //} |
| | | //获取储位信息 |
| | | var locat = Db.Queryable<SysStorageLocat>().First(l => l.LocatNo == s.LocatNo && l.IsDel == "0" && l.WareHouseNo == "W01"); |
| | | if (locat == null) |
| | | { |
| | | continue; |
| | | } |
| | | |
| | | ////更改储位状态为出库中 |
| | | //locat.Status = "3"; //3 出库中 |
| | | //locat.UpdateTime = serverTime; //修改时间 |
| | | //locat.UpdateUser = userId; //修改人 |
| | | ////修改储位信息 |
| | | //Db.Updateable(locat).ExecuteCommand(); |
| | | |
| | | if (locat.Status == "1") |
| | | { |
| | | if (locat.Depth == "01") //深度为1 |
| | | { |
| | | #region 改变库存 |
| | | |
| | | //增加库存锁定数量 |
| | | stock.LockQty += (int)s.Qty; //锁定数量 |
| | | stock.UpdateTime = serverTime; //修改时间 |
| | | stock.UpdateUser = 0; //修改人 |
| | | Db.Updateable(stock).ExecuteCommand();//修改库存总表信息 |
| | | |
| | | //增加库存明细锁定数量 |
| | | s.LockQty += (int)s.Qty; //锁定数量 |
| | | s.UpdateTime = serverTime; //修改时间 |
| | | s.UpdateUser = userId; //修改人 |
| | | s.Status = "2"; //2 已分配 |
| | | Db.Updateable(s).ExecuteCommand();//修改库存明细信息 |
| | | |
| | | #endregion |
| | | |
| | | #region 分配 |
| | | |
| | | //添加分配表信息 |
| | | var allot = new BllExportAllot |
| | | { |
| | | SONo = "", |
| | | WaveNo = "", |
| | | SODetailNo = 0, |
| | | StockId = s.Id, |
| | | LotNo = "", |
| | | LotText = "", |
| | | SupplierLot = "", |
| | | SkuNo = s.SkuNo, |
| | | SkuName = s.SkuName, |
| | | Standard = s.Standard, |
| | | PalletNo = s.PalletNo, |
| | | IsBale = "0", //是否裹包 |
| | | IsBelt = "0", //是否打带 |
| | | |
| | | //BoxexQty = s.Qty, |
| | | Qty = (int)s.Qty, |
| | | CompleteQty = 0, |
| | | Status = "1", |
| | | LogisticsId = 0, |
| | | IsAdvance = "0", |
| | | OutMode = model.OutMode,//出库口 |
| | | |
| | | CreateUser = userId, |
| | | CreateTime = DateTime.Now |
| | | }; |
| | | Db.Insertable(allot).ExecuteCommand(); |
| | | |
| | | #endregion |
| | | |
| | | #region 添加出库任务信息 |
| | | |
| | | var taskNo = new Common().GetMaxNo("TK"); |
| | | var exTask = new LogTask //出库任务 |
| | | { |
| | | TaskNo = taskNo, |
| | | Sender = "WMS", |
| | | Receiver = "WCS", |
| | | IsSuccess = 1, //是否下发成功 0失败 1成功 |
| | | |
| | | StartLocat = locat == null ? "" : s.LocatNo,//起始位置 |
| | | EndLocat = model.OutMode,//目标位置 |
| | | PalletNo = s.PalletNo,//托盘码 |
| | | IsSend = 1,//是否可再次下发 |
| | | IsCancel = 1,//是否可取消 |
| | | IsFinish = 1,//是否可完成 |
| | | Type = "1",//任务类型 0 入库任务 1 出库任务 2 移库任务 |
| | | Status = "1",//任务状态0:等待执行1正在执行2执行完成 |
| | | OrderType = "1",//0 入库单 1 出库单 2 盘点单 3 移库单 |
| | | CreateTime = serverTime, //创建时间 |
| | | CreateUser = userId, //创建人 |
| | | Msg = "WCS空托从" + locat == null ? "" : s.LocatNo + "到" + model.OutMode + "的出库任务", //关键信息 |
| | | //FinishDate = serverTime, //完成时间 |
| | | }; |
| | | outDto1.Add(new OutCommandDto() |
| | | { |
| | | PalletNo = exTask.PalletNo,//托盘号 |
| | | StartLocate = exTask.StartLocat, // 起始位置 |
| | | StartRoadway = locat.RoadwayNo, //所属巷道 |
| | | EndLocate = model.OutMode, // 目标位置 |
| | | TaskNo = exTask.TaskNo, // 任务号 |
| | | TaskType = "1",// 任务类型 (出库) |
| | | OutMode = model.OutMode, //目标地址 |
| | | Order = 1 |
| | | }); |
| | | Db.Insertable(exTask).ExecuteCommand(); |
| | | |
| | | #endregion |
| | | |
| | | #region 储位状态变更 |
| | | //更改储位状态为出库中 |
| | | locat.Status = "3"; //3 出库中 |
| | | Db.Updateable(locat).ExecuteCommand();//修改储位信息 |
| | | #endregion |
| | | } |
| | | else if (locat.Depth == "02") //深度为2 |
| | | { |
| | | //获取出库深度为2储位前面的储位信息 |
| | | var sql2 = $@"select * from SysStorageLocat where WareHouseNo = '{locat.WareHouseNo}' and row = {locat.Row} and [Column] = {locat.Column} and Layer = {locat.Layer} and Depth = '01'; "; |
| | | var slotBefore = Db.Ado.SqlQuery<SysStorageLocat>(sql2).First(); |
| | | if (slotBefore == null) |
| | | { |
| | | #region 改变库存 |
| | | |
| | | //增加库存锁定数量 |
| | | stock.LockQty += (int)s.Qty; //锁定数量 |
| | | stock.UpdateTime = serverTime; //修改时间 |
| | | //stock.UpdateUser = userId; //修改人 |
| | | Db.Updateable(stock).ExecuteCommand();//修改库存总表信息 |
| | | |
| | | //增加库存明细锁定数量 |
| | | s.LockQty += (int)s.Qty; //锁定数量 |
| | | s.UpdateTime = serverTime; //修改时间 |
| | | s.UpdateUser = userId; //修改人 |
| | | s.Status = "2"; //2 已分配 |
| | | Db.Updateable(s).ExecuteCommand();//修改库存明细信息 |
| | | |
| | | #endregion |
| | | |
| | | #region 分配 |
| | | |
| | | //添加分配表信息 |
| | | var allot = new BllExportAllot |
| | | { |
| | | SONo = "", |
| | | WaveNo = "", |
| | | SODetailNo = 0, |
| | | StockId = s.Id, |
| | | LotNo = "", |
| | | LotText = "", |
| | | SupplierLot = "", |
| | | SkuNo = s.SkuNo, |
| | | SkuName = s.SkuName, |
| | | Standard = s.Standard, |
| | | PalletNo = s.PalletNo, |
| | | IsBale = "0", //是否裹包 |
| | | IsBelt = "0", //是否打带 |
| | | |
| | | //BoxexQty = s.Qty, |
| | | Qty = (int)s.Qty, |
| | | CompleteQty = 0, |
| | | Status = "1", |
| | | LogisticsId = 0, |
| | | IsAdvance = "0", |
| | | OutMode = model.OutMode,//出库口 |
| | | |
| | | CreateUser = userId, |
| | | CreateTime = DateTime.Now |
| | | }; |
| | | Db.Insertable(allot).ExecuteCommand(); |
| | | |
| | | #endregion |
| | | |
| | | #region 添加出库任务信息 |
| | | |
| | | var taskNo = new Common().GetMaxNo("TK"); |
| | | var exTask = new LogTask //出库任务 |
| | | { |
| | | TaskNo = taskNo, |
| | | Sender = "WMS", |
| | | Receiver = "WCS", |
| | | IsSuccess = 1, //是否下发成功 0失败 1成功 |
| | | |
| | | StartLocat = locat == null ? "" : s.LocatNo,//起始位置 |
| | | EndLocat = model.OutMode,//目标位置 |
| | | PalletNo = s.PalletNo,//托盘码 |
| | | IsSend = 1,//是否可再次下发 |
| | | IsCancel = 1,//是否可取消 |
| | | IsFinish = 1,//是否可完成 |
| | | Type = "1",//任务类型 0 入库任务 1 出库任务 2 移库任务 |
| | | Status = "1",//任务状态0:等待执行1正在执行2执行完成 |
| | | OrderType = "1",//0 入库单 1 出库单 2 盘点单 3 移库单 |
| | | CreateTime = serverTime, //创建时间 |
| | | CreateUser = userId, //创建人 |
| | | Msg = "WCS空托从" + locat == null ? "" : s.LocatNo + "到" + model.OutMode + "的出库任务", //关键信息 |
| | | //FinishDate = serverTime, //完成时间 |
| | | }; |
| | | outDto1.Add(new OutCommandDto() |
| | | { |
| | | PalletNo = exTask.PalletNo,//托盘号 |
| | | StartLocate = exTask.StartLocat, // 起始位置 |
| | | StartRoadway = locat.RoadwayNo, //所属巷道 |
| | | EndLocate = model.OutMode, // 目标位置 |
| | | TaskNo = exTask.TaskNo, // 任务号 |
| | | TaskType = "1",// 任务类型 (出库) |
| | | OutMode = model.OutMode, //目标地址 |
| | | Order = 1 |
| | | }); |
| | | Db.Insertable(exTask).ExecuteCommand(); |
| | | |
| | | #endregion |
| | | |
| | | #region 储位状态变更 |
| | | //更改储位状态为出库中 |
| | | locat.Status = "3"; //3 出库中 |
| | | Db.Updateable(locat).ExecuteCommand();//修改储位信息 |
| | | #endregion |
| | | } |
| | | else |
| | | { |
| | | //判断储位状态 |
| | | if (slotBefore.Status == "0") |
| | | { |
| | | #region 改变库存 |
| | | |
| | | //增加库存锁定数量 |
| | | stock.LockQty += (int)s.Qty; //锁定数量 |
| | | stock.UpdateTime = serverTime; //修改时间 |
| | | //stock.UpdateUser = userId; //修改人 |
| | | Db.Updateable(stock).ExecuteCommand();//修改库存总表信息 |
| | | |
| | | //增加库存明细锁定数量 |
| | | s.LockQty += (int)s.Qty; //锁定数量 |
| | | s.UpdateTime = serverTime; //修改时间 |
| | | s.UpdateUser = userId; //修改人 |
| | | s.Status = "2"; //2 已分配 |
| | | Db.Updateable(s).ExecuteCommand();//修改库存明细信息 |
| | | |
| | | #endregion |
| | | |
| | | #region 分配 |
| | | |
| | | //添加分配表信息 |
| | | var allot = new BllExportAllot |
| | | { |
| | | SONo = "", |
| | | WaveNo = "", |
| | | SODetailNo = 0, |
| | | StockId = s.Id, |
| | | LotNo = "", |
| | | LotText = "", |
| | | SupplierLot = "", |
| | | SkuNo = s.SkuNo, |
| | | SkuName = s.SkuName, |
| | | Standard = s.Standard, |
| | | PalletNo = s.PalletNo, |
| | | IsBale = "0", //是否裹包 |
| | | IsBelt = "0", //是否打带 |
| | | |
| | | //BoxexQty = s.Qty, |
| | | Qty = (int)s.Qty, |
| | | CompleteQty = 0, |
| | | Status = "1", |
| | | LogisticsId = 0, |
| | | IsAdvance = "0", |
| | | OutMode = model.OutMode,//出库口 |
| | | |
| | | CreateUser = userId, |
| | | CreateTime = DateTime.Now |
| | | }; |
| | | Db.Insertable(allot).ExecuteCommand(); |
| | | |
| | | #endregion |
| | | |
| | | #region 添加出库任务信息 |
| | | |
| | | var taskNo = new Common().GetMaxNo("TK"); |
| | | var exTask = new LogTask //出库任务 |
| | | { |
| | | TaskNo = taskNo, |
| | | Sender = "WMS", |
| | | Receiver = "WCS", |
| | | IsSuccess = 1, //是否下发成功 0失败 1成功 |
| | | |
| | | StartLocat = locat == null ? "" : s.LocatNo,//起始位置 |
| | | EndLocat = model.OutMode,//目标位置 |
| | | PalletNo = s.PalletNo,//托盘码 |
| | | IsSend = 1,//是否可再次下发 |
| | | IsCancel = 1,//是否可取消 |
| | | IsFinish = 1,//是否可完成 |
| | | Type = "1",//任务类型 0 入库任务 1 出库任务 2 移库任务 |
| | | Status = "1",//任务状态0:等待执行1正在执行2执行完成 |
| | | OrderType = "1",//0 入库单 1 出库单 2 盘点单 3 移库单 |
| | | CreateTime = serverTime, //创建时间 |
| | | CreateUser = userId, //创建人 |
| | | Msg = "WCS空托从" + locat == null ? "" : s.LocatNo + "到" + model.OutMode + "的出库任务", //关键信息 |
| | | //FinishDate = serverTime, //完成时间 |
| | | }; |
| | | outDto1.Add(new OutCommandDto() |
| | | { |
| | | PalletNo = exTask.PalletNo,//托盘号 |
| | | StartLocate = exTask.StartLocat, // 起始位置 |
| | | StartRoadway = locat.RoadwayNo, //所属巷道 |
| | | EndLocate = model.OutMode, // 目标位置 |
| | | TaskNo = exTask.TaskNo, // 任务号 |
| | | TaskType = "1",// 任务类型 (出库) |
| | | OutMode = model.OutMode, //目标地址 |
| | | Order = 1 |
| | | }); |
| | | Db.Insertable(exTask).ExecuteCommand(); |
| | | |
| | | #endregion |
| | | |
| | | #region 储位状态变更 |
| | | //更改储位状态为出库中 |
| | | locat.Status = "3"; //3 出库中 |
| | | Db.Updateable(locat).ExecuteCommand();//修改储位信息 |
| | | #endregion |
| | | } |
| | | else if (slotBefore.Status == "1") |
| | | { |
| | | //判断托盘上物料 |
| | | var pallSku = Db.Queryable<DataStockDetail>().First(m => m.SkuNo == "100099" && m.LocatNo == slotBefore.LocatNo); |
| | | if (pallSku == null) //移库 |
| | | { |
| | | #region 分配 |
| | | |
| | | //添加分配表信息 |
| | | var allot = new BllExportAllot |
| | | { |
| | | SONo = "", |
| | | WaveNo = "", |
| | | SODetailNo = 0, |
| | | StockId = s.Id, |
| | | LotNo = "", |
| | | LotText = "", |
| | | SupplierLot = "", |
| | | SkuNo = s.SkuNo, |
| | | SkuName = s.SkuName, |
| | | Standard = s.Standard, |
| | | PalletNo = s.PalletNo, |
| | | IsBale = "0", //是否裹包 |
| | | IsBelt = "0", //是否打带 |
| | | |
| | | //BoxexQty = s.Qty, |
| | | Qty = (int)s.Qty, |
| | | CompleteQty = 0, |
| | | Status = "1", |
| | | LogisticsId = 0, |
| | | IsAdvance = "0", |
| | | OutMode = model.OutMode,//出库口 |
| | | |
| | | CreateUser = userId, |
| | | CreateTime = DateTime.Now |
| | | }; |
| | | Db.Insertable(allot).ExecuteCommand(); |
| | | |
| | | #endregion |
| | | |
| | | #region 添加移库任务信息 |
| | | |
| | | var taskNo = new Common().GetMaxNo("TK"); |
| | | var exTask = new LogTask //出库任务 |
| | | { |
| | | TaskNo = taskNo, |
| | | Sender = "WMS", |
| | | Receiver = "WCS", |
| | | IsSuccess = 1, //是否下发成功 0失败 1成功 |
| | | |
| | | StartLocat = locat == null ? "" : s.LocatNo,//起始位置 |
| | | EndLocat = model.OutMode,//目标位置 |
| | | PalletNo = s.PalletNo,//托盘码 |
| | | IsSend = 1,//是否可再次下发 |
| | | IsCancel = 1,//是否可取消 |
| | | IsFinish = 1,//是否可完成 |
| | | Type = "2",//任务类型 0 入库任务 1 出库任务 2 移库任务 |
| | | Status = "1",//任务状态0:等待执行1正在执行2执行完成 |
| | | OrderType = "1",//0 入库单 1 出库单 2 盘点单 3 移库单 |
| | | CreateTime = serverTime, //创建时间 |
| | | CreateUser = userId, //创建人 |
| | | Msg = "WCS空托从" + locat == null ? "" : s.LocatNo + "到" + model.OutMode + "的移库任务", //关键信息 |
| | | //FinishDate = serverTime, //完成时间 |
| | | }; |
| | | moveDto.Add(new OutCommandDto() |
| | | { |
| | | PalletNo = exTask.PalletNo,//托盘号 |
| | | StartLocate = exTask.StartLocat, // 起始位置 |
| | | StartRoadway = locat.RoadwayNo, //所属巷道 |
| | | EndLocate = model.OutMode, // 目标位置 |
| | | TaskNo = exTask.TaskNo, // 任务号 |
| | | TaskType = "2",// 任务类型 (出库) |
| | | OutMode = model.OutMode, //目标地址 |
| | | Order = 1 |
| | | }); |
| | | Db.Insertable(exTask).ExecuteCommand(); |
| | | |
| | | #endregion |
| | | |
| | | #region 储位状态变更 |
| | | //更改储位状态为移出中 |
| | | slotBefore.Status = "5"; //5 移出中 |
| | | Db.Updateable(slotBefore).ExecuteCommand();//修改储位信息 |
| | | #endregion |
| | | } |
| | | else //出库 |
| | | { |
| | | #region 改变库存 |
| | | |
| | | //增加库存锁定数量 |
| | | stock.LockQty += (int)s.Qty; //锁定数量 |
| | | stock.UpdateTime = serverTime; //修改时间 |
| | | //stock.UpdateUser = userId; //修改人 |
| | | Db.Updateable(stock).ExecuteCommand();//修改库存总表信息 |
| | | |
| | | //增加库存明细锁定数量 |
| | | s.LockQty += (int)s.Qty; //锁定数量 |
| | | s.UpdateTime = serverTime; //修改时间 |
| | | s.UpdateUser = userId; //修改人 |
| | | s.Status = "2"; //2 已分配 |
| | | Db.Updateable(s).ExecuteCommand();//修改库存明细信息 |
| | | |
| | | #endregion |
| | | |
| | | #region 分配 |
| | | |
| | | //添加分配表信息 |
| | | var allot = new BllExportAllot |
| | | { |
| | | SONo = "", |
| | | WaveNo = "", |
| | | SODetailNo = 0, |
| | | StockId = s.Id, |
| | | LotNo = "", |
| | | LotText = "", |
| | | SupplierLot = "", |
| | | SkuNo = s.SkuNo, |
| | | SkuName = s.SkuName, |
| | | Standard = s.Standard, |
| | | PalletNo = s.PalletNo, |
| | | IsBale = "0", //是否裹包 |
| | | IsBelt = "0", //是否打带 |
| | | |
| | | //BoxexQty = s.Qty, |
| | | Qty = (int)s.Qty, |
| | | CompleteQty = 0, |
| | | Status = "1", |
| | | LogisticsId = 0, |
| | | IsAdvance = "0", |
| | | OutMode = model.OutMode,//出库口 |
| | | |
| | | CreateUser = userId, |
| | | CreateTime = DateTime.Now |
| | | }; |
| | | Db.Insertable(allot).ExecuteCommand(); |
| | | |
| | | #endregion |
| | | |
| | | #region 添加出库任务信息 |
| | | |
| | | var taskNo = new Common().GetMaxNo("TK"); |
| | | var exTask = new LogTask //出库任务 |
| | | { |
| | | TaskNo = taskNo, |
| | | Sender = "WMS", |
| | | Receiver = "WCS", |
| | | IsSuccess = 1, //是否下发成功 0失败 1成功 |
| | | |
| | | StartLocat = locat == null ? "" : s.LocatNo,//起始位置 |
| | | EndLocat = model.OutMode,//目标位置 |
| | | PalletNo = s.PalletNo,//托盘码 |
| | | IsSend = 1,//是否可再次下发 |
| | | IsCancel = 1,//是否可取消 |
| | | IsFinish = 1,//是否可完成 |
| | | Type = "1",//任务类型 0 入库任务 1 出库任务 2 移库任务 |
| | | Status = "1",//任务状态0:等待执行1正在执行2执行完成 |
| | | OrderType = "1",//0 入库单 1 出库单 2 盘点单 3 移库单 |
| | | CreateTime = serverTime, //创建时间 |
| | | CreateUser = userId, //创建人 |
| | | Msg = "WCS空托从" + locat == null ? "" : s.LocatNo + "到" + model.OutMode + "的出库任务", //关键信息 |
| | | //FinishDate = serverTime, //完成时间 |
| | | }; |
| | | outDto2.Add(new OutCommandDto() |
| | | { |
| | | PalletNo = exTask.PalletNo,//托盘号 |
| | | StartLocate = exTask.StartLocat, // 起始位置 |
| | | StartRoadway = locat.RoadwayNo, //所属巷道 |
| | | EndLocate = model.OutMode, // 目标位置 |
| | | TaskNo = exTask.TaskNo, // 任务号 |
| | | TaskType = "1",// 任务类型 (出库) |
| | | OutMode = model.OutMode, //目标地址 |
| | | Order = 1 |
| | | }); |
| | | Db.Insertable(exTask).ExecuteCommand(); |
| | | |
| | | #endregion |
| | | #region 储位状态变更 |
| | | //更改储位状态为出库中 |
| | | slotBefore.Status = "3"; //3 出库中 |
| | | Db.Updateable(slotBefore).ExecuteCommand();//修改储位信息 |
| | | #endregion |
| | | } |
| | | if (int.Parse(model.Num) == outDto1.Count + outDto2.Count) |
| | | { |
| | | break;//需求垛数已达到 可以出库了 |
| | | } |
| | | else |
| | | { |
| | | #region 改变库存 |
| | | |
| | | //增加库存锁定数量 |
| | | stock.LockQty += (int)s.Qty; //锁定数量 |
| | | stock.UpdateTime = serverTime; //修改时间 |
| | | //stock.UpdateUser = userId; //修改人 |
| | | Db.Updateable(stock).ExecuteCommand();//修改库存总表信息 |
| | | |
| | | //增加库存明细锁定数量 |
| | | s.LockQty += (int)s.Qty; //锁定数量 |
| | | s.UpdateTime = serverTime; //修改时间 |
| | | s.UpdateUser = userId; //修改人 |
| | | s.Status = "2"; //2 已分配 |
| | | Db.Updateable(s).ExecuteCommand();//修改库存明细信息 |
| | | |
| | | #endregion |
| | | |
| | | #region 分配 |
| | | |
| | | //添加分配表信息 |
| | | var allot = new BllExportAllot |
| | | { |
| | | SONo = "", |
| | | WaveNo = "", |
| | | SODetailNo = 0, |
| | | StockId = s.Id, |
| | | LotNo = "", |
| | | LotText = "", |
| | | SupplierLot = "", |
| | | SkuNo = s.SkuNo, |
| | | SkuName = s.SkuName, |
| | | Standard = s.Standard, |
| | | PalletNo = s.PalletNo, |
| | | IsBale = "0", //是否裹包 |
| | | IsBelt = "0", //是否打带 |
| | | |
| | | //BoxexQty = s.Qty, |
| | | Qty = (int)s.Qty, |
| | | CompleteQty = 0, |
| | | Status = "1", |
| | | LogisticsId = 0, |
| | | IsAdvance = "0", |
| | | OutMode = model.OutMode,//出库口 |
| | | |
| | | CreateUser = userId, |
| | | CreateTime = DateTime.Now |
| | | }; |
| | | Db.Insertable(allot).ExecuteCommand(); |
| | | |
| | | #endregion |
| | | |
| | | #region 添加出库任务信息 |
| | | |
| | | var taskNo = new Common().GetMaxNo("TK"); |
| | | var exTask = new LogTask //出库任务 |
| | | { |
| | | TaskNo = taskNo, |
| | | Sender = "WMS", |
| | | Receiver = "WCS", |
| | | IsSuccess = 1, //是否下发成功 0失败 1成功 |
| | | |
| | | StartLocat = locat == null ? "" : s.LocatNo,//起始位置 |
| | | EndLocat = model.OutMode,//目标位置 |
| | | PalletNo = s.PalletNo,//托盘码 |
| | | IsSend = 1,//是否可再次下发 |
| | | IsCancel = 1,//是否可取消 |
| | | IsFinish = 1,//是否可完成 |
| | | Type = "1",//任务类型 0 入库任务 1 出库任务 2 移库任务 |
| | | Status = "1",//任务状态0:等待执行1正在执行2执行完成 |
| | | OrderType = "1",//0 入库单 1 出库单 2 盘点单 3 移库单 |
| | | CreateTime = serverTime, //创建时间 |
| | | CreateUser = userId, //创建人 |
| | | Msg = "WCS空托从" + locat == null ? "" : s.LocatNo + "到" + model.OutMode + "的出库任务", //关键信息 |
| | | //FinishDate = serverTime, //完成时间 |
| | | }; |
| | | outDto2.Add(new OutCommandDto() |
| | | { |
| | | PalletNo = exTask.PalletNo,//托盘号 |
| | | StartLocate = exTask.StartLocat, // 起始位置 |
| | | StartRoadway = locat.RoadwayNo, //所属巷道 |
| | | EndLocate = model.OutMode, // 目标位置 |
| | | TaskNo = exTask.TaskNo, // 任务号 |
| | | TaskType = "1",// 任务类型 (出库) |
| | | OutMode = model.OutMode, //目标地址 |
| | | Order = 1 |
| | | }); |
| | | Db.Insertable(exTask).ExecuteCommand(); |
| | | |
| | | #endregion |
| | | #region 储位状态变更 |
| | | |
| | | //更改储位状态为出库中 |
| | | locat.Status = "3"; //3 出库中 |
| | | Db.Updateable(locat).ExecuteCommand();//修改储位信息 |
| | | #endregion |
| | | } |
| | | } |
| | | } |
| | | } |
| | | } |
| | | if (int.Parse(model.Num) == outDto1.Count + outDto2.Count) |
| | | { |
| | | break;//需求垛数已达到 可以出库了 |
| | | } |
| | | } |
| | | outDto1.AddRange(moveDto); |
| | | outDto1.AddRange(outDto2); |
| | | if (outDto1.Count <= 0) |
| | | { |
| | | throw new Exception("暂无出库任务,请核查!"); |
| | | } |
| | | |
| | | //添加操作日志记录 |
| | | var k = new OperationSOServer().AddLogOperationSo("PDA模块", "空托出库", int.Parse(model.Num) + "", "下发", $"WCS下发了 {int.Parse(model.Num)} 个空托垛", userId); |
| | | Db.CommitTran(); |
| | | |
| | | return outDto1; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | Db.RollbackTran(); |
| | | throw new Exception(e.Message); |
| | | } |
| | | } |
| | | |
| | | |
| | | public string MoveAddress(string oldAddress, string roadWay, string skuNo)//01020201 排-列-层-深度 |
| | | { |
| | | string nowAddress = ""; |