From a95309ec158af3b95fe5b77f4f0c24208dc657e3 Mon Sep 17 00:00:00 2001 From: schangxiang@126.com <schangxiang@126.com> Date: 周四, 05 12月 2024 14:10:38 +0800 Subject: [PATCH] 22 --- LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsStockQuan/WmsStockQuan/WmsStockQuanService.cs | 88 +++++-------------------------------------- 1 files changed, 11 insertions(+), 77 deletions(-) diff --git a/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsStockQuan/WmsStockQuan/WmsStockQuanService.cs b/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsStockQuan/WmsStockQuan/WmsStockQuanService.cs index f246294..b24e962 100644 --- a/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsStockQuan/WmsStockQuan/WmsStockQuanService.cs +++ b/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsStockQuan/WmsStockQuan/WmsStockQuanService.cs @@ -5,6 +5,8 @@ using System.Web; using System.Text; using System; +using Admin.NET.Application.Service.WmsTask.WmsRbLineTask.Dto; + namespace Admin.NET.Application; /// <summary> /// 搴撳瓨淇℃伅鏈嶅姟 @@ -13,9 +15,16 @@ public class WmsStockQuanService : IDynamicApiController, ITransient { private readonly SqlSugarRepository<WmsStockQuan> _rep; - public WmsStockQuanService(SqlSugarRepository<WmsStockQuan> rep) + private readonly SqlSugarRepository<Mes_BatchOrderUPI_New> _Mes_BatchOrderUPI_New_Rep; + private readonly SqlSugarRepository<V_Station_Quan> _V_Station_Quan_Rep; + + public WmsStockQuanService(SqlSugarRepository<WmsStockQuan> rep, + SqlSugarRepository<Mes_BatchOrderUPI_New> Mes_BatchOrderUPI_New_Rep, + SqlSugarRepository<V_Station_Quan> v_Station_Quan_Rep) { _rep = rep; + _Mes_BatchOrderUPI_New_Rep = Mes_BatchOrderUPI_New_Rep; + _V_Station_Quan_Rep = v_Station_Quan_Rep; } /// <summary> @@ -219,88 +228,13 @@ throw Oops.Oh($"瀵煎叆鏁版嵁涓嶈兘涓虹┖"); } //鏍规嵁缁勫悎鏍¢獙楠岃瘉琛ㄦ牸涓腑鏄惁宸插瓨鍦ㄧ浉鍚屾暟鎹� - - - - - - - - //鏍规嵁鍗曠嫭鏍¢獙楠岃瘉琛ㄦ牸涓腑鏄惁宸插瓨鍦ㄧ浉鍚屾暟鎹� - - } #endregion - /// <summary> - /// 涓嶅垎椤垫煡璇㈤綈鍖呯鐞� - /// </summary> - /// <param name="input"></param> - /// <returns></returns> - [HttpGet] - [ApiDescriptionSettings(Name = "packList")] - [Description("WmsStockQuan/packList")] - public async Task<List<WmsPackListOutput>> packList([FromQuery] PackListInput input) - { - // 鏌ヨ骞惰浆鎹负 WmsKittingListOutput 瀵硅薄鐨勫垪琛� - var list = await _rep.AsQueryable() - .WhereIF(!string.IsNullOrWhiteSpace(input.DetailName), u => u.PlaceCode.Contains(input.DetailName.Trim())) - .Select(x => new WmsPackListOutput - { - PackageCode = x.PackageCode, - // 鏄犲皠鍏朵粬瀛楁 - }) - .ToListAsync(); // 纭繚鑾峰彇缁撴灉涓� List - // 鍒嗙粍骞惰繑鍥炲垎缁勪俊鎭� - var groupedResult = list - .GroupBy(x => x.PackageCode) // 鎸� PackageCode 鍒嗙粍 - .Select(g => new WmsPackListOutput - { - PackageCode = g.Key, // 鑾峰彇鍒嗙粍鐨勯敭 - Count = g.Count(), // 缁熻姣忕粍鐨勬暟閲� - IsPack = g.Count() == 5 ? true : false // 濡傛灉 Count 涓� 5 鍒� IsKitting 涓� 1锛屽惁鍒欎负 0 - }) - .WhereIF(input.IsPack.HasValue, u => u.IsPack == input.IsPack) - .OrderBy(g => g.PackageCode) // 鏍规嵁 PackageCode 鎺掑簭 - .ToList(); // 杞崲涓� List - return groupedResult; // 杩斿洖鍒嗙粍缁撴灉 - } - - - /// <summary> - /// 涓嶅垎椤垫煡璇㈤綈濂楃鐞� - /// </summary> - /// <param name="input"></param> - /// <returns></returns> - [HttpGet] - [ApiDescriptionSettings(Name = "KittingList")] - [Description("WmsStockQuan/KittingList")] - public async Task<List<WmsKittingListOutput>> KittingList([FromQuery] KittingListInput input) - { - var list = await _rep.AsQueryable() - .WhereIF(!string.IsNullOrWhiteSpace(input.DetailName), u => u.PlaceCode.Contains(input.DetailName.Trim())) - .Select(x => new WmsKittingListOutput - { - OrderId = x.OrderId - }) - .ToListAsync(); // 纭繚鑾峰彇缁撴灉涓� List - // 鍒嗙粍骞惰繑鍥炲垎缁勪俊鎭� - var groupedResult = list - .GroupBy(x => x.OrderId) // 鎸� PackageCode 鍒嗙粍 - .Select(g => new WmsKittingListOutput - { - OrderId = g.Key, // 鑾峰彇鍒嗙粍鐨勯敭 - Count = g.Count(), // 缁熻姣忕粍鐨勬暟閲� - IsKitting = g.Count() == 5 ? true : false // 濡傛灉 Count 涓� 5 鍒� IsKitting 涓� 1锛屽惁鍒欎负 0 - }) - .WhereIF(input.IsKitting.HasValue, u => u.IsKitting == input.IsKitting) - .OrderBy(g => g.OrderId) // 鏍规嵁 PackageCode 鎺掑簭 - .ToList(); // 杞崲涓� List - return groupedResult; // 杩斿洖鍒嗙粍缁撴灉 - } + } -- Gitblit v1.9.3