egovframework.rfc3.user.dao
Class UserManageDAO

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.user.dao.UserManageDAO

All Implemented Interfaces:

org.springframework.beans.factory.InitializingBean

@Repository(value="UserManageDAO")
public class UserManageDAO
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

UserManageDAO()

Method Summary

void	deleteUserManage(java.lang.String uniqId) 업무사용자 삭제하기
void	deleteUserManageForSiteGroup(java.lang.String sgroupId) 사이트 그룹에 해당하는 사용자 삭제하기
void	eminwonInfoUpdateUser(UserManageVO userManageVO) 새올 사용자정보 업데이트
void	eminwonUpdateUser(UserManageVO userManageVO) 새올 사용자 업데이트
UserManageVO	getUserInfoCerti(UserManageVO userManageVO)
java.util.List<UserManageVO>	getUserInfoEmail(UserManageVO userManageVO) 이메일을 통한 업무 사용자 정보 검색
UserManageVO	getUserInfoEmplyr(java.lang.String emplyrId) 해당 emplyrID 에 해당하는 업무 사용자 정보
java.util.List<UserManageVO>	getUserInfoMobile(UserManageVO userManageVO) 휴대전화 번호를 통한 업무 사용자 정보 검색
UserManageVO	getUserInfoUnique(java.lang.String uniqId)
void	insertUserManage(UserManageVO userManageVO) 업무사용자 저장하기
int	isExistUserId(java.lang.String checkId) 업무사용자 및 일반사용자에서 사용하는 아이디 찾기(중복허용 안함)
java.util.List<UserManageVO>	officeUserInfo(java.lang.String orgnztId) RFC 사용자 정보(새올사용자 비교용)
java.util.List<UserManageVO>	officeUserInfo2(java.lang.String orgnztId, java.util.HashMap map)
void	onnaraUpdateUser(UserManageVO userManageVO) 새올 사용자정보 업데이트
java.util.List<NewZipCodeVO>	searchNewZipCode(SearchNewZipCodeVO searchNewZipCodeVO) 새주소 검색
int	searchNewZipCodeCnt(SearchNewZipCodeVO searchNewZipCodeVO) 새주소 검색수
java.util.List<NZipCodeVO>	searchNZipCode(java.lang.String dong)
UserManageVO	searchUserId(UserManageVO userManageVO)
UserManageVO	searchUserPw(UserManageVO userManageVO)
UserManageVO	searchUserPwEtc(UserManageVO userManageVO)
UserManageVO	searchUserPwEtcId(UserManageVO userManageVO)
java.util.List<ZipCodeVO>	searchZipCode(java.lang.String dong) 일반주소 검색
java.util.List<UserManageVO>	selectManageListUCmessenger(UserManageVO userManageVO) UC Messenager day Batch list
java.util.List<UserManageVO>	selectUserManageList(UserManageVO userManageVO) 업무사용자 전체 목록
int	selectUserManageListTotCnt(UserManageVO userManageVO) 업무사용자 전체 갯수
void	updateUserManage(UserManageVO userManageVO) 업무사용자 수정하기
void	updateUserofficePart(UserManageVO userManageVO) 조직도 담당자선택
void	updateUserSttus(UserManageVO userManageVO) 업무 사용자 상태정보 수정
void	withdrawUser(java.lang.String uniqId) 업무 사용자 회원 탈퇴

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

UserManageDAO

public UserManageDAO()

Method Detail

selectUserManageListTotCnt

public int selectUserManageListTotCnt(UserManageVO userManageVO)
                               throws java.lang.Exception

업무사용자 전체 갯수

Parameters:

userManageVO -

Returns:

Throws:

java.lang.Exception

selectUserManageList

public java.util.List<UserManageVO> selectUserManageList(UserManageVO userManageVO)
                                                  throws java.lang.Exception

업무사용자 전체 목록

Parameters:

userManageVO -

Returns:

Throws:

java.lang.Exception

getUserInfoUnique

public UserManageVO getUserInfoUnique(java.lang.String uniqId)
                               throws java.lang.Exception

Throws:

java.lang.Exception

getUserInfoEmplyr

public UserManageVO getUserInfoEmplyr(java.lang.String emplyrId)
                               throws java.lang.Exception

해당 emplyrID 에 해당하는 업무 사용자 정보

Parameters:

uniqId -

Returns:

Throws:

java.lang.Exception

searchUserId

public UserManageVO searchUserId(UserManageVO userManageVO)
                          throws java.lang.Exception

Throws:

java.lang.Exception

searchUserPw

public UserManageVO searchUserPw(UserManageVO userManageVO)
                          throws java.lang.Exception

Throws:

java.lang.Exception

searchUserPwEtc

public UserManageVO searchUserPwEtc(UserManageVO userManageVO)
                             throws java.lang.Exception

Throws:

java.lang.Exception

searchUserPwEtcId

public UserManageVO searchUserPwEtcId(UserManageVO userManageVO)
                               throws java.lang.Exception

