egovframework.rfc3.office.dao
Class OfficeDAO

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.office.dao.OfficeDAO

All Implemented Interfaces:

org.springframework.beans.factory.InitializingBean

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

조직도 DAO 클래스를 정의한다.

Since:

2011.03.30

Version:

egovframework RFC 3.0

Author:

개발팀 박형민

See Also:

 << 개정이력(Modification Information) >>
   
   수정일      수정자           수정내용
  -------    --------    ---------------------------
   2010.03.30  박형민          최초 생성

 Copyright (C) 2011 by skoinfo  All right reserved.
 

Constructor Summary

OfficeDAO()

Method Summary

void	deleteEminwonFileList(EminwonOfficeVO eminwonOfficeVO) 동기화 삭제
void	deleteOffice(OfficeVO officeVO) 조직도 삭제
OfficeVO	getOfficeListVO(OfficeVO officeVO)
java.util.List<OfficeVO>	getOfficeRealList(java.lang.String realCode) 자동업데이트 리얼코드 리스트
java.util.List<OfficeVO>	getOfficeTopList(OfficeVO officeVO)
void	insertEminwonFileList(EminwonOfficeVO eminwonOfficeVO) 온나라행정포탈 동기화
int	insertOffice(OfficeVO officeVO) 조직도 검색조건에 따른 전체 목록
java.util.List<OfficeVO>	officeDwrDpList(OfficeVO officeVO) 조직도 DWR 코드차수 가져오기
java.util.List<OfficeVO>	selectDpOfficeList(OfficeVO officeVO) 조직도 차수 별 리스트
java.util.List<OfficeVO>	selectOfficeAllList(java.lang.String officeCd)
java.util.List<EminwonOfficeVO>	selectOfficeContentsList(OfficeVO officeVO)
java.util.List<OfficeVO>	selectOfficeDpAllList(OfficeVO officeVO)
java.util.List<OfficeVO>	selectOfficeDpList(OfficeVO officeVO) 조직도 차수 가져오기
int	selectOfficeDwrCnt(java.lang.String officeCd) 조직도 DWR 관련 카운트
java.util.List<OfficeVO>	selectOfficeEminwonList(java.lang.String officeCd)
java.util.List<OfficeVO>	selectOfficeJsonList(OfficeVO officeVO) 조직도 차수 json용 가져오기
java.util.List<OfficeVO>	selectOfficeList(OfficeVO officeVO) 조직도 검색조건에 따른 전체 목록
java.util.List<OfficeVO>	selectOfficeListAll(OfficeVO officeVO) 조직도 검색조건에 따른 전체 목록(json용)
java.util.List<OfficeVO>	selectOfficeListSaeol(OfficeVO officeVO)
java.util.List	selectOfficeListSaeol2(OfficeVO officeVO)
int	selectOfficeListTotCnt(OfficeVO officeVO) 조직도 검색조건에 해당하는 갯수
int	selectOfficeListTotCntSaeol(OfficeVO officeVO)
int	selectOfficeListTotCntSaeol2(OfficeVO officeVO)
OfficeVO	selectOfficeListVO(java.lang.String officeCd) //조직도 수정 정보 가져옴
java.util.List<OfficeVO>	selectOfficeMessengerList(OfficeVO officeVO) UC Messenger 부서 전체 목록
java.util.List<java.lang.String>	selectOfficeParentOfficeCdList(java.lang.String officeCd) officeCd 상위 부서의 officeCd 목록
java.lang.String	selectOfficeRealCode(java.lang.String officeCd) 새올코드검색
java.util.List<OfficeVO>	selectOfficeSgroupList(OfficeVO officeVO) //조직도 사이트 그룹 1차 조직 DWR 사용
java.util.List<OfficeVO>	selectOfficeSgroupListAsc(java.lang.String sgroupId) sgroupId 에 해당하는 조직도를 ASC로 정렬 전체 값
java.util.List<OfficeVO>	selectOfficeSgroupListJson(OfficeVO officeVO) //조직도 사이트 그룹 1차 조직 DWR 사용
java.util.List<OfficeVO>	selectOfficeSingleList(OfficeVO officeVO) 조직도 차수 json용 가져오기
java.util.List<OfficeVO>	selectOfficeVOList(OfficeVO officeVO) 조직도 검색조건에 따른 전체 목록
OfficeVO	selectOnnaraOfficeList(java.lang.String officerealcode) 온나라사용자 Office_CD
void	updateOffice(OfficeVO officeVO)
void	updateOfficeIsUse(OfficeVO officeVO)
void	updateOfficeReplace(OfficeVO officeVO)
void	updateOfficeSaeolSaengjeongSync(OfficeVO officeVO)
void	updatePortalOffice(OfficeVO officeVO)

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

