c851roledao.java

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

package com.je.ims.dao;

import java.util.List;

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

import com.je.ims.hibernate.Agent;
import com.je.ims.hibernate.Atree;
import com.je.ims.hibernate.Btree;
import com.je.ims.hibernate.Role;
import com.je.ims.hibernate.RoleMember;
import com.je.ims.hibernate.RoleType;

public class C851RoleDao extends HibernateDaoSupport {
	public C851RoleDao() {
		super();
	}
    //1判斷當前角色類型是否允許添加角色
	public boolean addRoleType(Long l){
		List L=getHibernateTemplate().find("from RoleType where roleTypeId="+l);
		if(L.size()>0){
			RoleType rt=(RoleType)L.get(0);
			if(rt.getIsAddrole().intValue()!=0&&rt.getIsLdap().intValue()==0&&rt.getRoleKind().intValue()!=4)
				return true;
			else
				return false;
		}
		return false;
	}
	//2獲取當前的角色類型
	public RoleType getRoleType(Long l){
			List L=getHibernateTemplate().find("from RoleType where roleTypeId="+l);
			RoleType rt=new RoleType();
		    if(L.size()>0){
			   rt=(RoleType)L.get(0);
			   return rt;
		    }
		return null;
	}
	//3獲取當前的組別
	public List getTeam(){
		try{
			List list = getHibernateTemplate().find("from Team team order by team.teamPk");
			return list;
		}
		catch(Exception e){
			System.out.println(e);
			return null;
		}
    }
	//4把當前角色插入資料庫中
	public void insertRole(Role role){
		getHibernateTemplate().saveOrUpdate(role);
	}
	//5從資料庫中獲得角色成員
	public List getRoleMember(){
			List list=getHibernateTemplate().find("from RoleMember");
			return list;
	}
	//6從資料庫中獲取可管理的角色類型
	public List getMgrRoleType(){
		try{
			List list=getHibernateTemplate().find("from RoleTypeMgrRoleType");
			return list;
		}
		catch(Exception e){
			System.out.println(e);
			return null;
		}
	}
	//7判斷當前角色類型是否允許修改
	public boolean alterRoleType(String msg){
		try{
			long l=Long.parseLong(msg);
			List L=getHibernateTemplate().find("from RoleType where roleTypeId="+l);
			if(L.size()>0){
				RoleType rt=(RoleType)L.get(0);
				if(rt.getIsLdap().intValue()==0&&rt.getRoleKind().intValue()!=4)
					return true;
				else
					return false;
			}
			return false;
		}
		catch(Exception e){
			System.out.println(e);
			return false;
		}
	}
	//8獲取沒有被刪除的角色
	public List getRole(){
			Long l=new Long(0);
			List list=getHibernateTemplate().find("from Role where isDelete="+l);
			return list;
	}
	//9刪除角色role
	public void deleteRole(Role role)
	{
		getHibernateTemplate().delete(role);
	}
    //10刪除角色成員roleMember
	public void deleteRoleMember(RoleMember roleMember)
	{
		 getHibernateTemplate().delete(roleMember);
	}
	//11判斷當前角色類型是否允許添加角色成員
	public boolean addRoleMember(Long l){
		try{
			List L=getHibernateTemplate().find("from RoleType where roleTypeId="+l);
			if(L.size()>0){
				RoleType rt=(RoleType)L.get(0);
				if(rt.getIsAddmember().intValue()!=0&&rt.getIsLdap().intValue()==0&&rt.getRoleKind().intValue()!=4)
					return true;
				else
					return false;
			}
			return false;
		}
		catch(Exception e){
			System.out.println(e);
			return false;
		}
	}
    //12把當前角色成員插入資料庫中
	public void insertRoleMember(RoleMember roleMember){
		getHibernateTemplate().saveOrUpdate(roleMember);
	}
	//13获得ATree的第一层结点
	public List getATree(Long lvl,Long year){
		List list = getHibernateTemplate().find("from Atree where lvl="+lvl+" and id.year="+year);
		return list;

	}
    //14获得BTree的第一层结点
	public List getBTree(Long lvl,Long year){
		List list = getHibernateTemplate().find("from Btree where lvl="+lvl+" and id.year="+year);
			return list;
	}
	//15刪除角色時要刪除的代理人
	public List getAgent(Long roleTypeId,String roleId){
		List list=getHibernateTemplate().find("from Agent where id.roleTypeId="+roleTypeId+" and id.roleId='"+roleId+"'");
		return list;
	}
	 //16刪除角色代理人
	public void deleteAgent(Agent agent)
	{
		 getHibernateTemplate().delete(agent);
	}
	//17
	public Role findRole(Long roleTypeId,String roleId){
		Long l=new Long(0);
		List list = getHibernateTemplate().find("from Role as r where r.id.roleTypeId="+roleTypeId+" and r.id.roleId='"+roleId+"'"+"and r.isDelete="+l);
		Role role=new Role();
		if(list.size()>0){
			role=(Role)list.get(0);
			return role;
		}
		return role;
	}
	//18
	public List findRoleType(Long roleTypeId){
		List list=getHibernateTemplate().find("select rt.roleTypeId,rt.roleTypeName from RoleType as rt where rt.roleTypeId="+roleTypeId);
		if(list!=null){
			return list;
		}
		else{
			return null;
		}
	}
	//19
	public List getMgrRoleType(Long roleTypeId){
			List list=getHibernateTemplate().find("select distinct rt from RoleTypeMgrRoleType as rtm,RoleType as rt where rtm.id.roleTypeId="+roleTypeId+"and rtm.id.mgrRoleTypeId=rt.roleTypeId");
			return list;
	}
	//20
	public List getMgrRoleType(String userId){
			List list=getHibernateTemplate().find("select distinct rt from RoleMember as rm,RoleTypeMgrRoleType as rtm,RoleType as rt where rm.id.userId='"+userId+"'and rm.id.roleTypeId=rtm.id.roleTypeId and rtm.id.mgrRoleTypeId=rt.roleTypeId");
			return list;

	}
	//21
	public void deleteRoleMember(Long roleTypeId,String roleId,String userId)
	{
		List list=getHibernateTemplate().find("from RoleMember as rm where rm.id.roleTypeId="+roleTypeId+"and rm.id.roleId='"+roleId+"'and rm.id.userId='"+userId+"'");
		RoleMember rm=new RoleMember();
		if(list.size()>0){
			rm=(RoleMember)list.get(0);
			 getHibernateTemplate().delete(rm);
		}
	}
	//22
	public List findRoleMember(Long roleTypeId,String roleId){
		List list=getHibernateTemplate().find("from RoleMember as rm where rm.id.roleTypeId="+roleTypeId+"and rm.id.roleId='"+roleId+"'");
		return list;
	}
	//23
	public List findRole(Long roleTypeId){
		Long l=new Long(0);
		List list=getHibernateTemplate().find("from Role as r where r.id.roleTypeId="+roleTypeId+"and r.isDelete="+l+"and r.year is null");
		return list;
	}
	public List findMyRole(Long roleTypeId){
		Long l=new Long(0);
		List list=getHibernateTemplate().find("from Role as r where r.id.roleTypeId="+roleTypeId+"and r.isDelete="+l);
		return list;
	}
	//24
	public List selectRole(Long roleTypeId,Long year){
		Long l=new Long(0);
		List list=getHibernateTemplate().find("from Role as r where r.id.roleTypeId="+roleTypeId+"and r.year="+year+"and r.isDelete="+l);
		return list;
	}
	//25
	public List findMember(Long roleTypeId,String roleId){
		List list=getHibernateTemplate().find("from RoleMember as rm where rm.id.roleTypeId="+roleTypeId+"and rm.id.roleId='"+roleId+"'");
		return list;
	}
	//26
	public List findTeam(Long year){
		List list=getHibernateTemplate().find("from Team as t where t.year="+year);
		return list;
	}
	public boolean IsNode(Btree btree){
		List l = getHibernateTemplate().find("from Btree where parentId='"+btree.getId().getNodeId()+"' and id.year="+btree.getId().getYear());
		if (l.size()>0)
		return true;
		return false;
	}
	public boolean IsANode(Atree atree){
		List l = getHibernateTemplate().find("from Atree where parentId='"+atree.getId().getNodeId()+"' and id.year="+atree.getId().getYear());
		if (l.size()>0)
		return true;
		return false;
	}
	public List getAtree(String parentId,Long year){
		Long lvl=new Long(1);
		List l = getHibernateTemplate().find("from Atree a where a.id.year="+year+"and a.parentId='"+parentId+"'and a.lvl="+lvl);
		return l;
	}
	public List getBtree(String parentId,Long year){
		Long lvl=new Long(1);
		List l = getHibernateTemplate().find("from Btree b where b.id.year="+year+"and b.parentId='"+parentId+"'and b.lvl="+lvl);
		return l;
	}
}