50,530
社区成员
发帖
与我相关
我的任务
分享
package cn.zhs.daoImpl;
import java.util.List;
import org.hibernate.criterion.DetachedCriteria;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import cn.zhs.dao.BaseDao;
import cn.zhs.entiy.BizClaimVoucher;
public class BaseDaoImpl<T> extends HibernateDaoSupport implements BaseDao<T> {
//查询账单
@Override
public List<BizClaimVoucher> search() {
List<BizClaimVoucher> bizClaimVoucher = this.getHibernateTemplate().find("from BizClaimVoucher");
return bizClaimVoucher;
}
//分页查询
public List<T> findByPage(DetachedCriteria criteria, int pageNo, int pageSize){
return this.getHibernateTemplate().findByCriteria(criteria, (pageNo-1)*pageSize , pageSize);
}
//也数计算
@Override
public Long getRowCount(DetachedCriteria criteria) {
return (Long)this.getHibernateTemplate().findByCriteria(criteria).get(0);
}
}
package cn.zhs.bizImpl;
import java.util.Date;
import java.util.List;
import org.hibernate.criterion.DetachedCriteria;
import org.hibernate.criterion.Property;
import org.hibernate.criterion.Restrictions;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import com.opensymphony.xwork2.conversion.impl.DateConverter;
import cn.zhs.biz.ClaimVoucherBiz;
import cn.zhs.biz.EmployeeBiz;
import cn.zhs.dao.BaseDao;
import cn.zhs.dao.EmployeeDao;
import cn.zhs.entiy.BizClaimVoucher;
import cn.zhs.entiy.SysEmployee;
import cn.zhs.util.PaginationSupport;
@Service
@Transactional
public class ClaimVoucherBizImpl implements ClaimVoucherBiz {
private BaseDao baseDao;
public BaseDao getBaseDao() {
return baseDao;
}
public void setBaseDao(BaseDao baseDao) {
this.baseDao = baseDao;
}
@Override
public List<BizClaimVoucher> searchClaimVoucherBiz() {
List<BizClaimVoucher> bizClaimVoucher = baseDao.search();
return bizClaimVoucher;
}
@Override
public PaginationSupport<BizClaimVoucher> findByPage(String sn,
String status, Date startDate, Date endDate, int pageNo,
int pageSize) {
System.out.println("@@@@@@@@ 来自 Biz impl @@@@@@@@@@@");
PaginationSupport<BizClaimVoucher> page = new PaginationSupport<BizClaimVoucher>();
if(pageNo > 1){
page.setCurrPageNo(pageNo);
}
if(pageSize > 0){
page.setPageSize(pageSize);
}
//條件查詢
DetachedCriteria criteria = DetachedCriteria.forClass(BizClaimVoucher.class);
criteria.add(Restrictions.eq("sysEmployeeByCreateSn.sn", sn));
if(status !=null && status.length() != 0){
criteria.add(Restrictions.eq("status",status));
}
if(startDate !=null){
criteria.add(Restrictions.gt("createTime",startDate));
}
if(endDate !=null){
criteria.add(Restrictions.lt("modifyTime",endDate));
}
criteria.setProjection(Property.forName("id"));
int rowCount = baseDao.getRowCount(criteria).intValue();
page.setTotalCount(rowCount);
int pageCount = (rowCount + page.getPageSize() -1) / page.getPageSize();
page.setTotalPageCount(pageCount);
if(page.getTotalPageCount() >pageCount ){
page.setTotalPageCount(pageCount);
}
criteria.setProjection(null);
List<BizClaimVoucher> result = baseDao.findByPage(criteria, page.getCurrPageNo(), page.getPageSize());
page.setItems(result);
return page;
}
}