From aa5a0ac9a7d35d3a072fbe164ded24adbaa68b17 Mon Sep 17 00:00:00 2001
From: dengjunjie <dengjunjie@hnkhzn.com>
Date: 星期二, 04 十一月 2025 12:29:05 +0800
Subject: [PATCH] Merge branch 'master' of http://115.159.85.185:8098/r/ZhiHuiQiCe/FangCangZhiNeng

---
 新建文件夹/WIDESEA_WMSServer/WIDESEA_SquareCabinServices/InventoryServices.cs |   77 +++++++++++++++++++++++---------------
 1 files changed, 47 insertions(+), 30 deletions(-)

diff --git "a/\346\226\260\345\273\272\346\226\207\344\273\266\345\244\271/WIDESEA_WMSServer/WIDESEA_SquareCabinServices/InventoryServices.cs" "b/\346\226\260\345\273\272\346\226\207\344\273\266\345\244\271/WIDESEA_WMSServer/WIDESEA_SquareCabinServices/InventoryServices.cs"
index d0f0bb3..ec8fbe9 100644
--- "a/\346\226\260\345\273\272\346\226\207\344\273\266\345\244\271/WIDESEA_WMSServer/WIDESEA_SquareCabinServices/InventoryServices.cs"
+++ "b/\346\226\260\345\273\272\346\226\207\344\273\266\345\244\271/WIDESEA_WMSServer/WIDESEA_SquareCabinServices/InventoryServices.cs"
@@ -1,12 +1,7 @@
 锘縰sing HslCommunication;
-using MailKit.Search;
 using Newtonsoft.Json;
-using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Reflection.Metadata;
-using System.Text;
-using System.Threading.Tasks;
+using SqlSugar;
+using WIDESEA_Common;
 using WIDESEA_Common.OrderEnum;
 using WIDESEA_Common.StockEnum;
 using WIDESEA_Common.TaskEnum;
@@ -31,11 +26,15 @@
         private readonly ICabinOrderServices _cabinOrderServices;
         private readonly IDeliveryOrderServices _deliveryOrderServices;
         private readonly ISupplyTaskService _supplyTaskService;
-        public InventoryServices(IRepository<Dt_Inventory> BaseDal, ICabinOrderServices cabinOrderServices, IDeliveryOrderServices deliveryOrderServices, ISupplyTaskService supplyTaskService) : base(BaseDal)
+        private readonly IInventory_BatchServices _inventoryBatchServices;
+        private readonly IMessageInfoService _infoService;
+        public InventoryServices(IRepository<Dt_Inventory> BaseDal, ICabinOrderServices cabinOrderServices, IDeliveryOrderServices deliveryOrderServices, ISupplyTaskService supplyTaskService, IInventory_BatchServices inventoryBatchServices, IMessageInfoService infoService) : base(BaseDal)
         {
             _cabinOrderServices = cabinOrderServices;
             _deliveryOrderServices = deliveryOrderServices;
             _supplyTaskService = supplyTaskService;
+            _inventoryBatchServices = inventoryBatchServices;
+            _infoService = infoService;
         }
 
         /// <summary>
@@ -45,50 +44,68 @@
         /// <param name="batch_num">鎵瑰彿</param>
         /// <returns></returns>
         /// <exception cref="NotImplementedException"></exception>
