egovframework.rfc3.perform.dao
Class PerformDAO

java.lang.Object
  extended by org.springframework.dao.support.DaoSupport
      extended by org.springframework.orm.ibatis.support.SqlMapClientDaoSupport
          extended by egovframework.rte.psl.dataaccess.EgovAbstractDAO
              extended by egovframework.rfc3.common.dao.RfcCMSAbstractDAO
                  extended by egovframework.rfc3.perform.dao.PerformDAO
All Implemented Interfaces:
org.springframework.beans.factory.InitializingBean

@Repository(value="PerformDAO")
public class PerformDAO
extends RfcCMSAbstractDAO


Constructor Summary
PerformDAO()
           
 
Method Summary
 int AllApplicantCnt(long playSid)
          해당공연신청자 총수
 void deleteApplicant(long applicantSid)
          공연 신청자 삭제
 void deleteApplicantAllplaySid(long playSid)
          해당공연신청자 전부 삭제
 void deletePerform(long playSid)
          공연 삭제
 ApplicantVO getApplicantInfo(long applicantSid)
          신청자 정보
 int getMaxTicketNum(long playSid)
          max 티켓번호
 PerFormInfoVO getPerformInfo(long playSid)
          공연정보
 void insertApplicant(ApplicantVO applicantVO)
          공연신청자 저장
 void insertPerform(PerFormInfoVO perFormInfoVO)
          공연저장
 int isExistApplicantCnt(ApplicantVO applicantVO)
          해당공연신청자 이중 존재여부
 java.util.List<ApplicantVO> selectApplicantForSchoolList(ApplicantVO applicantVO)
          해당공연신청자 이중 존재여부(유치원 교사)
 java.util.List<ApplicantVO> selectApplicantMyList(java.lang.String userId)
          나의 공연신청 목록
 int selectApplicanTotListCnt(ApplicantVO applicantVO)
          공연신청자 명수
 java.util.List<ApplicantVO> selectApplicantTotList(ApplicantVO applicantVO)
          공연 신청자 전제목록
 java.util.List<PerFormInfoVO> selectPerformTotList(PerFormInfoVO perFormInfoVO)
          공연 전체 목록
 int selectPerformTotListCnt(PerFormInfoVO perFormInfoVO)
          공연 전체 개수
 void updateApplicant(ApplicantVO applicantVO)
          공연 신청자 수정
 void updatePerform(PerFormInfoVO perFormInfoVO)
          공연수정
 
Methods inherited from class egovframework.rfc3.common.dao.RfcCMSAbstractDAO
delete, desDecoding, desDecoding2, desDecodingList, desDecodingList2, desEncoding, desEncoding2, insert, list, listWithPaging, selectByPk, setSuperSqlMapClient, update
 
Methods inherited from class org.springframework.orm.ibatis.support.SqlMapClientDaoSupport
getDataSource, getSqlMapClient, getSqlMapClientTemplate, setDataSource, setSqlMapClient, setSqlMapClientTemplate
 
Methods inherited from class org.springframework.dao.support.DaoSupport
afterPropertiesSet
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

PerformDAO

public PerformDAO()
Method Detail

selectPerformTotListCnt

public int selectPerformTotListCnt(PerFormInfoVO perFormInfoVO)
                            throws java.lang.Exception
공연 전체 개수

Parameters:
perFormInfoVO -
Returns:
Throws:
java.lang.Exception

selectPerformTotList

public java.util.List<PerFormInfoVO> selectPerformTotList(PerFormInfoVO perFormInfoVO)
                                                   throws java.lang.Exception
공연 전체 목록

Parameters:
perFormInfoVO -
Returns:
Throws:
java.lang.Exception

getPerformInfo

public PerFormInfoVO getPerformInfo(long playSid)
                             throws java.lang.Exception
공연정보

Parameters:
playSid -
Returns:
Throws:
java.lang.Exception

insertPerform

public void insertPerform(PerFormInfoVO perFormInfoVO)
                   throws java.lang.Exception
공연저장

Parameters:
perFormInfoVO -
Throws:
java.lang.Exception

updatePerform

public void updatePerform(PerFormInfoVO perFormInfoVO)
                   throws java.lang.Exception
공연수정

Parameters:
perFormInfoVO -
Throws:
java.lang.Exception

deletePerform

public void deletePerform(long playSid)
                   throws java.lang.Exception
공연 삭제

Parameters:
playSid -
Throws:
java.lang.Exception

selectApplicanTotListCnt

public int selectApplicanTotListCnt(ApplicantVO applicantVO)
                             throws java.lang.Exception
공연신청자 명수

Parameters:
applicantVO -
Returns:
Throws:
java.lang.Exception

selectApplicantTotList

public java.util.List<ApplicantVO> selectApplicantTotList(ApplicantVO applicantVO)
                                                   throws java.lang.Exception
공연 신청자 전제목록

Parameters:
applicantVO -
Returns:
Throws:
java.lang.Exception

selectApplicantMyList

public java.util.List<ApplicantVO> selectApplicantMyList(java.lang.String userId)
                                                  throws java.lang.Exception
나의 공연신청 목록

Parameters:
userId -
Returns:
Throws:
java.lang.Exception

getApplicantInfo

public ApplicantVO getApplicantInfo(long applicantSid)
                             throws java.lang.Exception
신청자 정보

Parameters:
applicantSid -
Returns:
Throws:
java.lang.Exception

isExistApplicantCnt

public int isExistApplicantCnt(ApplicantVO applicantVO)
                        throws java.lang.Exception
해당공연신청자 이중 존재여부

Parameters:
applicantVO -
Returns:
Throws:
java.lang.Exception

selectApplicantForSchoolList

public java.util.List<ApplicantVO> selectApplicantForSchoolList(ApplicantVO applicantVO)
                                                         throws java.lang.Exception
해당공연신청자 이중 존재여부(유치원 교사)

Parameters:
applicantVO -
Returns:
Throws:
java.lang.Exception

AllApplicantCnt

public int AllApplicantCnt(long playSid)
                    throws java.lang.Exception
해당공연신청자 총수

Parameters:
playSid -
Returns:
Throws:
java.lang.Exception

getMaxTicketNum

public int getMaxTicketNum(long playSid)
                    throws java.lang.Exception
max 티켓번호

Parameters:
playSid -
Returns:
Throws:
java.lang.Exception

insertApplicant

public void insertApplicant(ApplicantVO applicantVO)
                     throws java.lang.Exception
공연신청자 저장

Parameters:
applicantVO -
Throws:
java.lang.Exception

updateApplicant

public void updateApplicant(ApplicantVO applicantVO)
                     throws java.lang.Exception
공연 신청자 수정

Parameters:
applicantVO -
Throws:
java.lang.Exception

deleteApplicant

public void deleteApplicant(long applicantSid)
                     throws java.lang.Exception
공연 신청자 삭제

Parameters:
applicantSid -
Throws:
java.lang.Exception

deleteApplicantAllplaySid

public void deleteApplicantAllplaySid(long playSid)
                               throws java.lang.Exception
해당공연신청자 전부 삭제

Parameters:
playSid -
Throws:
java.lang.Exception