egovframework.rfc3.iam.dao
Class AdminMenuDAO

java.lang.Object
  org.springframework.dao.support.DaoSupport
      org.springframework.orm.ibatis.support.SqlMapClientDaoSupport
          egovframework.rte.psl.dataaccess.EgovAbstractDAO
              egovframework.rfc3.common.dao.RfcIAMAbstractDAO
                  egovframework.rfc3.iam.dao.AdminMenuDAO

All Implemented Interfaces:

org.springframework.beans.factory.InitializingBean

@Repository(value="AdminMenuDAO")
public class AdminMenuDAO
extends RfcIAMAbstractDAO

사용자권한 관계 테이블에 대한 DAO 클래스를 정의한다.

Since:

2010.12.21

Version:

egovframework RFC 3.0

Author:

개발팀 허성철

See Also:

 << 개정이력(Modification Information) >>
   
   수정일      수정자           수정내용
  -------    --------    ---------------------------
   2010.12.21  허성철          최초 생성

 Copyright (C) 2010 by skoinfo  All right reserved.
 

Constructor Summary

AdminMenuDAO()

Method Summary

int	adminMenuOfficeCnt(AdminMenuOfficeVO adminMenuOfficeVO) 부서권한 갯수
void	deleteAdminMenu(java.lang.String admSid) 메뉴 삭제
void	deleteAdminMenuOffice(long authSid) 부서권한 삭제
AdminMenuVO	getAdminMenuInfo(java.lang.String admSid) 메뉴 정보
AdminMenuVO	getAdminMenuInfoUrl(java.lang.String url)
AdminMenuOfficeVO	getAdminMenuOffice(long authSid) 부서권한 가져오기
int	getMaxGroupIdx() groupIdx최대값
int	getMaxOrderSid(int groupIdx) getMaxOrderSid
int	getOrderSidDuplicateCnt(AdminMenuVO adminMenuVO) groupIdx와 orderSid가 같은경우(수정모드에서)
void	insertAdminMenu(AdminMenuVO adminMenuVO) 메뉴 저장
void	insertAdminMenuOffice(AdminMenuOfficeVO adminMenuOfficeVO) 부서권한 저장
java.util.List<AdminMenuOfficeVO>	selectAdminMenuAuthList(java.lang.String admSid) 부서권한 전체목록
java.util.List<AdminMenuVO>	selectAdminMenuList(AdminMenuVO adminMenuVO) 관리자 메뉴 전체목록
java.util.List<AdminMenuVO>	selectGroupAdmList(int groupIdx) groupIdx에 해당하는 admSid값
int	subAdminMenuListCnt(AdminMenuVO adminMenuVO) groupIdx 같고 0보다 2차 메뉴 갯수
void	updateAdminMenu(AdminMenuVO adminMenuVO) 메뉴수정
void	updateAdminMenuOffice(AdminMenuOfficeVO adminMenuOfficeVO) 부서권한 수정

Methods inherited from class egovframework.rfc3.common.dao.RfcIAMAbstractDAO

delete, insert, list, listWithPaging, selectByPk, setSuperSqlMapClient, update

Methods inherited from class org.springframework.orm.ibatis.support.SqlMapClientDaoSupport

getDataSource, getSqlMapClient, getSqlMapClientTemplate, setDataSource, setSqlMapClient, setSqlMapClientTemplate

Methods inherited from class org.springframework.dao.support.DaoSupport

afterPropertiesSet

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

AdminMenuDAO

public AdminMenuDAO()

Method Detail

selectAdminMenuList

public java.util.List<AdminMenuVO> selectAdminMenuList(AdminMenuVO adminMenuVO)
                                                throws java.lang.Exception

관리자 메뉴 전체목록

Parameters:

adminMenuVO -

Returns:

Throws:

java.lang.Exception

selectGroupAdmList

public java.util.List<AdminMenuVO> selectGroupAdmList(int groupIdx)
                                               throws java.lang.Exception

groupIdx에 해당하는 admSid값

Parameters:

groupIdx -

Returns:

Throws:

java.lang.Exception

subAdminMenuListCnt

public int subAdminMenuListCnt(AdminMenuVO adminMenuVO)
                        throws java.lang.Exception

groupIdx 같고 0보다 2차 메뉴 갯수

Parameters:

groupIdx -

Returns:

Throws:

java.lang.Exception

getOrderSidDuplicateCnt

public int getOrderSidDuplicateCnt(AdminMenuVO adminMenuVO)
                            throws java.lang.Exception

groupIdx와 orderSid가 같은경우(수정모드에서)

Parameters:

adminMenuVO -

Returns:

Throws:

java.lang.Exception

getMaxGroupIdx

public int getMaxGroupIdx()
                   throws java.lang.Exception

groupIdx최대값

Returns:

Throws:

java.lang.Exception

getMaxOrderSid

public int getMaxOrderSid(int groupIdx)
                   throws java.lang.Exception

getMaxOrderSid

Parameters:

groupIdx -

Returns:

Throws:

java.lang.Exception

getAdminMenuInfo

public AdminMenuVO getAdminMenuInfo(java.lang.String admSid)
                             throws java.lang.Exception

메뉴 정보

Parameters:

admSid -

Returns:

Throws:

java.lang.Exception

getAdminMenuInfoUrl

public AdminMenuVO getAdminMenuInfoUrl(java.lang.String url)
                                throws java.lang.Exception

Throws:

java.lang.Exception

insertAdminMenu

public void insertAdminMenu(AdminMenuVO adminMenuVO)
                     throws java.lang.Exception

메뉴 저장

Parameters:

adminMenuVO -

Throws:

java.lang.Exception

updateAdminMenu

public void updateAdminMenu(AdminMenuVO adminMenuVO)
                     throws java.lang.Exception

메뉴수정

Parameters:

menuUserVO -

Throws:

java.lang.Exception

deleteAdminMenu

public void deleteAdminMenu(java.lang.String admSid)
                     throws java.lang.Exception

메뉴 삭제

Parameters:

admSid -

Throws:

java.lang.Exception

adminMenuOfficeCnt

public int adminMenuOfficeCnt(AdminMenuOfficeVO adminMenuOfficeVO)
                       throws java.lang.Exception

부서권한 갯수

Parameters:

groupIdx -

Returns:

Throws:

java.lang.Exception

selectAdminMenuAuthList

public java.util.List<AdminMenuOfficeVO> selectAdminMenuAuthList(java.lang.String admSid)
                                                          throws java.lang.Exception

부서권한 전체목록

Parameters:

adminMenuVO -

Returns:

Throws:

java.lang.Exception

getAdminMenuOffice

public AdminMenuOfficeVO getAdminMenuOffice(long authSid)
                                     throws java.lang.Exception

부서권한 가져오기

Parameters:

adminMenuOfficeVO -

Throws:

java.lang.Exception

insertAdminMenuOffice

public void insertAdminMenuOffice(AdminMenuOfficeVO adminMenuOfficeVO)
                           throws java.lang.Exception

부서권한 저장

Parameters:

adminMenuOfficeVO -

Throws:

java.lang.Exception

updateAdminMenuOffice

public void updateAdminMenuOffice(AdminMenuOfficeVO adminMenuOfficeVO)
                           throws java.lang.Exception

부서권한 수정

Parameters:

adminMenuOfficeVO -

Throws:

java.lang.Exception

deleteAdminMenuOffice

public void deleteAdminMenuOffice(long authSid)
                           throws java.lang.Exception

부서권한 삭제

Parameters:

admSid -

Throws:

java.lang.Exception