Concatenate and obtain paging SQL statements

///   <Summary>
/// Total number of paging records 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>
/// Paging 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} " ,< br> pagingsql, startindex, endindex);

return pagingsql;
}