/// <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 <RfChooseShopEntity> > FindRfChooseShopPageList(RfChooseShopView search, string orderByStr, ref int totalCount, int pageIndex = 1, int pageSize = 10) { return(Db.Queryable <RfChooseShopEntity>() .WhereIF(!search.OpenId.IsNullOrWhiteSpace(), t1 => t1.OpenId == search.OpenId) .WhereIF(!search.CateringShopTitle.IsNullOrWhiteSpace(), t1 => t1.CateringShopTitle.Contains(search.CateringShopTitle)) .OrderBy(orderByStr) .ToPageListAsync(pageIndex, pageSize, totalCount)); }
public async Task <IActionResult> GetRfChooseShopPageList([FromQuery] RfChooseShopView model, int pageIndex = 1, int pageSize = 10) { var totalCount = 0; if (model.OpenId.IsNullOrWhiteSpace()) { return(OkResult(new List <RfChooseShopEntity>(), totalCount)); } var r = await _cache.GetOrCreate($"RfChooseShopController_GetRfChooseShopPageList_{model.GetHashCode()}_{pageIndex}_{pageSize})".ToLower(), async (entry) => { var list = await _server.GetRfChooseShopPageList(model, ref totalCount, pageIndex, pageSize); entry.SetAbsoluteExpiration(TimeSpan.FromSeconds(5)); return(list); }); var rr = r.Select(t => new { Category = t.Category.Replace("美食:", ""), t.CateringShopTitle, CreateTime = Utils.L2DSecond(t.CreateTime).ToString("yyyy/MM/dd HH:mm:ss") }); return(OkResult(rr, 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 <RfChooseShopEntity> > GetRfChooseShopPageList(RfChooseShopView search, ref int totalCount, int pageIndex = 1, int pageSize = 10, string orderByStr = "id desc") { return(_rfChooseShopRepository.FindRfChooseShopPageList(search, orderByStr, ref totalCount, pageIndex, pageSize)); }