¹ØÓÚoracle²éѯ·ÖÒ³µÄÎÊÌâ

C# code:


/// <summary>
/// ·ÖÒ³
/// </summary>
/// <param name="PageSize"></param>
/// <param name="CurrentPage"></param>
/// <param name="poolid"></param>
/// <returns></returns>
public IList FindText(int PageSize, int CurrentPage, Decimal poolid)
{
try
{
string sql = "Select * from WLEVELHISTORYDATA where WLEVELID = " + poolid.ToString() + " AND WLEVHISID not in (select WLEVHISID from WLEVELHISTORYDATA where ROWNUM<=('" + PageSize + "'*('" + CurrentPage + "'-1))) and ROWNUM<='" + PageSize + "' order by WLEVHISID desc";
return wlevelhistorydataDao.FindBySQLQuery(sql, "WLEVELHISTORYDATA", typeof(Wlevelhistorydata));
}
catch (DALException ex)
{
throw new BLLException("Fail to lode objects.", ex);
}
}

---

C# code:

string sql = "Select * from WLEVELHISTORYDATA where WLEVELID = '" + poolid.ToString() + "' AND ROWNUM<=('" + PageSize + &quo