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







oracle·ÖÒ³²éѯÎÊÌ⣡£¡£¡ÎÞ·¨²éѯ³ö½á¹û£¡

---

µ½Êý¾Ý¿âÀïÈ¥ÎÊÒ»ÏÂ

---

²»ÐÐŶ

---

ÔõôûÈËŶ

---

ûÓùýOracle £¬Ö»ÄÜMark

---

C# code

---

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.