public class DataStringFY
{
public static string oracleString(string tblname, int pageCount, int pageNum, string orderby)
{
int startnum = pageNum * pageCount;
int endnum = (pageNum + 1) * pageCount;
return "select * from ( select rownum as rn ,DataStringFY.* from (select * from " + tblname + " order by " + orderby + ")DataStringFY ) where rn >" + startnum + " and rn <=" + endnum + " ";
}
public static string sqlstring(string tblname, int pageCount, int pageNum, string MainKey, string orderby)
{
int startnum = pageNum * pageCount;
return "select top " + pageCount + " * from " + tblname + " where " + MainKey + " not in ( select top " + startnum + " " + MainKey + " from " + tblname + " ORDER BY " + orderby + " ) ORDER BY " + orderby + " ";
}
}