depotmissiondao.java

这是一个物流管理系统

package dao;

import java.util.Date;
import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import bean.Depotmission;
import bean.Orderinfo;
import bean.State;

import util.HibernateSessionFactory;

public class DepotmissionDAO {
	private Session session;
	private Transaction tr;
	public DepotmissionDAO() {
		session = HibernateSessionFactory.getSession();
	}
	public void close() {
		session.close();
	}
	public void addDepotmissionReserve(Long orderid,Long stateid){
		tr=session.beginTransaction();
		System.out.println("addDepotmissionReserve");
		Depotmission dep=new Depotmission(); 
		Orderinfo ord=new Orderinfo();
		session.load(dep,orderid);
		State sta=new State();
		sta.setStateid(stateid);
		dep.setState(sta);
		session.update(dep);
		tr.commit();
	}
	public void addDepotmission(Long orderid){
		tr=session.beginTransaction();
		Depotmission dep=new Depotmission(); 
		Orderinfo ord=new Orderinfo();
		ord.setOrderid(orderid);
		dep.setOrderinfo(ord);
		Date depotmissiontime=new Date();
		dep.setDepotmissiontime(depotmissiontime);
		State sta=new State();
		sta.setStateid(new Long(1000));
		dep.setState(sta);
		dep.setBillid(new Long(1001));
		session.save(dep);
		tr.commit();
	}
	
	public void changeDepotmission2State(Long orderid,Long stateid){
		tr=session.beginTransaction();
		System.out.println("addDepotmissionReserve");
		Depotmission dep=new Depotmission(); 
		Orderinfo ord=new Orderinfo();
		//session.load(dep,orderid);
		List depl=session.createQuery("from Depotmission d where d.orderinfo.orderid=:id").setLong("id", orderid).list();
		for(int i=0;i<depl.size();i++){
			Depotmission d=(Depotmission)depl.get(i);
			dep=(Depotmission)session.get(Depotmission.class,d.getDepotmissionid());
			State sta=new State();
			sta=(State)session.load(State.class, stateid);
			dep.setState(sta);
			session.save(dep);
		}
		
		//session.load(sta,stateid);
		//dep.setState(sta);
		
		//session.update(dep); dep sesion关闭下 ，save-- dep -- 新创建的对象 没有和任何session关联
		tr.commit();
	}
	
	public void deleteDepotmission(Long orderid){
		tr=session.beginTransaction();
		System.out.println("deleteDepotmission");
		Depotmission dep=(Depotmission)session.load(Depotmission.class,orderid);
		session.delete(dep);
		tr.commit();
	}
	
	public List allDepotmission(Long depotmissionStateid){
		tr=session.beginTransaction();
		System.out.println("allDepotmission");
		//Depotmission dep=new Depotmission(); 
		List pl=session.createQuery("select dep.orderinfo.orderid,dep.orderinfo.userinfo.username,dep.orderinfo.ordertime " +
		        "from Depotmission dep where dep.billid=1001 and dep.state.stateid=:depotStateid")
		        .setLong("depotStateid",depotmissionStateid)
		        //.setString("searchby", searchBy)
		        .list();
		System.out.println(pl.size());
		tr.commit();
		return pl;
	}
	public boolean checkByEmpid(long id){
		session=HibernateSessionFactory.getSession();
		tr=session.beginTransaction();
		String hql="from Depotmission dep where dep.employeeinfo.employeeid="+id;
		Query q=session.createQuery(hql);
		List<Depotmission> sps=q.list();	
		tr.commit();
		if(sps.size()!= 0)
		{
			return true;
		}		
		    return false;
	} 
}