#region << 版 本 注 释 >> /*---------------------------------------------------------------- * 命名空间:WIDESEAWCS_TaskInfoService * 创建者:胡童庆 * 创建时间:2024/8/2 16:13:36 * 版本:V1.0.0 * 描述: * * ---------------------------------------------------------------- * 修改人: * 修改时间: * 版本:V1.0.1 * 修改说明: * *----------------------------------------------------------------*/ #endregion << 版 本 注 释 >> using AutoMapper; using HslCommunication.WebSocket; using OfficeOpenXml.FormulaParsing.Excel.Functions.Text; using SqlSugar; using System.Diagnostics.CodeAnalysis; using System.Threading.Tasks; using WIDESEAWCS_Common.LocationEnum; using WIDESEAWCS_Common.StockEnum; using WIDESEAWCS_Common.TaskEnum; using WIDESEAWCS_Core; using WIDESEAWCS_Core.BaseRepository; using WIDESEAWCS_Core.BaseServices; using WIDESEAWCS_DTO.TaskInfo; using WIDESEAWCS_ISystemServices; using WIDESEAWCS_ITaskInfoService; using WIDESEAWCS_IWMSPart; using WIDESEAWCS_Model.Models; using WIDESEAWCS_Model.Models.System; using WIDESEAWCS_QuartzJob; using WIDESEAWCS_QuartzJob.Models; using WIDESEAWCS_QuartzJob.Service; using static HslCommunication.Profinet.Knx.KnxCode; namespace WIDESEAWCS_TaskInfoService { public class TaskService : ServiceBase>, ITaskService { private readonly IRouterService _routerService; private readonly ITaskExecuteDetailService _taskExecuteDetailService; private readonly IRepository _taskExecuteDetailRepository; private readonly IRepository _stockRepository; private readonly IRepository _locationRepository; private readonly IRepository _batchinfoRepository; private readonly IRepository _taskhtyRepository; private readonly IUnitOfWorkManage _unitOfWorkManage; private readonly IRepository _errorinfoRepository; private readonly Idt_ErrormsginfoService _ErrormsginfoService; private readonly IMapper _mapper; private readonly IRepository _dt_stationInfoRepository; private Dictionary _taskOrderBy = new() { {nameof(Dt_Task.Grade),OrderByType.Desc }, {nameof(Dt_Task.CreateDate),OrderByType.Asc}, }; public Dictionary TaskOrderBy { get { return _taskOrderBy; } set { _taskOrderBy = value; } } public List TaskInboundTypes => typeof(TaskInboundTypeEnum).GetEnumIndexList(); public List TaskOutboundTypes => typeof(TaskOutboundTypeEnum).GetEnumIndexList(); /// /// 仓储层(数据库访问) /// public IRepository Repository => BaseDal; //SBText ITaskService.text { get => throw new NotImplementedException(); set => throw new NotImplementedException(); } public TaskService(IRepository BaseDal, IRouterService routerService, ITaskExecuteDetailService taskExecuteDetailService, IRepository taskExecuteDetailRepository, IRepository stockRepository, IRepository locationRepository, IRepository batchRepository, IRepository taskhtyRepository, IRepository errorinfoRepository, IRepository dt_stationInfoRepository, Idt_ErrormsginfoService errormsginfoService, IUnitOfWorkManage unitOfWorkManage, IMapper mapper) : base(BaseDal) { _routerService = routerService; _taskExecuteDetailService = taskExecuteDetailService; _taskExecuteDetailRepository = taskExecuteDetailRepository; _stockRepository = stockRepository; _locationRepository = locationRepository; _batchinfoRepository = batchRepository; _taskhtyRepository = taskhtyRepository; _unitOfWorkManage = unitOfWorkManage; _errorinfoRepository = errorinfoRepository; _ErrormsginfoService = errormsginfoService; _mapper = mapper; _dt_stationInfoRepository = dt_stationInfoRepository; } /// /// 接收WMS任务信息 /// /// WMS任务对象集合 /// 返回处理结果 public WebResponseContent ReceiveWMSTask([NotNull] List taskDTOs) { WebResponseContent content = new WebResponseContent(); try { List tasks = new List(); foreach (var item in taskDTOs) { if (BaseDal.QueryFirst(x => x.TaskNum == item.TaskNum || x.PalletCode == item.PalletCode) != null) { continue; } Dt_Task task = _mapper.Map(item); task.Creater = "WMS"; if (task.TaskType.GetTaskTypeGroup() == TaskTypeGroup.OutbondGroup) { List routers = _routerService.QueryNextRoutes(item.RoadWay, item.TargetAddress); //暂不考虑多路径 if (routers.Count > 0) { task.TaskState = (int)TaskOutStatusEnum.OutNew; task.CurrentAddress = item.SourceAddress; task.NextAddress = routers.FirstOrDefault().ChildPosi; } } else if (task.TaskType.GetTaskTypeGroup() == TaskTypeGroup.InboundGroup) { List routers = _routerService.QueryNextRoutes(item.SourceAddress, item.TargetAddress); //暂不考虑多路径 if (routers.Count > 0) { task.TaskState = (int)TaskInStatusEnum.InNew; task.CurrentAddress = item.SourceAddress; task.NextAddress = routers.FirstOrDefault().ChildPosi; } } 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; } /// /// 根据托盘号、起始地址向WMS请求任务 /// /// 托盘号 /// 起始地址 /// public WebResponseContent RequestWMSTask(string palletCode, string sourceAddress) { WebResponseContent content = new WebResponseContent(); try { WMSTaskDTO taskDTO = new WMSTaskDTO() { TaskNum = Convert.ToInt32(DateTime.Now.ToString("HHmmss")), Grade = 1, PalletCode = palletCode, RoadWay = "SC01", SourceAddress = sourceAddress, TargetAddress = "SC01", TaskState = (int)TaskInStatusEnum.InNew, Id = 0, TaskType = (int)TaskInboundTypeEnum.Inbound }; content = ReceiveWMSTask(new List { taskDTO }); } catch (Exception ex) { content = WebResponseContent.Instance.Error(ex.Message); } return content; } /// /// 根据任务状态查询任务 /// /// 设备编号 /// 当前地址 /// public Dt_Task QueryTaskState() { return BaseDal.QueryFirst(x => x.TaskState== (int)TaskInStatusEnum.InNew ); } /// /// 根据设备编号、当前地址查询输送线未执行的任务 /// /// 设备编号 /// 当前地址 /// public Dt_Task QueryConveyorLineTask(string deviceNo, string currentAddress) { return BaseDal.QueryFirst(x => (TaskInboundTypes.Contains(x.TaskType) && x.TaskState == (int)TaskInStatusEnum.InNew || TaskOutboundTypes.Contains(x.TaskType) && x.TaskState == (int)TaskOutStatusEnum.SC_OutFinish) && x.CurrentAddress == currentAddress, TaskOrderBy); } /// /// 根据任务号、下一地址查询输送线执行中的任务 /// /// 任务号 /// 下一地址 /// public Dt_Task QueryExecutingConveyorLineTask(int taskNum, string nextAddress) { return null;// BaseDal.QueryFirst(x => x.TaskNum == taskNum && x.NextAddress == nextAddress && (x.TaskState == (int)TaskInStatusEnum.Line_InExecuting || x.TaskState == (int)TaskOutStatusEnum.Line_OutExecuting), TaskOrderBy); } /// /// 根据任务号、当前地址查询输送线完成的任务 /// /// 任务号 /// 当前地址 /// public Dt_Task QueryCompletedConveyorLineTask(int taskNum, string currentAddress) { return null;// BaseDal.QueryFirst(x => x.TaskNum == taskNum && x.CurrentAddress == currentAddress && (x.TaskState == (int)TaskInStatusEnum.Line_InFinish || x.TaskState == (int)TaskOutStatusEnum.Line_OutFinish), TaskOrderBy); } /// /// 根据设备编号、任务类型分组(可选)按照优先级以及创建时间排序查询任务池新增的任务 /// /// 设备编号 /// 任务类型分组(可选) /// public Dt_Task? QuertStackerCraneTask(string deviceNo, TaskTypeGroup? taskTypeGroup = null) { if (taskTypeGroup == null) return BaseDal.QueryFirst(x => x.Roadway == deviceNo && (TaskInboundTypes.Contains(x.TaskType) && x.TaskState == (int)TaskInStatusEnum.Line_InFinish || TaskOutboundTypes.Contains(x.TaskType) && x.TaskState == (int)TaskOutStatusEnum.OutNew), TaskOrderBy); if (taskTypeGroup.Value == TaskTypeGroup.InboundGroup) return BaseDal.QueryFirst(x => x.Roadway == deviceNo && TaskInboundTypes.Contains(x.TaskType) && x.TaskState == (int)TaskInStatusEnum.Line_InFinish, TaskOrderBy); if (taskTypeGroup.Value == TaskTypeGroup.OutbondGroup) return BaseDal.QueryFirst(x => x.Roadway == deviceNo && TaskOutboundTypes.Contains(x.TaskType) && x.TaskState == (int)TaskOutStatusEnum.OutNew, TaskOrderBy); return null; } /// /// 根据设备编号、当前地址按照优先级以及创建时间排序查询任务池新增的任务 /// /// 设备编号 /// 当前地址 /// 返回任务实体对象,可能为null public Dt_Task QueryStackerCraneTask(string workTpe, string currentAddress = "") { Dt_Task task = new Dt_Task(); try { //优先查询当前任务池中是否有取货完成的任务 task = BaseDal.QueryFirst(v => v.TaskState == (int)TaskInStatusEnum.Line_Ingrab || v.TaskState == (int)TaskOutStatusEnum.SC_OutExecuting); if (task != null) { //优先返回执行到一半的任务继续执行 return task; } else { //查询天车移动任务 task = BaseDal.QueryFirst(v => v.TaskType == (int)TaskMoveEnum.Mowe && v.TaskState == (int)TaskMoveStatusEnum.OutNewMove); if (task!=null) { return task; } } //查询当前任务池中是否存在状态为非新建的 //task= BaseDal.QueryFirst(v => v.TaskState != (int)TaskInStatusEnum.InNew || v.TaskState != (int)TaskOutStatusEnum.OutNew); //if (task != null) //{ // throw new Exception($"当前任务池中存在执行中的任务,任务号:【{task.TaskNum}】"); //} //if (task != null) //{ // if (task.TaskState != (int)TaskMoveStatusEnum.OutNewMove) // { // } //} if (workTpe.Equals("In")) { task = BaseDal.QueryData(v => v.TaskType == (int)TaskInboundTypeEnum.Inbound && v.TaskState == (int)TaskInStatusEnum.InNew).OrderByDescending(v => v.Grade).OrderBy(v => v.CreateDate).First(); } else if (workTpe.Equals("Out")) { task = BaseDal.QueryData(v => (v.TaskType == (int)TaskOutboundTypeEnum.Outbound || v.TaskType == (int)TaskOutboundTypeEnum.OutInventory) && v.TaskState == (int)TaskOutStatusEnum.OutNew).OrderBy(v => v.CreateDate).First(); } } catch (Exception) { //将错误信息更新至错误信息记录表 } return task; } public Dt_Task QueryTasking() { Dt_Task task = new Dt_Task(); task = BaseDal.QueryFirst(v=>v.TaskState!=(int)TaskInStatusEnum.InNew && v.TaskState != (int)TaskMoveStatusEnum.OutNewMove && v.TaskState != (int)TaskOutStatusEnum.OutNew && v.TaskState != (int)TaskOutStatusEnum.SC_OutExecuting && v.TaskState != (int)TaskInStatusEnum.Line_Ingrab); if (task!=null) { return task; } else { return null; } } /// /// 根据设备编号、当前地址按照优先级以及创建时间排序查询任务池入库类型的新增的任务 /// /// 设备编号 /// 当前地址 /// 返回任务实体对象,可能为null public Dt_Task QueryStackerCraneInTask(string deviceNo, string currentAddress = "") { if (string.IsNullOrEmpty(currentAddress)) return BaseDal.QueryFirst(x => x.Roadway == deviceNo && TaskInboundTypes.Contains(x.TaskType) && x.TaskState == (int)TaskInStatusEnum.Line_InFinish, TaskOrderBy); else return BaseDal.QueryFirst(x => x.Roadway == deviceNo && TaskInboundTypes.Contains(x.TaskType) && x.TaskState == (int)TaskInStatusEnum.Line_InFinish && x.CurrentAddress == currentAddress, TaskOrderBy); } /// /// 根据设备编号、当前地址按照优先级以及创建时间排序查询任务池出库类型的新增的任务 /// /// 设备编号 /// 当前地址 /// 返回任务实体对象,可能为null public Dt_Task QueryStackerCraneOutTask(string deviceNo, string currentAddress = "") { if (string.IsNullOrEmpty(currentAddress)) return BaseDal.QueryFirst(x => x.Roadway == deviceNo && TaskOutboundTypes.Contains(x.TaskType) && x.TaskState == (int)TaskOutStatusEnum.OutNew, TaskOrderBy); else return BaseDal.QueryFirst(x => x.Roadway == deviceNo && TaskOutboundTypes.Contains(x.TaskType) && x.TaskState == (int)TaskOutStatusEnum.OutNew && x.CurrentAddress == currentAddress, TaskOrderBy); } /// /// 根据任务号返回当前任务 /// /// 设备编号 /// 当前地址 /// 返回任务实体对象,可能为null public Dt_Task QueryTakNnmTask(int taskNum) { return BaseDal.QueryFirst(v=>v.TaskId== taskNum); } /// /// 修改天车任务状态,将入库取货执行中修改为入库取货完成 /// /// public WebResponseContent UpdateTaskStatusToLine_Ingrab(Dt_Task task) { WebResponseContent content = new WebResponseContent(); try { task.TaskState = (int)TaskInStatusEnum.Line_Ingrab; BaseDal.UpdateData(task); content = WebResponseContent.Instance.OK(); } catch (Exception ex) { content = WebResponseContent.Instance.Error(ex.Message); UpdateTaskExceptionMessage(task.TaskId, ex.Message); } return content; } /// /// 修改天车任务状态,将出库取货执行中修改为出库取货完成 /// /// public WebResponseContent UpdateTaskStatusToLine_Outgrab(Dt_Task task) { WebResponseContent content = new WebResponseContent(); try { task.TaskState = (int)TaskOutStatusEnum.SC_OutExecuting; BaseDal.UpdateData(task); content = WebResponseContent.Instance.OK(); } catch (Exception ex) { content = WebResponseContent.Instance.Error(ex.Message); UpdateTaskExceptionMessage(task.TaskId, ex.Message); } return content; } /// /// 根据设备编号、当前地址按照优先级以及创建时间排序查询任务池出库类型的新增的任务 /// /// 设备编号 /// 当前地址 /// 返回任务实体对象集合,可能为null public List QueryStackerCraneOutTasks(string deviceNo, List outStationCodes) { return BaseDal.QueryData(x => x.Roadway == deviceNo && TaskOutboundTypes.Contains(x.TaskType) && x.TaskState == (int)TaskOutStatusEnum.OutNew && outStationCodes.Contains(x.CurrentAddress), TaskOrderBy); } /// /// 更新任务异常信息显示 /// /// 任务号 /// 异常信息 public WebResponseContent UpdateTaskExceptionMessage(int taskNum, string message) { WebResponseContent content = new WebResponseContent(); try { Dt_Task task = BaseDal.QueryFirst(x => x.TaskId == taskNum); if (task == null) return WebResponseContent.Instance.Error($"未找到该任务信息,任务号:【{taskNum}】"); //if (task.TaskType.GetTaskTypeGroup() == TaskTypeGroup.OutbondGroup) //{ // task.TaskState = (int)TaskOutStatusEnum.OutPending; //} //else if (task.TaskType.GetTaskTypeGroup() == TaskTypeGroup.InboundGroup) //{ // task.TaskState = (int)TaskInStatusEnum.InPending; //} 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; } /// /// 更新任务状态信息 /// /// 任务号 /// 任务状态 public void UpdateTaskStatus(int taskNum, int status) { try { Dt_Task task = BaseDal.QueryFirst(x => x.TaskId == taskNum); if (status == 2 && task.TaskType == (int)TaskInboundTypeEnum.Inbound) { task.TaskState = (int)TaskInStatusEnum.Line_InGrabExecuting; } else if (status == 2 && (task.TaskType == (int)TaskOutboundTypeEnum.Outbound || task.TaskType == (int)TaskOutboundTypeEnum.OutInventory)) { task.TaskState = (int)TaskOutStatusEnum.Line_OutGrabExecuting; } else if (status == 3 && task.TaskType == (int)TaskInboundTypeEnum.Inbound) { task.TaskState = (int)TaskInStatusEnum.Line_InDownExecuting; } else if (status == 3 && (task.TaskType == (int)TaskOutboundTypeEnum.Outbound || task.TaskType == (int)TaskOutboundTypeEnum.OutInventory)) { task.TaskState = (int)TaskOutStatusEnum.Line_OutWownExecuting; } else if(status == 4 && task.TaskType == (int)TaskMoveEnum.Mowe) { task.TaskState = (int)TaskMoveStatusEnum.Line_OutMove; } task.ModifyDate = DateTime.Now; BaseDal.UpdateData(task); } catch (Exception ex) { UpdateTaskExceptionMessage(taskNum, ex.Message); } } /// /// 将任务状态修改为下一个状态 /// /// 任务号 public WebResponseContent UpdateTaskStatusToNext(int taskNum) { WebResponseContent content = new WebResponseContent(); try { Dt_Task task = BaseDal.QueryFirst(x => x.TaskNum == taskNum); if (task == null) return WebResponseContent.Instance.Error($"未找到该任务信息,任务号:【{taskNum}】"); return UpdateTaskStatusToNext(task); } catch (Exception ex) { content = WebResponseContent.Instance.Error(ex.Message); } return content; } /// /// 将任务状态修改为下一个状态 /// /// 任务实体对象 /// public WebResponseContent UpdateTaskStatusToNext([NotNull] Dt_Task task) { WebResponseContent content = new WebResponseContent(); try { int oldState = task.TaskState; if (task.TaskType.GetTaskTypeGroup() == TaskTypeGroup.OutbondGroup) { if (task.TaskState >= (int)TaskOutStatusEnum.OutFinish) { return content = WebResponseContent.Instance.Error($"该任务状态不可跳转到下一步,任务号:【{task.TaskNum}】,任务状态:【{task.TaskState}】"); } int nextStatus = task.TaskState.GetNextNotCompletedStatus(); task.TaskState = nextStatus; } else if (task.TaskType.GetTaskTypeGroup() == TaskTypeGroup.InboundGroup) { if (task.TaskState >= (int)TaskInStatusEnum.InFinish) { return content = WebResponseContent.Instance.Error($"该任务状态不可跳转到下一步,任务号:【{task.TaskNum}】,任务状态:【{task.TaskState}】"); } int nextStatus = task.TaskState.GetNextNotCompletedStatus(); task.TaskState = nextStatus; if (task.TaskState == (int)TaskInStatusEnum.Line_InFinish) { Random random = new Random(); task.CurrentAddress = task.NextAddress; task.NextAddress = $"{random.Next(1, 100).ToString().PadLeft(3, '0')}-{random.Next(1, 100).ToString().PadLeft(3, '0')}-{random.Next(1, 100).ToString().PadLeft(3, '0')}"; task.TargetAddress = task.NextAddress; } } else { throw new Exception($"任务类型错误,未找到该任务类型,任务号:【{task.TaskNum}】,任务类型:【{task.TaskType}】"); } if (task.TaskState <= 0) { return content = WebResponseContent.Instance.Error($"该任务状态不可跳转到下一步,任务号:【{task.TaskNum}】,任务状态:【{task.TaskState}】"); } task.ModifyDate = DateTime.Now; task.Modifier = "System"; BaseDal.UpdateData(task); _taskExecuteDetailService.AddTaskExecuteDetail(task.TaskId, App.User.UserId > 0 ? $"人工手动将任务状态从【{oldState}】跳转到【{task.TaskState}】" : $"系统自动流程,任务状态从【{oldState}】转到【{task.TaskState}】"); content = WebResponseContent.Instance.OK(); } catch (Exception ex) { content = WebResponseContent.Instance.Error(ex.Message); } return content; } /// /// 根据任务号、当前地址更新任务位置信息 /// /// 任务号 /// 当前地址 /// public Dt_Task? UpdatePosition(int taskNum, string currentAddress) { try { Dt_Task task = BaseDal.QueryFirst(x => x.TaskNum == taskNum && x.CurrentAddress == currentAddress); if (task == null) throw new Exception($"未找到该任务信息,任务号:【{taskNum}】"); string oldCurrentPos = task.CurrentAddress; string oldNextPos = task.NextAddress; List routers = _routerService.QueryNextRoutes(task.NextAddress, task.TargetAddress); if (!routers.Any()) throw new Exception($"未找到设备路由信息"); task.CurrentAddress = task.NextAddress; task.NextAddress = routers.FirstOrDefault().ChildPosi; task.ModifyDate = DateTime.Now; task.Modifier = "System"; BaseDal.UpdateData(task); _taskExecuteDetailService.AddTaskExecuteDetail(task.TaskId, $"系统自动流程,更新当前位置【{oldCurrentPos} ----> {task.CurrentAddress}】和下一位置【{oldNextPos} ----> {task.NextAddress}】"); return task; } catch (Exception ex) { } return null; } /// /// 任务完成 /// /// 任务编号 /// 返回处理结果 public WebResponseContent StackCraneTaskCompleted(int taskNum,float weight) { WebResponseContent content = new WebResponseContent(); try { var nawtask = BaseDal.QueryFirst(v=>v.TaskId== taskNum); if (nawtask == null) { throw new Exception(string.Format("天车放货完成任务未查询到任务号{0}", taskNum)); } if (nawtask.TaskType == (int)TaskInboundTypeEnum.Inbound) { var station = _dt_stationInfoRepository.QueryFirst(v => v.msg == "剔除架"); string sourceAddress = station.Row + "-" + station.Column + "-1"; if (nawtask.SourceAddress.Equals(sourceAddress)) { var batck = _batchinfoRepository.QueryFirst(v => v.Id == 1); //新建库存 Dt_StockInfo stock = new Dt_StockInfo(); stock.LocationCode = nawtask.TargetAddress; stock.Weight = (decimal)weight; stock.StockStatus = (int)stockEnum.Free; stock.BatchNo = batck.InBatch; stock.Remark = 3; //修改货位信息 var location = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.TargetAddress); location.LocationStatus = (int)LocationStatusEnum.InStock; //处理任务信息 Dt_Task_hty taskhty = new Dt_Task_hty(); taskhty.TaskNum = nawtask.TaskNum; taskhty.Roadway = nawtask.Roadway; taskhty.TaskType = nawtask.TaskType; taskhty.TaskState = (int)TaskInStatusEnum.Line_InFinish; taskhty.SourceAddress = nawtask.SourceAddress; taskhty.TargetAddress = nawtask.TargetAddress; taskhty.ExceptionMessage = nawtask.ExceptionMessage; taskhty.Grade = nawtask.Grade; taskhty.Dispatchertime = nawtask.Dispatchertime; taskhty.Remark = nawtask.Remark; taskhty.PalletCode = nawtask.PalletCode; taskhty.NextAddress = nawtask.NextAddress; taskhty.CurrentAddress = nawtask.CurrentAddress; //开始数据库事务 _unitOfWorkManage.BeginTran(); _stockRepository.AddData(stock); _locationRepository.UpdateData(location); _taskhtyRepository.AddData(taskhty); BaseDal.DeleteData(nawtask); //提交事务 _unitOfWorkManage.CommitTran(); } else { var batck = _batchinfoRepository.QueryFirst(v => v.Id == 1); //新建库存 Dt_StockInfo stock = new Dt_StockInfo(); stock.LocationCode = nawtask.TargetAddress; stock.Weight = (decimal)weight; stock.StockStatus = (int)stockEnum.Free; stock.BatchNo = batck.InBatch; if (nawtask.Remark == (int)MateTypeEnum.ZiChan) { stock.Remark = (int)MateTypeEnum.ZiChan; } else { stock.Remark = (int)MateTypeEnum.WaiGou; } Dt_StockInfo stockTow = new Dt_StockInfo(); stockTow.LocationCode = nawtask.NextAddress; stockTow.Weight = (decimal)weight; stockTow.StockStatus = (int)stockEnum.Free; stockTow.BatchNo = batck.InBatch; if (nawtask.Remark == (int)MateTypeEnum.ZiChan) { stockTow.Remark = (int)MateTypeEnum.ZiChan; } else { stockTow.Remark = (int)MateTypeEnum.WaiGou; } //修改货位信息 var location = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.TargetAddress); location.LocationStatus = (int)LocationStatusEnum.InStock; //修改货位信息 var locationtow = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.NextAddress); locationtow.LocationStatus = (int)LocationStatusEnum.InStock; //处理任务信息 Dt_Task_hty taskhty = new Dt_Task_hty(); taskhty.TaskNum = nawtask.TaskNum; taskhty.Roadway = nawtask.Roadway; taskhty.TaskType = nawtask.TaskType; taskhty.TaskState = (int)TaskInStatusEnum.Line_InFinish; taskhty.SourceAddress = nawtask.SourceAddress; taskhty.TargetAddress = nawtask.TargetAddress; taskhty.ExceptionMessage = nawtask.ExceptionMessage; taskhty.Grade = nawtask.Grade; taskhty.Dispatchertime = nawtask.Dispatchertime; taskhty.Remark = nawtask.Remark; taskhty.PalletCode = nawtask.PalletCode; taskhty.NextAddress = nawtask.NextAddress; taskhty.CurrentAddress = nawtask.CurrentAddress; //开始数据库事务 _unitOfWorkManage.BeginTran(); _stockRepository.AddData(stock); _stockRepository.AddData(stockTow); _locationRepository.UpdateData(location); _locationRepository.UpdateData(locationtow); _taskhtyRepository.AddData(taskhty); BaseDal.DeleteData(nawtask); //提交事务 _unitOfWorkManage.CommitTran(); } } else if (nawtask.TaskType == (int)TaskOutboundTypeEnum.Outbound) { var station = _dt_stationInfoRepository.QueryFirst(v => v.msg == "西跨架子"); string targetAddress = station.Row + "-" + station.Column + "-1"; if (nawtask.TargetAddress.Equals(targetAddress)) { //查找库存 var stock = _stockRepository.QueryFirst(v => v.LocationCode == nawtask.SourceAddress); if (stock == null) { throw new Exception($"未找到库存信息货位号:【{nawtask.TargetAddress}】"); } //修改货位状态 var location = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.SourceAddress); location.LocationStatus = (int)LocationStatusEnum.Free; //准备历史任务数据 Dt_Task_hty taskhty = new Dt_Task_hty(); taskhty.TaskNum = nawtask.TaskNum; taskhty.Roadway = nawtask.Roadway; taskhty.TaskType = nawtask.TaskType; taskhty.TaskState = (int)TaskOutStatusEnum.OutFinish; taskhty.SourceAddress = nawtask.SourceAddress; taskhty.TargetAddress = nawtask.TargetAddress; taskhty.ExceptionMessage = nawtask.ExceptionMessage; taskhty.Grade = nawtask.Grade; taskhty.Dispatchertime = nawtask.Dispatchertime; taskhty.Remark = nawtask.Remark; taskhty.PalletCode = nawtask.PalletCode; taskhty.NextAddress = nawtask.NextAddress; taskhty.CurrentAddress = nawtask.CurrentAddress; //开始数据库事务 _unitOfWorkManage.BeginTran(); _stockRepository.DeleteData(stock); _locationRepository.UpdateData(location); _taskhtyRepository.AddData(taskhty); BaseDal.DeleteData(nawtask); //提交事务 _unitOfWorkManage.CommitTran(); } else { //查找库存 var stock = _stockRepository.QueryFirst(v => v.LocationCode == nawtask.SourceAddress); if (stock == null) { throw new Exception($"未找到库存信息货位号:【{nawtask.TargetAddress}】"); } var Towstock = _stockRepository.QueryFirst(v => v.LocationCode == nawtask.NextAddress); //修改货位状态 var location = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.SourceAddress); location.LocationStatus = (int)LocationStatusEnum.Free; //修改货位状态 var locationTow = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.NextAddress); locationTow.LocationStatus = (int)LocationStatusEnum.Free; //准备历史任务数据 Dt_Task_hty taskhty = new Dt_Task_hty(); taskhty.TaskNum = nawtask.TaskNum; taskhty.Roadway = nawtask.Roadway; taskhty.TaskType = nawtask.TaskType; taskhty.TaskState = (int)TaskOutStatusEnum.OutFinish; taskhty.SourceAddress = nawtask.SourceAddress; taskhty.TargetAddress = nawtask.TargetAddress; taskhty.ExceptionMessage = nawtask.ExceptionMessage; taskhty.Grade = nawtask.Grade; taskhty.Dispatchertime = nawtask.Dispatchertime; taskhty.Remark = nawtask.Remark; taskhty.PalletCode = nawtask.PalletCode; taskhty.NextAddress = nawtask.NextAddress; taskhty.CurrentAddress = nawtask.CurrentAddress; //如果放货位置行是40,则立马生成一条移动任务 //开始创建任务 Dt_Task Movstask = new Dt_Task(); Movstask.Roadway = "TC01"; Movstask.TaskType = (int)TaskMoveEnum.Mowe; Movstask.TaskState = (int)TaskMoveStatusEnum.OutNewMove; Movstask.SourceAddress = "0"; Movstask.TargetAddress = "1-5-1"; Movstask.NextAddress = "text"; Movstask.Grade = 1; Movstask.WMSId = 3; Movstask.Remark = 0; Movstask.PalletCode = "text"; Movstask.CurrentAddress = "text"; //开始数据库事务 _unitOfWorkManage.BeginTran(); BaseDal.AddData(Movstask); _stockRepository.DeleteData(stock); _stockRepository.DeleteData(Towstock); _locationRepository.UpdateData(location); _locationRepository.UpdateData(locationTow); _taskhtyRepository.AddData(taskhty); BaseDal.DeleteData(nawtask); //提交事务 _unitOfWorkManage.CommitTran(); } } else if (nawtask.TaskType == (int)TaskOutboundTypeEnum.OutInventory || nawtask.TaskType == (int)TaskMoveEnum.Mowe) { //处理任务信息 Dt_Task_hty taskhty = new Dt_Task_hty(); taskhty.TaskNum = nawtask.TaskNum; taskhty.Roadway = nawtask.Roadway; taskhty.TaskType = nawtask.TaskType; taskhty.TaskState = (int)TaskOutStatusEnum.OutFinish; taskhty.SourceAddress = nawtask.SourceAddress; taskhty.TargetAddress = nawtask.TargetAddress; taskhty.ExceptionMessage = nawtask.ExceptionMessage; taskhty.Grade = nawtask.Grade; taskhty.Dispatchertime = nawtask.Dispatchertime; taskhty.Remark = nawtask.Remark; taskhty.PalletCode = nawtask.PalletCode; taskhty.NextAddress = nawtask.NextAddress; taskhty.CurrentAddress = nawtask.CurrentAddress; if (nawtask.TaskType == (int)TaskOutboundTypeEnum.OutInventory) { //开始创建任务 Dt_Task Movstask = new Dt_Task(); Movstask.Roadway = "TC01"; Movstask.TaskType = (int)TaskMoveEnum.Mowe; Movstask.TaskState = (int)TaskMoveStatusEnum.OutNewMove; Movstask.SourceAddress = "0"; Movstask.TargetAddress = "1-5-1"; Movstask.NextAddress = "text"; Movstask.Grade = 1; Movstask.WMSId = 3; Movstask.Remark = 0; Movstask.PalletCode = "text"; Movstask.CurrentAddress = "text"; //开始数据库事务 _unitOfWorkManage.BeginTran(); BaseDal.AddData(Movstask); _taskhtyRepository.AddData(taskhty); BaseDal.DeleteData(nawtask); //提交事务 _unitOfWorkManage.CommitTran(); } else { //开始数据库事务 _unitOfWorkManage.BeginTran(); _taskhtyRepository.AddData(taskhty); BaseDal.DeleteData(nawtask); //提交事务 _unitOfWorkManage.CommitTran(); } } content = WebResponseContent.Instance.OK(); } catch (Exception ex) { //回滚事务 _unitOfWorkManage.RollbackTran(); content = WebResponseContent.Instance.Error($"任务完成异常,任务号:【{taskNum}】"); UpdateTaskExceptionMessage(taskNum,ex.Message); } return content; } /// /// 恢复挂起任务 /// /// 任务号 /// 返回处理结果 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)TaskInStatusEnum.InPending && task.TaskState != (int)TaskOutStatusEnum.OutPending) { return content = WebResponseContent.Instance.Error($"该任务状态不可恢复,任务号:【{taskNum}】,任务状态:【{task.TaskState}】"); } Dt_TaskExecuteDetail taskExecuteDetail = _taskExecuteDetailRepository.QueryFirst(x => x.TaskId == task.TaskId && x.IsNormal, new Dictionary { { nameof(Dt_TaskExecuteDetail.TaskDetailId), OrderByType.Desc } }); if (taskExecuteDetail != null) { task.TaskState = taskExecuteDetail.TaskState; } else { if (task.TaskType.GetTaskTypeGroup() == TaskTypeGroup.OutbondGroup) { task.TaskState = (int)TaskOutStatusEnum.OutNew; } else if (task.TaskType.GetTaskTypeGroup() == TaskTypeGroup.InboundGroup) { task.TaskState = (int)TaskInStatusEnum.InNew; } //todo } 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; } /// /// 回滚任务状态 /// /// 任务号 /// 返回处理结果 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 { { 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; } public WebResponseContent AtOnceUpdate(int taskid) { WebResponseContent content = new WebResponseContent(); Dt_Task nawtask = BaseDal.QueryFirst(v => v.TaskId == taskid); //入库 if (nawtask.TaskType == (int)TaskInboundTypeEnum.Inbound) { //剔除入库 var station = _dt_stationInfoRepository.QueryFirst(v => v.msg == "剔除架"); string sourceAddress = station.Row + "-" + station.Column + "-1"; if (nawtask.SourceAddress.Equals(sourceAddress)) { var batck = _batchinfoRepository.QueryFirst(v => v.Id == 1); //新建库存 Dt_StockInfo stock = new Dt_StockInfo(); stock.LocationCode = nawtask.TargetAddress; stock.StockStatus = (int)stockEnum.Free; stock.BatchNo = batck.InBatch; stock.Remark = 3; //修改货位信息 var location = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.TargetAddress); location.LocationStatus = (int)LocationStatusEnum.InStock; //处理任务信息 Dt_Task_hty taskhty = new Dt_Task_hty(); taskhty.TaskNum = nawtask.TaskNum; taskhty.Roadway = nawtask.Roadway; taskhty.TaskType = nawtask.TaskType; taskhty.TaskState = (int)TaskInStatusEnum.Line_InFinish; taskhty.SourceAddress = nawtask.SourceAddress; taskhty.TargetAddress = nawtask.TargetAddress; taskhty.ExceptionMessage = nawtask.ExceptionMessage; taskhty.Grade = nawtask.Grade; taskhty.Dispatchertime = nawtask.Dispatchertime; taskhty.Remark = nawtask.Remark; taskhty.PalletCode = nawtask.PalletCode; taskhty.NextAddress = nawtask.NextAddress; taskhty.CurrentAddress = nawtask.CurrentAddress; //开始数据库事务 _unitOfWorkManage.BeginTran(); _stockRepository.AddData(stock); _locationRepository.UpdateData(location); _taskhtyRepository.AddData(taskhty); BaseDal.DeleteData(nawtask); //提交事务 _unitOfWorkManage.CommitTran(); } //正常入库 else { var batck = _batchinfoRepository.QueryFirst(v => v.Id == 1); //新建库存 Dt_StockInfo stock = new Dt_StockInfo(); stock.LocationCode = nawtask.TargetAddress; stock.StockStatus = (int)stockEnum.Free; stock.BatchNo = batck.InBatch; if (nawtask.Remark == (int)MateTypeEnum.ZiChan) { stock.Remark = (int)MateTypeEnum.ZiChan; } else { stock.Remark = (int)MateTypeEnum.WaiGou; } Dt_StockInfo stockTow = new Dt_StockInfo(); stockTow.LocationCode = nawtask.NextAddress; stockTow.StockStatus = (int)stockEnum.Free; stockTow.BatchNo = batck.InBatch; if (nawtask.Remark == (int)MateTypeEnum.ZiChan) { stockTow.Remark = (int)MateTypeEnum.ZiChan; } else { stockTow.Remark = (int)MateTypeEnum.WaiGou; } //修改货位信息 var location = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.TargetAddress); location.LocationStatus = (int)LocationStatusEnum.InStock; //修改货位信息 var locationtow = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.NextAddress); locationtow.LocationStatus = (int)LocationStatusEnum.InStock; //处理任务信息 Dt_Task_hty taskhty = new Dt_Task_hty(); taskhty.TaskNum = nawtask.TaskNum; taskhty.Roadway = nawtask.Roadway; taskhty.TaskType = nawtask.TaskType; taskhty.TaskState = (int)TaskInStatusEnum.Line_InFinish; taskhty.SourceAddress = nawtask.SourceAddress; taskhty.TargetAddress = nawtask.TargetAddress; taskhty.ExceptionMessage = nawtask.ExceptionMessage; taskhty.Grade = nawtask.Grade; taskhty.Dispatchertime = nawtask.Dispatchertime; taskhty.Remark = nawtask.Remark; taskhty.PalletCode = nawtask.PalletCode; taskhty.NextAddress = nawtask.NextAddress; taskhty.CurrentAddress = nawtask.CurrentAddress; //开始数据库事务 _unitOfWorkManage.BeginTran(); _stockRepository.AddData(stock); _stockRepository.AddData(stockTow); _locationRepository.UpdateData(location); _locationRepository.UpdateData(locationtow); _taskhtyRepository.AddData(taskhty); BaseDal.DeleteData(nawtask); //提交事务 _unitOfWorkManage.CommitTran(); } } //出库 else if (nawtask.TaskType == (int)TaskOutboundTypeEnum.Outbound) { //剔除出库 var station = _dt_stationInfoRepository.QueryFirst(v => v.msg == "西跨架子"); string targetAddress = station.Row + "-" + station.Column + "-1"; if (nawtask.TargetAddress.Equals(targetAddress)) { //查找库存 var stock = _stockRepository.QueryFirst(v => v.LocationCode == nawtask.SourceAddress); if (stock == null) { throw new Exception($"未找到库存信息货位号:【{nawtask.TargetAddress}】"); } //修改货位状态 var location = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.SourceAddress); location.LocationStatus = (int)LocationStatusEnum.Free; //准备历史任务数据 Dt_Task_hty taskhty = new Dt_Task_hty(); taskhty.TaskNum = nawtask.TaskNum; taskhty.Roadway = nawtask.Roadway; taskhty.TaskType = nawtask.TaskType; taskhty.TaskState = (int)TaskOutStatusEnum.OutFinish; taskhty.SourceAddress = nawtask.SourceAddress; taskhty.TargetAddress = nawtask.TargetAddress; taskhty.ExceptionMessage = nawtask.ExceptionMessage; taskhty.Grade = nawtask.Grade; taskhty.Dispatchertime = nawtask.Dispatchertime; taskhty.Remark = nawtask.Remark; taskhty.PalletCode = nawtask.PalletCode; taskhty.NextAddress = nawtask.NextAddress; taskhty.CurrentAddress = nawtask.CurrentAddress; //开始数据库事务 _unitOfWorkManage.BeginTran(); _stockRepository.DeleteData(stock); _locationRepository.UpdateData(location); _taskhtyRepository.AddData(taskhty); BaseDal.DeleteData(nawtask); //提交事务 _unitOfWorkManage.CommitTran(); } //正常出库 else { //查找库存 var stock = _stockRepository.QueryFirst(v => v.LocationCode == nawtask.SourceAddress); if (stock == null) { throw new Exception($"未找到库存信息货位号:【{nawtask.TargetAddress}】"); } var Towstock = _stockRepository.QueryFirst(v => v.LocationCode == nawtask.NextAddress); //修改货位状态 var location = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.SourceAddress); location.LocationStatus = (int)LocationStatusEnum.Free; //修改货位状态 var locationTow = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.NextAddress); locationTow.LocationStatus = (int)LocationStatusEnum.Free; //准备历史任务数据 Dt_Task_hty taskhty = new Dt_Task_hty(); taskhty.TaskNum = nawtask.TaskNum; taskhty.Roadway = nawtask.Roadway; taskhty.TaskType = nawtask.TaskType; taskhty.TaskState = (int)TaskOutStatusEnum.OutFinish; taskhty.SourceAddress = nawtask.SourceAddress; taskhty.TargetAddress = nawtask.TargetAddress; taskhty.ExceptionMessage = nawtask.ExceptionMessage; taskhty.Grade = nawtask.Grade; taskhty.Dispatchertime = nawtask.Dispatchertime; taskhty.Remark = nawtask.Remark; taskhty.PalletCode = nawtask.PalletCode; taskhty.NextAddress = nawtask.NextAddress; taskhty.CurrentAddress = nawtask.CurrentAddress; //开始数据库事务 _unitOfWorkManage.BeginTran(); _stockRepository.DeleteData(stock); _stockRepository.DeleteData(Towstock); _locationRepository.UpdateData(location); _locationRepository.UpdateData(locationTow); _taskhtyRepository.AddData(taskhty); BaseDal.DeleteData(nawtask); //提交事务 _unitOfWorkManage.CommitTran(); } } return content.OK("完成"); } } }