From 5b2265e68c0a493c52ea336f77f8dbcd7655d34a Mon Sep 17 00:00:00 2001
From: 肖洋 <cathay_xy@163.com>
Date: 星期五, 22 十一月 2024 10:20:59 +0800
Subject: [PATCH] Merge branch 'master' of http://115.159.85.185:8098/r/HuaYiZhongHeng/BaiBuLiKu

---
 Code Management/WMS/WIDESEA_WMSServer/WIDESEA_StorageTaskServices/Task/Dt_TaskService.cs |  436 +++++++++++++++++++++++++++++++-----------------------
 1 files changed, 249 insertions(+), 187 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 5eca4bd..0fb68e6 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;
@@ -12,7 +13,7 @@
 
 namespace WIDESEA_StorageOutTaskServices;
 
-public class Dt_TaskService : ServiceBase<Dt_Task, IDt_TaskRepository>, IDt_TaskService
+public partial class Dt_TaskService : ServiceBase<Dt_Task, IDt_TaskRepository>, IDt_TaskService
 {
     private readonly LogFactory LogFactory = new LogFactory();
     private readonly IUnitOfWorkManage _unitOfWorkManage;
@@ -92,11 +93,11 @@
         {
             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);
+                //var process = await SqlSugarHelper.Db.Queryable<Dt_EquipmentProcess>()
+                //    .FirstAsync(x => x.EquipmentName == task.Roadway);
+                //var info = JsonConvert.DeserializeObject<ResponseEqptRunDto>(process.ProcessValue);
 
-                var agingOutputDto = MapToAgingOutputDto(stock, info);
+                var agingOutputDto = MapToAgingOutputDto(stock);
                 content = await _agingInOrOutInputService.GetOCVOutputAsync(agingOutputDto);
                 ValidateResponse(content);
             }
@@ -122,31 +123,37 @@
         }
     }
 
