/// <summary> /// 查总记录数 /// </summary> /// <param name="searchParams"></param> /// <returns></returns> public int GetApplicationRecordCount(ApplicationSearchParams searchParams) { var criteria = this.Session.CreateCriteria <Application>(); 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 <Application> GetApplicationByPage(ApplicationSearchParams searchParams) { var criteria = this.Session.CreateCriteria <Application>(); 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 <Application>().ToList(); return(items); }
/// <summary> /// 分页查询 /// </summary> /// <param name="categorySearchParams"></param> /// <returns></returns> public virtual PageResult <Tiantianquan.Privilege.Domain.Application> GetApplicationByPage(ApplicationSearchParams searchParams) { var items = this.ApplicationRepository.GetApplicationByPage(searchParams); var total = this.ApplicationRepository.GetApplicationRecordCount(searchParams); return(new PageResult <Tiantianquan.Privilege.Domain.Application>(total, items)); }
public PageResult <Tiantianquan.Privilege.Domain.Application> GetApplicationByPage([FromBody] ApplicationSearchParams searchParams) { return(this.ApplicationService.GetApplicationByPage(searchParams)); }