From 36343b85b0c883ebfdf3c17b173f263fd2bfcb93 Mon Sep 17 00:00:00 2001 From: 陈勇 <chenyong@hnkhzn.com> Date: 星期二, 19 十一月 2024 10:25:53 +0800 Subject: [PATCH] 合并 --- Code Management/WMS/WIDESEA_WMSServer/WIDESEA_StorageTaskServices/Task/Dt_TaskService.cs | 443 +++++++++++++++++++++++++++++++++++-------------------- 1 files changed, 281 insertions(+), 162 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 5901b8a..73feaf9 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,6 +1,7 @@ 锘縰sing log4net.Core; using Mapster; using Masuit.Tools; +using Masuit.Tools.Models; using WIDESEA_DTO.MOM; using WIDESEA_DTO.WMS; using WIDESEA_IStorageBasicRepository; @@ -34,6 +35,7 @@ private readonly IProcessApplyService _processApplyService; //宸ヨ壓璺嚎 private readonly IDt_AreaInfoRepository _areaInfoRepository; //鍖哄煙 private readonly IAgingInOrOutInputService _agingInOrOutInputService; //闈欑疆\闄堝寲 + private readonly IProductionRepository _productionRepository; //鐢熶骇 public Dt_TaskService(IDt_TaskRepository BaseDal, IUnitOfWorkManage unitOfWorkManage, @@ -54,7 +56,8 @@ IProcessApplyService processApplyService, IDt_AreaInfoRepository areaInfoRepository, IAgingInOrOutInputService agingInOrOutInputService, - IStockInfoDetailRepository stockInfoDetailRepository) : base(BaseDal) + IStockInfoDetailRepository stockInfoDetailRepository, + IProductionRepository productionRepository) : base(BaseDal) { _unitOfWorkManage = unitOfWorkManage; _outOrderRepository = outOrderRepository; @@ -75,111 +78,13 @@ _areaInfoRepository = areaInfoRepository; _agingInOrOutInputService = agingInOrOutInputService; _stockInfoDetailRepository = stockInfoDetailRepository; + _productionRepository = productionRepository; } #region 澶栭儴鎺ュ彛鏂规硶 #region 鍑哄簱浠诲姟瀹屾垚 - /// <summary> - /// 鍑哄簱浠诲姟瀹屾垚 - /// </summary> - /// <param name="saveModel">浠诲姟鏁版嵁鍚堥泦</param> - /// <returns>杩斿洖缁撴灉闆�</returns> - //public async Task<WebResponseContent> CompleteStackTaskAsync(Dt_Task task, DtStockInfo stock) - //{ - // WebResponseContent content = new WebResponseContent(); - // try - // { - // if (task.TaskType == (int)TaskOutboundTypeEnum.Outbound) - // { - // var process = await SqlSugarHelper.Db.Queryable<Dt_EquipmentProcess>() - // .FirstAsync(x => x.EquipmentName == task.Roadway); - // EquipmentParameterInfo info = JsonConvert.DeserializeObject<EquipmentParameterInfo>(process.ProcessValue); - // AgingOutputDto agingOutputDto = new AgingOutputDto() - // { - // OpFlag = 1, - // EquipmentCode = stock.LocationInfo.RoadwayNo, - // TrayBarcode = stock.PalletCode, - // SerialNos = stock.StockInfoDetails.Select(x => new SerialNoOutDto() - // { - // SlotNo = x.OrderNo.ToInt32(), - // SerialNo = x.SerialNumber, - // SerialNoResult = true, - // ParameterInfo = new List<ParameterInfo>() - // { - // new ParameterInfo() - // { - // LowerLomit =info.LowerControlLimit, - // UpperLimit = info.UpperControlLimit, - // ParameterResult = info.EquipmentAvailabilityFlag, - // ParameterCode = info.ParameterCode, - // ParameterDesc = info.Description, - // TargetValue = info.TargetValue, - // Value = info.TargetValue, - // DefectCode = info.UOMCode - // } - // } - // }).ToList() - // }; - // content = await _agingInOrOutInputService.GetOCVOutputAsync(agingOutputDto); - // var result = JsonConvert.DeserializeObject<BasicResult>(content.ToString()); - // if (!result.Success) - // { - // throw new Exception(result.MOMMessage); - // } - // } - // // 鏇存柊搴撳瓨鐘舵�� - // var loation = _locationRepository.QueryFirst(x => x.LocationCode == task.SourceAddress); - // var detail = _stockInfoDetailRepository.QueryData(x => x.StockId == stock.Id); - - // // 璁剧疆搴撲綅鐘舵�佷负绌洪棽 - // loation.LocationStatus = LocationEnum.Free.ObjToInt(); - - // // 鏇存柊浠诲姟鐘舵�� - // task.TaskState = TaskOutStatusEnum.OutFinish.ObjToInt(); - // task.CurrentAddress = task.NextAddress; - // task.NextAddress = task.TargetAddress; - - // LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, "鍫嗗灈鏈哄嚭搴撳畬鎴�", "鏇存柊搴撳瓨鐘舵�佷笌浠诲姟鐘舵��"); - - // // 浜嬪姟澶勭悊 - // // 寮�濮嬩簨鍔� - // _unitOfWorkManage.BeginTran(); - // // 鍒犻櫎搴撳瓨淇℃伅 - // var isStockUpdated = _stockInfoRepository.DeleteDataById(stock.Id); - // // 鍒犻櫎搴撳瓨淇℃伅 - // var isStockDetailUpdated = _stockInfoDetailRepository.DeleteDataByIds(detail.Select(x => (object)x.Id).ToArray()); - // // 鍒犻櫎浠诲姟淇℃伅 - // var isTaskUpdated = BaseDal.DeleteDataById(task.TaskId); - - // // 濡傛灉搴撳瓨淇℃伅鍜屼换鍔′俊鎭兘鏇存柊鎴愬姛 - // if (isStockUpdated && isTaskUpdated && isStockDetailUpdated) - // { - // // 璁板綍鏃ュ織 - // LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, "鍫嗗灈鏈哄嚭搴撳畬鎴�", $"浜嬪姟澶勭悊瀹屾垚锛屽簱瀛樼姸鎬佹洿鏂帮細{isStockUpdated}锛屼换鍔$姸鎬佹洿鏂�:{isTaskUpdated}"); - // // 鎻愪氦浜嬪姟 - // _unitOfWorkManage.CommitTran(); - // // 杩斿洖鎴愬姛缁撴灉 - // return content.OK("浠诲姟瀹屾垚鎴愬姛"); - // } - // else - // { - // // 璁板綍鏃ュ織 - // LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, "鍫嗗灈鏈哄嚭搴撳畬鎴�", $"浜嬪姟澶勭悊澶辫触锛屽簱瀛樼姸鎬佹洿鏂帮細{isStockUpdated}锛屼换鍔$姸鎬佹洿鏂�:{isTaskUpdated}"); - // // 鍥炴粴浜嬪姟 - // _unitOfWorkManage.RollbackTran(); - // // 杩斿洖澶辫触缁撴灉 - // return content.Error("浠诲姟鎴栧簱瀛樻洿鏂板け璐�"); - // } - // } - // catch (Exception err) - // { - // LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, $"绯荤粺寮傚父锛屽紓甯镐俊鎭細{err.Message}", ""); - // Console.WriteLine(err.Message); - // return content.Error(err.Message); - // } - //} public async Task<WebResponseContent> CompleteStackTaskAsync(Dt_Task task, DtStockInfo stock) { @@ -190,7 +95,7 @@ { var process = await SqlSugarHelper.Db.Queryable<Dt_EquipmentProcess>() .FirstAsync(x => x.EquipmentName == task.Roadway); - var info = JsonConvert.DeserializeObject<List<EquipmentParameterInfo>>(process.ProcessValue); + var info = JsonConvert.DeserializeObject<ResponseEqptRunDto>(process.ProcessValue); var agingOutputDto = MapToAgingOutputDto(stock, info); content = await _agingInOrOutInputService.GetOCVOutputAsync(agingOutputDto); @@ -206,7 +111,7 @@ await UpdateLocationAsync(loc); await DeleteStockInfoAsync(stock.Id); await DeleteStockInfoDetailsAsync(stock.StockInfoDetails); - await DeleteTaskAsync(task.TaskId); + //await DeleteTaskAsync(task.TaskId); }); return content.OK("浠诲姟瀹屾垚鎴愬姛"); @@ -218,28 +123,30 @@ } } - private AgingOutputDto MapToAgingOutputDto(DtStockInfo stock, List<EquipmentParameterInfo> info) + private AgingOutputDto MapToAgingOutputDto(DtStockInfo stock, ResponseEqptRunDto info) { + // TODO Value鍊兼牴鎹甅OM涓嬪彂鐨勯潤缃椂闂村埌褰撳墠鏃堕棿鐨勫垎閽熸暟 return new AgingOutputDto { OpFlag = 1, - EquipmentCode = stock.LocationInfo.RoadwayNo, + Software = "WMS", + EquipmentCode = "ECH001-B", TrayBarcode = stock.PalletCode, SerialNos = stock.StockInfoDetails.Select(x => new SerialNoOutDto { SlotNo = x.OrderNo.ToInt32(), SerialNo = x.SerialNumber, SerialNoResult = true, - ParameterInfo = info.Select(x => new ParameterInfo() + ParameterInfo = info.ParameterInfo.Select(y => new ParameterInfo() { - LowerLomit = x.LowerControlLimit, - UpperLimit = x.UpperControlLimit, - ParameterResult = x.EquipmentAvailabilityFlag, - ParameterCode = x.ParameterCode, - ParameterDesc = x.Description, - TargetValue = x.TargetValue, - Value = (DateTime.Now - stock.CreateDate).TotalMinutes.ToString(), - DefectCode = x.UOMCode + LowerLomit = y.LowerControlLimit, + UpperLimit = y.UpperControlLimit, + ParameterResult = y.EquipmentAvailabilityFlag, + ParameterCode = y.ParameterCode, + ParameterDesc = y.Description, + TargetValue = y.TargetValue, + Value = (DateTime.Parse(stock.LinedProcessFeedbackTime, null, System.Globalization.DateTimeStyles.RoundtripKind).ToLocalTime() - stock.CreateDate).TotalMinutes.ToString(), + DefectCode = y.UOMCode }).ToList() }).ToList() }; @@ -247,7 +154,7 @@ private void ValidateResponse(WebResponseContent content) { - var result = JsonConvert.DeserializeObject<BasicResult>(content.ToString()); + var result = JsonConvert.DeserializeObject<BasicResult>(content.Data.ToString()); if (!result.Success) { throw new Exception(result.MOMMessage); @@ -259,10 +166,10 @@ var location = _locationRepository.QueryFirst(x => x.LocationCode == task.SourceAddress); var details = _stockInfoDetailRepository.QueryData(x => x.StockId == stock.Id); - location.LocationStatus = LocationEnum.Free.ObjToInt(); - task.TaskState = TaskOutStatusEnum.OutFinish.ObjToInt(); - task.CurrentAddress = task.NextAddress; - task.NextAddress = task.TargetAddress; + location.LocationStatus = (int)LocationEnum.Free; + task.TaskState = (int)TaskOutStatusEnum.OutFinish; + //task.CurrentAddress = task.NextAddress; + //task.NextAddress = task.TargetAddress; LogFactory.GetLog("浠诲姟瀹屾垚").Info(true, "鏇存柊搴撳瓨鐘舵�佷笌浠诲姟鐘舵��"); return (location, task); @@ -347,6 +254,91 @@ /// </summary> /// <param name="task">浠诲姟鏁版嵁鍚堥泦</param> /// <returns>杩斿洖缁撴灉闆�</returns> + //public async Task<WebResponseContent> CompleteInboundTaskAsync(Dt_Task task) + //{ + // WebResponseContent content = new WebResponseContent(); + // try + // { + // var boxing = await _boxingInfoRepository.QueryFirstNavAsync(x => x.PalletCode == task.PalletCode); + // var locationInf = await _locationRepository.QueryFirstAsync(x => x.LocationCode == task.TargetAddress); + + // locationInf.LocationStatus = (int)LocationEnum.InStock; + + // // 鍒涘缓鍘嗗彶浠诲姟瀹炰緥妯″瀷 + // var taskHty = CreateHistoricalTask(task); + + // // 鍒涘缓搴撳瓨瀹炰緥妯″瀷 + // DtStockInfo stock; + // if (boxing == null) + // { + // // 绌烘墭鐩� + + // stock = new DtStockInfo() + // { + // PalletCode = task.PalletCode, + // LocationCode = task.TargetAddress, + // CreateDate = DateTime.Now, + // Creater = "system", + // IsFull = boxing.IsFull, + // StockInfoDetails = new List<DtStockInfoDetail>() + // { + // new DtStockInfoDetail() + // { + // MaterielCode = "绌烘墭鐩�", + // Id = 0, + // } + // } + // }; + // } + // else + // { + // // 瀹炵洏 + // var boxDetail = boxing.BoxingInfoDetails.Adapt<List<DtStockInfoDetail>>(); + // // 鍒涘缓搴撳瓨瀹炰緥妯″瀷 + // stock = new DtStockInfo() + // { + // PalletCode = task.PalletCode, + // LocationCode = task.TargetAddress, + // CreateDate = DateTime.Now, + // Creater = "system", + // IsFull = boxing.IsFull, + // StockInfoDetails = boxDetail, + // }; + + // AgingInputDto agingInputDto = new AgingInputDto() + // { + // SerialNos = boxing.BoxingInfoDetails + // .Select(item => new SerialNoInDto { SerialNo = item.SerialNumber, PositionNo = item.OrderNo }) + // .ToList(), + // TrayBarcode = task.PalletCode, + // OpFlag = 1 + // }; + // var result = await _agingInOrOutInputService.GetOCVInputAsync(agingInputDto); + // stock.Remark = JsonConvert.DeserializeObject<ResponeAgingInputDto>(result.Data.ToString()).LinedProcessFeedbackTime; + + // LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, "鍏ュ簱浠诲姟瀹屾垚", $"璐т綅鍦板潃锛歿task.TargetAddress},淇敼鍚庤揣浣嶆暟鎹細{locationInf}"); + + // } + + // // 鎵ц鏁版嵁搴撲簨鍔� + // bool isResult = await ExecuteTransaction(stock, taskHty, locationInf, task.TaskId); + // if (isResult) + // content.OK("鍏ュ簱浠诲姟瀹屾垚鎴愬姛"); + // else + // content.Error("鍏ュ簱浠诲姟瀹屾垚澶辫触"); + // } + // catch (Exception err) + // { + // Console.WriteLine(err.Message.ToString()); + // } + // return content; + //} + + /// <summary> + /// 瀹屾垚鍏ュ簱浠诲姟 + /// </summary> + /// <param name="task">浠诲姟鏁版嵁鍚堥泦</param> + /// <returns>杩斿洖缁撴灉闆�</returns> public async Task<WebResponseContent> CompleteInboundTaskAsync(Dt_Task task) { // 鍒濆鍖栧搷搴斿唴瀹� @@ -405,6 +397,7 @@ { MaterielCode = "绌烘墭鐩�", Id = 0, + Status = (int)StockStateEmun.宸插叆搴� } } }; @@ -416,6 +409,7 @@ private DtStockInfo CreateFullPalletStock(Dt_Task task, DtLocationInfo locationInf, DtBoxingInfo boxing) { var boxDetail = boxing.BoxingInfoDetails.Adapt<List<DtStockInfoDetail>>(); + boxDetail.ForEach(x => { x.Status = (int)StockStateEmun.宸插叆搴�; }); var stock = new DtStockInfo() { PalletCode = task.PalletCode, @@ -440,7 +434,10 @@ }; var result = _agingInOrOutInputService.GetOCVInputAsync(agingInputDto).Result; var respone = JsonConvert.DeserializeObject<ResponeAgingInputDto>(result.Data.ToString()); - stock.Remark = respone.LinedProcessFeedbackTime; + stock.LinedProcessFeedbackTime = respone.LinedProcessFeedbackTime; + stock.SpecialParameterDuration = respone.SpecialParameterDuration; + //2024骞�11鏈�16鏃ワ細鏂板瀛楁璁$畻搴斿嚭搴撴椂闂� + stock.OutboundTime = Convert.ToDateTime(respone.LinedProcessFeedbackTime).AddHours(Convert.ToDouble(respone.SpecialParameterDuration)); // 璁板綍鏃ュ織 LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, "鍏ュ簱浠诲姟瀹屾垚", $"璐т綅鍦板潃锛歿task.TargetAddress},淇敼鍚庤揣浣嶆暟鎹細{locationInf}"); @@ -474,7 +471,7 @@ LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, "楠岃瘉浠诲姟鏄惁瀛樺湪", JsonConvert.SerializeObject(task)); // 楠岃瘉搴撳瓨鏄惁瀛樺湪 - var stock = await _stockInfoRepository.QueryFirstAsync(x => x.PalletCode == task.PalletCode); + var stock = await _stockInfoRepository.QueryFirstNavAsync(x => x.PalletCode == task.PalletCode); // 鏍规嵁浠诲姟绫诲瀷璋冪敤鐩稿簲鐨勫畬鎴愪换鍔℃柟娉� switch (task.TaskType) @@ -499,7 +496,7 @@ #region 璇锋眰浠诲姟鍏ュ簱 /// <summary> - /// 璇锋眰浠诲姟 + /// 璇锋眰浠诲姟宸烽亾 /// </summary> /// <param name="input">璇锋眰妯″瀷</param> /// <returns>鍖呭惈浠诲姟淇℃伅鐨勫搷搴斿唴瀹�</returns> @@ -514,7 +511,7 @@ var task = await BaseDal.QueryFirstAsync(x => x.PalletCode == input.PalletCode); if (task != null) { - if (task.TaskState == (int)TaskInStatusEnum.InNew) + //if (task.TaskState == (int)TaskInStatusEnum.InNew) { // 鍒涘缓WMS浠诲姟 WMSTaskDTO taskDTO = new WMSTaskDTO() @@ -531,14 +528,13 @@ }; return content.OK(data: taskDTO); } - content = await UpdateExistingTask(input, task); - return content; } // 鍒涘缓涓�涓猅rayCellsStatusDto瀵硅薄锛屽苟璧嬪�� TrayCellsStatusDto trayCells = new TrayCellsStatusDto() { Software = "WMS", TrayBarcode = input.PalletCode, + //EquipmentCode = "EQ_CWJZ01" EquipmentCode = "ECH001-B" }; @@ -552,7 +548,16 @@ var result = JsonConvert.DeserializeObject<ResultTrayCellsStatus>(content.Data.ToString()); if (result.SerialNos.Count <= 0) return content.Error(result.MOMMessage); + + // 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); @@ -560,11 +565,18 @@ // 濡傛灉process涓簄ull锛屽垯杩斿洖content if (process == null) return content; - // 璋冪敤GetProcessResponseAsync鏂规硶锛岃幏鍙栧伐鑹哄搷搴� - var processResponse = await GetProcessResponseAsync(process, input.Position); + // 璋冪敤_processApplyService.GetProcessApplyAsync鏂规硶锛岃幏鍙栧伐鑹虹敵璇� + content = await _processApplyService.GetProcessApplyAsync(process); - // 濡傛灉task涓嶄负null锛屽垯璋冪敤UpdateExistingTask鏂规硶锛屾洿鏂颁换鍔★紱鍚﹀垯璋冪敤CreateNewTask鏂规硶锛屽垱寤烘柊浠诲姟 - content = task != null ? await UpdateExistingTask(input, task) : await CreateNewTask(input, processResponse); + // 濡傛灉鐘舵�佷负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) { var isBox = await _boxingInfoRepository.AddDataNavAsync(boxing); @@ -581,6 +593,35 @@ return content; } + /// <summary> + /// 鏇存柊浠诲姟璐т綅 + /// </summary> + /// <param name="input"></param> + /// <returns></returns> + public async Task<WebResponseContent> 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) + { + + throw; + } + } + + /// <summary> + /// 绌烘墭鐩樺叆搴撶敵璇� + /// </summary> + /// <param name="input"></param> + /// <returns></returns> public async Task<WebResponseContent> RequestTrayInTaskAsync(RequestTaskDto input) { WebResponseContent content = new WebResponseContent(); @@ -607,7 +648,11 @@ return content.OK(data: task); } - return await CreateNewTask(input, null, 1); + // 鑾峰彇鐩爣鍦板潃 + List<string> strings = input.Position == "1016" ? new List<string>() { "CHSC01" } : new List<string>() { "JZSC01" }; + + return await CreateNewTask(input, strings, 1); + //return await CreateNewTask(input, null, 1); } catch (Exception) { @@ -635,7 +680,7 @@ SerialNumber = serialNoObj.SerialNo, OrderNo = serialNoObj.PositionNo.ToString(), Status = serialNoObj.SerialNoStatus, - MaterielCode = serialNoObj.BindCode, + MaterielCode = result.BindCode, Remark = result.TrayBarcodePropertys.ToJsonString(), }).ToList() }; @@ -708,12 +753,20 @@ { // 鏍规嵁鎵樼洏绫诲瀷鏌ヨ搴撳瓨淇℃伅 DtStockInfo stockInfo = tag == (int)TaskOutboundTypeEnum.Outbound - ? QueryStockInfoForRealTray(areaCode, roadways) - : QueryStockInfoForEmptyTray(areaCode, roadways); + ? QueryStockInfoForRealTrayAsync(areaCode, roadways).Result + : QueryStockInfoForEmptyTrayAsync(areaCode, roadways).Result; if (stockInfo == null) { return content.Error("搴撳瓨淇℃伅涓嶅瓨鍦�"); + } + + // 鏂板閲嶅浠诲姟鏍¢獙 + var hasTask = BaseDal.QueryFirst(x => x.PalletCode == stockInfo.PalletCode); + if (hasTask != null) + { + WMSTaskDTO taskDTO1 = CreateTaskDTO(hasTask); + return content.OK("宸插瓨鍦ㄧ┖鐩樺嚭搴撲换鍔�", data: taskDTO1); } // 鍒涘缓鏂颁换鍔″疄渚� @@ -748,25 +801,38 @@ /// <summary> /// 鏌ヨ瀹炵洏搴撳瓨淇℃伅 /// </summary> - private DtStockInfo QueryStockInfoForRealTray(string areaCode, List<string> roadways) + private async Task<DtStockInfo> QueryStockInfoForRealTrayAsync(string areaCode, List<string> roadways) { - return _stockInfoRepository.Db.Queryable<DtStockInfo>().Where(x => x.AreaCode == areaCode && Convert.ToDateTime(x.Remark) < DateTime.Now && x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && roadways.Contains(x.LocationInfo.RoadwayNo)) - .Includes(x => x.LocationInfo) - .Includes(x => x.StockInfoDetails) - .OrderBy(x => x.CreateDate) - .First(); + // TODO鏃堕棿鏍规嵁MOM绯荤粺閰嶇疆鐨勫嚭搴撴椂闂存潵鑾峰彇,鏆傛椂涓嶇煡閬揗OM杩斿洖鐨勬椂闂存槸浠�涔堟墍浠ヨ繖閲屾祴璇曟椂鍊欏湪鏀� + //return _stockInfoRepository.QueryFirstNavAsync(x => x.AreaCode == areaCode && Convert.ToDateTime(x.LinedProcessFeedbackTime).AddHours(Convert.ToDouble(x.SpecialParameterDuration)) < DateTime.Now + // && x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && roadways.Contains(x.LocationInfo.RoadwayNo) && x.StockInfoDetails.Any(x => x.Status == (int)StockStateEmun.宸插叆搴�) && x.LocationInfo.LocationStatus == (int)LocationEnum.InStock).Result; + + var result = await _stockInfoRepository.Db.Queryable<DtStockInfo>().Where(x => + x.AreaCode == areaCode && + Convert.ToDateTime(x.LinedProcessFeedbackTime).AddHours(Convert.ToDouble(x.SpecialParameterDuration)) < DateTime.Now) + .Includes(x => x.LocationInfo) + .Where(x => x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && roadways.Contains(x.LocationInfo.RoadwayNo)) + .Includes(x => x.StockInfoDetails) + .Where(x => x.StockInfoDetails.Any(detail => detail.Status == (int)StockStateEmun.宸插叆搴�)) + .OrderBy(x => x.CreateDate) + .FirstAsync(); + return result; } /// <summary> /// 鏌ヨ绌虹洏搴撳瓨淇℃伅 /// </summary> - private DtStockInfo QueryStockInfoForEmptyTray(string areaCode, List<string> roadways) + private async Task<DtStockInfo> QueryStockInfoForEmptyTrayAsync(string areaCode, List<string> roadways) { - return _stockInfoRepository.Db.Queryable<DtStockInfo>().Where(x => x.AreaCode == areaCode && x.StockInfoDetails.Any(z => z.MaterielCode == "绌烘墭鐩�") && roadways.Contains(x.LocationInfo.RoadwayNo)) - .Includes(x => x.LocationInfo) - .Includes(x => x.StockInfoDetails) - .OrderBy(x => x.CreateDate) - .First(); + //return _stockInfoRepository.QueryFirstNavAsync(x => x.StockInfoDetails.Any(x => x.MaterielCode == "绌烘墭鐩�") && roadways.Contains(x.LocationInfo.RoadwayNo) && x.StockInfoDetails.Any(x => x.Status == (int)StockStateEmun.宸插叆搴�) && x.LocationInfo.LocationStatus == (int)LocationEnum.InStock).Result; + var result = await _stockInfoRepository.Db.Queryable<DtStockInfo>() + .Includes(x => x.LocationInfo) + .Where(x => x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && roadways.Contains(x.LocationInfo.RoadwayNo)) + .Includes(x => x.StockInfoDetails) + .Where(x => x.StockInfoDetails.Any(detail => detail.Status == (int)StockStateEmun.宸插叆搴� && detail.MaterielCode == "绌烘墭鐩�")) + .OrderBy(x => x.CreateDate) + .FirstAsync(); + return result; } /// <summary> @@ -816,6 +882,12 @@ #region 浠诲姟鐘舵�佹洿鏀� + /// <summary> + /// 鏇存柊浠诲姟鐘舵��&鍑哄簱瑙g洏 + /// </summary> + /// <param name="taskNum"></param> + /// <param name="taskState"></param> + /// <returns></returns> public async Task<WebResponseContent> UpdateTaskStatus(int taskNum, int taskState) { WebResponseContent content = new WebResponseContent(); @@ -824,12 +896,57 @@ var task = await BaseDal.QueryFirstAsync(x => x.TaskNum == taskNum); if (task == null) return content.Error("鏈壘鍒颁换鍔�"); - task.TaskState = taskState; - var asb = await BaseDal.UpdateDataAsync(task); - if (asb) + + if (taskState == (int)TaskOutStatusEnum.Line_OutFinish) + { + 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 - content.Error(); + { + 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 鍑哄簱瑙g洏 + + /// <summary> + /// 鍑哄簱瑙g洏鎺ュ彛 + /// </summary> + /// <param name="taskNum"></param> + /// <returns></returns> + public async Task<WebResponseContent> OutUnblockInterface(int taskNum) + { + 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); } catch (Exception ex) { @@ -1204,20 +1321,13 @@ /// <param name="areaId">鍖哄煙ID</param> /// <param name="content">鍝嶅簲鍐呭</param> /// <returns></returns> - private async Task<WebResponseContent> CreateNewTask(RequestTaskDto input, List<Dt_EquipmentProcess> process = null, int flag = 0) + private async Task<WebResponseContent> CreateNewTask(RequestTaskDto input, List<string> process = null, int flag = 0) { WebResponseContent content = new WebResponseContent(); - List<string> strings = new List<string>(); - if (process != null) - { - strings = process.Select(x => x.EquipmentName).ToList(); - } - else - { - strings = input.Position.Split(',').ToList(); - } + // 鑾峰彇鐩爣鍦板潃 - string ToAddress = await GetRoadWayAsync(strings); + //string ToAddress = await GetRoadWayAsync(process); + string ToAddress = await GetRoadWayAsync(input, process); // 鍒涘缓鏂颁换鍔″疄渚� var task = new Dt_Task @@ -1276,13 +1386,22 @@ /// <param name="areaId">鍖哄煙涓婚敭</param> /// <param name="roadWay">宸烽亾</param> /// <returns></returns> - public async Task<DtLocationInfo> GetLocationDistributeAsync(string roadWay) + public async Task<DtLocationInfo> GetLocationDistributeAsync(string roadWay, bool IsFull = true) { #region 鑾峰彇璐т綅 try { - var locations = await _locationRepository.QueryDataAsync(x => x.LocationStatus == (int)LocationEnum.Free && x.RoadwayNo == roadWay); + List<DtLocationInfo> locations; + if (IsFull) + { + locations = await _locationRepository.QueryDataAsync(x => x.LocationStatus == (int)LocationEnum.Free && x.RoadwayNo == roadWay); + } + else + { + locations = await _locationRepository.QueryDataAsync(x => x.LocationStatus == (int)LocationEnum.Free && x.RoadwayNo == roadWay); + } + if (locations == null) { return null; @@ -1307,7 +1426,7 @@ /// <param name="Direction">鏂瑰悜</param> /// <param name="area">鍏崇郴鍖哄煙</param> /// <returns></returns> - public async Task<string> GetRoadWayAsync(List<string> process) + public async Task<string> GetRoadWayAsync(RequestTaskDto input, List<string> process) { var minGroup = _locationRepository.QueryData(x => process.Contains(x.RoadwayNo) && x.LocationStatus == (int)LocationEnum.Free) .GroupBy(x => x.RoadwayNo) -- Gitblit v1.9.3