| | |
| | | const string IsSchoolID = "IsShoodsID:"; |
| | | const string IsSchoolMangerID = "IsSchoolManger:"; |
| | | const string IsDeliverManageKey = "IsDeliverManageKey:"; |
| | | private readonly ISqlSugarClient _CyDbClient; |
| | | private readonly IUnitOfWork _UnitOfWork; |
| | | private readonly ISqlSugarClient _CyDbClient; |
| | | private readonly IHttpContextUser _User; |
| | | private readonly ICoreCmsUserServices _coreCmsUserServices; |
| | | private readonly IRedisOperationRepository _redisOperationRepository; |
| | |
| | | IRedisOperationRepository redisOperationRepository, ICoreCmsUserServices coreCmsUser) |
| | | { |
| | | |
| | | _UnitOfWork = unitOfWork; |
| | | |
| | | _CyDbClient = unitOfWork.GetDbClient().GetConnection(AppSettingsConstVars.CYDbDbID); |
| | | _User = contextUser; |
| | | _coreCmsUserServices = coreCmsUserServices; |
| | |
| | | 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 |
| | | { |