OfficeDAO

public OfficeDAO()

Method Detail

selectOfficeListTotCnt

public int selectOfficeListTotCnt(OfficeVO officeVO)
                           throws java.lang.Exception

조직도 검색조건에 해당하는 갯수

Parameters:

officeVO -

Returns:

Throws:

java.lang.Exception

selectOfficeList

public java.util.List<OfficeVO> selectOfficeList(OfficeVO officeVO)
                                          throws java.lang.Exception

조직도 검색조건에 따른 전체 목록

Parameters:

officeVO -

Returns:

Throws:

java.lang.Exception

selectOfficeListTotCntSaeol

public int selectOfficeListTotCntSaeol(OfficeVO officeVO)
                                throws java.lang.Exception

Throws:

java.lang.Exception

selectOfficeListSaeol

public java.util.List<OfficeVO> selectOfficeListSaeol(OfficeVO officeVO)
                                               throws java.lang.Exception

Throws:

java.lang.Exception

selectOfficeListTotCntSaeol2

public int selectOfficeListTotCntSaeol2(OfficeVO officeVO)
                                 throws java.lang.Exception

Throws:

java.lang.Exception

selectOfficeListSaeol2

public java.util.List selectOfficeListSaeol2(OfficeVO officeVO)
                                      throws java.lang.Exception

Throws:

java.lang.Exception

selectOfficeVOList

public java.util.List<OfficeVO> selectOfficeVOList(OfficeVO officeVO)
                                            throws java.lang.Exception

조직도 검색조건에 따른 전체 목록

Parameters:

officeVO -

Returns:

Throws:

java.lang.Exception

insertOffice

public int insertOffice(OfficeVO officeVO)
                 throws java.lang.Exception

조직도 검색조건에 따른 전체 목록

Parameters:

officeVO -

Returns:

Throws:

java.lang.Exception

deleteOffice

public void deleteOffice(OfficeVO officeVO)
                  throws java.lang.Exception

조직도 삭제

Parameters:

officeVO -

Throws:

java.lang.Exception

selectOfficeDpList

public java.util.List<OfficeVO> selectOfficeDpList(OfficeVO officeVO)
                                            throws java.lang.Exception

조직도 차수 가져오기

Parameters:

officeVO -

Returns:

Throws:

java.lang.Exception

selectOfficeDpAllList

public java.util.List<OfficeVO> selectOfficeDpAllList(OfficeVO officeVO)
                                               throws java.lang.Exception

Throws:

java.lang.Exception

selectOfficeAllList

public java.util.List<OfficeVO> selectOfficeAllList(java.lang.String officeCd)
                                             throws java.lang.Exception

Throws:

java.lang.Exception

selectOfficeDwrCnt

public int selectOfficeDwrCnt(java.lang.String officeCd)
                       throws java.lang.Exception

조직도 DWR 관련 카운트

Parameters:

officeCd -

Returns:

Throws:

java.lang.Exception

officeDwrDpList

public java.util.List<OfficeVO> officeDwrDpList(OfficeVO officeVO)
                                         throws java.lang.Exception

조직도 DWR 코드차수 가져오기

Parameters:

officeCd -

Returns:

Throws:

java.lang.Exception

selectOfficeListVO

public OfficeVO selectOfficeListVO(java.lang.String officeCd)
                            throws java.lang.Exception

//조직도 수정 정보 가져옴

Parameters:

officeCd -

Returns:

Throws:

java.lang.Exception

getOfficeListVO

public OfficeVO getOfficeListVO(OfficeVO officeVO)
                         throws java.lang.Exception

Throws:

java.lang.Exception

updateOffice

public void updateOffice(OfficeVO officeVO)
                  throws java.lang.Exception

Throws:

java.lang.Exception

updateOfficeSaeolSaengjeongSync

public void updateOfficeSaeolSaengjeongSync(OfficeVO officeVO)
                                     throws java.lang.Exception

Throws:

java.lang.Exception

updateOfficeReplace

public void updateOfficeReplace(OfficeVO officeVO)
                         throws java.lang.Exception

Throws:

java.lang.Exception

updateOfficeIsUse

public void updateOfficeIsUse(OfficeVO officeVO)
                       throws java.lang.Exception

Throws:

java.lang.Exception

selectOfficeSgroupList

