From 15be9cdba09e832452983ad3badf7e6cbefae57d Mon Sep 17 00:00:00 2001
From: xxyy <cathay_xy@163.com>
Date: 星期五, 07 三月 2025 15:08:29 +0800
Subject: [PATCH] 增强业务扩展能力和错误处理逻辑

---
 Code Management/WMS/WIDESEA_WMSServer/WIDESEA_StorageTaskServices/Task/Dt_TaskService.cs |  461 ++++++++++++++++++++++++++++++--------------------------
 1 files changed, 246 insertions(+), 215 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 5499743..9f34503 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,7 +1,8 @@
-锘縰sing Autofac.Core;
-using Mapster;
+锘縰sing Mapster;
 using Masuit.Tools;
+using SqlSugar;
 using System.Text.RegularExpressions;
+using WIDESEA_Cache;
 using WIDESEA_Core.Const;
 using WIDESEA_DTO.MOM;
 using WIDESEA_DTO.WMS;
@@ -9,7 +10,6 @@
 using WIDESEA_IStoragIntegrationServices;
 using WIDESEAWCS_BasicInfoRepository;
 using WIDESEAWCS_QuartzJob.Models;
-
 
 namespace WIDESEA_StorageTaskServices;
 
@@ -31,6 +31,7 @@
     private readonly IAgingInOrOutInputService _agingInOrOutInputService; //闈欑疆\闄堝寲
     private readonly IDt_StationManagerRepository _stationManagerRepository;
     private readonly ISys_ConfigService _configService;
+    private readonly ISimpleCacheService _simpleCacheService;
 
     public Dt_TaskService(IDt_TaskRepository BaseDal,
                                 IUnitOfWorkManage unitOfWorkManage,
@@ -48,7 +49,8 @@
                                 IAgingInOrOutInputService agingInOrOutInputService,
                                 IStockInfoDetailRepository stockInfoDetailRepository,
                                 IDt_StationManagerRepository stationManagerRepository,
-                                ISys_ConfigService configService) : base(BaseDal)
+                                ISys_ConfigService configService,
+                                ISimpleCacheService simpleCacheService) : base(BaseDal)
     {
         _unitOfWorkManage = unitOfWorkManage;
         _stockInfoRepository = stockInfoRepository;
@@ -65,6 +67,7 @@
         _stockInfoDetailRepository = stockInfoDetailRepository;
         _stationManagerRepository = stationManagerRepository;
         _configService = configService;
+        _simpleCacheService = simpleCacheService;
     }
 
     #region 澶栭儴鎺ュ彛鏂规硶