Throws:

java.lang.Exception

getUserInfoCerti

public UserManageVO getUserInfoCerti(UserManageVO userManageVO)
                              throws java.lang.Exception

Throws:

java.lang.Exception

insertUserManage

public void insertUserManage(UserManageVO userManageVO)
                      throws java.lang.Exception

업무사용자 저장하기

Parameters:

userManageVO -

Throws:

java.lang.Exception

isExistUserId

public int isExistUserId(java.lang.String checkId)
                  throws java.lang.Exception

업무사용자 및 일반사용자에서 사용하는 아이디 찾기(중복허용 안함)

Parameters:

checkId -

Returns:

Throws:

java.lang.Exception

updateUserManage

public void updateUserManage(UserManageVO userManageVO)
                      throws java.lang.Exception

업무사용자 수정하기

Parameters:

userManageVO -

Throws:

java.lang.Exception

withdrawUser

public void withdrawUser(java.lang.String uniqId)
                  throws java.lang.Exception

업무 사용자 회원 탈퇴

Parameters:

uniqId -

Throws:

java.lang.Exception

deleteUserManage

public void deleteUserManage(java.lang.String uniqId)
                      throws java.lang.Exception

업무사용자 삭제하기

Parameters:

uniqId -

Throws:

java.lang.Exception

deleteUserManageForSiteGroup

public void deleteUserManageForSiteGroup(java.lang.String sgroupId)
                                  throws java.lang.Exception

사이트 그룹에 해당하는 사용자 삭제하기

Parameters:

sgroupId -

Throws:

java.lang.Exception

searchZipCode

public java.util.List<ZipCodeVO> searchZipCode(java.lang.String dong)
                                        throws java.lang.Exception

일반주소 검색

Parameters:

dong -

Returns:

Throws:

java.lang.Exception

searchNZipCode

public java.util.List<NZipCodeVO> searchNZipCode(java.lang.String dong)
                                          throws java.lang.Exception

Throws:

java.lang.Exception

searchNewZipCodeCnt

public int searchNewZipCodeCnt(SearchNewZipCodeVO searchNewZipCodeVO)
                        throws java.lang.Exception

새주소 검색수

Parameters:

dong -

Returns:

Throws:

java.lang.Exception

searchNewZipCode

public java.util.List<NewZipCodeVO> searchNewZipCode(SearchNewZipCodeVO searchNewZipCodeVO)
                                              throws java.lang.Exception

새주소 검색

Parameters:

dong -

Returns:

Throws:

java.lang.Exception

updateUserSttus

public void updateUserSttus(UserManageVO userManageVO)
                     throws java.lang.Exception

업무 사용자 상태정보 수정

Parameters:

mberManageVO -

Throws:

java.lang.Exception

getUserInfoMobile

public java.util.List<UserManageVO> getUserInfoMobile(UserManageVO userManageVO)
                                               throws java.lang.Exception

휴대전화 번호를 통한 업무 사용자 정보 검색

Parameters:

userManageVO -

Returns:

Throws:

java.lang.Exception

getUserInfoEmail

public java.util.List<UserManageVO> getUserInfoEmail(UserManageVO userManageVO)
                                              throws java.lang.Exception

이메일을 통한 업무 사용자 정보 검색

Parameters:

userManageVO -

Returns:

Throws:

java.lang.Exception

selectManageListUCmessenger

public java.util.List<UserManageVO> selectManageListUCmessenger(UserManageVO userManageVO)
                                                         throws java.lang.Exception

UC Messenager day Batch list

Parameters:

userManageVO -

Returns:

Throws:

java.lang.Exception

updateUserofficePart

public void updateUserofficePart(UserManageVO userManageVO)
                          throws java.lang.Exception

조직도 담당자선택

Parameters:

userManageVO -

Throws:

java.lang.Exception

eminwonUpdateUser

public void eminwonUpdateUser(UserManageVO userManageVO)
                       throws java.lang.Exception

새올 사용자 업데이트

Parameters:

userManageVO -

Throws:

java.lang.Exception

officeUserInfo

public java.util.List<UserManageVO> officeUserInfo(java.lang.String orgnztId)
                                            throws java.lang.Exception

RFC 사용자 정보(새올사용자 비교용)

Parameters:

userManageVO -

Throws:

java.lang.Exception

officeUserInfo2

public java.util.List<UserManageVO> officeUserInfo2(java.lang.String orgnztId,
                                                    java.util.HashMap map)
                                             throws java.lang.Exception

Throws:

java.lang.Exception

eminwonInfoUpdateUser

public void eminwonInfoUpdateUser(UserManageVO userManageVO)
                           throws java.lang.Exception

새올 사용자정보 업데이트

Parameters:

userManageVO -

Throws:

java.lang.Exception

onnaraUpdateUser

public void onnaraUpdateUser(UserManageVO userManageVO)
                      throws java.lang.Exception

새올 사용자정보 업데이트

Parameters:

userManageVO -

Throws:

java.lang.Exception