standardsbiz.java

人力资源管理系统

package com.accphr.biz.impl;

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

import com.accphr.biz.IStandardsBiz;
import com.accphr.dao.ICommonDao;
import com.accphr.entity.Standards;
import com.accphr.page.PageResult;


/**
 * 映射表 "salary_standard"。
 * 薪酬标准单信息    
 */
public class StandardsBiz implements IStandardsBiz {

	private ICommonDao commonDao;

	public void setCommonDao(ICommonDao commonDao) {
		this.commonDao = commonDao;
	}
	
	//添加信息
	/* (non-Javadoc)
	 * @see com.accphr.biz.impl.IStandardsBiz#add(com.accphr.entity.Standards)
	 */
	public void add(Standards standards){
		this.commonDao.add(standards);
	}
	
	//删除信息
	/* (non-Javadoc)
	 * @see com.accphr.biz.impl.IStandardsBiz#del(java.io.Serializable)
	 */
	public void del(Serializable serializable){
		this.commonDao.del(Standards.class, serializable);
	}
	
	//更新信息
	/* (non-Javadoc)
	 * @see com.accphr.biz.impl.IStandardsBiz#update(com.accphr.entity.Standards)
	 */
	public void update(Standards standards){
		this.commonDao.update(standards);
	}
	
	//查询产生新的ID
	/* (non-Javadoc)
	 * @see com.accphr.biz.impl.IStandardsBiz#findNewId()
	 */
	public String findNewId(){
		String hql="select max(standardId) from Standards";
		List list=this.commonDao.findByHql(hql);
		if(list.get(0)!=null){
			Integer oldid=Integer.parseInt(list.get(0).toString());
			return (oldid+1+"");
		}
		else{
			return "10001";
		}
	}
	
	//分页查询
	/* (non-Javadoc)
	 * @see com.accphr.biz.impl.IStandardsBiz#setPageResult(com.accphr.entity.Standards, com.accphr.page.PageResult)
	 */
	public void setPageResult(Standards standards,PageResult pageResult){
		String hql="from Standards where 1=1";
		if(standards!=null){
			//System.out.println(standards.getStandardName());
			if(standards.getStandardName()!=null){
				if(standards.getStandardName().length()>0){
					hql+=" and standardName like '%"+standards.getStandardName()+"%'";
				}
			}
			if(standards.getCheckStatus()!=null){
				if(standards.getCheckStatus()!=3){
					hql+=" and checkStatus like '%"+standards.getCheckStatus()+"%'";
				}
			}
		}
		//System.out.println(hql);
		pageResult.setHql(hql);
		this.commonDao.pageList(pageResult);
	}

	//根据ID查询信息
	public Standards findById(Serializable serializable) {
		String hql="from Standards where ssdId=?";
		List list=this.commonDao.findByHql(hql, new Object[]{serializable});
		Standards standards=null;
		if(list.size()>0){
			standards=(Standards)list.get(0);
		}
		
		return standards;
	}

	//根据sID查询信息
	public Standards findBySid(Serializable serializable) {
		String hql="from Standards where standardId=?";
		List list=this.commonDao.findByHql(hql, new Object[]{serializable});
		Standards standards=null;
		if(list.size()>0){
			standards=(Standards)list.get(0);
		}
		
		return standards;
	}
	

	//查询所有
	public List findAll() {
		String hql=" from Standards where checkStatus=1";
		return this.commonDao.findByHql(hql);
	}
	
	
}