plandao.java

gensou.rar为某渔具厂的一个简单ERP系统。为比较基础的工程

package com.gensou.dao.sheji.plan;

import java.util.ArrayList;
import java.util.List;

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

import com.gensou.hibernate.model.Changpinxinxi;
import com.gensou.hibernate.model.Dingdantiaomu;
import com.gensou.hibernate.model.Dingdanxinxi;
import com.gensou.hibernate.model.Shengchangjihuatiaomu;
import com.gensou.hibernate.model.Shengchanjihua;
import com.gensou.hibernate.model.Sucaishengchangxinxi;
import com.gensou.hibernate.model.Sucaixinxiguanlian;
import com.gensou.hibernate.util.HibernateSessionFactory;
import com.gensou.logic.sheji.order.QueryOrderService;
import com.gensou.logic.sheji.plan.AddplanService;
import com.gensou.logic.sheji.plan.AddsucaiplansService;
import com.gensou.logic.sheji.plan.QueryPlans;
import com.gensou.logic.sheji.plan.QueryPlant;
import com.gensou.logic.sheji.plan.QuerySucai;
import com.gensou.logic.sheji.plan.QuerySucais;
import com.gensou.logic.sheji.plan.Querysucaiplans;
import com.gensou.logic.sheji.plan.UpdatesucaiplanService;
import com.gensou.util.Pagination;

public class PlanDao {
	
	public boolean addPlantiao(Dingdanxinxi order,Integer planid){
	   Session session=HibernateSessionFactory.getSession();
	   Transaction tx=session.beginTransaction();
	   Query query;
	   boolean bool=false;
	   Shengchanjihua plan=(Shengchanjihua)session.load(Shengchanjihua.class, planid);
	   query=session.createQuery("from Dingdantiaomu where dingdanxinxi=?");
	   query.setEntity(0,order);
	   List list=query.list();
	   for(int i=0;i<list.size();i++){
		   Dingdantiaomu ordert=(Dingdantiaomu)list.get(i);
		   Shengchangjihuatiaomu plant=new Shengchangjihuatiaomu();
		   plant.setBeizhu(ordert.getBeizhu());
		   plant.setChangpinxinxi(ordert.getChangpinxinxi());
		   plant.setShengchanjihua(plan);
		   plant.setShuliang(ordert.getShuliang());
		   session.save(plant);
	   }
	   try{
		      tx.commit();
		      bool=true;
		   }catch(Exception e){
			   tx.rollback();
		   }finally{
			   session.flush();
			   session.close(); 
		   }
	   return bool;  
	}
	
	public Integer addPlantiao(String planid){
		 Session session=HibernateSessionFactory.getSession();
		 Integer plantid=null;
		 Query query;
		 query=session.createQuery("from Shengchanjihua where shengchangjihuaId=?");
		 query.setString(0,planid);
		 List list=query.list();
		 Shengchanjihua plan=(Shengchanjihua)list.get(0);
		 plantid=plan.getId();
		 return plantid;
	}
	
	public boolean updateorders(Integer id){
		Session session=HibernateSessionFactory.getSession();
		Transaction tx=session.beginTransaction();
		boolean bool=false;
		Dingdanxinxi order=(Dingdanxinxi)session.load(Dingdanxinxi.class, id);
		order.setZhuangtai("1");
		try{
			session.update(order);
			tx.commit();
			bool=true;
		}catch(Exception e){
			tx.rollback();
		}finally{
			 session.flush();
			 session.close();
		}
		return bool;
	}
	
 public boolean addPlan(AddplanService addplan){
	 Session session=HibernateSessionFactory.getSession();
	 Transaction tx=session.beginTransaction();
	 Query query;
	 boolean bool=false;
	 try{
		 query=session.createQuery("from Shengchanjihua where shengchangjihuaId=?");
		 query.setString(0, addplan.getShengchangjihuaId());
		 List list=query.list();
		 if(list.isEmpty()){
		 Dingdanxinxi order=(Dingdanxinxi)session.load(Dingdanxinxi.class, addplan.getOid());
		 Shengchanjihua plan=new Shengchanjihua();
		 plan.setBeizhu(addplan.getBeizhu());
		 plan.setDingdanxinxi(order);
		 plan.setJieshuTime(addplan.getJieshuTime());
		 plan.setKaishiTime(addplan.getKaishiTime());
		 plan.setShengchangjihuaId(addplan.getShengchangjihuaId());
		 plan.setZhuangtai(addplan.getZhuangtai());
		 session.save(plan);
		 tx.commit();
		 Integer planid=addPlantiao(addplan.getShengchangjihuaId());
		 bool=addPlantiao(order,planid);
			 if(bool=true){
				bool=updateorders(addplan.getOid());
			 }
		 }
	 }catch(Exception e){
		 tx.rollback();
		 e.printStackTrace();
	 }finally{
		   session.flush();
		   session.close(); 
	  }
	 return bool;
 }
 
