orderinfodao.java

这是一个物流管理系统

package dao;

import java.util.ArrayList;
import java.util.HashSet;
import java.util.Iterator;
import java.util.List;
import java.util.Set;

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

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

import util.HibernateSessionFactory;

public class OrderInfoDao {
	private Session session = HibernateSessionFactory.getSession();
	private Transaction tr = session.beginTransaction();
	public Orderinfo select(Long orderid){
		session =HibernateSessionFactory.getSession();
		tr=session.beginTransaction();
		List list=session.createQuery("select o from Orderinfo o where o.orderid=:orderid")
		.setLong("orderid", orderid).list();
		 if(list.isEmpty()){
			 return null;
		 }else {
			 Orderinfo orderinfo=(Orderinfo)list.get(0);
			 //System.out.println(orderinfo.getOrderid());
			 tr.commit();			 
			 return orderinfo;
		 }
		
	}
	public List<Orderinfo> select(String name){	
		session =HibernateSessionFactory.getSession();
		tr=session.beginTransaction();
		List<Orderinfo> list=session.createQuery("from Orderinfo o where o.state.stateid=1000 and o.userinfo.username like '%"+name+"%'").list();
		tr.commit();
		return  list;	
		
	}

	public List stateSelect(Long stateid) {
		List list = session.createQuery(
				"select o from Orderinfo o where STATEID=:id ").setLong("id",
				stateid).list();
		List list1 = new ArrayList();
		for (int i = 0; i < list.size(); i++) {
			Orderinfo orderinfo = (Orderinfo) list.get(i);
			System.out.println("orderid=" + orderinfo.getOrderid());
			list1.add(orderinfo);
		}
		return list1;
	}

	public void changeState(Long orderid) {

		Orderinfo orderinfo = new Orderinfo();
		session.load(orderinfo, orderid);
		System.out.println("orderid=" + orderinfo.getOrderid());
		State state = new State();
		state.setStateid(new Long(1001));
		state.setStatename("已审核");
		orderinfo.setState(state);
		session.update(orderinfo);
		tr.commit();
		session.close();
	}

	public void close() {
		session.close();
	}

	public List getAllOrderinfos(int stateid) {
		List list = null;
		String hql = null;
		if (stateid == 1002) {
			hql = "SELECT ord.orderid,ord.userinfo.username,ord.userinfo.usertel,ord.delivertime FROM Orderinfo as ord WHERE ord.state.stateid=?";
		} else if (stateid == 1001) {
			hql = "SELECT ord.orderid,ord.userinfo.username,ord.userinfo.usertel,ord.delivertime FROM Orderinfo as ord WHERE ord.state.stateid=? or ord.state.stateid=1006";
		}
		Query q = session.createQuery(hql);
		q.setInteger(0, new Integer(stateid));
		list = q.list();
		return list;

	}

	public void updateOrderinfoStateAndEmployeeid(Long orderid, Long stateid,
			Long employeeid) {
		Orderinfo ord = new Orderinfo();
		session.load(ord, orderid);
		Employeeinfo emp = new Employeeinfo();
		emp.setEmployeeid(employeeid);
		ord.setEmployeeinfo(emp);
		State sta = new State();
		sta.setStateid(stateid);
		ord.setState(sta);
		session.update(ord);
		tr.commit();

	}

	public void updateOrderinfoState(Long orderid, Long stateid) {
		Orderinfo ord = new Orderinfo();
		session.load(ord, orderid);
		State sta = new State();
		sta.setStateid(stateid);
		ord.setState(sta);
		session.update(ord);
		tr.commit();

	}

	public List queryByOrderID(String condition, Long depotStateid) {
		List pl = session
				.createQuery(
						"select dep.orderinfo.orderid,dep.orderinfo.userinfo.username,dep.orderinfo.ordertime "
								+ "from Depotmission dep where dep.state.stateid=:depotmissionStateId and dep.orderinfo.orderid=:condi and dep.billid=1001")
				// .setString("searchby", searchBy)
				.setLong("depotmissionStateId", depotStateid).setLong("condi",
						Long.parseLong(condition)).list();
		System.out.println(pl.size());
		if(pl.size()!=0){
		List list=new ArrayList();
		list.add(pl.get(0));
			for (Object o : list) {
				System.out.println("orderDAo");
				Object[] oo = (Object[]) o;
				System.out.println(oo[0]);
				System.out.println(oo[1]);
				System.out.println(oo[2]);
			}
			tr.commit();

			/*
			 * * String[] s=null;
			 * while((s=(String[])pl.iterator().next())!=null){ for(String si:s)
			 * System.out.print(si); System.out.println(); }
			 */

			return list;
		}
		else{
			return pl;
		}
	

	}

	public List queryByUsername(String condition, Long depotStateid) {
		List pl = session
				.createQuery(
						"select dep.orderinfo.orderid,"
								+ "dep.orderinfo.userinfo.username,dep.orderinfo.ordertime "
								+ "from Depotmission dep "
								+ "where dep.state.stateid=:depotmissionStateId "
								+ "and dep.state.stateid=:depotmissionStateId "
								+ "and dep.orderinfo.userinfo.username=:condi and dep.billid=1001")
				// .setString("searchby", searchBy)
				.setString("condi", condition).setLong("depotmissionStateId",
						depotStateid).list();
		System.out.println(pl.size());
		for (Object o : pl) {
			System.out.println("do");
			Object[] oo = (Object[]) o;
			System.out.println(oo[0]);
			System.out.println(oo[1]);
			System.out.println(oo[2]);
		}
		tr.commit();
		return pl;

	}

	public void modifyOrderinfoState2Unchecked(Long orderid) {
		Orderinfo order = (Orderinfo) session.load(Orderinfo.class, orderid);
		order.setState((State) session.load(State.class, 1006l));
		tr.commit();
	}
	public boolean checkByUserid(long id){
		session=HibernateSessionFactory.getSession();
		tr=session.beginTransaction();
		String hql="from Orderinfo order where order.userinfo.userid="+id;
		Query q=session.createQuery(hql);
		List<Orderinfo> sps=q.list();	
		tr.commit();
		session.close();
		if(sps.size()!= 0)
		{
			return true;
		}		
		    return false;
	} 
	
	public boolean checkByEmpid(long id){
		session=HibernateSessionFactory.getSession();
		tr=session.beginTransaction();
		String hql="from Orderinfo order where order.employeeinfo.employeeid="+id;
		Query q=session.createQuery(hql);
		List<Orderinfo> sps=q.list();	
		tr.commit();
		if(sps.size()!= 0)
		{
			return true;
		}		
		    return false;
	} 
}