public List getList(String startTime, String endTime, String mc, Pager pager)
{
String where = " ";
where = where + " and " + TypeChange.DateBetweenSql("a.riQi", startTime, endTime);
if (!TypeChange.toNotNullDao(mc).equals(""))
{
where = where + " and a.mingCheng like '%" + TypeChange.toNotNullDao(mc) + "%'";
}
return this.findAll(where, pager);
}
findAll:
private List<Test> findAll(String where, Pager pager)
{
String hSql = " From Test a where 1=1 " + where + " order by id ";
pager.setRowCount(getAllRowCount(hSql));
Session sess = this.getSessionFactory().openSession();
try
{
Query query = sess.createQuery(hSql);
query.setFirstResult(pager.getFirstResult());
query.setMaxResults(pager.getPageSize());
return query.list();
}
finally
{
sess.close();
}
}