/// <summary>
/// 分页查询
/// </summary>
/// <param name="categorySearchParams"></param>
/// <returns></returns>
public virtual PageResult <ApplicationRole> GetApplicationRoleByPage(ApplicationRoleSearchParams searchParams)
{
var items = this.ApplicationRoleRepository.GetApplicationRoleByPage(searchParams);
var total = this.ApplicationRoleRepository.GetApplicationRoleRecordCount(searchParams);
return(new PageResult <ApplicationRole>(total, items));
}
/// <summary>
/// 查总记录数
/// </summary>
/// <param name="searchParams"></param>
/// <returns></returns>
public int GetApplicationRoleRecordCount(ApplicationRoleSearchParams searchParams)
{
var criteria = this.Session.CreateCriteria <ApplicationRole>();
if (!string.IsNullOrWhiteSpace(searchParams.Keywords))
{
// criteria.Add(Restrictions.Like(__CategoryName__, "%" + searchParams.Keywords + "%"));
}
criteria.SetProjection(Projections.RowCount());
int total = (int)criteria.UniqueResult();
return(total);
}
public Task <List <ApplicationRole> > Groups(ApplicationRoleSearchParams searchParams)
{
var taskResult = Task.Run(() =>
{
using (var context = new DbContext())
{
var ctx = context
.Roles
.Where(r => !r.IsBack.HasValue);
return(ctx.ToList());
}
});
return(taskResult);
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="searchParams">分页查询条件</param>
/// <returns></returns>
public List <ApplicationRole> GetApplicationRoleByPage(ApplicationRoleSearchParams searchParams)
{
var criteria = this.Session.CreateCriteria <ApplicationRole>();
if (!string.IsNullOrWhiteSpace(searchParams.Keywords))
{
// criteria.Add(Restrictions.Like(__CategoryName__, "%" + searchParams.Keywords + "%"));
}
//criteria.AddOrder(Order.Asc(__CategoryName__));
criteria.SetFirstResult(searchParams.GetFirstResult());
criteria.SetMaxResults(searchParams.GetMaxResults());
var items = criteria.List <ApplicationRole>().ToList();
return(items);
}
public Task <List <ApplicationRole> > Groups(ApplicationRoleSearchParams searchParams)
{
return(_applicationRoleRepository.Groups(searchParams));
}
public PageResult <ApplicationRole> GetApplicationRoleByPage([FromBody] ApplicationRoleSearchParams searchParams)
{
return(this.ApplicationRoleService.GetApplicationRoleByPage(searchParams));
}
