/// <summary>
/// 分页查询
/// </summary>
/// <param name="categorySearchParams"></param>
/// <returns></returns>
public virtual PageResult <Permission> GetPermissionByPage(PermissionSearchParams searchParams)
{
var items = this.PermissionRepository.GetPermissionByPage(searchParams);
var total = this.PermissionRepository.GetPermissionRecordCount(searchParams);
return(new PageResult <Permission>(total, items));
}
/// <summary>
/// 查总记录数
/// </summary>
/// <param name="searchParams"></param>
/// <returns></returns>
public int GetPermissionRecordCount(PermissionSearchParams searchParams)
{
var criteria = this.Session.CreateCriteria <Permission>();
if (!string.IsNullOrWhiteSpace(searchParams.Keywords))
{
// criteria.Add(Restrictions.Like(__CategoryName__, "%" + searchParams.Keywords + "%"));
}
criteria.SetProjection(Projections.RowCount());
int total = (int)criteria.UniqueResult();
return(total);
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="searchParams">分页查询条件</param>
/// <returns></returns>
public List <Permission> GetPermissionByPage(PermissionSearchParams searchParams)
{
var criteria = this.Session.CreateCriteria <Permission>();
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 <Permission>().ToList();
return(items);
}
public PageResult <Permission> GetPermissionByPage([FromBody] PermissionSearchParams searchParams)
{
return(this.PermissionService.GetPermissionByPage(searchParams));
}
