| | |
|---|
| | | // 获取符合条件的记录，并提取所需信息 |
|---|
| | | var list = await _wmsStockQuanRep.AsQueryable() |
|---|
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.PackageCode), u => u.PackageCode.Contains(input.PackageCode.Trim())) |
|---|
| | | .Select(x => new { x.PackageCode }) |
|---|
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.PlanNo), u => u.PlanNo.Contains(input.PlanNo.Trim())) |
|---|
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.OrderId), u => u.OrderId.Contains(input.OrderId.Trim())) |
|---|
| | | .Select(x => new { x.PackageCode, x.PlanNo, x.OrderId }) |
|---|
| | | .ToListAsync(); |
|---|
| | | |
|---|
| | | // 创建一个列表以存储 WmsPackListOutput |
|---|
| | | var resultList = new List<WmsPackListOutput>(); |
|---|
| | | |
|---|
| | | // 分组并计算每组信息 |
|---|
| | | var groupedResult = list.GroupBy(x => x.PackageCode); |
|---|
| | | var groupedResult = list.GroupBy(x => new { x.PackageCode, x.PlanNo, x.OrderId }); |
|---|
| | | |
|---|
| | | foreach (var g in groupedResult) |
|---|
| | | { |
|---|
| | | // 在这里计算每组的总数 |
|---|
| | | var count = g.Count(); |
|---|
| | | var mesTotalCount = await _mesBatchOrderUpiRep.AsQueryable().CountAsync(m => m.PackageCode == g.Key); |
|---|
| | | var mesTotalCount = await _mesBatchOrderUpiRep.AsQueryable().CountAsync(m => m.PackageCode == g.Key.PackageCode); |
|---|
| | | |
|---|
| | | resultList.Add(new WmsPackListOutput |
|---|
| | | { |
|---|
| | | PackageCode = g.Key, |
|---|
| | | PackageCode = g.Key.PackageCode, |
|---|
| | | PlanNo = g.Key.PlanNo, |
|---|
| | | OrderId = g.Key.OrderId, |
|---|
| | | Count = count, |
|---|
| | | MesTotalCount = mesTotalCount, |
|---|
| | | IsPack = count >= mesTotalCount, // 检查是否打包 |
|---|
