From b7f53ba61fbc1844d7b92ff852762b140d46ab54 Mon Sep 17 00:00:00 2001
From: huanghongfeng <huanghongfeng@hnkhzn.com>
Date: 星期一, 23 六月 2025 19:58:16 +0800
Subject: [PATCH] 最新

---
 代码管理/WMS/WIDESEA_WMSServer/WIDESEA_TaskInfoService/PartialTaskService_Inbound.cs |  308 ++++++++++++++++++++++++++++++++++++--------------
 1 files changed, 220 insertions(+), 88 deletions(-)

diff --git "a/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_TaskInfoService/PartialTaskService_Inbound.cs" "b/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_TaskInfoService/PartialTaskService_Inbound.cs"
index 2a931fa..2c9ff09 100644
--- "a/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_TaskInfoService/PartialTaskService_Inbound.cs"
+++ "b/\344\273\243\347\240\201\347\256\241\347\220\206/WMS/WIDESEA_WMSServer/WIDESEA_TaskInfoService/PartialTaskService_Inbound.cs"
@@ -12,6 +12,7 @@
 using MailKit.Search;
 using System.Reflection.Metadata;
 using static WIDESEA_ITaskInfoService.ITaskService;
+using WIDESEA_Common.Log;
 
 namespace WIDESEA_TaskInfoService
 {
@@ -238,11 +239,13 @@
                                 CreateDate = DateTime.Now,
                                 MaterialType = (int)InventoryMaterialType.绌烘墭,
                                 Materialweight = 0,
+                                Wlstatus = (int)InventoryMaterialStatus.绌烘墭,
+                                Mgeneratetime = DateTime.Now,
                             };
                             _stockService.StockInfoService.Repository.AddData(dt_Stock);
                         }
                     }
