From c6e8b600398de38b6684f5fa1eaaaade8562859b Mon Sep 17 00:00:00 2001 From: wangxinhui <wangxinhui@hnkhzn.com> Date: 星期六, 20 九月 2025 15:16:56 +0800 Subject: [PATCH] Merge branch 'master' of http://115.159.85.185:8098/r/ZhiHuiQiCe/LongDeLiLiKu --- 项目代码/WMS/WMSServices/WIDESEA_StockService/ProStockViewService.cs | 34 ++++++---------------------------- 1 files changed, 6 insertions(+), 28 deletions(-) diff --git "a/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WMSServices/WIDESEA_StockService/ProStockViewService.cs" "b/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WMSServices/WIDESEA_StockService/ProStockViewService.cs" index 963efed..c10586d 100644 --- "a/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WMSServices/WIDESEA_StockService/ProStockViewService.cs" +++ "b/\351\241\271\347\233\256\344\273\243\347\240\201/WMS/WMSServices/WIDESEA_StockService/ProStockViewService.cs" @@ -54,14 +54,11 @@ List<SearchParameters> searchParametersList = options.Wheres.DeserializeObject<List<SearchParameters>>(); if (searchParametersList.Count > 0) { + SearchParameters? searchParameters1 = searchParametersList.FirstOrDefault(x => x.Name == nameof(Dt_ProStockInfoDetail.ProductCode).FirstLetterToLower()); + if (searchParameters1 != null) { - SearchParameters? searchParameters = searchParametersList.FirstOrDefault(x => x.Name == nameof(Dt_ProStockInfoDetail.ProductCode).FirstLetterToLower()); - if (searchParameters != null) - { - sugarQueryable1 = sugarQueryable1.Where(x => x.proStockInfoDetails.Any(v => v.ProductCode.Contains(searchParameters.Value))); - } + sugarQueryable1 = sugarQueryable1.Where(x => x.proStockInfoDetails.Any(v => v.ProductCode.Contains(searchParameters1.Value))); } - } } @@ -81,7 +78,7 @@ { ProStockAttribute=b.ProStockAttribute, LocationCode = b.LocationCode, - Column = a.Column, + Column = a.Columns, WarehouseId = b.WarehouseId, CreateDate = b.CreateDate, Creater = b.Creater, @@ -100,29 +97,10 @@ SumStocks=b.proStockInfoDetails.Sum(x=>x.StockQty) }); - var pklist = sugarQueryable1.Where(b => b.LocationCode == "鎴愬搧寰呭彂璐у尯" || b.LocationCode == "鎴愬搧鍖呰鎷h揣鍖�").Select(b => new ProStockViewDTO - { - ProStockAttribute = b.ProStockAttribute, - LocationCode = b.LocationCode, - WarehouseId = b.WarehouseId, - CreateDate = b.CreateDate, - Creater = b.Creater, - LocationName = b.LocationCode, - Modifier = b.Modifier, - ModifyDate = b.ModifyDate, - PalletCode = b.PalletCode, - StockRemark = b.Remark, - ProStockId = b.Id, - StockStatus = b.StockStatus, - Details = b.proStockInfoDetails, - SumStocks = b.proStockInfoDetails.Sum(x => x.StockQty) - }); - int totalCount = 0; int pktotalCount = 0; stockViewDTOs = list.ToPageList(options.Page, options.Rows, ref totalCount); - stockViewDTOs.AddRange(pklist.ToPageList(options.Page, options.Rows, ref pktotalCount)); stockViewDTOs.ForEach(x => { @@ -214,7 +192,7 @@ { ProStockAttribute = b.ProStockAttribute, LocationCode = b.LocationCode, - Column = a.Column, + Column = a.Columns, WarehouseId = b.WarehouseId, CreateDate = b.CreateDate, Creater = b.Creater, @@ -294,7 +272,7 @@ { if (userRole.WarehouseIds.Count > 0) { - return $"{nameof(BaseWarehouseEntity.WarehouseId)} in ({userRole.WarehouseIds.Serialize().Replace("[", "").Replace("]", "")})"; + return $"{nameof(BaseWarehouseEntity.WarehouseId)} in ({userRole.WarehouseIds.OrderBy(x=>x).Serialize().Replace("[", "").Replace("]", "")})"; } else -- Gitblit v1.9.3