audittabledaohibernate.java

这是本人曾经在公司里用的,内部开发框架,基于struts+hibernate今天分享给大家

/**
 * 
 */
package cn.bway.foreigntrade.auditmanagement.audittable.dao;

import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import org.hibernate.Criteria;
import org.hibernate.HibernateException;
import org.hibernate.criterion.Example;
import org.hibernate.criterion.Expression;
import org.hibernate.criterion.Order;

import cn.bway.common.BwayHibernateException;
import cn.bway.common.DataBaseUtils;
import cn.bway.common.Util;
import cn.bway.common.dao.BaseDAOHibernate;
import cn.bway.common.vo.PageListVO;
import cn.bway.common.vo.QueryVO;
import cn.bway.myoffice.merchant.model.Merchant;
import cn.bway.foreigntrade.auditmanagement.auditstaff.model.Auditstaff;
import cn.bway.foreigntrade.auditmanagement.audittable.model.Audittable;
import cn.bway.foreigntrade.information.model.Information;
import cn.bway.foreigntrade.operation.colormanagement.model.Colormanagement;
import cn.bway.foreigntrade.operation.countryport.model.Countryport;
import cn.bway.foreigntrade.operation.units.model.Units;

/**
 * @author Kson
 *
 */
public class AudittableDAOHibernate extends BaseDAOHibernate implements
		AudittableDAO {

	/* (non-Javadoc)
	 * @see cn.bway.myoffice.merchant.dao.MerchantDAO#findAllMerchant(cn.bway.common.vo.QueryVO)
	 */
	public Object findAllaudittable(QueryVO qvo) throws BwayHibernateException {
		Audittable audittable= new Audittable();
		PageListVO rvo=new PageListVO();
		rvo.setRealPage(qvo.getCurPage());
		rvo.setPageSize(qvo.getPageSize());
		List list=null;
		session=currentSession();
		try {
	    	Criteria criteria=session.createCriteria(Audittable.class);
	    	criteria.add(Expression.eq("state","3"));
	    	rvo.setTotalItems(criteria.add(Example.create(audittable)).list().size());	    	
	    	criteria.setFirstResult(qvo.getFirstItem());
	    	criteria.setMaxResults(qvo.getPageSize());	    	
			list=criteria.add(Example.create(audittable))
			.addOrder(Order.desc("id"))
			.list();
	    	
	    	rvo.setretVO(list);
		} catch (Exception ex)	{
			ex.printStackTrace();
			log.error(this.getClass().getName()+".updateObject(Object obj)"+ex);
		}finally{
			closeSession();
		}
    	return rvo;
	}

	/* (non-Javadoc)
	 * @see cn.bway.myoffice.merchant.dao.MerchantDAO#findAllMerchant1(cn.bway.common.vo.QueryVO)
	 */
	public Object findAllaudittable1(QueryVO qvo) throws BwayHibernateException {
		Audittable audittable= new Audittable();
		PageListVO rvo=new PageListVO();
		rvo.setRealPage(qvo.getCurPage());
		rvo.setPageSize(qvo.getPageSize());
		List list=null;
		session=currentSession();
		try {
	    	Criteria criteria=session.createCriteria(Audittable.class);
	    	rvo.setTotalItems(criteria.add(Example.create(audittable)).list().size());
	    	
	    	criteria.setFirstResult(qvo.getFirstItem());
	    	criteria.setMaxResults(qvo.getPageSize());
	    	
			list=criteria.add(Example.create(audittable))
			.addOrder(Order.desc("id"))
			.list();
	    	
	    	rvo.setretVO(list);
		} catch (Exception ex)	{
			ex.printStackTrace();
			log.error(this.getClass().getName()+".updateObject(Object obj)"+ex);
		}finally{
			closeSession();
		}
    	return rvo;
	}

	public Object queryaudittable(String orderid,String audittype) throws BwayHibernateException {
		Audittable table=new Audittable();
		session=currentSession();
		Criteria criter=session.createCriteria(Audittable.class);
		criter.add(Expression.eq("orderid", orderid));
		criter.add(Expression.eq("audittype", audittype));
		List list=criter.list();
		for(int i=0;i<list.size();i++){
			table=(Audittable) list.get(i);
		}
		return table;
	}

	public boolean isgreat(String audittype, String auditstaffid) throws BwayHibernateException {
		Auditstaff table=new Auditstaff();
		session=currentSession();
		Criteria criter=session.createCriteria(Auditstaff.class);
		criter.add(Expression.eq("auditorderid",audittype));//类型配套
		criter.add(Expression.gt("orderid",auditstaffid));//是否大于当前审核人
		List list=criter.list();
		boolean power=false;
		if(list.size()<1){
			//if(table==null){
				power=true;//没有大,就些结束
			//}
		}		
		return power;
	}

	public Object getInformation(String audittype, String orderid) throws BwayHibernateException {
		Information information=new Information();
		session=currentSession();
		Criteria criter=session.createCriteria(Information.class);
		criter.add(Expression.eq("inforcontent",audittype));//类型配套
		criter.add(Expression.eq("inforid",orderid));//是否大于当前审核人
		List list=criter.list();
		for(int i=0;i<list.size();i++){
			information=(Information) list.get(i);
		}
		return information;
	}

	public Object getError(String orderid, String audittype, String state) throws BwayHibernateException {
		Audittable table=new Audittable();
		session=currentSession();
		Criteria criter=session.createCriteria(Audittable.class);
		criter.add(Expression.eq("orderid",orderid));//类型配套
		criter.add(Expression.eq("audittype",audittype));//是否大于当前审核人
		criter.add(Expression.eq("state",state));//是否大于当前审核人
		List list=criter.list();
		for(int i=0;i<list.size();i++){
			table=(Audittable) list.get(i);
		}
		return table;
	}

}