plandao.java

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

		 }else{
			 query=session.createQuery("from Shengchanjihua where shengchangjihuaId like ?");
			 query.setString(0,"%"+scjhid+"%");
			 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);
				 }
			 }
		 }
		 return plan_info;
	 }
	 public QueryPlans queryPlani(Integer planid){
		 Session session=HibernateSessionFactory.getSession();
		 Transaction tx=session.beginTransaction();
		 Shengchanjihua plan=(Shengchanjihua)session.load(Shengchanjihua.class, planid);
		 QueryPlans plans=new QueryPlans(plan);
		 return plans;
	 }
	public List querylist(Integer id){ 
		 Session session=HibernateSessionFactory.getSession();
		 Query query;
         List lists=new ArrayList();
         List liste=new ArrayList();
	        	  Changpinxinxi plant=(Changpinxinxi)session.load(Changpinxinxi.class, id);
	        	  query=session.createQuery("from Sucaixinxiguanlian where changpinxinxi=?");
	        	  query.setEntity(0, plant);
	        	  lists=query.list();
	        	  for(int j=0;j<lists.size();j++){
	        		  Sucaixinxiguanlian sucai=(Sucaixinxiguanlian)lists.get(j);
	        		  QuerySucais sucais=new QuerySucais(sucai);
	        		  liste.add(sucais);
	        	  }
	        	  session.clear();
        
		 return liste; 
	} 
	public boolean addsucaiplan(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 Shengchangjihuatiaomu where shengchanjihua=?");
        query.setEntity(0, plan);
        List lists=query.list();
		if(!lists.isEmpty()&&lists!=null){
			for(int j=0;j<lists.size();j++){
				Shengchangjihuatiaomu plant=(Shengchangjihuatiaomu)lists.get(j);
				List list =querylist(plant.getChangpinxinxi().getId());  
				if(!list.isEmpty()&&list!=null){
					for(int i=0;i<list.size();i++){
						if(i%10==0){
							QuerySucais sucaiplan=(QuerySucais)list.get(i);
							Sucaishengchangxinxi sucai=new Sucaishengchangxinxi();
							sucai.setModelid(sucaiplan.getModelid());
							sucai.setModelnum(sucaiplan.getModelnum());
							sucai.setProductname(sucaiplan.getProductname());
							sucai.setQufen(sucaiplan.getQufen());
							sucai.setShengchanjihua(plan);
							Integer num;
					        if(plant.getShuliang()>sucaiplan.getModelnum()){
								if(plant.getShuliang()%sucaiplan.getModelnum()==0){
									num=plant.getShuliang()/sucaiplan.getModelnum();
								}else{
									num=plant.getShuliang()/sucaiplan.getModelnum()+1;
								}
					        }else{
					        	num=1;
					        }
							sucai.setQuanshu(num);
							sucai.setShuliang(plant.getShuliang());
							session.save(sucai);
							session.flush();
						}else{
							QuerySucais sucaiplan=(QuerySucais)list.get(i);
							Sucaishengchangxinxi sucai=new Sucaishengchangxinxi();
							sucai.setModelid(sucaiplan.getModelid());
							sucai.setModelnum(sucaiplan.getModelnum());
							sucai.setProductname(sucaiplan.getProductname());
							sucai.setQufen(sucaiplan.getQufen());
							sucai.setShengchanjihua(plan);
							Integer num;
					        if(plant.getShuliang()>sucaiplan.getModelnum()){
								if(plant.getShuliang()%sucaiplan.getModelnum()==0){
									num=plant.getShuliang()/sucaiplan.getModelnum();
								}else{
									num=plant.getShuliang()/sucaiplan.getModelnum()+1;
								}
					        }else{
					        	num=1;
					        }
							sucai.setQuanshu(num);
							sucai.setShuliang(plant.getShuliang());
							session.save(sucai);
						}
					}
				}
			}
			try{
				tx.commit();
				session.clear();
				session.close();
				bool=true;
			}catch(Exception e){
				tx.rollback();
				e.printStackTrace();
				session.clear();
				session.close();
			}
		}
		return bool;
	}
	
	public List querysucaiplant(Integer planid){
		Session session=HibernateSessionFactory.getSession();
		List list =new ArrayList();
		Query query;
		Shengchanjihua plan=(Shengchanjihua)session.load(Shengchanjihua.class, planid);
		query=session.createQuery("from Sucaishengchangxinxi where shengchanjihua=?");
		query.setEntity(0,plan);                               
		List lists = query.list();
		if(!lists.isEmpty()){
		   for(int i=0;i<lists.size();i++){
			   QuerySucai sucai=new QuerySucai((Sucaishengchangxinxi)lists.get(i));
			   list.add(sucai);
		   }
		}
		session.clear();
		session.close();
		return list;
	}
	public boolean updatesucaiplans(AddsucaiplansService sucaiplan){
		Session session=HibernateSessionFactory.getSession();
		Transaction tx=session.beginTransaction();
		boolean bool=false;
	    for(int i=0;i<sucaiplan.getId().length;i++){
	    	if(i%10==0){
	    		Integer[] id=sucaiplan.getId();
	    		System.out.print(id[i]);
	    		Sucaishengchangxinxi sucaiplans=(Sucaishengchangxinxi)session.load(Sucaishengchangxinxi.class,id[i]);
	    		String[] caiduan=sucaiplan.getCaiduan();
	    		sucaiplans.setCaiduan(caiduan[i]);
	    		Integer[] mquanshu= sucaiplan.getMquansu();
	    		sucaiplans.setMeitianquanshu(mquanshu[i]);
	    		String[] suoxutime=sucaiplan.getSuoxuTime();
	    		sucaiplans.setSucaiwanchengri(suoxutime[i]);
	    		session.update(sucaiplans);
	    		session.flush();
	    	}else{
	    		Integer[] id=sucaiplan.getId();
	    		System.out.print(id[i]);
	    		Sucaishengchangxinxi sucaiplans=(Sucaishengchangxinxi)session.load(Sucaishengchangxinxi.class,id[i]);
	    		String[] caiduan=sucaiplan.getCaiduan();
	    		sucaiplans.setCaiduan(caiduan[i]);
	    		Integer[] mquanshu= sucaiplan.getMquansu();
	    		sucaiplans.setMeitianquanshu(mquanshu[i]);
	    		String[] suoxutime=sucaiplan.getSuoxuTime();
	    		sucaiplans.setSucaiwanchengri(suoxutime[i]);
	    		session.update(sucaiplans);
	    	}
	    }
	    try{
    		tx.commit();
    		session.clear();
    		session.close();
    		bool=true;
    	}catch(Exception e){
    		tx.rollback();
    		session.clear();
    		session.close();
    	}
		return bool;
		}
	
	public List querysucaiplans(Integer planid){
		Session session=HibernateSessionFactory.getSession();
		List list =new ArrayList();
		Query query;
		Shengchanjihua plan=(Shengchanjihua)session.load(Shengchanjihua.class, planid);
		query=session.createQuery("from Sucaishengchangxinxi where shengchanjihua=?");
		query.setEntity(0,plan);                               
		List lists = query.list();
		if(!lists.isEmpty()){
		   for(int i=0;i<lists.size();i++){
			   Querysucaiplans sucai=new Querysucaiplans((Sucaishengchangxinxi)lists.get(i));
			   list.add(sucai);
		   }
		}
		session.clear();
		session.close();
		return list;
	}
	public boolean updatesucaiplan(UpdatesucaiplanService updatesucai){
		Session session=HibernateSessionFactory.getSession();
		Transaction tx=session.beginTransaction();
		boolean bool=false;
		Integer id[]=updatesucai.getId();
		Integer mquansu[]=updatesucai.getMquansu();
		String sucaiwanshengri[]=updatesucai.getSucaiwanchengri();
		for(int i=0;i<id.length;i++){
		  if(i!=0&&i%10==0){
			  Sucaishengchangxinxi plan=(Sucaishengchangxinxi)session.load(Sucaishengchangxinxi.class, id[i]);
			  plan.setMeitianquanshu(mquansu[i]);
			  plan.setSucaiwanchengri(sucaiwanshengri[i]);
			  session.update(plan);
			  session.flush();
		  }else{
			  Sucaishengchangxinxi plan=(Sucaishengchangxinxi)session.load(Sucaishengchangxinxi.class, id[i]);
			  plan.setMeitianquanshu(mquansu[i]);
			  plan.setSucaiwanchengri(sucaiwanshengri[i]);
			  session.update(plan); 
		  }
		}
		try{
			  tx.commit();
			  bool=true;
		  }catch(Exception ex){
			  tx.rollback();
		  }finally{
			  session.clear();
			  session.close();
		  }
		return bool;
	}
	
}