/// <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));
        }
Esempio n. 2
0
        /// <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);
        }