Oracle 分页方法 （C# 使用）

/// <summary>
        ///分页sql
        /// </summary>
        /// <param name="sql">查询内容的sql</param>
        /// <param name="order">排序字段（降序），必须是查出的某个字段</param>
        /// <param name="pageNumebr">页码</param>
        /// <param name="pageSize">每页的数量</param>
        /// <returns></returns>
        public static string SqlToPage(string sql, string order, int pageNumebr, int pageSize)
        {
            string psql = @"select * from（
                                        SELECT * FROM(
                                                    select row_number() OVER(order by Q." + order + @" desc) ROWIDS, Q.*, COUNT(*) OVER() TOTAL from(" + sql + @") Q
                                                     )
                                        WHERE ROWIDS <= " + (pageNumebr * pageSize) + @") TABS
                            WHERE TABS.ROWIDS > " + (pageNumebr - 1) * pageSize;
            return psql;

        }
string sql="select name,id,time from table1"
SqlToPage(sql,"time",1,10);