daptpay.java

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

package com.gensou.dao.mange.deptPay;

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.Bumengongzi;
import com.gensou.hibernate.util.HibernateSessionFactory;
import com.gensou.logic.manage.deptPay.DeptPayService;
import com.gensou.util.Pagination;

public class DaptPay {

	//用于添加部门工资操作、
	public boolean addDeptPay (DeptPayService d)throws Exception {
		boolean bool=false;
		Session session = HibernateSessionFactory.getSession();
		Transaction tx = session.beginTransaction();
		Bumengongzi bu = new Bumengongzi();
		Query query = session.createQuery("from Bumengongzi where bumengongziId=? and yuefen=?");
		query.setString(0, d.getNum());
		query.setString(1, d.getYuefen());
		List l = query.list();
		if(l == null || l.isEmpty()){
			try{
			    bu.setBumengongziId(d.getNum());
			    bu.setBumenming(d.getName());
			    bu.setXiaoshigongzi(d.getXiaoshigongzi());
			    bu.setJibengongshi(d.getJibengongshi());
			    bu.setJibengongzi(d.getJibengongzi());
			    bu.setKoukuanheji(d.getKoukuanheji());
			    bu.setKoucanfei(d.getKoucanfei());
			    bu.setGangweijintie(d.getGangweijintie());
			    bu.setChejianjintie(d.getChejianjintie());
			    bu.setGonglingbutie(d.getGonglingbutie());
			    bu.setQitakoukuan(d.getQitakoukuan());
			    bu.setManqinjiang(d.getManqinjiang());
			    bu.setYiliaobutie(d.getYiliaobutie());
			    bu.setYuefen(d.getYuefen());
			    bu.setQita(d.getQita());
			    bu.setYingfaheji(d.getYingfaheji());
			    bu.setShifaheji(d.getShifaheji());
			    bu.setBeizhu(d.getBeizhu());
			    session.save(bu);
			    tx.commit();
			    bool=true;
				}catch(Exception e){
					e.printStackTrace();
					try{
						tx.rollback();
					}catch(NullPointerException npe){}
				}finally{    
				    session.flush();
			        session.clear();
			        session.close();
		        }
		}else{
	     return bool;   	
		}
	    return bool;
	}
	//用于查询部门工资
	public List queryDeptPay (DeptPayService dps,int pag,int max) throws Exception {
		String name = dps.getName();
		Pagination pagination=new Pagination();
		List list = new ArrayList();
		Query query = null;
		Session session = HibernateSessionFactory.getSession();
		if(name==null || name.equals("")){
			query = session.createQuery("from Bumengongzi where yuefen=?");
			query.setString(0,dps.getYuefen());
		}else{
			query = session.createQuery("from Bumengongzi where bumenming like ?");
			query.setString(0,"%"+name+"%");
		}
		List l = pagination.getNowlist(query,pag,max);
		if(l!=null && !l.isEmpty()){
			Query q = session.createQuery("from Bumengongzi where bumenming like ? and yuefen=?");
			q.setString(0,"%"+name+"%");
			q.setString(1,dps.getYuefen());
			List li = pagination.getNowlist(q,pag,max);
			try{
				for(int i=0;i<li.size();i++){
					Bumengongzi bu = (Bumengongzi) li.get(i);
					DeptPayService dept = new DeptPayService();
					dept.setId(bu.getId().intValue());
					dept.setNum(bu.getBumengongziId());
					dept.setName(bu.getBumenming());
					dept.setXiaoshigongzi(bu.getXiaoshigongzi());
					dept.setJibengongshi(bu.getJibengongshi());
					dept.setJibengongzi(bu.getJibengongzi());
				    dept.setKoucanfei(bu.getKoucanfei());
				    dept.setKoukuanheji(bu.getKoukuanheji());
				    dept.setGangweijintie(bu.getGangweijintie());
				    dept.setChejianjintie(bu.getChejianjintie());
				    dept.setGonglingbutie(bu.getGonglingbutie());
				    dept.setQitakoukuan(bu.getQitakoukuan());
				    dept.setManqinjiang(bu.getManqinjiang());
				    dept.setYiliaobutie(bu.getYiliaobutie());
				    dept.setYuefen(bu.getYuefen());
				    dept.setYingfaheji(bu.getYingfaheji());
				    dept.setQita(bu.getQita());
				    dept.setShifaheji(bu.getShifaheji());
				    dept.setBeizhu(bu.getBeizhu());
				    list.add(dept);
				}
		    }catch (Exception e){
		    	e.printStackTrace();
		    }finally{
		    	session.flush();
		    	session.clear();
		    	session.close();
		    }
		    	
		}
		return list;
	}
	//用于查询部门工资的详细信息
	public DeptPayService queryDeptAll (int id)throws Exception {
		DeptPayService dept = new DeptPayService();
		Session session = HibernateSessionFactory.getSession();
		Bumengongzi bu = (Bumengongzi)session.get(Bumengongzi.class,new Integer(id));
		dept.setId(bu.getId().intValue());
		dept.setNum(bu.getBumengongziId());
		dept.setName(bu.getBumenming());
		dept.setXiaoshigongzi(bu.getXiaoshigongzi());
		dept.setJibengongshi(bu.getJibengongshi());
		dept.setJibengongzi(bu.getJibengongzi());
	    dept.setKoucanfei(bu.getKoucanfei());
	    dept.setKoukuanheji(bu.getKoukuanheji());
	    dept.setGangweijintie(bu.getGangweijintie());
	    dept.setChejianjintie(bu.getChejianjintie());
	    dept.setGonglingbutie(bu.getGonglingbutie());
	    dept.setQitakoukuan(bu.getQitakoukuan());
	    dept.setManqinjiang(bu.getManqinjiang());
	    dept.setYiliaobutie(bu.getYiliaobutie());
	    dept.setYuefen(bu.getYuefen());
	    dept.setYingfaheji(bu.getYingfaheji());
	    dept.setQita(bu.getQita());
	    dept.setShifaheji(bu.getShifaheji());
	    dept.setBeizhu(bu.getBeizhu());
	    session.flush();
	    session.clear();
	    session.close();
		return dept;
	}
	//更新部门工资
	public boolean updateDeptPay (DeptPayService d) throws Exception{
		boolean  bool = false;
		Session session = HibernateSessionFactory.getSession();
		Transaction tx = session.beginTransaction();
		Bumengongzi bu = (Bumengongzi)session.get(Bumengongzi.class,new Integer(d.getId()));
		try{
		    bu.setXiaoshigongzi(d.getXiaoshigongzi());
		    bu.setJibengongshi(d.getJibengongshi());
		    bu.setJibengongzi(d.getJibengongzi());
		    bu.setKoukuanheji(d.getKoukuanheji());
		    bu.setKoucanfei(d.getKoucanfei());
		    bu.setGangweijintie(d.getGangweijintie());
		    bu.setChejianjintie(d.getChejianjintie());
		    bu.setGonglingbutie(d.getGonglingbutie());
		    bu.setQitakoukuan(d.getQitakoukuan());
		    bu.setManqinjiang(d.getManqinjiang());
		    bu.setYiliaobutie(d.getYiliaobutie());
		    bu.setYuefen(d.getYuefen());
		    bu.setQita(d.getQita());
		    bu.setYingfaheji(d.getYingfaheji());
		    bu.setShifaheji(d.getShifaheji());
		    bu.setBeizhu(d.getBeizhu());
		    session.update(bu);
		    tx.commit();
		    bool = true;
		}catch(Exception e){
			e.printStackTrace();
			try{
				tx.rollback();
			}catch(NullPointerException nps){}
		}finally{
			session.flush();
		    session.clear();
		    session.close();
		}
		return bool;
	}
}