lingliaodao.java

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

package com.gensou.dao.depot.draw;

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.model.Lingliaodan;
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 LingliaoDao {
    public List queryLingliao(String pinMing,String guiGe,String dateStr,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 Lingliaodan where riqi like ?");
				 query.setString(0,dateStr+"%");
			}else{
				if((pinming==null||pinming.equals(""))&& guige!=null && !guige.equals("")){
					 query = (Query) session.createQuery("from Lingliaodan where guige like ? and riqi like ?");
					 query.setString(0,"%"+guige+"%");
					 query.setString(1,dateStr+"%");
				}else{
					if((guige==null||guige.equals(""))&& pinming!=null && !pinming.equals("")){
						 query = (Query) session.createQuery("from Lingliaodan where pinming like ? and riqi like ?");
						 query.setString(0,"%"+pinming+"%");
						 query.setString(1,dateStr+"%");
					}else{
						 query = (Query) session.createQuery("from Lingliaodan where guige like ? and pinming like ? and riqi like ?");
						 query.setString(0,"%"+guige+"%");
						 query.setString(1,"%"+pinming+"%");
						 query.setString(2,dateStr+"%");
					}
				}
			}
			Pagination pagination=new Pagination();
			list=pagination.getNowlist(query,pag,max);
		}catch(NullPointerException e){}
    	session.flush();
    	session.clear();
    	session.close();
    	return list;
    }
    public int addLingliao(LingliaodanService bean){
    	int bool=0;
    	Session session=HibernateSessionFactory.getSession();
    	Transaction tx=null;
    	   try{
    		   tx=session.beginTransaction();
    		   String lingliaoId=bean.getLingliaodanId();
    		   Query q=session.createQuery(" from Lingliaodan where lingliaodanId=?");
    		   q.setString(0,lingliaoId);
    		   List list=q.list();
    		   if(list==null || list.isEmpty()){
    			   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()){
    				   bool=1;
    				   throw new HibernateException("");
    			   }
    	           Kucunxinxi kucun=(Kucunxinxi) list.get(0);
    	           int shuliang=kucun.getShuliang().intValue()-bean.getShuliang().intValue();
    	           if(shuliang >= 0){
    	        	   kucun.setShuliang(new Integer(shuliang));
    	        	   session.update(kucun);
    	        	   Lingliaodan lingliao=new Lingliaodan(bean);  			    
        			   session.save(lingliao);
        			   tx.commit();
        			   bool=2;		
    	           }else{
    	        	   bool=1;
    	           } 			    	 
    		   }
    	   }catch(HibernateException he){
    		   try{
    			   tx.rollback();
    		   }catch(NullPointerException npe){
    			   
    		   }  
    	   }finally{
    		   		   
    		   session.flush();
    		   session.clear();
    		   session.close();
    	   }
    	return bool;
    }
    public String printLingliao(String pinMing,String guiGe,String dateStr,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 Lingliaodan where riqi like ?");
				 query.setString(0,dateStr+"%");
			}else{
				if((pinming==null||pinming.equals(""))&& guige!=null && !guige.equals("")){
					 query = (Query) session.createQuery("from Lingliaodan where guige like ? and riqi like ?");
					 query.setString(0,"%"+guige+"%");
					 query.setString(1,dateStr+"%");
				}else{
					if((guige==null||guige.equals(""))&& pinming!=null && !pinming.equals("")){
						 query = (Query) session.createQuery("from Lingliaodan where pinming like ? and riqi like ?");
						 query.setString(0,"%"+pinming+"%");
						 query.setString(1,dateStr+"%");
					}else{
						 query = (Query) session.createQuery("from Lingliaodan where guige like ? and pinming like ? and riqi like ?");
						 query.setString(0,"%"+guige+"%");
						 query.setString(1,"%"+pinming+"%");
						 query.setString(2,dateStr+"%");
					}
				}
			}
			list=query.list();
			for(int i=0;i<list.size();i++){
				beanList.add(new LingliaodanService((Lingliaodan)list.get(i)));
			}
		}catch(NullPointerException e){}
    	session.flush();
    	session.clear();
    	session.close();
    	String jrxml=jrXml+"/jrxml/lingliaodan.jrxml";
    	System.out.println(jrxml);
    	String filepath="/pdf/"+UtilTimestamp.getNowTimestampString()+".pdf";
    	Print.printb(beanList,null,jrxml,jrXml+filepath,null,null);
    	return filepath;
    }
}