public async Task <PagedResult <AreaOfferDto> > SearchPAreaOffersAsync(AreaOfferFilter filters) { if (filters == null)//110000 { return(new PagedResult <AreaOfferDto>()); } var parent = await FindAllByParentId(filters.AreaId); var query = _context.AreaOffers .WhereIf(filters.AreaId.IsNotBlank(), x => x.AreaId == filters.AreaId || x.AreaId.StartsWith(GetParentAreaId(filters.AreaId))); return(await query.OrderByDescending(x => x.CreateDateTime) .Select(item => new AreaOfferDto { Id = item.Id, AreaId = item.AreaId, AreaName = parent == null?string.Empty: (parent.FirstOrDefault(c => c.id == item.AreaId) == null?string.Empty: parent.FirstOrDefault(c => c.id == item.AreaId).name), //AreaName = parent?.FirstOrDefault(c=>c.id==item.AreaId)?.name??string.Empty, A1OfferPrice = item.A1OfferPrice, A2OfferPrice = item.A2OfferPrice, A3OfferPrice = item.A3OfferPrice, B1OfferPrice = item.B1OfferPrice, B2OfferPrice = item.B2OfferPrice, C1OfferPrice = item.C1OfferPrice, C2OfferPrice = item.C2OfferPrice, C3OfferPrice = item.C3OfferPrice, C4OfferPrice = item.C4OfferPrice, DOfferPrice = item.DOfferPrice, EOfferPrice = item.EOfferPrice, FOfferPrice = item.FOfferPrice, MOfferPrice = item.MOfferPrice, NOfferPrice = item.NOfferPrice, POfferPrice = item.POfferPrice, CreateDateTime = item.CreateDateTime }).PagingAsync(filters.page, filters.rows)); }
/// <summary> /// 获取票价值 /// </summary> //[HttpPost, IgnoreRightFilter] public async Task <ActionResult> AreaOfferPriceList(AreaOfferFilter model) { var pages = await _areaService.SearchPAreaOffersAsync(model); return(Json(pages)); }