egovframework.rfc3.research.service.impl
Class ReSearchSericeImpl

java.lang.Object
  extended by egovframework.rte.fdl.cmmn.AbstractServiceImpl
      extended by egovframework.rfc3.research.service.impl.ReSearchSericeImpl
All Implemented Interfaces:
ReSearchService

@Service(value="ReSearchService")
public class ReSearchSericeImpl
extends egovframework.rte.fdl.cmmn.AbstractServiceImpl
implements ReSearchService


Constructor Summary
ReSearchSericeImpl()
           
 
Method Summary
 java.lang.String autoCreateUser()
          신청자 자동 아이디 생성
 void deleteApplyer(long aplySid)
           
 void deleteApplyerForReUniqId(java.lang.String reUniqId)
           
 void deleteCareer(long aplySid)
           
 void deleteReSearch(java.lang.String reUniqId)
           
 void deleteReSearchFile(long reFileSid)
           
 void deleteReSearchFileAll(java.lang.String reUniqId)
           
 void deleteReSearchLecture(long lectureSid)
           
 void deleteReSearchLectureAll(java.lang.String reUniqId)
           
 ReSearchApplyVO getApplyerInfo(long aplySid)
           
 java.lang.String getLastFinishNoMake(java.lang.String reUniqId)
          최종 이수번호 구하기
 int getNextFinishNo(java.lang.String reUniqId)
           
 ReSearchFileVO getReSearchFileInfo(long reFileSid)
           
 ReSearchVO getReSearchInfo(java.lang.String reUniqId)
           
 ReSearchLectureVO getReSearchLectureInfo(long lectureSid)
           
 ReSearchVO getReSearchStatus(java.lang.String reUniqId)
          연수 상태
 void insertApplyer(ReSearchApplyVO reSearchApplyVO)
           
 void insertCareer(ReSearchApplyCareerVO reSearchApplyCareerVO)
           
 void insertReSearch(ReSearchVO reSearchVO)
           
 void insertReSearchFile(ReSearchFileVO reSearchFileVO)
           
 void insertReSearchLecture(ReSearchLectureVO reSearchLectureVO)
           
 void insertResearchSurvey(SurveyStatVO surveyStatVO)
           
 int isDupicateSurvey(SurveyStatVO surveyStatVO)
           
 int isExistFinishNo(ReSearchApplyVO reSearchApplyVO)
           
 int isExistUserCnt(ReSearchApplyVO reSearchApplyVO)
           
 int partInUserSurveyCnt(SurveyStatVO surveyStatVO)
           
 java.util.List<SurveyStatVO> selectAnswerTextList(SurveyStatVO surveyStatVO)
           
 int selectAppliedUserCnt(java.lang.String reUniqId)
           
 int selectAppliedUserCnt1(java.lang.String reUniqId)
           
 java.util.List<ReSearchApplyVO> selectApplyerList(ReSearchApplyVO reSearchApplyVO)
           
 java.util.List<ReSearchApplyVO> selectApplyerList1(ReSearchApplyVO reSearchApplyVO)
           
 int selectApplyerListTotal(ReSearchApplyVO reSearchApplyVO)
           
 java.util.List<ReSearchApplyCareerVO> selectCareerList(long aplySid)
           
 java.util.List<ReSearchFileVO> selectReSearchFileList(java.lang.String reUniqId)
           
 java.util.List<ReSearchLectureVO> selectReSearchLectureList(java.lang.String reUniqId)
           
 java.util.List<ReSearchVO> selectReSearchList(ReSearchVO reSearchVO)
           
 int selectReSearchListTotal(ReSearchVO reSearchVO)
           
 int selectTotalAnswerUserCnt(SurveyStatVO surveyStatVO)
           
 int selectTotalAnswerUserCntSum(SurveyStatVO surveyStatVO)
           
 int selectTotalQestionUserCnt(SurveyStatVO surveyStatVO)
           
 int selectTotalReSearchUserCnt(SurveyStatVO surveyStatVO)
           
 void updateApplyer(ReSearchApplyVO reSearchApplyVO)
           
 void updateApplyerFinishStatus(ReSearchApplyVO reSearchApplyVO)
           
 void updateCareer(ReSearchApplyCareerVO reSearchApplyCareerVO)
           
 void updateReSearch(ReSearchVO reSearchVO)
           
 void updateReSearchLecture(ReSearchLectureVO reSearchLectureVO)
           
 void updateTraineeNumAdd(ReSearchApplyVO vo)
           
 java.util.List<ReSearchApplyVO> userSelectApplyerList(ReSearchApplyVO reSearchApplyVO)
           
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

