打印

liuying

2024-11-27 47852462c8585d6a7c772c05c50072eed62e8e62

 LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsStockQuan/WmsStockQuan/WmsStockQuanService.cs

@@ -371,6 +371,52 @@
        };
    }


    /// <summary>
    /// 分页查询缺料清单 不齐包 -按照生产单号分组 
    /// </summary>
    /// <param name="input"></param>
    /// <returns></returns>
    [HttpPost]
    [ApiDescriptionSettings(Name = "ShortagePageGroupByInfo5")]
    [Description("WmsStockQuan/ShortagePageGroupByInfo5")]
    public async Task<SqlSugarPagedList<WmsShortageListOutput>> ShortagePageGroupByInfo5(KittingListInput input)
    {
        var listRes = await GetShortageListCore(input);

        // 按照字段 Info5 分组
        var groupedList = listRes
            .GroupBy(x => x.Info5) // 根据 Info5 字段进行分组
            .Select(g => new WmsShortageListOutput // 假设您将分组后的结果转换为 WmsShortageListOutput
            {
                Info5 = g.Key,
                ShortageCount = g.Count(),
            })
            .ToList();

        // 进行分页处理
        var totalCount = groupedList.Count; // 获取总数
        var pagedList = groupedList
            //.OrderBy(x => x.Id) // 根据需要进行排序
            .Skip((input.Page - 1) * input.PageSize)
            .Take(input.PageSize)
            .ToList();

        // 构造并返回分页结果
        return new SqlSugarPagedList<WmsShortageListOutput>
        {
            Page = input.Page,
            PageSize = input.PageSize,
            Total = totalCount,
            TotalPages = (int)Math.Ceiling((double)totalCount / input.PageSize),
            Items = pagedList,
            HasPrevPage = input.Page > 1,
            HasNextPage = input.Page < ((int)Math.Ceiling((double)totalCount / input.PageSize))
        };
    }



    /// <summary>
    /// 缺包数据
    /// </summary>
@@ -400,7 +446,9 @@
                    PackageCode = item.PackageCode,
                    DetailName = item.DetailName,
                    OrderId = item.OrderId,
                    PlanNo = item.PlanNo
                    PlanNo = item.PlanNo,
                    Info5= item.Info5,
                    Info16 = item.Info16,
                });
            }
        }