@@ -78,86 +81,6 @@
         {
             if (task.TaskType == (int)TaskOutboundTypeEnum.Outbound)
             {
-                #region 鑰佺増鏈�
-                //var process = await SqlSugarHelper.Db.Queryable<Dt_EquipmentProcess>()
-                //    .FirstAsync(x => x.EquipmentName == task.Roadway);
-                //var info = JsonConvert.DeserializeObject<ResponseEqptRunDto>(process.ProcessValue);
-                //if (!task.Roadway.Contains("FR") && stock.ProcessCode != "OCVB")  //闈炲垎瀹瑰簱鍖轰笌褰撳墠宸ュ簭鏄疧CVB鍧囦笂鎶OM鍑哄叆绔�
-                //{
-                //    var agingOutputDto = MapToAgingOutputDto(stock);
-                //    content = await _agingInOrOutInputService.GetOCVOutputAsync(agingOutputDto);
-                //    //ValidateResponse(content);
-                //    var result = JsonConvert.DeserializeObject<BasicResult>(content.Data.ToString());
-                //    if (!result.Success || !agingOutputDto.SerialNos[0].SerialNoResult)
-                //    {
-                //        if (result.MessageCode == "E10001")
-                //        {
-                //            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 content;
-
-                //            var ResultTray = JsonConvert.DeserializeObject<ResultTrayCellsStatus>(content.Data.ToString());
-                //            if (ResultTray.SerialNos.Count > 0)
-                //            {
-                //                var parameterInfo = JsonConvert.DeserializeObject<List<ParameterInfo>>(stock.ParameterInfos).FirstOrDefault(y => y.Description.Contains("鏃堕棿"));
-                //                if (parameterInfo == null) throw new Exception("");
-
-                //                var outHours = (DateTime.Now - (stock.LinedProcessFeedbackTime == null ? stock.CreateDate : stock.LinedProcessFeedbackTime.ToDateTime())).TotalHours;
-
-                //                var isNG = outHours > parameterInfo.LowerSpecificationsLimit.ToDouble() && outHours < parameterInfo.UpperSpecificationsLimit.ToDouble();
-
-                //                var defectCode = string.Empty;
-                //                if (!isNG) defectCode = "TQCK";
-                //                var outputDto = 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, //isNG,
-                //                        ParameterInfo = new List<ParameterInfoOutput> {
-                //                            new ParameterInfoOutput() {
-                //                                Value = outHours.ToString(),
-                //                                ParameterCode =parameterInfo.ParameterCode,
-                //                                ParameterDesc = parameterInfo.Description,
-                //                                ParameterResult  = "OK", //isNG.ToString(),
-                //                                TargetValue = parameterInfo.TargetValue,
-                //                                LowerLomit = parameterInfo.LowerSpecificationsLimit,
-                //                                UpperLimit = parameterInfo.UpperSpecificationsLimit,
-                //                                DefectCode = defectCode,
-                //                                UOMCode = parameterInfo.UOMCode,
-                //                            }
-                //                        }
-                //                    }).ToList()
-                //                };
-
-                //                content = await _agingInOrOutInputService.GetOCVOutputAsync(outputDto);
-                //                result = JsonConvert.DeserializeObject<BasicResult>(content.Data.ToString());
-                //                if (!result.Success)
-                //                    task.Remark = "NG";
-                //            }
-                //        }
-                //        else
-                //            task.Remark = "NG";
-                //    }
-                //}
-                #endregion 鑰佺増鏈�
-
                 if (task.TaskType == (int)TaskOutboundTypeEnum.Outbound)
                 {
                     if (!task.Roadway.Contains("FR") && stock.ProcessCode != "OCVB")
@@ -194,6 +117,7 @@
             (var loc, var tas) = UpdateStockAndTaskStatus(stock, task);
             var taskHty = task.Adapt<Dt_Task_Hty>();
             taskHty.FinishTime = DateTime.Now;
+            taskHty.OperateType = (int)OperateTypeEnum.鑷姩瀹屾垚;
 
             DtStockInfo_Hty stockInfo_Hty = stock.Adapt<DtStockInfo_Hty>();
             stockInfo_Hty.ModifyDate = DateTime.Now;
@@ -211,6 +135,15 @@
                 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}");
+                _simpleCacheService.HashDel<DtStockInfo>(WIDESEA_Cache.CacheConst.Cache_DtStockInfo, new string[] { stock.PalletCode });
+            }
 
             return content.OK("浠诲姟瀹屾垚鎴愬姛", task.Remark);
         }
@@ -445,6 +378,10 @@
             if (isResult)
             {
                 _locationStatusChangeRecordRepository.AddLocationStatusChangeRecord(locationInf, lastStatus, (int)StatusChangeTypeEnum.AutomaticStorage, task.TaskNum);
+
+                stock.StockInfoDetails = new List<DtStockInfoDetail>() { { stock.StockInfoDetails[0] } };
+                _simpleCacheService.HashAdd(WIDESEA_Cache.CacheConst.Cache_DtStockInfo, stock.PalletCode, stock);
+
                 content.OK("鍏ュ簱浠诲姟瀹屾垚鎴愬姛");
             }
             else
@@ -478,6 +415,7 @@
             IsFull = false,
             AreaCode = area.AreaCode ?? "",
             LocationId = loation.Id,