ReSearchSericeImpl

public ReSearchSericeImpl()
Method Detail

selectReSearchListTotal

public int selectReSearchListTotal(ReSearchVO reSearchVO)
                            throws java.lang.Exception
Specified by:
selectReSearchListTotal in interface ReSearchService
Throws:
java.lang.Exception

selectReSearchList

public java.util.List<ReSearchVO> selectReSearchList(ReSearchVO reSearchVO)
                                              throws java.lang.Exception
Specified by:
selectReSearchList in interface ReSearchService
Throws:
java.lang.Exception

getReSearchInfo

public ReSearchVO getReSearchInfo(java.lang.String reUniqId)
                           throws java.lang.Exception
Specified by:
getReSearchInfo in interface ReSearchService
Throws:
java.lang.Exception

insertReSearch

public void insertReSearch(ReSearchVO reSearchVO)
                    throws java.lang.Exception
Specified by:
insertReSearch in interface ReSearchService
Throws:
java.lang.Exception

updateReSearch

public void updateReSearch(ReSearchVO reSearchVO)
                    throws java.lang.Exception
Specified by:
updateReSearch in interface ReSearchService
Throws:
java.lang.Exception

deleteReSearch

public void deleteReSearch(java.lang.String reUniqId)
                    throws java.lang.Exception
Specified by:
deleteReSearch in interface ReSearchService
Throws:
java.lang.Exception

selectReSearchFileList

public java.util.List<ReSearchFileVO> selectReSearchFileList(java.lang.String reUniqId)
                                                      throws java.lang.Exception
Specified by:
selectReSearchFileList in interface ReSearchService
Throws:
java.lang.Exception

getReSearchFileInfo

public ReSearchFileVO getReSearchFileInfo(long reFileSid)
                                   throws java.lang.Exception
Specified by:
getReSearchFileInfo in interface ReSearchService
Throws:
java.lang.Exception

insertReSearchFile

public void insertReSearchFile(ReSearchFileVO reSearchFileVO)
                        throws java.lang.Exception
Specified by:
insertReSearchFile in interface ReSearchService
Throws:
java.lang.Exception

deleteReSearchFile

public void deleteReSearchFile(long reFileSid)
                        throws java.lang.Exception
Specified by:
deleteReSearchFile in interface ReSearchService
Throws:
java.lang.Exception

deleteReSearchFileAll

public void deleteReSearchFileAll(java.lang.String reUniqId)
                           throws java.lang.Exception
Specified by:
deleteReSearchFileAll in interface ReSearchService
Throws:
java.lang.Exception

selectReSearchLectureList

public java.util.List<ReSearchLectureVO> selectReSearchLectureList(java.lang.String reUniqId)
                                                            throws java.lang.Exception
Specified by:
selectReSearchLectureList in interface ReSearchService
Throws:
java.lang.Exception

getReSearchLectureInfo

public ReSearchLectureVO getReSearchLectureInfo(long lectureSid)
                                         throws java.lang.Exception
Specified by:
getReSearchLectureInfo in interface ReSearchService
Throws:
java.lang.Exception

insertReSearchLecture

public void insertReSearchLecture(ReSearchLectureVO reSearchLectureVO)
                           throws java.lang.Exception
Specified by:
insertReSearchLecture in interface ReSearchService
Throws:
java.lang.Exception

updateReSearchLecture

public void updateReSearchLecture(ReSearchLectureVO reSearchLectureVO)
                           throws java.lang.Exception
