egovframework.rfc3.perform.dao
Class PerformDAO

java.lang.Object
  org.springframework.dao.support.DaoSupport
      org.springframework.orm.ibatis.support.SqlMapClientDaoSupport
          egovframework.rte.psl.dataaccess.EgovAbstractDAO
              egovframework.rfc3.common.dao.RfcCMSAbstractDAO
                  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