engagesubjectsbiz.java

人力资源管理系统

package com.accphr.biz.impl;

import java.io.Serializable;
import java.util.List;

import com.accphr.biz.IEngageSubjectsBiz;
import com.accphr.dao.ICommonDao;
import com.accphr.entity.EngageSubjects;
import com.accphr.page.PageResult;

/*
 * 试题管理
 */
public class EngageSubjectsBiz implements IEngageSubjectsBiz {

	private ICommonDao commonDao=null;

	public void setCommonDao(ICommonDao commonDao) {
		this.commonDao = commonDao;
	}
	
	//保存
	/* (non-Javadoc)
	 * @see com.accphr.biz.impl.IEngageSubjectsBiz#add(com.accphr.entity.EngageSubjects)
	 */
	public void add(EngageSubjects engageSubjects ){
		this.commonDao.add(engageSubjects);
	}
	
	//删除
	/* (non-Javadoc)
	 * @see com.accphr.biz.impl.IEngageSubjectsBiz#del(java.io.Serializable)
	 */
	public void del(Serializable erid){
		this.commonDao.del(EngageSubjects.class, erid);
	}
	
	//更新
	/* (non-Javadoc)
	 * @see com.accphr.biz.impl.IEngageSubjectsBiz#update(com.accphr.entity.EngageSubjects)
	 */
	public void update(EngageSubjects engageSubjects){
		this.commonDao.update(engageSubjects);
	}
	
	
	//分页查询
	/* (non-Javadoc)
	 * @see com.accphr.biz.impl.IEngageSubjectsBiz#setPageResult(com.accphr.entity.EngageSubjects, com.accphr.page.PageResult)
	 */
	public void setPageResult(EngageSubjects engageSubjects,PageResult pageResult){
		String hql=" from EngageSubjects where 1=1";
		if(engageSubjects!=null){
			if(engageSubjects.getFirstKindId()!=null){
				hql+=" and firstKindId='"+engageSubjects.getFirstKindId()+"'";
			}
			if(engageSubjects.getRegister()!=null&&engageSubjects.getRegister().length()>0&&engageSubjects.getChanger()!=null&&engageSubjects.getChanger().length()>0){
				hql+=" and (registTime BETWEEN '"+engageSubjects.getRegister()+"' and '"+engageSubjects.getChanger()+"')";
			}else if(engageSubjects.getRegister()!=null&&engageSubjects.getRegister().length()>0){
				hql+=" and (registTime > '"+engageSubjects.getRegister()+"' )";
			}else if(engageSubjects.getChanger()!=null&&engageSubjects.getChanger().length()>0){
				hql+=" and (registTime < '"+engageSubjects.getChanger()+"')";
			}
			if(engageSubjects.getContent()!=null&&engageSubjects.getContent().length()>0){
				hql+=" and (content like '%"+engageSubjects.getContent()+"%'";
				if(engageSubjects.getDerivation()!=null&&engageSubjects.getDerivation().length()>0){
					hql+=" or derivation like '%"+engageSubjects.getDerivation()+"%'";
				}
				hql+=")";
			}
			
		}
		
		pageResult.setHql(hql);
		this.commonDao.pageList(pageResult);
	}

	//根据ID查询
	/* (non-Javadoc)
	 * @see com.accphr.biz.impl.IEngageSubjectsBiz#findById(java.io.Serializable)
	 */
	public EngageSubjects findById(Serializable id) {
		return (EngageSubjects)this.commonDao.findById(EngageSubjects.class, id);
	}

	//查询某类试题数量
	/* (non-Javadoc)
	 * @see com.accphr.biz.impl.IEngageSubjectsBiz#findById(java.io.Serializable)
	 */
	public Integer findAmount(String firstID, String secondID) {
		String hql="select count(*) from EngageSubjects where firstKindId=? and secondKindId=?";
		List list=this.commonDao.findByHql(hql, new Object[]{firstID,secondID});
		Integer amount=Integer.parseInt(String.valueOf(list.get(0)));
		return amount;
	}

	//根据字段查询
	public List findByPro(EngageSubjects engageSubjects) {
		String hql=" from EngageSubjects where 1=1";
		if(engageSubjects!=null){
			if(engageSubjects.getFirstKindId()!=null&&engageSubjects.getFirstKindId().length()>0){
				hql+=" and firstKindId='"+engageSubjects.getFirstKindId()+"'";
			}
			if(engageSubjects.getSecondKindId()!=null&&engageSubjects.getSecondKindId().length()>0){
				hql+=" and secondKindId='"+engageSubjects.getSecondKindId()+"'";
			}
		}
		return this.commonDao.findByHql(hql);
	}

}