+            ProductionLine = task.ProductionLine,
             StockInfoDetails = new List<DtStockInfoDetail>()
             {
                 new DtStockInfoDetail()
@@ -760,7 +698,7 @@
                 {
                     NGStation = efg.Select(x => x.stationNGChildCode).ToList();
                 }
-                content = await CreateNewTask(input, NGStation, 2);
+                content = await CreateNewTask(input, result.ProductionLine, result.ProcessCode, NGStation, 2);
                 return content.Error("瀛樺湪寮傚父鐢佃姱");
             }
 
@@ -797,7 +735,7 @@
                 {
                     // TODO 閫佽嚦鍖呰
                     List<string> strings = stationManagers.Where(x => x.stationType == 0).Select(x => x.Roadway).ToList();
-                    content = await CreateNewTask(input, strings, 3);
+                    content = await CreateNewTask(input, result.ProductionLine, result.ProcessCode, strings, 3);
                     return content;
                 }
                 else
@@ -805,7 +743,7 @@
                     var config = _configService.GetByConfigKey("SYS_InStacker", "CW3InStacker");
                     var strings = config.ConfigValue.Split(',').ToList();
                     // TODO 鍏ュ簱
-                    content = await CreateNewTask(input, strings);
+                    content = await CreateNewTask(input, result.ProductionLine, result.ProcessCode, strings);
                     if (content.Status)
                         await _boxingInfoRepository.AddDataNavAsync(boxing);
                 }
@@ -894,7 +832,7 @@
                 List<string> strings = stationManagers.Roadway.Split(',').ToList();
                 Console.WriteLine(strings.ToJsonString() + "b-----------------------");
                 //// 璋冪敤CreateNewTask鏂规硶锛屽垱寤烘柊浠诲姟
-                content = await CreateNewTask(input, strings);
+                content = await CreateNewTask(input, result.ProductionLine, result.ProcessCode, strings);
                 if (content.Status)
                 {
                     var isBox = await _boxingInfoRepository.AddDataNavAsync(boxing);
@@ -950,6 +888,8 @@
                     Creater = "System", // 淇鎷煎啓閿欒
                     CreateDate = DateTime.Now,
                     TaskId = 0,
+                    ProductionLine = stock.ProductionLine,
+                    ProcessCode = stock.ProcessCode,
                 };
 
                 var taskDTO = CreateTaskDTO(taskNew);
@@ -997,7 +937,6 @@
                     return content.Error(result.MOMMessage);
             }
 
-
             if (result.SerialNos.Count <= 0)
             {
                 var config = _configService.GetByConfigKey(CateGoryConst.CONFIG_SYS_InStacker, SysConfigConst.InboundIsEmpty);
@@ -1023,6 +962,7 @@
                 var boxing = CreateBoxingInfo(result, input.PalletCode);
                 if (boxing == null) return content.Error("缁勭洏澶辫触");
 
+                input.ProductionLine = result.ProductionLine;
                 return await ProcessBasedOnProcessCode(boxing, area, input, result);
             }
         }
@@ -1073,19 +1013,44 @@
             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);
+                //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: task);
+            }
+
+            // 鏍规嵁浣嶇疆鏌ヨ鍖哄煙淇℃伅
+            var areaCode = Regex.Replace(input.Position, @"-(\d+)", "");
+            var area = await QueryAreaInfoByPosition(areaCode);
+            if (area == null)
+            {
+                return content.Error("璇ョ偣浣嶄笉鍦ㄥ尯鍩熷垪琛ㄤ腑瀛樺湪");
+            }
+
+            // 鑾峰彇鏁寸洏鐢佃姱灞炴�х姸鎬�
+            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();
@@ -1096,9 +1061,8 @@
                     throw new Exception("鏈壘鍒扮┖鎵樼洏鍏ュ簱绔欏彴鍜屽叆搴撶珯鍙伴厤缃�");
             }
             List<string> strings = stationManagers.Roadway.Split(',').ToList();
-            //Console.WriteLine(strings.ToJsonString() + "b-----------------------");
 
