在c# 的分页获取数据列表

/// <summary>
        /// 分页获取数据列表
        /// </summary>
        /// <param name="tableName">表名</param>
        /// <param name="pageSize">分页容量</param>
        /// <param name="showString">显示字段</param>
        /// <param name="pageIndex">当前页数</param>
        /// <param name="strWhere">where</param>
        /// <param name="strOrderByField">排序字段</param>
        /// <param name="strOrderByType">排序类型</param>
        /// <param name="recordCount">总记录数</param>
        /// <param name="pageCount">总页数</param>
        /// <returns></returns>
        public DataSet GetList(string tableName, int pageSize, int pageIndex, string showString, string strWhere, string strOrderByField, string strOrderByType, out int recordCount, out int pageCount)
        {
            if (string.IsNullOrEmpty(showString))
            {
                showString = "*";
            }
            string strOrderBy = "";
            if (!string.IsNullOrEmpty(strOrderByField) && !string.IsNullOrEmpty(strOrderByType))
            {
                strOrderBy = string.Format("order by {0} {1}", strOrderByField, strOrderByType);
            }
            //获取总记录
            string recordSql = string.Format("select count(1) from {0} {1} ", tableName, strWhere);
            recordCount = Convert.ToInt32(DBHelper.DbHelperOleDb.Query(recordSql.ToString()).Tables[0].Rows[0][0]);
            //获取总页数
            if (recordCount % pageSize > 0) { pageCount = recordCount / pageSize + 1; }
            else { pageCount = recordCount / pageSize; }
            string strSql = "";
            pageIndex = GetPageIndex(pageIndex, pageCount);
            if (pageIndex == 1)
            {
                strSql = string.Format("select top {0} * from {1} {2} {3},id {4}", pageSize, tableName, strWhere, strOrderBy, strOrderByType);
            }
            else
            {
                strSql = string.Format("select top {0} * from {1} {2} and id not in (select top {3} id from {1} {2} {4},id {5}) {4},id {5}", pageSize, tableName, strWhere, (pageIndex - 1) * pageSize, strOrderBy, strOrderByType);
            }
            return DBHelper.DbHelperOleDb.Query(strSql.ToString());
        }
        /// <summary>
        /// 获取当前页数
        /// </summary>
        /// <param name="pageIndex"></param>
        /// <param name="pageCount"></param>
        /// <returns></returns>
        private int GetPageIndex(int pageIndex,int pageCount)
        {
            int index = 0;
            if (pageIndex <= 1) { index = 1; }
            else if (pageIndex >= pageCount) { index = pageCount; }
            else { index = pageIndex; }
            return index;
        }