/// <summary> /// 通过用户名分页查找用户 /// </summary> /// <param name="userName"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="totalRecords"></param> /// <returns></returns> public List <SystemUserEntity> FindUsersByName(string userName, int pageIndex, int pageSize, out int totalRecords) { NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_USERLOGINID.Like(userName)); queryGenerator.SetFirstResult((pageIndex - 1) * pageSize); queryGenerator.SetMaxResults(pageSize); return(this.FindListByPageByQueryBuilder(queryGenerator, out totalRecords)); }
/// <summary> /// 通过用户名分页查找用户 /// </summary> /// <param name="userName"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="totalRecords"></param> /// <returns></returns> public List <SystemUserEntity> FindUsersByName(string userName, int pageIndex, int pageSize, out int totalRecords) { NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_USERLOGINID.Like(userName)); PageQueryParams pageQueryParams = new PageQueryParams(); pageQueryParams.PageIndex = pageIndex; pageQueryParams.PageSize = pageSize; List <SystemUserEntity> result = this.FindListByPageByQueryBuilder(queryGenerator, pageQueryParams); totalRecords = pageQueryParams.RecordCount; return(result); }