-            return await CreateNewTask(input, strings, 1);
+            return await CreateNewTask(input, result.ProductionLine, result.ProcessCode, strings, 1);
         }
         catch (Exception)
         {
@@ -1174,6 +1138,8 @@
                 return content.Error("搴撳瓨淇℃伅涓嶅瓨鍦�");
             }
 
+            //ConsoleHelper.WriteColorLine(JsonConvert.SerializeObject(stockInfo), ConsoleColor.DarkMagenta);
+
             // 鏂板閲嶅浠诲姟鏍¢獙
             var hasTask = BaseDal.QueryFirst(x => x.PalletCode == stockInfo.PalletCode);
             if (hasTask != null)
@@ -1218,20 +1184,37 @@
     private async Task<DtStockInfo> QueryStockInfoForRealTrayAsync(string areaCode, List<string> devices, string productionLine)
     {
         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) // 杩囨护鏉′欢
-            .WhereIF(!productionLine.IsNullOrEmpty(), x => x.ProductionLine == productionLine)
-            .Where(x => x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && x.LocationInfo.AreaId == area.AreaID && x.LocationInfo.EnalbeStatus == (int)EnableEnum.Enable) // 杩囨护鏉′欢
-            .WhereIF(!devices.IsNullOrEmpty(), x => devices.Contains(x.LocationInfo.RoadwayNo))
-            .OrderBy(x => x.OutboundTime) // 鎺掑簭
-            .FirstAsync(); // 鑾峰彇绗竴涓厓绱�
+        var outBoundMateriel = AppSettings.app<OutBoundMateriel>("OutBoundMateriel");
+        List<string>? materielCodes = outBoundMateriel.Count != 0
+            ? outBoundMateriel.Where(x => x.ProductionLine == productionLine && x.ProcessCode == area.AreaCode)
+                              .Select(x => x.MaterielCode)
+                              .ToList()
+            : null;
 
-        //var firstOrDefault = result.FirstOrDefault(x => roadways.Contains(x.LocationInfo.RoadwayNo)); // 鏌ユ壘绗竴涓尮閰嶇殑鍏冪礌
-        //var firstOrDefault = result[0]; // 鏌ユ壘绗竴涓尮閰嶇殑鍏冪礌
-        //return firstOrDefault;
+        IDictionary<string, DtStockInfo>? stockInfos = _simpleCacheService.HashGetAll<DtStockInfo>(WIDESEA_Cache.CacheConst.Cache_DtStockInfo);
+        List<DtStockInfo> stockInfoList = stockInfos.Values.ToList();
+        var result = new DtStockInfo();
+
+        //if (stockInfoList.IsNullOrEmpty())
+        //{
+        //    stockInfoList = await _stockInfoRepository.Db.Queryable<DtStockInfo>()
+        //        .Where(x => x.LocationInfo.LocationStatus == (int)LocationEnum.InStock).IncludesAllFirstLayer().ToListAsync();
+        //}
+
+        result = stockInfoList.Where(x => x.AreaCode == areaCode && x.OutboundTime < DateTime.Now && x.IsFull)
+                          .WhereIF(!productionLine.IsNullOrEmpty(), x => x.ProductionLine == productionLine)
+                          .Where(x => x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && x.LocationInfo.AreaId == area.AreaID && x.LocationInfo.EnalbeStatus == (int)EnableEnum.Enable)
+                          .WhereIF(!devices.IsNullOrEmpty(), x => devices.Contains(x.LocationInfo.RoadwayNo))
+                          .WhereIF(!materielCodes.IsNullOrEmpty(), x => x.StockInfoDetails.Any(y => materielCodes.Contains(y.MaterielCode)))
+                          .OrderBy(x => x.OutboundTime)
+                          .FirstOrDefault();
+
         return result;
     }
 
@@ -1247,25 +1230,37 @@
             return null;
         }
 
