From 4dfe8ece141f05a163cf7d290b6fe4c520d89909 Mon Sep 17 00:00:00 2001
From: huangxiaoqiang <huangxiaoqiang@hnkhzn.com>
Date: 星期五, 31 十月 2025 17:28:33 +0800
Subject: [PATCH] 1

---
 项目代码/WMS/WIDESEA_WMSServer/WIDESEA_StorageBasicServices/Boxing/BoxingInfoService.cs |  124 ++++++++++++++++++++++++++++++++++++++---
 1 files changed, 115 insertions(+), 9 deletions(-)

diff --git "a/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WIDESEA_WMSServer/WIDESEA_StorageBasicServices/Boxing/BoxingInfoService.cs" "b/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WIDESEA_WMSServer/WIDESEA_StorageBasicServices/Boxing/BoxingInfoService.cs"
index e119110..3c9d543 100644
--- "a/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WIDESEA_WMSServer/WIDESEA_StorageBasicServices/Boxing/BoxingInfoService.cs"
+++ "b/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WIDESEA_WMSServer/WIDESEA_StorageBasicServices/Boxing/BoxingInfoService.cs"
@@ -3,10 +3,12 @@
 using SqlSugar;
 using System.ComponentModel.DataAnnotations;
 using System.Linq.Expressions;
+using System.Threading.Tasks;
 using WIDESEA_Common;
 using WIDESEA_Core.BaseRepository;
 using WIDESEA_DTO.Basic;
 using WIDESEA_IOrderRepository;
+using WIDESEA_Model.Models;
 using WIDESEA_OrderRepository;
 
 namespace WIDESEA_StorageBasicService;
@@ -60,6 +62,38 @@
     }
 
     #region 缁勭洏
