weeklyinputdao.java

一个oa系统

package com.oa.db;

import java.io.UnsupportedEncodingException;
import java.util.List;

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


public class WeeklyinputDAO extends HibernateDaoSupport{
	public void Save(Weeklyinput vo) {// 保存员工填写的周报		
		try {
			this.getHibernateTemplate().save(vo);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public List ByStaffNameidAndPeriodQueryDate(int userid,int period) {// 通过员工姓名和周期查询周报信息
		List list = null; 
		try {
		list = this.getHibernateTemplate().find("from Weeklyinput where userid=? and period=?",new Object[]{userid,period});
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public int ByStaffNameAndPeriodQueryInputinfo(int userid,int period) {// 通过员工姓名和周期查询id
		List list = null;
		int id = 0;
		try {
		list = this.getHibernateTemplate().find("from Weeklyinput where userid=? and period=?",new Object[]{userid,period});
		if(list!=null&&list.size()!=0){
			Weeklyinput wo = (Weeklyinput)list.get(0);
			id = wo.getId();
		}
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return id;
	}
	
	public void UpdateInputinfo(Weeklyinput wo) {// 修改周报信息
		try {
			this.getHibernateTemplate().update(wo);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public List ByUseridQueryModify(int userid) {// 通过用户id查询处于非'已审核'状态的，即员工可以修改的周报列表
		List list = null;
		try {
			String whethercheck = "已审核";
			list = this.getHibernateTemplate().find("from Weeklyinput where userid=? and whethercheck!=? order by id DESC",new Object[]{userid,whethercheck});		
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	public List ByUseridQuery(int userid) {// 通过用户id查询周报列表
		List list = null;
		try {
			list = this.getHibernateTemplate().find("from Weeklyinput where userid=? order by id DESC",userid);		
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public List ByUseridandPeriodQueryModify(int userid,int period) {// 通过用户id和周期查询处于非'已审核'状态的，即员工可以修改的周报列表
		List list = null;
		try {
			String whethercheck = "已审核";
			list = this.getHibernateTemplate().find("from Weeklyinput where userid=? and whethercheck!=? and period=?",new Object[]{userid,whethercheck,period});		
			//System.out.println("sa:"+list.size());
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public List ByUseridandPeriodQuery(int userid,int period) {// 通过用户id和周期查询周报列表
		List list = null;
		try {
			list = this.getHibernateTemplate().find("from Weeklyinput where userid=? and period=?",new Object[]{userid,period});		
			//System.out.println("sa:"+list.size());
		} catch (HibernateException e) {
			// TODO Auto-generated catch block    
			e.printStackTrace();
		}
		return list;
	}
	
	public List ByIdQuery(int id) {// 通过id周报
		List list = null;
		try {
			list = this.getHibernateTemplate().find("from Weeklyinput where id=?",id);		
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public List ByDepartmentidQuery(int departmentid) {// 通过部门id查询周报列表
		List list = null;
		try {
			list = this.getHibernateTemplate().find("from Weeklyinput where departmentid=? order by id DESC",departmentid);		
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public List ByDepartmentidandPeriodQuery(int departmentid,int period) {// 通过部门id和周期查询周报列表
		List list = null;
		try {
			list = this.getHibernateTemplate().find("from Weeklyinput where departmentid=?  and period=?",new Object[]{departmentid,period});		
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public void UpdateWeekly(Weeklyinput wo) {// 修改周报信息
		try {
			this.getHibernateTemplate().update(wo);
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public List Query() {
		List list = null;
		try {
			list = this.getHibernateTemplate().find("from Weeklyinput order by id DESC");		
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public List ByDepartmentidandPeriodandKeywordQuery(int departmentid,int period,String keyword2) {// 通过部门id和周期和关键字查询周报列表
		List list = null;
	/*	String keyword = "";
		try {
			keyword = new String(keyword2.getBytes("iso8859-1"),"gbk");
		} catch (UnsupportedEncodingException e1) {
			// TODO 自动生成 catch 块
			e1.printStackTrace();
		}System.out.println("keyword2"+keyword);*/
		try {
		  if(departmentid!=0&&period!=0){
			list = this.getHibernateTemplate().find("from Weeklyinput where departmentid=? and period=? and (whethercheck like ? or realname like ?))", new Object[]{departmentid, period,"%"+keyword2+"%","%"+keyword2+"%"});
		  }
		 if(departmentid!=0&&period==0){
				list = this.getHibernateTemplate().find("from Weeklyinput where departmentid=?  and (whethercheck like ? or realname like ?))", new Object[]{departmentid, "%"+keyword2+"%","%"+keyword2+"%"});
			  }
		 if(departmentid==0&&period!=0){
				list = this.getHibernateTemplate().find("from Weeklyinput where period=? and (whethercheck like ? or realname like ?))", new Object[]{ period,"%"+keyword2+"%","%"+keyword2+"%"});
			  }
		 if(departmentid==0&&period==0){
				list = this.getHibernateTemplate().find("from Weeklyinput where whethercheck like ? or realname like ?)", new Object[]{"%"+keyword2+"%","%"+keyword2+"%"});
			  }
			//list = this.getHibernateTemplate().find("from Weeklyinput where departmentid=?  and period=?",new Object[]{departmentid,period});		
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	public List ByPeriodQuery(int period) {//通过周期查询周报
		List list = null;
		try {
			list = this.getHibernateTemplate().find("from Weeklyinput where period=?",period);		
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	public List ByPeriodAndUsernameQuery(int period,int userid) {//通过周期查询周报
		List list = null;
		try {
			list = this.getHibernateTemplate().find("from Weeklyinput where period=? and userid=?",new Object[]{period,userid});		
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
}