Specified by:
updateReSearchLecture in interface ReSearchService
Throws:
java.lang.Exception

deleteReSearchLecture

public void deleteReSearchLecture(long lectureSid)
                           throws java.lang.Exception
Specified by:
deleteReSearchLecture in interface ReSearchService
Throws:
java.lang.Exception

deleteReSearchLectureAll

public void deleteReSearchLectureAll(java.lang.String reUniqId)
                              throws java.lang.Exception
Specified by:
deleteReSearchLectureAll in interface ReSearchService
Throws:
java.lang.Exception

selectAppliedUserCnt

public int selectAppliedUserCnt(java.lang.String reUniqId)
                         throws java.lang.Exception
Specified by:
selectAppliedUserCnt in interface ReSearchService
Throws:
java.lang.Exception

selectAppliedUserCnt1

public int selectAppliedUserCnt1(java.lang.String reUniqId)
                          throws java.lang.Exception
Specified by:
selectAppliedUserCnt1 in interface ReSearchService
Throws:
java.lang.Exception

getNextFinishNo

public int getNextFinishNo(java.lang.String reUniqId)
                    throws java.lang.Exception
Specified by:
getNextFinishNo in interface ReSearchService
Throws:
java.lang.Exception

isExistUserCnt

public int isExistUserCnt(ReSearchApplyVO reSearchApplyVO)
                   throws java.lang.Exception
Specified by:
isExistUserCnt in interface ReSearchService
Throws:
java.lang.Exception

isExistFinishNo

public int isExistFinishNo(ReSearchApplyVO reSearchApplyVO)
                    throws java.lang.Exception
Specified by:
isExistFinishNo in interface ReSearchService
Throws:
java.lang.Exception

selectApplyerListTotal

public int selectApplyerListTotal(ReSearchApplyVO reSearchApplyVO)
                           throws java.lang.Exception
Specified by:
selectApplyerListTotal in interface ReSearchService
Throws:
java.lang.Exception

selectApplyerList

public java.util.List<ReSearchApplyVO> selectApplyerList(ReSearchApplyVO reSearchApplyVO)
                                                  throws java.lang.Exception
Specified by:
selectApplyerList in interface ReSearchService
Throws:
java.lang.Exception

selectApplyerList1

public java.util.List<ReSearchApplyVO> selectApplyerList1(ReSearchApplyVO reSearchApplyVO)
                                                   throws java.lang.Exception
Specified by:
selectApplyerList1 in interface ReSearchService
Throws:
java.lang.Exception

userSelectApplyerList

public java.util.List<ReSearchApplyVO> userSelectApplyerList(ReSearchApplyVO reSearchApplyVO)
                                                      throws java.lang.Exception
Specified by:
userSelectApplyerList in interface ReSearchService
Throws:
java.lang.Exception

getApplyerInfo

public ReSearchApplyVO getApplyerInfo(long aplySid)
                               throws java.lang.Exception
Specified by:
getApplyerInfo in interface ReSearchService
Throws:
java.lang.Exception

insertApplyer

public void insertApplyer(ReSearchApplyVO reSearchApplyVO)
                   throws java.lang.Exception
Specified by:
insertApplyer in interface ReSearchService
Throws:
java.lang.Exception

updateApplyer

public void updateApplyer(ReSearchApplyVO reSearchApplyVO)
                   throws java.lang.Exception
Specified by:
updateApplyer in interface ReSearchService
Throws:
java.lang.Exception

updateApplyerFinishStatus

public void updateApplyerFinishStatus(ReSearchApplyVO reSearchApplyVO)
                               throws java.lang.Exception
Specified by:
updateApplyerFinishStatus in interface ReSearchService
Throws:
java.lang.Exception

deleteApplyer

public void deleteApplyer(long aplySid)
                   throws java.lang.Exception
Specified by:
deleteApplyer in interface ReSearchService
Throws:
java.lang.Exception

deleteApplyerForReUniqId