-                    Dt_StockInfo dt_StockInfo = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == generate.PalletCode);
+                    Dt_StockInfo dt_StockInfo = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == generate.PalletCode && x.StockStatus== (int)StockStatusEmun.缁勭洏鏆傚瓨);
                     if (dt_StockInfo != null)
                     {
                         Dt_LocationInfo newLocation;
@@ -252,11 +255,82 @@
                         if(dt_StockInfo.MaterialType== (int)InventoryMaterialType.鎴愬搧  || (generate.SourceAddress == "R01-003-041-001-01" && dt_StockInfo.MaterialType == (int)InventoryMaterialType.鍘熸潗鏂�))
                         {
                             Locationtype = 11;
+
                         }else if(dt_StockInfo.MaterialType == (int)InventoryMaterialType.鍘熸潗鏂�)
                         {
                             Locationtype = 10;
                         }
-                        newLocation = _basicService.LocationInfoService.GetLocation(newSourceAddress.RoadwayNo, Locationtype);
+
+                        
+
+
+                        int maxRetries = 20;
+                        int retryCount = 0;
+                        bool needRetry;
+
+                        do
+                        {
+                            needRetry = false;  // 榛樿涓嶉渶瑕侀噸璇�
+                            retryCount++;
+
+
+                            if (dt_StockInfo.MaterialType == (int)InventoryMaterialType.鎴愬搧)
+                            {
+                                string[] targetCodes = dt_StockInfo.PalletCode.Split("*");
+                                Dt_InboundOrder dt_Inbound = _inboundService.InbounOrderService.Repository.QueryFirst(x => x.OrderName == targetCodes[0]);
+                                if (dt_Inbound.Startingcolumn != 0 || dt_Inbound.Terminationcolumn != 0)
+                                {
+                                    newLocation = _basicService.LocationInfoService.GetLocation2(newSourceAddress.RoadwayNo, Locationtype, dt_Inbound.Startingcolumn, dt_Inbound.Terminationcolumn);
+                                }
+                                else
+                                {
+                                    newLocation = _basicService.LocationInfoService.GetLocation(newSourceAddress.RoadwayNo, Locationtype);
+                                }
+
+                            }
+                            else
+                            {
+                                newLocation = _basicService.LocationInfoService.GetLocation(newSourceAddress.RoadwayNo, Locationtype);
+                               
+                            }
+
+
+                            if (newLocation == null)
+                            {
+                                return WebResponseContent.Instance.Error("鏃犳硶鑾峰彇搴撲綅");
+                            }
+
+                            // 2. 妫�鏌ュ簱瀛�
+                            if (_stockService.StockInfoService.Repository.QueryFirst(x => x.LocationCode == newLocation.LocationCode) !=null)
+                            {
+                                needRetry = true;
+                                continue;  // 鐩存帴杩涘叆涓嬩竴娆″惊鐜紙閲嶈瘯锛�
+                            }
+
+                            // 3. 妫�鏌ヤ换鍔�
+                            if (BaseDal.QueryFirst(x => x.TargetAddress == newLocation.LocationCode) != null)
+                            {
+                                needRetry = true;
+                                continue;
+                            }
+
+                            // 4. 妫�鏌ュ巻鍙蹭换鍔�
+                            if (_taskHtyService.CrueeTaskHty(newLocation.LocationCode))
+                            {
+                                needRetry = true;
+                                continue;
+                            }
+
+                        } while (needRetry && retryCount < maxRetries);
+
+                        // 妫�鏌ユ槸鍚﹁秴杩囨渶澶ч噸璇曟鏁�
+                        if (retryCount >= maxRetries)
+                        {
+                            return WebResponseContent.Instance.Error($"鏃犳硶鎵惧埌鍙敤搴撲綅锛堝凡灏濊瘯 {retryCount} 娆★級");
+                        }
+
+
+
                         //string[] Pallet = PalletCode.Split("-");
                         if (newLocation != null && newSourceAddress != null)
                         {
@@ -276,14 +350,20 @@
                                 Creater = "WMS",
                                 Depth = newLocation.Depth,
                                 CreateDate = DateTime.Now,
+                                MaterialType= dt_StockInfo.MaterialType
                             };
                             _unitOfWorkManage.BeginTran();
                             if (newLocation.LocationStatus == LocationStatusEnum.Free.ObjToInt())
                             {
                                 newLocation.LocationStatus = newSourceAddress.LocationType == (int)LocationTypeEnum.EmptyOut ? LocationStatusEnum.PalletLock.ObjToInt() : LocationStatusEnum.Lock.ObjToInt();
                             }
-                            BaseDal.AddData(dt_Task);
+                            else
+                            {
+                                return content = WebResponseContent.Instance.Error($"璇ュ簱浣峽newSourceAddress.LocationCode}鐨勮揣浣嶇姸鎬佸紓甯革紝涓嶅彲閫�");
+                            }
                             _basicService.LocationInfoService.UpdateData(newLocation);
+                            BaseDal.AddData(dt_Task);
+                           
 
                             _unitOfWorkManage.CommitTran();
 
@@ -306,6 +386,7 @@
             }
             catch (Exception ex)
             {
+                _unitOfWorkManage.RollbackTran();
                 return content = WebResponseContent.Instance.Error($"鐢熸垚鍏ュ簱浠诲姟鍑洪敊锛屽嚭閿欎俊鎭�:{ex.Message}");
                 throw;
             }
@@ -382,102 +463,153 @@
             }
         }
 
+
+        public static List<int> InventoryCode = new List<int>() { 0,1,2,4,5,6};  //0:寰呮   1锛氬悎鏍�    2锛氫笉鍚堟牸  4锛氶��璐�   5锛氳繑宸�    6锛氱壒閲�
         /// <summary>
         /// 瑙f瀽搴撳瓨
         /// </summary>
         /// <returns></returns>
