From 8f6a1e8a01a518a384d22f0f773459be744a2a4d Mon Sep 17 00:00:00 2001 From: 刘磊 <1161824510@qq.com> Date: 星期一, 09 六月 2025 19:31:20 +0800 Subject: [PATCH] 合并 --- Code Management/WMS/WIDESEA_WMSServer/WIDESEA_StorageTaskServices/Task/Dt_TaskService.cs | 1707 +++++++++++++++++++++++++++++++++++++++++++++------------- 1 files changed, 1,318 insertions(+), 389 deletions(-) diff --git a/Code Management/WMS/WIDESEA_WMSServer/WIDESEA_StorageTaskServices/Task/Dt_TaskService.cs b/Code Management/WMS/WIDESEA_WMSServer/WIDESEA_StorageTaskServices/Task/Dt_TaskService.cs index fa3ef06..8cfd6d0 100644 --- a/Code Management/WMS/WIDESEA_WMSServer/WIDESEA_StorageTaskServices/Task/Dt_TaskService.cs +++ b/Code Management/WMS/WIDESEA_WMSServer/WIDESEA_StorageTaskServices/Task/Dt_TaskService.cs @@ -1,35 +1,28 @@ -锘縰sing log4net.Core; -using Mapster; +锘縰sing Mapster; using Masuit.Tools; -using Masuit.Tools.Models; -using System.Linq; +using SqlSugar; +using System.Text.RegularExpressions; using System.Threading.Tasks; +using WIDESEA_Cache; +using WIDESEA_Core.Const; using WIDESEA_DTO.MOM; using WIDESEA_DTO.WMS; -using WIDESEA_IStorageBasicRepository; +using WIDESEA_IServices; using WIDESEA_IStoragIntegrationServices; -using WIDESEA_Model.Models; -using WIDESEA_StorageBasicRepository; -using WIDESEA_StorageTaskRepository; -using WIDESEA_StoragIntegrationServices; +using WIDESEAWCS_BasicInfoRepository; +using WIDESEAWCS_QuartzJob.Models; -namespace WIDESEA_StorageOutTaskServices; +namespace WIDESEA_StorageTaskServices; public partial class Dt_TaskService : ServiceBase<Dt_Task, IDt_TaskRepository>, IDt_TaskService { private readonly LogFactory LogFactory = new LogFactory(); private readonly IUnitOfWorkManage _unitOfWorkManage; - private readonly IDt_OutOrderRepository _outOrderRepository; private readonly IStockInfoRepository _stockInfoRepository; private readonly IStockInfoDetailRepository _stockInfoDetailRepository; private readonly IDt_Task_HtyRepository _task_HtyRepository; - private readonly IDt_OutOrderAndStockRepository _outOrderAndStockRepository; - private readonly IDt_OutOrderAndStock_HtyRepository _outOrderAndStock_HtyRepository; private readonly IMapper _mapper; - private readonly IDt_MaterielInfoRepository _materielInfoRepository; private readonly ILocationInfoRepository _locationRepository; - private readonly IDt_WareAreaInfoRepository _wareAreaInfoRepository; - private readonly IPointStackerRelationRepository _pointStackerRelationRepository; private readonly ITaskExecuteDetailRepository _taskExecuteDetailRepository; private readonly ILocationStatusChangeRecordRepository _locationStatusChangeRecordRepository; private readonly IBoxingInfoRepository _boxingInfoRepository; //缁勭洏 @@ -37,20 +30,18 @@ private readonly IProcessApplyService _processApplyService; //宸ヨ壓璺嚎 private readonly IDt_AreaInfoRepository _areaInfoRepository; //鍖哄煙 private readonly IAgingInOrOutInputService _agingInOrOutInputService; //闈欑疆\闄堝寲 - private readonly IProductionRepository _productionRepository; //鐢熶骇 + private readonly IDt_StationManagerRepository _stationManagerRepository; + private readonly ISys_ConfigService _configService; + private readonly IDt_ChangeoversRepository _dt_ChangeoversRepository; + private readonly ISimpleCacheService _simpleCacheService; public Dt_TaskService(IDt_TaskRepository BaseDal, IUnitOfWorkManage unitOfWorkManage, IDt_OutOrderRepository outOrderRepository, IStockInfoRepository stockInfoRepository, - IDt_OutOrderAndStockRepository dt_OutOrderAndStockRepository, - IDt_OutOrderAndStock_HtyRepository dt_OutOrderAndStock_HtyRepository, IDt_Task_HtyRepository task_HtyRepository, IMapper mapper, - IDt_MaterielInfoRepository materielInfoRepository, ILocationInfoRepository locationRepository, - IDt_WareAreaInfoRepository wareAreaInfoRepository, - IPointStackerRelationRepository pointStackerRelationRepository, ITaskExecuteDetailRepository taskExecuteDetailRepository, ILocationStatusChangeRecordRepository locationStatusChangeRecordRepository, IBoxingInfoRepository boxingInfoRepository, @@ -59,19 +50,16 @@ IDt_AreaInfoRepository areaInfoRepository, IAgingInOrOutInputService agingInOrOutInputService, IStockInfoDetailRepository stockInfoDetailRepository, - IProductionRepository productionRepository) : base(BaseDal) + IDt_StationManagerRepository stationManagerRepository, + ISys_ConfigService configService, + ISimpleCacheService simpleCacheService, + IDt_ChangeoversRepository dt_ChangeoversRepository) : base(BaseDal) { _unitOfWorkManage = unitOfWorkManage; - _outOrderRepository = outOrderRepository; _stockInfoRepository = stockInfoRepository; - _outOrderAndStockRepository = dt_OutOrderAndStockRepository; - _outOrderAndStock_HtyRepository = dt_OutOrderAndStock_HtyRepository; _task_HtyRepository = task_HtyRepository; _mapper = mapper; - _materielInfoRepository = materielInfoRepository; _locationRepository = locationRepository; - _wareAreaInfoRepository = wareAreaInfoRepository; - _pointStackerRelationRepository = pointStackerRelationRepository; _taskExecuteDetailRepository = taskExecuteDetailRepository; _locationStatusChangeRecordRepository = locationStatusChangeRecordRepository; _boxingInfoRepository = boxingInfoRepository; @@ -80,13 +68,15 @@ _areaInfoRepository = areaInfoRepository; _agingInOrOutInputService = agingInOrOutInputService; _stockInfoDetailRepository = stockInfoDetailRepository; - _productionRepository = productionRepository; + _stationManagerRepository = stationManagerRepository; + _configService = configService; + _simpleCacheService = simpleCacheService; + _dt_ChangeoversRepository = dt_ChangeoversRepository; } #region 澶栭儴鎺ュ彛鏂规硶 #region 鍑哄簱浠诲姟瀹屾垚 - public async Task<WebResponseContent> CompleteStackTaskAsync(Dt_Task task, DtStockInfo stock) { @@ -95,28 +85,70 @@ { if (task.TaskType == (int)TaskOutboundTypeEnum.Outbound) { - //var process = await SqlSugarHelper.Db.Queryable<Dt_EquipmentProcess>() - // .FirstAsync(x => x.EquipmentName == task.Roadway); - //var info = JsonConvert.DeserializeObject<ResponseEqptRunDto>(process.ProcessValue); + if (task.TaskType == (int)TaskOutboundTypeEnum.Outbound) + { + if (!task.Roadway.Contains("FR") && stock.ProcessCode != "OCVB") + { + var agingOutputDto = MapToAgingOutputDto(stock); + content = await _agingInOrOutInputService.GetOCVOutputAsync(agingOutputDto); - var agingOutputDto = MapToAgingOutputDto(stock); - content = await _agingInOrOutInputService.GetOCVOutputAsync(agingOutputDto); - ValidateResponse(content); + if (content.Status) + { + var result = JsonConvert.DeserializeObject<BasicResult>(content.Data.ToString()); + + if (!result.Success && result.MessageCode == "E10001") + { + await HandleOutBoundError(stock, task); + } + } + else + { + task.Remark = "NG"; + ConsoleHelper.WriteErrorLine("MOM閫氭姤鐐硅姱NG"); + return content.Error("MOM閫氭姤鐐硅姱NG"); + } + } + } } + if (task.Remark == "NG") + { + ConsoleHelper.WriteErrorLine("MOM閫氭姤鐐硅姱NG"); + return content.Error("MOM閫氭姤鐐硅姱NG"); + } // 鏇存柊搴撳瓨鐘舵�佸拰浠诲姟鐘舵�� (var loc, var tas) = UpdateStockAndTaskStatus(stock, task); + var taskHty = task.Adapt<Dt_Task_Hty>(); + taskHty.FinishTime = DateTime.Now; + taskHty.OperateType = App.User.UserName != null ? (int)OperateTypeEnum.浜哄伐瀹屾垚 : (int)OperateTypeEnum.鑷姩瀹屾垚; + taskHty.Creater = App.User.UserName != null ? App.User.UserName : "System"; + + DtStockInfo_Hty stockInfo_Hty = stock.Adapt<DtStockInfo_Hty>(); + stockInfo_Hty.ModifyDate = DateTime.Now; // 浜嬪姟澶勭悊 await _unitOfWorkManage.UseTranAsync(async () => { - await UpdateLocationAsync(loc); - await DeleteStockInfoAsync(stock.Id); - await DeleteStockInfoDetailsAsync(stock.StockInfoDetails); - //await DeleteTaskAsync(task.TaskId); + if (task.TaskType != (int)TaskOutboundTypeEnum.OutQuality) + { + await DeleteStockInfoAsync(stock.Id); + await DeleteStockInfoDetailsAsync(stock.StockInfoDetails); + await AddStockInfoHtyAsync(stockInfo_Hty); + await UpdateLocationAsync(loc); //璐ㄦ浠诲姟闇�瑕佹寔缁攣瀹氬簱浣� + } + await DeleteTaskAsync(task.TaskId); + await AddTaskHtyAsync(taskHty); }); + //try + //{ + // _simpleCacheService.HashDel<DtStockInfo>(WIDESEA_Cache.CacheConst.Cache_DtStockInfo, new string[] { stock.PalletCode }); + //} + //catch (Exception ex) + //{ + // LogFactory.GetLog("鍒犻櫎缂撳瓨澶辫触").Error(true, $"{stock.PalletCode}_鍒犻櫎缂撳瓨澶辫触锛屽紓甯镐俊鎭細{ex.Message}"); + //} - return content.OK("浠诲姟瀹屾垚鎴愬姛"); + return content.OK("浠诲姟瀹屾垚鎴愬姛", task.Remark); } catch (Exception err) { @@ -125,7 +157,7 @@ } } - private AgingOutputDto MapToAgingOutputDto(DtStockInfo stock, ResponseEqptRunDto info = null) + private AgingOutputDto MapToAgingOutputDto(DtStockInfo stock, ResponseEqptRunDto? info = null) { // TODO Value鍊兼牴鎹甅OM涓嬪彂鐨勯潤缃椂闂村埌褰撳墠鏃堕棿鐨勫垎閽熸暟 var area = _areaInfoRepository.QueryFirst(x => x.AreaCode == stock.AreaCode); @@ -137,9 +169,21 @@ var parameterInfo = JsonConvert.DeserializeObject<List<ParameterInfo>>(stock.ParameterInfos).FirstOrDefault(y => y.Description.Contains("鏃堕棿")); if (parameterInfo == null) throw new Exception(""); - var outHours = (DateTime.Now - stock.OutboundTime.Value).TotalHours; + var outHours = (DateTime.Now - (stock.LinedProcessFeedbackTime == null ? stock.CreateDate : stock.LinedProcessFeedbackTime.ToDateTime())).TotalHours; + + //if (stock.LinedProcessFeedbackTime == null) + //{ + // outHours = (DateTime.Now - stock.CreateDate).TotalHours; + //} + //else + //{ + // outHours = (DateTime.Now - stock.LinedProcessFeedbackTime.ToDateTime()).TotalHours; + //} + var isNG = outHours > parameterInfo.LowerSpecificationsLimit.ToDouble() && outHours < parameterInfo.UpperSpecificationsLimit.ToDouble(); + var defectCode = string.Empty; + if (!isNG) defectCode = "TQCK"; return new AgingOutputDto { OpFlag = 1, @@ -150,40 +194,35 @@ { SlotNo = x.OrderNo.ToInt32(), SerialNo = x.SerialNumber, - SerialNoResult = true, + SerialNoResult = true, //isNG, ParameterInfo = new List<ParameterInfoOutput> { new ParameterInfoOutput() { Value = outHours.ToString(), ParameterCode =parameterInfo.ParameterCode, ParameterDesc = parameterInfo.Description, - ParameterResult = isNG.ToString(), + ParameterResult = "OK", //isNG.ToString(), TargetValue = parameterInfo.TargetValue, - LowerLomit = parameterInfo.LowerSpecificationsLimit, + LowerLimit = parameterInfo.LowerSpecificationsLimit, UpperLimit = parameterInfo.UpperSpecificationsLimit, + DefectCode = defectCode, + UOMCode = parameterInfo.UOMCode, } } }).ToList() }; } - private void ValidateResponse(WebResponseContent content) - { - var result = JsonConvert.DeserializeObject<BasicResult>(content.Data.ToString()); - if (!result.Success) - { - throw new Exception(result.MOMMessage); - } - } - private (DtLocationInfo, Dt_Task) UpdateStockAndTaskStatus(DtStockInfo stock, Dt_Task task) { - var location = _locationRepository.QueryFirst(x => x.LocationCode == task.SourceAddress); + var location = _locationRepository.QueryFirst(x => x.LocationCode == task.SourceAddress && x.RoadwayNo == task.Roadway); //var details = _stockInfoDetailRepository.QueryData(x => x.StockId == stock.Id); - + 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); @@ -198,12 +237,21 @@ } } + private async Task AddStockInfoHtyAsync(DtStockInfo_Hty dtStock) + { + var isStockAdd = await SqlSugarHelper.DbWMS.InsertNav(dtStock).IncludesAllFirstLayer().ExecuteCommandAsync(); + if (!isStockAdd) + { + throw new Exception("搴撳瓨鍘嗗彶淇℃伅娣诲姞澶辫触"); + } + } + private async Task UpdateLocationAsync(DtLocationInfo info) { var isStockUpdated = await _locationRepository.UpdateDataAsync(info); if (!isStockUpdated) { - throw new Exception("搴撳瓨淇℃伅鏇存柊澶辫触"); + throw new Exception("搴撲綅淇℃伅鏇存柊澶辫触"); } } @@ -226,7 +274,46 @@ } } + private async Task AddTaskHtyAsync(Dt_Task_Hty taskHty) + { + var isTaskAdd = await _task_HtyRepository.AddDataAsync(taskHty) > 0; + if (!isTaskAdd) + { + throw new Exception("鍘嗗彶浠诲姟淇℃伅娣诲姞澶辫触"); + } + } + #endregion 鍑哄簱浠诲姟瀹屾垚 + + #region 鐏浠诲姟瀹屾垚 + public async Task<WebResponseContent> CompleteOutFireAlarmTaskAsync(Dt_Task task, DtStockInfo stock) + { + WebResponseContent content = new WebResponseContent(); + (var loc, var tas) = UpdateStockAndTaskStatus(stock, task); + var taskHty = task.Adapt<Dt_Task_Hty>(); + taskHty.FinishTime = DateTime.Now; + taskHty.OperateType = App.User.UserName != null ? (int)OperateTypeEnum.浜哄伐瀹屾垚 : (int)OperateTypeEnum.鑷姩瀹屾垚; + taskHty.Creater = App.User.UserName != null ? App.User.UserName : "System"; + + DtStockInfo_Hty stockInfo_Hty = stock.Adapt<DtStockInfo_Hty>(); + stockInfo_Hty.ModifyDate = DateTime.Now; + + // 浜嬪姟澶勭悊 + await _unitOfWorkManage.UseTranAsync(async () => + { + if (task.TaskType != (int)TaskOutboundTypeEnum.OutQuality) + { + await DeleteStockInfoAsync(stock.Id); + await DeleteStockInfoDetailsAsync(stock.StockInfoDetails); + await AddStockInfoHtyAsync(stockInfo_Hty); + await UpdateLocationAsync(loc); //璐ㄦ浠诲姟闇�瑕佹寔缁攣瀹氬簱浣� + } + await DeleteTaskAsync(task.TaskId); + await AddTaskHtyAsync(taskHty); + }); + return content.OK("浠诲姟瀹屾垚鎴愬姛", task.Remark); + } + #endregion #region 绉诲簱浠诲姟瀹屾垚 @@ -241,12 +328,12 @@ try { // 鏇存柊璐т綅鍜屽簱瀛樹俊鎭� - (DtStockInfo updateStock, DtLocationInfo locationInf) = UpdateStockLocation(stock, task.NextAddress); + (DtStockInfo updateStock, DtLocationInfo locationInForm, DtLocationInfo locationInfoTo) = UpdateStockLocation(stock, task); var taskHty = CreateHistoricalTask(task); - LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, "绉诲簱浠诲姟瀹屾垚", $"璐т綅鍦板潃锛歿task.TargetAddress},淇敼鍚庡簱瀛樻暟鎹細{JsonConvert.SerializeObject(updateStock)}锛屽師鍏堣揣浣嶆暟鎹細{locationInf}"); + LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, "绉诲簱浠诲姟瀹屾垚", $"璐т綅鍦板潃锛歿task.TargetAddress},淇敼鍚庡簱瀛樻暟鎹細{JsonConvert.SerializeObject(updateStock)}锛屽師鍏堣揣浣嶆暟鎹細{locationInForm}"); // 鎵ц鏁版嵁搴撲簨鍔� - bool isResult = await ExecuteTransaction(updateStock, taskHty, locationInf, task.TaskId); + bool isResult = await ExecuteTransaction(updateStock, taskHty, locationInForm, locationInfoTo, task.TaskId); if (isResult) content.OK("绉诲簱浠诲姟瀹屾垚鎴愬姛"); else @@ -283,7 +370,6 @@ // 鎵ц鏁版嵁搴撲簨鍔� await _unitOfWorkManage.UseTranAsync(async () => { - // 娣诲姞鍘嗗彶浠诲姟 var isTaskHtyAdd = await _task_HtyRepository.AddDataAsync(taskHtyNG) > 0; @@ -297,21 +383,38 @@ // 鑾峰彇瑁呯淇℃伅鍜岀洰鏍囦綅缃俊鎭� var boxing = await _boxingInfoRepository.QueryFirstNavAsync(x => x.PalletCode == task.PalletCode); - var locationInf = await _locationRepository.QueryFirstAsync(x => x.LocationCode == task.TargetAddress); + 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); + if (task.TaskType == (int)TaskInboundTypeEnum.InQuality) + { + await _locationRepository.UpdateDataAsync(locationInf); + await _task_HtyRepository.AddDataAsync(taskHty); + await BaseDal.DeleteDataAsync(task); + + //璁板綍璐т綅鍙樺姩淇℃伅 + _locationStatusChangeRecordRepository.AddLocationStatusChangeRecord(locationInf, lastStatus, (int)StatusChangeTypeEnum.AutomaticStorage, task.TaskNum); + + return content.OK("鍏ュ簱浠诲姟瀹屾垚鎴愬姛"); + } // 鏍规嵁鏄惁鏈夌粍鐩樹俊鎭垱寤哄簱瀛樺疄渚嬫ā鍨� DtStockInfo stock = boxing == null ? CreateEmptyPalletStock(task, locationInf) : CreateFullPalletStock(task, locationInf, boxing); // 鎵ц鏁版嵁搴撲簨鍔� - bool isResult = await ExecuteTransaction(stock, taskHty, locationInf, task.TaskId); + bool isResult = await ExecuteTransaction(stock, taskHty, locationInf, task.TaskId, boxing); if (isResult) { + _locationStatusChangeRecordRepository.AddLocationStatusChangeRecord(locationInf, lastStatus, (int)StatusChangeTypeEnum.AutomaticStorage, task.TaskNum); + + stock.StockInfoDetails = new List<DtStockInfoDetail>() { { stock.StockInfoDetails[0] } }; + stock.LocationInfo = locationInf; + content.OK("鍏ュ簱浠诲姟瀹屾垚鎴愬姛"); } else @@ -325,6 +428,9 @@ Console.WriteLine(err.Message.ToString()); LogFactory.GetLog("浠诲姟瀹屾垚").Error(true, err); content.Error(err.Message); + task.ErrorMessage= err.Message; + task.TaskState=(int)TaskInStatusEnum.SC_InExecuting; + await BaseDal.Update(task); } return content; } @@ -343,13 +449,42 @@ CreateDate = DateTime.Now, Creater = "system", IsFull = false, - AreaCode = area.AreaCode, + AreaCode = area.AreaCode ?? "", LocationId = loation.Id, + ProductionLine = task.ProductionLine, StockInfoDetails = new List<DtStockInfoDetail>() { new DtStockInfoDetail() { MaterielCode = "绌烘墭鐩�", + Id = 0, + Status = (int)StockStateEmun.宸插叆搴� + } + } + }; + } + + /// <summary> + /// 鍒涘缓鍒嗗鐨勫疄鎵樼洏鐨勫簱瀛樺疄渚嬫ā鍨� + /// </summary> + private DtStockInfo CreateFullPalletStockByFR(Dt_Task task, DtLocationInfo locationInf) + { + var loation = _locationRepository.QueryFirst(x => x.RoadwayNo == task.Roadway && x.LocationCode == task.TargetAddress); + var area = _areaInfoRepository.QueryFirst(x => x.AreaID == loation.AreaId); + return new DtStockInfo() + { + PalletCode = task.PalletCode, + LocationCode = task.TargetAddress, + CreateDate = DateTime.Now, + Creater = "system", + IsFull = false, + AreaCode = area.AreaCode ?? "", + LocationId = loation.Id, + StockInfoDetails = new List<DtStockInfoDetail>() + { + new DtStockInfoDetail() + { + MaterielCode = "瀹炴墭鐩�", Id = 0, Status = (int)StockStateEmun.宸插叆搴� } @@ -365,9 +500,33 @@ var loation = _locationRepository.QueryFirst(x => x.RoadwayNo == task.Roadway && x.LocationCode == task.TargetAddress); if (loation == null) throw new Exception("鏈壘鍒板搴斾綅缃俊鎭�"); - var area = _areaInfoRepository.QueryFirst(x => x.AreaID == loation.AreaId); - if (area == null) - throw new Exception("鏈壘鍒板搴斿尯鍩熶俊鎭�"); + + var area = new Dt_AreaInfo(); + if (task.Roadway.Contains("FR")) + { + area = _areaInfoRepository.QueryFirst(x => x.AreaID == loation.AreaId); + } + else + { + //var station = _stationManagerRepository.QueryFirst(x => x.stationChildCode == task.SourceAddress); + //if (station.stationPLC == "1017") + // area = _areaInfoRepository.QueryFirst(x => x.AreaID == Convert.ToInt32(station.stationNGLocation)); + //else + // area = _areaInfoRepository.QueryFirst(x => x.AreaID == loation.AreaId); + //if (area == null) + // throw new Exception("鏈壘鍒板搴斿尯鍩熶俊鎭�"); + + if (boxing.ProcessCode == "OCV1") + area = _areaInfoRepository.QueryFirst(x => x.AreaID == 6); + else if (boxing.ProcessCode == "OCVB") + area = _areaInfoRepository.QueryFirst(x => x.AreaID == 7); + else + area = _areaInfoRepository.QueryFirst(x => x.AreaID == loation.AreaId); + + if (area == null) + throw new Exception("鏈壘鍒板搴斿尯鍩熶俊鎭�"); + } + var boxDetail = boxing.BoxingInfoDetails.Adapt<List<DtStockInfoDetail>>(); boxDetail.ForEach(x => { x.Status = (int)StockStateEmun.宸插叆搴�; }); var stock = new DtStockInfo() @@ -380,28 +539,51 @@ AreaCode = area.AreaCode, LocationId = loation.Id, StockInfoDetails = boxDetail, + ProcessCode = boxing.ProcessCode, + NextProcessCode = boxing.NextProcessCode, + Remark = boxing.BoxingInfoDetails.Count().ToString(), }; - // 澶勭悊璇锋眰鍙傛暟 - AgingInputDto agingInputDto = new AgingInputDto() + if (boxing.ProcessCode != "OCVB" && !task.Roadway.Contains("FR")) { - SerialNos = boxing.BoxingInfoDetails - .Select(item => new SerialNoInDto { SerialNo = item.SerialNumber, PositionNo = item.OrderNo }) - .ToList(), - TrayBarcode = task.PalletCode, - OpFlag = 1, - EquipmentCode = area.Spare2, - Software = area.Spare3 - }; - var result = _agingInOrOutInputService.GetOCVInputAsync(agingInputDto).Result; - var respone = JsonConvert.DeserializeObject<ResponeAgingInputDto>(result.Data.ToString()); - stock.LinedProcessFeedbackTime = respone.LinedProcessFeedbackTime; - stock.SpecialParameterDuration = respone.SpecialParameterDuration; - //2024骞�11鏈�16鏃ワ細鏂板瀛楁璁$畻搴斿嚭搴撴椂闂� - stock.OutboundTime = Convert.ToDateTime(respone.LinedProcessFeedbackTime).AddHours(Convert.ToDouble(respone.SpecialParameterDuration)); - stock.ProductionLine = respone.ProductionLine; - stock.ParameterInfos = respone.ParameterInfos.ToJsonString(); - stock.StockStatus = 1; + // 澶勭悊璇锋眰鍙傛暟 + AgingInputDto agingInputDto = new AgingInputDto() + { + SerialNos = boxing.BoxingInfoDetails + .Select(item => new SerialNoInDto { SerialNo = item.SerialNumber, PositionNo = item.OrderNo }) + .ToList(), + TrayBarcode = task.PalletCode, + OpFlag = 1, + EquipmentCode = area.Spare2, + Software = area.Spare3 + }; + + var result = _agingInOrOutInputService.GetOCVInputAsync(agingInputDto).Result; + var respone = JsonConvert.DeserializeObject<ResponeAgingInputDto>(result.Data.ToString()); + + bool isFull = false; + if (!task.Roadway.Contains("FR")) + { + isFull = respone.SpecialParameterDuration.IsNullOrEmpty(); + } + if (respone.ProductionLine == null || respone.ParameterInfos == null || respone.ParameterInfos.IsNullOrEmpty()) + { + throw new Exception($"MOM鏁版嵁杩斿洖閿欒,浜х嚎{respone.ProductionLine},ParameterInfos{respone.ParameterInfos}"); + } + stock.LinedProcessFeedbackTime = respone.LinedProcessFeedbackTime; + stock.SpecialParameterDuration = respone.SpecialParameterDuration; + //2024骞�11鏈�16鏃ワ細鏂板瀛楁璁$畻搴斿嚭搴撴椂闂� + stock.OutboundTime = Convert.ToDateTime(respone.LinedProcessFeedbackTime == null ? DateTime.Now : respone.LinedProcessFeedbackTime).AddHours(Convert.ToDouble(respone.SpecialParameterDuration)); + stock.ProductionLine = respone.ProductionLine; + stock.ParameterInfos = respone.ParameterInfos.ToJsonString(); + stock.StockStatus = 1; + } + else + { + stock.OutboundTime = DateTime.Now; + stock.StockStatus = 1; + stock.ProductionLine = boxing.ProductionLine; + } // 璁板綍鏃ュ織 LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, "鍏ュ簱浠诲姟瀹屾垚", $"璐т綅鍦板潃锛歿task.TargetAddress},淇敼鍚庤揣浣嶆暟鎹細{locationInf}"); @@ -434,6 +616,10 @@ } LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, "楠岃瘉浠诲姟鏄惁瀛樺湪", JsonConvert.SerializeObject(task)); + if (task.TaskType == (int)TaskOutboundTypeEnum.InToOut) + { + return await CompleteInToOutTaskAsync(task); + } // 楠岃瘉搴撳瓨鏄惁瀛樺湪 var stock = await _stockInfoRepository.QueryFirstNavAsync(x => x.PalletCode == task.PalletCode); @@ -442,13 +628,25 @@ { case (int)TaskInboundTypeEnum.Inbound: case (int)TaskInboundTypeEnum.InTray: + case (int)TaskInboundTypeEnum.InNG: + case (int)TaskInboundTypeEnum.InQuality: LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, "鍏ュ簱浠诲姟", ""); return await CompleteInboundTaskAsync(task); case (int)TaskOutboundTypeEnum.OutTray: case (int)TaskOutboundTypeEnum.Outbound: + case (int)TaskOutboundTypeEnum.OutNG: + LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, "鍑哄簱浠诲姟", ""); return await CompleteStackTaskAsync(task, stock); + + case (int)TaskOutboundTypeEnum.OutFireAlarm: + + LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, "鐏浠诲姟", ""); + return await CompleteOutFireAlarmTaskAsync(task, stock); + + case (int)TaskRelocationTypeEnum.Relocation: + return await CompleteTransferTaskAsync(task, stock); default: return content.Error("浠诲姟绫诲瀷涓嶅瓨鍦�"); @@ -459,136 +657,127 @@ #region 璇锋眰浠诲姟鍏ュ簱 - /// <summary> - /// 璇锋眰浠诲姟宸烽亾 - /// </summary> - /// <param name="input">璇锋眰妯″瀷</param> - /// <returns>鍖呭惈浠诲姟淇℃伅鐨勫搷搴斿唴瀹�</returns> public async Task<WebResponseContent> RequestTaskAsync(RequestTaskDto input) { - // 鍒涘缓涓�涓猈ebResponseContent瀵硅薄 WebResponseContent content = new WebResponseContent(); try { - // 璋冪敤BaseDal.QueryFirstAsync鏂规硶锛屾煡璇换鍔� - var task = await BaseDal.QueryFirstAsync(x => x.PalletCode == input.PalletCode); + // 鏌ヨ浠诲姟 + var task = await QueryTaskByPalletCode(input.PalletCode); if (task != null) { - //if (task.TaskState == (int)TaskInStatusEnum.InNew) - { - // 鍒涘缓WMS浠诲姟 - WMSTaskDTO taskDTO = new WMSTaskDTO() - { - TaskNum = task.TaskNum.Value, - Grade = 1, - PalletCode = task.PalletCode, - RoadWay = task.Roadway, - SourceAddress = task.SourceAddress, - TargetAddress = task.Roadway, - TaskState = task.TaskState.Value, - Id = 0, - TaskType = task.TaskType, - }; - return content.OK(data: taskDTO); - } + return CreateAndReturnWMSTaskDTO(task); } - - var stock = await _stockInfoRepository.QueryFirstNavAsync(x => x.PalletCode == input.PalletCode && x.IsFull); + // 鏌ヨ搴撳瓨淇℃伅锛堣繖閲屽悗缁瀹屽杽璐ㄦ鍥炲簱閫昏緫锛� + var stock = await QueryStockInfo(input.PalletCode); if (stock != null) { + Dt_Task taskNew = new Dt_Task + { + Grade = 1, + Roadway = stock.LocationInfo.RoadwayNo, + TargetAddress = stock.LocationInfo.RoadwayNo, + Dispatchertime = DateTime.Now, + MaterialNo = "", + NextAddress = stock.LocationInfo.RoadwayNo, + OrderNo = null, + PalletCode = stock.PalletCode, + SourceAddress = input.Position, + CurrentAddress = input.Position, + TaskState = stock.LocationInfo.RoadwayNo.Contains("CH") ? (int)TaskInStatusEnum.InNew : (int)TaskInStatusEnum.Line_InFinish, + TaskType = (int)TaskInboundTypeEnum.InQuality, + TaskNum = BaseDal.GetTaskNo().Result, + Creater = "System", // 淇鎷煎啓閿欒 + CreateDate = DateTime.Now, + TaskId = 0, + ProductionLine = stock.ProductionLine, + ProcessCode = stock.ProcessCode, + }; + + var taskDTO = CreateTaskDTO(taskNew); + BaseDal.AddData(taskNew); + return content.OK(data: taskDTO); // TODO璐ㄦ鍥炲簱 } - var area = await _areaInfoRepository.QueryFirstAsync(x => x.Spare1.Contains(input.Position)); + // 鏍规嵁浣嶇疆鏌ヨ鍖哄煙淇℃伅 + var areaCode = Regex.Replace(input.Position, @"-(\d+)", ""); + var area = await QueryAreaInfoByPosition(areaCode); if (area == null) - return content.Error("鏀圭偣浣嶄笉鍦ㄥ尯鍩熷垪琛ㄤ腑瀛樺湪"); - - // 鍒涘缓涓�涓猅rayCellsStatusDto瀵硅薄锛屽苟璧嬪�� - TrayCellsStatusDto trayCells = new TrayCellsStatusDto() { - Software = area.Spare3, - TrayBarcode = input.PalletCode, - //EquipmentCode = "EQ_CWJZ01" - EquipmentCode = area.Spare2 - }; + return content.Error("璇ョ偣浣嶄笉鍦ㄥ尯鍩熷垪琛ㄤ腑瀛樺湪"); + } - // 璋冪敤GetTrayCellStatusAsync鏂规硶锛岃幏鍙栨暣鐩樼數鑺� + // 鍒涘缓骞惰幏鍙栨暣鐩樼數鑺姸鎬� + TrayCellsStatusDto trayCells = CreateTrayCellsStatusDto(area, input.PalletCode); content = await GetTrayCellStatusAsync(trayCells); - // 濡傛灉鐘舵�佷负false锛屽垯杩斿洖content - if (!content.Status) return content; - - // 娣诲姞缁勭洏淇℃伅 - // 灏哻ontent.Data杞崲涓篟esultTrayCellsStatus瀵硅薄 - var result = JsonConvert.DeserializeObject<ResultTrayCellsStatus>(content.Data.ToString()); - if (!result.Success) - return content.Error(result.MOMMessage); - - // 鑾峰彇寮傚父鐢佃姱 - var serialNosError = result.SerialNos.Where(x => x.SerialNoStatus != 1).ToList(); - if (serialNosError.Count > 0) + if (!content.Status) { - // TODO 鍒涘缓浠诲姟閫佽嚦NG鎺掑嚭鍙� - List<string> NGStation = input.Position == "1088" ? new List<string>() { "1020" } : new List<string>() { "JZSC01" }; - content = await CreateNewTask(input, NGStation, 2); - return content.Error("瀛樺湪寮傚父鐢佃姱"); + ConsoleHelper.WriteErrorLine($"鑾峰彇鐢佃姱鐘舵�佸け璐�:{content.Message}"); + return content; + } + + var result = JsonConvert.DeserializeObject<ResultTrayCellsStatus>(content.Data.ToString()); + + if (!result.Success) + { + ConsoleHelper.WriteErrorLine($"鑾峰彇鐢佃姱鐘舵�佸け璐�:{result.MOMMessage}"); + if (result.SerialNos.Count <= 0) + { + // 绌烘墭鐩樺叆搴撻�昏緫 + var staion = _stationManagerRepository.QueryFirst(x => x.stationChildCode == input.Position && x.stationType == 1 && x.remark == "IN"); + if (staion != null) + { + return await HandleErrorCells(input, area); + } + else + { + return await RequestTrayInTaskAsync(input); + } + } + else + return content.Error(result.MOMMessage); } if (result.SerialNos.Count <= 0) { - // Todo 绌烘墭鐩樺叆搴撻�昏緫 - content = await RequestTrayInTaskAsync(input); - return content; + var config = _configService.GetByConfigKey(CateGoryConst.CONFIG_SYS_InStacker, SysConfigConst.InboundIsEmpty); + var strings = config.ConfigValue.Split(',').ToList(); + if (strings.Contains(input.Position)) + { + // todo閫佽嚦NG鍙� + ConsoleHelper.WriteErrorLine($"褰撳墠浣嶇疆涓嶈兘鍏ョ┖鎵樼洏"); + return content.Error("褰撳墠浣嶇疆涓嶈兘鍏ョ┖鎵樼洏"); + } + else + return await RequestTrayInTaskAsync(input); } - - // TODO 鑾峰彇鏈湴鏂欐灞炴�т笌鏁寸洏鐢佃姱灞炴�ц幏鍙栫殑鍊艰繘琛屽姣旓紝濡傛灉涓�鑷村垯缁х画锛屽惁鍒欒繑鍥為敊璇俊鎭� - //var productions = await _productionRepository.QueryDataAsync(x => result.TrayBarcodePropertys.Select(x => x.TrayBarcodeProperty).ToList().Contains(x.TrayBarcodeProperty)); - //if (productions.Count <= 0) - // return content.Error("鏂欐灞炴�т笉瀛樺湪"); - - // 璋冪敤CreateBoxingInfo鏂规硶锛屽垱寤虹粍鐩樹俊鎭� - - var boxing = await CreateBoxingInfo(result, input.PalletCode); - if (boxing == null) return content.Error("缁勭洏澶辫触"); - - // 璋冪敤GetProcessApplyAsync鏂规硶锛岃幏鍙栧伐鑹鸿矾绾� - ProcessApplyDto process = await GetProcessApplyAsync(result); - - // 濡傛灉process涓簄ull锛屽垯杩斿洖content - if (process == null) return content; - - // 骞惰祴鍊间笂浣嶈蒋浠跺悕绉板拰璁惧缂栫爜 - process.Software = area.Spare3; - process.EquipmentCode = area.Spare2; - - // 璋冪敤GetProcessApplyAsync鏂规硶锛岃幏鍙栧伐鑹虹敵璇� - - // 璋冪敤_processApplyService.GetProcessApplyAsync鏂规硶锛岃幏鍙栧伐鑹虹敵璇� - content = await _processApplyService.GetProcessApplyAsync(process); - - // 濡傛灉鐘舵�佷负false锛屽垯杩斿洖null - if (!content.Status) return content.Error("宸ヨ壓鐢宠澶辫触"); - - //// 璋冪敤GetProcessResponseAsync鏂规硶锛岃幏鍙栧伐鑹哄搷搴� - //var processResponse = await GetProcessResponseAsync(process, input.Position); - - List<string> strings = input.Position == "1088" ? new List<string>() { "CHSC01" } : new List<string>() { "JZSC01" }; - // 璋冪敤CreateNewTask鏂规硶锛屽垱寤烘柊浠诲姟 - content = await CreateNewTask(input, strings); - if (content.Status) + else { - var isBox = await _boxingInfoRepository.AddDataNavAsync(boxing); + // 澶勭悊寮傚父鐢佃姱鎯呭喌 + #region 鐢佃姱鍒嗙粨鏋滃紓甯镐笉闇�瑕佹垜浠鐞� + //var serialNosError = result.SerialNos.Where(x => x.SerialNoStatus != 1 && x.SerialNoStatus != 4).ToList(); + //if (serialNosError.Count > 0) + //{ + // return await HandleErrorCells(input, area, serialNosError); + //} + #endregion + var boxing = CreateBoxingInfo(result, input.PalletCode); + if (boxing == null) return content.Error("缁勭洏澶辫触"); + + input.ProductionLine = result.ProductionLine; + return await ProcessBasedOnProcessCode(boxing, area, input, result); } } catch (Exception err) { - // 濡傛灉鍙戠敓寮傚父锛屽垯璋冪敤content.Error鏂规硶锛岃褰曢敊璇俊鎭紝骞惰緭鍑洪敊璇俊鎭� + // 鏇磋缁嗙殑寮傚父澶勭悊锛屽彲浠ユ牴鎹紓甯哥被鍨嬭褰曚笉鍚岀殑閿欒鏃ュ織绛� content.Error(err.Message); Console.WriteLine(err.Message); } - // 杩斿洖content return content; } @@ -607,12 +796,10 @@ return content.Error($"鏆傛湭鎵惧埌銆恵input.PalletCode}銆戠殑浠诲姟"); return content = await UpdateExistingTask(input, task); - } catch (Exception err) { - - throw; + return content.Error(err.Message); } } @@ -626,35 +813,84 @@ WebResponseContent content = new WebResponseContent(); try { - // 璋冪敤BaseDal.QueryFirstAsync鏂规硶锛屾煡璇换鍔� var task = await BaseDal.QueryFirstAsync(x => x.PalletCode == input.PalletCode); if (task != null && task.TaskState == (int)TaskInStatusEnum.InNew) { // 鍒涘缓WMS浠诲姟 - WMSTaskDTO taskDTO = new WMSTaskDTO() - { - TaskNum = task.TaskNum.Value, - Grade = 1, - PalletCode = task.PalletCode, - RoadWay = task.Roadway, - SourceAddress = task.SourceAddress, - TargetAddress = task.Roadway, - TaskState = task.TaskState.Value, - Id = 0, - TaskType = task.TaskType, - }; + WMSTaskDTO taskDTO = CreateTaskDTO(task); return content.OK(data: task); } - // 鑾峰彇鐩爣鍦板潃 - List<string> strings = input.Position == "1016" ? new List<string>() { "CHSC01" } : new List<string>() { "JZSC01" }; + // 鏍规嵁浣嶇疆鏌ヨ鍖哄煙淇℃伅 + var areaCode = Regex.Replace(input.Position, @"-(\d+)", ""); + var area = await QueryAreaInfoByPosition(areaCode); + if (area == null) + { + return content.Error("璇ョ偣浣嶄笉鍦ㄥ尯鍩熷垪琛ㄤ腑瀛樺湪"); + } - return await CreateNewTask(input, strings, 1); + // 鑾峰彇鏁寸洏鐢佃姱灞炴�х姸鎬� + TrayCellsStatusDto trayCells = CreateTrayCellsStatusDto(area, input.PalletCode); + content = await GetTrayCellStatusAsync(trayCells); + if (!content.Status) + { + ConsoleHelper.WriteErrorLine($"鑾峰彇鐢佃姱鐘舵�佸け璐�:{content.Message}"); + return content; + } + + var result = JsonConvert.DeserializeObject<ResultTrayCellsStatus>(content.Data.ToString()); + if (result.ProductionLine.IsNullOrEmpty()) + { + ConsoleHelper.WriteErrorLine($"褰撳墠鎵樼洏鏃犱骇绾�,鑱旂郴MOM娣诲姞浜х嚎"); + return content.Error("褰撳墠鎵樼洏鏃犱骇绾�,鑱旂郴MOM娣诲姞浜х嚎"); + } + + var stationManagers = _stationManagerRepository.QueryData(x => x.stationType == 6 && x.stationChildCode == input.Position).FirstOrDefault(); + if (stationManagers == null) + { + stationManagers = _stationManagerRepository.QueryData(x => x.stationType == 1 && x.stationChildCode == input.Position).FirstOrDefault(); + if (stationManagers == null) + throw new Exception("鏈壘鍒扮┖鎵樼洏鍏ュ簱绔欏彴鍜屽叆搴撶珯鍙伴厤缃�"); + } + List<string> strings; + if (input.Position == "1016-3") + { + var configOne = _configService.GetByConfigKey(CateGoryConst.CONFIG_SYS_InStacker, SysConfigConst.CHInboundEmptyProductLineOne); + var configTwo = _configService.GetByConfigKey(CateGoryConst.CONFIG_SYS_InStacker, SysConfigConst.CHInboundEmptyProductLineTwo); + + List<string> productLineconfigOne = configOne.ConfigValue.Split(',').ToList(); + List<string> productLineconfigTwo = configTwo.ConfigValue.Split(',').ToList(); + + if (productLineconfigOne.Count == 0 && productLineconfigTwo.Count() == 0) + { + ConsoleHelper.WriteErrorLine($"鏈壘鍒伴厤缃枃浠朵骇绾块厤缃�"); + return content.Error("鏈壘鍒伴厤缃枃浠朵骇绾块厤缃�"); + } + if (productLineconfigOne.Contains(result.ProductionLine)) + { + strings = configOne.Remark.Split(',').ToList(); + } + else if (productLineconfigTwo.Contains(result.ProductionLine)) + { + strings = configTwo.Remark.Split(',').ToList(); + } + else + { + ConsoleHelper.WriteErrorLine($"鏈壘鍒皗result.ProductionLine}瀵瑰簲閰嶇疆宸烽亾"); + return content.Error($"鏈壘鍒皗result.ProductionLine}瀵瑰簲閰嶇疆宸烽亾"); + } + } + else + { + strings = stationManagers.Roadway.Split(',').ToList(); + } + + + return await CreateNewTask(input, result.ProductionLine, result.ProcessCode, strings, 1); } catch (Exception) { - throw; } } @@ -667,21 +903,46 @@ } // 鑾峰彇缁勭洏淇℃伅 - private async Task<DtBoxingInfo> CreateBoxingInfo(ResultTrayCellsStatus result, string palletCode) - { - return new DtBoxingInfo + private DtBoxingInfo CreateBoxingInfo(ResultTrayCellsStatus result, string palletCode) + { + var boxing=_boxingInfoRepository.QueryFirst(x=>x.PalletCode == palletCode); + if (boxing == null) { - PalletCode = palletCode, - IsFull = true, - BoxingInfoDetails = result.SerialNos.Select(serialNoObj => new DtBoxingInfoDetail + return new DtBoxingInfo { - SerialNumber = serialNoObj.SerialNo, - OrderNo = serialNoObj.PositionNo.ToString(), - Status = serialNoObj.SerialNoStatus, - MaterielCode = result.BindCode, - Remark = result.TrayBarcodePropertys.ToJsonString(), - }).ToList() - }; + PalletCode = palletCode, + IsFull = true, + ProcessCode = result.ProcessCode, + ProductionLine = result.ProductionLine, + BoxingInfoDetails = result.SerialNos.Select(serialNoObj => new DtBoxingInfoDetail + { + SerialNumber = serialNoObj.SerialNo, + OrderNo = serialNoObj.PositionNo.ToString(), + Status = serialNoObj.SerialNoStatus, + MaterielCode = result.BindCode, + Remark = result.TrayBarcodePropertys.ToJsonString(), + }).ToList() + }; + } + else { + _boxingInfoRepository.DeleteData(boxing); + return new DtBoxingInfo + { + PalletCode = palletCode, + IsFull = true, + ProcessCode = result.ProcessCode, + ProductionLine = result.ProductionLine, + BoxingInfoDetails = result.SerialNos.Select(seriaINoObj => new DtBoxingInfoDetail + { + SerialNumber = seriaINoObj.SerialNo, + OrderNo = seriaINoObj.PositionNo.ToString(), + Status = seriaINoObj.SerialNoStatus, + MaterielCode = result.BindCode, + Remark = result.TrayBarcodePropertys.ToJsonString(), + }).ToList() + }; + } + } // 鑾峰彇宸ヨ壓鐢宠 @@ -710,27 +971,28 @@ /// <param name="areaCode">鍖哄煙缂栫爜</param> /// <param name="roadways">宸烽亾缂栫爜闆嗗悎</param> /// <returns>杩斿洖缁撴灉闆�</returns> - public async Task<WebResponseContent> RequestTrayOutTaskAsync(string position, int tag, string areaCode, List<string> roadways) + public async Task<WebResponseContent> RequestTrayOutTaskAsync(string position, int tag, string areaCode, List<string> areaCodes, string productionLine) { WebResponseContent content = new WebResponseContent(); try { // 鏍规嵁鎵樼洏绫诲瀷鏌ヨ搴撳瓨淇℃伅 DtStockInfo stockInfo = tag == (int)TaskOutboundTypeEnum.Outbound - ? QueryStockInfoForRealTrayAsync(areaCode, roadways).Result - : QueryStockInfoForEmptyTrayAsync(areaCode, roadways).Result; - + ? areaCode != "CWSC1" ? await QueryStockInfoForRealTrayAsync(areaCode, areaCodes, productionLine) : await QueryStockInfoForRealTrayCWAsync(areaCodes, productionLine) + : await QueryStockInfoForEmptyTrayAsync(areaCode, position); if (stockInfo == null) { return content.Error("搴撳瓨淇℃伅涓嶅瓨鍦�"); } + + //ConsoleHelper.WriteColorLine(JsonConvert.SerializeObject(stockInfo), ConsoleColor.DarkMagenta); // 鏂板閲嶅浠诲姟鏍¢獙 var hasTask = BaseDal.QueryFirst(x => x.PalletCode == stockInfo.PalletCode); if (hasTask != null) { WMSTaskDTO taskDTO1 = CreateTaskDTO(hasTask); - return content.OK("宸插瓨鍦ㄧ┖鐩樺嚭搴撲换鍔�", data: taskDTO1); + return content.OK("宸插瓨鍦ㄥ嚭搴撲换鍔�", data: taskDTO1); } // 鍒涘缓鏂颁换鍔″疄渚� @@ -758,6 +1020,7 @@ { // 璁板綍寮傚父淇℃伅骞舵姏鍑� LogFactory.GetLog("璇锋眰鎵樼洏浠诲姟").Error(true, ex); + ConsoleHelper.WriteErrorLine("璇锋眰绌�/瀹炴墭鐩樹换鍔�" + ex.Message + "\r\n" + ex.StackTrace); return content.Error(ex.Message); } } @@ -765,43 +1028,149 @@ /// <summary> /// 鏌ヨ瀹炵洏搴撳瓨淇℃伅 /// </summary> - private async Task<DtStockInfo> QueryStockInfoForRealTrayAsync(string areaCode, List<string> roadways) + private async Task<DtStockInfo> QueryStockInfoForRealTrayAsync(string areaCode, List<string> devices, string productionLine) { - var area = await _areaInfoRepository.QueryFirstAsync(x => x.AreaCode == areaCode); + try + { + var area = await _areaInfoRepository.QueryFirstAsync(x => x.AreaCode == areaCode); + if (area == null) + { + ConsoleHelper.WriteErrorLine($"鏌ヨ瀹炵洏搴撳瓨淇℃伅鏃�,鏈壘鍒板尯鍩熶唬鐮佷负{areaCode}鐨勬暟鎹�"); + return null; + } - var result = await _stockInfoRepository.Db.Queryable<DtStockInfo>() - .Includes(x => x.LocationInfo) // 棰勫姞杞絃ocationInfo - .Includes(x => x.StockInfoDetails) // 棰勫姞杞絊tockInfoDetails - .Where(x => x.AreaCode == areaCode && x.OutboundTime < DateTime.Now && x.IsFull == true) // 杩囨护鏉′欢 - .Where(x => x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && x.LocationInfo.AreaId == area.AreaID) // 杩囨护鏉′欢 - .OrderBy(x => x.OutboundTime) // 鎺掑簭 - .FirstAsync(); // 鑾峰彇绗竴涓厓绱� + //var outBoundMateriel = AppSettings.app<OutBoundMateriel>("OutBoundMateriel"); + var outBoundMateriel = _dt_ChangeoversRepository.QueryData(x => x.Status == "1").ToList(); - //var firstOrDefault = result.FirstOrDefault(x => roadways.Contains(x.LocationInfo.RoadwayNo)); // 鏌ユ壘绗竴涓尮閰嶇殑鍏冪礌 - //var firstOrDefault = result[0]; // 鏌ユ壘绗竴涓尮閰嶇殑鍏冪礌 - //return firstOrDefault; - return result; + List<string>? materielCodes = outBoundMateriel.Count != 0 + ? outBoundMateriel.Where(x => x.ProductionLine == productionLine && x.ProcessCode == area.AreaCode) + .Select(x => x.MaterielCode) + .ToList() + : null; + + var result = new DtStockInfo(); + + result = await _stockInfoRepository.Db.Queryable<DtStockInfo>() + .Includes(x => x.LocationInfo) + .Includes(x => x.StockInfoDetails) + .Where(x => x.AreaCode == areaCode && x.OutboundTime < DateTime.Now && x.IsFull) + .WhereIF(!productionLine.IsNullOrEmpty(), x => x.ProductionLine == productionLine) + .WhereIF(!devices.IsNullOrEmpty(), x => devices.Contains(x.LocationInfo.RoadwayNo)) + .Where(x => x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && x.LocationInfo.AreaId == area.AreaID && x.LocationInfo.EnalbeStatus == (int)EnableEnum.Enable) + .WhereIF(!materielCodes.IsNullOrEmpty(), x => x.StockInfoDetails.Any(y => materielCodes.Contains(y.MaterielCode))) + .OrderBy(x => x.OutboundTime) + .FirstAsync(); + + if (result.IsNullOrEmpty()) + ConsoleHelper.WriteErrorLine($"{area.AreaName}-{productionLine}鏌ヨ瀹炵洏搴撳瓨淇℃伅澶辫触:鏈壘鍒扮鍚堟潯浠剁殑鏁版嵁"); + + return result; + } + catch (Exception ex) + { + ConsoleHelper.WriteErrorLine("鏌ヨ瀹炵洏搴撳瓨淇℃伅澶辫触:" + ex.Message + "\r\n" + ex.StackTrace); + return null; + } + } + + /// <summary> + /// 鏌ヨ甯告俯瀹炵洏搴撳瓨淇℃伅 + /// </summary> + private async Task<DtStockInfo> QueryStockInfoForRealTrayCWAsync(List<string> areaCodes, string productionLine) + { + try + { + var areaId = (await _areaInfoRepository.QueryDataAsync(x => areaCodes.Contains(x.AreaCode))).Select(x => x.AreaID).ToList(); + if (areaId.Count == 0) + { + ConsoleHelper.WriteErrorLine($"鏌ヨ甯告俯瀹炵洏搴撳瓨淇℃伅鏃�,鏈壘鍒板尯鍩熶唬鐮佷负{JsonConvert.SerializeObject(areaCodes)}鐨勬暟鎹�"); + return null; + } + + //var outBoundMateriel = AppSettings.app<OutBoundMateriel>("OutBoundMateriel"); + //List<string> materielCodes = null; + //if (outBoundMateriel.Count != 0) + //{ + // materielCodes = outBoundMateriel.Where(x => x.ProductionLine == productionLine && x.ProcessCode == areaCodes[0]).Select(x => x.MaterielCode).ToList(); + //} + + //var outBoundMateriel = AppSettings.app<OutBoundMateriel>("OutBoundMateriel"); + var outBoundMateriel = _dt_ChangeoversRepository.QueryData(x => x.Status == "1").ToList(); + List<string>? materielCodes = outBoundMateriel.Count != 0 + ? outBoundMateriel.Where(x => x.ProductionLine == productionLine && x.ProcessCode == areaCodes[0]) + .Select(x => x.MaterielCode) + .ToList() + : null; + + var deviceCode = SqlSugarHelper.DbWCS.Queryable<Dt_DeviceInfo>() + .Where(x => x.DeviceStatus == "1") + .Where(x => x.DeviceCode.Contains("CWSC")) + .ToList().Select(x => x.DeviceCode).ToList(); + + var result = await _stockInfoRepository.Db.Queryable<DtStockInfo>() + .Where(x => areaCodes.Contains(x.AreaCode) && x.OutboundTime < DateTime.Now && x.IsFull == true) // 杩囨护鏉′欢 + .WhereIF(!productionLine.IsNullOrEmpty(), x => x.ProductionLine == productionLine) + .Includes(x => x.LocationInfo) + .WhereIF(!deviceCode.IsNullOrEmpty(), x => deviceCode.Contains(x.LocationInfo.RoadwayNo)) + .Where(x => x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && areaId.Contains(x.LocationInfo.AreaId) && x.LocationInfo.EnalbeStatus == (int)EnableEnum.Enable) // 杩囨护鏉′欢 + .Includes(x => x.StockInfoDetails) + .WhereIF(!materielCodes.IsNullOrEmpty(), x => x.StockInfoDetails.Any(y => materielCodes.Contains(y.MaterielCode))) + .OrderBy(x => x.OutboundTime) // 鎺掑簭 + .FirstAsync(); // 鑾峰彇绗竴涓厓绱� + + if (result.IsNullOrEmpty()) + ConsoleHelper.WriteErrorLine($"{JsonConvert.SerializeObject(areaCodes)}-{productionLine}鏌ヨ甯告俯瀹炵洏搴撳瓨淇℃伅澶辫触:鏈壘鍒扮鍚堟潯浠剁殑鏁版嵁"); + + return result; + } + catch (Exception ex) + { + ConsoleHelper.WriteErrorLine("QueryStockInfoForRealTrayCWAsync鏌ヨ瀹炵洏搴撳瓨淇℃伅澶辫触:" + ex.Message + "\r\n" + ex.StackTrace); + return null; + } } /// <summary> /// 鏌ヨ绌虹洏搴撳瓨淇℃伅 /// </summary> - private async Task<DtStockInfo> QueryStockInfoForEmptyTrayAsync(string areaCode, List<string> roadways) + private async Task<DtStockInfo> QueryStockInfoForEmptyTrayAsync(string areaCode, string position) { - var area = await _areaInfoRepository.QueryFirstAsync(x => x.AreaCode == areaCode); + try + { + var area = await _areaInfoRepository.QueryFirstAsync(x => x.AreaCode == areaCode); - var result = await _stockInfoRepository.Db.Queryable<DtStockInfo>() - .Includes(x => x.LocationInfo) // 棰勫姞杞絃ocationInfo - .Includes(x => x.StockInfoDetails) // 棰勫姞杞絊tockInfoDetails - .Where(x => x.AreaCode == areaCode && x.IsFull == false) - .Where(x => x.StockInfoDetails.Any(y => y.MaterielCode == "绌烘墭鐩�")) - .Where(x => x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && x.LocationInfo.AreaId == area.AreaID) // 杩囨护鏉′欢 - .OrderBy(x => x.CreateDate) // 鎺掑簭 - .FirstAsync(); // 杞崲涓哄垪琛� + ConsoleHelper.WriteColorLine(position + "..." + areaCode, ConsoleColor.Magenta); + var station = await _stationManagerRepository.QueryFirstAsync(x => x.stationChildCode == position && x.stationType == 17); - //var firstOrDefault = result[0]; // 鏌ユ壘绗竴涓尮閰嶇殑鍏冪礌 - //return firstOrDefault; - return result; + ConsoleHelper.WriteColorLine(station.Roadway, ConsoleColor.Magenta); + var stackers = station.Roadway.Split(',').ToList(); + + var deviceCode = SqlSugarHelper.DbWCS.Queryable<Dt_DeviceInfo>() + .Where(x => x.DeviceStatus == "1") + .Where(x => stackers.Contains(x.DeviceCode)) + .ToList().Select(x => x.DeviceCode).ToList(); + + var result = await _stockInfoRepository.Db.Queryable<DtStockInfo>() + .Where(x => x.ProductionLine == station.productLine) + .Where(x => x.AreaCode == areaCode && x.IsFull == false) + .Includes(x => x.StockInfoDetails) + .Where(x => x.StockInfoDetails.Any(y => y.MaterielCode == "绌烘墭鐩�")) + .Includes(x => x.LocationInfo) + .WhereIF(!deviceCode.IsNullOrEmpty(), x => deviceCode.Contains(x.LocationInfo.RoadwayNo)) + .Where(x => x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && x.LocationInfo.AreaId == area.AreaID && x.LocationInfo.EnalbeStatus == (int)EnableEnum.Enable) // 杩囨护鏉′欢 + .OrderBy(x => x.CreateDate) // 鎺掑簭 + .FirstAsync(); // 杞崲涓哄垪琛� + + if (result.IsNullOrEmpty()) + ConsoleHelper.WriteErrorLine($"{area}-{station.productLine}鏌ヨ绌虹洏搴撳瓨淇℃伅澶辫触:鏈壘鍒扮鍚堟潯浠剁殑鏁版嵁"); + + return result; + } + catch (Exception ex) + { + ConsoleHelper.WriteErrorLine("QueryStockInfoForEmptyTrayAsync鏌ヨ瀹炵洏搴撳瓨淇℃伅澶辫触:" + ex.Message + "\r\n" + ex.StackTrace); + return null; + } } /// <summary> @@ -811,7 +1180,7 @@ { return new Dt_Task { - Grade = 1, + Grade = tag == 104 ? (stockInfo.LocationInfo.RoadwayNo.Contains("CWSC") ? 1 : 2) : (stockInfo.LocationInfo.RoadwayNo.Contains("CWSC") ? 2 : 1), Roadway = stockInfo.LocationInfo.RoadwayNo, TargetAddress = position, Dispatchertime = DateTime.Now, @@ -822,9 +1191,13 @@ SourceAddress = stockInfo.LocationCode, CurrentAddress = stockInfo.LocationCode, TaskState = (int)TaskOutStatusEnum.OutNew, - TaskType = tag == (int)TaskOutboundTypeEnum.Outbound ? (int)TaskOutboundTypeEnum.Outbound : (int)TaskOutboundTypeEnum.OutTray, + TaskType = tag, TaskNum = BaseDal.GetTaskNo().Result, - Creater = "System" // 淇鎷煎啓閿欒 + Creater = "System", // 淇鎷煎啓閿欒 + CreateDate = DateTime.Now, + TaskId = 0, + ProductionLine = stockInfo.ProductionLine, + ProcessCode = stockInfo.ProcessCode, }; } @@ -836,7 +1209,7 @@ return new WMSTaskDTO { TaskNum = task.TaskNum.Value, - Grade = 1, + Grade = task.Grade.Value, PalletCode = task.PalletCode, RoadWay = task.Roadway, SourceAddress = task.SourceAddress, @@ -844,10 +1217,11 @@ TaskState = task.TaskState.Value, Id = 0, TaskType = task.TaskType, + ProductionLine = task.ProductionLine, }; } - #endregion 璇锋眰鍑哄簱 + #endregion 璇锋眰鍑哄簱锛堝疄鐩�&绌虹洏锛� #region 浠诲姟鐘舵�佹洿鏀� @@ -897,34 +1271,422 @@ return content; } - #endregion + #endregion 浠诲姟鐘舵�佹洿鏀� - #region 鍑哄簱瑙g洏 + #region 鎸囧畾浠诲姟鍑哄簱 - /// <summary> - /// 鍑哄簱瑙g洏鎺ュ彛 - /// </summary> - /// <param name="taskNum"></param> - /// <returns></returns> - public async Task<WebResponseContent> OutUnblockInterface(int taskNum) + public async Task<WebResponseContent> CreateAndSendOutboundTask(string locationCode, string palletCode) { WebResponseContent content = new WebResponseContent(); try { - var task = await BaseDal.QueryFirstAsync(x => x.TaskNum == taskNum); - if (task == null) - return content.Error("鏈壘鍒颁换鍔�"); - task.TaskState = (int)TaskOutStatusEnum.Line_OutFinish; - var taskHty = CreateHistoricalTask(task); + // 鏌ヨ搴撳瓨淇℃伅 + var stockInfo = await _stockInfoRepository.QueryFirstNavAsync(x => x.LocationCode == locationCode && x.PalletCode == palletCode); + if (stockInfo == null) + { + return content.Error("鏈煡璇㈠埌瀵瑰簲鐨勫簱瀛樹俊鎭�"); + } + if (stockInfo.LocationInfo.LocationStatus != (int)LocationEnum.InStock) + { + return content.Error("璇ヨ揣浣嶇姸鎬佷笉绛変簬銆愭湁璐с�戣鏌ョ湅鏄惁宸茬粡鏈変换鍔★紒"); + } + + var task = await BaseDal.QueryFirstAsync(x => x.PalletCode == palletCode); + if (task != null) + { + return content.Error($"銆恵palletCode}銆戝凡瀛樺湪浠诲姟"); + } + + int taskType = 0; + if (stockInfo.IsFull) + taskType = (int)TaskOutboundTypeEnum.OutQuality; + else + taskType = (int)TaskOutboundTypeEnum.OutTray; + + if (stockInfo.AreaCode.Contains("CH")) + { + // 鍒涘缓骞舵坊鍔犱换鍔″埌鏁版嵁搴� + if(stockInfo.LocationInfo.RoadwayNo=="CHSC1"|| stockInfo.LocationInfo.RoadwayNo == "CHSC2"|| stockInfo.LocationInfo.RoadwayNo == "CHSC3") + { + task = CreateTask(stockInfo, "1020-1", taskType); + } + else + { + task = CreateTask(stockInfo, "1049-8", taskType); + } + + } + else + { + if (stockInfo.LocationInfo.RoadwayNo.Contains("JZSC")) + { + var targetAddress = "002-021-001"; + if (stockInfo.LocationInfo.RoadwayNo == "JZSC4") + targetAddress = "001-021-001"; + task = CreateTask(stockInfo, targetAddress, taskType); + } + } + //var taskId = await BaseDal.AddDataAsync(task); + //if (taskId <= 0) + //{ + // return content.Error("浠诲姟鍒涘缓澶辫触"); + //} + + // 鍒涘缓浠诲姟浼犺緭鐢ㄧ殑DTO瀵硅薄 + var taskDTO = CreateTaskDTO(task); + + // 鑾峰彇WMS IP鍦板潃鐢ㄤ簬鍙戦�佷换鍔¤姹� + var wmsIpAddress = GetWCSIpReceiveTask(); + if (wmsIpAddress == null) + { + throw new InvalidOperationException("WMS IP 鏈厤缃�"); + } + + var tasks = new List<WMSTaskDTO>() { taskDTO }; + // 鍙戦�佷换鍔¤姹傚埌WMS + var result = await HttpHelper.PostAsync(wmsIpAddress, tasks.ToJsonString()); + content = JsonConvert.DeserializeObject<WebResponseContent>(result); + if (content.Status) + { + // 娣诲姞浠诲姟鍒版暟鎹簱 + await BaseDal.AddDataAsync(task); + // 鏇存柊搴撳瓨浣嶇疆鐘舵�佷负涓嶅彲鐢� + stockInfo.LocationInfo.LocationStatus = (int)LocationEnum.InStockDisable; + await _locationRepository.UpdateDataAsync(stockInfo.LocationInfo); + } } 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 鎸囧畾浠诲姟鍑哄簱 + + #region 闈欑疆寮傚父鍙e叆搴� + + public async Task<WebResponseContent> CreateAndSendInboundTask(string palletCode, string position) + { + #region + //WebResponseContent content = new WebResponseContent(); + //try + //{ + // // 鏌ヨ搴撳瓨淇℃伅 + // var stockInfo = await _stockInfoRepository.QueryFirstNavAsync(x => x.PalletCode == palletCode); + // if (stockInfo == null) + // { + // var taskOld = BaseDal.QueryFirst(x => x.PalletCode == palletCode); + // if (!taskOld.IsNullOrEmpty()) + // {// 鍒涘缓WMS浠诲姟 + // WMSTaskDTO taskDTO = new WMSTaskDTO() + // { + // TaskNum = taskOld.TaskNum.Value, + // Grade = 1, + // PalletCode = taskOld.PalletCode, + // RoadWay = taskOld.Roadway, + // SourceAddress = taskOld.CurrentAddress, + // TargetAddress = taskOld.TargetAddress, + // TaskState = taskOld.TaskState.Value, + // Id = 0, + // TaskType = taskOld.TaskType, + // }; + // return content.OK(data: taskDTO); + // } + // var area = _areaInfoRepository.QueryFirst(x => x.AreaID == 2); + // var station = _stationManagerRepository.QueryFirst(x => x.stationChildCode == position); + // TrayCellsStatusDto trayCells = CreateTrayCellsStatusDto(area, palletCode); + // content = await GetTrayCellStatusAsync(trayCells); + // if (!content.Status) return content; + + // ConsoleHelper.WriteErrorLine(content.ToJsonString()); + // var result = JsonConvert.DeserializeObject<ResultTrayCellsStatus>(content.Data.ToString()); + // if (!result.Success) return content.Error(result.MOMMessage); + + // if (result.SerialNos.Count > 0) + // { + // var boxing = CreateBoxingInfo(result, palletCode); + // if (boxing == null) return content.Error("缁勭洏澶辫触"); + + // // 鑾峰彇宸ヨ壓璺嚎 + // ProcessApplyDto process = await GetProcessApplyAsync(result); + // // 璧嬪�间笂浣嶈蒋浠跺悕绉板拰璁惧缂栫爜 + // process.Software = area.Spare3; + // process.EquipmentCode = area.Spare2; + // content = await _processApplyService.GetProcessApplyAsync(process); + // if (!content.Status) return content.Error("宸ヨ壓鐢宠澶辫触"); + + // var resultProcessApply = JsonConvert.DeserializeObject<ResultProcessApply>(content.Data.ToString()); + // if (!resultProcessApply.Success) return content.Error("宸ヨ壓鐢宠澶辫触"); + + // var number = resultProcessApply.ProcessInfo.Where(x => x.ProcessCode.Contains(boxing.ProcessCode)).FirstOrDefault().Number.ToInt32(); + // foreach (var item in resultProcessApply.ProcessInfo) + // { + // if (item.Number.ToInt32() == number + 1) + // { + // boxing.NextProcessCode = item.ProcessCode; + // } + // } + // var location = await GetLocationDistributeAsync(station.Roadway); + + // ConsoleHelper.WriteErrorLine(location.ToJsonString()); + + // // 鍒涘缓鏂颁换鍔″疄渚� + // var task = new Dt_Task + // { + // CurrentAddress = station.stationLocation, + // Grade = 1, + // Roadway = station.Roadway, + // TargetAddress = location.LocationCode, + // Dispatchertime = DateTime.Now, + // MaterialNo = "", + // NextAddress = location.LocationCode, + // OrderNo = null, + // PalletCode = palletCode, + // SourceAddress = position, + // TaskState = (int)TaskInStatusEnum.Line_InFinish, + // TaskType = (int)TaskInboundTypeEnum.Inbound, + // TaskNum = await BaseDal.GetTaskNo(), + // Creater = "Systeam" + // }; + + // // 鍒涘缓WMS浠诲姟 + // WMSTaskDTO taskDTO = new WMSTaskDTO() + // { + // TaskNum = task.TaskNum.Value, + // Grade = 1, + // PalletCode = task.PalletCode, + // RoadWay = task.Roadway, + // SourceAddress = task.SourceAddress, + // TargetAddress = task.TargetAddress, + // TaskState = task.TaskState.Value, + // Id = 0, + // TaskType = task.TaskType, + // }; + + // await _unitOfWorkManage.UseTranAsync(async () => + // { + // // 娣诲姞浠诲姟鍒版暟鎹簱 + // await BaseDal.AddDataAsync(task); + // // 鏇存柊搴撳瓨浣嶇疆鐘舵�佷负涓嶅彲鐢� + // location.LocationStatus = (int)LocationEnum.InStockDisable; + // await _locationRepository.UpdateDataAsync(location); + // await _boxingInfoRepository.AddDataNavAsync(boxing); + // }); + + // content.OK(data: taskDTO); + // } + // else + // content.Error(result.MOMMessage); + // } + // else + // { + // // TODO璐ㄦ鍥炲簱 + // var area = _areaInfoRepository.QueryFirst(x => x.AreaID == 2); + // } + //} + //catch (Exception ex) + //{ + // content.Error(ex.Message); + //} + //return content; + #endregion 闈欑疆寮傚父鍙e叆搴� + WebResponseContent content = new WebResponseContent(); + try + { + // 鏌ヨ搴撳瓨淇℃伅 + var stockInfo = await _stockInfoRepository.QueryFirstNavAsync(x => x.PalletCode == palletCode); + if (stockInfo == null) + { + var taskOld = BaseDal.QueryFirst(x => x.PalletCode == palletCode); + if (taskOld != null) + { + // 鍒涘缓WMS浠诲姟 + WMSTaskDTO taskDTO = CreateWMSTaskDTO(taskOld); + return content.OK(data: taskDTO); + } + var area = _areaInfoRepository.QueryFirst(x => x.AreaID == 2); + var station = _stationManagerRepository.QueryFirst(x => x.stationChildCode == position); + TrayCellsStatusDto trayCells = CreateTrayCellsStatusDto(area, palletCode); + content = await GetTrayCellStatusAsync(trayCells); + if (!content.Status) return content; + + ConsoleHelper.WriteErrorLine(content.ToJsonString()); + var result = JsonConvert.DeserializeObject<ResultTrayCellsStatus>(content.Data.ToString()); + if (result == null || !result.Success) return content.Error(result?.MOMMessage ?? "Deserialization error"); + + if (result.SerialNos.Count > 0) + { + var boxing = CreateBoxingInfo(result, palletCode); + if (boxing == null) return content.Error("缁勭洏澶辫触"); + + // 鑾峰彇宸ヨ壓璺嚎 + ProcessApplyDto process = await GetProcessApplyAsync(result); + // 璧嬪�间笂浣嶈蒋浠跺悕绉板拰璁惧缂栫爜 + process.Software = area.Spare3; + process.EquipmentCode = area.Spare2; + + content = await _processApplyService.GetProcessApplyAsync(process); + if (!content.Status) return content.Error("宸ヨ壓鐢宠澶辫触"); + + var resultProcessApply = JsonConvert.DeserializeObject<ResultProcessApply>(content.Data.ToString()) as ResultProcessApply; + if (resultProcessApply == null || !resultProcessApply.Success) return content.Error("宸ヨ壓鐢宠澶辫触"); + + var number = resultProcessApply.ProcessInfo.Where(x => x.ProcessCode.Contains(boxing.ProcessCode)).FirstOrDefault()?.Number.ToInt32() ?? 0; + foreach (var item in resultProcessApply.ProcessInfo) + { + if (item.Number.ToInt32() == number + 1) + { + boxing.NextProcessCode = item.ProcessCode; + } + } + var location = await GetLocationDistributeAsync(station.Roadway); + + ConsoleHelper.WriteErrorLine(location.ToJsonString()); + + // 鍒涘缓鏂颁换鍔″疄渚� + var task = new Dt_Task + { + CurrentAddress = station.stationLocation, + Grade = 1, + Roadway = station.Roadway, + TargetAddress = location.LocationCode, + Dispatchertime = DateTime.Now, + MaterialNo = "", + NextAddress = location.LocationCode, + OrderNo = null, + PalletCode = palletCode, + SourceAddress = position, + TaskState = (int)TaskInStatusEnum.Line_InFinish, + TaskType = (int)TaskInboundTypeEnum.Inbound, + TaskNum = await BaseDal.GetTaskNo(), + Creater = "System", + ProductionLine = result.ProductionLine, + ProcessCode = result.ProcessCode, + }; + + // 鍒涘缓WMS浠诲姟 + WMSTaskDTO taskDTO = CreateWMSTaskDTO(task); + + await _unitOfWorkManage.UseTranAsync(async () => + { + // 娣诲姞浠诲姟鍒版暟鎹簱 + await BaseDal.AddDataAsync(task); + // 鏇存柊搴撳瓨浣嶇疆鐘舵�佷负涓嶅彲鐢� + location.LocationStatus = (int)LocationEnum.Lock; + await _locationRepository.UpdateDataAsync(location); + await _boxingInfoRepository.AddDataNavAsync(boxing); + }); + + content.OK(data: taskDTO); + } + else + { + var location = await GetLocationDistributeAsync(station.Roadway); + var task = new Dt_Task + { + CurrentAddress = station.stationLocation, + Grade = 1, + Roadway = station.Roadway, + TargetAddress = location.LocationCode, + Dispatchertime = DateTime.Now, + MaterialNo = "", + NextAddress = location.LocationCode, + OrderNo = null, + PalletCode = palletCode, + SourceAddress = position, + TaskState = (int)TaskInStatusEnum.Line_InFinish, + TaskType = (int)TaskInboundTypeEnum.InTray, + TaskNum = await BaseDal.GetTaskNo(), + Creater = "System", + ProductionLine = result.ProductionLine, + ProcessCode = result.ProcessCode, + }; + // 鍒涘缓WMS浠诲姟 + WMSTaskDTO taskDTO = CreateWMSTaskDTO(task); + + await _unitOfWorkManage.UseTranAsync(async () => + { + // 娣诲姞浠诲姟鍒版暟鎹簱 + await BaseDal.AddDataAsync(task); + // 鏇存柊搴撳瓨浣嶇疆鐘舵�佷负涓嶅彲鐢� + location.LocationStatus = (int)LocationEnum.Lock; + await _locationRepository.UpdateDataAsync(location); + }); + + content.OK(data: taskDTO); + } + } + else + { + // TODO璐ㄦ鍥炲簱 + var area = _areaInfoRepository.QueryFirst(x => x.AreaID == 2); + } + } + catch (Exception ex) + { + // 鏇磋缁嗙殑鏃ュ織璁板綍锛屽彲浣跨敤鏃ュ織妗嗘灦鏇挎崲 Console.WriteLine + Console.WriteLine($"Error in CreateAndSendInboundTask: {ex.Message}"); content.Error(ex.Message); } return content; } - #endregion + private WMSTaskDTO CreateWMSTaskDTO(object source) + { + if (source is Dt_Task taskOld) + { + return new WMSTaskDTO() + { + TaskNum = taskOld.TaskNum.Value, + Grade = 1, + PalletCode = taskOld.PalletCode, + RoadWay = taskOld.Roadway, + SourceAddress = taskOld.SourceAddress, + TargetAddress = taskOld.TargetAddress, + TaskState = taskOld.TaskState.Value, + Id = 0, + TaskType = taskOld.TaskType, + ProductionLine = taskOld.ProductionLine + }; + } + else if (source is Dt_Task task) + { + return new WMSTaskDTO() + { + TaskNum = task.TaskNum.Value, + Grade = 1, + PalletCode = task.PalletCode, + RoadWay = task.Roadway, + SourceAddress = task.SourceAddress, + TargetAddress = task.TargetAddress, + TaskState = task.TaskState.Value, + Id = 0, + TaskType = task.TaskType, + ProductionLine = task.ProductionLine + }; + } + else + { + throw new ArgumentException("Invalid source object type for WMSTaskDTO creation."); + } + } + + #endregion 澶栭儴鎺ュ彛鏂规硶 #endregion 澶栭儴鎺ュ彛鏂规硶 @@ -968,6 +1730,35 @@ public async Task<bool> Delete(List<int> 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("鏈壘鍒颁换鍔′俊鎭�!"); + } + var taskHtyNG = CreateHistoricalTask(task, true); + + // 鎵ц鏁版嵁搴撲簨鍔� + + // 娣诲姞鍘嗗彶浠诲姟 + var isTaskHtyAdd = _task_HtyRepository.AddData(taskHtyNG) > 0; + + // 鍒犻櫎浠诲姟鏁版嵁 + var isTaskDelete = BaseDal.Delete(task.TaskId); + + return content.OK("鍒犻櫎鎴愬姛!"); + } + catch (Exception ex) + { + return content.Error("鍒犻櫎浠诲姟寮傚父锛�" + ex.Message); + } } /// <summary> @@ -1075,56 +1866,27 @@ #region private 鍐呴儴鏂规硶 /// <summary> - /// 鏇存柊鍑哄簱璁㈠崟鍜屽簱瀛樹俊鎭� - /// </summary> - /// <param name="stock">搴撳瓨瀹炰緥</param> - /// <param name="barCode">鏉$爜</param> - /// <returns>鏇存柊鍚庣殑璁㈠崟鍜屽簱瀛樹俊鎭�</returns> - private async Task<Dt_OutOrderAndStock> UpdateOrderAndStockAsync(DtStockInfo stock, string barCode) - { - //鏍规嵁PalletCode鑾峰彇璁㈠崟鍜屽簱瀛樹俊鎭� - var orderStock = await _outOrderAndStockRepository.GetOrderAndStock(palletCode: barCode); - - //瀹屾垚鏁伴噺澧炲姞 - orderStock.CompletedQuantity += stock.StockInfoDetails.Sum(x => x.StockQuantity); - - //璁㈠崟璇︽儏瀹屾垚鏁伴噺澧炲姞 - orderStock.OrderList.OrderDetailList.CompletedQuantity += stock.StockInfoDetails.Sum(x => x.StockQuantity); - - //杩斿洖鏇存柊鍚庣殑璁㈠崟鍜屽簱瀛樹俊鎭� - return orderStock; - } - - /// <summary> - /// 鍒ゆ柇璁㈠崟鏄惁瀹屾垚 - /// </summary> - /// <param name="orderStock">璁㈠崟鍜屽簱瀛樹俊鎭�</param> - /// <returns>鏄惁瀹屾垚</returns> - // 鍒ゆ柇璁㈠崟鏄惁瀹屾垚 - private bool IsOrderComplete(Dt_OutOrderAndStock orderStock) - { - // 濡傛灉鍑哄簱鏁伴噺绛変簬瀹屾垚鍑哄簱鏁伴噺锛屽垯璁㈠崟瀹屾垚 - return orderStock.CompletedQuantity == orderStock.OutboundQuantity; - } - - /// <summary> /// 鍒涘缓鍘嗗彶浠诲姟璁板綍 /// </summary> /// <param name="task"></param> /// <returns></returns> - private Dt_Task_Hty CreateHistoricalTask(Dt_Task task) + private Dt_Task_Hty CreateHistoricalTask(Dt_Task task, bool isHand = false) { // 鏇存柊浠诲姟鐘舵�� - task.TaskState = TaskOutStatusEnum.OutFinish.ObjToInt(); + task.TaskState = task.TaskType > 199 ? (int)TaskInStatusEnum.InFinish : (int)TaskOutStatusEnum.OutFinish; task.CurrentAddress = task.NextAddress; // 鍒涘缓鍘嗗彶浠诲姟 var taskHty = _mapper.Map<Dt_Task_Hty>(task); taskHty.FinishTime = DateTime.Now; taskHty.TaskId = 0; - taskHty.OperateType = (int)OperateTypeEnum.鑷姩瀹屾垚; + taskHty.OperateType = isHand ? (int)OperateTypeEnum.浜哄伐鍒犻櫎 : App.User.UserName != null ? (int)OperateTypeEnum.浜哄伐瀹屾垚 : (int)OperateTypeEnum.鑷姩瀹屾垚; taskHty.SourceId = task.TaskId; - taskHty.TaskState = TaskOutStatusEnum.OutFinish.ObjToInt(); + 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; } @@ -1134,20 +1896,19 @@ /// <param name="stock">搴撳瓨瀵硅薄</param> /// <param name="toLocation">鐩爣浣嶇疆</param> // 鏇存柊搴撳瓨鍜屼綅缃俊鎭� - private (DtStockInfo, DtLocationInfo) UpdateStockLocation(DtStockInfo stock, string toLocation) + private (DtStockInfo, DtLocationInfo, DtLocationInfo) UpdateStockLocation(DtStockInfo stock, Dt_Task task) { - // 鑾峰彇搴撳瓨淇℃伅 - var locationInfo = _locationRepository.QueryFirst(x => x.LocationCode == stock.LocationCode); - // 灏嗗簱瀛樼姸鎬佽缃负鍦ㄥ簱 - locationInfo.LocationStatus = LocationEnum.InStock.ObjToInt(); + //淇敼鏉ユ簮搴撲綅鍜� 鐩爣搴撲綅鐘舵�� + var fromLocation = _locationRepository.QueryFirst(x => x.LocationCode == task.SourceAddress && x.RoadwayNo == task.Roadway); + fromLocation.LocationStatus = LocationEnum.Free.ObjToInt(); + var toLocation = _locationRepository.QueryFirst(x => x.LocationCode == task.SourceAddress && x.RoadwayNo == task.Roadway); + toLocation.LocationStatus = LocationEnum.InStock.ObjToInt(); // 灏嗗簱瀛樹綅缃缃负鐩爣浣嶇疆 - stock.LocationCode = toLocation; - // 灏嗗簱瀛樼姸鎬佽缃负鍦ㄥ簱 - stock.LocationInfo.LocationStatus = LocationEnum.InStock.ObjToInt(); + stock.LocationCode = task.TargetAddress; // 杩斿洖鏇存柊鍚庣殑搴撳瓨鍜屼綅缃俊鎭� - return (stock, locationInfo); + return (stock, fromLocation, toLocation); } /// <summary> @@ -1173,12 +1934,42 @@ { // 娣诲姞搴撳瓨 isUpdateStock = await _stockInfoRepository.AddDataNavAsync(stock); - isDeleteBoxing = await _boxingInfoRepository.Db.DeleteNav<DtBoxingInfo>(x => x.Id == boxingInfo.Id) - .Include(x => x.BoxingInfoDetails) - .ExecuteCommandAsync(); + if (boxingInfo != null) + { + isDeleteBoxing = await _boxingInfoRepository.Db.DeleteNav<DtBoxingInfo>(x => x.Id == boxingInfo.Id) + .Include(x => x.BoxingInfoDetails) + .ExecuteCommandAsync(); + } } + #region 鏇存柊搴撳瓨淇℃伅锛堟殏鏃朵笉闇�瑕侊級 + //if (stock.IsFull) + //{ + // // 鏌ヨ绗﹀悎鏉′欢鐨勫簱瀛樹俊鎭� + // var stocks = _stockInfoRepository.QueryData(x => x.AreaCode == stock.AreaCode && x.ProductionLine == stock.ProductionLine && x.SpecialParameterDuration != stock.SpecialParameterDuration); + // // 鏌ヨ浠诲姟淇℃伅 + // var tasks = BaseDal.QueryData(x => x.PalletCode != stock.PalletCode && x.ProductionLine == stock.ProductionLine).Select(x => x.PalletCode).ToList(); + + // if (stocks != null && stocks.Count > 0) + // { + // // 杩囨护鍑洪渶瑕佹洿鏂扮殑搴撳瓨淇℃伅 + // var stocksToUpdate = stocks.Where(item => !tasks.Contains(item.PalletCode)).ToList(); + // foreach (var item in stocksToUpdate) + // { + // // 鏇存柊搴撳瓨淇℃伅鐨勭壒瀹氬弬鏁� + // item.SpecialParameterDuration = stock.SpecialParameterDuration; + // item.ParameterInfos = stock.ParameterInfos; + // item.OutboundTime = Convert.ToDateTime(item.LinedProcessFeedbackTime == null ? item.CreateDate : item.LinedProcessFeedbackTime).AddHours(Convert.ToDouble(stock.SpecialParameterDuration)); + // } + // if (stocksToUpdate.Count > 0) + // { + // // 寮傛鏇存柊搴撳瓨淇℃伅 + // var isUpdates = await _stockInfoRepository.UpdateDataAsync(stocksToUpdate); + // } + // } + //} + #endregion // 娣诲姞鍘嗗彶浠诲姟 var isTaskHtyAdd = await _task_HtyRepository.AddDataAsync(taskHty) > 0; @@ -1213,69 +2004,95 @@ #region 浠诲姟璇锋眰鏂规硶 + private static readonly SemaphoreSlim _semaphoreUpdate = new SemaphoreSlim(1, 1); // 鏇存柊浠诲姟璐т綅 private async Task<WebResponseContent> UpdateExistingTask(RequestTaskDto input, Dt_Task task) { - if (task == null) - { - return new WebResponseContent().Error("浠诲姟瀵硅薄涓虹┖"); - } - + await _semaphoreUpdate.WaitAsync(); try { - // 鍒涘缓WebResponseContent瀵硅薄 - var content = new WebResponseContent(); - - // 鑾峰彇鐩爣鍦板潃鍜屾洿鏂颁换鍔$姸鎬� - if (task.TaskType == (int)TaskInboundTypeEnum.InNG) + if (task == null) { - // TODO 鏍规嵁宸烽亾鏌ユ壘瀵瑰簲NG鍙o紝鐜板湪榛樿鍘婚潤缃爢鍨涙満鐨勫紓甯稿彛璐т綅鍙� - task.CurrentAddress = input.Position; - task.TargetAddress = "002-021-000"; - task.NextAddress = "002-021-000"; - task.TaskState = (int)TaskInStatusEnum.Line_InFinish; - bool isResult = await BaseDal.UpdateDataAsync(task); - return content.OK(data: task); - } - else - { - var location = await GetLocationDistributeAsync(task.Roadway); - 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); - - // 寮�濮嬩簨鍔� - var isResult = await UpdateTaskAsync(task, location, beforeStatus); - if (!isResult) - { - _unitOfWorkManage.RollbackTran(); - return content.Error("鏇存柊浠诲姟澶辫触"); - } - - // 鎻愪氦浜嬪姟 - _unitOfWorkManage.CommitTran(); - return content.OK(data: task); + return new WebResponseContent().Error("浠诲姟瀵硅薄涓虹┖"); } + try + { + // 鍒涘缓WebResponseContent瀵硅薄 + var content = new WebResponseContent(); + + // 鑾峰彇鐩爣鍦板潃鍜屾洿鏂颁换鍔$姸鎬� + + input.Position = Regex.Replace(input.Position, @"-(\d+)", ""); + if (Convert.ToInt32(input.Position) > 1999) + { + input.Position = (Convert.ToInt32(input.Position) - 1000).ToString(); + } + + if (task.TaskType == (int)TaskInboundTypeEnum.InNG) + { + // TODO 鏍规嵁宸烽亾鏌ユ壘瀵瑰簲NG鍙o紝鐜板湪榛樿鍘婚潤缃爢鍨涙満鐨勫紓甯稿彛璐т綅鍙� + task.CurrentAddress = input.Position; + task.TargetAddress = "002-021-000"; + task.NextAddress = "002-021-000"; + task.TaskState = (int)TaskInStatusEnum.Line_InFinish; + bool isResult = await BaseDal.UpdateDataAsync(task); + return content.OK(data: task); + } + else if (task.TaskType == (int)TaskInboundTypeEnum.InQuality) + { + var stockInfo = await _stockInfoRepository.QueryFirstNavAsync(x => x.PalletCode == input.PalletCode); + task.CurrentAddress = input.Position; + task.TargetAddress = stockInfo.LocationInfo.LocationCode; + task.NextAddress = stockInfo.LocationInfo.LocationCode; + task.TaskState = (int)TaskInStatusEnum.Line_InFinish; + bool isResult = await BaseDal.UpdateDataAsync(task); + return content.OK(data: task); + } + else + { + var location = await GetLocationDistributeAsync(task.Roadway); + 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); + + // 寮�濮嬩簨鍔� + 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 ex) + catch (Exception) { - // 鍥炴粴浜嬪姟 - _unitOfWorkManage.RollbackTran(); - // 杩欓噷鍙互娣诲姞鏃ュ織璁板綍 - return new WebResponseContent().Error($"鏇存柊浠诲姟鏃跺彂鐢熼敊璇�: {ex.Message}"); + throw; } + finally { _semaphoreUpdate.Release(); } } private void MapTaskProperties(Dt_Task task, RequestTaskDto input, string toAddress, int taskState) @@ -1312,18 +2129,18 @@ /// 鍒涘缓鏂颁换鍔� /// </summary> /// <param name="input">璇锋眰妯″瀷</param> - /// <param name="areaId">鍖哄煙ID</param> - /// <param name="content">鍝嶅簲鍐呭</param> + /// <param name="process">宸烽亾</param> + /// <param name="flag">鏍囪瘑锛�0-鍏ュ簱锛�1-绌烘墭鐩樺叆搴擄紝2-NG鍏ュ簱锛�3-鍑哄簱锛�</param> /// <returns></returns> - private async Task<WebResponseContent> CreateNewTask(RequestTaskDto input, List<string> process = null, int flag = 0) + private async Task<WebResponseContent> CreateNewTask(RequestTaskDto input, string productionLine, string processCode, List<string> process = null, int flag = 0) { WebResponseContent content = new WebResponseContent(); // 鑾峰彇鐩爣鍦板潃 //string ToAddress = await GetRoadWayAsync(process); string ToAddress = string.Empty; - if (flag != 2) - ToAddress = await GetRoadWayAsync(input, process); + if (flag < 2) + ToAddress = await GetRoadWayAsync(process); else ToAddress = process[0]; @@ -1340,10 +2157,12 @@ OrderNo = null, PalletCode = input.PalletCode, SourceAddress = input.Position, - TaskState = (int)TaskInStatusEnum.InNew, - TaskType = flag == 0 ? (int)TaskInboundTypeEnum.Inbound : flag == 1 ? (int)TaskInboundTypeEnum.InTray : (int)TaskInboundTypeEnum.InNG, + TaskState = flag == 3 ? (int)TaskOutStatusEnum.OutNew : (int)TaskInStatusEnum.InNew, + TaskType = flag == 0 ? (int)TaskInboundTypeEnum.Inbound : flag == 1 ? (int)TaskInboundTypeEnum.InTray : flag == 2 ? (int)TaskInboundTypeEnum.InNG : (int)TaskOutboundTypeEnum.Outbound, TaskNum = await BaseDal.GetTaskNo(), - Creater = "Systeam" + Creater = "System", + ProductionLine = productionLine, + ProcessCode = processCode }; // 灏濊瘯娣诲姞鏂颁换鍔� @@ -1353,6 +2172,11 @@ { task.TaskId = taskId; isResult = await _taskExecuteDetailRepository.AddDetailAsync(task, false, TaskDescription.GetTaskUpdateDescription(input.PalletCode, input.Position, ToAddress, TaskInStatusEnum.InNew.GetIntegralRuleTypeEnumDesc())); + + //var location = _locationRepository.QueryFirst(x => x.RoadwayNo == task.Roadway && x.LocationCode == task.TargetAddress); + //location.LocationStatus = (int)LocationEnum.Lock; + //var isLocation = _locationRepository.UpdateData(location); + if (isResult) { // 鍒涘缓WMS浠诲姟 @@ -1367,6 +2191,7 @@ TaskState = task.TaskState.Value, Id = 0, TaskType = task.TaskType, + ProductionLine = task.ProductionLine }; content.OK(data: taskDTO); } @@ -1378,6 +2203,8 @@ return content; } + private static readonly SemaphoreSlim _semaphore = new SemaphoreSlim(1, 1); + /// <summary> /// 鏌ユ壘璐т綅 /// </summary> @@ -1388,16 +2215,17 @@ { #region 鑾峰彇璐т綅 + await _semaphore.WaitAsync(); try { List<DtLocationInfo> locations; if (IsFull) { - locations = await _locationRepository.QueryDataAsync(x => x.LocationStatus == (int)LocationEnum.Free && x.RoadwayNo == roadWay); + locations = await _locationRepository.QueryDataAsync(x => x.LocationStatus == (int)LocationEnum.Free && x.RoadwayNo == roadWay && x.EnalbeStatus == (int)EnableEnum.Enable); } else { - locations = await _locationRepository.QueryDataAsync(x => x.LocationStatus == (int)LocationEnum.Free && x.RoadwayNo == roadWay /*&& x.LocationType ==*/); + locations = await _locationRepository.QueryDataAsync(x => x.LocationStatus == (int)LocationEnum.Free && x.RoadwayNo == roadWay && x.EnalbeStatus == (int)EnableEnum.Enable); } if (locations == null) @@ -1412,32 +2240,43 @@ Console.WriteLine(err.Message.ToString()); return null; } + finally + { + _semaphore.Release(); + } #endregion 鑾峰彇璐т綅 } /// <summary> - /// 鑾峰彇宸烽亾鎴栫珯鍙� + /// 鏍规嵁宸烽亾鑾峰彇宸烽亾鎴栫珯鍙� /// </summary> - /// <param name="areaId">璐т綅鍖哄煙ID</param> - /// <param name="position">绔欏彴</param> - /// <param name="Direction">鏂瑰悜</param> - /// <param name="area">鍏崇郴鍖哄煙</param> /// <returns></returns> - public async Task<string> GetRoadWayAsync(RequestTaskDto input, List<string> process) + public async Task<string> GetRoadWayAsync(List<string> process) { - var minGroup = _locationRepository.QueryData(x => process.Contains(x.RoadwayNo) && x.LocationStatus == (int)LocationEnum.Free) + var deviceCode = await SqlSugarHelper.DbWCS.Queryable<Dt_DeviceInfo>() + .Where(x => x.DeviceStatus == 1.ToString() && process.Contains(x.DeviceCode)) + .Select(x => x.DeviceCode).ToListAsync(); + + var minGroup = _locationRepository.QueryData(x => deviceCode.Contains(x.RoadwayNo) && x.LocationStatus == (int)LocationEnum.Free) .GroupBy(x => x.RoadwayNo) .OrderByDescending(g => g.Count()) // 鏍规嵁姣忎釜缁勭殑鍏冪礌鏁伴噺鎺掑簭 - .First(); // 鍙栧嚭鏁伴噺鏈�澶氱殑缁� + .ToList(); // 鍙栧嚭鏁伴噺鏈�澶氱殑缁� - string minRoadwayNo = minGroup.Key; // 鏁伴噺鏈�澶氱殑缁勭殑Key + Dictionary<string, int> result = new Dictionary<string, int>(); + foreach (var item in minGroup) + { + var number = BaseDal.QueryData(x => x.TargetAddress == item.Key).Count(); + result.Add(item.Key, item.Count() - number); + } + + string minRoadwayNo = result.OrderByDescending(x => x.Value).FirstOrDefault().Key; // 鏁伴噺鏈�澶氱殑缁勭殑Key return minRoadwayNo; } /// <summary> - /// 鑾峰彇宸烽亾鎴栫珯鍙� + /// 鏍规嵁鍖哄煙鑾峰彇宸烽亾鎴栫珯鍙� /// </summary> /// <returns></returns> public async Task<string> GetRoadWayAsync(int areaCode) @@ -1445,13 +2284,103 @@ var minGroup = _locationRepository.QueryData(x => x.AreaId == areaCode && x.LocationStatus == (int)LocationEnum.Free) .GroupBy(x => x.RoadwayNo) .OrderBy(g => g.Count()) // 鏍规嵁姣忎釜缁勭殑鍏冪礌鏁伴噺鎺掑簭 - .First(); // 鍙栧嚭鏁伴噺鏈�灏戠殑缁� + .ToList(); // 鍙栧嚭鏁伴噺鏈�灏戠殑缁� - string minRoadwayNo = minGroup.Key; // 鏁伴噺鏈�灏戠殑缁勭殑Key + Dictionary<string, int> result = new Dictionary<string, int>(); + foreach (var item in minGroup) + { + var number = BaseDal.QueryData(x => x.TargetAddress == item.Key).Count(); + result.Add(item.Key, item.Count() - number); + } + + string minRoadwayNo = result.OrderByDescending(x => x.Value).FirstOrDefault().Key; // 鏁伴噺鏈�澶氱殑缁勭殑Key return minRoadwayNo; } + // 鏂扮殑鍑哄簱閿欒澶勭悊閫昏緫 + private async Task HandleOutBoundError(DtStockInfo stock, Dt_Task task) + { + WebResponseContent content = new WebResponseContent(); + var area = _areaInfoRepository.QueryFirst(x => x.AreaCode == stock.AreaCode); + if (area == null) + { + throw new Exception("鏈壘鍒板搴旂殑搴撳尯淇℃伅"); + } + + var trayCells = new TrayCellsStatusDto + { + Software = area.Spare3, + TrayBarcode = task.PalletCode, + EquipmentCode = area.Spare2, + SceneType = area.Spare4 + }; + + content = await _cellStateService.GetTrayCellStatusAsync(trayCells); + if (!content.Status) return; + + var ResultTray = JsonConvert.DeserializeObject<ResultTrayCellsStatus>(content.Data.ToString()); + if (ResultTray.SerialNos.Count > 0) + { + var parameterInfo = GetParameterInfo(stock); + + var outHours = CalculateOutHours(stock); + var isNG = outHours > parameterInfo.LowerSpecificationsLimit.ToDouble() + && outHours < parameterInfo.UpperSpecificationsLimit.ToDouble(); + + var defectCode = !isNG ? "TQCK" : string.Empty; + + var outputDto = CreateAgingOutputDto(area, stock, ResultTray, parameterInfo, outHours, defectCode); + content = await _agingInOrOutInputService.GetOCVOutputAsync(outputDto); + + var result = JsonConvert.DeserializeObject<BasicResult>(content.Data.ToString()); + if (!result.Success) + task.Remark = "NG"; + } + } + + // 璁$畻鍑哄簱灏忔椂鐨勬柟娉� + private double CalculateOutHours(DtStockInfo stock) => + (DateTime.Now - Convert.ToDateTime(stock.LinedProcessFeedbackTime ?? stock.CreateDate.ToString())).TotalHours; + + // 鐢熸垚 AgingOutputDto 鐨勫皝瑁呮柟娉� + private AgingOutputDto CreateAgingOutputDto(Dt_AreaInfo area, DtStockInfo stock, ResultTrayCellsStatus resultTray, + ParameterInfo parameterInfo, double outHours, string defectCode) + { + return new AgingOutputDto + { + OpFlag = 1, + Software = area.Spare3, + EquipmentCode = area.Spare2, + TrayBarcode = stock.PalletCode, + SerialNos = resultTray.SerialNos.Select(x => new SerialNoOutDto + { + SlotNo = x.PositionNo, + SerialNo = x.SerialNo, + SerialNoResult = true, + ParameterInfo = new List<ParameterInfoOutput> + { + new ParameterInfoOutput + { + Value = outHours.ToString(), + ParameterCode = parameterInfo.ParameterCode, + ParameterDesc = parameterInfo.Description, + ParameterResult = "OK", + TargetValue = parameterInfo.TargetValue, + LowerLimit = parameterInfo.LowerSpecificationsLimit, + UpperLimit = parameterInfo.UpperSpecificationsLimit, + DefectCode = defectCode, + } + } + }).ToList() + }; + } + + // 鑾峰彇鍙傛暟淇℃伅鐨勮緟鍔╂柟娉� + private ParameterInfo GetParameterInfo(DtStockInfo stock) => + JsonConvert.DeserializeObject<List<ParameterInfo>>(stock.ParameterInfos) + .FirstOrDefault(y => y.Description.Contains("鏃堕棿")); + #endregion 浠诲姟璇锋眰鏂规硶 #endregion private 鍐呴儴鏂规硶 -- Gitblit v1.9.3