public async Task <IActionResult> GetRfCateringShopPageList([FromQuery] RfCateringShopView model, int pageIndex = 1, int pageSize = 10) { var totalCount = 0; var r = await _cache.GetOrCreate($"RfCateringShopController_GetRfCateringShopPageList_{model.GetHashCode()}_{pageIndex}_{pageSize})".ToLower(), async (entry) => { var list = await _server.GetRfCateringShopPageList(model, ref totalCount, pageIndex, pageSize); entry.SetAbsoluteExpiration(TimeSpan.FromSeconds(30)); return(list); }); return(OkResult(r, totalCount)); }
/// <summary> /// 获取餐饮店列表 /// </summary> /// <param name="search"></param> /// <param name="orderByStr"></param> /// <param name="totalCount"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public Task <List <RfCateringShopEntity> > FindRfCateringShopPageList(RfCateringShopView search, string orderByStr, ref int totalCount, int pageIndex = 1, int pageSize = 10) { return(Db.Queryable <RfCateringShopEntity>() .WhereIF(!search.Title.IsNullOrWhiteSpace(), t1 => t1.Title.Contains(search.Title)) .WhereIF(!search.Category.IsNullOrWhiteSpace(), t1 => t1.Category.Contains(search.Category)) .WhereIF(!search.Address.IsNullOrWhiteSpace(), t1 => t1.Address.Contains(search.Address)) .WhereIF(!search.Province.IsNullOrWhiteSpace(), t1 => t1.Province.Contains(search.Province)) .WhereIF(!search.City.IsNullOrWhiteSpace(), t1 => t1.City.Contains(search.City)) .WhereIF(!search.District.IsNullOrWhiteSpace(), t1 => t1.District.Contains(search.District)) .OrderBy(orderByStr) .ToPageListAsync(pageIndex, pageSize, totalCount)); }
/// <summary> /// 查询餐饮店信息 /// </summary> /// <param name="search"></param> /// <param name="totalCount"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="orderByStr">默认主键倒序</param> /// <returns></returns> public Task <List <RfCateringShopEntity> > GetRfCateringShopPageList(RfCateringShopView search, ref int totalCount, int pageIndex = 1, int pageSize = 10, string orderByStr = "id desc") { return(_rfCateringShopRepository.FindRfCateringShopPageList(search, orderByStr, ref totalCount, pageIndex, pageSize)); }