-        var devices = SqlSugarHelper.DbWCS.Queryable<Dt_DeviceInfo>()
-            .Where(x => x.DeviceStatus == "1")
-            .Where(x => x.DeviceRemark == "1")
-            .ToList();
-        var deviceCode = devices.Select(x => x.DeviceCode).ToList();
+        //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 result = await _stockInfoRepository.Db.Queryable<DtStockInfo>()
-            .Includes(x => x.LocationInfo) // 棰勫姞杞絃ocationInfo
-            .Includes(x => x.StockInfoDetails) // 棰勫姞杞絊tockInfoDetails
-            .Where(x => areaCodes.Contains(x.AreaCode) && x.OutboundTime < DateTime.Now && x.IsFull == true) // 杩囨护鏉′欢
+        var outBoundMateriel = AppSettings.app<OutBoundMateriel>("OutBoundMateriel");
+        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 deviceCode = devices.Select(x => x.DeviceCode).ToList();
+
+        IDictionary<string, DtStockInfo>? stockInfos = _simpleCacheService.HashGetAll<DtStockInfo>(WIDESEA_Cache.CacheConst.Cache_DtStockInfo);
+        List<DtStockInfo> stockInfoList = stockInfos.Values.ToList();
+
+        var result = stockInfoList.Where(x => areaCodes.Contains(x.AreaCode) && x.OutboundTime < DateTime.Now && x.IsFull == true) // 杩囨护鏉′欢
             .WhereIF(!productionLine.IsNullOrEmpty(), x => x.ProductionLine == productionLine)
             .Where(x => x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && areaId.Contains(x.LocationInfo.AreaId) && x.LocationInfo.EnalbeStatus == (int)EnableEnum.Enable) // 杩囨护鏉′欢
             .WhereIF(!deviceCode.IsNullOrEmpty(), x => deviceCode.Contains(x.LocationInfo.RoadwayNo))
+            .WhereIF(!materielCodes.IsNullOrEmpty(), x => x.StockInfoDetails.Any(y => materielCodes.Contains(y.MaterielCode)))
             .OrderBy(x => x.OutboundTime) // 鎺掑簭
-            .FirstAsync(); // 鑾峰彇绗竴涓厓绱�
+            .FirstOrDefault(); // 鑾峰彇绗竴涓厓绱�
 
-        //var firstOrDefault = result.FirstOrDefault(x => roadways.Contains(x.LocationInfo.RoadwayNo)); // 鏌ユ壘绗竴涓尮閰嶇殑鍏冪礌
-        //var firstOrDefault = result[0]; // 鏌ユ壘绗竴涓尮閰嶇殑鍏冪礌
-        //return firstOrDefault;
         return result;
     }
 
@@ -1282,26 +1277,28 @@
         ConsoleHelper.WriteColorLine(station.Roadway, ConsoleColor.Magenta);
         var stackers = station.Roadway.Split(',').ToList();
 
-
-        var devices = SqlSugarHelper.DbWCS.Queryable<Dt_DeviceInfo>()
+        var deviceCode = SqlSugarHelper.DbWCS.Queryable<Dt_DeviceInfo>()
             .Where(x => x.DeviceStatus == "1")
             .Where(x => stackers.Contains(x.DeviceCode))
-            .ToList();
+            .ToList().Select(x => x.DeviceCode).ToList();
 
-        var deviceCode = devices.Select(x => x.DeviceCode).ToList();
+        IDictionary<string, DtStockInfo>? stockInfos = _simpleCacheService.HashGetAll<DtStockInfo>(WIDESEA_Cache.CacheConst.Cache_DtStockInfo);
+        List<DtStockInfo> stockInfoList = stockInfos.Values.ToList();
 
-        var result = await _stockInfoRepository.Db.Queryable<DtStockInfo>()
-            .Includes(x => x.LocationInfo) // 棰勫姞杞絃ocationInfo
-            .Includes(x => x.StockInfoDetails) // 棰勫姞杞絊tockInfoDetails
+        var result = stockInfoList.Where(x => x.ProductionLine == station.productLine)
             .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 && x.LocationInfo.EnalbeStatus == (int)EnableEnum.Enable) // 杩囨护鏉′欢
             .WhereIF(!deviceCode.IsNullOrEmpty(), x => deviceCode.Contains(x.LocationInfo.RoadwayNo))
             .OrderBy(x => x.CreateDate) // 鎺掑簭
