indentinfodao.java

这是一个物流管理系统

package dao;

import java.util.*;
import bean.Indentinfo;

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


import util.HibernateSessionFactory;
public class IndentInfoDAO {
	private Session session =HibernateSessionFactory.getSession();
	private Transaction tr=session.beginTransaction();
	public List<Indentinfo> select(Long orderid)
	{
	   	List<Indentinfo> list=session.createQuery("from Indentinfo i where ORDERID=:id")
	   	.setLong("id",orderid).list();
	    if(list.isEmpty())
	    {
	    	System.out.println("kong order");
	    } 
	    Indentinfo indentinfo=list.get(0);
	    System.out.println(indentinfo.getIndentid());
	   	tr.commit();
	   	session.close();
	   	return list;
	}
	public List selectAll(Long orderid){
		List list1=session.createQuery("select i.orderinfo.orderid,i.stockpile.goodsname,i.stockpile.goodssort.goodssortname,i.goodsamount,i.stockpile.goodsamount from Indentinfo i where ORDERID=:id")
		.setLong("id",orderid).list();
		List list=null;
		 if(list1.isEmpty())
		    {
		    	System.out.println("kong duochaorder");
		    } 
		 for(Iterator it=list1.iterator();it.hasNext();)
		 {
			 Object[] o = (Object[])it.next();
			 System.out.println(o[0]+"--"+o[1]+"--"+o[2]);
		 }
		tr.commit();
		session.close();
	    return list1;
	}
	
	public List checkOrderinfoByStockpile(int orderid){
		List list = null;
		String hql=null;
		hql="SELECT ind.orderinfo.orderid,ind.indentid,ind.goodsamount,ind.stockpile.goodsamount-ind.stockpile.outamount FROM Indentinfo as ind  WHERE ind.orderinfo.orderid=?";
		Query q = session.createQuery(hql);
		q.setInteger(0, new Integer(orderid));
		list = q.list();
		System.out.println(list.size());
		return list;
	}
	public List checkOrderinfoByVehicle(int orderid){
		List list = null;
		String hql=null;
		hql="SELECT ind.orderinfo.orderid FROM Indentinfo as ind WHERE ind.orderinfo.orderid=?";
		Query q = session.createQuery(hql);
		q.setLong(0, new Long(orderid));
		list= q.list();
		return list;
	}
	public Long getStockpileGoodsid(Long indentid) {
		List list = null;
		String hql=null;
		hql="SELECT ind.stockpile.goodsid FROM Indentinfo as ind  WHERE ind.indentid=?";
		Query q = session.createQuery(hql);
		q.setLong(0,indentid);
		list = q.list();
		Long goodsid=(Long) list.get(0);
		return goodsid;
		
	}
	public void close() {
		session.close();
	}
	public List queryUncheckedDetail(long orderid){
		List pl=session.createQuery("select indent.orderinfo.orderid,indent.stockpile.goodsname," +
				"indent.goodsamount,indent.stockpile.goodsamount,indent.units.unitname,indent.stockpile.goodsid,indent.units.unitid " +
				"from Indentinfo indent where ORDERID=:orderid2")
				.setLong("orderid2",orderid)
				.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]);
			System.out.println(oo[3]);
			System.out.println(oo[4]);
			System.out.println(oo[5]);
		}
		tr.commit();
		return pl;
	}
	
	public List queryCheckedDetail(long orderid){
		List pl=session.createQuery("select indent.orderinfo.orderid,indent.stockpile.goodsname," +
				"indent.goodsamount,indent.stockpile.goodsamount,indent.units.unitname,indent.stockpile.goodsid,indent.units.unitid " +
				"from Indentinfo indent where ORDERID=:orderid2")
				.setLong("orderid2",orderid)
				.list();
		System.out.println(pl.size());
		tr.commit();
		return pl;
	}
}