staffbasicinfodao.java

上一上传oa系统漏掉web-inf文件夹

package com.oa.db;

import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;
import java.util.GregorianCalendar;
import java.util.List;

import org.hibernate.HibernateException;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

public class StaffbasicinfoDAO extends HibernateDaoSupport{
	public List QueryStaffbasicinfo(String uname) {//通过用户名查询员工基本信息
		List list = null;
		try {
			list = this.getHibernateTemplate().find("from User where username=?",uname);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public List QueryStaffbasicinfo1(String uname) {//通过用户名查询员工基本信息
		List list = null;
		try {
			list = this.getHibernateTemplate().find("from Staffbasicinfo where staffnamebh='"+uname+"'");
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public List QueryStaffbasicinfoa(String uname) {//通过用户名查询员工基本信息
		List list = null;
		try {
			list = this.getHibernateTemplate().find("from Staffbasicinfo where departmentid = 4 and staffnamebh='"+uname+"'");
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public List QueryStaffbasicinfo() {//查找所有员工基本信息
		List list = null;
		try {
		    list = this.getHibernateTemplate().find("from Staffbasicinfo order by id DESC");
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public int Save(Staffbasicinfo vo) {// 保存员工基本信息
		List list = null;
		int id = 0;
		try {
			this.getHibernateTemplate().save(vo);
			list = this.getHibernateTemplate().find("from Staffbasicinfo where staffnamebh=?",vo.getStaffnamebh());
			if(list!=null&&list.size()!=0){
				Staffbasicinfo uo = (Staffbasicinfo)list.get(0);
				id = uo.getId();
			}
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return id;
	}
	
	public List QueryStaffbasicinfobyentrytime(String querytype,String select) {//按条件查询员工基本信息
		List list = null;
		String a= "";
		String b="";
		String c="";
		if(querytype!=null&&!querytype.equals("")&&!querytype.equals("null")){
			if(querytype.equals("zhengshi")){
				a="正式员工";
			}
			if(querytype.equals("lizhi")){
				a="离职";
			}
			if(querytype.equals("shiyong")){
				a="试用";
			}
		}
		try {
			if(select!=null&&select.equals("1")){
				if(querytype!=null&&querytype.equals("all")){
					list = this.getHibernateTemplate().find("from Staffbasicinfo order by entrytime DESC");
				}else{
					list = this.getHibernateTemplate().find("from Staffbasicinfo where staffstatus=? order by entrytime DESC",a);
				}
			}else if(select!=null&&select.equals("2")){
				if(querytype!=null&&querytype.equals("all")){
					list = this.getHibernateTemplate().find("from Staffbasicinfo order by staffnamebh DESC");
				}else{
					list = this.getHibernateTemplate().find("from Staffbasicinfo where staffstatus=? order by staffnamebh DESC",a);
				}
			}
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public List QueryStaffbasicinfobykeyword(String bm,String key2) {// 通过部门和关键字查询员工基本信息
	//	Criteria dcri = session.createCriteria(Staffbasicinfo.class);
		List list = null;
		String key = "";
		if(key2!=null&&!key2.equals("")&&!key2.equals("null")){
			try {
				key = new String(key2.getBytes("iso8859-1"),"gbk");
			} catch (Exception e) {
				// TODO 自动生成 catch 块
				e.printStackTrace();
			}
			
		}
		
		//list = this.getHibernateTemplate().find("from Staffbasicinfo where departmentid=?", Object[]{});
		if(bm!=null&&!bm.equals("")&&!bm.equals("null")&&!bm.equals("0")){
			int departmentid = Integer.parseInt(bm);
			list = this.getHibernateTemplate().find("from Staffbasicinfo where departmentid=? and (staffnamebh like ? or realname like ? or staffstatus like ?)", new Object[]{departmentid, "%"+key2+"%","%"+key2+"%","%"+key2+"%"});
//			dcri.add(Expression.eq("department", bm));	
		//	dcri.addOrder(Order.desc("period"));
		//	dcri.addOrder(Order.asc("staffname"));
		}else{
			list = this.getHibernateTemplate().find("from Staffbasicinfo where staffnamebh like ? or realname like ? or staffstatus like ?", new Object[]{"%"+key2+"%","%"+key2+"%","%"+key2+"%"});
		}
//		if(key!=null&&!key.equals("")&&!key.equals("null")){
			//dcri.add(Expression.eq("staffname", key));
//			dcri.add(Expression.or(Expression.like("staffname",  "%"+key+"%"), Expression.like("staffbh", "%"+key+"%")));
			//dcri.addOrder(Order.desc("period"));
//		}
//		list=dcri.list();
		return list;
	}
	
	public void delStaffbasicinfo(Staffbasicinfo so) {// 删除员工基本信息
		List list = null; 
		try {
			this.getHibernateTemplate().delete(so);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public List QueryStaffbasicinfobyid(int id) {//通过用户名查询员工基本信息
		List list = null;
		try {
			list = this.getHibernateTemplate().find("from Staffbasicinfo where id=?",id);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public List QueryStaffbasicinfobyusername(String username) {//通过用户名查询员工基本信息
		List list = null;
		try {
			list = this.getHibernateTemplate().find("from Staffbasicinfo where staffnamebh=?",username);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public void Update(Staffbasicinfo vo) {//更新用户基本信息表
		try {
			this.getHibernateTemplate().update(vo);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	
	

	/**
	 * 查询所有的员工基本信息
	 * 
	 * @return list
	 */
	public List findAll(String flag) {
		List list = null;
		if(flag!=null){
			if(flag.equals("1")){
				list = this.getHibernateTemplate().find("from Staffbasicinfo where staffstatus = ?","正式员工");
			}
			if(flag.equals("2")){
				list = this.getHibernateTemplate().find("from Staffbasicinfo where staffstatus = ?","试用");
			}
			if(flag.equals("3")){
				list = this.getHibernateTemplate().find("from Staffbasicinfo where staffstatus = ?","离职");
			}
		}
		
		return list;
	}
	
	public List findAll() {
		List list = this.getHibernateTemplate().find("from Staffbasicinfo");		
		return list;
	}
	
	public List findAll2() {
		List list = this.getHibernateTemplate().find("from Staffbasicinfo where staffstatus!=?","离职");		
		return list;
	}

	/**
	 * 通过员工姓名查询部门id
	 * 
	 * @param username
	 * @return id
	 */
	public int findDeptIdByUserName(String userName) {
		List list = this.getHibernateTemplate().find(
				"from Staffbasicinfo where staffnamebh='" + userName + "'");
		Staffbasicinfo staffbasicinfo = (Staffbasicinfo) list.get(0);
		int id = staffbasicinfo.getDepartmentid();
		return id;
	}

	/**
	 * 通过员工姓名查询职位id；
	 * 
	 * @param userName
	 * @return id
	 */
	public int findPostIdByUserName(String userName) {
		List list = this.getHibernateTemplate().find(
				"from Staffbasicinfo where staffnamebh='" + userName + "'");
		Staffbasicinfo staffbasicinfo = (Staffbasicinfo) list.get(0);
		int id = staffbasicinfo.getPostid();
		return id;
	}

	/**
	 * 统计过生日的员工数量
	 * 
	 * @return
	 */
	public int findByStaffnamebh() {
		Calendar calendar = GregorianCalendar.getInstance();
		Date now = calendar.getTime();
		DateFormat d = new SimpleDateFormat("yyyy-MM-dd");// 通过SimpleDateFormat创建自定义的时间
		String str = d.format(now);
		String nowmonth = str.substring(5, 7);
		String nowday = str.substring(8, 10);
		List list = this
				.getHibernateTemplate()
				.find(
						"select count(*) from Staffbasicinfo where birthmonth=? and birthday=?",
						new String[] { nowmonth, nowday });
		String strr = list.get(0).toString();
		int counts = Integer.parseInt(strr);
		return counts;
	}

	/**
	 * 查询过生日人的名单
	 * @return
	 */
	public List findBirthName() {
		Calendar calendar = GregorianCalendar.getInstance();
		Date now = calendar.getTime();
		DateFormat d = new SimpleDateFormat("yyyy-MM-dd");// 通过SimpleDateFormat创建自定义的时间
		String str = d.format(now);
		String nowmonth = str.substring(5, 7);
		String nowday = str.substring(8, 10);
		List list = this
				.getHibernateTemplate()
				.find(
						"from Staffbasicinfo where birthmonth=? and birthday=?",
						new String[] { nowmonth, nowday });
		return list;
	}
	
	
}