-    private AgingOutputDto MapToAgingOutputDto(DtStockInfo stock, ResponseEqptRunDto info)
+    private AgingOutputDto MapToAgingOutputDto(DtStockInfo stock, ResponseEqptRunDto info = null)
     {
         // TODO Value鍊兼牴鎹甅OM涓嬪彂鐨勯潤缃椂闂村埌褰撳墠鏃堕棿鐨勫垎閽熸暟
+        var area = _areaInfoRepository.QueryFirst(x => x.AreaCode == stock.AreaCode);
+        if (area == null)
+        {
+            throw new Exception("鏈壘鍒板搴旂殑搴撳尯淇℃伅");
+        }
         return new AgingOutputDto
         {
             OpFlag = 1,
-            Software = "WMS",
-            EquipmentCode = "ECH001-B",
+            Software = area.Spare3,
+            EquipmentCode = area.Spare2,
             TrayBarcode = stock.PalletCode,
             SerialNos = stock.StockInfoDetails.Select(x => new SerialNoOutDto
             {
                 SlotNo = x.OrderNo.ToInt32(),
                 SerialNo = x.SerialNumber,
                 SerialNoResult = true,
-                ParameterInfo = info.ParameterInfo.Select(y => new ParameterInfo()
-                {
-                    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()
+                ParameterInfo = new List<ParameterInfo> { new ParameterInfo() { Value = (DateTime.Now - stock.CreateDate).TotalMinutes.ToString() } }
+                //ParameterInfo = info.ParameterInfo.Select(y => new ParameterInfo()
+                //{
+                //    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()
         };
     }
@@ -163,7 +170,7 @@
     private (DtLocationInfo, Dt_Task) UpdateStockAndTaskStatus(DtStockInfo stock, Dt_Task task)
     {
         var location = _locationRepository.QueryFirst(x => x.LocationCode == task.SourceAddress);
-        var details = _stockInfoDetailRepository.QueryData(x => x.StockId == stock.Id);
+        //var details = _stockInfoDetailRepository.QueryData(x => x.StockId == stock.Id);
 
         location.LocationStatus = (int)LocationEnum.Free;
         task.TaskState = (int)TaskOutStatusEnum.OutFinish;
@@ -253,91 +260,6 @@
     /// </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)
     {
         // 鍒濆鍖栧搷搴斿唴瀹�
@@ -373,6 +295,7 @@
             // 璁板綍寮傚父淇℃伅鍒版帶鍒跺彴鍜屾棩蹇�
             Console.WriteLine(err.Message.ToString());
             LogFactory.GetLog("浠诲姟瀹屾垚").Error(true, err);
+            content.Error(err.Message);
         }
         return content;
     }
@@ -382,6 +305,8 @@
     /// </summary>
     private DtStockInfo CreateEmptyPalletStock(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,
@@ -389,13 +314,15 @@
             CreateDate = DateTime.Now,
             Creater = "system",
             IsFull = false,
-            AreaCode = task.Roadway,
+            AreaCode = area.AreaCode,
+            LocationId = loation.Id,
             StockInfoDetails = new List<DtStockInfoDetail>()
             {
                 new DtStockInfoDetail()
                 {
                     MaterielCode = "绌烘墭鐩�",
                     Id = 0,
+                    Status = (int)StockStateEmun.宸插叆搴�
                 }
             }
         };
@@ -406,7 +333,14 @@
     /// </summary>
     private DtStockInfo CreateFullPalletStock(Dt_Task task, DtLocationInfo locationInf, DtBoxingInfo boxing)
     {
+        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 boxDetail = boxing.BoxingInfoDetails.Adapt<List<DtStockInfoDetail>>();
+        boxDetail.ForEach(x => { x.Status = (int)StockStateEmun.宸插叆搴�; });
         var stock = new DtStockInfo()
         {
             PalletCode = task.PalletCode,
@@ -414,7 +348,8 @@
             CreateDate = DateTime.Now,
             Creater = "system",
             IsFull = boxing.IsFull,
-            AreaCode = task.Roadway,
+            AreaCode = area.AreaCode,
+            LocationId = loation.Id,
             StockInfoDetails = boxDetail,
         };
 
@@ -426,8 +361,8 @@
                 .ToList(),
             TrayBarcode = task.PalletCode,
             OpFlag = 1,
-            EquipmentCode = "ECH001-B",
-            Software = "WMS"
+            EquipmentCode = area.Spare2,
+            Software = area.Spare3
         };
         var result = _agingInOrOutInputService.GetOCVInputAsync(agingInputDto).Result;
         var respone = JsonConvert.DeserializeObject<ResponeAgingInputDto>(result.Data.ToString());
@@ -435,6 +370,7 @@
         stock.SpecialParameterDuration = respone.SpecialParameterDuration;
         //2024骞�11鏈�16鏃ワ細鏂板瀛楁璁$畻搴斿嚭搴撴椂闂�
         stock.OutboundTime = Convert.ToDateTime(respone.LinedProcessFeedbackTime).AddHours(Convert.ToDouble(respone.SpecialParameterDuration));
+        stock.ProductionLine = respone.ProductionLine;
 
         // 璁板綍鏃ュ織
         LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, "鍏ュ簱浠诲姟瀹屾垚", $"璐т綅鍦板潃锛歿task.TargetAddress},淇敼鍚庤揣浣嶆暟鎹細{locationInf}");
@@ -526,12 +462,18 @@
                     return content.OK(data: taskDTO);
                 }
             }
+
+            var area = await _areaInfoRepository.QueryFirstAsync(x => x.Spare1.Contains(input.Position));
+            if (area == null)
+                return content.Error("鏀圭偣浣嶄笉鍦ㄥ尯鍩熷垪琛ㄤ腑瀛樺湪");
+
             // 鍒涘缓涓�涓猅rayCellsStatusDto瀵硅薄锛屽苟璧嬪��
             TrayCellsStatusDto trayCells = new TrayCellsStatusDto()
             {
-                Software = "WMS",
+                Software = area.Spare3,
                 TrayBarcode = input.PalletCode,
-                EquipmentCode = "ECH001-B"
+                //EquipmentCode = "EQ_CWJZ01"
+                EquipmentCode = area.Spare2
             };
 
             // 璋冪敤GetTrayCellStatusAsync鏂规硶锛岃幏鍙栨暣鐩樼數鑺�
@@ -546,9 +488,9 @@
                 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("鏂欐灞炴�т笉瀛樺湪");
+            //var productions = await _productionRepository.QueryDataAsync(x => result.TrayBarcodePropertys.Select(x => x.TrayBarcodeProperty).ToList().Contains(x.TrayBarcodeProperty));
+            //if (productions.Count <= 0)
+            //    return content.Error("鏂欐灞炴�т笉瀛樺湪");
 
             // 璋冪敤CreateBoxingInfo鏂规硶锛屽垱寤虹粍鐩樹俊鎭�
 
@@ -560,6 +502,12 @@
 
             // 濡傛灉process涓簄ull锛屽垯杩斿洖content
             if (process == null) return content;
+
+            // 骞惰祴鍊间笂浣嶈蒋浠跺悕绉板拰璁惧缂栫爜
+            process.Software = area.Spare3;
+            process.EquipmentCode = area.Spare2;
+
+            // 璋冪敤GetProcessApplyAsync鏂规硶锛岃幏鍙栧伐鑹虹敵璇�
 
             // 璋冪敤_processApplyService.GetProcessApplyAsync鏂规硶锛岃幏鍙栧伐鑹虹敵璇�
             content = await _processApplyService.GetProcessApplyAsync(process);
@@ -644,7 +592,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)
         {
@@ -684,8 +636,6 @@
         // 鍒涘缓涓�涓狿rocessApplyDto瀵硅薄锛屽苟璧嬪��
         return new ProcessApplyDto()
         {
-            EquipmentCode = "ECH001-B",
-            Software = "WMS",
             //WipOrderNo = result.BindCode,
             SerialNos = content.SerialNos.Select(item => new SerialNos
             {
@@ -745,12 +695,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);
             }
 
             // 鍒涘缓鏂颁换鍔″疄渚�
@@ -785,26 +743,43 @@
     /// <summary>
     /// 鏌ヨ瀹炵洏搴撳瓨淇℃伅
     /// </summary>
-    private DtStockInfo QueryStockInfoForRealTray(string areaCode, List<string> roadways)
+    private async Task<DtStockInfo> QueryStockInfoForRealTrayAsync(string areaCode, List<string> roadways)
     {
-        // TODO鏃堕棿鏍规嵁MOM绯荤粺閰嶇疆鐨勫嚭搴撴椂闂存潵鑾峰彇,鏆傛椂涓嶇煡閬揗OM杩斿洖鐨勬椂闂存槸浠�涔堟墍浠ヨ繖閲屾祴璇曟椂鍊欏湪鏀�
-        return _stockInfoRepository.Db.Queryable<DtStockInfo>().Where(x => x.AreaCode == areaCode && Convert.ToDateTime(x.LinedProcessFeedbackTime) < 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();
+        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.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 firstOrDefault = result.FirstOrDefault(x => roadways.Contains(x.LocationInfo.RoadwayNo)); // 鏌ユ壘绗竴涓尮閰嶇殑鍏冪礌
+        //var firstOrDefault = result[0]; // 鏌ユ壘绗竴涓尮閰嶇殑鍏冪礌
+        //return firstOrDefault;
+        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();
+        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(); // 杞崲涓哄垪琛�
+
+        //var firstOrDefault = result[0]; // 鏌ユ壘绗竴涓尮閰嶇殑鍏冪礌
+        //return firstOrDefault;
+        return result;
     }
 
     /// <summary>
@@ -869,7 +844,7 @@
             if (task == null)
                 return content.Error("鏈壘鍒颁换鍔�");
 
-            if (taskState == (int)TaskOutStatusEnum.Line_OutFinish)
+            if (taskState == (int)TaskOutStatusEnum.Line_OutFinish || taskState == (int)TaskInStatusEnum.SC_InFinish)
             {
                 var taskHty = CreateHistoricalTask(task);
                 await _unitOfWorkManage.UseTranAsync(async () =>
@@ -1030,7 +1005,7 @@
     /// <returns>鏄惁鏇存柊鎴愬姛</returns>
     public async Task<bool> Update(Dt_Task model)
     {
-        return await BaseDal.Update(model);
+        return await BaseDal.UpdateDataAsync(model);
     }
 
     /// <summary>
@@ -1040,7 +1015,7 @@
     /// <returns>鏄惁鏇存柊鎴愬姛</returns>
     public async Task<bool> Update(List<Dt_Task> models)
     {
-        return await BaseDal.Update(models);
+        return await BaseDal.UpdateDataAsync(models);
     }
 
     /// <summary>
@@ -1060,7 +1035,7 @@
     /// <returns></returns>
     public async Task<Dt_Task> GetByLocation(string locationID)
     {
-        return await Db.Queryable<Dt_Task>().Where(x => x.SourceAddress == locationID).FirstAsync();
+        return await BaseDal.QueryFirstAsync(x => x.SourceAddress == locationID);
     }
 
     /// <summary>
@@ -1070,7 +1045,7 @@
     /// <returns></returns>
     public async Task<Dt_Task> GetByTaskNum(int taskNum)
     {
-        return await Db.Queryable<Dt_Task>().Where(x => x.TaskNum == taskNum).FirstAsync();
+        return await BaseDal.QueryFirstAsync(x => x.TaskNum == taskNum);
     }
 
     #endregion 鍐呴儴璋冪敤鏂规硶
@@ -1160,12 +1135,13 @@
     /// <param name="taskHty">鍘嗗彶浠诲姟瀵硅薄</param>
     /// <param name="taskId">浠诲姟ID</param>
     /// <returns></returns>
-    private async Task<bool> ExecuteTransaction(DtStockInfo stock, Dt_Task_Hty taskHty, DtLocationInfo locationInfo, int taskId)
+    private async Task<bool> ExecuteTransaction(DtStockInfo stock, Dt_Task_Hty taskHty, DtLocationInfo locationInfo, int taskId, DtBoxingInfo boxingInfo = null)
     {
         _unitOfWorkManage.BeginTran();
         try
         {
             var isUpdateStock = true;
+            var isDeleteBoxing = true;
             if (taskHty.TaskType == (int)TaskTypeEnum.Outbound)
             {
                 // 鏇存柊搴撳瓨
@@ -1175,6 +1151,9 @@
             {
                 // 娣诲姞搴撳瓨
                 isUpdateStock = await _stockInfoRepository.AddDataNavAsync(stock);
+                isDeleteBoxing = await _boxingInfoRepository.Db.DeleteNav<DtBoxingInfo>(x => x.Id == boxingInfo.Id)
+                   .Include(x => x.BoxingInfoDetails)
+                   .ExecuteCommandAsync();
             }
 
 
@@ -1189,7 +1168,7 @@
             var isTaskDelete = await Delete(taskId);
 
             // 鎻愪氦鎴栧洖婊氫簨鍔�
-            if (isUpdateStock && isTaskHtyAdd && isTaskDelete && isUpdateLoc)
+            if (isUpdateStock && isTaskHtyAdd && isTaskDelete && isUpdateLoc && isDeleteBoxing)
             {
                 LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, "浠诲姟瀹屾垚", $"浜嬪姟澶勭悊瀹屾垚,鎻愪氦浜嬪姟銆傛坊鍔犲巻鍙蹭换鍔★細{isTaskHtyAdd},鍒犻櫎浠诲姟鏁版嵁锛歿isTaskDelete},鏇存柊鎴栨坊鍔犲簱瀛橈細{isUpdateStock},淇敼绉诲簱鍓嶈揣浣嶇姸鎬侊細{isUpdateLoc}");
                 _unitOfWorkManage.CommitTran();
@@ -1204,7 +1183,7 @@
         }
         catch (Exception err)
         {
-            LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, $"绉诲簱浠诲姟瀹屾垚,绯荤粺寮傚父锛屽紓甯镐俊鎭細{err.Message}", "鏃犲弬鏁�");
+            LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, $"浠诲姟瀹屾垚,绯荤粺寮傚父锛屽紓甯镐俊鎭細{err.Message}", "鏃犲弬鏁�");
             _unitOfWorkManage.RollbackTran();
             throw; // 鎶涘嚭寮傚父浠ヤ究澶栭儴鎹曡幏
         }
@@ -1220,46 +1199,140 @@
     /// <param name="task">浠诲姟瀹炰緥</param>
     /// <param name="content">鍝嶅簲鍐呭</param>
     /// <returns></returns>
+    //private async Task<WebResponseContent> UpdateExistingTask(RequestTaskDto input, Dt_Task task)
+    //{
+    //    // 鍒涘缓WebResponseContent瀵硅薄
+    //    WebResponseContent content = new WebResponseContent();
+    //    // 瀹氫箟鍙橀噺
+    //    string toAddress;
+    //    int taskState;
+    //    string original = task.CurrentAddress;
+    //    DtLocationInfo location = new DtLocationInfo();
+    //    int beforeStatus = 0;
+
+    //    // 澶勭悊鍏ュ簱浠诲姟
+    //    location = await GetLocationDistributeAsync(task.Roadway);
+    //    toAddress = location.LocationCode;
+    //    taskState = (int)TaskInStatusEnum.Line_InFinish;
+    //    beforeStatus = location.LocationStatus;
+
+    //    // 鏇存柊璐т綅淇℃伅
+    //    location.LocationStatus = (int)LocationEnum.Lock;
+
+    //    // 鏇存柊浠诲姟淇℃伅
+    //    task.CurrentAddress = input.Position;
+    //    task.TargetAddress = toAddress;
+    //    task.NextAddress = toAddress;
+    //    task.TaskState = taskState;
+
+    //    // 寮�濮嬩簨鍔�
+    //    _unitOfWorkManage.BeginTran();
+    //    // 瀹氫箟鍙橀噺
+    //    bool isUpdateLo = true;
+    //    bool isUpdateChange = true;
+
+    //    // 灏濊瘯鏇存柊浠诲姟
+    //    bool isResult = await BaseDal.UpdateDataAsync(task);
+    //    bool isTaskDetail = await _taskExecuteDetailRepository.AddDetailAsync(task, false, TaskDescription.GetTaskUpdateDescription(task.PalletCode, original, input.Position, TaskInStatusEnum.Line_InFinish.GetIntegralRuleTypeEnumDesc()));
+
+    //    // 鍒涘缓LocationChangeRecordDto瀵硅薄
+    //    LocationChangeRecordDto changeRecordDto = new LocationChangeRecordDto()
+    //    {
+    //        // 璁剧疆鍙橀噺
+    //        AfterStatus = location.LocationStatus,
+    //        BeforeStatus = beforeStatus,
+    //        TaskNum = task.TaskNum.Value,
+    //        LocationId = location.Id,
+    //        LocationCode = location.LocationCode,
+    //        ChangeType = (int)StatusChangeTypeEnum.AutomaticStorage,
+    //    };
+    //    // 鏇存柊浣嶇疆鐘舵��
+    //    isUpdateChange = _locationStatusChangeRecordRepository.AddStatusChangeRecord(changeRecordDto);
+    //    isUpdateLo = await _locationRepository.UpdateDataAsync(location);
+
+    //    if (isResult && isUpdateLo && isTaskDetail)
+    //    {
+    //        // 鎻愪氦浜嬪姟
+    //        _unitOfWorkManage.CommitTran();
+    //        content.OK(data: task);
+    //    }
+    //    else
+    //    {
+    //        // 鍥炴粴浜嬪姟
+    //        _unitOfWorkManage.RollbackTran();
+    //        content.Error("鏇存柊浠诲姟澶辫触");
+    //    }
+    //    return content;
+    //}
+
+    // 鏇存柊浠诲姟璐т綅
+
     private async Task<WebResponseContent> UpdateExistingTask(RequestTaskDto input, Dt_Task task)
     {
-        // 鍒涘缓WebResponseContent瀵硅薄
-        WebResponseContent content = new WebResponseContent();
-        // 瀹氫箟鍙橀噺
-        string toAddress;
-        int taskState;
-        string original = task.CurrentAddress;
-        DtLocationInfo location = new DtLocationInfo();
-        int beforeStatus = 0;
+        if (task == null)
+        {
+            return new WebResponseContent().Error("浠诲姟瀵硅薄涓虹┖");
+        }
 
-        // 澶勭悊鍏ュ簱浠诲姟
-        location = await GetLocationDistributeAsync(task.Roadway);
-        toAddress = location.LocationCode;
-        taskState = (int)TaskInStatusEnum.Line_InFinish;
-        beforeStatus = location.LocationStatus;
+        try
+        {
+            // 鍒涘缓WebResponseContent瀵硅薄
+            var content = new WebResponseContent();
 
-        // 鏇存柊璐т綅淇℃伅
-        location.LocationStatus = (int)LocationEnum.Lock;
+            // 鑾峰彇鐩爣鍦板潃鍜屾洿鏂颁换鍔$姸鎬�
+            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}");
+        }
+    }
+
+    private void MapTaskProperties(Dt_Task task, RequestTaskDto input, string toAddress, int taskState)
+    {
         task.CurrentAddress = input.Position;
         task.TargetAddress = toAddress;
         task.NextAddress = toAddress;
         task.TaskState = taskState;
+    }
 
-        // 寮�濮嬩簨鍔�
-        _unitOfWorkManage.BeginTran();
-        // 瀹氫箟鍙橀噺
-        bool isUpdateLo = true;
-        bool isUpdateChange = true;
-
-        // 灏濊瘯鏇存柊浠诲姟
+    // 淇敼浠诲姟
+    private async Task<bool> UpdateTaskAsync(Dt_Task task, DtLocationInfo location, int beforeStatus)
+    {
         bool isResult = await BaseDal.UpdateDataAsync(task);
-        bool isTaskDetail = await _taskExecuteDetailRepository.AddDetailAsync(task, false, TaskDescription.GetTaskUpdateDescription(task.PalletCode, original, input.Position, TaskInStatusEnum.Line_InFinish.GetIntegralRuleTypeEnumDesc()));
+        bool isTaskDetail = await _taskExecuteDetailRepository.AddDetailAsync(task, false, TaskDescription.GetTaskUpdateDescription(task.PalletCode, task.CurrentAddress, task.TargetAddress, TaskInStatusEnum.Line_InFinish.GetIntegralRuleTypeEnumDesc()));
 
-        // 鍒涘缓LocationChangeRecordDto瀵硅薄
         LocationChangeRecordDto changeRecordDto = new LocationChangeRecordDto()
         {
-            // 璁剧疆鍙橀噺
             AfterStatus = location.LocationStatus,
             BeforeStatus = beforeStatus,
             TaskNum = task.TaskNum.Value,
@@ -1267,23 +1340,11 @@
             LocationCode = location.LocationCode,
             ChangeType = (int)StatusChangeTypeEnum.AutomaticStorage,
         };
-        // 鏇存柊浣嶇疆鐘舵��
-        isUpdateChange = _locationStatusChangeRecordRepository.AddStatusChangeRecord(changeRecordDto);
-        isUpdateLo = await _locationRepository.UpdateDataAsync(location);
 
-        if (isResult && isUpdateLo && isTaskDetail)
-        {
-            // 鎻愪氦浜嬪姟
-            _unitOfWorkManage.CommitTran();
-            content.OK(data: task);
-        }
-        else
-        {
-            // 鍥炴粴浜嬪姟
-            _unitOfWorkManage.RollbackTran();
-            content.Error("鏇存柊浠诲姟澶辫触");
-        }
-        return content;
+        bool isUpdateChange = _locationStatusChangeRecordRepository.AddStatusChangeRecord(changeRecordDto);
+        bool isUpdateLo = await _locationRepository.UpdateDataAsync(location);
+
+        return isResult && isUpdateLo && isTaskDetail;
     }
 
     /// <summary>
@@ -1298,7 +1359,8 @@
         WebResponseContent content = new WebResponseContent();
 
         // 鑾峰彇鐩爣鍦板潃
-        string ToAddress = await GetRoadWayAsync(process);
+        //string ToAddress = await GetRoadWayAsync(process);
+        string ToAddress = await GetRoadWayAsync(input, process);
 
         // 鍒涘缓鏂颁换鍔″疄渚�
         var task = new Dt_Task
@@ -1354,7 +1416,7 @@
     /// <summary>
     /// 鏌ユ壘璐т綅
     /// </summary>
-    /// <param name="areaId">鍖哄煙涓婚敭</param>
+    /// <param name="IsFull">鍖哄煙涓婚敭</param>
     /// <param name="roadWay">宸烽亾</param>
     /// <returns></returns>
     public async Task<DtLocationInfo> GetLocationDistributeAsync(string roadWay, bool IsFull = true)
@@ -1370,7 +1432,7 @@
             }
             else
             {
-                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.LocationType ==*/);
             }
 
             if (locations == null)
@@ -1397,10 +1459,10 @@
     /// <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)
+             .GroupBy(x => x.RoadwayNo)
              .OrderByDescending(g => g.Count()) // 鏍规嵁姣忎釜缁勭殑鍏冪礌鏁伴噺鎺掑簭
              .First(); // 鍙栧嚭鏁伴噺鏈�澶氱殑缁�
 

--
Gitblit v1.9.3