+
+    public async Task<WebResponseContent> GetPalletCodeInfo(string palletCode)
+    {
+        WebResponseContent content = new WebResponseContent();
+        try
+        {
+            var boxinginfo = await BaseDal.QueryFirstNavAsync(x => x.PalletCode == palletCode);
+            if(boxinginfo != null)
+            {
+                List<PalletCodeInfo> obj = new List<PalletCodeInfo>();
+                boxinginfo.BoxingInfoDetails.ForEach(x =>
+                {
+                    obj.Add(new PalletCodeInfo
+                    {
+                        orderNo=x.OrderNo,
+                        warehouseName=x.Warehouse,
+                        materialNo = x.MaterielCode,
+                        quantity = x.Quantity,
+                    });
+                });
+                
+                return content.OK(data: obj);
+            }
+            return content.Error();
+        }
+        catch (Exception ex)
+        {
+            return content.Error(ex.Message);
+        }
+    }
+    
+
     public async Task<WebResponseContent> AddGroupPlateAsync(GroupPlate groupPlate)
     {
         WebResponseContent content = new WebResponseContent();
@@ -72,7 +106,77 @@
             var info = await BaseDal.QueryFirstAsync(x => x.PalletCode == groupPlate.palletCode);
             if (!info.IsNullOrEmpty())
             {
-                content.Error("璇ユ墭鐩樺凡瀛樺湪缁勭洏");
+                //content.Error("璇ユ墭鐩樺凡瀛樺湪缁勭洏");
+                info.StockStatus = (int)StockStateEmun.缁勭洏鎾ら攢;
+                DtBoxingInfo_Hty stockhty = info.Adapt<DtBoxingInfo_Hty>();
+                stockhty.ModifyDate = DateTime.Now;
+
+                List<DtBoxingInfoDetail> details = new List<DtBoxingInfoDetail>();
+                foreach (var item in groupPlate.groups)
+                {
+                    var InboundOrder = _inboundOrderRepository.QueryFirst(x => x.OrderNo == item.orderNo);
+
+                    if (InboundOrder != null)
+                    {
+                        var x = details.Where(x => x.MaterielCode == InboundOrder.MaterialNo && x.Warehouse == InboundOrder.WarehouseName && x.DrawingNumber == InboundOrder.ProductDrawingNumber && x.DemandClassification == InboundOrder.DemandClassification).FirstOrDefault();
+                        if (x != null)
+                        {
+                            details.Remove(x);
+                            x.MaterielCode = InboundOrder.MaterialNo;
+                            x.MaterielName = InboundOrder.MaterialName;
+                            x.DemandClassification = InboundOrder.DemandClassification;
+                            x.Warehouse = InboundOrder.WarehouseName;
+                            x.OrderNo = InboundOrder.UpperOrderNo;
+                            x.Unit = InboundOrder.Unit;
+                            x.WareHouseId = InboundOrder.WareHouseId;
+                            x.Specs = InboundOrder.Specs;
+                            x.Weight = InboundOrder.Weight;
+                            x.Quantity = x.Quantity + item.quantity;
+                            x.DrawingNumber = InboundOrder.ProductDrawingNumber;
+                            x.Date = InboundOrder.Datetime;
+                            details.Add(x);
+                        }
+                        else
+                        {
+                            DtBoxingInfoDetail detail = new DtBoxingInfoDetail()
+                            {
+                                MaterielCode = InboundOrder.MaterialNo,
+                                MaterielName = InboundOrder.MaterialName,
+                                DemandClassification = InboundOrder.DemandClassification,
+                                Warehouse = InboundOrder.WarehouseName,
+                                OrderNo = InboundOrder.UpperOrderNo,
+                                Unit = InboundOrder.Unit,
+                                Specs = InboundOrder.Specs,
+                                Weight = InboundOrder.Weight,
+                                WareHouseId = InboundOrder.WareHouseId,
+                                Quantity = item.quantity,
+                                DrawingNumber = InboundOrder.ProductDrawingNumber,
+                                Date = InboundOrder.Datetime,
+                            };
+                            details.Add(detail);
+                        }
+                    }
+                    else
+                    {
+                        return content.Error("鏈壘鍒板叆搴撳崟鎹俊鎭�");
+                    }
+                }
+                DtBoxingInfo boxing = new DtBoxingInfo()
+                {
+                    PalletCode = groupPlate.palletCode,
+                    StockStatus = (int)StockStateEmun.缁勭洏鏆傚瓨,
+                    BoxingInfoDetails = details
+                };
+                await _unitOfWorkManage.UseTranAsync(async () =>
+                {
+                    await BaseDal.Db.DeleteNav<DtBoxingInfo>(x => x.Id == info.Id)
+                                            .Include(x => x.BoxingInfoDetails)
+                                            .ExecuteCommandAsync();
+                    await AddStockHtyAsync(stockhty);
+                    await BaseDal.AddDataNavAsync(boxing);
+                });
+                content.OK("缁勭洏鎴愬姛");
+
             }
             else
             {
@@ -93,6 +197,7 @@
                             x.Warehouse = InboundOrder.WarehouseName;
                             x.OrderNo = InboundOrder.UpperOrderNo;
                             x.Unit = InboundOrder.Unit;
+                            x.WareHouseId = InboundOrder.WareHouseId;
                             x.Specs = InboundOrder.Specs;
                             x.Weight = InboundOrder.Weight;
                             x.Quantity = x.Quantity + item.quantity;
@@ -112,6 +217,7 @@
                                 Unit = InboundOrder.Unit,
                                 Specs = InboundOrder.Specs,
                                 Weight = InboundOrder.Weight,
+                                WareHouseId = InboundOrder.WareHouseId,
                                 Quantity = item.quantity,
                                 DrawingNumber = InboundOrder.ProductDrawingNumber,
                                 Date = InboundOrder.Datetime,
@@ -152,16 +258,16 @@
             {
                 return content.Error("鍙傛暟閿欒");
             }
-            var stock = await BaseDal.QueryFirstNavAsync(x => x.PalletCode == groupPlate.palletCode && x.StockStatus == (int)StockStateEmun.缁勭洏鏆傚瓨);
-            if (!stock.IsNullOrEmpty())
+            var boxingInfo = await BaseDal.QueryFirstNavAsync(x => x.PalletCode == groupPlate.palletCode);
+            if (!boxingInfo.IsNullOrEmpty())
             {
-                stock.StockStatus = (int)StockStateEmun.缁勭洏鎾ら攢;
-                DtStockInfo_Hty stockhty = stock.Adapt<DtStockInfo_Hty>();
+                boxingInfo.StockStatus = (int)StockStateEmun.缁勭洏鎾ら攢;
+                DtBoxingInfo_Hty stockhty = boxingInfo.Adapt<DtBoxingInfo_Hty>();
                 stockhty.ModifyDate = DateTime.Now;
                 await _unitOfWorkManage.UseTranAsync(async () =>
                 {
-                    await BaseDal.Db.DeleteNav<DtStockInfo>(x => x.Id == stock.Id)
-                                            .Include(x => x.StockInfoDetails)
+                    await BaseDal.Db.DeleteNav<DtBoxingInfo>(x => x.Id == boxingInfo.Id)
+                                            .Include(x => x.BoxingInfoDetails)
                                             .ExecuteCommandAsync();
                     await AddStockHtyAsync(stockhty);
                 });
@@ -178,9 +284,9 @@
             return content.Error(ex.Message);
         }
     }
-    private async Task AddStockHtyAsync(DtStockInfo_Hty stockhty)
+    private async Task AddStockHtyAsync(DtBoxingInfo_Hty stockhty)
     {
-        var isStockAdd = await SqlSugarHelper.DbWMS.InsertNav(stockhty).IncludesAllFirstLayer().ExecuteCommandAsync();
+        var isStockAdd = await SqlSugarHelper.DbWMS.InsertNav(stockhty).Include(x=>x.BoxingInfoDetails).ExecuteCommandAsync();
         if (!isStockAdd)
         {
             throw new Exception("搴撳瓨鍘嗗彶淇℃伅娣诲姞澶辫触");

--
Gitblit v1.9.3