C#实现 ORACLE的分页功能

public class PageUtil
{
    // Methods
    public static DataView GetListForPage(int index, int pagesize, string tabname, string key, string condition, string sortindex, ref int count)
    {
        int rscount = 0;
        StringBuilder strSql = new StringBuilder();
        OracleDataReader sdr = null;
        if (condition.Length > 0)
        {
            condition = " and " + condition;
        }
        strSql.Append("select count(*) from " + tabname + " where 1=1" + condition);
        sdr = DbHelperOra.ExecuteReader(strSql.ToString());
        if (sdr.Read())
        {
            rscount = Convert.ToInt32(sdr[0]);
        }
        sdr.Close();
        count = rscount;
        int maxpage = ((rscount + pagesize) - 1) / pagesize;
        if ((index + 1) >= maxpage)
        {
            index = maxpage - 1;
        }
        if (index < 0)
        {
            index = 0;
        }
        int start = (index * pagesize) + 1;
        int end = ((index + 1) * pagesize) + 1;
        string sql = "SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT * FROM " + tabname + " where 1=1 " + condition + " order by " + sortindex + " desc) A WHERE ROWNUM < " + end.ToString() + ") WHERE RN >= " + start.ToString();
        DataSet ds = new DataSet();
        ds = DbHelperOra.Query(sql);
        if (ds.Tables.Count > 0)
        {
            return ds.Tables[0].DefaultView;
        }
        return null;
    }
}