-            .FirstAsync(); // 杞崲涓哄垪琛�
+            .FirstOrDefault(); // 杞崲涓哄垪琛�
 
-        //var firstOrDefault = result[0]; // 鏌ユ壘绗竴涓尮閰嶇殑鍏冪礌
-        //return firstOrDefault;
+        //if (result != null)
+        //{
+        //    stockInfoList = stockInfoList.Where(x => x != result).ToList();
+        //    _simpleCacheService.HashDel<DtStockInfo>(WIDESEA_Cache.CacheConst.Cache_DtStockInfo, new string[] { result.PalletCode });
+        //}
+
         return result;
     }
 
@@ -1328,6 +1325,8 @@
             Creater = "System", // 淇鎷煎啓閿欒
             CreateDate = DateTime.Now,
             TaskId = 0,
+            ProductionLine = stockInfo.ProductionLine,
+            ProcessCode = stockInfo.ProcessCode,
         };
     }
 
@@ -1347,6 +1346,7 @@
             TaskState = task.TaskState.Value,
             Id = 0,
             TaskType = task.TaskType,
+            ProductionLine = task.ProductionLine,
         };
     }
 
@@ -1625,7 +1625,7 @@
         //    content.Error(ex.Message);
         //}
         //return content;
-        #endregion
+        #endregion 闈欑疆寮傚父鍙e叆搴�
         WebResponseContent content = new WebResponseContent();
         try
         {
@@ -1695,7 +1695,9 @@
                         TaskState = (int)TaskInStatusEnum.Line_InFinish,
                         TaskType = (int)TaskInboundTypeEnum.Inbound,
                         TaskNum = await BaseDal.GetTaskNo(),
-                        Creater = "Systeam"
+                        Creater = "Systeam",
+                        ProductionLine = result.ProductionLine,
+                        ProcessCode = result.ProcessCode,
                     };
 
                     // 鍒涘缓WMS浠诲姟
@@ -1731,7 +1733,9 @@
                         TaskState = (int)TaskInStatusEnum.Line_InFinish,
                         TaskType = (int)TaskInboundTypeEnum.InTray,
                         TaskNum = await BaseDal.GetTaskNo(),
-                        Creater = "Systeam"
+                        Creater = "Systeam",
+                        ProductionLine = result.ProductionLine,
+                        ProcessCode = result.ProcessCode,
                     };
                     // 鍒涘缓WMS浠诲姟
                     WMSTaskDTO taskDTO = CreateWMSTaskDTO(task);
@@ -1763,7 +1767,6 @@
         return content;
     }
 
-
     private WMSTaskDTO CreateWMSTaskDTO(object source)
     {
         if (source is Dt_Task taskOld)
@@ -1779,6 +1782,7 @@
                 TaskState = taskOld.TaskState.Value,
                 Id = 0,
                 TaskType = taskOld.TaskType,
+                ProductionLine = taskOld.ProductionLine
             };
         }
         else if (source is Dt_Task task)
@@ -1794,6 +1798,7 @@
                 TaskState = task.TaskState.Value,
                 Id = 0,
                 TaskType = task.TaskType,
+                ProductionLine = task.ProductionLine
             };
         }
         else
@@ -1805,8 +1810,6 @@
     #endregion 闈欑疆寮傚父鍙e叆搴�
 
     #endregion 澶栭儴鎺ュ彛鏂规硶
-
-
 
     #region 鍐呴儴璋冪敤鏂规硶
 
@@ -1991,7 +1994,7 @@
     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;
 
         // 鍒涘缓鍘嗗彶浠诲姟
@@ -2004,7 +2007,7 @@
         {
             taskHty.Creater = App.User.UserName != null ? App.User.UserName : "System";
         }