-        public WebResponseContent Queryinventory2(GenerateInv generate)
+        public WebResponseContent Queryinventory(GenerateInv generate)
         {
             WebResponseContent content = new WebResponseContent();
             try
             {
-                Dt_StockInfo dt_StockInfo = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == generate.PalletCode);
-                if(dt_StockInfo == null)
+
+                string[] targetCodes = generate.PalletCode.Split("*");
+                if (targetCodes.Length == 5)
                 {
-                    
-                    string[] targetCodes = generate.PalletCode.Split("*");
-                    if(targetCodes.Length == 4)
+                    Dt_InboundOrder dt_Inbound = _inboundService.InbounOrderService.Repository.QueryFirst(x => x.OrderName == targetCodes[0]);
+
+                    bool isContained = InventoryCode.Contains(int.Parse(targetCodes[4]));
+                    if(!isContained)
                     {
-                        Dt_InboundOrder dt_Inbound = _inboundService.InbounOrderService.Repository.QueryFirst(x => x.OrderName == targetCodes[0]);
+                        return content = WebResponseContent.Instance.Error($"绗簲浣嶇墿鏂欑姸鎬佺紪鐮佽В鏋愰敊璇細{generate.PalletCode}");
+                    }
+
+                    if (dt_Inbound != null)
+                    {
+                        string PalletCodetarget = string.Join("*", targetCodes.Take(3));
+                        Dt_StockInfo dt_StockInfo = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode.Contains(PalletCodetarget));
                         if (dt_Inbound.OrderType == (int)InventoryMaterialType.鍘熸潗鏂�)   //0涓哄師鏉愭枡缂栫爜
                         {
-                            Dt_StockInfo dt_Stock = new()
-                            {
-                                PalletCode = generate.PalletCode,
-                                IsFull = true,
-                                StockStatus = (int)StockStatusEmun.缁勭洏鏆傚瓨,
-                                Creater = "WMS",
-                                CreateDate = DateTime.Now,
-                                MaterialType = (int)InventoryMaterialType.鍘熸潗鏂�,
-                                Materialweight = decimal.Parse(targetCodes[3]),
-                            };
-                            _unitOfWorkManage.BeginTran();
-                            _stockService.StockInfoService.Repository.AddData(dt_Stock);
-                            Dt_StockInfo dt_StockInfo2 = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == generate.PalletCode);
-                            string part2 = targetCodes[1].Substring(0, 2);  //瑙f瀽鐗╂枡鎵规鎵捐鎯�
-                            Dt_InboundOrder dt_Int = _inboundService.InbounOrderService.Repository.QueryFirst(x => x.UpperOrderNo == part2);
+                            List<Dt_LocationInfo> locationInfos = _basicService.LocationInfoService.Repository.QueryData(x => x.RoadwayNo == "2" && x.LocationStatus == (int)LocationStatusEnum.Free && x.Depth == 1 && x.EnableStatus == (int)EnableStatusEnum.Normal && x.LocationType == (int)LocationTypeEnum.MaterialsCube);
 
-                            Dt_StockInfoDetail dt_StockInfoDetail = new()
+                            if (dt_StockInfo == null)
                             {
-                                StockId = dt_StockInfo2.Id,
-                                MaterielCode = dt_Inbound.OrderName,    //鐗╂枡鍙�
-                                MaterielName = dt_Inbound.UpperOrderNo,    //鐗╂枡鍚嶇О
-                                OrderNo = dt_Inbound.OrderNo,        //鐗╂枡璇︽儏
-                                BatchNo = targetCodes[1].ToString(),         //鐗╂枡鎵规
-                                SerialNumber = targetCodes[2].ToString(),    //鍖呭彿
-                                BatchNoName = dt_Int.OrderNo,
-                                StockQuantity = decimal.Parse(targetCodes[3].ToString()),    //閲嶉噺
-                                OutboundQuantity = 1,    //搴忓垪鍙�
-                                Status = (int)StockStatusEmun.缁勭洏鏆傚瓨,
-                                Creater = "WMS",
-                                CreateDate = DateTime.Now,
-                            };
-                            _stockService.StockInfoDetailService.AddData(dt_StockInfoDetail);
-                            _unitOfWorkManage.CommitTran();
-                            List<Dt_LocationInfo> locationInfos = _basicService.LocationInfoService.Repository.QueryData(x => x.RoadwayNo == "2" && x.LocationStatus== (int)LocationStatusEnum.Free && x.Depth==1);
-                            if (locationInfos.Count < 50)
+                                Dt_StockInfo dt_Stock = new()
+                                {
+                                    PalletCode = generate.PalletCode,
+                                    IsFull = true,
+                                    StockStatus = (int)StockStatusEmun.缁勭洏鏆傚瓨,
+                                    Creater = "WMS",
+                                    CreateDate = DateTime.Now,
+                                    MaterialType = (int)InventoryMaterialType.鍘熸潗鏂�,
+                                    Materialweight = decimal.Parse(targetCodes[3]),
+                                    Wlstatus = int.Parse(targetCodes[4]),
+                                    Mgeneratetime=DateTime.Now,
+                                };
+                                _unitOfWorkManage.BeginTran();
+                                _stockService.StockInfoService.Repository.AddData(dt_Stock);
+                                Dt_StockInfo dt_StockInfo2 = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == generate.PalletCode);
+                                string part2 = targetCodes[1].Substring(0, 2);  //瑙f瀽鐗╂枡鎵规鎵捐鎯�
+                                Dt_InboundOrder dt_Int = _inboundService.InbounOrderService.Repository.QueryFirst(x => x.UpperOrderNo == part2);
+
+                                Dt_StockInfoDetail dt_StockInfoDetail = new()
+                                {
+                                    StockId = dt_StockInfo2.Id,
+                                    MaterielCode = dt_Inbound.OrderName,    //鐗╂枡鍙�
+                                    MaterielName = dt_Inbound.UpperOrderNo,    //鐗╂枡鍚嶇О
+                                    OrderNo = dt_Inbound.OrderNo,        //鐗╂枡璇︽儏
+                                    BatchNo = targetCodes[1].ToString(),         //鐗╂枡鎵规
+                                    SerialNumber = targetCodes[2].ToString(),    //鍖呭彿
+                                    BatchNoName = dt_Int.OrderNo,
+                                    StockQuantity = decimal.Parse(targetCodes[3].ToString()),    //閲嶉噺
+                                    OutboundQuantity = 1,    //搴忓垪鍙�
+                                    Status = (int)StockStatusEmun.缁勭洏鏆傚瓨,
+                                    Creater = "WMS",
+                                    CreateDate = DateTime.Now,
+
+                                };
+                                _stockService.StockInfoDetailService.AddData(dt_StockInfoDetail);
+                                _unitOfWorkManage.CommitTran();
+                                if (locationInfos.Count < 50)
+                                {
+                                    return content = WebResponseContent.Instance.OK(data: 1);
+                                }
+                                else
+                                {
+                                    return content = WebResponseContent.Instance.OK(data: 3);
+                                }
+                            }
+                            else
                             {
+                                if (dt_StockInfo.StockStatus == (int)StockStatusEmun.缁勭洏鏆傚瓨)
+                                {
+                                    if (locationInfos.Count < 50)
+                                    {
+                                        return content = WebResponseContent.Instance.OK(data: 1);
+                                    }
+                                    else
+                                    {
+                                        return content = WebResponseContent.Instance.OK(data: 3);
+                                    }
+                                }
+                                else
+                                {
+                                    return content = WebResponseContent.Instance.Error($"搴撳瓨宸叉湁璇ユ潯鐮侊紝鏉$爜淇℃伅锛歿generate.PalletCode}");
+                                }
+
+                            }
+                        }
+                        else if (dt_Inbound.OrderType == (int)InventoryMaterialType.鎴愬搧)
+                        {
+                            if (dt_StockInfo == null)
+                            {
+                                Dt_StockInfo dt_Stock = new()
+                                {
+                                    PalletCode = generate.PalletCode,
+                                    IsFull = true,
+                                    StockStatus = (int)StockStatusEmun.缁勭洏鏆傚瓨,
+                                    Creater = "WMS",
+                                    CreateDate = DateTime.Now,
+                                    MaterialType = (int)InventoryMaterialType.鎴愬搧,
+                                    Materialweight = decimal.Parse(targetCodes[3]),
+                                    Wlstatus = int.Parse(targetCodes[4]),
+                                    Mgeneratetime = DateTime.Now,
+                                };
+                                _unitOfWorkManage.BeginTran();
+                                _stockService.StockInfoService.Repository.AddData(dt_Stock);
+                                Dt_StockInfo dt_StockInfo2 = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == generate.PalletCode);
+                                Dt_StockInfoDetail dt_StockInfoDetail = new()
+                                {
+                                    StockId = dt_StockInfo2.Id,
+                                    MaterielCode = dt_Inbound.OrderName,    //鐗╂枡鍙�
+                                    MaterielName = dt_Inbound.UpperOrderNo,    //鐗╂枡鍚嶇О
+                                    OrderNo = dt_Inbound.OrderNo,        //鐗╂枡璇︽儏
+                                    BatchNo = targetCodes[1].ToString(),         //鐗╂枡鎵规
+                                    BatchNoName = "",
+                                    SerialNumber = targetCodes[2],    //鍖呭彿
+                                    StockQuantity = decimal.Parse(targetCodes[3]),    //閲嶉噺
+                                    OutboundQuantity = 1,    //搴忓垪鍙�
+                                    Status = (int)StockStatusEmun.缁勭洏鏆傚瓨,
+                                    Creater = "WMS",
+                                    CreateDate = DateTime.Now,
+                                };
+                                _stockService.StockInfoDetailService.AddData(dt_StockInfoDetail);
+                                _unitOfWorkManage.CommitTran();
                                 return content = WebResponseContent.Instance.OK(data: 1);
                             }
                             else
                             {
-                                return content = WebResponseContent.Instance.OK(data: 3);
+                                if (dt_StockInfo.StockStatus == (int)StockStatusEmun.缁勭洏鏆傚瓨)
+                                {
+                                    return content = WebResponseContent.Instance.OK(data: 1);
+                                }
+                                else
+                                {
+                                    return content = WebResponseContent.Instance.Error($"搴撳瓨宸叉湁璇ユ潯鐮侊紝鏉$爜淇℃伅锛歿generate.PalletCode}");
+                                }
                             }
