@Override
public int queryTotal(List<RetailStore> rsList) {
if (NullCheck.notNullList(rsList)) {
List<Integer> l = new ArrayList<Integer>();
for (RetailStore r : rsList) {
l.add(r.getId());
}
String hql = "select count(*) from " + clazz.getSimpleName() + " where belongs_id in :bid";
return Integer.valueOf(
getSession().createQuery(hql).setParameterList("bid", l).list().get(0).toString());
}
return 0;
}
@Override
public List<T> queryDatasList(List<RetailStore> rsList, int current, int nums) {
if (NullCheck.notNullList(rsList)) {
List<Integer> l = new ArrayList<Integer>();
for (RetailStore r : rsList) {
l.add(r.getId());
}
String hql = "from " + clazz.getSimpleName() + " where belongs_id in :bid and stat<>8";
return getSession()
.createQuery(hql)
.setParameterList("bid", l)
.setFirstResult((current - 1) * nums)
.setMaxResults(nums)
.list();
}
return null;
}
