using Autofac.Core; using MailKit.Search; using Mapster; using Masuit.Tools; using System.Diagnostics; using System.Text.RegularExpressions; using System.Threading.Tasks; using WIDESEA_Comm.WCSInterface.Requst; using WIDESEA_Core.Const; using WIDESEA_DTO.WMS; using WIDESEA_IServices; using WIDESEA_IStoragIntegrationServices; using WIDESEA_StoragIntegrationServices; 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; private readonly IDt_PalletStockInfoDetailRepository _palletStockInfoDetailRepository; private readonly IDt_PalletStockInfo_htyRepository _palletStockInfo_HtyRepository; private readonly IBoxingInfoRepository _boxingInfoRepository; public static string AGV_Interface = "http://192.168.1.195:10200/"; public Dt_TaskService(IDt_TaskRepository BaseDal, IUnitOfWorkManage unitOfWorkManage, IDt_Task_HtyRepository task_HtyRepository, IMapper mapper, ILocationInfoRepository locationRepository, ITaskExecuteDetailRepository taskExecuteDetailRepository, ILocationStatusChangeRecordRepository locationStatusChangeRecordRepository, IDt_StationManagerRepository stationManagerRepository, ISys_ConfigService configService, IDt_PalletStockInfoRepository palletStockInfoRepository, IDt_PalletStockInfo_htyRepository palletStockInfo_HtyRepository, IBoxingInfoRepository boxingInfoRepository, IDt_PalletStockInfoDetailRepository palletStockInfoDetailRepository) : base(BaseDal) { _unitOfWorkManage = unitOfWorkManage; _task_HtyRepository = task_HtyRepository; _mapper = mapper; _locationRepository = locationRepository; _taskExecuteDetailRepository = taskExecuteDetailRepository; _locationStatusChangeRecordRepository = locationStatusChangeRecordRepository; _stationManagerRepository = stationManagerRepository; _configService = configService; _palletStockInfoRepository = palletStockInfoRepository; _palletStockInfo_HtyRepository = palletStockInfo_HtyRepository; _boxingInfoRepository = boxingInfoRepository; _palletStockInfoDetailRepository = palletStockInfoDetailRepository; } #region 外部接口方法 #region 入库任务完成 /// /// 完成入库任务 /// /// 任务数据合集 /// 返回结果集 public async Task CompleteInboundTaskAsync(Dt_Task task) { // 初始化响应内容 WebResponseContent content = new WebResponseContent(); try { // 获取库位信息 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); //获取组盘信息 var boxinginfo = await _boxingInfoRepository.QueryFirstNavAsync(x => x.PalletCode == task.PalletCode); // 根据创建库存实例模型 var boxDetail = boxinginfo.BoxingInfoDetails.Adapt>(); Dt_PalletStockInfo palletStockInfo = new Dt_PalletStockInfo { CreateDate = DateTime.Now, Creater = task.Creater, LocationCode = task.TargetAddress, StockStatus = 2, PalletCode = task.PalletCode, AreaCode = task.Roadway, StockInfoDetails = boxDetail }; // 执行数据库事务 bool isResult = await ExecuteTransaction(palletStockInfo, taskHty, locationInf, task.TaskId, boxinginfo); 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) { WebResponseContent content = new WebResponseContent(); try { // 更新库位状态与任务状态 var stock = _palletStockInfoRepository.QueryFirst(x => x.PalletCode == task.PalletCode); (var loc, var tas) = UpdateStockAndTaskStatus(stock, task); var taskHty = task.Adapt(); taskHty.FinishTime = DateTime.Now; taskHty.OperateType = (int)OperateTypeEnum.自动完成; Dt_PalletStockInfo_hty stockInfo_Hty = stock.Adapt(); stockInfo_Hty.FinishTime = DateTime.Now; stockInfo_Hty.OperateType = (int)OperateTypeEnum.自动完成; var boxinfo = _boxingInfoRepository.QueryFirst(x => x.PalletCode == task.PalletCode); // 事务处理 await _unitOfWorkManage.UseTranAsync(async () => { var isLocationUpdate = await _locationRepository.UpdateDataAsync(loc); //更新库位 var isPalletHty = await _palletStockInfo_HtyRepository.AddDataAsync(stockInfo_Hty); //添加历史库存记录 //var isTaskUpdated = await BaseDal.DeleteDataByIdAsync(task.TaskId); //删除任务 await BaseDal.UpdateDataAsync(task); //取消删除任务,改为完成状态;并WMS界面由人工确认完成 var isTaskAdd = await _task_HtyRepository.AddDataAsync(taskHty) > 0; //加入历史任务 var isDelete = await _palletStockInfoRepository.DeleteDataAsync(stock); //删除库存 await DeleteStockInfoDetailsAsync(stock.StockInfoDetails); //删除库存明细 //if (boxinfo != null) //{ // var isDeleteBoxing = await _boxingInfoRepository.Db.DeleteNav(x => x.Id == boxinfo.Id) // .Include(x => x.BoxingInfoDetails) // .ExecuteCommandAsync(); //删除组盘 //} }); 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_PalletStockInfo 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: LogFactory.GetLog("任务完成").InfoFormat(true, "入库任务", ""); return await CompleteInboundTaskAsync(task); case (int)TaskOutboundTypeEnum.Outbound: LogFactory.GetLog("任务完成").InfoFormat(true, "出库任务", ""); return await CompleteStackTaskAsync(task); default: return content.Error("任务类型不存在"); } } #endregion 任务完成 #region 请求任务入库 /// /// 更新任务货位 /// /// /// 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 任务状态更改 /// /// 更新任务状态 /// /// /// /// 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 != 2) return content.Error("指定失败:当前状态不允许指定出库"); stockInfo.StockStatus = 3; //查询库位是否锁定, 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); // 创建并添加任务到数据库 string agvId = Guid.NewGuid().ToString().Replace("-", "").Take(16); task = new Dt_Task { Grade = 1, Roadway = stationInfo.Roadway, TargetAddress = stationInfo.stationLocation, Dispatchertime = DateTime.Now, MaterialNo = "", NextAddress = stationInfo.stationLocation, OrderNo = null, PalletCode = stockInfo.PalletCode, SourceAddress = stockInfo.LocationCode, CurrentAddress = stockInfo.LocationCode, TaskState = (int)TaskOutStatusEnum.OutNew, TaskType = (int)TaskOutboundTypeEnum.Outbound, TaskNum = BaseDal.GetTaskNo().Result, Creater = "System", CreateDate = DateTime.Now, TaskId = 0, AGVtaskId = agvId }; addtask schedulingTask = new addtask { task_id = task.AGVtaskId, task_type = task.TaskType == (int)TaskTypeEnum.Inbound ? "push" : "pop", work_begin = task.SourceAddress, work_end = task.TargetAddress }; string address = AGV_Interface + "add_task"; string result = HttpsClient.PostAsync(address, schedulingTask.ToDictionary()).Result; content = JsonConvert.DeserializeObject(result); if (content.ack != 0) { Console.WriteLine($"请求RCS异常:{content.msg}"); LogFactory.GetLog("下发AGV任务").Info(true, $"\r\r--------------------------------------"); LogFactory.GetLog("下发AGV任务").Info(true, $"请求参数:{schedulingTask.ToJsonString()}"); LogFactory.GetLog("下发AGV任务").Info(true, $"响应参数:{content.ToJsonString()}"); throw new Exception(content.msg); } _unitOfWorkManage.BeginTran(); // 添加任务到数据库 BaseDal.AddData(task); // 更新库位位置状态为不可用 _locationRepository.UpdateData(location); _palletStockInfoRepository.UpdateData(stockInfo); _unitOfWorkManage.CommitTran(); } catch (Exception ex) { _unitOfWorkManage.RollbackTran(); Console.WriteLine($"发生异常: {ex.Message}"); content.Error(ex.Message); } return content; } private string GetAGVIpReceiveTask() { var configs = _configService.GetConfigsByCategory(CateGoryConst.CONFIG_SYS_IPAddress); var wmsBase = configs.FirstOrDefault(x => x.ConfigKey == SysConfigConst.AGVIPAddress)?.ConfigValue; var ipAddress = configs.FirstOrDefault(x => x.ConfigKey == SysConfigConst.addTask)?.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 async Task DeleteStockInfoDetailsAsync(IEnumerable details) { if (details != null) { var ids = details.Select(x => (object)x.Id).ToArray(); var isStockDetailUpdated = await _palletStockInfoDetailRepository.DeleteDataByIdsAsync(ids); if (!isStockDetailUpdated) { throw new Exception("库存详情信息更新失败"); } } } /// /// 创建历史任务记录 /// /// /// 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; } #region 执行数据库事务 /// /// 执行数据库事务 /// /// 库存对象 /// 历史任务对象 /// 任务ID /// private async Task ExecuteTransaction(Dt_PalletStockInfo stock, Dt_Task_Hty taskHty, DtLocationInfo locationInfo, int taskId, DtBoxingInfo boxingInfo) { _unitOfWorkManage.BeginTran(); try { var isUpdateStock = true; var isDeleteBoxing = true; // 添加库存 isUpdateStock = await _palletStockInfoRepository.AddDataNavAsync(stock); //删除组盘数据 if (boxingInfo != null) { boxingInfo.CurrentStatue = 5; isDeleteBoxing = await _boxingInfoRepository.Db.DeleteNav(x => x.Id == boxingInfo.Id) .Include(x => x.BoxingInfoDetails) .ExecuteCommandAsync(); } //var box = _boxingInfoRepository.dele(boxingInfo); // 添加历史任务 var isTaskHtyAdd = await _task_HtyRepository.AddDataAsync(taskHty) > 0; // 修改移库前货位状态 var isUpdateLoc = _locationRepository.UpdateData(locationInfo); // 删除任务数据 var isTaskDelete = await Delete(taskId); // 提交或回滚事务 if (isUpdateStock && isTaskHtyAdd && isTaskDelete && isUpdateLoc && isDeleteBoxing) { 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 = false; //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 内部方法 }