admindaoimpl.java

一个关于tlms的一个小程序 看看能否帮助到别人

/**
 * ================================================================
 * Copyright 2006 szmx
 * <p/>
 * Change Revision
 * ---------------------------------------------------------------
 * Date               Author            Remarks
 * Mar 20, 2006       BZhang      Create class com.szmx.tlms.admin.dao.impl.AdminDAOImpl
 * ================================================================
 */

package com.szmx.tlms.admin.dao.impl;

import com.szmx.tlms.admin.dao.AdminDAO;
import com.szmx.tlms.admin.model.*;
import com.szmx.framework.base.dao.impl.BaseDaoImpl;
import com.szmx.framework.base.model.Pagination;
import org.hibernate.criterion.*;
import org.hibernate.Criteria;

import java.util.List;
import java.util.Map;
import java.util.HashMap;

public class AdminDAOImpl extends BaseDaoImpl implements AdminDAO {

    // Employee Managerment

    /**
     * @see AdminDAO#searchEmployees(com.szmx.framework.base.model.Pagination, java.util.Map)
     */
    public Pagination searchEmployees(Pagination pagination, Map paraMap) {
        return findPageByCombinedHsql("searchEmployeeList", paraMap, pagination);
    }

    /**
     * @see AdminDAO#getEmployee(Long)
     */
    public Employee getEmployee(Long id) {
        return (Employee) super.getObject(Employee.class, id);
    }

    /**
     * @see AdminDAO#getEmployee(String)
     */
    public Employee getEmployee(String empId) {
        return (Employee) super.findBy(Employee.class, "empId", empId);
    }

    /**
     * @see AdminDAO#saveEmployee(com.szmx.tlms.admin.model.Employee)
     */
    public void saveEmployee(Employee employee) {
        super.saveObject(employee);
    }

    /**
     * @see AdminDAO#removeEmployee(Long)
     */
    public void removeEmployee(Long id) {
        super.removeObject(Employee.class, id);
    }

    // Role Managerment

    /**
     * @see AdminDAO#searchRoles(com.szmx.framework.base.model.Pagination, java.util.Map)
     */
    public Pagination searchRoles(Pagination pagination, Map paraMap) {
        DetachedCriteria detachedCriteria = DetachedCriteria.forClass(Role.class);
        String name = (String) paraMap.get("roleName");
        if (name != null && ! "".equals(name)) {
            detachedCriteria.add(Restrictions.like("name", name, MatchMode.ANYWHERE));
        }
        return findPageByCriteria(detachedCriteria, pagination);
    }

    /**
     * @see AdminDAO#searchAssignedRoles(Long)
     */
    public List searchAssignedRoles(Long empId) {
        Map paraMap = new HashMap();
        paraMap.put("empId", empId);
        return findListByCombinedHsql("searchAssignedRoles", paraMap);
    }

    /**
     * @see AdminDAO#searchNotAssignedRoles(Long)
     */
    public List searchNotAssignedRoles(Long empId) {
        Map paraMap = new HashMap();
        paraMap.put("empId", empId);
        return findListByCombinedHsql("searchNotAssignedRoles", paraMap);
    }

    /**
     * @see AdminDAO#getRole(Long)
     */
    public Role getRole(Long id) {
        return (Role) super.getObject(Role.class, id);
    }

    /**
     * @see AdminDAO#getRoleByName(String)
     */
    public Role getRoleByName(String name) {
        Criteria criteria = getSession().createCriteria(Role.class);
        criteria.add(Expression.eq("name", name));
        return criteria.list().size() == 0 ? null : (Role) criteria.list().get(0);
    }

    /**
     * @see AdminDAO#saveRole(com.szmx.tlms.admin.model.Role)
     */
    public void saveRole(Role role) {
        saveObject(role);
    }

    /**
     * @see AdminDAO#removeRole(Long)
     */
    public void removeRole(Long id) {
        super.removeObject(Role.class, id);
    }

    /**
     * @see AdminDAO#removeEmpRoleRelation(Long)
     */
    public int removeEmpRoleRelation(Long empId) {
        Map paraMap = new HashMap();
        paraMap.put("empId", empId);
        return executeUpdateByHsql("delete from RelEmpRole where empId = :empId", paraMap);
    }

    /**
     * @see AdminDAO#searchEmpRoleRelation(Long)
     */
    public List searchEmpRoleRelation(Long roleId) {
        return findAllBy(RelEmpRole.class, "roleId", roleId);
    }

    /**
     * @see AdminDAO#getResourceModByModId(Long)
     */
    public Resource getResourceModByModId(Long modId) {
        return getResource(modId);
    }

    /**
     * @see AdminDAO#addResourceForRole(com.szmx.tlms.admin.model.RelRoleResource)
     */
    public void addResourceForRole(RelRoleResource relrr) {
        saveObject(relrr);
    }

    /**
     * @see AdminDAO#addBasicResForRole(Long)
     */
    public void addBasicResForRole(Long roleId) {
        RelRoleResource relRes = new RelRoleResource(roleId, new Long(6));
        saveObject(relRes);
        relRes = new RelRoleResource(roleId, new Long(7));
        saveObject(relRes);
    }

    /**
     * @see AdminDAO#removeAllResFromRole(Long)
     */
    public int removeAllResFromRole(Long roleId) {
        Map paraMap = new HashMap();
        paraMap.put("roleId", roleId);
        return executeUpdateByHsql("delete from RelRoleResource where roleId = :roleId", paraMap);
    }

    /**
     * @see AdminDAO#getRoleResource(Long)
     */
    public List getRoleResource(Long roleId) {
        Map map = new HashMap();
        map.put("roleId", roleId);
        return findListByCombinedHsql("searchRoleResourceList", map);
    }

    // Department Managerment

    /**
     * @see AdminDAO#searchDepartment(com.szmx.framework.base.model.Pagination, java.util.Map)
     */
    public Pagination searchDepartment(Pagination pagination, Map paraMap) {
        DetachedCriteria detachedCriteria = DetachedCriteria.forClass(Department.class);
        return findPageByCriteria(detachedCriteria, pagination);
    }

    /**
     * @see com.szmx.tlms.admin.dao.AdminDAO#getDepartmentList()
     */
    public List getDepartmentList() {
        return super.getAllObject(Department.class);
    }

    // Resource Managerment

    /**
     * @see AdminDAO#searchResources(com.szmx.framework.base.model.Pagination, java.util.Map)
     */
    public Pagination searchResources(Pagination pagination, Map paraMap) {
        return findPageByCombinedHsql("searchRoleResource", paraMap, pagination);
    }

    /**
     * @see AdminDAO#getResource(Long)
     */
    public Resource getResource(Long id) {
        return (Resource) super.getObject(Resource.class, id);
    }

    /**
     * @see AdminDAO#saveResource(com.szmx.tlms.admin.model.Resource)
     */
    public void saveResource(Resource resource) {
        super.saveObject(resource);
    }

    /**
     * @see AdminDAO#removeResource(Long)
     */
    public void removeResource(Long id) {
        super.removeObject(Resource.class, id);
    }

}