hibernatedepartmentdao.java

OBPM是一个开源

package cn.myapps.core.department.dao;

import java.util.Collection;

import org.hibernate.Query;

import cn.myapps.base.action.ParamsTable;
import cn.myapps.base.dao.HibernateBaseDAO;
import cn.myapps.core.department.ejb.DepartmentVO;

public class HibernateDepartmentDAO extends HibernateBaseDAO implements
		DepartmentDAO {

	public HibernateDepartmentDAO(String voClassName) {
		super(voClassName);
	}

	public Collection getDatasByParent(String parent)
			throws Exception {
		String hql = "FROM " + _voClazzName + " vo WHERE vo.superior = '"
				+ parent + "' ORDER BY vo.id";
		return getDatas(hql, null);
	}

	public String getIdByName(String deptname, String application)
			throws Exception {
		String hql = "SELECT vo.id FROM " + _voClazzName
				+ " vo WHERE vo.name = '" + deptname + "'";

		Query query = currentSession().createQuery(hql);
		if (!query.list().isEmpty()) {
			return (String) query.list().get(0);
		} else
			return null;
	}

	public Collection getAllDepartment(String application) throws Exception {
		String hql = "FROM " + _voClazzName;
		   ParamsTable params=new ParamsTable();
		   params.setParameter("application",application);
		   return getDatas(hql, params);
	}

	public Collection getDepartmentByLevel(int level, String application)
			throws Exception {
		String hql = "FROM " + _voClazzName + " vo where vo.level=" + level;
		   ParamsTable params=new ParamsTable();
		   params.setParameter("application",application);
		   return getDatas(hql, params);
	}

	public Collection getDepartmentByName(String byName, String application)
			throws Exception {
		String hql = "FROM " + this._voClazzName + " vo where vo.name= '"
				+ byName + "'";
		   ParamsTable params=new ParamsTable();
		   params.setParameter("application",application);
		   return getDatas(hql, params);
	}
	public  DepartmentVO getRootDepartmentByApplication(String application)throws Exception{
		String hql = "FROM " + this._voClazzName + " vo where vo.superior is null and vo.applicationid='"+application+"'";
		
		   return (DepartmentVO)getData(hql);

	}

}