 public List queryorders(String way,String term,int pag,int max){
		List order_info = new ArrayList();
		Session session=HibernateSessionFactory.getSession();
		Query query;
		String ways;
		String terms;
		List list=new ArrayList();
		try{
			ways=way;
			terms=term;
			if(way==null||way.equals("")||terms==null||terms.equals("")){
				query = (Query) session.createQuery("from Dingdanxinxi where zhuangtai=0");
				Pagination pagination=new Pagination();
				order_info=pagination.getNowlist(query,pag,max);
				if(!order_info.isEmpty()){
				for(int i=0;i<order_info.size();i++){
					Dingdanxinxi order=new Dingdanxinxi();
					order=(Dingdanxinxi)order_info.get(i);
					QueryOrderService queryorderService=new QueryOrderService();
					queryorderService.setClientName(order.getClientName());
					queryorderService.setDingdanId(order.getDingdanId());
					queryorderService.setId(order.getId());
					queryorderService.setMudidi(order.getMudidi());
					queryorderService.setShoudanshijian(order.getShoudanshijian());
					queryorderService.setXiadanshijian(order.getXiadanshijian());
					queryorderService.setZhuangtai(order.getZhuangtai());
					list.add(queryorderService);
				}
				}
			    
			}else{
				String name="%"+term+"%";
				query = (Query) session.createQuery("from Dingdanxinxi where "+ways+" like ? and zhuangtai=0");
				query.setString(0,name);
				Pagination pagination=new Pagination();
				order_info=pagination.getNowlist(query,pag,max);
				if(!order_info.isEmpty()){
				for(int i=0;i<order_info.size();i++){
					Dingdanxinxi order=new Dingdanxinxi();
					order=(Dingdanxinxi)order_info.get(i);
					QueryOrderService queryorderService=new QueryOrderService();
					queryorderService.setClientName(order.getClientName());
					queryorderService.setDingdanId(order.getDingdanId());
					queryorderService.setId(order.getId());
					queryorderService.setMudidi(order.getMudidi());
					queryorderService.setShoudanshijian(order.getShoudanshijian());
					queryorderService.setXiadanshijian(order.getXiadanshijian());
					queryorderService.setZhuangtai(order.getZhuangtai());
					list.add(queryorderService);
				}
				}
			}
		}catch(NullPointerException e){}
		session.flush();
	    session.close();
		return list; 
	 }
 public QueryPlans queryPlanid(String addplan){
	 Session session=HibernateSessionFactory.getSession();
	 Transaction tx=session.beginTransaction();
	 Query query;
	 query=session.createQuery("from Shengchanjihua where shengchangjihuaId=?");
	 query.setString(0,addplan);
	 List list=query.list();
	 Shengchanjihua plan=(Shengchanjihua)list.get(0);
	 QueryPlans queryplan = new QueryPlans(plan);
	 session.flush();
	 session.close();
	 return queryplan;    
 } 
 public List queryPlanit(Integer planid){
	 Session session=HibernateSessionFactory.getSession();
	 
	 List list=new ArrayList();
	 Query query;
	 Shengchanjihua plan=(Shengchanjihua)session.load(Shengchanjihua.class, planid);
	 query=session.createQuery("from Shengchangjihuatiaomu where shengchanjihua=?");
	 query.setEntity(0,plan);
	 List lists=query.list();
	 for(int i=0;i<lists.size();i++){
		  Shengchangjihuatiaomu Planit=(Shengchangjihuatiaomu)lists.get(i);
		  QueryPlant queryplant=new QueryPlant(Planit);
		  list.add(queryplant);
	  }
	 session.flush();
	 session.close();
	 return list;
 }
 
	 public List queryway(String scjhid,int max,int page){
		 Session session=HibernateSessionFactory.getSession();
		 List list;
		 List plan_info=new ArrayList();
		 Query query;
		 if(scjhid==null||scjhid.equals("")){
			 query=session.createQuery("from Shengchanjihua");
			 Pagination pagination=new Pagination();
			 list=pagination.getNowlist(query,page,max);
			 if(!list.isEmpty()&&list!=null){
				 for(int i=0;i<list.size();i++){
					 Shengchanjihua plan=(Shengchanjihua)list.get(i);
					 QueryPlans plans=new QueryPlans(plan);
					 plan_info.add(plans);
				 }
			 }