sqlServer通用分页

        /// <summary>
        /// 分页获取数据列表
        /// </summary>
        public DataSet GetList(int PageSize, int PageIndex, string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(userId) as AllRows from USERS where " + strWhere + " ");
            strSql.Append("SELECT * FROM ( ");
            strSql.Append("SELECT ROW_NUMBER() OVER(ORDER BY createTime) as ROWID, userId, userType, personId, account, password, isAdmin, enabled, loginIP, loginTime, loginTimes, lastLoginIP, lastLoginTime, remark, state, createUser, createTime, updateUser, updateTime FROM  USERS ");
            strSql.Append("  WHERE " + strWhere);
            strSql.Append(") AS TMP_GAME ");
            strSql.Append(" WHERE ROWID > " + (PageSize * (PageIndex - 1)));
            strSql.Append(" AND   ROWID <= " + (PageSize * (PageIndex - 1) + PageSize));
            return new DbHelperSQL().ExecuteQuery(strSql.ToString());