public async Task <IActionResult> GetRfPhoneDevicePageList([FromQuery] RfPhoneDeviceView model, int pageIndex = 1, int pageSize = 10)
{
var totalCount = 0;
var r = await _cache.GetOrCreate($"RfPhoneDeviceController_GetRfPhoneDevicePageList_{model.GetHashCode()}_{pageIndex}_{pageSize})".ToLower(), async (entry) =>
{
var list = await _server.GetRfPhoneDevicePageList(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<RfPhoneDeviceEntity>> FindRfPhoneDevicePageList(RfPhoneDeviceView search, string orderByStr, ref int totalCount, int pageIndex = 1, int pageSize = 10)
{
return Db.Queryable<RfPhoneDeviceEntity>()
.WhereIF(!search.OpenId.IsNullOrWhiteSpace(), t1 => t1.OpenId.Contains(search.OpenId))
.WhereIF(!search.Brand.IsNullOrWhiteSpace(), t1 => t1.Brand.Contains(search.Brand))
.WhereIF(!search.Model.IsNullOrWhiteSpace(), t1 => t1.Model.Contains(search.Model))
.WhereIF(!search.Language.IsNullOrWhiteSpace(), t1 => t1.Language.Contains(search.Language))
.WhereIF(!search.System.IsNullOrWhiteSpace(), t1 => t1.System.Contains(search.System))
.WhereIF(!search.Version.IsNullOrWhiteSpace(), t1 => t1.Version.Contains(search.Version))
.WhereIF(!search.Platform.IsNullOrWhiteSpace(), t1 => t1.Platform.Contains(search.Platform))
.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 <RfPhoneDeviceEntity> > GetRfPhoneDevicePageList(RfPhoneDeviceView search, ref int totalCount, int pageIndex = 1, int pageSize = 10, string orderByStr = "open_id desc")
{
return(_rfPhoneDeviceRepository.FindRfPhoneDevicePageList(search, orderByStr, ref totalCount, pageIndex, pageSize));
}
