#region << 版 本 注 释 >>
|
/*----------------------------------------------------------------
|
* 命名空间：WIDESEAWCS_TaskInfoService
|
* 创建者：胡童庆
|
* 创建时间：2024/8/2 16:13:36
|
* 版本：V1.0.0
|
* 描述：
|
*
|
* ----------------------------------------------------------------
|
* 修改人：
|
* 修改时间：
|
* 版本：V1.0.1
|
* 修改说明：
|
*
|
*----------------------------------------------------------------*/
|
#endregion << 版 本 注 释 >>
|
|
using AutoMapper;
|
using Microsoft.AspNetCore.Mvc.RazorPages;
|
using NetTaste;
|
using Newtonsoft.Json;
|
using OfficeOpenXml.FormulaParsing.Excel.Functions.DateTime;
|
using OfficeOpenXml.FormulaParsing.Excel.Functions.Math;
|
using OfficeOpenXml.FormulaParsing.Excel.Functions.Text;
|
using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Diagnostics;
|
using System.Diagnostics.CodeAnalysis;
|
using System.Linq;
|
using System.Linq.Expressions;
|
using System.Reflection;
|
using System.Reflection.Metadata;
|
using System.Security.Policy;
|
using System.Text;
|
using System.Threading.Tasks;
|
using WIDESEA_Comm.Http;
|
using WIDESEA_Common.Log;
|
using WIDESEAWCS_Common.TaskEnum;
|
using WIDESEAWCS_Core;
|
using WIDESEAWCS_Core.BaseServices;
|
using WIDESEAWCS_Core.Enums;
|
using WIDESEAWCS_Core.Utilities;
|
using WIDESEAWCS_DTO.Enum;
|
using WIDESEAWCS_DTO.TaskInfo;
|
using WIDESEAWCS_ITaskInfoRepository;
|
using WIDESEAWCS_ITaskInfoService;
|
using WIDESEAWCS_Model.Models;
|
using WIDESEAWCS_QuartzJob.Models;
|
using WIDESEAWCS_QuartzJob.Service;
|
using static Microsoft.IO.RecyclableMemoryStreamManager;
|
|
namespace WIDESEAWCS_TaskInfoService
|
{
|
public class TaskService : ServiceBase<Dt_Task, ITaskRepository>, ITaskService
|
{
|
private readonly IRouterService _routerService;
|
private readonly ITaskExecuteDetailService _taskExecuteDetailService;
|
private readonly ITaskExecuteDetailRepository _taskExecuteDetailRepository;
|
private readonly ITask_HtyService _task_HtyService;
|
private readonly IMapper _mapper;
|
|
private Dictionary<string, OrderByType> _taskOrderBy = new()
|
{
|
{nameof(Dt_Task.Grade),OrderByType.Desc },
|
{nameof(Dt_Task.CreateDate),OrderByType.Asc},
|
};
|
|
public Dictionary<string, OrderByType> TaskOrderBy { get { return _taskOrderBy; } set { _taskOrderBy = value; } }
|
|
public List<int> TaskInboundTypes => typeof(TaskInboundTypeEnum).GetEnumIndexList();
|
|
public List<int> TaskOutboundTypes => typeof(TaskOutboundTypeEnum).GetEnumIndexList();
|
|
public TaskService(ITaskRepository BaseDal, IRouterService routerService, ITaskExecuteDetailService taskExecuteDetailService, ITaskExecuteDetailRepository taskExecuteDetailRepository, IMapper mapper, ITask_HtyService task_HtyService) : base(BaseDal)
|
{
|
_routerService = routerService;
|
_taskExecuteDetailService = taskExecuteDetailService;
|
_taskExecuteDetailRepository = taskExecuteDetailRepository;
|
_task_HtyService = task_HtyService;
|
_mapper = mapper;
|
}
|
|
public string urlWMSTask = WIDESEAWCS_Core.Helper.AppSettings.Configuration["urlWMSTask"];
|
public string urlTaskCompleted = WIDESEAWCS_Core.Helper.AppSettings.Configuration["urlTaskCompleted"];
|
public string urlWMSMovelibraryTask = WIDESEAWCS_Core.Helper.AppSettings.Configuration["urlWMSMovelibraryTask"];
|
public string urlQueryinventory = WIDESEAWCS_Core.Helper.AppSettings.Configuration["urlQueryinventory"];
|
public string urlEmptyOutbound = WIDESEAWCS_Core.Helper.AppSettings.Configuration["urlEmptyOutbound"];
|
public string urlRawmaterialout = WIDESEAWCS_Core.Helper.AppSettings.Configuration["urlRawmaterialout"];
|
public string urlPalletQueryinventory = WIDESEAWCS_Core.Helper.AppSettings.Configuration["urlPalletQueryinventory"];
|
/// <summary>
|
/// 接收WMS任务信息
|
/// </summary>
|
/// <param name="taskDTOs">WMS任务对象集合</param>
|
/// <returns>返回处理结果</returns>
|
public WebResponseContent ReceiveWMSTask([NotNull]List<Dt_Task> taskDTOs)
|
{
|
WebResponseContent content = new WebResponseContent();
|
try
|
{
|
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.TaskState = (int)TaskOutStatusEnum.OutNew;
|
task.Roadway = task.Roadway == "1" ? task.Roadway = "SC01" : task.Roadway = "SC02";
|
task.CreateDate = DateTime.Now;
|
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}");
|
}
|
finally
|
{
|
WriteLog.GetLog("接收任务").Write(JsonConvert.SerializeObject(content), "接收任务");
|
}
|
return content;
|
}
|
|
/// <summary>
|
/// 根据托盘号、起始地址向WMS请求任务
|
/// </summary>
|
/// <param name="palletCode">托盘号</param>
|
/// <param name="sourceAddress">起始地址</param>
|
/// <returns></returns>
|
public class GenerateInv
|
{
|
public string SourceAddress { get; set; }
|
public string PalletCode { get; set; }
|
}
|
|
public class GenerateInv3
|
{
|
|
public string PalletCode { get; set; }
|
public int outCount { get; set; }
|
public string TargetAddress { get; set; }
|
}
|
public WebResponseContent RequestWMSTask(string palletCode, string sourceAddress)
|
{
|
WebResponseContent content = new WebResponseContent();
|
try
|
{
|
GenerateInv generate = new GenerateInv()
|
{
|
SourceAddress=sourceAddress,
|
PalletCode = palletCode
|
};
|
content = HttpHelper.Post<WebResponseContent>($"{urlWMSTask}", generate);
|
WriteLog.GetLog("入库任务接收").Write(JsonConvert.SerializeObject(content), "入库任务接收");
|
Dt_Task task = new Dt_Task();
|
if (content != null)
|
{
|
if (content.Status)
|
{
|
task = JsonConvert.DeserializeObject<Dt_Task>(content.Data.ToString());
|
task.TaskState = (int)TaskInStatusEnum.Line_InFinish;
|
task.Roadway = task.Roadway == "1" ? task.Roadway = "SC01" : task.Roadway = "SC02";
|
BaseDal.AddData(task);
|
return content;
|
}
|
}
|
|
|
return content = WebResponseContent.Instance.Error();
|
}
|
catch (Exception ex)
|
{
|
return content = WebResponseContent.Instance.Error(ex.Message);
|
}
|
}
|
/// <summary>
|
/// 进行组盘
|
/// </summary>
|
/// <param name="palletCode"></param>
|
/// <returns></returns>
|
public WebResponseContent ToPlatform(string palletCode)
|
{
|
try
|
{
|
WebResponseContent content = new WebResponseContent();
|
GenerateInv generate = new GenerateInv()
|
{
|
SourceAddress = "",
|
PalletCode = palletCode
|
};
|
|
return content = HttpHelper.Post<WebResponseContent>($"{urlQueryinventory}", generate);
|
}
|
catch (Exception ex)
|
{
|
|
throw;
|
}
|
}
|
|
|
|
/// <summary>
|
/// 根据托盘号、起始地址向WMS请求任务
|
/// </summary>
|
/// <param name="palletCode">托盘号</param>
|
/// <param name="sourceAddress">起始地址</param>
|
/// <returns></returns>
|
public WebResponseContent RequestWMSTask2(string palletCode,string sourceAddress)
|
{
|
WebResponseContent content = new WebResponseContent();
|
try
|
{
|
GenerateInv generate = new GenerateInv()
|
{
|
SourceAddress = sourceAddress,
|
PalletCode = palletCode
|
};
|
content = HttpHelper.Post<WebResponseContent>($"{urlEmptyOutbound}", generate);
|
Dt_Task task = new Dt_Task();
|
if (content != null)
|
{
|
if (content.Status)
|
{
|
task = JsonConvert.DeserializeObject<Dt_Task>(content.Data.ToString());
|
task.TaskState = (int)TaskOutStatusEnum.OutNew;
|
task.TaskType = (int)TaskOutboundTypeEnum.Outbound;
|
task.Roadway = task.Roadway == "1" ? task.Roadway = "SC01" : task.Roadway = "SC02";
|
BaseDal.AddData(task);
|
return content = WebResponseContent.Instance.OK();
|
}
|
else
|
{
|
WriteLog.GetLog("PLC日志出库日志").Write($"空托出库失败，详情：{content.Message}", "需要空托");
|
}
|
}
|
return content = WebResponseContent.Instance.Error();
|
}
|
catch (Exception ex)
|
{
|
return content = WebResponseContent.Instance.Error(ex.Message);
|
}
|
}
|
|
/// <summary>
|
/// 根据托盘号、起始地址向WMS请求任务
|
/// </summary>
|
/// <param name="palletCode">托盘号</param>
|
/// <param name="sourceAddress">起始地址</param>
|
/// <returns></returns>
|
public WebResponseContent RequestWMSTask3(string palletCode, int outCount,string Loc)
|
{
|
WebResponseContent content = new WebResponseContent();
|
try
|
{
|
if (outCount==0)
|
{
|
outCount = 1;
|
}
|
GenerateInv3 generate = new GenerateInv3()
|
{
|
PalletCode = palletCode,
|
outCount = outCount,
|
TargetAddress= Loc
|
};
|
content = HttpHelper.Post<WebResponseContent>($"{urlRawmaterialout}", generate);
|
Dt_Task task = new Dt_Task();
|
if (content != null)
|
{
|
if (content.Status)
|
{
|
task = JsonConvert.DeserializeObject<Dt_Task>(content.Data.ToString());
|
task.TaskState = (int)TaskOutStatusEnum.OutNew;
|
task.TaskType = (int)TaskOutboundTypeEnum.Outbound;
|
task.Roadway = task.Roadway == "1" ? task.Roadway = "SC01" : task.Roadway = "SC02";
|
BaseDal.AddData(task);
|
return content = WebResponseContent.Instance.OK();
|
}
|
}
|
return content = WebResponseContent.Instance.Error();
|
}
|
catch (Exception ex)
|
{
|
return content = WebResponseContent.Instance.Error(ex.Message);
|
}
|
}
|
|
|
public WebResponseContent RequestWMSTask4()
|
{
|
WebResponseContent content = new WebResponseContent();
|
try
|
{
|
|
return content = HttpHelper.Get<WebResponseContent>($"{urlPalletQueryinventory}");
|
}
|
catch (Exception ex)
|
{
|
return content = WebResponseContent.Instance.Error(ex.Message);
|
}
|
}
|
/// <summary>
|
/// 根据深库位向wms申请判断浅库位是否有货，是否需要进行移库操作
|
/// </summary>
|
/// <param name="palletCode">托盘号</param>
|
/// <param name="sourceAddress">起始地址</param>
|
/// <returns></returns>
|
public Dt_Task RequestWMSTaskMovelibrary(Dt_Task _Task)
|
{
|
WebResponseContent content = new WebResponseContent();
|
content = HttpHelper.Get<WebResponseContent>($"{urlWMSMovelibraryTask}?TaskNum={_Task.TaskNum}&SourceAddress={_Task.SourceAddress}");
|
Dt_Task task = new Dt_Task();
|
if (content != null)
|
{
|
if (content.Status)
|
{
|
if(content.Data != null)
|
{
|
task = JsonConvert.DeserializeObject<Dt_Task>(content.Data.ToString());
|
if (task.TaskNum != _Task.TaskNum)
|
{
|
WriteLog.GetLog("接收任务").Write("移库任务："+JsonConvert.SerializeObject(task), "接收任务");
|
task.TaskState = (int)TaskRelocationTypeEnum.Relocation;
|
task.Roadway = task.Roadway == "1" ? task.Roadway = "SC01" : task.Roadway = "SC02";
|
task.TaskNum = task.TaskNum;
|
task.Grade = 3;
|
task.TaskType= (int)TaskRelocationTypeEnum.Relocation;
|
BaseDal.AddData(task);
|
return task;
|
}
|
}
|
}
|
else
|
{
|
WriteLog.GetLog("PLC日志").Write($"失败信息：{content.Message}", "移库信息");
|
return null;
|
|
}
|
}
|
|
return _Task;
|
}
|
|
|
public Dt_Task RequestWMSTaskMovelibrary2(Dt_Task _Task)
|
{
|
WebResponseContent content = new WebResponseContent();
|
content = HttpHelper.Get<WebResponseContent>($"{urlWMSMovelibraryTask}?TaskNum={_Task.TaskNum}&SourceAddress={_Task.TargetAddress}");
|
Dt_Task task = new Dt_Task();
|
if (content != null)
|
{
|
if (content.Status)
|
{
|
if (content.Data != null)
|
{
|
task = JsonConvert.DeserializeObject<Dt_Task>(content.Data.ToString());
|
if (task.TaskNum != _Task.TaskNum)
|
{
|
WriteLog.GetLog("接收任务").Write("移库任务：" + JsonConvert.SerializeObject(task), "接收任务");
|
task.TaskState = (int)TaskRelocationTypeEnum.Relocation;
|
task.Roadway = task.Roadway == "1" ? task.Roadway = "SC01" : task.Roadway = "SC02";
|
task.TaskNum = task.TaskNum;
|
task.Grade = 3;
|
task.TaskType = (int)TaskRelocationTypeEnum.Relocation;
|
BaseDal.AddData(task);
|
return task;
|
}
|
}
|
}
|
else
|
{
|
WriteLog.GetLog("PLC日志").Write($"失败信息：{content.Message}", "移库信息");
|
return null;
|
|
}
|
}
|
|
return _Task;
|
}
|
|
/// <summary>
|
/// 根据设备编号、当前地址查询输送线未执行的任务
|
/// </summary>
|
/// <param name="deviceNo">设备编号</param>
|
/// <param name="currentAddress">当前地址</param>
|
/// <returns></returns>
|
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);
|
}
|
|
/// <summary>
|
/// 根据任务号、下一地址查询输送线执行中的任务
|
/// </summary>
|
/// <param name="taskNum">任务号</param>
|
/// <param name="nextAddress">下一地址</param>
|
/// <returns></returns>
|
public Dt_Task QueryExecutingConveyorLineTask(int taskNum, string nextAddress)
|
{
|
return BaseDal.QueryFirst(x => x.TaskNum == taskNum && x.NextAddress == nextAddress && (x.TaskState == (int)TaskInStatusEnum.Line_InExecuting || x.TaskState == (int)TaskOutStatusEnum.Line_OutExecuting), TaskOrderBy);
|
}
|
|
/// <summary>
|
/// 根据任务号、当前地址查询输送线完成的任务
|
/// </summary>
|
/// <param name="taskNum">任务号</param>
|
/// <param name="currentAddress">当前地址</param>
|
/// <returns></returns>
|
public Dt_Task QueryCompletedConveyorLineTask(int taskNum, string currentAddress)
|
{
|
return BaseDal.QueryFirst(x => x.TaskNum == taskNum && x.CurrentAddress == currentAddress && (x.TaskState == (int)TaskInStatusEnum.Line_InFinish || x.TaskState == (int)TaskOutStatusEnum.Line_OutFinish), TaskOrderBy);
|
}
|
|
/// <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.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;
|
}
|
|
/// <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.Roadway == deviceNo && (TaskInboundTypes.Contains(x.TaskType) && x.TaskState == (int)TaskInStatusEnum.Line_InFinish || TaskOutboundTypes.Contains(x.TaskType) && x.TaskState == (int)TaskOutStatusEnum.OutNew), TaskOrderBy);
|
else
|
return BaseDal.QueryFirst(x => x.Roadway == deviceNo && x.CurrentAddress == currentAddress && (TaskInboundTypes.Contains(x.TaskType) && x.TaskState == (int)TaskInStatusEnum.Line_InFinish || TaskOutboundTypes.Contains(x.TaskType) && x.TaskState == (int)TaskOutStatusEnum.OutNew), TaskOrderBy);
|
}
|
|
public List<Dt_Task> CraneTaskList(string deviceNo)
|
{
|
return BaseDal.QueryData(x => x.Roadway == deviceNo && (x.TaskState == (int)TaskInStatusEnum.Line_InFinish || x.TaskState == (int)TaskOutStatusEnum.OutNew),TaskOrderBy);
|
}
|
|
public Dt_Task CutStackerCraneTask(string deviceNo)
|
{
|
Dt_Task dt_Task = BaseDal.QueryFirst(x => x.Roadway == deviceNo && (x.TaskState == (int)TaskOutStatusEnum.SC_OutExecuting || x.TaskState == (int)TaskOutStatusEnum.SC_OutFinish || x.TaskState == (int)TaskInStatusEnum.SC_InExecuting || x.TaskState == (int)TaskInStatusEnum.SC_InFinish));
|
return dt_Task;
|
}
|
|
public Dt_Task IngStackerCraneTask(string deviceNo)
|
{
|
//string deviceNot = deviceNo == "SC01" ? "1" : "2";
|
return BaseDal.QueryFirst(x => x.Roadway == deviceNo && x.TaskState == (int)TaskInStatusEnum.SC_InExecuting);
|
}
|
|
public Dt_Task IngStackerCraneTask2(string deviceNo)
|
{
|
//string deviceNot = deviceNo == "SC01" ? "1" : "2";
|
try
|
{
|
return BaseDal.QueryFirst(x => x.Roadway == deviceNo && x.TaskState == (int)TaskOutStatusEnum.SC_OutExecuting);
|
}
|
catch (Exception ex)
|
{
|
|
throw;
|
}
|
}
|
|
/// <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.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);
|
}
|
|
/// <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.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);
|
}
|
|
/// <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.Roadway == deviceNo && TaskOutboundTypes.Contains(x.TaskType) && x.TaskState == (int)TaskOutStatusEnum.OutNew && outStationCodes.Contains(x.CurrentAddress), TaskOrderBy);
|
}
|
|
/// <summary>
|
/// 根据出库货位查询是否有当前浅货位任务
|
/// </summary>
|
/// <param name="deviceNo">设备编号</param>
|
/// <param name="currentAddress">当前地址</param>
|
/// <returns>返回任务实体对象集合，可能为null</returns>
|
public List<Dt_Task> QueryStationIsOccupiedOutTasks(string deviceNo, string SourceAddress)
|
{
|
return BaseDal.QueryData(x => x.Roadway == deviceNo && SourceAddress.Contains(x.SourceAddress), TaskOrderBy);
|
}
|
|
public List<Dt_Task> QueryStationIsOccupiedOutTasks2(string deviceNo, string TargetAddress)
|
{
|
return BaseDal.QueryData(x => x.Roadway == deviceNo && TargetAddress.Contains(x.SourceAddress), 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}】");
|
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;
|
}
|
|
/// <summary>
|
/// 更新任务状态信息，并同步至WMS
|
/// </summary>
|
/// <param name="taskNum">任务号</param>
|
/// <param name="status">任务状态</param>
|
public void UpdateTaskStatus(int taskNum, int status)
|
{
|
Dt_Task task = BaseDal.QueryFirst(x => x.TaskNum == taskNum);
|
if (task == null) return;
|
task.TaskState = status;
|
task.ModifyDate = DateTime.Now;
|
BaseDal.UpdateData(task);
|
}
|
|
/// <summary>
|
/// 将任务状态修改为下一个状态
|
/// </summary>
|
/// <param name="taskNum">任务号</param>
|
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;
|
}
|
|
/// <summary>
|
/// 将任务状态修改为下一个状态
|
/// </summary>
|
/// <param name="task">任务实体对象</param>
|
/// <returns></returns>
|
public WebResponseContent UpdateTaskStatusToNext([NotNull] Dt_Task task)
|
{
|
WebResponseContent content = new WebResponseContent();
|
try
|
{
|
int oldState = task.TaskState;
|
if (task.TaskType == (int)TaskOutboundTypeEnum.Outbound)
|
{
|
if (task.TaskState >= (int)TaskOutStatusEnum.OutFinish)
|
{
|
return content = WebResponseContent.Instance.Error($"该任务状态不可跳转到下一步,任务号:【{task.TaskNum}】,任务状态:【{task.TaskState}】");
|
}
|
|
int nextStatus = task.TaskState.GetNextNotCompletedStatus<TaskOutStatusEnum>();
|
|
task.TaskState = nextStatus;
|
if (task.TaskState == (int)TaskOutStatusEnum.SC_OutExecuting)
|
{
|
task.Dispatchertime = DateTime.Now;
|
}
|
}
|
else if (task.TaskType == (int)TaskInboundTypeEnum.Inbound)
|
{
|
if (task.TaskState >= (int)TaskInStatusEnum.InFinish)
|
{
|
return content = WebResponseContent.Instance.Error($"该任务状态不可跳转到下一步,任务号:【{task.TaskNum}】,任务状态:【{task.TaskState}】");
|
}
|
|
int nextStatus = task.TaskState.GetNextNotCompletedStatus<TaskInStatusEnum>();
|
task.TaskState = nextStatus;
|
if (task.TaskState == (int)TaskInStatusEnum.SC_InExecuting)
|
{
|
task.Dispatchertime = DateTime.Now;
|
}
|
if (task.TaskState == (int)TaskRelocationTypeEnum.Relocation)
|
{
|
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 if (task.TaskType == (int)TaskInboundTypeEnum.Inbound)
|
{
|
if (task.TaskState <= (int)TaskRelocationStatusEnum.SC_RelocationFinish)
|
{
|
|
return content = WebResponseContent.Instance.Error($"该任务状态不可跳转到下一步,任务号:【{task.TaskNum}】,任务状态:【{task.TaskState}】");
|
}
|
|
int nextStatus = (int)TaskRelocationStatusEnum.SC_RelocationExecuting;
|
task.TaskState = nextStatus;
|
if (task.TaskState == (int)TaskRelocationStatusEnum.SC_RelocationExecuting)
|
{
|
task.Dispatchertime = DateTime.Now;
|
}
|
}
|
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;
|
}
|
|
/// <summary>
|
/// 根据任务号、当前地址更新任务位置信息
|
/// </summary>
|
/// <param name="taskNum">任务号</param>
|
/// <param name="currentAddress">当前地址</param>
|
/// <returns></returns>
|
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<Dt_Router> 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;
|
}
|
|
/// <summary>
|
/// 任务完成
|
/// </summary>
|
/// <param name="taskNum">任务编号</param>
|
/// <returns>返回处理结果</returns>
|
public class GenerateInv2
|
{
|
public string PalletCode { get; set; }
|
public string SourceAddress { get; set; }
|
public string TargetAddress { get; set; }
|
}
|
public WebResponseContent StackCraneTaskCompleted(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.TaskType == (int)TaskOutboundTypeEnum.Outbound && task.TaskState == (int)TaskOutStatusEnum.SC_OutExecuting)
|
{
|
/*List<Dt_Router> routers = _routerService.QueryNextRoutes(task.NextAddress, task.TargetAddress);
|
if (!routers.Any()) return WebResponseContent.Instance.Error($"未找到设备路由信息");*/
|
task.TaskState = (int)TaskOutStatusEnum.OutFinish;
|
BaseDal.UpdateData(task);
|
|
|
content = HttpHelper.Get<WebResponseContent>($"{urlTaskCompleted}?TaskNum={task.TaskNum}&HowWorks=2");
|
|
wcs_PLCto09("出库任务",$"条码：{task.PalletCode},任务号：{task.TaskNum}",$"调取wms任务反馈：{JsonConvert.SerializeObject(content)}");
|
|
task.ModifyDate = DateTime.Now;
|
BaseDal.DeleteData(task);
|
_task_HtyService.AddTaskHty(task);
|
_taskExecuteDetailService.AddTaskExecuteDetail(task.TaskId, $"出库完成");
|
//todo 同步到WMS
|
|
//暂不考虑多个出库口
|
}
|
else if (task.TaskType == (int)TaskInboundTypeEnum.Inbound && task.TaskState == (int)TaskInStatusEnum.SC_InExecuting)
|
{
|
task.TaskState = (int)TaskInStatusEnum.InFinish;
|
BaseDal.UpdateData(task);
|
|
content = HttpHelper.Get<WebResponseContent>($"{urlTaskCompleted}?TaskNum={task.TaskNum}&HowWorks=2");
|
|
wcs_PLCto09("入库任务", $"条码：{task.PalletCode},任务号：{task.TaskNum}", $"调取wms任务反馈：{JsonConvert.SerializeObject(content)}");
|
//todo
|
//int nextStatus = task.TaskState.GetNextNotCompletedStatus<TaskInStatusEnum>();
|
task.ModifyDate = DateTime.Now;
|
task.Modifier = "System";
|
BaseDal.DeleteData(task);
|
_task_HtyService.AddTaskHty(task);
|
_taskExecuteDetailService.AddTaskExecuteDetail(task.TaskId, $"入库完成");
|
|
}
|
else if (task.TaskType == (int)TaskRelocationTypeEnum.Relocation)
|
{
|
task.TaskState = (int)TaskOutStatusEnum.OutRest;
|
BaseDal.UpdateData(task);
|
|
content = HttpHelper.Get<WebResponseContent>($"{urlTaskCompleted}?TaskNum={task.TaskNum}&HowWorks=2");
|
|
wcs_PLCto09("入库任务", $"条码：{task.PalletCode},任务号：{task.TaskNum}", $"调取wms任务反馈：{JsonConvert.SerializeObject(content)}");
|
|
task.ModifyDate = DateTime.Now;
|
BaseDal.DeleteData(task);
|
_task_HtyService.AddTaskHty(task);
|
_taskExecuteDetailService.AddTaskExecuteDetail(task.TaskId, $"移库完成");
|
}
|
else if (task.TaskType.GetTaskTypeGroup() == TaskTypeGroup.OtherGroup)
|
{
|
|
}
|
else
|
{
|
throw new Exception($"任务类型错误,未找到该任务类型,任务号:【{taskNum}】,任务类型:【{task.TaskType}】");
|
}
|
content = WebResponseContent.Instance.OK();
|
}
|
catch (Exception ex)
|
{
|
content = WebResponseContent.Instance.Error($"任务完成异常,任务号:【{taskNum}】，原因：{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)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<string, OrderByType> { { 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;
|
}
|
|
/// <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;
|
}
|
|
|
/// <summary>
|
/// 删除数据
|
/// </summary>
|
/// <param name="keys">主键数组</param>
|
/// <returns></returns>
|
public virtual WebResponseContent DeleteData(object[] keys)
|
{
|
try
|
{
|
List<Dt_Task> tasks = BaseDal.QureyDataByIds(keys);
|
foreach (Dt_Task task in tasks)
|
{
|
_task_HtyService.AddTaskHty(task);
|
}
|
|
|
if (typeof(Dt_Task).GetNavigatePro() == null)
|
return BaseDal.DeleteDataByIds(keys) ? WebResponseContent.Instance.OK() : WebResponseContent.Instance.Error();
|
else
|
{
|
if (keys != null)
|
{
|
Type detailType = typeof(Dt_Task).GetDetailType();
|
string name = typeof(Dt_Task).GetMainIdByDetail();
|
List<object> dynamicDelKeys = new List<object>();
|
|
for (int i = 0; i < keys.Length; i++)
|
{
|
dynamicDelKeys.Add(keys[i]);
|
}
|
((SqlSugarClient)BaseDal.Db).BeginTran();
|
|
if (dynamicDelKeys.Count > 0)
|
BaseDal.Db.Deleteable<object>().AS(detailType.Name).Where($"{name} in (@id)", new { id = dynamicDelKeys.ToArray() }).ExecuteCommandHasChange();
|
|
BaseDal.DeleteDataByIds(keys);
|
|
((SqlSugarClient)BaseDal.Db).CommitTran();
|
|
return WebResponseContent.Instance.OK();
|
}
|
else
|
{
|
return WebResponseContent.Instance.Error("参数错误");
|
}
|
}
|
}
|
catch (Exception ex)
|
{
|
((SqlSugarClient)BaseDal.Db).RollbackTran();
|
return WebResponseContent.Instance.Error(ex.Message);
|
}
|
}
|
|
public WebResponseContent ReceiveWCSTask(int tasknum)
|
{
|
Dt_Task tasks = BaseDal.QueryFirst(x => x.TaskNum == tasknum);
|
if(tasks == null)
|
{
|
return WebResponseContent.Instance.Error();
|
}
|
else
|
{
|
try
|
{
|
_task_HtyService.AddTaskHty(tasks);
|
BaseDal.DeleteData(tasks);
|
WriteLog.Write_Log("WMS手动删除任务", "删除成功", $"申请删除的条码：{tasks.TaskNum},托盘条码：{tasks.PalletCode}", new { 信息 = "删除成功" });
|
return WebResponseContent.Instance.OK();
|
|
}
|
catch (Exception ex)
|
{
|
WriteLog.Write_Log("WMS手动删除任务", "删除失败", $"申请删除的条码：{tasks.TaskNum},托盘条码：{tasks.PalletCode}", new { 信息 = ex.Message });
|
return WebResponseContent.Instance.Error();
|
}
|
}
|
|
}
|
|
|
public void wcs_PLCto09(string SCLLinStack, string Logtype, string Magessadd)
|
{
|
WriteLog.Write_Log("任务完成交互", SCLLinStack, Logtype, new { 信息 = Magessadd });
|
}
|
}
|
}
|