-                            
-                        }
-                        else if (dt_Inbound.OrderType == (int)InventoryMaterialType.鎴愬搧)
-                        {
-                            Dt_StockInfo dt_Stock = new()
-                            {
-                                PalletCode = generate.PalletCode,
-                                IsFull = true,
-                                StockStatus = (int)StockStatusEmun.缁勭洏鏆傚瓨,
-                                Creater = "WMS",
-                                CreateDate = DateTime.Now,
-                                MaterialType = (int)InventoryMaterialType.鎴愬搧,
-                                Materialweight = decimal.Parse(targetCodes[3]),
-                            };
-                            _unitOfWorkManage.BeginTran();
-                            _stockService.StockInfoService.Repository.AddData(dt_Stock);
-                            Dt_StockInfo dt_StockInfo2 = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == generate.PalletCode);
-                            Dt_StockInfoDetail dt_StockInfoDetail = new()
-                            {
-                                StockId = dt_StockInfo2.Id,
-                                MaterielCode = dt_Inbound.OrderName,    //鐗╂枡鍙�
-                                MaterielName = dt_Inbound.UpperOrderNo,    //鐗╂枡鍚嶇О
-                                OrderNo = dt_Inbound.OrderNo,        //鐗╂枡璇︽儏
-                                BatchNo = targetCodes[1].ToString(),         //鐗╂枡鎵规
-                                BatchNoName = "",
-                                SerialNumber = targetCodes[2],    //鍖呭彿
-                                StockQuantity = decimal.Parse(targetCodes[3]),    //閲嶉噺
-                                OutboundQuantity = 1,    //搴忓垪鍙�
-                                Status = (int)StockStatusEmun.缁勭洏鏆傚瓨,
-                                Creater = "WMS",
-                                CreateDate = DateTime.Now,
-                            };
-                            _stockService.StockInfoDetailService.AddData(dt_StockInfoDetail);
-                            _unitOfWorkManage.CommitTran();
-                            return content = WebResponseContent.Instance.OK(data: 1);
                         }
                         else
                         {
@@ -486,23 +618,23 @@
                     }
                     else
                     {
-                        return content = WebResponseContent.Instance.Error($"瑙f瀽鐨勬墭鐩樻潯鐮侀暱搴︿笉瓒�4,鏉$爜淇℃伅锛歿generate.PalletCode}");
+                        return content = WebResponseContent.Instance.Error($"鏈壘鍒板叆搴撳崟锛屾潯鐮佷俊鎭細{generate.PalletCode}");
                     }
                     
                 }
                 else
                 {
-                    return content = WebResponseContent.Instance.Error($"宸叉湁搴撳瓨锛屽叆搴撳け璐ワ細{generate.PalletCode}");
+                    return content = WebResponseContent.Instance.Error($"瑙f瀽鐨勬墭鐩樻潯鐮侀暱搴︿笉瓒�4,鏉$爜淇℃伅锛歿generate.PalletCode}");
                 }
             }
             catch (Exception ex)
             {
-                return content=WebResponseContent.Instance.Error($"绯荤粺宸烽亾鍏ュ簱鎺ュ彛瑙f瀽閿欒锛氶敊璇細{ex.Message}");
+                return content=WebResponseContent.Instance.Error($"鎵樼洏鏉$爜閿欒锛屽鑷寸郴缁熼敊璇細{ex.Message}");
                 throw;
             }
         }
 