-        public WebResponseContent GetInventoryList(string goods_no, string batch_num)
+        public WebResponseContent GetInventoryList(int[] key)
         {
             var responseContent = new WebResponseContent();
             try
             {
-                var url = "http://121.37.118.63/GYZ2/95fck/repositoryInfo";
-                var result = HttpHelper.Post(url, new { goods_no, batch_num }.ToJsonString());
 
-                var response = JsonConvert.DeserializeObject<UpstreamResponse<InventoryInfo>>(result);
+                List<Dt_Inventory_Batch> UpdateBatches = new List<Dt_Inventory_Batch>();
+                //鏍规嵁id鏌ヨ搴撳瓨鎵规淇℃伅琛紝鑾峰彇鍒颁粬浠殑鍟嗗搧缂栫爜鍜屾壒娆″彿
+                var inventoryBatches = _inventoryBatchServices.Repository.QueryData(); //鏌ュ叏閮�
 
-                if (response.resultCode != "0")
+                var inventory = inventoryBatches.Where(x => key.Contains(x.Id)).Select(x => new { x.MaterielCode, x.BatchNo }).ToList();
+                if (inventory.Count < 1)
                 {
-                    //SendErrorToUpstream(8, "", response.resultMsg ?? "涓婃父鎺ュ彛杩斿洖澶辫触", "");
-                    return responseContent.Error(response.resultMsg ?? "涓婃父鎺ュ彛杩斿洖澶辫触");
+                    return WebResponseContent.Instance.Error("娌℃湁鎵惧埌搴撳瓨鎵规淇℃伅");
                 }
 
-                if (response.data == null || !response.data.Any())
-                {
-                    return responseContent.OK("鏃犳柊搴撳瓨鏁版嵁");
-                }
+                var requestData = inventory.Select(x => new { goods_no = x.MaterielCode, batch_num = x.BatchNo }).Distinct().ToList();
 
-                Db.Ado.BeginTran();
-                foreach (var item in response.data)
+                foreach (var item in requestData)
                 {
-                    // 浣跨敤 FirstOrDefault 閬垮厤鎵句笉鍒拌褰曟椂鎶涘嚭寮傚父
-                    var Inver = Db.Queryable<Dt_Inventory_Batch>()
-                        .First(x => x.MaterielCode == item.goods_no && x.BatchNo == item.batch_num);
+                   
+                    var url = "http://127.0.0.1:4523/m2/5660322-5340849-default/370999979?apifoxApiId=370999979";
+                    var result = HttpHelper.Post(url, new { item.goods_no, item.batch_num }.ToJsonString());
 
-                    if (Inver != null)
+                    var response = JsonConvert.DeserializeObject<UpstreamResponse<InventoryInfo>>(result);
+
+                    if (response.resultCode != "0")
                     {
-                        Inver.ERPStockQuantity = item.business_qty;
-                        Db.Updateable(Inver).ExecuteCommand();
+                        //return responseContent.Error(response.resultMsg ?? "涓婃父鎺ュ彛杩斿洖澶辫触");
+                        _infoService.AddMessageInfo(MessageGroupByEnum.SynchronismAlarm, "Erp鍚屾澶辫触", "涓婃父鎺ュ彛杩斿洖澶辫触");
+                        continue;
+                        
+                    }
+
+                    if (response.data == null || !response.data.Any())
+                    {
+                        return responseContent.OK("鏃犳柊搴撳瓨鏁版嵁");
+                    }
+                    var materialCodes = response.data.Select(x => x.goods_no).Distinct().ToList();
+                    var batchNos = response.data.Select(x => x.batch_num).Distinct().ToList();
+                    foreach (var inventoryInfo in response.data)
+                    {
+                        //// 浣跨敤 FirstOrDefault 閬垮厤鎵句笉鍒拌褰曟椂鎶涘嚭寮傚父
+                        var Inver = inventoryBatches.FirstOrDefault(x => x.MaterielCode == item.goods_no && x.BatchNo == item.batch_num);
+
+                        if (Inver != null)
+                        {
+                            Inver.ERPStockQuantity = inventoryInfo.business_qty;
+                            UpdateBatches.Add(Inver);
+                        }
                     }
                 }
-                Db.Ado.CommitTran();
+                _inventoryBatchServices.UpdateData(UpdateBatches);
                 return responseContent.OK("搴撳瓨淇℃伅鍚屾瀹屾垚");
+
             }
             catch (Exception ex)
             {
-                Db.Ado.RollbackTran();
-                //SendErrorToUpstream(8, "", ex.Message, "");
                 return responseContent.Error("鍚屾澶辫触: " + ex.Message);
             }
         }
+     
 
 
         public ApiResponse<Dt_InventoryInfo> OrderFeedback(EdiOrderCallbackRequest request)

--
Gitblit v1.9.3