| | |
| | | deliverOrder = SqlFunc.Subqueryable<CoreDeliverOrder>().Where(x => x.OrderId == n.id |
| | | && x.OrderState != CoreDeliverOrderType.Faile |
| | | && x.OrderState != CoreDeliverOrderType.Completed |
| | | && (x.DeliveryMoble != "" && x.DeliveryMoble != null)).OrderByDesc(x => x.CreateTime).First() |
| | | && (x.DeliveryMoble != "" && x.DeliveryMoble != null)).OrderByDesc(x => x.CreateTime).First(), |
| | | MakeTime = SqlFunc.Subqueryable<CoreDeliverOrder>().Where(x => x.OrderId == n.id |
| | | && x.OrderState != CoreDeliverOrderType.Faile |
| | | && x.OrderState != CoreDeliverOrderType.Completed |
| | | && (x.DeliveryMoble != "" && x.DeliveryMoble != null)).OrderByDesc(x => x.CreateTime).Select(x=>x.MakeTime) |
| | | }, |
| | | |
| | | true |
| | | ).MergeTable().Where(where).ToPageListAsync(entity.page, entity.limit, totalNumbe); |
| | | ).MergeTable().Where(where).OrderBy(n=>n.MakeTime).ToPageListAsync(entity.page, entity.limit, totalNumbe); |
| | | |
| | | var data = dlist.Select(x => new |
| | | { |
| | |
| | | } |
| | | |
| | | , true |
| | | ).MergeTable().Where(where).ToPageListAsync(entity.page, entity.limit, totalNumbe); |
| | | ).MergeTable().Where(where).OrderBy(x=>x.MakeTime).ToPageListAsync(entity.page, entity.limit, totalNumbe); |
| | | |
| | | var deliveryList = await _CyDbClient.Queryable<OA_Staff>().Where(x => x.Status == "在职" && x.BF_IsDriver == true).Select(x => new |
| | | { |