-        public WebResponseContent Queryinventory(GenerateInv generate)
+        public WebResponseContent Queryinventory2(GenerateInv generate)
         {
             try
             {
@@ -526,9 +658,9 @@
                         _unitOfWorkManage.BeginTran();
                         _stockService.StockInfoService.Repository.AddData(dt_Stock);
 
-                        string part2 = generate.PalletCode.Substring(2, 8);
+                        //string part2 = generate.PalletCode.Substring(2, 8);
 
-                        string part3 = generate.PalletCode.Split('#')[1];
+                        //string part3 = generate.PalletCode.Split('#')[1];
                         Dt_StockInfo dt_StockInfo2 = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == generate.PalletCode);
                         Dt_StockInfoDetail dt_StockInfoDetail = new()
                         {
@@ -557,7 +689,7 @@
                         }
                         else
                         {
-                            return content = WebResponseContent.Instance.Error();
+                            return content = WebResponseContent.Instance.Error($"搴撳瓨宸叉湁璇ユ潯鐮侊紝鏉$爜淇℃伅锛歿generate.PalletCode}");
                         }
                     }
                 }
@@ -632,7 +764,7 @@
                             }
                             else
                             {
-                                return content = WebResponseContent.Instance.Error();
+                                return content = WebResponseContent.Instance.Error($"搴撳瓨宸叉湁璇ユ潯鐮侊紝鏉$爜淇℃伅锛歿generate.PalletCode}");
                             }
                         }
 
@@ -655,7 +787,7 @@
         {
             WebResponseContent content = new WebResponseContent();
             List<Dt_LocationInfo> locationinfoData = _basicService.LocationInfoService.Repository.QueryData(x => x.RoadwayNo=="2" && x.LocationStatus == LocationStatusEnum.Free.ObjToInt() 
-            && x.LocationType == (int)LocationTypeEnum.EmptyCube);
+            && x.LocationType == (int)LocationTypeEnum.EmptyCube && x.EnableStatus == (int)EnableStatusEnum.Normal);
             if (locationinfoData.Count < 20)
             {
                 return content = WebResponseContent.Instance.OK(data: 1);

--
Gitblit v1.9.3