Overview  Package   Class  Use  Tree  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD

skoinfo.rfc.board.dao
Class BoardDAO

java.lang.Object
  extended by com.opensymphony.xwork2.ActionSupport
      extended by skoinfo.rfc.common.action.AbstractAction
          extended by skoinfo.rfc.board.dao.BoardDAO
All Implemented Interfaces:
com.opensymphony.xwork2.Action, com.opensymphony.xwork2.LocaleProvider, com.opensymphony.xwork2.TextProvider, com.opensymphony.xwork2.Validateable, com.opensymphony.xwork2.ValidationAware, java.io.Serializable
public class BoardDAO
extends AbstractAction

Board DAO

Version:
RFC 1.1 Release, 2008.10.20
Author:
허성철
See Also:
Serialized Form

Field Summary
 
Fields inherited from interface com.opensymphony.xwork2.Action
ERROR, INPUT, LOGIN, NONE, SUCCESS
 
Constructor Summary
BoardDAO()
           
 
Method Summary
 java.util.ArrayList<BoardFileVO> addFileList(org.hibernate.Session session, java.util.HashMap params, BoardVO boardVO, BoardDataVO boardDataVO, java.lang.String command)
           
 java.util.List<BoardBackUpVO> boardBackUpList(org.hibernate.Session session, java.lang.String groupCd, long boardSid, java.lang.String layerId, int rowCount)
          게시판스킨 List [원서형 : 2009-10-28]
 java.lang.String boardCleanerFilter(org.hibernate.Session session, BoardVO boardVO, BoardDataVO boardDataVO, GroupVO groupVO, java.lang.String rootPath, java.lang.String uploadPath, java.lang.String command, SessionManager sm, java.util.HashMap params)
          Data 보드클리너 필터
 void deleteBoard(org.hibernate.Session session, BoardVO boardVO)
          Board Delete
 void deleteBoardAdmin(org.hibernate.Session session, BoardAdminVO boardAdminVO)
          관리자 삭제
 void deleteBoardData(org.hibernate.Session session, BoardVO boardVO, long dataSid, SessionManager sm)
          게시물 및 첨부파일 삭제
 void deleteBoardFile(org.hibernate.Session session, long fileSid)
          첨부파일 삭제
 void deleteBoardReply(org.hibernate.Session session, long dataSid)
          민원게시판 등록 [2009-11-25 : 원서형]
 void deleteCategory(org.hibernate.Session session, CategoryVO categoryVO)
          Category Delete
 void deleteComment(org.hibernate.Session session, long commentSid)
          Comment 삭제
 void deleteComments(org.hibernate.Session session, long commentSid)
          첨부파일 삭제
 java.util.List<BoardFileVO> deleteDBBoardData(org.hibernate.Session session, BoardVO boardVO, BoardDataVO boardDataVO)
          게시물 및 첨부파일 영구삭제
 void deleteExtension(org.hibernate.Session session, ExtensionVO extensionVO)
          Extension Delete
 java.lang.String filterData(org.hibernate.Session session, BoardVO boardVO, BoardDataVO boardDataVO, java.lang.String rootPath, java.lang.String uploadPath, SessionManager sm, java.util.HashMap params)
          Data 필터
 BoardVO getBoard(org.hibernate.Session session, long boardSid)
          Get Board Info
 BoardVO getBoard(org.hibernate.Session session, java.lang.String boardId)
          Get Board Info
 java.util.List<BoardAdminVO> getBoardAdminList(org.hibernate.Session session, long boardSid)
          관리자 정보 가져오기
 int getBoardAdminUserCount(org.hibernate.Session session, long boardSid, java.lang.String userId)
          관리자 등록정보
 java.util.List<BoardDataVO> getBoardAllReplyDataList(org.hibernate.Session session, BoardVO boardVO, boolean isManager, int dataIdx)
          전체 답변글 리스트[민원형 게시판에서 사용:정상,차단]
 BoardVO getBoardCheckGroup(org.hibernate.Session session, java.lang.String boardId)
          Get Board Info
 int getBoardCount(org.hibernate.Session session, java.lang.String groupCd, java.lang.String boardType, java.lang.String searchType, java.lang.String keyword)
          Board Count
 BoardDataVO getBoardData(org.hibernate.Session session, long dataSid, boolean isManager, java.lang.String userId, java.lang.String command)
          Data 정보 가져오기
 BoardDataVO getBoardData(org.hibernate.Session session, long boardSid, int dataIdx, int dataRef, boolean isManager, java.lang.String userId, java.lang.String command)
          Data 정보 가져오기
 int getBoardDataCount(org.hibernate.Session session, BoardVO boardVO, java.lang.String userId, boolean isManager, java.lang.String searchType, java.lang.String keyword, java.lang.String categoryCode1, java.lang.String categoryCode2, java.lang.String categoryCode3)
          Board Data Count
 int getBoardDataCount(org.hibernate.Session session, BoardVO boardVO, java.lang.String userId, boolean isManager, java.lang.String searchType, java.lang.String keyword, java.lang.String searchStartDt, java.lang.String searchEndDt, java.lang.String categoryCode1, java.lang.String categoryCode2, java.lang.String categoryCode3)
          Board Data Count
 int getBoardDataCount(org.hibernate.Session session, BoardVO boardVO, java.lang.String userId, boolean isManager, java.lang.String searchType, java.lang.String keyword, java.lang.String searchStartDt, java.lang.String searchEndDt, java.lang.String categoryCode1, java.lang.String categoryCode2, java.lang.String categoryCode3, java.lang.String officeCd)
           
 int getBoardDataCount(org.hibernate.Session session, java.lang.String boardSid, java.lang.String userId, java.lang.String searchType, java.lang.String keyword, java.lang.String categoryCode1, java.lang.String categoryCode2, java.lang.String categoryCode3)
          Board Data Count 비동기식(DWR) 요청에서 사용되는 함수
 BoardDataVO getboardDataIdx(org.hibernate.Session session, int dataIdx)
           
 java.util.List<BoardDataVO> getBoardDataList(org.hibernate.Session session, BoardVO boardVO, java.lang.String userId, boolean isManager, java.lang.String searchType, java.lang.String keyword, java.lang.String categoryCode1, java.lang.String categoryCode2, java.lang.String categoryCode3, int beginRow, int rowCount, java.util.ArrayList orderByList)
          Board List
 java.util.List<BoardDataVO> getBoardDataList(org.hibernate.Session session, BoardVO boardVO, java.lang.String userId, boolean isManager, java.lang.String searchType, java.lang.String keyword, java.lang.String searchStartDt, java.lang.String searchEndDt, java.lang.String categoryCode1, java.lang.String categoryCode2, java.lang.String categoryCode3, int beginRow, int rowCount, java.util.ArrayList orderByList)
          Board List [2009-11-10]
 java.util.List<BoardDataVO> getBoardDataList(org.hibernate.Session session, BoardVO boardVO, java.lang.String userId, boolean isManager, java.lang.String searchType, java.lang.String keyword, java.lang.String searchStartDt, java.lang.String searchEndDt, java.lang.String categoryCode1, java.lang.String categoryCode2, java.lang.String categoryCode3, int beginRow, int rowCount, java.util.ArrayList orderByList, java.lang.String officeCd)
           
 java.util.List<BoardDataVO> getBoardDataList(org.hibernate.Session session, java.lang.String boardSid, java.lang.String userId, java.lang.String searchType, java.lang.String keyword, java.lang.String categoryCode1, java.lang.String categoryCode2, java.lang.String categoryCode3, int beginRow, int rowCount, java.util.ArrayList orderByList)
          Board Data List 게시물 리스트 비동기식(DWR) 요청에서 사용되는 함수
 java.util.List<BoardDataVO> getBoardDataUserList(org.hibernate.Session session, long boardSid, java.lang.String whereSql, java.util.ArrayList orderByList, int count)
          getBoardDataUserList (사용자 쿼리로 게시판 정보 가져오기:최대 10개만 가져옴(부하로드 감소목적)
 BoardFileVO getBoardFile(org.hibernate.Session session, long fileSid, boolean isManager)
          첨부파일 정보 가져오기[다운로드시 사용]
 java.util.List<BoardFileVO> getBoardFileList(org.hibernate.Session session, long dataSid)
          첨부파일 정보 가져오기[삭제된 파일 제외]
 java.lang.String getBoardId(org.hibernate.Session session, long boardSid)
          Get Board ID
 java.util.List<BoardVO> getBoardList(org.hibernate.Session session)
          Board List(허성철 추가 :cms용)
 java.util.List<BoardVO> getBoardList(org.hibernate.Session session, java.lang.String groupCd)
           
 java.util.List<BoardVO> getBoardList(org.hibernate.Session session, java.lang.String groupCd, java.lang.String searchType, java.lang.String keyword, java.lang.String boardType, int beginRow, int rowCount, java.util.ArrayList orderByList)
          Board List
 java.util.List<BoardVO> getBoardListCms(org.hibernate.Session session)
           
 java.util.List<BoardVO> getBoardListCms(org.hibernate.Session session, java.lang.String groupCd)
           
 int getBoardListCount(org.hibernate.Session session, java.lang.String groupCd, java.lang.String searchField, java.lang.String keyword, long boardSid, java.lang.String deleteStatus, java.lang.String dataStatus, java.lang.String mobileIsUse, int userLevel)
          게시물 관리의 게시물 목록 수 [2009-09-24]
 java.util.List<BoardDataVO> getBoardListList(org.hibernate.Session session, java.lang.String groupCd, java.lang.String searchField, java.lang.String keyword, long boardSid, int beginRow, int rowCount, java.util.ArrayList orderByList, java.lang.String deleteStatus, java.lang.String dataStatus, java.lang.String mobileIsUse, int userLevel)
          게시물 관리의 게시물 목록 [2009-09-24]
 int getBoardLogCount(org.hibernate.Session session, java.lang.String groupCd, long boardSid)
          Board Log Count
 int getBoardLogCount(org.hibernate.Session session, java.lang.String groupCd, java.lang.String searchField, java.lang.String keyword, long boardSid)
          Board Log Count
 java.util.List<BoardLogVO> getBoardLogList(org.hibernate.Session session, java.lang.String groupCd, long boardSid, java.lang.String actionType, int beginRow, int rowCount, java.util.ArrayList orderByList)
          Board Log List
 java.util.List<BoardLogVO> getBoardLogList(org.hibernate.Session session, java.lang.String groupCd, java.lang.String searchField, java.lang.String keyword, long boardSid, int beginRow, int rowCount, java.util.ArrayList orderByList)
           
 BoardVO getBoardMain(org.hibernate.Session session, long boardSid)
          Get Board Info
 BoardVO getBoardMain(org.hibernate.Session session, java.lang.String boardId)
          Get Board Info
 java.util.List<BoardDataVO> getBoardOrginDataList(org.hibernate.Session session, int dataIdx)
          답변글의 최초 원본글 가져오기
 java.util.List<BoardDataVO> getBoardRecentDataList(org.hibernate.Session session, BoardVO boardVO, java.lang.String userId, java.lang.String searchType, java.lang.String keyword, java.lang.String categoryCode1, java.lang.String categoryCode2, java.lang.String categoryCode3, int beginRow, int rowCount, java.util.ArrayList orderByList)
          최근 게시물 Board List(동기,비동기)
 int getBoardReplyCount(org.hibernate.Session session, int dataIdx, int dataRef)
          최초 원글에 대한 전체 답변글 목록수
 int getBoardReplyCount(org.hibernate.Session session, int dataIdx, int dataRef, long boardSid)
          해당 게시판에 대한 최초 원글에 대한 전체 답변갯수
 java.util.List<BoardDataVO> getBoardReplyDataList(org.hibernate.Session session, int dataIdx, int dataRef, int dataDep)
          해당글에대한 답변글 가져오기[게시물 보기에서 사용]
 int getBoardReplyOfficeCount(org.hibernate.Session session, java.lang.String pcode, long boardSid, java.lang.String searchType, java.lang.String keyword)
          민원게시판 해당 부서이하 글 카운트
 java.util.List<BoardReplyVO> getBoardReplyOfficeList(org.hibernate.Session session, long dataSid)
           
 java.util.List<BoardDataVO> getBoardReplyOfficeList(org.hibernate.Session session, java.lang.String pcode, long boardSid, int beginRow, int rowCount, java.lang.String searchType, java.lang.String keyword)
          민원게시판 해당 부서이하 글 가져오기
 int getBoardReplySubCount(org.hibernate.Session session, int dataIdx, int dataRef, int dataDep)
          원본보호갯수에서 사용(바로 하위 답변갯수 구하기)
 java.util.List<BoardDataVO> getBoardWeekDataList(org.hibernate.Session session, BoardVO boardVO, java.lang.String userId, java.lang.String searchType, java.lang.String keyword, java.lang.String categoryCode1, java.lang.String categoryCode2, java.lang.String categoryCode3, int beginRow, int rowCount, java.lang.String strartDt, java.lang.String endDt, java.util.ArrayList orderByList)
          비동기 시작날짜와 마지막날짜 사이의 게시물 Board List
 java.util.List<BoardDataVO> getBoardWeekDataListEtc(org.hibernate.Session session, java.lang.String boardSid, java.lang.String userId, java.lang.String searchType, java.lang.String keyword, java.lang.String categoryCode1, java.lang.String categoryCode2, java.lang.String categoryCode3, int beginRow, int rowCount, java.lang.String strartDt, java.lang.String endDt, java.util.ArrayList orderByList)
          N개의 게시판 Sid 를 이용하여 기간검색된 게시물을 가져온다 [2010-01-07] 양민욱
 int getCategoryCount(org.hibernate.Session session, CategoryVO categoryVO)
          Extension Count ExtensionVO
 java.util.List<CategoryVO> getCategoryList(org.hibernate.Session session, java.lang.String boardId, int depth)
          CategoryVO List(허성철 추가 :cms용)
 CommentVO getComment(org.hibernate.Session session, long commentSid)
          Comment 등록
 int getCommentCount(org.hibernate.Session session, long dataSid)
          Comment Count
 int getCommentCount(org.hibernate.Session session, long dataSid, java.lang.String flag)
           
 java.util.List<CommentVO> getCommentList(org.hibernate.Session session, long dataSid, int beginRow, int rowCount)
          Comment List
 java.util.List<CommentVO> getCommentList(org.hibernate.Session session, long dataSid, int beginRow, int rowCount, java.lang.String flag)
           
 int getCommentManagerCount(org.hibernate.Session session, int searchField, java.lang.String keyword, java.lang.String flag, boolean isManager)
          코멘트 관리기능
 java.util.List<CommentVO> getCommentManagerList(org.hibernate.Session session, int searchField, java.lang.String keyword, int beginRow, int rowCount, java.lang.String flag, boolean isManager)
          코멘트 관리기능
 int getExtensionCount(org.hibernate.Session session, ExtensionVO extensionVO)
          Extension Count ExtensionVO
 int getLinkBoardCount(org.hibernate.Session session, java.lang.String boardId)
          Board link board count
 int getMobileDataCount(org.hibernate.Session session, java.lang.String searchType, java.lang.String keyword)
          모바일 검색 카운트 [2010-06-22 : 원서형]
 java.util.List<BoardDataVO> getMobileDataList(org.hibernate.Session session, java.lang.String searchType, java.lang.String keyword, int beginRow, int rowCount, java.util.ArrayList orderByList)
          모바일 검색 리스트 [2010-06-22 : 원서형]
 int getPointAvg(org.hibernate.Session session, long dataSid)
          Comment Star Point Sum
 boolean isBoardAdmin(org.hibernate.Session session, long boardSid, java.lang.String userId)
          Board Admin
 boolean isOfficeManager(org.hibernate.Session session, java.lang.String loginPcode, java.lang.String officePcode, int modiDepth)
           1.
 int searchDataCount(org.hibernate.Session session, java.lang.String keyword)
          게시물 통합검색 Count
 java.util.List<BoardDataVO> searchDataList(org.hibernate.Session session, java.lang.String keyword, int beginRow, int rowCount, java.util.ArrayList orderByList)
          게시물 통합검색
 void skinCopyBoard(org.hibernate.Session session, long boardSid, long srcBoardSid)
          스킨 복사
 void updateBoard(org.hibernate.Session session, BoardVO boardVO)
          Board Update
 void updateBoardAnswerStatus(org.hibernate.Session session, long dataSid, java.lang.String status)
          답변 상태 변경
 void updateBoardBackup(org.hibernate.Session session, BoardBackUpVO viewVO)
          게시판스킨 백업시점 업데이트 [원서형 2009-10-29]
 void updateBoardConfig(org.hibernate.Session session, BoardVO boardVO)
          Board Update Config
 void updateBoardData(org.hibernate.Session session, BoardDataVO boardDataVO)
          게시물 Data 수정
 BoardDataVO updateBoardData(org.hibernate.Session session, BoardVO boardVO, BoardDataVO boardDataVO, java.util.HashMap params, SessionManager sm)
          게시물 Data 수정
 void updateBoardDataRegister(org.hibernate.Session session, long dataSid, java.lang.String register_dt)
          게시물 등록날짜 수정 [2009-12-17 : 원서형]
 java.lang.String updateBoardDataStatus(org.hibernate.Session session, long dataSid, java.lang.String status)
          게시물 Data 상태 수정[차단 상태]
 void updateBoardLog(org.hibernate.Session session, long dataSid, java.lang.String actionType)
          게시판 로그 수정 [2009-11-23 : 원서형]
 BoardVO updateBoardSkin(org.hibernate.Session session, BoardVO boardVO)
          Board Update Skin
 void updateBoardViewCount(org.hibernate.Session session, BoardDataVO boardDataVO)
          Board hit Update
 void updateBoardViewCount(org.hibernate.Session session, long dataSid)
          Board hit Update
 void updateCategory(org.hibernate.Session session, CategoryVO categoryVO)
          Category Update
 java.lang.String updateDataEtcStatus(org.hibernate.Session session, long dataSid, java.lang.String status)
          게시물의 파일, 코멘트 Data 상태 수정 [2009-09-24]
 void updateExtension(org.hibernate.Session session, ExtensionVO extensionVO)
          Extension Update
 BoardVO viewBoard(org.hibernate.Session session, BoardVO boardVO)
          게시판스킨 보기 Select [원서형 : 2009-10-28]
 BoardBackUpVO viewBoardBackUp(org.hibernate.Session session, long boardBpSid)
          스킨백업 보기 DAO [원서형 2009-10-28]
 java.util.List<ExtensionVO> viewExtension(org.hibernate.Session session, long boardSid)
          Extension view(홍승민 추가 :boardCleaner용)
 void writeBoadAdmin(org.hibernate.Session session, BoardAdminVO boardAdminVO)
          관리자 등록
 int writeBoard(org.hibernate.Session session, BoardVO boardVO)
          Board Insert
 void writeBoardBackUp(org.hibernate.Session session, BoardVO origVO, SessionManager sm, java.lang.String layerId)
          게시판스킨백업 Insert [원서형 : 2009-10-28]
 BoardDataVO writeBoardData(org.hibernate.Session session, BoardVO boardVO, BoardDataVO boardDataVO, java.util.HashMap params, java.lang.String command, SessionManager sm, boolean isManager)
          게시물 Data 등록
 BoardDataVO writeBoardData(org.hibernate.Session session, BoardVO boardVO, BoardDataVO boardDataVO, java.util.HashMap params, java.lang.String command, java.lang.String userId, java.lang.String userName, java.lang.String userIp, boolean isManager)
          게시물 Data 등록(dwr) [원서형 : 2009-10-27]
 void writeBoardLog(org.hibernate.Session session, long boardSid, long dataSid, java.lang.String dataTitle, java.lang.String actionType, java.lang.String userId, java.lang.String userName, java.lang.String userIp, java.lang.String groupCd, java.lang.String boardId)
          게시판 로그 기록 [2009-11-23 : 원서형]
 void writeBoardReplys(org.hibernate.Session session, BoardReplyVO boardReplyVO)
           
 void writeCategory(org.hibernate.Session session, CategoryVO categoryVO)
          Category Insert
 void writeComment(org.hibernate.Session session, CommentVO commentVO)
          Comment 등록
 void writeExtension(org.hibernate.Session session, ExtensionVO extensionVO)
          Extension Insert
 void writeExtensionData(org.hibernate.Session session, long boardSid, long dataSid, java.util.Map<java.lang.String,java.lang.String> params)
          ExtensionData Insert
 
Methods inherited from class skoinfo.rfc.common.action.AbstractAction
getText, getText, getText, getText, getText, getText, getText, getText, getText, getTexts, getTexts
 
Methods inherited from class com.opensymphony.xwork2.ActionSupport
addActionError, addActionMessage, addFieldError, clearActionErrors, clearErrors, clearErrorsAndMessages, clearFieldErrors, clearMessages, clone, doDefault, execute, getActionErrors, getActionMessages, getErrorMessages, getErrors, getFieldErrors, getLocale, hasActionErrors, hasActionMessages, hasErrors, hasFieldErrors, hasKey, input, pause, setActionErrors, setActionMessages, setFieldErrors, validate
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

BoardDAO

public BoardDAO()
Method Detail

getBoardCount

public int getBoardCount(org.hibernate.Session session,
                         java.lang.String groupCd,
                         java.lang.String boardType,
                         java.lang.String searchType,
                         java.lang.String keyword)
Board Count

Parameters:
A:전체 - N:일반 S:시스템(필터)
Returns:
게시판 수

getBoardList

public java.util.List<BoardVO> getBoardList(org.hibernate.Session session,
                                            java.lang.String groupCd,
                                            java.lang.String searchType,
                                            java.lang.String keyword,
                                            java.lang.String boardType,
                                            int beginRow,
                                            int rowCount,
                                            java.util.ArrayList orderByList)
Board List

Parameters:
A:전체 - N:일반 S:시스템(필터)
시작 - 라인 위치
라인 - 수
라인 - 수
Returns:
Board List

getBoardList

public java.util.List<BoardVO> getBoardList(org.hibernate.Session session)
Board List(허성철 추가 :cms용)

Returns:
Board List

getBoardList

public java.util.List<BoardVO> getBoardList(org.hibernate.Session session,
                                            java.lang.String groupCd)

getBoardListCms

public java.util.List<BoardVO> getBoardListCms(org.hibernate.Session session)

getBoardListCms

public java.util.List<BoardVO> getBoardListCms(org.hibernate.Session session,
                                               java.lang.String groupCd)

getCategoryList

public java.util.List<CategoryVO> getCategoryList(org.hibernate.Session session,
                                                  java.lang.String boardId,
                                                  int depth)
CategoryVO List(허성철 추가 :cms용)

Returns:
Board List

getBoardMain

public BoardVO getBoardMain(org.hibernate.Session session,
                            java.lang.String boardId)
Get Board Info

Parameters:
board - Id
Returns:
BoardVO

getBoard

public BoardVO getBoard(org.hibernate.Session session,
                        java.lang.String boardId)
Get Board Info

Parameters:
board - Id
Returns:
BoardVO

getBoardMain

public BoardVO getBoardMain(org.hibernate.Session session,
                            long boardSid)
Get Board Info

Parameters:
boardSid -
Returns:
BoardVO

getBoard

public BoardVO getBoard(org.hibernate.Session session,
                        long boardSid)
Get Board Info

Parameters:
boardSid -
Returns:
BoardVO

getLinkBoardCount

public int getLinkBoardCount(org.hibernate.Session session,
                             java.lang.String boardId)
Board link board count

Parameters:
board - Id
Returns:
BoardVO

getBoardCheckGroup

public BoardVO getBoardCheckGroup(org.hibernate.Session session,
                                  java.lang.String boardId)
Get Board Info

Parameters:
boardSid -
Returns:
BoardVO

getBoardId

public java.lang.String getBoardId(org.hibernate.Session session,
                                   long boardSid)
Get Board ID

Parameters:
boardSid -
Returns:
String

writeBoard

public int writeBoard(org.hibernate.Session session,
                      BoardVO boardVO)
Board Insert

Parameters:
BoardVO -
Returns:
Board Sid

updateBoard

public void updateBoard(org.hibernate.Session session,
                        BoardVO boardVO)
Board Update

Parameters:
BoardVO -

updateBoardConfig

public void updateBoardConfig(org.hibernate.Session session,
                              BoardVO boardVO)
Board Update Config

Parameters:
BoardVO -

updateBoardSkin

public BoardVO updateBoardSkin(org.hibernate.Session session,
                               BoardVO boardVO)
Board Update Skin

Parameters:
BoardVO -

deleteBoard

public void deleteBoard(org.hibernate.Session session,
                        BoardVO boardVO)
Board Delete

Parameters:
BoardVO -

skinCopyBoard

public void skinCopyBoard(org.hibernate.Session session,
                          long boardSid,
                          long srcBoardSid)
스킨 복사

Parameters:
long -
long -

getCategoryCount

public int getCategoryCount(org.hibernate.Session session,
                            CategoryVO categoryVO)
Extension Count ExtensionVO

Returns:
게시판 수

writeCategory

public void writeCategory(org.hibernate.Session session,
                          CategoryVO categoryVO)
Category Insert

Parameters:
BoardVO -

updateCategory

public void updateCategory(org.hibernate.Session session,
                           CategoryVO categoryVO)
Category Update

Parameters:
BoardVO -

deleteCategory

public void deleteCategory(org.hibernate.Session session,
                           CategoryVO categoryVO)
Category Delete

Parameters:
BoardVO -

getExtensionCount

public int getExtensionCount(org.hibernate.Session session,
                             ExtensionVO extensionVO)
Extension Count ExtensionVO

Returns:
게시판 수

writeExtension

public void writeExtension(org.hibernate.Session session,
                           ExtensionVO extensionVO)
Extension Insert

Parameters:
BoardVO -

writeExtensionData

public void writeExtensionData(org.hibernate.Session session,
                               long boardSid,
                               long dataSid,
                               java.util.Map<java.lang.String,java.lang.String> params)
ExtensionData Insert

Parameters:
BoardVO -

updateExtension

public void updateExtension(org.hibernate.Session session,
                            ExtensionVO extensionVO)
Extension Update

Parameters:
BoardVO -

viewExtension

public java.util.List<ExtensionVO> viewExtension(org.hibernate.Session session,
                                                 long boardSid)
Extension view(홍승민 추가 :boardCleaner용)

Parameters:
boardSid -

deleteExtension

public void deleteExtension(org.hibernate.Session session,
                            ExtensionVO extensionVO)
Extension Delete

Parameters:
BoardVO -

searchDataCount

public int searchDataCount(org.hibernate.Session session,
                           java.lang.String keyword)
게시물 통합검색 Count

Parameters:
Session -
String -
Returns:
게시물 수

searchDataList

public java.util.List<BoardDataVO> searchDataList(org.hibernate.Session session,
                                                  java.lang.String keyword,
                                                  int beginRow,
                                                  int rowCount,
                                                  java.util.ArrayList orderByList)
게시물 통합검색

Parameters:
Session -
String -
int -
int -
ArrayList -
Returns:
List

getBoardDataCount

public int getBoardDataCount(org.hibernate.Session session,
                             BoardVO boardVO,
                             java.lang.String userId,
                             boolean isManager,
                             java.lang.String searchType,
                             java.lang.String keyword,
                             java.lang.String categoryCode1,
                             java.lang.String categoryCode2,
                             java.lang.String categoryCode3)
Board Data Count

Parameters:
A:전체 - N:일반 S:시스템(필터)
Returns:
게시판 수

getBoardDataCount

public int getBoardDataCount(org.hibernate.Session session,
                             BoardVO boardVO,
                             java.lang.String userId,
                             boolean isManager,
                             java.lang.String searchType,
                             java.lang.String keyword,
                             java.lang.String searchStartDt,
                             java.lang.String searchEndDt,
                             java.lang.String categoryCode1,
                             java.lang.String categoryCode2,
                             java.lang.String categoryCode3)
Board Data Count

Parameters:
A:전체 - N:일반 S:시스템(필터)
Returns:
게시판 수

getBoardDataCount

public int getBoardDataCount(org.hibernate.Session session,
                             BoardVO boardVO,
                             java.lang.String userId,
                             boolean isManager,
                             java.lang.String searchType,
                             java.lang.String keyword,
                             java.lang.String searchStartDt,
                             java.lang.String searchEndDt,
                             java.lang.String categoryCode1,
                             java.lang.String categoryCode2,
                             java.lang.String categoryCode3,
                             java.lang.String officeCd)

getBoardDataList

public java.util.List<BoardDataVO> getBoardDataList(org.hibernate.Session session,
                                                    BoardVO boardVO,
                                                    java.lang.String userId,
                                                    boolean isManager,
                                                    java.lang.String searchType,
                                                    java.lang.String keyword,
                                                    java.lang.String categoryCode1,
                                                    java.lang.String categoryCode2,
                                                    java.lang.String categoryCode3,
                                                    int beginRow,
                                                    int rowCount,
                                                    java.util.ArrayList orderByList)
Board List

Parameters:
게시판 - 정보
시작 - 라인 위치
라인 - 수
정렬 -
Returns:
Board List

getBoardDataList

public java.util.List<BoardDataVO> getBoardDataList(org.hibernate.Session session,
                                                    BoardVO boardVO,
                                                    java.lang.String userId,
                                                    boolean isManager,
                                                    java.lang.String searchType,
                                                    java.lang.String keyword,
                                                    java.lang.String searchStartDt,
                                                    java.lang.String searchEndDt,
                                                    java.lang.String categoryCode1,
                                                    java.lang.String categoryCode2,
                                                    java.lang.String categoryCode3,
                                                    int beginRow,
                                                    int rowCount,
                                                    java.util.ArrayList orderByList)
Board List [2009-11-10]

Parameters:
게시판 - 정보
시작 - 라인 위치
라인 - 수
정렬 -
Returns:
Board List 부서글 글목록 적용

getBoardDataList

public java.util.List<BoardDataVO> getBoardDataList(org.hibernate.Session session,
                                                    BoardVO boardVO,
                                                    java.lang.String userId,
                                                    boolean isManager,
                                                    java.lang.String searchType,
                                                    java.lang.String keyword,
                                                    java.lang.String searchStartDt,
                                                    java.lang.String searchEndDt,
                                                    java.lang.String categoryCode1,
                                                    java.lang.String categoryCode2,
                                                    java.lang.String categoryCode3,
                                                    int beginRow,
                                                    int rowCount,
                                                    java.util.ArrayList orderByList,
                                                    java.lang.String officeCd)

getBoardDataCount

public int getBoardDataCount(org.hibernate.Session session,
                             java.lang.String boardSid,
                             java.lang.String userId,
                             java.lang.String searchType,
                             java.lang.String keyword,
                             java.lang.String categoryCode1,
                             java.lang.String categoryCode2,
                             java.lang.String categoryCode3)
Board Data Count 비동기식(DWR) 요청에서 사용되는 함수

Parameters:
-
Returns:
게시물 수

getBoardDataList

public java.util.List<BoardDataVO> getBoardDataList(org.hibernate.Session session,
                                                    java.lang.String boardSid,
                                                    java.lang.String userId,
                                                    java.lang.String searchType,
                                                    java.lang.String keyword,
                                                    java.lang.String categoryCode1,
                                                    java.lang.String categoryCode2,
                                                    java.lang.String categoryCode3,
                                                    int beginRow,
                                                    int rowCount,
                                                    java.util.ArrayList orderByList)
Board Data List 게시물 리스트 비동기식(DWR) 요청에서 사용되는 함수

Parameters:
Session -
String -
String -
String -
String -
String -
String -
Returns:
List

getboardDataIdx

public BoardDataVO getboardDataIdx(org.hibernate.Session session,
                                   int dataIdx)

getBoardOrginDataList

public java.util.List<BoardDataVO> getBoardOrginDataList(org.hibernate.Session session,
                                                         int dataIdx)
답변글의 최초 원본글 가져오기

Parameters:
Hibernate - Session
dataIdx - 게시판 그룹정보
Returns:
Board data List

getBoardReplyDataList

public java.util.List<BoardDataVO> getBoardReplyDataList(org.hibernate.Session session,
                                                         int dataIdx,
                                                         int dataRef,
                                                         int dataDep)
해당글에대한 답변글 가져오기[게시물 보기에서 사용]

Parameters:
Hibernate - Session
dataIdx - 게시판 그룹정보
Returns:
Board data List

getBoardReplyCount

public int getBoardReplyCount(org.hibernate.Session session,
                              int dataIdx,
                              int dataRef)
최초 원글에 대한 전체 답변글 목록수

Parameters:
Hibernate - Session
dataIdx - 게시판 그룹정보
Returns:
Board data List

getBoardReplySubCount

public int getBoardReplySubCount(org.hibernate.Session session,
                                 int dataIdx,
                                 int dataRef,
                                 int dataDep)
원본보호갯수에서 사용(바로 하위 답변갯수 구하기)

Parameters:
session -
dataIdx -
dataRef -
dataDep -
Returns:

getBoardReplyCount

public int getBoardReplyCount(org.hibernate.Session session,
                              int dataIdx,
                              int dataRef,
                              long boardSid)
해당 게시판에 대한 최초 원글에 대한 전체 답변갯수

Parameters:
session -
dataIdx -
dataRef -
boardSid -
Returns:

getBoardAllReplyDataList

public java.util.List<BoardDataVO> getBoardAllReplyDataList(org.hibernate.Session session,
                                                            BoardVO boardVO,
                                                            boolean isManager,
                                                            int dataIdx)
전체 답변글 리스트[민원형 게시판에서 사용:정상,차단]

Parameters:
Hibernate - Session
게시판 - 정보
시작 - 라인 위치
라인 - 수
정렬 -
Returns:
Board List

getBoardRecentDataList

public java.util.List<BoardDataVO> getBoardRecentDataList(org.hibernate.Session session,
                                                          BoardVO boardVO,
                                                          java.lang.String userId,
                                                          java.lang.String searchType,
                                                          java.lang.String keyword,
                                                          java.lang.String categoryCode1,
                                                          java.lang.String categoryCode2,
                                                          java.lang.String categoryCode3,
                                                          int beginRow,
                                                          int rowCount,
                                                          java.util.ArrayList orderByList)
최근 게시물 Board List(동기,비동기)

Parameters:
게시판 - 정보
시작 - 라인 위치
라인 - 수
정렬 -
Returns:
Board List

getBoardWeekDataList

public java.util.List<BoardDataVO> getBoardWeekDataList(org.hibernate.Session session,
                                                        BoardVO boardVO,
                                                        java.lang.String userId,
                                                        java.lang.String searchType,
                                                        java.lang.String keyword,
                                                        java.lang.String categoryCode1,
                                                        java.lang.String categoryCode2,
                                                        java.lang.String categoryCode3,
                                                        int beginRow,
                                                        int rowCount,
                                                        java.lang.String strartDt,
                                                        java.lang.String endDt,
                                                        java.util.ArrayList orderByList)
                                                 throws java.text.ParseException
비동기 시작날짜와 마지막날짜 사이의 게시물 Board List

Parameters:
게시판 - 정보
시작 - 라인 위치
라인 - 수
strartDt(시작날짜) - 예시:2009-09-01
endDt(마지막날짜) - 예시: 2009-09-09
정렬 -
Returns:
Board List
Throws:
java.text.ParseException

getBoardWeekDataListEtc

public java.util.List<BoardDataVO> getBoardWeekDataListEtc(org.hibernate.Session session,
                                                           java.lang.String boardSid,
                                                           java.lang.String userId,
                                                           java.lang.String searchType,
                                                           java.lang.String keyword,
                                                           java.lang.String categoryCode1,
                                                           java.lang.String categoryCode2,
                                                           java.lang.String categoryCode3,
                                                           int beginRow,
                                                           int rowCount,
                                                           java.lang.String strartDt,
                                                           java.lang.String endDt,
                                                           java.util.ArrayList orderByList)
                                                    throws java.text.ParseException
N개의 게시판 Sid 를 이용하여 기간검색된 게시물을 가져온다 [2010-01-07] 양민욱

Parameters:
boardSid -
userId -
searchType -
keyword -
categoryCode1 -
categoryCode2 -
categoryCode3 -
beginRow -
rowCount -
strartDt -
endDt -
orderByList -
Returns:
Throws:
java.text.ParseException

getBoardDataUserList

public java.util.List<BoardDataVO> getBoardDataUserList(org.hibernate.Session session,
                                                        long boardSid,
                                                        java.lang.String whereSql,
                                                        java.util.ArrayList orderByList,
                                                        int count)
getBoardDataUserList (사용자 쿼리로 게시판 정보 가져오기:최대 10개만 가져옴(부하로드 감소목적)

Parameters:
session - 디비연결정보
게시판 - SID
기타 - 조건절(직접쿼리)
Returns:
BoardDataVO List

getBoardData

public BoardDataVO getBoardData(org.hibernate.Session session,
                                long dataSid,
                                boolean isManager,
                                java.lang.String userId,
                                java.lang.String command)
Data 정보 가져오기

Parameters:
dataSid -
Returns:
게시물 정보

getBoardData

public BoardDataVO getBoardData(org.hibernate.Session session,
                                long boardSid,
                                int dataIdx,
                                int dataRef,
                                boolean isManager,
                                java.lang.String userId,
                                java.lang.String command)
Data 정보 가져오기

Parameters:
Session -
int -
int -
Returns:
BoardDataVO

getBoardFileList

public java.util.List<BoardFileVO> getBoardFileList(org.hibernate.Session session,
                                                    long dataSid)
첨부파일 정보 가져오기[삭제된 파일 제외]

Parameters:
fileSid -
Returns:
BoardFileVO

getBoardFile

public BoardFileVO getBoardFile(org.hibernate.Session session,
                                long fileSid,
                                boolean isManager)
첨부파일 정보 가져오기[다운로드시 사용]

Parameters:
fileSid -
Returns:
BoardFileVO

deleteBoardFile

public void deleteBoardFile(org.hibernate.Session session,
                            long fileSid)
첨부파일 삭제

Parameters:
fileSid -

deleteBoardData

public void deleteBoardData(org.hibernate.Session session,
                            BoardVO boardVO,
                            long dataSid,
                            SessionManager sm)
                     throws java.lang.Exception
게시물 및 첨부파일 삭제

Parameters:
fileSid -
Throws:
java.lang.Exception

deleteDBBoardData

public java.util.List<BoardFileVO> deleteDBBoardData(org.hibernate.Session session,
                                                     BoardVO boardVO,
                                                     BoardDataVO boardDataVO)
                                              throws java.lang.Exception
게시물 및 첨부파일 영구삭제

Parameters:
fileSid -
Throws:
java.lang.Exception

filterData

public java.lang.String filterData(org.hibernate.Session session,
                                   BoardVO boardVO,
                                   BoardDataVO boardDataVO,
                                   java.lang.String rootPath,
                                   java.lang.String uploadPath,
                                   SessionManager sm,
                                   java.util.HashMap params)
                            throws java.lang.Exception
Data 필터

Parameters:
게시물 - Data
Returns:
String 필터링 정보
Throws:
java.lang.Exception

boardCleanerFilter

public java.lang.String boardCleanerFilter(org.hibernate.Session session,
                                           BoardVO boardVO,
                                           BoardDataVO boardDataVO,
                                           GroupVO groupVO,
                                           java.lang.String rootPath,
                                           java.lang.String uploadPath,
                                           java.lang.String command,
                                           SessionManager sm,
                                           java.util.HashMap params)
                                    throws java.lang.Exception
Data 보드클리너 필터

Parameters:
게시물 - Data
Returns:
String 필터링 정보
Throws:
java.lang.Exception

writeBoardData

public BoardDataVO writeBoardData(org.hibernate.Session session,
                                  BoardVO boardVO,
                                  BoardDataVO boardDataVO,
                                  java.util.HashMap params,
                                  java.lang.String command,
                                  SessionManager sm,
                                  boolean isManager)
                           throws java.lang.Exception
게시물 Data 등록

Parameters:
게시물 - Data
파라메터 - 정보 ( 확장필드 )
쓰기/리플 - 구분
Returns:
int 0: 정상 1:필터링
Throws:
java.lang.Exception

writeBoardData

public BoardDataVO writeBoardData(org.hibernate.Session session,
                                  BoardVO boardVO,
                                  BoardDataVO boardDataVO,
                                  java.util.HashMap params,
                                  java.lang.String command,
                                  java.lang.String userId,
                                  java.lang.String userName,
                                  java.lang.String userIp,
                                  boolean isManager)
게시물 Data 등록(dwr) [원서형 : 2009-10-27]

Parameters:
게시물 - Data
파라메터 - 정보 ( 확장필드 )
쓰기/리플 - 구분
Returns:
int 0: 정상 1:필터링

updateBoardDataStatus

public java.lang.String updateBoardDataStatus(org.hibernate.Session session,
                                              long dataSid,
                                              java.lang.String status)
게시물 Data 상태 수정[차단 상태]

Parameters:
Session - Hibernate Session
long - 게시물 Data Sid
String - 상태

updateDataEtcStatus

public java.lang.String updateDataEtcStatus(org.hibernate.Session session,
                                            long dataSid,
                                            java.lang.String status)
게시물의 파일, 코멘트 Data 상태 수정 [2009-09-24]

Parameters:
Session - Hibernate Session
long - 게시물 Data Sid
String - 상태

updateBoardAnswerStatus

public void updateBoardAnswerStatus(org.hibernate.Session session,
                                    long dataSid,
                                    java.lang.String status)
답변 상태 변경

Parameters:
Session - Hibernate Session
long - 게시물 Data Sid
String - 상태

updateBoardDataRegister

public void updateBoardDataRegister(org.hibernate.Session session,
                                    long dataSid,
                                    java.lang.String register_dt)
게시물 등록날짜 수정 [2009-12-17 : 원서형]

Parameters:
Session - Hibernate Session
long - 게시물 Data Sid
String - 날짜

updateBoardData

public void updateBoardData(org.hibernate.Session session,
                            BoardDataVO boardDataVO)
게시물 Data 수정

Parameters:
게시물 - Data
파라메터 - 정보 ( 확장필드 )

updateBoardData

public BoardDataVO updateBoardData(org.hibernate.Session session,
                                   BoardVO boardVO,
                                   BoardDataVO boardDataVO,
                                   java.util.HashMap params,
                                   SessionManager sm)
                            throws java.lang.Exception
게시물 Data 수정

Parameters:
게시물 - Data
파라메터 - 정보 ( 확장필드 )
Returns:
int 0: 정상 1:필터링
Throws:
java.lang.Exception

addFileList

public java.util.ArrayList<BoardFileVO> addFileList(org.hibernate.Session session,
                                                    java.util.HashMap params,
                                                    BoardVO boardVO,
                                                    BoardDataVO boardDataVO,
                                                    java.lang.String command)
                                             throws java.lang.Exception
Throws:
java.lang.Exception

updateBoardViewCount

public void updateBoardViewCount(org.hibernate.Session session,
                                 BoardDataVO boardDataVO)
Board hit Update

Parameters:
BoardVO -

updateBoardViewCount

public void updateBoardViewCount(org.hibernate.Session session,
                                 long dataSid)
Board hit Update

Parameters:
BoardVO -

isBoardAdmin

public boolean isBoardAdmin(org.hibernate.Session session,
                            long boardSid,
                            java.lang.String userId)
Board Admin

Parameters:
BoardVO -
userId -

viewBoard

public BoardVO viewBoard(org.hibernate.Session session,
                         BoardVO boardVO)
                  throws java.lang.Exception
게시판스킨 보기 Select [원서형 : 2009-10-28]

Parameters:
BoardVO - 가져올 boardVO
Throws:
java.lang.Exception - 처리

boardBackUpList

public java.util.List<BoardBackUpVO> boardBackUpList(org.hibernate.Session session,
                                                     java.lang.String groupCd,
                                                     long boardSid,
                                                     java.lang.String layerId,
                                                     int rowCount)
                                              throws java.lang.Exception
게시판스킨 List [원서형 : 2009-10-28]

Parameters:
session - 세션정보
boardSid - 게시판아이디
layerId - 스킨구분
rowCount - 가져올 레코드수
Returns:
BoardBackUpVO list객체
Throws:
java.lang.Exception

writeBoardBackUp

public void writeBoardBackUp(org.hibernate.Session session,
                             BoardVO origVO,
                             SessionManager sm,
                             java.lang.String layerId)
                      throws java.lang.Exception
게시판스킨백업 Insert [원서형 : 2009-10-28]

Parameters:
BoardVO -
Throws:
java.lang.reflect.InvocationTargetException
java.lang.IllegalAccessException
java.lang.Exception

viewBoardBackUp

public BoardBackUpVO viewBoardBackUp(org.hibernate.Session session,
                                     long boardBpSid)
                              throws java.lang.Exception
스킨백업 보기 DAO [원서형 2009-10-28]

Parameters:
BoardBackUpVO - 가져올 BoardBackUpVO
Throws:
java.lang.Exception - 처리

updateBoardBackup

public void updateBoardBackup(org.hibernate.Session session,
                              BoardBackUpVO viewVO)
                       throws java.lang.Exception
게시판스킨 백업시점 업데이트 [원서형 2009-10-29]

Parameters:
BoardBackUpVO - 가져올 BoardBackUpVO
Throws:
java.lang.Exception - 처리

writeBoardLog

public void writeBoardLog(org.hibernate.Session session,
                          long boardSid,
                          long dataSid,
                          java.lang.String dataTitle,
                          java.lang.String actionType,
                          java.lang.String userId,
                          java.lang.String userName,
                          java.lang.String userIp,
                          java.lang.String groupCd,
                          java.lang.String boardId)
                   throws java.lang.Exception
게시판 로그 기록 [2009-11-23 : 원서형]

Throws:
java.lang.Exception

updateBoardLog

public void updateBoardLog(org.hibernate.Session session,
                           long dataSid,
                           java.lang.String actionType)
                    throws java.lang.Exception
게시판 로그 수정 [2009-11-23 : 원서형]

Throws:
java.lang.Exception

deleteBoardReply

public void deleteBoardReply(org.hibernate.Session session,
                             long dataSid)
민원게시판 등록 [2009-11-25 : 원서형]

Throws:
java.lang.reflect.InvocationTargetException
java.lang.IllegalAccessException

getBoardReplyOfficeList

public java.util.List<BoardReplyVO> getBoardReplyOfficeList(org.hibernate.Session session,
                                                            long dataSid)

getBoardReplyOfficeCount

public int getBoardReplyOfficeCount(org.hibernate.Session session,
                                    java.lang.String pcode,
                                    long boardSid,
                                    java.lang.String searchType,
                                    java.lang.String keyword)
민원게시판 해당 부서이하 글 카운트

Parameters:
session -
pcode - 상위1단계위 부서코드
boardSid - 게시판 번호
searchType - 검색필드
keyword - 검색어
Returns:

getBoardReplyOfficeList

public java.util.List<BoardDataVO> getBoardReplyOfficeList(org.hibernate.Session session,
                                                           java.lang.String pcode,
                                                           long boardSid,
                                                           int beginRow,
                                                           int rowCount,
                                                           java.lang.String searchType,
                                                           java.lang.String keyword)
민원게시판 해당 부서이하 글 가져오기

Parameters:
session -
pcode - 상위1단계위 부서코드
boardSid - 게시판 번호
beginRow - 시작위치
rowCount - 페이징수
searchType - 검색필드
keyword - 검색어
Returns:

writeBoardReplys

public void writeBoardReplys(org.hibernate.Session session,
                             BoardReplyVO boardReplyVO)
                      throws java.lang.Exception
Throws:
java.lang.Exception

getCommentCount

public int getCommentCount(org.hibernate.Session session,
                           long dataSid)
Comment Count

Parameters:
long -

getCommentCount

public int getCommentCount(org.hibernate.Session session,
                           long dataSid,
                           java.lang.String flag)

getPointAvg

public int getPointAvg(org.hibernate.Session session,
                       long dataSid)
Comment Star Point Sum

Parameters:
long -

getCommentList

public java.util.List<CommentVO> getCommentList(org.hibernate.Session session,
                                                long dataSid,
                                                int beginRow,
                                                int rowCount)
Comment List

Parameters:
Session -
long -
int -
int -
Returns:
ListString flag

getCommentList

public java.util.List<CommentVO> getCommentList(org.hibernate.Session session,
                                                long dataSid,
                                                int beginRow,
                                                int rowCount,
                                                java.lang.String flag)

writeComment

public void writeComment(org.hibernate.Session session,
                         CommentVO commentVO)
Comment 등록

Parameters:
Session -
CommentVO -

getComment

public CommentVO getComment(org.hibernate.Session session,
                            long commentSid)
Comment 등록

Parameters:
long -

deleteComment

public void deleteComment(org.hibernate.Session session,
                          long commentSid)
Comment 삭제

Parameters:
Session -
long -

getBoardLogCount

public int getBoardLogCount(org.hibernate.Session session,
                            java.lang.String groupCd,
                            long boardSid)
Board Log Count

Returns:
Log 수

getBoardLogCount

public int getBoardLogCount(org.hibernate.Session session,
                            java.lang.String groupCd,
                            java.lang.String searchField,
                            java.lang.String keyword,
                            long boardSid)
Board Log Count

Returns:
Log 수

getBoardLogList

public java.util.List<BoardLogVO> getBoardLogList(org.hibernate.Session session,
                                                  java.lang.String groupCd,
                                                  long boardSid,
                                                  java.lang.String actionType,
                                                  int beginRow,
                                                  int rowCount,
                                                  java.util.ArrayList orderByList)
Board Log List

Parameters:
시작 - 라인 위치
라인 - 수
라인 - 수
Returns:
BoardLogVO List

getBoardLogList

public java.util.List<BoardLogVO> getBoardLogList(org.hibernate.Session session,
                                                  java.lang.String groupCd,
                                                  java.lang.String searchField,
                                                  java.lang.String keyword,
                                                  long boardSid,
                                                  int beginRow,
                                                  int rowCount,
                                                  java.util.ArrayList orderByList)

getBoardListCount

public int getBoardListCount(org.hibernate.Session session,
                             java.lang.String groupCd,
                             java.lang.String searchField,
                             java.lang.String keyword,
                             long boardSid,
                             java.lang.String deleteStatus,
                             java.lang.String dataStatus,
                             java.lang.String mobileIsUse,
                             int userLevel)
게시물 관리의 게시물 목록 수 [2009-09-24]

Parameters:
게시판 - 그룹CD
검색 - 필드
검색어 -
게시판 - SID
Returns:
int List Count

getBoardListList

public java.util.List<BoardDataVO> getBoardListList(org.hibernate.Session session,
                                                    java.lang.String groupCd,
                                                    java.lang.String searchField,
                                                    java.lang.String keyword,
                                                    long boardSid,
                                                    int beginRow,
                                                    int rowCount,
                                                    java.util.ArrayList orderByList,
                                                    java.lang.String deleteStatus,
                                                    java.lang.String dataStatus,
                                                    java.lang.String mobileIsUse,
                                                    int userLevel)
                                             throws java.lang.Exception
게시물 관리의 게시물 목록 [2009-09-24]

Parameters:
게시판 - 그룹CD
검색 - 필드
검색어 -
시작 - 라인 위치
라인 - 수
게시판 - SID
정렬 - 값
Returns:
BoardDataVO
Throws:
java.lang.Exception

writeBoadAdmin

public void writeBoadAdmin(org.hibernate.Session session,
                           BoardAdminVO boardAdminVO)
관리자 등록

Parameters:
Session -
boardAdminVO -

deleteBoardAdmin

public void deleteBoardAdmin(org.hibernate.Session session,
                             BoardAdminVO boardAdminVO)
관리자 삭제

Parameters:
Session -
long -

getBoardAdminUserCount

public int getBoardAdminUserCount(org.hibernate.Session session,
                                  long boardSid,
                                  java.lang.String userId)
관리자 등록정보

Returns:
사용자 수

getBoardAdminList

public java.util.List<BoardAdminVO> getBoardAdminList(org.hibernate.Session session,
                                                      long boardSid)
                                               throws java.lang.Exception
관리자 정보 가져오기

Parameters:
session - 디비세션정보
officeCd - 부서코드
mode - 부서담당자 위치(0:해당부서수장정보,1:전체 담당,담당자 정보,2:해당 담당자 정보)
Throws:
java.lang.Exception - 처리

getMobileDataCount

public int getMobileDataCount(org.hibernate.Session session,
                              java.lang.String searchType,
                              java.lang.String keyword)
모바일 검색 카운트 [2010-06-22 : 원서형]

Parameters:
session -
searchType -
keyword -
Returns:

getMobileDataList

public java.util.List<BoardDataVO> getMobileDataList(org.hibernate.Session session,
                                                     java.lang.String searchType,
                                                     java.lang.String keyword,
                                                     int beginRow,
                                                     int rowCount,
                                                     java.util.ArrayList orderByList)
모바일 검색 리스트 [2010-06-22 : 원서형]

Parameters:
session -
searchType -
keyword -
beginRow -
rowCount -
orderByList -
Returns:

isOfficeManager

public boolean isOfficeManager(org.hibernate.Session session,
                               java.lang.String loginPcode,
                               java.lang.String officePcode,
                               int modiDepth)
                        throws java.lang.Exception
 1. MethodName : isOfficeManager
 2. ClassName  : BoardDAO
 3. Comment   : 부서별 담당 게시판 목록 DAO
 4. 작성자    : 박형민
 5. 작성일    : 2010. 8. 17. 오전 11:02:00

Parameters:
session - 디비세션정보
loginPcode - 로그인 부서담당코드
officePcode - 글등록 부서담당코드
modiDepth - 부서수정시 하단 부서 상위로 수정(김제1)
Returns:
boolean 결과값 true:false
Throws:
java.lang.Exception

getCommentManagerCount

public int getCommentManagerCount(org.hibernate.Session session,
                                  int searchField,
                                  java.lang.String keyword,
                                  java.lang.String flag,
                                  boolean isManager)
코멘트 관리기능

Parameters:
session -
flag -
isManager -
Returns:

getCommentManagerList

public java.util.List<CommentVO> getCommentManagerList(org.hibernate.Session session,
                                                       int searchField,
                                                       java.lang.String keyword,
                                                       int beginRow,
                                                       int rowCount,
                                                       java.lang.String flag,
                                                       boolean isManager)
코멘트 관리기능

Parameters:
session -
searchField -
keyword -
beginRow -
rowCount -
flag -
isManager -
Returns:

deleteComments

public void deleteComments(org.hibernate.Session session,
                           long commentSid)
첨부파일 삭제

Parameters:
fileSid -
Overview  Package   Class  Use  Tree  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD