c36monthgroupdao.java

使用spring ,hibernate 框架的稽查管理系统

package com.je.ims.dao;

import java.util.List;

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

import com.je.ims.hibernate.Role;
import com.je.ims.hibernate.RoleMember;

public class C36MonthGroupDao extends HibernateDaoSupport {

	public C36MonthGroupDao() {
		super();
	}
    //1獲取年度為y的組別
	public List getTeam(Long y){
		List list = getHibernateTemplate().find("from Team where year="+y);
		if(list.size()>0){
			return list;
		}
		return null;
	}
    //2獲取當前的角色類型
	public List getRoleType(){
		List list=getHibernateTemplate().find("from RoleType where isTeam="+1+"and isYear="+1);
		if(list.size()>0){
			return list;
		}
		return null;
	}
    //3從資料庫中獲得角色成員
	public List getRoleMember(){
	      List list=getHibernateTemplate().find("from RoleMember");
	      if(list.size()>0){
	    	  return list;
	      }
		  return null;
	}
    //4獲取沒有被刪除的角色
	public Role getRole(Long rti,String ri){
		Long l=new Long(0);
		List list=getHibernateTemplate().find("from Role where isDelete="+l+"and id.roleId='"+ri+"'and id.roleTypeId="+rti);
		if(list.size()>0){
			Role role=(Role)list.get(0);
			return role;
		}
		return null;
	}
	 //5获得BTree的第一层结点
	public List getBTree(Long lvl,Long year){
		List list = getHibernateTemplate().find("from Btree where lvl="+lvl+" and id.year="+year);
		if(list.size()>0){
			return list;
		}
		else{
			return null;
		}
	}
	//6獲取組員信息
	public List getGroup(Long year,Long roleTypeId,Long teamPk,Long month,String orgId,String nodeId){
		String tree="B";
		List list=getHibernateTemplate().find("select r.teamName,r.month,rt.roleTypeName,r.roleName,r.orgName,r.nodeId,rm.userName,r.id.roleId,rm.id.userId from RoleType as rt,Role r,RoleMember rm where rt.roleTypeId=r.id.roleTypeId and r.id.roleTypeId=rm.id.roleTypeId and r.id.roleTypeId="+roleTypeId+"and r.id.roleId=rm.id.roleId and r.year="+year+"and r.teamPk="+teamPk+"and r.month="+month+"and r.orgId='"+orgId+"'and r.nodeId='"+nodeId+"'and r.ab='"+tree+"'");
		if(list.size()>0){
			return list;
		}
		else{
			return null;
		}
	}
	//7獲取沒有被刪除的角色
	public Role getRole1(Long rti,String ri){
		List list=getHibernateTemplate().find("from Role where id.roleId='"+ri+"'and id.roleTypeId="+rti);
		if(list.size()>0){
			Role role=(Role)list.get(0);
			return role;
		}
		return null;
	}
	//8獲取roleTypeId和roleId的角色成員
	public RoleMember getRoleMember(Long rti,String ri,String userId){
		List list=getHibernateTemplate().find("from RoleMember as rm where rm.id.roleTypeId="+rti+"and rm.id.roleId='"+ri+"'and rm.id.userId='"+userId+"'");
		if(list.size()>0){
			RoleMember roleMember=(RoleMember)list.get(0);
			return roleMember;
		}
		else{
			return null;
		}
	}
    //9把當前角色插入資料庫中
	public void insertRole(Role role){
		getHibernateTemplate().saveOrUpdate(role);
	}
    //10刪除角色role
	public void deleteRole(Role role)
	{
		getHibernateTemplate().delete(role);
	}
    //11刪除角色成員roleMember
	public void deleteRoleMember(RoleMember roleMember)
	{
		 getHibernateTemplate().delete(roleMember);
	}
	//12插入角色成員
	public void insertMember(RoleMember roleMember){
		getHibernateTemplate().saveOrUpdate(roleMember);
	}
    //13獲取當前的角色類型
	public List getRoleTypeAdd(){
		List list=getHibernateTemplate().find("from RoleType where isTeam="+1+"and isYear="+1+"and isAddrole="+1+"and isAddmember="+1);
		if(list.size()>0){
			return list;
		}
		return null;
	}

}