| | |
| | | public List<VOrdreBycl> GetWomdaasByEngineeringNo(OrderMachineDto query) |
| | | { |
| | | var list = VOrders(query); |
| | | var vOrders = list.GroupBy(p => p.cutterId) |
| | | .Select(g => g.First()).ToList(); |
| | | return vOrders; |
| | | |
| | | // 增加状态筛选 |
| | | if (query.OrderStatus != null && query.OrderStatus.Any()) |
| | | { |
| | | Console.WriteLine("收到OrderStatus参数: " + string.Join(",", query.OrderStatus ?? Array.Empty<string>())); |
| | | Console.WriteLine("所有工单状态: " + string.Join(",", list.Select(x => x.Daa018 ?? "").Distinct())); |
| | | list = list.Where(p => p.Daa018 != null && query.OrderStatus.Contains(p.Daa018)).ToList(); |
| | | } |
| | | |
| | | // 去掉模具分组,直接返回筛选结果 |
| | | return list; |
| | | } |
| | | |
| | | /// <summary> |
| | |
| | | private List<VOrdreBycl> VOrders(OrderMachineDto query) |
| | | { |
| | | var list = Db.Queryable<VOrdreBycl>() |
| | | .Where(s => s.Daa018 != "完工" && |
| | | s.MachineNo == query.machineNo |
| | | ) |
| | | .Where(s => s.MachineNo == query.machineNo) |
| | | .Select(s => new VOrdreBycl |
| | | { |
| | | ID = s.ID, |
| | | cutterId = s.cutterId, |
| | | cutterName = s.cutterName, |
| | | cutterModel = s.cutterModel |
| | | cutterModel = s.cutterModel, |
| | | Daa018 = s.Daa018 // 确保状态字段被映射 |
| | | }) |
| | | .ToList(); |
| | | |
| | | // 查询指定机器的工单 |
| | | var orders = Db.Queryable<VOrderABycl>() |
| | | .Where(s => s.MachineNo == query.machineNo) |
| | | .Select<VOrdreBycl>(s => new VOrdreBycl |
| | |
| | | ID = s.ID, |
| | | cutterId = s.cutterId, |
| | | cutterName = s.cutterName, |
| | | cutterModel = s.cutterModel |
| | | cutterModel = s.cutterModel, |
| | | Daa018 = s.Daa018 |
| | | }) |
| | | .ToList(); |
| | | |