#region << 版 本 注 释 >> /*---------------------------------------------------------------- * 命å空间:WIDESEAWCS_TaskInfoService * 创建者:胡童庆 * 创建时间:2024/8/2 16:13:36 * 版本:V1.0.0 * æè¿°ï¼š * * ---------------------------------------------------------------- * 修改人: * 修改时间: * 版本:V1.0.1 * 修改说明: * *----------------------------------------------------------------*/ #endregion << 版 本 注 释 >> using AutoMapper; using Newtonsoft.Json; using OfficeOpenXml.FormulaParsing.Excel.Functions.Text; using SqlSugar; using System; using System.Collections.Generic; using System.ComponentModel; using System.Diagnostics.CodeAnalysis; using System.Linq; using System.Reflection; using System.Text; using System.Threading.Tasks; using WIDESEAWCS_Common.APIEnum; using WIDESEAWCS_Common.TaskEnum; using WIDESEAWCS_Core; using WIDESEAWCS_Core.BaseServices; using WIDESEAWCS_Core.Enums; using WIDESEAWCS_Core.Helper; using WIDESEAWCS_DTO.BasicInfo; using WIDESEAWCS_DTO.System; using WIDESEAWCS_DTO.TaskInfo; using WIDESEAWCS_IBasicInfoRepository; using WIDESEAWCS_ITaskInfoRepository; using WIDESEAWCS_ITaskInfoService; using WIDESEAWCS_Model.Models; using WIDESEAWCS_QuartzJob; using WIDESEAWCS_QuartzJob.Models; using WIDESEAWCS_QuartzJob.Repository; using WIDESEAWCS_QuartzJob.Service; using ICacheService = WIDESEAWCS_Core.Caches.ICacheService; namespace WIDESEAWCS_TaskInfoService { public partial class TaskService : ServiceBase<Dt_Task, ITaskRepository>, ITaskService { private readonly IMapper _mapper; private readonly ICacheService _cacheService; private readonly IRouterService _routerService; private readonly ITaskExecuteDetailService _taskExecuteDetailService; private readonly ITaskExecuteDetailRepository _taskExecuteDetailRepository; private readonly IStationMangerRepository _stationMangerRepository; private readonly IRouterRepository _routerRepository; private readonly IApiInfoRepository _apiInfoRepository; private List<Dt_ApiInfo> apiInfos; private Dictionary<string, OrderByType> _taskOrderBy = new() { {nameof(Dt_Task.Grade),OrderByType.Desc }, {nameof(Dt_Task.CreateDate),OrderByType.Asc}, }; private List<Dt_Warehouse>? Warehouses = new List<Dt_Warehouse>(); public Dictionary<string, OrderByType> TaskOrderBy { get { return _taskOrderBy; } set { _taskOrderBy = value; } } public List<int> TaskInboundTypes => typeof(TaskTypeEnum).GetEnumIndexList().Where(x => x >= 500 && x < 900).ToList(); public List<int> TaskOutboundTypes => typeof(TaskTypeEnum).GetEnumIndexList().Where(x => x >= 100 && x < 500).ToList(); public TaskService(ITaskRepository BaseDal, IMapper mapper, ICacheService cacheService, IRouterService routerService, ITaskExecuteDetailService taskExecuteDetailService, ITaskExecuteDetailRepository taskExecuteDetailRepository, IStationMangerRepository stationMangerRepository, IRouterRepository routerRepository, IApiInfoRepository apiInfoRepository) : base(BaseDal) { _mapper = mapper; _cacheService = cacheService; _routerService = routerService; _taskExecuteDetailService = taskExecuteDetailService; _taskExecuteDetailRepository = taskExecuteDetailRepository; _stationMangerRepository = stationMangerRepository; _routerRepository = routerRepository; _apiInfoRepository = apiInfoRepository; string? cacheStr = _cacheService.Get(nameof(Dt_Warehouse)); if (!string.IsNullOrEmpty(cacheStr)) { Warehouses = JsonConvert.DeserializeObject<List<Dt_Warehouse>>(cacheStr); } string? apiInfoStr = _cacheService.Get("apiInfos"); if (!string.IsNullOrEmpty(apiInfoStr)) { List<Dt_ApiInfo>? infos = JsonConvert.DeserializeObject<List<Dt_ApiInfo>>(apiInfoStr); if (infos == null || infos.Count == 0) { apiInfos = new List<Dt_ApiInfo>(); } else { apiInfos = infos; } } } public WebResponseContent TaskCompleted(int taskNum) { try { Dt_Task task = BaseDal.QueryFirst(x => x.TaskNum == taskNum); if (task != null) { BaseDal.DeleteAndMoveIntoHty(task, App.User == null ? OperateTypeEnum.è‡ªåŠ¨å®Œæˆ : OperateTypeEnum.人工完æˆ); } string? url = apiInfos.FirstOrDefault(x => x.ApiCode == APIEnum.FeedBackWMSTaskCompleted.ToString())?.ApiAddress; if (string.IsNullOrEmpty(url)) { _taskExecuteDetailService.AddTaskExecuteDetail(taskNum, $"未找到WMSä»»åŠ¡å®ŒæˆæŽ¥å£,请检查接å£é…ç½®"); UpdateTaskExceptionMessage(taskNum, $"未找到WMSä»»åŠ¡å®ŒæˆæŽ¥å£,请检查接å£é…ç½®"); return WebResponseContent.Instance.Error($"{taskNum},未找到WMSä»»åŠ¡å®ŒæˆæŽ¥å£,请检查接å£é…ç½®"); } string responseStr = HttpHelper.Get(url + "?taskNum=" + taskNum); WebResponseContent content = JsonConvert.DeserializeObject<WebResponseContent>(responseStr) ?? WebResponseContent.Instance.Error($"{taskNum},未接收到任务完æˆè¿”回值"); return content; } catch (Exception ex) { return WebResponseContent.Instance.Error(ex.Message); } } /// <summary> /// 接收WMSä»»åŠ¡ä¿¡æ¯ /// </summary> /// <param name="taskDTOs">WMS任务对象集åˆ</param> /// <returns>返回处ç†ç»“æžœ</returns> public WebResponseContent ReceiveWMSTask([NotNull] List<WMSTaskDTO> taskDTOs) { WebResponseContent content = new WebResponseContent(); try { List<Dt_WarehouseDevice> warehouseDevices = Db.Queryable<Dt_WarehouseDevice>().ToList(); List<Dt_Task> tasks = new List<Dt_Task>(); foreach (var item in taskDTOs) { if (BaseDal.QueryFirst(x => x.TaskNum == item.TaskNum || x.PalletCode == item.PalletCode) != null) { continue; } Dt_Task task = _mapper.Map<Dt_Task>(item); task.Creater = "WMS"; task.TaskState = (int)TaskStatusEnum.New; task.CurrentAddress = item.SourceAddress; List<Dt_WarehouseDevice> wades = warehouseDevices.Where(x => x.WarehouseId == item.WarehouseId).ToList(); Dt_Router? router = new Dt_Router(); if (string.IsNullOrEmpty(item.AGVArea)) { //task.AgvTaskNum = "AGV-" + DateTime.Now.ToString("yyyyMMdd") + item.TaskNum; Dt_StationManger stationManger = _stationMangerRepository.QueryFirst(x => x.StationCode == item.SourceAddress || x.StackerCraneCode == item.RoadWay); if (stationManger == null) { return WebResponseContent.Instance.Error($"未找到站å°é…置信æ¯"); } List<Dt_Router> routers = _routerRepository.QueryData(x => x.InOutType == item.TaskType && (stationManger.StationCode == x.StartPosi || stationManger.StackerCraneCode == x.StartPosi)); if (routers.FirstOrDefault() == null) { return WebResponseContent.Instance.Error($"未找到路由é…置信æ¯"); } router = routers.FirstOrDefault(); if (routers.Count == 1) { task.NextAddress = router?.NextPosi ?? ""; task.DeviceCode = stationManger.StationDeviceCode; } else { task.NextAddress = ""; task.DeviceCode = ""; } } else { if (item.TaskType.GetTaskTypeGroup() == TaskTypeGroup.OutbondGroup) { task.AgvTaskNum = "AGV-" + DateTime.Now.ToString("yyyyMMdd") + item.TaskNum; List<Dt_Router> routers = _routerRepository.QueryData(x => x.InOutType == item.TaskType && item.AGVArea == x.NextPosi); if (routers.FirstOrDefault() == null) { return WebResponseContent.Instance.Error($"未找到路由é…置信æ¯"); } router = routers.FirstOrDefault(); task.NextAddress = router?.StartPosi ?? ""; task.DeviceCode = item.RoadWay; task.TaskState = TaskStatusEnum.SC_Execute.ObjToInt(); } else { task.AgvTaskNum = "AGV-" + DateTime.Now.ToString("yyyyMMdd") + item.TaskNum; List<Dt_Router> routers = _routerRepository.QueryData(x => x.InOutType == item.TaskType && item.AGVArea == x.StartPosi); if (routers.FirstOrDefault() == null) { return WebResponseContent.Instance.Error($"未找到路由é…置信æ¯"); } router = routers.FirstOrDefault(); string stationCode = router?.NextPosi ?? ""; Dt_StationManger? stationManger = _stationMangerRepository.QueryFirst(x => x.StationCode == stationCode); if (stationManger == null) { return WebResponseContent.Instance.Error($"未找到站å°é…置信æ¯"); } task.NextAddress = stationManger?.AGVStationCode ?? ""; task.DeviceCode = stationManger?.Remark ?? ""; task.TaskState = TaskStatusEnum.AGV_Execute.ObjToInt(); } } tasks.Add(task); } BaseDal.AddData(tasks); _taskExecuteDetailService.AddTaskExecuteDetail(tasks.Select(x => x.TaskNum).ToList(), "接收WMS任务"); content = WebResponseContent.Instance.OK("æˆåŠŸ"); } catch (Exception ex) { content = WebResponseContent.Instance.Error($"任务接收错误,错误信æ¯:{ex.Message}"); } return content; } /// <summary> /// æ ¹æ®æ‰˜ç›˜å·ã€èµ·å§‹åœ°å€å‘WMS请求任务 /// </summary> /// <param name="palletCode">托盘å·</param> /// <param name="sourceAddress">起始地å€</param> /// <returns></returns> public WebResponseContent RequestWMSTask(string palletCode, string sourceAddress) { WebResponseContent content = new WebResponseContent(); try { Dt_StationManger stationManger = _stationMangerRepository.QueryFirst(x => x.StationDeviceCode == sourceAddress); if (stationManger == null) { return WebResponseContent.Instance.Error($"未找到站å°ä¿¡æ¯"); } HttpHelper.Post($"RequestInboundTask?palletCode={palletCode}&stationCode={sourceAddress}"); WMSTaskDTO taskDTO = new WMSTaskDTO(); content = ReceiveWMSTask(new List<WMSTaskDTO> { taskDTO }); } catch (Exception ex) { content = WebResponseContent.Instance.Error(ex.Message); } return content; } /// <summary> /// å‘WMS申请分é…è´§ä½ /// </summary> /// <param name="taskNum">任务å·</param> /// <param name="roadwayNo">å··é“å·</param> /// <returns></returns> public string? RequestAssignLocation(int taskNum, string roadwayNo) { string responseStr = HttpHelper.Get($"http://127.0.0.1:9293/api/Task/AssignInboundTaskLocation?taskNum={taskNum}&roadwayNo={roadwayNo}"); WebResponseContent? responseContent = JsonConvert.DeserializeObject<WebResponseContent>(responseStr); if (responseContent != null && responseContent.Status && responseContent.Data != null) { return responseContent.Data.ToString(); } return ""; } /// <summary> /// æ ¹æ®è®¾å¤‡ç¼–å·ã€ä»»åŠ¡ç±»åž‹åˆ†ç»„(å¯é€‰)按照优先级以åŠåˆ›å»ºæ—¶é—´æŽ’åºæŸ¥è¯¢ä»»åŠ¡æ± æ–°å¢žçš„ä»»åŠ¡ /// </summary> /// <param name="deviceNo">设备编å·</param> /// <param name="taskTypeGroup">任务类型分组(å¯é€‰)</param> /// <returns></returns> public Dt_Task? QuertStackerCraneTask(string deviceNo, TaskTypeGroup? taskTypeGroup = null) { if (taskTypeGroup == null) return BaseDal.QueryFirst(x => x.DeviceCode == deviceNo && x.TaskState == (int)TaskStatusEnum.New, TaskOrderBy); if (taskTypeGroup.Value == TaskTypeGroup.InboundGroup) return BaseDal.QueryFirst(x => x.DeviceCode == deviceNo && TaskInboundTypes.Contains(x.TaskType) && x.TaskState == (int)TaskStatusEnum.SC_Execute, TaskOrderBy); if (taskTypeGroup.Value == TaskTypeGroup.OutbondGroup) return BaseDal.QueryFirst(x => x.DeviceCode == deviceNo && TaskOutboundTypes.Contains(x.TaskType) && x.TaskState == (int)TaskStatusEnum.SC_Execute, TaskOrderBy); return null; } /// <summary> /// æ ¹æ®è®¾å¤‡ç¼–å·ã€å½“å‰åœ°å€æŒ‰ç…§ä¼˜å…ˆçº§ä»¥åŠåˆ›å»ºæ—¶é—´æŽ’åºæŸ¥è¯¢ä»»åŠ¡æ± æ–°å¢žçš„ä»»åŠ¡ /// </summary> /// <param name="deviceNo">设备编å·</param> /// <param name="currentAddress">当å‰åœ°å€</param> /// <returns>返回任务实体对象,å¯èƒ½ä¸ºnull</returns> public Dt_Task QueryStackerCraneTask(string deviceNo, string currentAddress = "") { if (string.IsNullOrEmpty(currentAddress)) return BaseDal.QueryFirst(x => x.DeviceCode == deviceNo && x.TaskState == (int)TaskStatusEnum.SC_Execute, TaskOrderBy); else return BaseDal.QueryFirst(x => x.DeviceCode == deviceNo && x.CurrentAddress == currentAddress && x.TaskState == (int)TaskStatusEnum.SC_Execute, TaskOrderBy); } /// <summary> /// æ ¹æ®è®¾å¤‡ç¼–å·ã€å½“å‰åœ°å€æŒ‰ç…§ä¼˜å…ˆçº§ä»¥åŠåˆ›å»ºæ—¶é—´æŽ’åºæŸ¥è¯¢ä»»åŠ¡æ± å…¥åº“ç±»åž‹çš„æ–°å¢žçš„ä»»åŠ¡ /// </summary> /// <param name="deviceNo">设备编å·</param> /// <param name="currentAddress">当å‰åœ°å€</param> /// <returns>返回任务实体对象,å¯èƒ½ä¸ºnull</returns> public Dt_Task QueryStackerCraneInTask(string deviceNo, string currentAddress = "") { if (string.IsNullOrEmpty(currentAddress)) return BaseDal.QueryFirst(x => x.DeviceCode == deviceNo && TaskInboundTypes.Contains(x.TaskType) && x.TaskState == (int)TaskStatusEnum.SC_Execute, TaskOrderBy); else return BaseDal.QueryFirst(x => x.DeviceCode == deviceNo && TaskInboundTypes.Contains(x.TaskType) && x.TaskState == (int)TaskStatusEnum.SC_Execute && x.CurrentAddress == currentAddress, TaskOrderBy); } /// <summary> /// æ ¹æ®è®¾å¤‡ç¼–å·ã€å½“å‰åœ°å€æŒ‰ç…§ä¼˜å…ˆçº§ä»¥åŠåˆ›å»ºæ—¶é—´æŽ’åºæŸ¥è¯¢ä»»åŠ¡æ± å‡ºåº“ç±»åž‹çš„æ–°å¢žçš„ä»»åŠ¡ /// </summary> /// <param name="deviceNo">设备编å·</param> /// <param name="currentAddress">当å‰åœ°å€</param> /// <returns>返回任务实体对象,å¯èƒ½ä¸ºnull</returns> public Dt_Task QueryStackerCraneOutTask(string deviceNo, string currentAddress = "") { if (string.IsNullOrEmpty(currentAddress)) return BaseDal.QueryFirst(x => x.DeviceCode == deviceNo && TaskOutboundTypes.Contains(x.TaskType) && x.TaskState == (int)TaskStatusEnum.SC_Execute, TaskOrderBy); else return BaseDal.QueryFirst(x => x.DeviceCode == deviceNo && TaskOutboundTypes.Contains(x.TaskType) && x.TaskState == (int)TaskStatusEnum.SC_Execute && x.CurrentAddress == currentAddress, TaskOrderBy); } /// <summary> /// æ ¹æ®è®¾å¤‡ç¼–å·ã€å½“å‰åœ°å€æŒ‰ç…§ä¼˜å…ˆçº§ä»¥åŠåˆ›å»ºæ—¶é—´æŽ’åºæŸ¥è¯¢ä»»åŠ¡æ± å‡ºåº“ç±»åž‹çš„æ–°å¢žçš„ä»»åŠ¡ /// </summary> /// <param name="deviceNo">设备编å·</param> /// <param name="currentAddress">当å‰åœ°å€</param> /// <returns>返回任务实体对象集åˆï¼Œå¯èƒ½ä¸ºnull</returns> public List<Dt_Task> QueryStackerCraneOutTasks(string deviceNo, List<string> outStationCodes) { return BaseDal.QueryData(x => x.DeviceCode == deviceNo && TaskOutboundTypes.Contains(x.TaskType) && x.TaskState == (int)TaskStatusEnum.SC_Execute && outStationCodes.Contains(x.CurrentAddress), TaskOrderBy); } /// <summary> /// æ›´æ–°ä»»åŠ¡å¼‚å¸¸ä¿¡æ¯æ˜¾ç¤º /// </summary> /// <param name="taskNum">任务å·</param> /// <param name="message">异常信æ¯</param> public WebResponseContent UpdateTaskExceptionMessage(int taskNum, string message) { WebResponseContent content = new WebResponseContent(); try { Dt_Task task = BaseDal.QueryFirst(x => x.TaskNum == taskNum); if (task == null) return WebResponseContent.Instance.Error($"未找到该任务信æ¯,任务å·:ã€{taskNum}】"); task.TaskState = (int)TaskStatusEnum.Pending; task.ExceptionMessage = message; task.ModifyDate = DateTime.Now; BaseDal.UpdateData(task); _taskExecuteDetailService.AddTaskExecuteDetail(task.TaskId, task.ExceptionMessage); content = WebResponseContent.Instance.OK(); } catch (Exception ex) { content = WebResponseContent.Instance.Error(ex.Message); } return content; } /// <summary> /// æ¢å¤æŒ‚起任务 /// </summary> /// <param name="taskNum">任务å·</param> /// <returns>返回处ç†ç»“æžœ</returns> public WebResponseContent TaskStatusRecovery(int taskNum) { WebResponseContent content = new WebResponseContent(); try { Dt_Task task = BaseDal.QueryFirst(x => x.TaskNum == taskNum); if (task == null) return WebResponseContent.Instance.Error($"未找到该任务信æ¯,任务å·:ã€{taskNum}】"); if (task.TaskState != (int)TaskStatusEnum.Pending) { return content = WebResponseContent.Instance.Error($"该任务状æ€ä¸å¯æ¢å¤,任务å·:ã€{taskNum}】,任务状æ€:ã€{task.TaskState}】"); } Dt_TaskExecuteDetail taskExecuteDetail = _taskExecuteDetailRepository.QueryFirst(x => x.TaskId == task.TaskId && x.IsNormal, new Dictionary<string, OrderByType> { { nameof(Dt_TaskExecuteDetail.TaskDetailId), OrderByType.Desc } }); if (taskExecuteDetail != null) { task.TaskState = taskExecuteDetail.TaskState; } else { task.TaskState = (int)TaskStatusEnum.New; } task.ExceptionMessage = string.Empty; BaseDal.UpdateData(task); _taskExecuteDetailService.AddTaskExecuteDetail(task.TaskId, $"人工æ¢å¤æŒ‚起任务,æ¢å¤æŒ‚起时任务状æ€ã€{task.TaskState}】"); content = WebResponseContent.Instance.OK(); } catch (Exception ex) { content = WebResponseContent.Instance.Error(ex.Message); } return content; } /// <summary> /// å›žæ»šä»»åŠ¡çŠ¶æ€ /// </summary> /// <param name="taskNum">任务å·</param> /// <returns>返回处ç†ç»“æžœ</returns> public WebResponseContent RollbackTaskStatusToLast(int taskNum) { WebResponseContent content = new(); try { Dt_Task task = BaseDal.QueryFirst(x => x.TaskNum == taskNum); if (task == null) return WebResponseContent.Instance.Error($"未找到该任务信æ¯,任务å·:ã€{taskNum}】"); int oldState = task.TaskState; Dt_TaskExecuteDetail taskExecuteDetail = _taskExecuteDetailRepository.QueryFirst(x => x.TaskId == task.TaskId && x.TaskState < task.TaskState && x.TaskState > 0, new Dictionary<string, OrderByType> { { nameof(Dt_TaskExecuteDetail.TaskDetailId), OrderByType.Desc } }); if (taskExecuteDetail != null) { task.TaskState = taskExecuteDetail.TaskState; task.CurrentAddress = taskExecuteDetail.CurrentAddress; task.NextAddress = taskExecuteDetail.NextAddress; } else { return content = WebResponseContent.Instance.Error($"未找到任务明细信æ¯,该任务状æ€ä¸å¯å›žæ»šåˆ°ä¸Šä¸€æ¥,任务å·:ã€{taskNum}】,任务状æ€:ã€{task.TaskState}】"); } task.ExceptionMessage = string.Empty; BaseDal.UpdateData(task); _taskExecuteDetailService.AddTaskExecuteDetail(task.TaskId, $"人工将任务状æ€ä»Žã€{oldState}】回滚到ã€{task.TaskState}】"); content = WebResponseContent.Instance.OK(); } catch (Exception ex) { content = WebResponseContent.Instance.Error(ex.Message); } return content; } } }