30c2269145b0001b15ec8c0593d0bdd8

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

package com.gensou.dao.depot.stock;

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

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


import com.gensou.hibernate.model.Kucunxinxi;
import com.gensou.hibernate.util.HibernateSessionFactory;
import com.gensou.logic.depot.draw.LingliaodanService;
import com.gensou.logic.depot.stock.KucunService;
import com.gensou.util.Pagination;
import com.gensou.util.Print;
import com.gensou.util.UtilTimestamp;

public class KucunDao {
    public List queryKucun(String pinMing,String guiGe,int pag,int max){
    	List list=new ArrayList();
    	Session session=HibernateSessionFactory.getSession();
    	Query query;
    	String pinming;
		String guige;
		
		try{
			pinming=pinMing;
			guige=guiGe;
			if((pinming==null||pinming.equals(""))&&(guige==null||guige.equals(""))){
				 query = (Query) session.createQuery("from Kucunxinxi");
			}else{
				if((pinming==null||pinming.equals(""))&& guige!=null && !guige.equals("")){
					 query = (Query) session.createQuery("from Kucunxinxi where guige like ?");
					 query.setString(0,"%"+guige+"%");
				}else{
					if((guige==null||guige.equals(""))&& pinming!=null && !pinming.equals("")){
						 query = (Query) session.createQuery("from Kucunxinxi where pinming like ?");
						 query.setString(0,"%"+pinming+"%");
					}else{
						 query = (Query) session.createQuery("from Kucunxinxi where guige like ? and pinming like ?");
						 query.setString(0,"%"+guige+"%");
						 query.setString(1,"%"+pinming+"%");
					}
				}
			}
			Pagination pagination=new Pagination();
			list=pagination.getNowlist(query,pag,max);
		}catch(NullPointerException e){}
    	session.flush();
    	session.clear();
    	session.close();
    	return list;
    }
    public boolean addKucun(KucunService bean) throws Exception{
    	boolean bool=false;
    	Session session=HibernateSessionFactory.getSession();
    	Transaction tx=null;
    	Query q;
    	List list=new ArrayList();
    	try{
    		   tx=session.beginTransaction();
    		   String guige=bean.getGuige();
    		   String pinming=bean.getPinming();
    		   q=session.createQuery(" from Kucunxinxi where guige=? and pinming=?");
    		   q.setString(0,guige);
    		   q.setString(1,pinming);
    		   list=q.list(); 
    		   if(list==null || list.isEmpty()){
    		       Kucunxinxi kucun=new Kucunxinxi(bean);
    			   session.save(kucun);
    			   tx.commit();
    			   bool=true;  			  
    		   }else{
    			   Kucunxinxi kucun=(Kucunxinxi) list.get(0);
    			   int shuliang=kucun.getShuliang().intValue()+bean.getShuliang().intValue();
    			   bean.setShuliang(new Integer(shuliang));
    			   String beizhu=kucun.getBeizhu();
    			   if(bean.getBeizhu()==null || bean.getBeizhu().equals("")){
    				   bean.setBeizhu(beizhu);
    			   }
    			   kucun.copyFoBean(bean);
    			   session.update(kucun);
    			   tx.commit();
    			   bool=true;
    		   }		   
    	 }catch(Exception he){
    		   try{
    			   he.printStackTrace(); 
    			   tx.rollback();
    		   }catch(NullPointerException npe){
    			   
    		   }  		   
    	 }finally{
    		   
    		   session.flush();
    		   session.clear();
    		   session.close();
    	 }
    	return bool;
    }
    public String print(String pinMing,String guiGe,String jrXml){
    	List list=new ArrayList();
		List beanList=new ArrayList();
    	Session session=HibernateSessionFactory.getSession();
    	Query query;
    	String pinming;
		String guige;
		
		try{
			pinming=pinMing;
			guige=guiGe;
			if((pinming==null||pinming.equals(""))&&(guige==null||guige.equals(""))){
				 query = (Query) session.createQuery("from Kucunxinxi");
			}else{
				if((pinming==null||pinming.equals(""))&& guige!=null && !guige.equals("")){
					 query = (Query) session.createQuery("from Kucunxinxi where guige like ?");
					 query.setString(0,"%"+guige+"%");
				}else{
					if((guige==null||guige.equals(""))&& pinming!=null && !pinming.equals("")){
						 query = (Query) session.createQuery("from Kucunxinxi where pinming like ?");
						 query.setString(0,"%"+pinming+"%");
					}else{
						 query = (Query) session.createQuery("from Kucunxinxi where guige like ? and pinming like ?");
						 query.setString(0,"%"+guige+"%");
						 query.setString(1,"%"+pinming+"%");
					}
				}
			}
			list=query.list();

			for(int i=0;i<list.size();i++){
				beanList.add(new KucunService((Kucunxinxi) list.get(i)));
			}
		}catch(NullPointerException e){}
    	session.flush();
    	session.clear();
    	session.close();
    	String jrxml="D:\\kucun.jrxml";
    	System.out.println(jrxml);
    	String filepath="D:\\"+UtilTimestamp.getNowTimestampString()+".pdf";
    	Print.printb(beanList,null,jrxml,filepath,null,null);
    	return filepath;
    }
}