| | |
| | | if (decimals.Count == 0) |
| | | return new List<VOrderBycl>(); |
| | | |
| | | //如果有工单ID |
| | | var numericalList = Db.Queryable<MesNumericalBycl>() |
| | | .Where(x => ids.Contains(x.OrderId ?? 0)) |
| | | .OrderBy(x => x.CjTiem) |
| | | .ToList(); |
| | | |
| | | var vOrderBycl = new VOrderBycl(); |
| | | if (numericalList.Count > 0) |
| | | { |
| | | // 开工数采:最早一条 |
| | | var firstNum = numericalList.First().CjNum ?? 0; |
| | | var lastNum = numericalList.Last().CjNum ?? 0; |
| | | // 需要有对象引用,假设你有一个 VOrderBycl 类型的对象,比如 vOrderBycl |
| | | |
| | | vOrderBycl.StartCjNum = firstNum; |
| | | vOrderBycl.CurrentCjNum = lastNum; |
| | | } |
| | | else |
| | | { |
| | | vOrderBycl.StartCjNum = 0; |
| | | vOrderBycl.CurrentCjNum = 0; |
| | | } |
| | | |
| | | var startCjNum = vOrderBycl.StartCjNum; |
| | | var currentCjNum = vOrderBycl.CurrentCjNum; |
| | | |
| | | // 查询工单视图,筛选出需要显示的工单 |
| | | return Db.Queryable<VOrderBycl>() |
| | | var orders = Db.Queryable<VOrderBycl>() |
| | | .Where(c => |
| | | decimals.Contains(c.ID) && |
| | | (c.EditDate == date || c.EditDate == null)) |
| | | .ToList(); |
| | | |
| | | foreach (var order in orders) |
| | | { |
| | | order.StartCjNum = startCjNum; |
| | | order.CurrentCjNum = currentCjNum; |
| | | } |
| | | |
| | | return orders; |
| | | } |
| | | |
| | | /// <summary> |