-        taskHty.TaskState = TaskOutStatusEnum.OutFinish.ObjToInt();
+        taskHty.TaskState = task.TaskType > 199 ? (int)TaskInStatusEnum.InFinish : (int)TaskOutStatusEnum.OutFinish;
         return taskHty;
     }
 
@@ -2060,16 +2063,31 @@
                 }
             }
 
-            var stocks = _stockInfoRepository.QueryData(x => x.AreaCode == stock.AreaCode && x.ProductionLine == stock.ProductionLine && x.SpecialParameterDuration != stock.SpecialParameterDuration);
-            if (stocks != null && stocks.Count > 0)
+            if (stock.IsFull)
             {
-                foreach (var item in stocks)
+                // 鏌ヨ绗﹀悎鏉′欢鐨勫簱瀛樹俊鎭�
+                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)
                 {
-                    item.SpecialParameterDuration = stock.SpecialParameterDuration;
-                    item.ParameterInfos = stock.ParameterInfos;
-                    item.OutboundTime = Convert.ToDateTime(item.LinedProcessFeedbackTime == null ? item.CreateDate : item.LinedProcessFeedbackTime).AddHours(Convert.ToDouble(stock.SpecialParameterDuration));
+                    // 杩囨护鍑洪渶瑕佹洿鏂扮殑搴撳瓨淇℃伅
+                    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);
+                    }
                 }
-                var isUpdates = await _stockInfoRepository.UpdateDataAsync(stocks);
             }
 
             // 娣诲姞鍘嗗彶浠诲姟
@@ -2105,85 +2123,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();
-
-            // 鑾峰彇鐩爣鍦板潃鍜屾洿鏂颁换鍔$姸鎬�
-
-            input.Position = Regex.Replace(input.Position, @"-(\d+)", "");
-            if (Convert.ToInt32(input.Position) > 1999)
+            if (task == null)
             {
-                input.Position = (Convert.ToInt32(input.Position) - 1000).ToString();
+                return new WebResponseContent().Error("浠诲姟瀵硅薄涓虹┖");
             }
 
-            if (task.TaskType == (int)TaskInboundTypeEnum.InNG)
+            try
             {
-                // 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)
+                // 鍒涘缓WebResponseContent瀵硅薄
+                var content = new WebResponseContent();
+
+                // 鑾峰彇鐩爣鍦板潃鍜屾洿鏂颁换鍔$姸鎬�
+
+                input.Position = Regex.Replace(input.Position, @"-(\d+)", "");
+                if (Convert.ToInt32(input.Position) > 1999)
                 {
-                    return content.Error("鏃犳硶鑾峰彇璐т綅淇℃伅");
+                    input.Position = (Convert.ToInt32(input.Position) - 1000).ToString();
                 }
 
-                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)
+                if (task.TaskType == (int)TaskInboundTypeEnum.InNG)
                 {
-                    _unitOfWorkManage.RollbackTran();
-                    return content.Error("鏇存柊浠诲姟澶辫触");
+                    // 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("鏃犳硶鑾峰彇璐т綅淇℃伅");
+                    }
 
-                // 鎻愪氦浜嬪姟
-                _unitOfWorkManage.CommitTran();
-                return content.OK(data: task);
+                    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)
@@ -2223,7 +2251,7 @@
     /// <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();
 
@@ -2251,7 +2279,9 @@
             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 = "Systeam",
+            ProductionLine = productionLine,
+            ProcessCode = processCode
         };
 
         // 灏濊瘯娣诲姞鏂颁换鍔�
@@ -2280,6 +2310,7 @@
                     TaskState = task.TaskState.Value,
                     Id = 0,
                     TaskType = task.TaskType,
+                    ProductionLine = task.ProductionLine
                 };
                 content.OK(data: taskDTO);
             }
@@ -2291,8 +2322,8 @@
         return content;
     }
 
-
     private static readonly SemaphoreSlim _semaphore = new SemaphoreSlim(1, 1);
+
     /// <summary>
     /// 鏌ユ壘璐т綅
     /// </summary>

--
Gitblit v1.9.3