iostockpiledao.java

这是一个物流管理系统

package dao;

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

import org.apache.struts.tiles.taglib.GetAttributeTag;
import org.hibernate.Session;
import org.hibernate.Transaction;

import bean.Depotmission;
import bean.Goodssort;
import bean.Iostockpile;
import bean.Orderinfo;
import bean.State;
import bean.Stockpile;
import bean.Units;

import util.HibernateSessionFactory;

public class IostockpileDAO {
	Session session =HibernateSessionFactory.getSession();
	Transaction tr=session.beginTransaction();
	public void addOutReserve(List uncheckedDtail){
		
		int i=0;
		
		
		for(Object o:uncheckedDtail){
			Iostockpile ios=new Iostockpile();
			System.out.println("io"+ios.getIostockpileid());
			
			List l=session.createQuery("from Iostockpile").list();
		    Iostockpile ios1=(Iostockpile)l.get(l.size()-1);
			ios.setIostockpileid(ios1.getIostockpileid()+1);
			System.out.println("io_id"+ios.getIostockpileid());
			
			Stockpile sto=null;
			Units unit=null;
			
			Object[] oo=(Object[])o;
		    Long goodsid=(Long)oo[5];
		    sto=(Stockpile)session.load(Stockpile.class,goodsid);
		    Goodssort goodssort=sto.getGoodssort();
		    ios.setStockpile(sto);
		    ios.setGoodssort(goodssort);

		    Long unitid=(Long)oo[6];
		    unit=(Units)session.load(Units.class,unitid);
		    ios.setUnits(unit);
		    
		    Long orderid=(Long)oo[0];
		    List depl=session.createQuery("from Depotmission d where d.orderinfo.orderid=:id").setLong("id", orderid).list();
		    Depotmission dep1=(Depotmission)depl.get(i);
		    i++;
		    
		    Depotmission dep=(Depotmission)session.get("bean.Depotmission",dep1.getDepotmissionid());
		    System.out.println(dep);
		    ios.setDepotmissionid(dep.getDepotmissionid());
		    ios.setBillid(1003l);
		    Long indentamount=(Long)oo[2];
		    ios.setLairageamount(indentamount);
		    
		    Date da=new Date();
		    ios.setLairagetime(da);
		    
		    session.save(ios);
		}
	    tr.commit();
	}
	public List ioStockileRecordByBillid(Long billid){
		List pl=null;
		pl=session.createQuery("select iosto.depotmissionid,iosto.stockpile.goodsname," +
     "iosto.goodssort.goodssortname,iosto.lairageamount,iosto.units.unitname," +
				"iosto.lairagetime from Iostockpile iosto where billid=:billID")
        .setLong("billID",billid).list();
		System.out.println(pl.size());
		for(int i=0 ;i<pl.size();i++)
		{
			Object[] o=(Object[])pl.get(i);
			System.out.println("depotmissionid"+o[0]);
		}
		tr.commit();
		return pl;
	}
	public List selectCurrent(Date start,Date end){
		List list=session.createQuery("select io.goodssort.goodssortname,io.stockpile.goodsname,io.lairageamount from Iostockpile io where io.lairagetime between :s and :e")
		.setDate("s", start).setDate("e", end).list();
		System.out.println("zhixing iodao");
		for(int i=0;i<list.size();i++){
			System.out.println(list.get(i).toString());
		}
		tr.commit();
		session.close();
		return list;
	}
	public void doDepotmissonOut(List list)
	{
		for(int i=0;i<list.size();i++)
		{
			String s=(String)list.get(i);
			Long depotmissonid =Long.parseLong(s);
			System.out.println("depotmissonid shi"+depotmissonid);
		    Depotmission dep=(Depotmission)session.load(Depotmission.class, depotmissonid);
		    State state=new State();
		    state.setStateid(1007L);
		    state.setStatename("已执行");
		    dep.setState(state);
		    dep.setBillid(1001L);
		    session.update(dep);
		    Orderinfo orderinfo=(Orderinfo)session.get("bean.Orderinfo", dep.getOrderinfo().getOrderid());
		    State orderstate=new State();
		    orderstate.setStateid(1005L);
		    orderstate.setStatename("正在执行");
		    orderinfo.setState(orderstate);
		    session.update(orderinfo);
		    List iolist=session.createQuery("select io from Iostockpile io where depotmissionid=:id")
		    .setLong("id",depotmissonid).list();
		    System.out.println(iolist.size());
		    for(int j=0;j<iolist.size();j++){
		    	Iostockpile listio=(Iostockpile)iolist.get(j);
		    	System.out.println("out iostockpile"+listio.getIostockpileid());
		    	Iostockpile io=(Iostockpile)session.get("bean.Iostockpile",listio.getIostockpileid());
		    	io.setBillid(1001L);
		    	session.update(io);
		    	Long lairageamount=listio.getLairageamount();
		    	Stockpile st=(Stockpile)session.get("bean.Stockpile",listio.getStockpile().getGoodsid());
		    	st.setGoodsamount(st.getGoodsamount()-lairageamount);
		    	st.setOutamount(st.getOutamount()-lairageamount);
		    	session.update(st);
		    }
		    
		   
		}
		tr.commit();
		session.close();
	}

}