public java.util.List<OfficeVO> selectOfficeSgroupList(OfficeVO officeVO)
                                                throws java.lang.Exception

//조직도 사이트 그룹 1차 조직 DWR 사용

Parameters:

officeVO -

Returns:

Throws:

java.lang.Exception

selectOfficeSgroupListAsc

public java.util.List<OfficeVO> selectOfficeSgroupListAsc(java.lang.String sgroupId)
                                                   throws java.lang.Exception

sgroupId 에 해당하는 조직도를 ASC로 정렬 전체 값

Parameters:

sgroupId -

Returns:

Throws:

java.lang.Exception

selectOfficeParentOfficeCdList

public java.util.List<java.lang.String> selectOfficeParentOfficeCdList(java.lang.String officeCd)
                                                                throws java.lang.Exception

officeCd 상위 부서의 officeCd 목록

Parameters:

officeCd -

Returns:

Throws:

java.lang.Exception

selectOfficeMessengerList

public java.util.List<OfficeVO> selectOfficeMessengerList(OfficeVO officeVO)
                                                   throws java.lang.Exception

UC Messenger 부서 전체 목록

Returns:

Throws:

java.lang.Exception

selectOfficeJsonList

public java.util.List<OfficeVO> selectOfficeJsonList(OfficeVO officeVO)
                                              throws java.lang.Exception

조직도 차수 json용 가져오기

Parameters:

officeVO -

Returns:

Throws:

java.lang.Exception

selectOfficeSingleList

public java.util.List<OfficeVO> selectOfficeSingleList(OfficeVO officeVO)
                                                throws java.lang.Exception

조직도 차수 json용 가져오기

Parameters:

officeVO -

Returns:

Throws:

java.lang.Exception

selectOfficeListAll

public java.util.List<OfficeVO> selectOfficeListAll(OfficeVO officeVO)
                                             throws java.lang.Exception

조직도 검색조건에 따른 전체 목록(json용)

Parameters:

officeVO -

Returns:

Throws:

java.lang.Exception

selectDpOfficeList

public java.util.List<OfficeVO> selectDpOfficeList(OfficeVO officeVO)
                                            throws java.lang.Exception

조직도 차수 별 리스트

Parameters:

officeVO -

Returns:

Throws:

java.lang.Exception

selectOfficeSgroupListJson

public java.util.List<OfficeVO> selectOfficeSgroupListJson(OfficeVO officeVO)
                                                    throws java.lang.Exception

//조직도 사이트 그룹 1차 조직 DWR 사용

Parameters:

officeVO -

Returns:

Throws:

java.lang.Exception

selectOfficeEminwonList

public java.util.List<OfficeVO> selectOfficeEminwonList(java.lang.String officeCd)
                                                 throws java.lang.Exception

Throws:

java.lang.Exception

getOfficeTopList

public java.util.List<OfficeVO> getOfficeTopList(OfficeVO officeVO)
                                          throws java.lang.Exception

Throws:

java.lang.Exception

selectOfficeRealCode

public java.lang.String selectOfficeRealCode(java.lang.String officeCd)
                                      throws java.lang.Exception

새올코드검색

Parameters:

officeCd -

Returns:

Throws:

java.lang.Exception

getOfficeRealList

public java.util.List<OfficeVO> getOfficeRealList(java.lang.String realCode)
                                           throws java.lang.Exception

자동업데이트 리얼코드 리스트

Parameters:

officeVO -

Returns:

Throws:

java.lang.Exception

selectOfficeContentsList

public java.util.List<EminwonOfficeVO> selectOfficeContentsList(OfficeVO officeVO)
                                                         throws java.lang.Exception

Throws:

java.lang.Exception

insertEminwonFileList

public void insertEminwonFileList(EminwonOfficeVO eminwonOfficeVO)
                           throws java.lang.Exception

온나라행정포탈 동기화

Parameters:

eminwonOfficeVO -

Throws:

java.lang.Exception

deleteEminwonFileList

public void deleteEminwonFileList(EminwonOfficeVO eminwonOfficeVO)
                           throws java.lang.Exception

동기화 삭제

Parameters:

eminwonOfficeVO -

Throws:

java.lang.Exception

selectOnnaraOfficeList

public OfficeVO selectOnnaraOfficeList(java.lang.String officerealcode)
                                throws java.lang.Exception

온나라사용자 Office_CD

Parameters:

officeVO -

Returns:

Throws:

java.lang.Exception

updatePortalOffice

public void updatePortalOffice(OfficeVO officeVO)
                        throws java.lang.Exception

Throws:

java.lang.Exception