| | |
| | | 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(); |
| | | |