Oracle»òsql2005·ÖÒ³

/// <summary>
        /// ·µ»Ø·ÖÒ³SQLÓï¾ä
        /// </summary>
        /// <param name="selectSql">²éѯSQLÓï¾ä</param>
        /// <param name="PageIndex">µ±Ç°Ò³Âë</param>
        /// <param name="PageSize">Ò»Ò³¶àÉÙÌõ¼Ç¼</param>
        /// <returns></returns>
        public static string getPageSplitSQL(string selectSql, int PageIndex, int PageSize)
        {
            string StartSelectSql = @" select * from (select aa.*, rownum r  from (";
            int CurrentReadRows = PageIndex * PageSize;
            int startRow = (CurrentReadRows - PageSize) < 0 ? 0 : (CurrentReadRows - PageSize);
            int endRow = CurrentReadRows == 0 ? PageSize : CurrentReadRows;
            string EndSelectSql = string.Format(") aa where rownum <= {1}) bb  where r >{0} ", startRow, endRow);
            return StartSelectSql + selectSql + EndSelectSql;
        }