using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using WIDESEA_Core.Enums; using WIDESEA_Core; using WIDESEA_DTO.Stock; using WIDESEA_Model.Models; using WIDESEA_Core.Helper; using Newtonsoft.Json; using WIDESEA_DTO.WCSInfo; using WIDESEAWCS_DTO.WCSInfo; using Microsoft.AspNetCore.DataProtection.KeyManagement; using WIDESEA_Common.TaskEnum; using System.Collections; namespace WIDESEA_TaskInfoService { public partial class TaskService { /// /// 库存数据转出库任务 /// /// /// public List GetTasks(List stockInfos) { List tasks = new List(); for (int i = 0; i < stockInfos.Count; i++) { Dt_StockInfo stockInfo = stockInfos[i]; if (stockInfo != null) { Dt_LocationInfo locationInfo = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == stockInfo.LocationCode); Dt_RoadwayInfo roadwayInfo = _basicService.RoadwayInfoService.Repository.QueryFirst(x => x.RoadwayNo == locationInfo.RoadwayNo); if (roadwayInfo != null) { Dt_Task task = new() { CurrentAddress = stockInfo.LocationCode, Grade = 0, PalletCode = stockInfo.PalletCode, NextAddress = roadwayInfo.OutSCStationCode, Roadway = locationInfo.RoadwayNo, SourceAddress = stockInfo.LocationCode, TargetAddress = roadwayInfo.OutStationCode, TaskState = OutTaskStatusEnum.OutNew.ObjToInt(), TaskType = TaskTypeEnum.Outbound.ObjToInt(), TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum)) //TaskNum = Convert.ToInt32(DateTime.Now.ToString("HHmmss")), }; tasks.Add(task); } } } return tasks; } /// /// 出库任务数据处理 /// /// /// /// /// public (List?, List?, List?, List?, List?, List?, Dt_OutboundOrder?) OutboundTaskDataHandle(int[] keys) { List tasks = new List(); List outboundOrderDetails = _outboundService.OutboundOrderDetailService.Repository.QueryData(x => keys.Contains(x.Id)); if (outboundOrderDetails == null || outboundOrderDetails.Count == 0) { throw new Exception("未找到出库单明细信息"); } if (outboundOrderDetails.FirstOrDefault(x => x.OrderDetailStatus > OrderDetailStatusEnum.New.ObjToInt()) != null) { throw new Exception("所选出库单明细存在出库中或已完成"); } List? stockInfos = new List(); List? orderDetails = null; List? outStockLockInfos = null; List? locationInfos = null; List? locationInfos1 = null; Dt_OutboundOrder? outboundOrder = null; (List?, List?, List?, List?, Dt_OutboundOrder?) result = _outboundService.OutboundOrderDetailService.AssignStockOutbound(outboundOrderDetails); if (result.Item1 != null && result.Item1.Count > 0) { (List?, List?, List?) result1 = GetTasks(result.Item1, TaskTypeEnum.Outbound, result.Item4); tasks = result1.Item1; locationInfos1 = result1.Item2; stockInfos.AddRange(result1.Item3); stockInfos.AddRange(result.Item1); orderDetails = result.Item2; outStockLockInfos = result.Item3; locationInfos = result.Item4; outboundOrder = result.Item5; } else { throw new Exception("无库存"); } return (tasks, stockInfos, orderDetails, outStockLockInfos, locationInfos, locationInfos1, outboundOrder); } /// /// 库存数据转出库任务 /// /// /// public (List?, List?, List?) GetTasks(List stockInfos, TaskTypeEnum taskType, List? locationInfos) { List tasks = new List(); List locations = new List(); List stocks = new List(); foreach (var item in stockInfos.GroupBy(x => x.LocationCode)) { Dt_LocationInfo locationInfo = locationInfos.First(x => x.LocationCode == item.Key); (List?, List?, List?) result = GetRelocationTask(locationInfo); tasks.AddRange(result.Item1);//移库任务 locations.AddRange(result.Item2);//移库货位 stocks.AddRange(result.Item3);//移库库存 foreach (var stockInfo in item.OrderByDescending(x => x.SerialNumber)) { if (!tasks.Exists(x => x.PalletCode == stockInfo.PalletCode)) { Dt_Task task = new() { CurrentAddress = stockInfo.LocationCode, Grade = 0, PalletCode = stockInfo.PalletCode, TargetIsPickPlace = false, SourceIsPickPlace = locationInfo.Row == 1 ? false : stockInfo.SerialNumber == locationInfo.MaxQty, NextAddress = "1008", Roadway = locationInfo.RoadwayNo, SourceAddress = stockInfo.LocationCode, TargetAddress = "1008", TaskState = TaskOutStatusEnum.OutNew.ObjToInt(), TaskType = taskType.ObjToInt(), TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum)) }; tasks.Add(task); } } } return (tasks, locations, stocks); } /// /// 获取移库任务 /// /// /// /// public (List?, List?, List?) GetRelocationTask(Dt_LocationInfo locationInfo) { List dt_Tasks = new List(); List locationInfos = new List(); List stockInfos = new List(); if (locationInfo.Row == 1) { var locationInfo1 = _basicService.LocationInfoService.Repository.QueryFirst(x => x.Row == 2 && x.Column == locationInfo.Column && x.Layer == locationInfo.Layer); stockInfos = _stockService.StockInfoService.Repository.QueryData(x => locationInfo1.LocationCode == x.LocationCode).OrderByDescending(x => x.SerialNumber).ToList(); if (stockInfos == null || stockInfos.Count < 1) { return (dt_Tasks, locationInfos, stockInfos); } Dt_LocationInfo? locationInfo2 = _basicService.LocationInfoService.AssignLocation(); if (locationInfo2 == null) throw new Exception("无可移库货位"); locationInfo1.LocationStatus = LocationStatusEnum.Relocationing.ObjToInt(); locationInfo2.LocationStatus = LocationStatusEnum.Relocationing.ObjToInt(); locationInfos.Add(locationInfo1); locationInfos.Add(locationInfo2); int i = 1; foreach (var item in stockInfos) { Dt_Task task = new() { CurrentAddress = item.LocationCode, SourceIsPickPlace = item.SerialNumber == 12, TargetIsPickPlace = i == 12 ? locationInfo2.Row != 1 : false, Grade = 0, PalletCode = item.PalletCode, NextAddress = locationInfo2.LocationCode, Roadway = locationInfo.RoadwayNo, SourceAddress = item.LocationCode, TargetAddress = locationInfo2.LocationCode, TaskState = WIDESEA_Common.TaskEnum.TaskRelocationStatusEnum.RelocationNew.ObjToInt(), TaskType = TaskRelocationTypeEnum.Relocation.ObjToInt(), TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum)) }; if (locationInfo2.Row == 1) task.TargetIsPickPlace = false; dt_Tasks.Add(task); i++; item.StockStatus = StockStatusEmun.移库中.ObjToInt(); } } return (dt_Tasks, locationInfos, stockInfos); } /// /// 出库任务数据处理/指定出库单出库 /// /// /// /// /// public (List, List?, List?, List?, List?) OutboundTaskDataHandle(int orderDetailId, List stockSelectViews) { List tasks = new List(); Dt_OutboundOrderDetail outboundOrderDetail = _outboundService.OutboundOrderDetailService.Repository.QueryFirst(x => x.Id == orderDetailId); if (outboundOrderDetail == null) throw new Exception("未找到出库单明细信息"); if (outboundOrderDetail.OrderDetailStatus != OrderDetailStatusEnum.New.ObjToInt()) throw new Exception("所选出库单明细存在出库中或已完成"); Dt_OutboundOrder outboundOrder = _outboundService.OutboundOrderService.Repository.QueryFirst(x => x.Id == outboundOrderDetail.OrderId); outboundOrder.Details = new List { outboundOrderDetail }; List? stockInfos = null; Dt_OutboundOrderDetail? orderDetail = null; List? outStockLockInfos = null; List? locationInfos = null; List? locationInfos1 = null; (List, List, List) result = _outboundService.OutboundOrderDetailService.AssignStockOutbound(outboundOrder, stockSelectViews); if (result.Item1 != null && result.Item1.Count > 0) { } else { throw new Exception("无库存"); } return (tasks, stockInfos, orderDetail == null ? null : new List { orderDetail }, outStockLockInfos, locationInfos); } /// /// 生成出库任务 /// /// /// /// public WebResponseContent GenerateOutboundTask(int orderDetailId, List stockSelectViews) { try { (List, List?, List?, List?, List?) result = OutboundTaskDataHandle(orderDetailId, stockSelectViews); WebResponseContent content = GenerateOutboundTaskDataUpdate(result.Item1, result.Item2, result.Item3, result.Item4, result.Item5); return content; } catch (Exception ex) { return WebResponseContent.Instance.Error(ex.Message); } } public WebResponseContent GenerateOutboundTaskDataUpdate(List tasks, List? stockInfos = null, List? outboundOrderDetails = null, List? outStockLockInfos = null, List? locationInfos = null, List? locationInfos1 = null, Dt_OutboundOrder? order = null) { try { _unitOfWorkManage.BeginTran(); BaseDal.AddData(tasks); if (stockInfos != null && stockInfos.Count > 0 && outboundOrderDetails != null && outboundOrderDetails.Count > 0 && outStockLockInfos != null && outStockLockInfos.Count > 0 && locationInfos != null && locationInfos.Count > 0) { List addOutStockLockInfos = outStockLockInfos.Where(x => x.Id == 0).ToList(); if (addOutStockLockInfos != null && addOutStockLockInfos.Any()) { if (tasks != null) { addOutStockLockInfos.ForEach(x => { x.TaskNum = tasks.FirstOrDefault(v => v.PalletCode == x.PalletCode)?.TaskNum; }); } _outboundService.OutboundStockLockInfoService.Repository.AddData(addOutStockLockInfos); } List updateOutStockLockInfos = outStockLockInfos.Where(x => x.Id > 0).ToList(); if (updateOutStockLockInfos != null && updateOutStockLockInfos.Any()) { _outboundService.OutboundStockLockInfoService.Repository.UpdateData(updateOutStockLockInfos); } _stockService.StockInfoService.Repository.UpdateData(stockInfos); _basicRepository.LocationInfoRepository.UpdateData(locationInfos); _basicRepository.LocationInfoRepository.UpdateData(locationInfos1); _outboundService.OutboundOrderService.Repository.UpdateData(order); _outboundService.OutboundOrderDetailService.Repository.UpdateData(outboundOrderDetails); } else if (outboundOrderDetails != null && outboundOrderDetails.Count > 0) { _outboundService.OutboundOrderDetailService.Repository.UpdateData(outboundOrderDetails); } #region 下发任务给WCS List wMSTaskDTOs = _mapper.Map>(tasks); var ResultData = HttpHelper.PostAsync(WCSInterfaceAddress.ReceiveTask, wMSTaskDTOs.ToJson(), headers: new Dictionary()); if (ResultData.Result == null) throw new Exception($"向WCS下发出库任务超时"); WebResponseContent content = JsonConvert.DeserializeObject(ResultData.Result); if (content == null) throw new Exception($"下发出库任务WCS无响应"); if (!content.Status) throw new Exception(content.Message); #endregion _unitOfWorkManage.CommitTran(); return WebResponseContent.Instance.OK(); } catch (Exception ex) { _unitOfWorkManage.RollbackTran(); return WebResponseContent.Instance.Error(ex.Message); } } /// /// 生成出库任务后数据更新到数据库 /// /// /// /// /// /// /// public WebResponseContent GenerateOutboundTaskDataUpdate(List tasks, List? stockInfos = null, List? outboundOrderDetails = null, List? outStockLockInfos = null, List? locationInfos = null) { try { _unitOfWorkManage.BeginTran(); #region 生成移库任务 List taskList = new List(); List dt_StockInfos = _stockService.StockInfoService.Repository.LocationCodesGetStockInfos(tasks.Select(x => x.SourceAddress).ToList()); List dt_stockInfos = dt_StockInfos.Where(x => x.StockStatus == StockStatusEmun.出库锁定.ObjToInt() || tasks.Select(x => x.PalletCode).ToList().Contains(x.PalletCode)).ToList();//待出库库存 dt_StockInfos = dt_StockInfos.Where(x => !dt_stockInfos.Select(x => x.Id).ToList().Contains(x.Id)).ToList();//排除待出库库存 if (dt_StockInfos.Count > 0) { foreach (var dt_stockInfo in dt_stockInfos) { foreach (var dt_StockInfo in dt_StockInfos.Where(x => x.LocationCode == dt_stockInfo.LocationCode)) { if (dt_StockInfo.InDate > dt_stockInfo.InDate) { dt_StockInfo.StockStatus = StockStatusEmun.移库中.ObjToInt(); dt_stockInfo.Details.ForEach(x => { x.Status = StockStatusEmun.移库中.ObjToInt(); }); } } } List stockInfoDetails = dt_StockInfos.Where(x => x.StockStatus == StockStatusEmun.移库中.ObjToInt()).Select(x => x.Details).ToList().OfType().ToList();//待移库详情 foreach (var stockInfoDetail in stockInfoDetails.GroupBy(x => x.MaterielCode)) { foreach (var item in stockInfoDetail.GroupBy(x => x.BatchNo)) { var locationInfo = _basicService.LocationInfoService.AssignLocation(item.Count());//重新分配货位 var stockInfo = dt_StockInfos.Where(x => x.Id == item.First().StockId).First(); foreach (var infoDetail in item) { Dt_Task task = new Dt_Task() { CurrentAddress = stockInfo.LocationCode, Grade = 2, PalletCode = stockInfo.PalletCode, NextAddress = locationInfo.LocationCode, Roadway = locationInfo.RoadwayNo, SourceAddress = stockInfo.LocationCode, TargetAddress = locationInfo.LocationCode, TaskState = WIDESEA_Common.TaskEnum.TaskRelocationStatusEnum.RelocationNew.ObjToInt(), TaskType = TaskTypeEnum.Relocation.ObjToInt(), TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum)), }; taskList.Add(task); } stockInfo.LocationCode = locationInfo.LocationCode; } } } tasks.AddRange(taskList); #endregion BaseDal.AddData(tasks); #region 下发任务给WCS List wMSTaskDTOs = _mapper.Map>(tasks); var ResultData = HttpHelper.PostAsync(WCSInterfaceAddress.ReceiveTask, wMSTaskDTOs.ToJson(), headers: new Dictionary()); if (ResultData.Result == null) throw new Exception($"向WCS下发出库任务超时"); WebResponseContent content = JsonConvert.DeserializeObject(ResultData.Result); if (content == null) throw new Exception($"下发出库任务WCS无响应"); if (!content.Status) throw new Exception(content.Message); #endregion if (stockInfos != null && outboundOrderDetails != null && outStockLockInfos != null && locationInfos != null) { content = _outboundService.OutboundOrderDetailService.LockOutboundStockDataUpdate(stockInfos, outboundOrderDetails, outStockLockInfos, locationInfos, tasks: tasks); if (content.Status) { _unitOfWorkManage.CommitTran(); } else { _unitOfWorkManage.RollbackTran(); } return content; } else if (outboundOrderDetails != null && outboundOrderDetails.Count > 0) { outboundOrderDetails.ForEach(x => { x.OrderDetailStatus = OrderDetailStatusEnum.Outbound.ObjToInt(); }); _outboundService.OutboundOrderDetailService.Repository.UpdateData(outboundOrderDetails); } _unitOfWorkManage.CommitTran(); return WebResponseContent.Instance.OK(); } catch (Exception ex) { _unitOfWorkManage.RollbackTran(); return WebResponseContent.Instance.Error(ex.Message); } } /// /// 生成出库任务 /// /// /// public WebResponseContent GenerateOutboundTask(int[] keys) { try { List tasks = new List(); List stockSelectViews = new List(); List stockInfos = new List(); List outboundOrderDetails = new List(); List outStockLockInfos = new List(); List locationInfos = new List(); List locationInfos1 = new List(); Dt_OutboundOrder order = new Dt_OutboundOrder(); #region 出库任务数据处理 (List?, List?, List?, List?, List?, List?, Dt_OutboundOrder?) result = OutboundTaskDataHandle(keys); if (result.Item1 != null && result.Item1.Count > 0) { tasks.AddRange(result.Item1); } if (result.Item2 != null && result.Item2.Count > 0) { stockInfos.AddRange(result.Item2); } if (result.Item3 != null && result.Item3.Count > 0) { outboundOrderDetails.AddRange(result.Item3); } if (result.Item4 != null && result.Item4.Count > 0) { outStockLockInfos.AddRange(result.Item4); } if (result.Item5 != null && result.Item5.Count > 0) { locationInfos.AddRange(result.Item5); } if (result.Item6 != null && result.Item6.Count > 0) { locationInfos1.AddRange(result.Item6); } if (result.Item7 != null) { order = result.Item7; } #endregion //WebResponseContent content = GenerateOutboundTaskDataUpdate(tasks, stockInfos, outboundOrderDetails, outStockLockInfos, locationInfos); WebResponseContent content = GenerateOutboundTaskDataUpdate(tasks, stockInfos, outboundOrderDetails, outStockLockInfos, locationInfos, locationInfos1, order); return content; } catch (Exception ex) { _unitOfWorkManage.RollbackTran(); return WebResponseContent.Instance.Error(ex.Message); } } /// /// 空托盘出库任务 /// /// /// public WebResponseContent PalletOutboundTask(string roadwayNo, string endStation) { try { Dt_StockInfo stockInfo = _stockService.StockInfoService.Repository.GetPalletStockInfo(roadwayNo); if (stockInfo == null) { return WebResponseContent.Instance.Error("未找到空托盘库存"); } Dt_LocationInfo locationInfo = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == stockInfo.LocationCode && x.RoadwayNo == roadwayNo); if (locationInfo == null) { return WebResponseContent.Instance.Error("未找到空托盘库存对应的货位信息"); } Dt_RoadwayInfo roadwayInfo = _basicService.RoadwayInfoService.Repository.QueryFirst(x => x.InStationCode == endStation && x.RoadwayNo == roadwayNo); if (roadwayInfo == null) { return WebResponseContent.Instance.Error("未找到终点巷道信息"); } Dt_Task task = new Dt_Task() { CurrentAddress = stockInfo.LocationCode, Grade = 0, NextAddress = endStation, PalletCode = stockInfo.PalletCode, Roadway = roadwayNo, SourceAddress = stockInfo.LocationCode, TargetAddress = endStation, TaskState = OutTaskStatusEnum.OutNew.ObjToInt(), TaskType = TaskTypeEnum.PalletOutbound.ObjToInt(), }; _unitOfWorkManage.BeginTran(); stockInfo.StockStatus = StockStatusEmun.出库锁定.ObjToInt(); locationInfo.LocationStatus = LocationStatusEnum.OutLock.ObjToInt(); BaseDal.AddData(task); _unitOfWorkManage.CommitTran(); return WebResponseContent.Instance.OK(); } catch (Exception ex) { return WebResponseContent.Instance.Error(ex.Message); } } } }