分页只调用一个方法

一个分页写一个对应的方法，只不过是数据库表名和字段名不同，这样太不专业了。

于是把数据库表名和字段名当参数提出来，调用方法时再输进去，这样类中的方法可移植性就好多了。

类中的代码：

 /// <summary>
        /// 分页绑定数据
        /// </summary>
        /// <param name="PageIndex"></param>
        /// <param name="PageSize"></param>
        /// <returns></returns>
        public DataTable ShowPagesea(int PageIndex, int PageSize,string DataTable,string id)
        {
            string sql = "select top " + PageSize + " * from " + DataTable + " where " + id + " Not in (select top " + (PageIndex - 1) * PageSize + " " + id + " from " + DataTable + " order by " + id + " desc) order by " + id + " desc ";
            DataTable dt = sdh.dbODSGetDataTable(sql, DataTable);
            return dt;
        }
        /// <summary>
        /// 判断总页数,分10页
        /// </summary>
        /// <returns>总页数</returns>
        public int ShowPageCountsea(string DataTable)
        {
            string sql = "select count(*) from " + DataTable + " ";
            int i = Convert.ToInt32(sdh.dbExecuteSql4Value(sql));
            if (i % 10 == 0)
            {
                i = i / 10;
            }
            else
            {
                i = i / 10 + 1;
            }
            return i;
        }

转载于:https://www.cnblogs.com/gengxiaochao/archive/2007/09/03/879953.html