/// <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 <RfChooseFoodEntity> > FindRfChooseFoodPageList(RfChooseFoodView search, string orderByStr, ref int totalCount, int pageIndex = 1, int pageSize = 10) { return(Db.Queryable <RfChooseFoodEntity>() .WhereIF(!search.OpenId.IsNullOrWhiteSpace(), t1 => t1.OpenId == search.OpenId) .WhereIF(!search.FoodName.IsNullOrWhiteSpace(), t1 => t1.FoodName.Contains(search.FoodName)) .OrderBy(orderByStr) .ToPageListAsync(pageIndex, pageSize, totalCount)); }
public async Task <IActionResult> GetRfChooseFoodPageList([FromQuery] RfChooseFoodView model, int pageIndex = 1, int pageSize = 10) { var totalCount = 0; if (model.OpenId.IsNullOrWhiteSpace()) { return(OkResult(new List <RfChooseFoodEntity>(), totalCount)); } var r = await _cache.GetOrCreate($"RfChooseFoodController_GetRfChooseFoodPageList_{model.GetHashCode()}_{pageIndex}_{pageSize})".ToLower(), async (entry) => { var list = await _server.GetRfChooseFoodPageList(model, ref totalCount, pageIndex, pageSize); entry.SetAbsoluteExpiration(TimeSpan.FromSeconds(30)); return(list); }); return(OkResult(r.Select(t => new { t.FoodName, t.FoodId, CreateTime = Utils.L2DSecond(t.CreateTime).ToString("yyyy/MM/dd HH:mm:ss") }), 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 <RfChooseFoodEntity> > GetRfChooseFoodPageList(RfChooseFoodView search, ref int totalCount, int pageIndex = 1, int pageSize = 10, string orderByStr = "id desc") { return(_rfChooseFoodRepository.FindRfChooseFoodPageList(search, orderByStr, ref totalCount, pageIndex, pageSize)); }