public void deleteApplyerForReUniqId(java.lang.String reUniqId)
                              throws java.lang.Exception
Specified by:
deleteApplyerForReUniqId in interface ReSearchService
Throws:
java.lang.Exception

selectCareerList

public java.util.List<ReSearchApplyCareerVO> selectCareerList(long aplySid)
                                                       throws java.lang.Exception
Specified by:
selectCareerList in interface ReSearchService
Throws:
java.lang.Exception

insertCareer

public void insertCareer(ReSearchApplyCareerVO reSearchApplyCareerVO)
                  throws java.lang.Exception
Specified by:
insertCareer in interface ReSearchService
Throws:
java.lang.Exception

updateCareer

public void updateCareer(ReSearchApplyCareerVO reSearchApplyCareerVO)
                  throws java.lang.Exception
Specified by:
updateCareer in interface ReSearchService
Throws:
java.lang.Exception

deleteCareer

public void deleteCareer(long aplySid)
                  throws java.lang.Exception
Specified by:
deleteCareer in interface ReSearchService
Throws:
java.lang.Exception

partInUserSurveyCnt

public int partInUserSurveyCnt(SurveyStatVO surveyStatVO)
                        throws java.lang.Exception
Specified by:
partInUserSurveyCnt in interface ReSearchService
Throws:
java.lang.Exception

isDupicateSurvey

public int isDupicateSurvey(SurveyStatVO surveyStatVO)
                     throws java.lang.Exception
Specified by:
isDupicateSurvey in interface ReSearchService
Throws:
java.lang.Exception

selectTotalReSearchUserCnt

public int selectTotalReSearchUserCnt(SurveyStatVO surveyStatVO)
                               throws java.lang.Exception
Specified by:
selectTotalReSearchUserCnt in interface ReSearchService
Throws:
java.lang.Exception

selectTotalQestionUserCnt

public int selectTotalQestionUserCnt(SurveyStatVO surveyStatVO)
                              throws java.lang.Exception
Specified by:
selectTotalQestionUserCnt in interface ReSearchService
Throws:
java.lang.Exception

selectTotalAnswerUserCnt

public int selectTotalAnswerUserCnt(SurveyStatVO surveyStatVO)
                             throws java.lang.Exception
Specified by:
selectTotalAnswerUserCnt in interface ReSearchService
Throws:
java.lang.Exception

selectTotalAnswerUserCntSum

public int selectTotalAnswerUserCntSum(SurveyStatVO surveyStatVO)
                                throws java.lang.Exception
Specified by:
selectTotalAnswerUserCntSum in interface ReSearchService
Throws:
java.lang.Exception

selectAnswerTextList

public java.util.List<SurveyStatVO> selectAnswerTextList(SurveyStatVO surveyStatVO)
                                                  throws java.lang.Exception
Specified by:
selectAnswerTextList in interface ReSearchService
Throws:
java.lang.Exception

insertResearchSurvey

public void insertResearchSurvey(SurveyStatVO surveyStatVO)
                          throws java.lang.Exception
Specified by:
insertResearchSurvey in interface ReSearchService
Throws:
java.lang.Exception

autoCreateUser

public java.lang.String autoCreateUser()
                                throws java.lang.Exception
신청자 자동 아이디 생성

Returns:
Throws:
java.lang.Exception

getReSearchStatus

public ReSearchVO getReSearchStatus(java.lang.String reUniqId)
                             throws java.lang.Exception
연수 상태

Specified by:
getReSearchStatus in interface ReSearchService
Throws:
java.lang.Exception

getLastFinishNoMake

public java.lang.String getLastFinishNoMake(java.lang.String reUniqId)
                                     throws java.lang.Exception
최종 이수번호 구하기

Specified by:
getLastFinishNoMake in interface ReSearchService
Throws:
java.lang.Exception

updateTraineeNumAdd

public void updateTraineeNumAdd(ReSearchApplyVO vo)
                         throws java.lang.Exception
Specified by:
updateTraineeNumAdd in interface ReSearchService
Throws:
java.lang.Exception