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 Microsoft.AspNetCore.Http; using System.Reflection.Metadata; using OfficeOpenXml.FormulaParsing.Excel.Functions.RefAndLookup; using SkiaSharp; using System.Collections; using Newtonsoft.Json; using WIDESEA_Core.Log; using System.Linq.Expressions; using WIDESEA_DTO.Inbound; using WIDESEA_DTO.Task; using OfficeOpenXml.FormulaParsing.Excel.Functions.Text; using System.Drawing.Printing; using WIDESEA_Core.DB; using System.Drawing; using WIDESEA_ITaskInfoService; 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 = 3, PalletCode = stockInfo.PalletCode, NextAddress = roadwayInfo.OutStationCode, Roadway = locationInfo.RoadwayNo, SourceAddress = stockInfo.LocationCode, TargetAddress = roadwayInfo.OutStationCode, TaskStatus = OutTaskStatusEnum.OutNew.ObjToInt(), TaskType = TaskTypeEnum.Outbound.ObjToInt(), Depth = locationInfo.Depth, TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum)) }; tasks.Add(task); } } } return tasks; } /// /// 出库任务数据处理 /// /// /// /// /// 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 (stockSelectViews.Sum(x => x.UseableQuantity) > outboundOrderDetail.OrderQuantity - outboundOrderDetail.LockQuantity) { throw new Exception("选择数量超出单据数量!"); } List? stockInfos = null; Dt_OutboundOrderDetail? orderDetail = null; List? outStockLockInfos = null; List? locationInfos = null; if (outboundOrderDetail.OrderDetailStatus == OrderDetailStatusEnum.New.ObjToInt()) { (List, Dt_OutboundOrderDetail, List, List) result = _outboundService.OutboundOrderDetailService.AssignStockOutbound(outboundOrderDetail, stockSelectViews); if (result.Item1 != null && result.Item1.Count > 0) { tasks = GetTasks(result.Item1); result.Item2.OrderDetailStatus = OrderDetailStatusEnum.Outbound.ObjToInt(); result.Item3.ForEach(x => { x.Status = OutStockStatus.出库中.ObjToInt(); }); stockInfos = result.Item1; orderDetail = result.Item2; outStockLockInfos = result.Item3; locationInfos = result.Item4; } else { throw new Exception("无库存!"); } } else { List stockLockInfos = _outboundService.OutboundStockLockInfoService.GetByOrderDetailId(outboundOrderDetail.OrderId); if (stockLockInfos != null && stockLockInfos.Count > 0) { List stocks = _stockService.StockInfoService.Repository.GetStockInfosByPalletCodes(stockLockInfos.Select(x => x.PalletCode).Distinct().ToList()); tasks = GetTasks(stocks); } } 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) { WebResponseContent content = new WebResponseContent(); try { _unitOfWorkManage.BeginTran(); (List?, List?) result = RelocationTasks(tasks.OrderBy(x => x.Depth).ToList()); if (result.Item1 != null && result.Item1.Count > 0) { AddData(result.Item1); var response = HttpHelper.Post(url + "ReceiveTask/", result.Item1, "出库任务下发"); if (!response.Status) { _unitOfWorkManage.RollbackTran(); return content = WebResponseContent.Instance.Error($"{response.Message}"); } } if (result.Item2 != null && result.Item2.Count > 0) { for (int i = 0; i < result.Item2.Count; i++) { Dt_LocationInfo location = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == result.Item2[i].SourceAddress && x.RoadwayNo == result.Item2[i].Roadway); if (location.Depth == 2) { _basicService.LocationInfoService.UpdateLocationLock(location, result.Item2[i].TaskNum, StockChangeType.Outbound.ObjToInt(), false); } } AddData(result.Item2); var response = HttpHelper.Post(url + "ReceiveTask/", result.Item2, "出库任务下发"); if (!response.Status) { _unitOfWorkManage.RollbackTran(); return content = WebResponseContent.Instance.Error($"{response.Message}"); } } 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(); } } else if (outboundOrderDetails != null && outboundOrderDetails.Count > 0) { outboundOrderDetails.ForEach(x => { x.OrderDetailStatus = OrderDetailStatusEnum.Outbound.ObjToInt(); }); _outboundService.OutboundOrderDetailService.Repository.UpdateData(outboundOrderDetails); } if (outboundOrderDetails != null && outboundOrderDetails.Count() > 0) { for (int i = 0; i < outboundOrderDetails.Count(); i++) { _outboundService.OutboundOrderDetailService.Repository.DeleteAndMoveIntoHty(outboundOrderDetails[i], App.User.UserId == 0 ? OperateType.自动完成 : OperateType.人工完成); Dt_OutboundOrder outboundOrder = _outboundService.OutboundOrderService.Repository.QueryFirst(x => x.Id == outboundOrderDetails[i].OrderId); List outboundOrderDetail = _outboundService.OutboundOrderDetailService.Repository.QueryData(x => x.OrderId == outboundOrder.Id && x.OrderDetailStatus == OrderDetailStatusEnum.New.ObjToInt()).ToList(); if (outboundOrderDetail.Count <= 0) { outboundOrder.OrderStatus = OutboundStatusEnum.出库完成.ObjToInt(); _outboundService.OutboundOrderService.Repository.DeleteAndMoveIntoHty(outboundOrder, App.User.UserId == 0 ? OperateType.自动完成 : OperateType.人工完成); } else { outboundOrder.OrderStatus = OutboundStatusEnum.出库中.ObjToInt(); _outboundService.OutboundOrderService.Repository.UpdateData(outboundOrder); } } } _unitOfWorkManage.CommitTran(); return WebResponseContent.Instance.OK(); } catch (Exception ex) { _unitOfWorkManage.RollbackTran(); return WebResponseContent.Instance.Error(ex.Message); } finally { WriteLog.GetLog("出库任务下发").Write(JsonConvert.SerializeObject(content), "出库任务下发"); } } public (List?, List?) RelocationTasks(List task) { WebResponseContent content = new WebResponseContent(); try { List tasks = new List(); List relocationList = new List(); if (task.Count > 0) { for (int i = 0; i < task.Count; i++) { Dt_LocationInfo location = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == task[i].SourceAddress && x.RoadwayNo == task[i].Roadway); int befoStatus = location.LocationStatus.ObjToInt(); if (location != null) { Dt_LocationInfo result = _basicService.LocationInfoService.isDepth(location); if (result != null && result.LocationStatus != LocationStatusEnum.Lock.ObjToInt() && result.LocationStatus != StatusEnum.PalletLock.ObjToInt() && result.LocationStatus != LocationStatusEnum.Free.ObjToInt()) { int sum = 0; for (int j = 0; j < task.Count; j++) { if (result.LocationCode == task[j].SourceAddress) { sum++; } } if (sum == 0) { Dt_Task relocariontask = RelocationTask(result); task[i].Grade = 2; relocationList.Add(relocariontask); relocationList.Add(task[i]); } else { tasks.Add(task[i]); content = WebResponseContent.Instance.OK(); } } else if (result == null) { tasks.Add(task[i]); content = WebResponseContent.Instance.OK(); } else if (result != null && result.LocationStatus == LocationStatusEnum.Free.ObjToInt()) { tasks.Add(task[i]); content = WebResponseContent.Instance.OK(); } else if (result != null && (result.LocationStatus == LocationStatusEnum.Lock.ObjToInt() || result.LocationStatus == StatusEnum.PalletLock.ObjToInt())) { Dt_Task TaskInfo = BaseDal.QueryFirst(x => x.SourceAddress == result.LocationCode); if (TaskInfo == null) { content = WebResponseContent.Instance.Error("货位被锁定不可出库"); break; } else { tasks.Add(task[i]); content = WebResponseContent.Instance.OK(); } } } else { content = WebResponseContent.Instance.Error("任务异常"); break; } } return (relocationList, tasks); } else { throw new Exception($"生成移库任务失败"); } } catch (Exception ex) { return (null, null); } } /// /// 移库任务 /// /// /// public Dt_Task RelocationTask(Dt_LocationInfo location) { WebResponseContent content = new WebResponseContent(); try { Dt_StockInfo stockInfo = _stockService.StockInfoService.Repository.QueryFirst(x => x.LocationCode == location.LocationCode); if (stockInfo != null) { Dt_LocationInfo? locationInfos = _basicService.LocationInfoService.AssignLocation(location.RoadwayNo); if (locationInfos != null) { Dt_Task tasks = new() { CurrentAddress = location.LocationCode, Grade = 0, PalletCode = stockInfo.PalletCode, NextAddress = locationInfos.LocationCode, Roadway = location.RoadwayNo, SourceAddress = location.LocationCode, TargetAddress = locationInfos.LocationCode, TaskStatus = InTaskStatusEnum.RelocationNew.ObjToInt(), //TaskType = TaskTypeEnum.Relocation.ObjToInt(), Depth = location.Depth, TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum)) }; _basicService.LocationInfoService.RelocationLock(location, locationInfos, tasks.TaskNum); stockInfo.StockStatus = StockStatusEmun.移库锁定.ObjToInt(); _stockService.StockInfoService.Repository.UpdateData(stockInfo); return tasks; } else { throw new Exception($"生成移库任务失败"); } } else { throw new Exception("未找到库存信息"); } } catch (Exception ex) { throw new Exception($"生成移库任务失败"); ; } } /// /// 生成出库任务 /// /// /// 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(); foreach (int key in keys) { (List, List?, List?, List?, List?) result = OutboundTaskDataHandle(key, stockSelectViews); 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.Item1 != null && result.Item1.Count > 0) { tasks.AddRange(result.Item1); } } WebResponseContent content = GenerateOutboundTaskDataUpdate(tasks, stockInfos, outboundOrderDetails, outStockLockInfos, locationInfos); 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("未找到终点巷道信息"); } List tasks = new List(); Dt_Task task = new Dt_Task() { CurrentAddress = stockInfo.LocationCode, Grade = 1, NextAddress = endStation, PalletCode = stockInfo.PalletCode, Roadway = roadwayNo, SourceAddress = stockInfo.LocationCode, TargetAddress = endStation, TaskStatus = OutTaskStatusEnum.OutNew.ObjToInt(), //TaskType = TaskTypeEnum.PalletOutbound.ObjToInt(), Depth = locationInfo.Depth, TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum)) }; int beforeStatus = locationInfo.LocationStatus; _unitOfWorkManage.BeginTran(); stockInfo.StockStatus = StockStatusEmun.出库锁定.ObjToInt(); locationInfo.LocationStatus = LocationStatusEnum.Lock.ObjToInt(); tasks.Add(task); (List?, List?) result = RelocationTasks(tasks.OrderBy(x => x.Depth).ToList()); if (result.Item1 != null && result.Item1.Count > 0) { for (int i = 0; i < result.Item1.Count; i++) { result.Item1[i].Grade = 1; } AddData(result.Item1); var response = HttpHelper.Post(url + "ReceiveTask/", result.Item1, "入库任务下发"); if (!response.Status) { _unitOfWorkManage.RollbackTran(); return WebResponseContent.Instance.Error($"{response.Message}"); } } if (result.Item2 != null && result.Item2.Count > 0) { for (int i = 0; i < result.Item2.Count; i++) { Dt_LocationInfo location = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == result.Item2[i].SourceAddress && x.RoadwayNo == result.Item2[i].Roadway); if (location.Depth == 2) { _basicService.LocationInfoService.UpdateLocationLock(location, result.Item2[i].TaskNum, StockChangeType.Outbound.ObjToInt(), false); } result.Item2[i].Grade = 1; } AddData(result.Item2); var response = HttpHelper.Post(url + "ReceiveTask/", result.Item2, "出库任务下发"); if (!response.Status) { _unitOfWorkManage.RollbackTran(); return WebResponseContent.Instance.Error($"{response.Message}"); } } _stockService.StockInfoService.UpdateData(stockInfo); _basicService.LocationInfoService.UpdateData(locationInfo); _basicService.LocationInfoService.UpdateLocationLock(locationInfo, task.TaskNum, StockChangeType.Outbound.ObjToInt(), false); _recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(locationInfo, beforeStatus, StockChangeType.Outbound.ObjToInt(), "", task.TaskNum); _unitOfWorkManage.CommitTran(); return WebResponseContent.Instance.OK(); } catch (Exception ex) { return WebResponseContent.Instance.Error(ex.Message); } } /// /// 出库任务查询 /// /// /// public WebResponseContent OutboundTask(TaskDTO taskDTO) { WebResponseContent content = new WebResponseContent(); try { Expression> expressionOrder = x => true; //if (!string.IsNullOrEmpty(taskDTO.TaskNum)) //{ // expressionOrder = x => x.OrderNo.Contains(inboundOrderGetDTO.OrderNo); //} int count = BaseDal.QueryData(x => x.TaskStatus == OutboundStatusEnum.未开始.ObjToInt() && x.TaskType == TaskTypeEnum.Outbound.ObjToInt()).ToList().Count(); int maxPage = Convert.ToInt32(Math.Ceiling(count / 10.0)); if (taskDTO.pageNo <= maxPage) { var inboundOrder = BaseDal.Db.Queryable().Where(expressionOrder).Where(x => x.TaskType == TaskTypeEnum.Outbound.ObjToInt()).OrderByDescending(x => x.CreateDate).Select(x => new Dt_Task { TaskNum = x.TaskNum, TaskId = x.TaskId, CreateDate = x.CreateDate, Creater = x.Creater, Materialtype = x.Materialtype }).ToList(); content = WebResponseContent.Instance.OK(data: inboundOrder); } else { content = WebResponseContent.Instance.OK(data: null, message: "已到最后一页"); } } catch (Exception ex) { content = WebResponseContent.Instance.Error($"查询入库单据错误,错误信息:{ex.Message}"); } return content; } /// /// 确认出库任务 /// /// /// public WebResponseContent RequestInbound(SaveModel saveModel) { WebResponseContent content = new WebResponseContent(); try { string stationcode = saveModel.MainData["stationcode"].ToString(); string PalletCode = saveModel.MainData["PalletCode"].ToString(); Dt_Task task = BaseDal.QueryFirst(x => x.SourceAddress == stationcode && x.Materialtype == PalletCode); if (task != null) { task.TaskStatus = AGVTaskStatusEnum.AGV_New.ObjToInt(); BaseDal.UpdateData(task); content = WebResponseContent.Instance.OK(); } else { return content = WebResponseContent.Instance.Error("未找到此任务或物料类型不匹配"); } } catch (Exception ex) { content = WebResponseContent.Instance.Error($"任务起点异常,错误信息:{ex.Message}"); } return content; } private static readonly object text = new object(); /// /// 出库任务 /// /// /// public WebResponseContent OutboundTasks(SaveModel saveModel) { lock (text) { WebResponseContent content = new WebResponseContent(); try { string stationcode = saveModel.MainData["stationcode"].ToString(); string PalletCode = saveModel.MainData["PalletCode"].ToString(); if (stationcode == "" || PalletCode == "")//异常返回。。。。。。 { return content = WebResponseContent.Instance.Error($"添加任务异常,错误信息:扫码信息不能为空"); } Dt_CachePoint endCachePoint = _basicService.CachePointService.Repository.QueryFirst(x => x.PointCode.Contains("原材料库") && x.PointStatus == LocationStatusEnum.Free.ObjToInt());//&& x.PointStatus == LocationStatusEnum.Free.ObjToInt() if (endCachePoint == null) { return content = WebResponseContent.Instance.Error($"添加任务异常,错误信息:{"未找到原材料库可用缓存位"}"); } Dt_CachePoint points = _basicService.CachePointService.Repository.QueryFirst(x => x.PointCode == stationcode && x.PointStatus == LocationStatusEnum.Free.ObjToInt()); if (points == null) { return content = WebResponseContent.Instance.Error($"添加任务异常,错误信息:{"扫码数据异常,此缓存点已被锁定"}"); } Dt_Task taskcode = BaseDal.QueryFirst(x => x.SourceAddress == stationcode || x.TargetAddress == stationcode); if (taskcode != null) { return content = WebResponseContent.Instance.Error($"添加任务异常,错误信息:该站点已存在任务"); } var pointname = _basicService.CachePointService.Repository.QueryData(x => x.Remark == points.Remark).ToList(); foreach (var item in pointname) { var a = points.Depth.ObjToInt(); var b = item.Depth.ObjToInt(); if (b <= a) { Dt_CachePoint c = _basicService.CachePointService.Repository.QueryFirst(x => x.PointCode == item.PointCode && x.PointStatus == 0); if (c != null) { return content = WebResponseContent.Instance.Error($"添加任务异常,错误信息:{"请按从里到外缓存点顺序请求任务"}"); } } } List tasks = new List(); Dt_Task task = new Dt_Task() { CurrentAddress = "1", Grade = 1, NextAddress = "1", PalletCode = "", Roadway = "1", SourceAddress = endCachePoint.PointCode, TargetAddress = stationcode, TaskStatus = AGVTaskStatusEnum.AGV_Query.ObjToInt(), TaskType = TaskTypeEnum.Outbound.ObjToInt(), Materialtype = PalletCode, Depth = 1, TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum)) }; tasks.Add(task); Repository.AddData(tasks); HCJLock(task); //Main(); content = WebResponseContent.Instance.OK(); } catch (Exception ex) { content = WebResponseContent.Instance.Error($"添加任务异常,错误信息:{ex.Message}"); } return content; } } public void Main() { PrintDocument printDocument = new PrintDocument(); printDocument.PrintPage += new PrintPageEventHandler(PrintPage); printDocument.Print(); } private void PrintPage(object sender, PrintPageEventArgs e) { var agvtask = BaseDal.QueryData(x => x.TaskStatus == AGVTaskStatusEnum.AGV_Query.ObjToInt()).OrderByDescending(x => x.CreateDate).First(); string textToPrint = "放货货位位:" + agvtask.SourceAddress + Environment.NewLine + "物料类型:" + agvtask.Materialtype + Environment.NewLine + "任务创建时间:" + agvtask.CreateDate; Font printFont = new Font("Arial", 12); e.Graphics.DrawString(textToPrint, printFont, Brushes.Black, 10, 10); } } }