using Autofac.Core; using MailKit.Search; using Mapster; using Masuit.Tools; using System.Diagnostics; using System.Text.RegularExpressions; using System.Threading.Tasks; using WIDESEA_Core.Const; using WIDESEA_DTO.WMS; using WIDESEA_IServices; using WIDESEA_IStoragIntegrationServices; using WIDESEAWCS_BasicInfoRepository; using WIDESEAWCS_Model.Models; using WIDESEAWCS_QuartzJob.Models; namespace WIDESEA_StorageTaskServices; public partial class Dt_TaskService : ServiceBase, IDt_TaskService { private readonly LogFactory LogFactory = new LogFactory(); private readonly IUnitOfWorkManage _unitOfWorkManage; private readonly IDt_Task_HtyRepository _task_HtyRepository; private readonly IMapper _mapper; private readonly ILocationInfoRepository _locationRepository; private readonly ITaskExecuteDetailRepository _taskExecuteDetailRepository; private readonly ILocationStatusChangeRecordRepository _locationStatusChangeRecordRepository; private readonly IDt_StationManagerRepository _stationManagerRepository; private readonly ISys_ConfigService _configService; private readonly IDt_PalletStockInfoRepository _palletStockInfoRepository; public Dt_TaskService(IDt_TaskRepository BaseDal, IUnitOfWorkManage unitOfWorkManage, IDt_OutOrderRepository outOrderRepository, IStockInfoRepository stockInfoRepository, IDt_Task_HtyRepository task_HtyRepository, IMapper mapper, ILocationInfoRepository locationRepository, ITaskExecuteDetailRepository taskExecuteDetailRepository, ILocationStatusChangeRecordRepository locationStatusChangeRecordRepository, IStockInfoDetailRepository stockInfoDetailRepository, IDt_StationManagerRepository stationManagerRepository, ISys_ConfigService configService, IDt_PalletStockInfoRepository palletStockInfoRepository) : base(BaseDal) { _unitOfWorkManage = unitOfWorkManage; _task_HtyRepository = task_HtyRepository; _mapper = mapper; _locationRepository = locationRepository; _taskExecuteDetailRepository = taskExecuteDetailRepository; _locationStatusChangeRecordRepository = locationStatusChangeRecordRepository; _stationManagerRepository = stationManagerRepository; _configService = configService; _palletStockInfoRepository = palletStockInfoRepository; } #region 外部接口方法 #region 入库任务完成 /// /// 完成入库任务 /// /// 任务数据合集 /// 返回结果集 public async Task CompleteInboundTaskAsync(Dt_Task task) { // 初始化响应内容 WebResponseContent content = new WebResponseContent(); try { // 获取MES信息和目标位置信息 //var mes_Wheels = await _InWheels_MesRepository.QueryFirstNavAsync(x => x.Wheels_Num == task.PalletCode); var locationInf = await _locationRepository.QueryFirstAsync(x => x.LocationCode == task.TargetAddress && x.RoadwayNo == task.Roadway); int lastStatus = locationInf.LocationStatus; // 更新目标位置状态为库存中 locationInf.LocationStatus = (int)LocationEnum.InStock; // 创建历史任务实例模型 var taskHty = CreateHistoricalTask(task); // 根据创建库存实例模型 Dt_PalletStockInfo palletStockInfo = new Dt_PalletStockInfo { }; // 执行数据库事务 bool isResult = await ExecuteTransaction(palletStockInfo, taskHty, locationInf, task.TaskId); if (isResult) { _locationStatusChangeRecordRepository.AddLocationStatusChangeRecord(locationInf, lastStatus, (int)StatusChangeTypeEnum.AutomaticStorage, task.TaskNum); content.OK("入库任务完成成功"); } else { content.Error("入库任务完成失败"); } } catch (Exception err) { // 记录异常信息到控制台和日志 Console.WriteLine(err.Message.ToString()); LogFactory.GetLog("任务完成").Error(true, err); content.Error(err.Message); } return content; } #endregion 入库任务完成 #region 出库任务完成 public async Task CompleteStackTaskAsync(Dt_Task task, Dt_PalletStockInfo stock) { WebResponseContent content = new WebResponseContent(); try { // 更新库位状态与任务状态 //(var loc, var tas) = UpdateStockAndTaskStatus(stock, task); //var taskHty = task.Adapt(); //taskHty.FinishTime = DateTime.Now; //taskHty.OperateType = (int)OperateTypeEnum.自动完成; //Dt_WheelsStock_hty stockInfo_Hty = stock.Adapt(); //stockInfo_Hty.FinishWheelDate = DateTime.Now; //stockInfo_Hty.OperateType = (int)OperateTypeEnum.自动完成; //// 事务处理 //await _unitOfWorkManage.UseTranAsync(async () => //{ // var isLocationUpdate = await _locationRepository.UpdateDataAsync(loc); //更新库位 // //var isTaskUpdated = await BaseDal.DeleteDataByIdAsync(task.TaskId); //删除任务 // var isTaskAdd = await _task_HtyRepository.AddDataAsync(taskHty) > 0; //加入历史任务 //}); return content.OK("任务完成成功", task.Remark); } catch (Exception err) { LogFactory.GetLog("任务完成").Error(true, $"系统异常,异常信息:{err.Message}"); return content.Error(err.Message); } } private (DtLocationInfo, Dt_Task) UpdateStockAndTaskStatus(Dt_WheelsStock stock, Dt_Task task) { var location = _locationRepository.QueryFirst(x => x.LocationCode == task.SourceAddress && x.RoadwayNo == task.Roadway); int lastStatus = location.LocationStatus; location.LocationStatus = (int)LocationEnum.Free; task.TaskState = (int)TaskOutStatusEnum.OutFinish; //task.CurrentAddress = task.NextAddress; //task.NextAddress = task.TargetAddress; _locationStatusChangeRecordRepository.AddLocationStatusChangeRecord(location, lastStatus, (int)StatusChangeTypeEnum.AutomaticDelivery, task.TaskNum); LogFactory.GetLog("任务完成").Info(true, "更新库位状态与任务状态"); return (location, task); } #endregion #region 任务完成 /// /// 完成任务 /// /// 任务编号 /// 返回结果集 public async Task CompleteAsync(int taskNum) { // 初始化响应内容 WebResponseContent content = new WebResponseContent(); // 提取任务数据 LogFactory.GetLog("任务完成").InfoFormat(true, "提取任务数据", $"任务号:{taskNum}"); // 验证任务是否存在 var task = await GetByTaskNum(taskNum); if (task == null) { return content.Error("任务不存在"); } LogFactory.GetLog("任务完成").InfoFormat(true, "验证任务是否存在", JsonConvert.SerializeObject(task)); // 验证库存是否存在 var stock = await _palletStockInfoRepository.QueryFirstNavAsync(x => x.PalletCode == task.PalletCode); // 根据任务类型调用相应的完成任务方法 switch (task.TaskType) { case (int)TaskInboundTypeEnum.Inbound: case (int)TaskInboundTypeEnum.InWheels: case (int)TaskInboundTypeEnum.InBrake: LogFactory.GetLog("任务完成").InfoFormat(true, "入库任务", ""); return await CompleteInboundTaskAsync(task); case (int)TaskOutboundTypeEnum.Outbound: case (int)TaskOutboundTypeEnum.OutBrake: case (int)TaskOutboundTypeEnum.OutWheels: LogFactory.GetLog("任务完成").InfoFormat(true, "出库任务", ""); return await CompleteStackTaskAsync(task, stock); default: return content.Error("任务类型不存在"); } } #endregion 任务完成 #region 请求任务入库 #region #endregion 请求任务入库 /// /// 更新任务货位 /// /// /// public async Task UpdateExistingTask(RequestTaskDto input) { WebResponseContent content = new WebResponseContent(); try { var task = await BaseDal.QueryFirstAsync(x => x.PalletCode == input.PalletCode); if (task == null) return content.Error($"暂未找到【{input.PalletCode}】的任务"); return content = await UpdateExistingTask(input, task); } catch (Exception err) { return content.Error(err.Message); } } #endregion 外部接口方法 #region 请求出库(实盘) /// /// 创建任务DTO /// private WMSTaskDTO CreateTaskDTO(Dt_Task task) { return new WMSTaskDTO { TaskNum = task.TaskNum.Value, Grade = task.Grade.Value, PalletCode = task.PalletCode, RoadWay = task.Roadway, SourceAddress = task.SourceAddress, TargetAddress = task.TargetAddress, TaskState = task.TaskState.Value, Id = 0, TaskType = task.TaskType }; } #endregion 请求出库(实盘&空盘) #region 任务状态更改 /// /// 更新任务状态 /// /// /// /// public async Task UpdateTaskStatus(int taskNum, int taskState) { WebResponseContent content = new WebResponseContent(); try { var task = await BaseDal.QueryFirstAsync(x => x.TaskNum == taskNum); if (task == null) return content.Error("未找到任务"); if (taskState == (int)TaskOutStatusEnum.Line_OutFinish || taskState == (int)TaskInStatusEnum.SC_InFinish) { var taskHty = CreateHistoricalTask(task); await _unitOfWorkManage.UseTranAsync(async () => { var asb = await BaseDal.DeleteDataByIdAsync(task.TaskId); var asbHty = await _task_HtyRepository.AddDataAsync(taskHty) > 0; if (asb && asbHty) content.OK(); else throw new Exception(); }); content.OK(); } else { task.TaskState = taskState; var asb = await BaseDal.UpdateDataAsync(task); if (asb) content.OK(); else content.Error(); } } catch (Exception ex) { content.Error(ex.Message); } return content; } #endregion 任务状态更改 #region 指定任务出库 public WebResponseContent CreateAndSendOutboundTask(SaveModel saveModel) { WebResponseContent content = new WebResponseContent(); try { string palletCode = saveModel.MainData["palletCode"].ToString(); string station = saveModel.MainData["station"].ToString(); // 查询库存信息 var stockInfo = _palletStockInfoRepository.QueryFirst(x => x.PalletCode == palletCode); if (stockInfo == null) { return content.Error("未查询到对应的库存信息"); } if (stockInfo.StockStatus != 1) return content.Error("指定失败:当前状态不允许指定出库"); stockInfo.StockStatus = 4; //查询库位是否锁定, var location = _locationRepository.QueryFirst(x => x.LocationCode == stockInfo.LocationCode); if (location.LocationStatus == (int)LocationEnum.Lock) return content.Error("库位锁定,请先解锁后再指定出库"); location.LocationStatus = (int)LocationEnum.InStockDisable; var task = BaseDal.QueryFirst(x => x.PalletCode == palletCode); if (task != null) { return content.Error($"【{palletCode}】已存在任务"); } // var stationInfo = _stationManagerRepository.QueryFirst(x => x.stationChildCode == station); // 创建并添加任务到数据库 task = new Dt_Task { Grade = 1, Roadway = "SC1", TargetAddress = station, Dispatchertime = DateTime.Now, MaterialNo = "", NextAddress = "2010", OrderNo = null, PalletCode = stockInfo.PalletCode, SourceAddress = stockInfo.LocationCode, CurrentAddress = stockInfo.LocationCode, TaskState = (int)TaskOutStatusEnum.OutNew, TaskType = (int)TaskOutboundTypeEnum.OutWheels, TaskNum = BaseDal.GetTaskNo().Result, Creater = "System", CreateDate = DateTime.Now, TaskId = 0, //task_bak1 = JsonConvert.SerializeObject(checkInfo) }; // 创建任务传输用的DTO对象 var taskDTO = CreateTaskDTO(task); // 获取WMS IP地址用于发送任务请求 var wmsIpAddress = GetWCSIpReceiveTask(); if (wmsIpAddress == null) { throw new InvalidOperationException("WMS IP 未配置"); } var tasks = new List() { taskDTO }; // 发送任务请求到WMS var result = HttpHelper.Post(wmsIpAddress, tasks.ToJsonString()); content = JsonConvert.DeserializeObject(result); if (content.Status) { // 添加任务到数据库 BaseDal.AddData(task); // 更新库位位置状态为不可用 _locationRepository.UpdateData(location); _palletStockInfoRepository.UpdateData(stockInfo); } } catch (Exception ex) { Console.WriteLine($"发生异常: {ex.Message}"); content.Error(ex.Message); } return content; } private string GetWCSIpReceiveTask() { var configs = _configService.GetConfigsByCategory(CateGoryConst.CONFIG_SYS_IPAddress); var wmsBase = configs.FirstOrDefault(x => x.ConfigKey == SysConfigConst.WCSIPAddress)?.ConfigValue; var ipAddress = configs.FirstOrDefault(x => x.ConfigKey == SysConfigConst.ReceiveTask)?.ConfigValue; if (wmsBase == null || ipAddress == null) { return null; } return wmsBase + ipAddress; } #endregion 指定任务出库 #endregion 外部接口方法 #region 内部调用方法 /// /// 创建一个新的任务 /// /// 任务模型 /// 创建的任务 public async Task Create(Dt_Task model) { return await BaseDal.Create(model); } /// /// 批量创建任务 /// /// 任务模型列表 /// 是否创建成功 public async Task Create(List models) { return await BaseDal.Create(models); } /// /// 删除一个任务 /// /// 任务ID /// 是否删除成功 public async Task Delete(int id) { return await BaseDal.Delete(id); } /// /// 批量删除任务 /// /// 任务ID列表 /// 是否删除成功 public async Task Delete(List ids) { return await BaseDal.Delete(ids); } public override WebResponseContent DeleteData(object[] key) { WebResponseContent content = new WebResponseContent(); // 创建历史任务实例模型 try { Dt_Task task = BaseDal.QueryFirst(x => x.TaskId == Convert.ToInt32(key[0])); if (task == null) { return content.Error("未找到任务信息!"); } if (task.TaskState != (int)TaskInStatusEnum.InNew && task.TaskState != (int)TaskOutStatusEnum.OutNew && task.TaskState != (int)TaskStatus.Created) { return content.Error("任务不处于新建状态,禁止删除!"); } var taskHtyNG = CreateHistoricalTask(task, true); //if (task.TaskState == (int)TaskInStatusEnum.InNew || task.TaskState == (int)TaskOutStatusEnum.OutNew) //{ // //if(task.TaskType == ) //} // 添加历史任务 var isTaskHtyAdd = _task_HtyRepository.AddData(taskHtyNG) > 0; // 删除任务数据 var isTaskDelete = BaseDal.Delete(task.TaskId); return content.OK("删除成功!"); } catch (Exception ex) { return content.Error("删除任务异常:" + ex.Message); } } /// /// 通过ID获取任务 /// /// 任务ID /// 任务模型 public async Task GetById(int id) { return await BaseDal.GetById(id); } /// /// 获取所有任务列表 /// /// 任务模型列表 public async Task> GetList() { return await BaseDal.GetList(); } /// /// 根据出库订单ID获取任务列表 /// /// 出库订单ID /// 任务模型列表 public async Task> GetListByOutOrder(int outOrderId) { return await BaseDal.GetListByOutOrder(outOrderId); } /// /// 根据出库订单ID和状态获取任务列表 /// /// 出库订单ID /// 任务状态 /// 任务模型列表 public async Task> GetListByOutOrderAndStatus(int outOrderId, int status) { return await BaseDal.GetListByOutOrderAndStatus(outOrderId, status); } /// /// 根据状态获取任务列表 /// /// 任务状态 /// 任务模型列表 public async Task> GetListByStatus(int status) { return await BaseDal.GetListByStatus(status); } /// /// 更新一个任务 /// /// 任务模型 /// 是否更新成功 public async Task Update(Dt_Task model) { return await BaseDal.UpdateDataAsync(model); } /// /// 批量更新任务 /// /// 任务模型列表 /// 是否更新成功 public async Task Update(List models) { return await BaseDal.UpdateDataAsync(models); } /// /// 检查任务是否存在 /// /// 托盘编码 /// 任务是否存在 public bool IsExist(string palletCode) { return Db.Queryable().Any(x => x.PalletCode == palletCode); } /// /// 根据货位ID获取任务 /// /// /// public async Task GetByLocation(string locationID) { return await BaseDal.QueryFirstAsync(x => x.SourceAddress == locationID); } /// /// 根据任务号获取任务 /// /// /// public async Task GetByTaskNum(int taskNum) { return await BaseDal.QueryFirstAsync(x => x.TaskNum == taskNum); } #endregion 内部调用方法 #region private 内部方法 /// /// 创建历史任务记录 /// /// /// private Dt_Task_Hty CreateHistoricalTask(Dt_Task task, bool isHand = false) { // 更新任务状态 task.TaskState = task.TaskType > 199 ? (int)TaskInStatusEnum.InFinish : (int)TaskOutStatusEnum.OutFinish; task.CurrentAddress = task.NextAddress; // 创建历史任务 var taskHty = _mapper.Map(task); taskHty.FinishTime = DateTime.Now; taskHty.TaskId = 0; taskHty.OperateType = isHand ? (int)OperateTypeEnum.人工删除 : (int)OperateTypeEnum.自动完成; taskHty.SourceId = task.TaskId; if (isHand) { taskHty.Creater = App.User.UserName != null ? App.User.UserName : "System"; } taskHty.TaskState = task.TaskType > 199 ? (int)TaskInStatusEnum.InFinish : (int)TaskOutStatusEnum.OutFinish; return taskHty; } /// /// 更新库存位置 /// /// 库存对象 /// 目标位置 // 更新库存和位置信息 private (Dt_WheelsStock, DtLocationInfo, DtLocationInfo) UpdateStockLocation(Dt_WheelsStock stock, Dt_Task task) { //修改来源库位和 目标库位状态 var fromLocation = _locationRepository.QueryFirst(x => x.LocationCode == task.SourceAddress && x.RoadwayNo == task.Roadway); fromLocation.LocationStatus = (int)LocationEnum.Free; var toLocation = _locationRepository.QueryFirst(x => x.LocationCode == task.TargetAddress && x.RoadwayNo == task.Roadway); toLocation.LocationStatus = (int)LocationEnum.InStock; // 将库存位置设置为目标位置 stock.Wheels_Location = task.TargetAddress; // 返回更新后的库存和位置信息 return (stock, fromLocation, toLocation); } #region 执行数据库事务 /// /// 执行数据库事务 /// /// 库存对象 /// 历史任务对象 /// 任务ID /// private async Task ExecuteTransaction(Dt_PalletStockInfo stock, Dt_Task_Hty taskHty, DtLocationInfo locationInfo, int taskId /*Dt_InWheels_mes inWheels_Mes = null*/) { _unitOfWorkManage.BeginTran(); try { var isUpdateStock = false; var isDeleteWheelsMes = false; // 添加库存 isUpdateStock = _palletStockInfoRepository.AddData(stock) > 0; //if (inWheels_Mes != null) //{ // isDeleteWheelsMes = _InWheels_MesRepository.DeleteData(inWheels_Mes); // //var wheels_Mes_Hty = inWheels_Mes.Adapt(); // //wheels_Mes_Hty.Wheels_CurrentStatue = "2"; // //wheels_Mes_Hty.FinishDate = DateTime.Now; // //wheels_Mes_Hty.OperateType = (int)OperateTypeEnum.自动完成; // //_InWheels_Mes_HtyRepository.AddData(wheels_Mes_Hty); //} // 添加历史任务 var isTaskHtyAdd = await _task_HtyRepository.AddDataAsync(taskHty) > 0; // 修改移库前货位状态 var isUpdateLoc = _locationRepository.UpdateData(locationInfo); // 删除任务数据 var isTaskDelete = await Delete(taskId); // 提交或回滚事务 if (isUpdateStock && isTaskHtyAdd && isTaskDelete && isUpdateLoc && isDeleteWheelsMes) { LogFactory.GetLog("任务完成").InfoFormat(true, "任务完成", $"事务处理完成,提交事务。添加历史任务:{isTaskHtyAdd},删除任务数据:{isTaskDelete},更新或添加库存:{isUpdateStock},修改入库前货位状态:{isUpdateLoc}"); _unitOfWorkManage.CommitTran(); return true; } else { LogFactory.GetLog("任务完成").InfoFormat(true, "任务完成", $"数据处理失败,请检查数据是否正确,数据回滚。添加历史任务:{isTaskHtyAdd},删除任务数据:{isTaskDelete},更新库存:{isUpdateStock},修改入库前货位状态:{isUpdateLoc}"); _unitOfWorkManage.RollbackTran(); return false; } } catch (Exception err) { LogFactory.GetLog("任务完成").InfoFormat(true, $"任务完成,系统异常,异常信息:{err.Message}", "无参数"); _unitOfWorkManage.RollbackTran(); throw; // 抛出异常以便外部捕获 } } #endregion #region 任务请求方法 private static readonly SemaphoreSlim _semaphoreUpdate = new SemaphoreSlim(1, 1); // 更新任务货位 private async Task UpdateExistingTask(RequestTaskDto input, Dt_Task task) { await _semaphoreUpdate.WaitAsync(); try { if (task == null) { return new WebResponseContent().Error("任务对象为空"); } try { // 创建WebResponseContent对象 var content = new WebResponseContent(); // 获取库位 var location = RequestLocation(input); if (location == null) { return content.Error("无法获取货位信息"); } string toAddress = location.LocationCode; int taskState = (int)TaskInStatusEnum.Line_InFinish; int beforeStatus = location.LocationStatus; // 更新货位信息 location.LocationStatus = (int)LocationEnum.Lock; // 更新任务信息 MapTaskProperties(task, input, toAddress, taskState); _unitOfWorkManage.BeginTran(); // 开始事务 var isResult = await UpdateTaskAsync(task, location, beforeStatus); if (!isResult) { _unitOfWorkManage.RollbackTran(); return content.Error("更新任务失败"); } // 提交事务 _unitOfWorkManage.CommitTran(); return content.OK(data: task); } catch (Exception ex) { // 回滚事务 _unitOfWorkManage.RollbackTran(); // 这里可以添加日志记录 return new WebResponseContent().Error($"更新任务时发生错误: {ex.Message}"); } } catch (Exception) { throw; } finally { _semaphoreUpdate.Release(); } } private void MapTaskProperties(Dt_Task task, RequestTaskDto input, string toAddress, int taskState) { task.CurrentAddress = input.Position; task.TargetAddress = toAddress; task.NextAddress = toAddress; task.TaskState = taskState; } // 修改任务 private async Task UpdateTaskAsync(Dt_Task task, DtLocationInfo location, int beforeStatus) { bool isResult = await BaseDal.UpdateDataAsync(task); bool isTaskDetail = await _taskExecuteDetailRepository.AddDetailAsync(task, false, TaskDescription.GetTaskUpdateDescription(task.PalletCode, task.CurrentAddress, task.TargetAddress, TaskInStatusEnum.Line_InFinish.GetIntegralRuleTypeEnumDesc())); LocationChangeRecordDto changeRecordDto = new LocationChangeRecordDto() { AfterStatus = location.LocationStatus, BeforeStatus = beforeStatus, TaskNum = task.TaskNum.Value, LocationId = location.Id, LocationCode = location.LocationCode, ChangeType = (int)StatusChangeTypeEnum.AutomaticStorage, }; bool isUpdateChange = _locationStatusChangeRecordRepository.AddStatusChangeRecord(changeRecordDto); bool isUpdateLo = await _locationRepository.UpdateDataAsync(location); return isResult && isUpdateLo && isTaskDetail; } #endregion 任务请求方法 #endregion private 内部方法 }