|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectskoinfo.rfc.office.dao.OfficeDAO
public class OfficeDAO
Constructor Summary | |
---|---|
OfficeDAO()
|
Method Summary | |
---|---|
java.lang.String |
deleteOfficeCode(org.hibernate.Session session,
OfficeVO officeVO)
조직도 삭제 |
void |
deleteOfficePart(org.hibernate.Session session,
OfficePartVO officePartVO)
담당자 삭제 |
OfficeVO |
getOfficeCd(org.hibernate.Session session,
java.lang.String officeCd)
조직도 코드로 조직도 정보가져오기 |
OfficeVO |
getOfficeCd(org.hibernate.Session session,
java.lang.String officeCd,
java.lang.String isUse,
int depth)
차수에 맞는 조직도 목록 DAO |
java.lang.String |
getOfficeFullName(org.hibernate.Session session,
java.lang.String officeCd,
java.lang.String split)
부서 이름 가져오기 |
OfficeVO |
getOfficeName(org.hibernate.Session session,
java.lang.String officeCd)
부서 이름 가져오기 |
java.util.List<OfficePartVO> |
getOfficePartInfoList(org.hibernate.Session session,
java.lang.String officeCd,
java.lang.String mode)
실과소 홈페이지 담당자 정보 가져오기 |
java.util.List<OfficeVO> |
getTotalOffice(org.hibernate.Session session,
boolean officeIsUse)
|
java.util.List<OfficeVO> |
office1ThList(org.hibernate.Session session)
1차조직도 목록 DAO |
java.util.List<OfficeVO> |
office1ThList(org.hibernate.Session session,
java.lang.String isBoard)
|
OfficeVO |
officeBoardDataCount(org.hibernate.Session session,
java.lang.String officeCd,
java.lang.String groupCd,
long boardSid,
java.lang.String searchStartDt,
java.lang.String searchEndDt)
부서별 게시판 통계 [2009-12-21 : 원서형] |
java.util.List<OfficeVO> |
officeBoardDataList(org.hibernate.Session session,
int officeDp,
java.lang.String officeCd,
int beginRow,
int rowCount,
java.util.ArrayList orderByList)
조직도 목록 DAO |
java.util.List<OfficeVO> |
officeCodeList(org.hibernate.Session session,
int officeDp,
java.lang.String officeCd,
int beginRow,
int rowCount,
java.util.ArrayList orderByList)
조직도 목록 DAO |
int |
officeCodeListCount(org.hibernate.Session session,
int officeDp,
java.lang.String officeCd)
조직도 목록 카운트 DAO |
java.util.List<OfficeVO> |
officeCodePartList(org.hibernate.Session session,
java.lang.String officeCd)
부서별 조직도 목록 DAO |
java.util.List<OfficeVO> |
officeParentList(org.hibernate.Session session,
java.lang.String officeCd)
조직도의 하위 부서 가져오기 |
java.util.List<OfficeVO> |
officeParentList(org.hibernate.Session session,
java.lang.String officeCd,
java.lang.String isUse)
|
OfficePartVO |
officePartInfo(org.hibernate.Session session,
long officePtSid)
담당자 정보 DAO |
java.util.List<OfficePartVO> |
officePartList(org.hibernate.Session session,
java.lang.String officeCd)
담당자 목록 DAO |
java.util.List<OfficePartVO> |
officePartList(org.hibernate.Session session,
java.lang.String officeCd,
int beginRow,
int rowCount)
담당자 목록 DAO |
java.util.List<OfficePartVO> |
officePartList(org.hibernate.Session session,
java.lang.String officeCd,
int beginRow,
int rowCount,
java.lang.String searchType,
java.lang.String keyword)
담당자 목록 DAO |
java.util.List<OfficePartVO> |
officePartList(org.hibernate.Session session,
java.lang.String officeCd,
java.lang.String isAll)
담당자 목록 DAO |
java.util.List<OfficePartVO> |
officePartList(org.hibernate.Session session,
java.lang.String officeCd,
java.lang.String isUse,
int beginRow,
int rowCount,
java.lang.String isAll)
담당자 목록 DAO |
java.util.List<OfficePartVO> |
officePartList(org.hibernate.Session session,
java.lang.String officeCd,
java.lang.String isUse,
int beginRow,
int rowCount,
java.lang.String isAll,
java.lang.String searchType,
java.lang.String keyword)
담당자 목록 DAO |
int |
officePartListCount(org.hibernate.Session session,
java.lang.String officeCd,
java.lang.String searchType,
java.lang.String keyword)
담당자 목록 카운트 DAO |
int |
officePartListCount(org.hibernate.Session session,
java.lang.String officeCd,
java.lang.String isUse,
java.lang.String searchType,
java.lang.String keyword)
담당자 목록 카운트 DAO |
int |
officePartListCount(org.hibernate.Session session,
java.lang.String officeCd,
java.lang.String isUse,
java.lang.String isAll,
java.lang.String searchType,
java.lang.String keyword)
담당자 목록 카운트 DAO |
int |
officePartListCounts(org.hibernate.Session session,
java.lang.String officeCd,
java.lang.String searchType,
java.lang.String keyword)
담당자 목록 카운트 DAO(관리자가 아닌 특정부서 관리자 사용 ) |
java.util.List<OfficePartVO> |
officePartLists(org.hibernate.Session session,
java.lang.String officeCd,
int beginRow,
int rowCount,
java.lang.String searchType,
java.lang.String keyword)
담당자 목록 DAO |
java.util.List<OfficePartVO> |
officePartLists(org.hibernate.Session session,
java.lang.String officeCd,
java.lang.String isUse,
int beginRow,
int rowCount,
java.lang.String isAll,
java.lang.String searchType,
java.lang.String keyword)
담당자 목록 DAO |
java.util.List<OfficePartVO> |
officePartListSort(org.hibernate.Session session,
java.lang.String officeCd)
1. |
int |
officePartUserCount(org.hibernate.Session session,
java.lang.String userId)
담당자 목록 카운트 DAO |
int |
officePartUserCount(org.hibernate.Session session,
java.lang.String userId,
long sid)
담당자 목록 카운트 DAO |
void |
officePartUserDelete(org.hibernate.Session session,
OfficePartVO officePartVO)
1. |
int |
officePartUserUpdate(org.hibernate.Session session,
OfficePartVO officePartVO)
|
java.util.List<OfficeVO> |
searchOfficeCodeList(org.hibernate.Session session,
int officeDp,
java.lang.String officeCd,
int beginRow,
int rowCount,
java.util.ArrayList orderByList)
조직도 자식 최근값 검색 목록 DAO |
java.util.List<OfficeVO> |
searchSubOfficeCodeList(org.hibernate.Session session,
java.lang.String officeCd)
서브 조직도 검색 목록 DAO |
java.util.List<OfficeVO> |
searchSubOfficeCodeList(org.hibernate.Session session,
java.lang.String officeCd,
java.lang.String isBoard)
|
void |
updateOfficeCode(org.hibernate.Session session,
OfficeVO officeVO)
조직도 수정 DAO |
void |
updateOfficePart(org.hibernate.Session session,
OfficePartVO officePartVO)
담당자 수정 DAO |
void |
updateOfficePartSort(org.hibernate.Session session,
java.lang.String getOfficePtSid,
java.lang.String level)
|
OfficeVO |
viewOfficeCode(org.hibernate.Session session,
OfficeVO viewVO)
조직도 스퀀스 번호로 보기 DAO |
OfficePartVO |
viewOfficePart(org.hibernate.Session session,
OfficePartVO viewVO)
담당관리 스퀀스 번호로 보기 DAO |
void |
writeOfficeCode(org.hibernate.Session session,
OfficeVO officeVO)
조직도 Insert |
void |
writeOfficePart(org.hibernate.Session session,
OfficePartVO officePartVO)
담당자 Insert |
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public OfficeDAO()
Method Detail |
---|
public int officeCodeListCount(org.hibernate.Session session, int officeDp, java.lang.String officeCd) throws java.lang.Exception
officeDp
- 조직도depthofficeCd
- 조직도코드
java.lang.Exception
- 처리public java.util.List<OfficeVO> officeCodeList(org.hibernate.Session session, int officeDp, java.lang.String officeCd, int beginRow, int rowCount, java.util.ArrayList orderByList) throws java.lang.Exception
officeDp
- 조직도 depthofficeCd
- 조직도코드beginRow
- 페이지 시작 위치rowCount
- 가져올 자료수orderByList
- 정렬할 필드정의
java.lang.Exception
- 처리public java.util.List<OfficeVO> getTotalOffice(org.hibernate.Session session, boolean officeIsUse)
public java.util.List<OfficeVO> officeBoardDataList(org.hibernate.Session session, int officeDp, java.lang.String officeCd, int beginRow, int rowCount, java.util.ArrayList orderByList) throws java.lang.Exception
officeDp
- 조직도 depthofficeCd
- 조직도코드beginRow
- 페이지 시작 위치rowCount
- 가져올 자료수orderByList
- 정렬할 필드정의
java.lang.Exception
- 처리public OfficeVO officeBoardDataCount(org.hibernate.Session session, java.lang.String officeCd, java.lang.String groupCd, long boardSid, java.lang.String searchStartDt, java.lang.String searchEndDt)
session
- officeCd
- groupCd
- boardSid
- searchStartDt
- searchEndDt
-
public java.util.List<OfficeVO> officeCodePartList(org.hibernate.Session session, java.lang.String officeCd) throws java.lang.Exception
officeCd
- 조직도코드orderByList
- 정렬할 필드정의
java.lang.Exception
- 처리public java.util.List<OfficeVO> searchOfficeCodeList(org.hibernate.Session session, int officeDp, java.lang.String officeCd, int beginRow, int rowCount, java.util.ArrayList orderByList) throws java.lang.Exception
officeDp
- 조직도depthofficeCd
- 조직도코드beginRow
- 페이지 시작 위치rowCount
- 가져올 자료수orderByList
- 정렬할 필드정의
java.lang.Exception
- 처리public java.util.List<OfficeVO> searchSubOfficeCodeList(org.hibernate.Session session, java.lang.String officeCd) throws java.lang.Exception
officeCd
- 조직도코드beginRow
- 페이지 시작 위치rowCount
- 가져올 자료수orderByList
- 정렬할 필드정의
java.lang.Exception
- 처리public java.util.List<OfficeVO> searchSubOfficeCodeList(org.hibernate.Session session, java.lang.String officeCd, java.lang.String isBoard) throws java.lang.Exception
java.lang.Exception
public java.util.List<OfficeVO> office1ThList(org.hibernate.Session session) throws java.lang.Exception
session
- 세션정보
java.lang.Exception
- 처리public java.util.List<OfficeVO> office1ThList(org.hibernate.Session session, java.lang.String isBoard) throws java.lang.Exception
java.lang.Exception
public OfficeVO getOfficeCd(org.hibernate.Session session, java.lang.String officeCd, java.lang.String isUse, int depth) throws java.lang.Exception
session
- 세션정보
java.lang.Exception
- 처리public OfficeVO getOfficeCd(org.hibernate.Session session, java.lang.String officeCd) throws java.lang.Exception
officeCd
- 조직도 코드
java.lang.Exception
- 처리public OfficeVO viewOfficeCode(org.hibernate.Session session, OfficeVO viewVO) throws java.lang.Exception
OfficeVO
- 가져올 OfficeVO
java.lang.Exception
- 처리public void writeOfficeCode(org.hibernate.Session session, OfficeVO officeVO)
menuVO
- public void updateOfficeCode(org.hibernate.Session session, OfficeVO officeVO) throws java.lang.Exception
OfficeVO
- 수정할 OfficeVO
java.lang.Exception
- 처리public java.lang.String deleteOfficeCode(org.hibernate.Session session, OfficeVO officeVO) throws java.lang.Exception
sid
- 삭제할 그릅번호
java.lang.Exception
- 처리public int officePartUserCount(org.hibernate.Session session, java.lang.String userId) throws java.lang.Exception
session
- 리소스userId
- 직원아이디
java.lang.Exception
- 처리public int officePartUserCount(org.hibernate.Session session, java.lang.String userId, long sid) throws java.lang.Exception
session
- 디비커넥션 정보userId
- 직원아이디sid
- 담당자목록번호
java.lang.Exception
- 처리public void officePartUserDelete(org.hibernate.Session session, OfficePartVO officePartVO) throws java.lang.Exception
1. MethodName : officePartUserDelete 2. ClassName : OfficeDAO 3. Comment : 담당관리 부서변경시 부서비움 초기화 4. 작성자 : 박형민 5. 작성일 : 2010. 8. 25. 오후 4:52:16
session
- officePartVO
-
java.lang.Exception
public int officePartUserUpdate(org.hibernate.Session session, OfficePartVO officePartVO)
public int officePartListCounts(org.hibernate.Session session, java.lang.String officeCd, java.lang.String searchType, java.lang.String keyword) throws java.lang.Exception
session
- 디비커넥션 정보officeCd
- 조직도코드
java.lang.Exception
- 처리public int officePartListCount(org.hibernate.Session session, java.lang.String officeCd, java.lang.String searchType, java.lang.String keyword) throws java.lang.Exception
session
- 디비커넥션 정보officeCd
- 조직도코드
java.lang.Exception
- 처리public int officePartListCount(org.hibernate.Session session, java.lang.String officeCd, java.lang.String isUse, java.lang.String searchType, java.lang.String keyword) throws java.lang.Exception
session
- 디비커넥션 정보officeCd
- 조직도코드isUse
- 사용여부 'true':사용되는 자료
java.lang.Exception
- 처리public int officePartListCount(org.hibernate.Session session, java.lang.String officeCd, java.lang.String isUse, java.lang.String isAll, java.lang.String searchType, java.lang.String keyword) throws java.lang.Exception
session
- 디비커넥션 정보officeCd
- 조직도코드isUse
- 사용여부 'true':사용되는 자료
java.lang.Exception
- 처리public java.util.List<OfficePartVO> officePartList(org.hibernate.Session session, java.lang.String officeCd) throws java.lang.Exception
officeCd
- 조직도코드
java.lang.Exception
- 처리public java.util.List<OfficePartVO> officePartList(org.hibernate.Session session, java.lang.String officeCd, java.lang.String isAll) throws java.lang.Exception
officeCd
- 조직도코드isAll
- 초기에 전체로딩여부
java.lang.Exception
- 처리public java.util.List<OfficePartVO> officePartList(org.hibernate.Session session, java.lang.String officeCd, int beginRow, int rowCount) throws java.lang.Exception
officeCd
- 조직도코드beginRow
- 페이지 시작 위치rowCount
- 가져올 자료수orderByList
- 정렬할 필드정의
java.lang.Exception
- 처리public java.util.List<OfficePartVO> officePartLists(org.hibernate.Session session, java.lang.String officeCd, int beginRow, int rowCount, java.lang.String searchType, java.lang.String keyword) throws java.lang.Exception
officeCd
- 조직도코드beginRow
- 페이지 시작 위치rowCount
- 가져올 자료수orderByList
- 정렬할 필드정의
java.lang.Exception
- 처리public java.util.List<OfficePartVO> officePartList(org.hibernate.Session session, java.lang.String officeCd, int beginRow, int rowCount, java.lang.String searchType, java.lang.String keyword) throws java.lang.Exception
officeCd
- 조직도코드beginRow
- 페이지 시작 위치rowCount
- 가져올 자료수orderByList
- 정렬할 필드정의
java.lang.Exception
- 처리public java.util.List<OfficePartVO> officePartListSort(org.hibernate.Session session, java.lang.String officeCd)
1. MethodName : officePartListSort 2. ClassName : OfficeDAO 3. Comment : 부서코드 = 전체 리스트를 가져옴 4. 작성자 : 박형민 5. 작성일 : 2010. 8. 26. 오전 11:21:49
session
- officeCd
-
public void updateOfficePartSort(org.hibernate.Session session, java.lang.String getOfficePtSid, java.lang.String level) throws java.lang.Exception
java.lang.Exception
public java.util.List<OfficePartVO> officePartList(org.hibernate.Session session, java.lang.String officeCd, java.lang.String isUse, int beginRow, int rowCount, java.lang.String isAll) throws java.lang.Exception
officeCd
- 조직도코드isUse
- 사용여부 'true':사용되는 자료beginRow
- 페이지 시작 위치rowCount
- 가져올 자료수isAll
- 초기에 전체로딩여부
java.lang.Exception
- 처리public java.util.List<OfficePartVO> officePartLists(org.hibernate.Session session, java.lang.String officeCd, java.lang.String isUse, int beginRow, int rowCount, java.lang.String isAll, java.lang.String searchType, java.lang.String keyword) throws java.lang.Exception
officeCd
- 조직도코드isUse
- 사용여부 'true':사용되는 자료beginRow
- 페이지 시작 위치rowCount
- 가져올 자료수isAll
- 초기에 전체로딩여부
java.lang.Exception
- 처리public java.util.List<OfficePartVO> officePartList(org.hibernate.Session session, java.lang.String officeCd, java.lang.String isUse, int beginRow, int rowCount, java.lang.String isAll, java.lang.String searchType, java.lang.String keyword) throws java.lang.Exception
officeCd
- 조직도코드isUse
- 사용여부 'true':사용되는 자료beginRow
- 페이지 시작 위치rowCount
- 가져올 자료수isAll
- 초기에 전체로딩여부searchType
- 검색필드keyword
- 검색값
java.lang.Exception
- 처리public OfficePartVO officePartInfo(org.hibernate.Session session, long officePtSid) throws java.lang.Exception
session
- 세션정보officePtSid
- 담당자번호
java.lang.Exception
- 처리public OfficePartVO viewOfficePart(org.hibernate.Session session, OfficePartVO viewVO) throws java.lang.Exception
OfficeVO
- 가져올 OfficeVO
java.lang.Exception
- 처리public void writeOfficePart(org.hibernate.Session session, OfficePartVO officePartVO)
officePartVO
- 담당자 정보public void updateOfficePart(org.hibernate.Session session, OfficePartVO officePartVO) throws java.lang.Exception
officePartVO
- 담당자 정보
java.lang.Exception
- 처리public void deleteOfficePart(org.hibernate.Session session, OfficePartVO officePartVO) throws java.lang.Exception
officePartVO
- 담당자 정보
java.lang.Exception
- 처리public java.util.List<OfficePartVO> getOfficePartInfoList(org.hibernate.Session session, java.lang.String officeCd, java.lang.String mode) throws java.lang.Exception
session
- 디비세션정보officeCd
- 부서코드mode
- 부서담당자 위치(0:해당부서수장정보,1:전체 담당,담당자 정보,2:해당 담당자 정보)
java.lang.Exception
- 처리public java.util.List<OfficeVO> officeParentList(org.hibernate.Session session, java.lang.String officeCd) throws java.lang.Exception
session
- 디비세션정보officeCd
- 부서코드
java.lang.Exception
- 처리public java.util.List<OfficeVO> officeParentList(org.hibernate.Session session, java.lang.String officeCd, java.lang.String isUse) throws java.lang.Exception
java.lang.Exception
public OfficeVO getOfficeName(org.hibernate.Session session, java.lang.String officeCd)
officeCd
- 부서 코드
java.lang.Exception
- 처리public java.lang.String getOfficeFullName(org.hibernate.Session session, java.lang.String officeCd, java.lang.String split) throws java.lang.Exception
officeCd
- 부서 코드
java.lang.Exception
- 처리
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |