拼接、获取分页Sql语句

/// <summary>
        /// 分页记录总数Sql
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public static string GetPagingCountSql(string sql)
        {
            string pagingCountSql = "SELECT COUNT(*) FROM ({0}) t";

            return string.Format(pagingCountSql, sql);
        }

        /// <summary>
        /// 分页Sql
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <param name="orderBy"></param>
        /// <returns></returns>
        public static string GetPagingSql(string sql, int pageIndex, int pageSize, string orderBy)
        {
            string pagingSql = string.Format("select Row_Number() over (order by {1}) Seq_RowNum, t.* from ({0}) t", sql,orderBy);
            int startIndex = (pageIndex - 1) * pageSize + 1;
            int endIndex = startIndex + pageSize + 1;

            pagingSql = string.Format("select * from ({0}) T_RowNum where Seq_RowNum>={1} and Seq_RowNum<{2}", 
                                      pagingSql, startIndex, endIndex);

            return pagingSql;
        }