/// <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;
}