yuangongkaoqindao.java

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

package com.gensou.dao.yuangong.kaoqin;

import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import org.hibernate.*;

import com.gensou.hibernate.model.Kaoqinbiao;
import com.gensou.hibernate.model.Yuangongxinxi;
import com.gensou.hibernate.util.HibernateSessionFactory;
import com.gensou.logic.yuangong.kaoqin.AddygkaoqinService;
import com.gensou.logic.yuangong.kaoqin.QueryygkaoqinService;
import com.gensou.logic.yuangong.xinxi.QueryygxinxiService;


import com.gensou.util.Pagination;

public class YuangongkaoqinDao {
	
		
		 public boolean addygkaoqin(AddygkaoqinService addygkaoqinservice){
			boolean bool=false;
			Query query;
			List list;
			Kaoqinbiao kaoqin=new Kaoqinbiao();
			Session session=HibernateSessionFactory.getSession();
			Transaction tx=session.beginTransaction();
			try{
			Yuangongxinxi yuangong=new Yuangongxinxi();
			yuangong=(Yuangongxinxi)session.load(Yuangongxinxi.class,Integer.parseInt(addygkaoqinservice.getYuangongid()));
			query=session.createQuery("from Kaoqinbiao where yuangongxinxi=? and kaoqinshijian=?");
			query.setEntity(0,yuangong);
			query.setString(1,addygkaoqinservice.getKaoqinshijian());
			list=query.list();
			if(!list.isEmpty()){
				kaoqin = (Kaoqinbiao) list.get(0);
				Date date2=new Date();
				String date=date2.getHours()+":"+date2.getMinutes();
				 if(addygkaoqinservice.getDanxuan().equals("xiabanshijian")){
					 kaoqin.setXiabanshijian(date+"");
				 }else if(addygkaoqinservice.getDanxuan().equals("jiabanKsshijian")){
					 kaoqin.setJiabanKsshijian(date+"");
				 }else if(addygkaoqinservice.getDanxuan().equals("jiabanJsshijian")){
					 kaoqin.setJiabanJsshijian(date+"");
				 }else if(addygkaoqinservice.getDanxuan().equals("shangbanshijian")){
					 session.flush();
				     session.close();
					 return bool;
				 }
				 session.update(kaoqin);
				 session.flush();
				 tx.commit();
				 session.close();
				 return bool=true;
			}else{
				Date date3=new Date();
				String date1=date3.getHours()+":"+date3.getMinutes();
				kaoqin.setShangbanshijian(date1+"");
				kaoqin.setBeizhu(addygkaoqinservice.getBeizhu());
				kaoqin.setShifouchuqin(addygkaoqinservice.getShifouchuqin());
				kaoqin.setKaoqinshijian(addygkaoqinservice.getKaoqinshijian());
				kaoqin.setYuangongxinxi(yuangong);
				session.save(kaoqin);
				session.flush();
				tx.commit();
				session.close();
				return bool=true;
			}
			}catch(Exception e){
				e.printStackTrace();
				return bool;
			}
			
			
		 }
		 public List queryygkaoqin(String ways,String terms,int pageI,int maxpage){
			List ygkaoqin = new ArrayList();
			List list=new ArrayList();
			Session session=HibernateSessionFactory.getSession();
			Query query;
			String term;
			try{
				
				if(ways==null||ways.equals("")){
					term="%"+terms+"%";
					query = (Query) session.createQuery("from Kaoqinbiao where kaoqinshijian like ?");
					query.setString(0,term);
					Pagination pageination=new Pagination();
					ygkaoqin=pageination.getNowlist(query, pageI, maxpage);
				    if(ygkaoqin!=null&&!ygkaoqin.isEmpty()){
				    	for(int i=0;i<ygkaoqin.size();i++){
				            QueryygkaoqinService qcs=new QueryygkaoqinService((Kaoqinbiao)ygkaoqin.get(i));
				            list.add(qcs);
				    	}
				    }else{
				    	return list;
				    }
				}else{
					
					term="%"+terms+"%";
					Yuangongxinxi yuangongxinxi=(Yuangongxinxi)session.load(Yuangongxinxi.class,new Integer(ways));
					query = (Query) session.createQuery("from Kaoqinbiao where yuangongxinxi=? and kaoqinshijian like ?");
				    query.setEntity(0, yuangongxinxi);
					query.setString(1,term);
				    Pagination pageination=new Pagination();
				    ygkaoqin=pageination.getNowlist(query, pageI, maxpage);
				    if(ygkaoqin!=null&&!ygkaoqin.isEmpty()){
				    	for(int i=0;i<ygkaoqin.size();i++){
				            QueryygkaoqinService qcs=new QueryygkaoqinService((Kaoqinbiao)ygkaoqin.get(i));
				            list.add(qcs);
				    	}
				    }else{
				    	return list;
				    }
				}
			}catch(NullPointerException e){}
			session.flush();
	    	session.close();
			return list; 
		 }
		
		public Yuangongxinxi queryyuanggong(String ids){
			Session session=HibernateSessionFactory.getSession();
			Integer id=Integer.parseInt(ids);
			Yuangongxinxi yuangongxinxi=new Yuangongxinxi();
			yuangongxinxi=(Yuangongxinxi)session.load(Yuangongxinxi.class, id);
			session.flush();
	    	session.close();
			return yuangongxinxi;
		}
}