|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
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.training.dao.BloomDAO
@Repository(value="BloomDAO") public class BloomDAO
Constructor Summary | |
---|---|
BloomDAO()
|
Method Summary | |
---|---|
void |
deleteBloomDetail(BloomVO bloomVO)
상세정보 삭제 시퀀스가 증가 서브쿼리로 되어 있기때문에 삭제처리 |
int |
deleteBloomDetailCnt(long idexNo)
시설물관리 상세정보 카운트 |
void |
deleteHoliDayList(java.lang.Long idexSeq)
휴일관리 delete |
void |
deleteRloom(BloomVO bloomVO)
시설물 삭제 |
void |
deleteRloomfile(java.lang.Long fileSid)
파일삭제 |
void |
deleteRloomMainfile(BloomFileVO bloomFileVO)
파일삭제 |
void |
deleteTbloomDc(java.lang.Long idexSeq)
할인삭제 |
void |
deleteTbloomOption(java.lang.Long idexSeq)
옵션 삭제 |
void |
deleteTbloomTime(java.lang.Long idexSeq)
시설물 이용시간 삭제 |
void |
insertBloomDetail(BloomVO bloomVO)
상세정보 등록 운영중인 광양시청 포팅후 추가사항(기존데이터 이관문제로 따로 테이블을 구성하였습니다.) |
void |
insertHoliDay(BloomHoliDayVO bloomHoliDayVO)
휴일관리 insert |
void |
insertReserveOrder(BloomOrderVO bloomOrderVO)
시설물예약 Action |
java.lang.Long |
insertRloom(BloomVO bloomVO)
시설물 등록 |
void |
insertRloomfile(BloomFileVO bloomFileVO)
파일 등록 |
void |
insertTbloomDc(BloomDcVO bloomDcVO)
할인등록 |
void |
insertTbloomOption(BloomOptionVO bloomOptionVO)
옵션등록 |
void |
insertTbloomTime(BloomTimeVO bloomTimeVO)
시설물 시간등록 |
void |
orderCancel(BloomOrderVO bloomOrderVO)
예약취소 |
void |
orderCancelAct(BloomOrderVO bloomOrderVO)
환불 반려 |
void |
orderCompleteAct(BloomOrderVO bloomOrderVO)
승인확인/환불완료 |
java.util.List<BloomOrderVO> |
reserveOrderBank(BloomOrderVO bloomOrderVO)
결제진행 예약정보 |
int |
reserveOrderBankCnt(BloomOrderVO bloomOrderVO)
결제진행 카운티 |
void |
reserveOrderBankSuccess(BloomOrderVO bloomOrderVO)
결제완료 update |
int |
reserveOrderCnt(BloomOrderVO bloomOrderVO)
예약자 COUNT |
java.util.List<BloomOrderVO> |
reserveOrderList(BloomOrderVO bloomOrderVO)
사용자 예약 페이징 |
int |
reserveOrderListCnt(BloomOrderVO bloomOrderVO)
사용자 예약 페이지 카운트 |
void |
reserveOrderOpInsert(BloomOrderVO bloomOrderVO)
예약관리 사용자 승인요청(옵션부분 등록)처리 |
void |
reserveOrderOpUpdate(BloomOrderVO bloomOrderVO)
예약관리 사용자 승인요청(옵션부분 업데이트) 처리 |
void |
reserveOrderUpdate(BloomOrderVO bloomOrderVO)
예약관리 사용자 승인요청 처리 |
java.util.List<BloomSalesVO> |
selectAllSales(BloomSalesVO bloomSalesVO)
매출현황 Excel 검색전체 |
BloomVO |
selectBloomDetail(BloomVO bloomVO)
상세정보 VO 운영중인 광양시청 포팅후 추가사항(기존데이터 이관문제로 따로 테이블을 구성하였습니다.) |
int |
selectHoliDayCount(BloomHoliDayVO bloomHoliDayVO)
휴일관리 카운트 |
java.util.List<BloomHoliDayVO> |
selectHoliDayList(BloomHoliDayVO bloomHoliDayVO)
휴일관리 리스트 |
java.util.List<BloomTimeVO> |
selectHoliDaytime(java.lang.Long indexNo)
휴일관리 등록시간 리스트 |
java.util.List<BloomOptionVO> |
selectOrderBloomOptionList(BloomOptionVO bloomOptionVO)
예약시설물 옵션 리스트 |
java.util.List<BloomOrderVO> |
selectOrderList(BloomOrderVO bloomOrderVO)
예약자 리스트 |
java.util.List<BloomOrderOptionVO> |
selectOrderOption(BloomOrderOptionVO bloomOrderOptionVO)
예약 옵션리스트 |
int |
selectOrderTotal(BloomOrderVO bloomOrderVO)
예약자 리스트 카운트 |
BloomOrderVO |
selectOrderView(BloomOrderVO bloomOrderVO)
예약자 상세보기 |
java.util.List<BloomDcVO> |
selectReserveTbloomDc(BloomDcVO bloomDcVO)
예약시설 할인 리스트 |
java.util.List<BloomVO> |
selectRloom(BloomVO bloomVO)
시설물관리 리스트 |
java.util.List<BloomFileVO> |
selectRloomfile(BloomFileVO bloomFileVO)
파일 리스트 |
int |
selectRloomTotal(BloomVO bloomVO)
시설물관리 리스트 카운트 |
java.util.List<BloomSalesVO> |
selectSales(BloomSalesVO bloomSalesVO)
매출현황 리스트 |
int |
selectSalesTotal(BloomSalesVO bloomSalesVO)
매출현황 카운트 |
java.util.List<BloomDcVO> |
selectTbloomDc(java.lang.Long indexNo)
시설물 할인리스트 |
java.util.List<BloomOptionVO> |
selectTbloomOption(java.lang.Long indexNo)
시설물 옵션리스트 |
java.util.List<BloomTimeVO> |
selectTbloomTime(java.lang.Long indexNo)
시설물 시간리스트 |
BloomTimeVO |
selectTbloomTimeVo(java.lang.Long idexSeq)
시설물 시간리스트 View |
java.util.List<BloomHoliDayVO> |
selectUserHoliDayList(BloomHoliDayVO bloomHoliDayVO)
사용자 휴관일 리스트 |
java.util.List<BloomTimeVO> |
selectUserTbloomTime(BloomTimeVO bloomTimeVO)
사용자 예약시간 리스트 |
void |
updateAllTbloomDcOrder(BloomDcVO bloomDcVO)
할인출력 순서 전체변경 |
void |
updateAllTbloomOption(BloomOptionVO bloomOptionVO)
옵션순서 전체 수정 |
void |
updateAllTbloomTime(BloomTimeVO bloomTimeVO)
시설물 이용시간 전체 순서변경(상단 updateTbloomTime 실행후 순차실행) |
void |
updateBloomDetail(BloomVO bloomVO)
상세정보 수정 운영중인 광양시청 포팅후 추가사항(기존데이터 이관문제로 따로 테이블을 구성하였습니다.) |
void |
updateOrderView(BloomOrderVO bloomOrderVO)
관리자추가금액 적용 |
void |
updateReserveCancel(BloomOrderVO bloomOrderVO)
예약취소 |
void |
updateRloom(BloomVO bloomVO)
시설물 수정 |
void |
updateRloomYn(BloomVO bloomVO)
시설물 노출여부 변경 |
void |
updateTbloomDcEtc(BloomDcVO bloomDcVO)
할인option update |
void |
updateTbloomDcHide(BloomDcVO bloomDcVO)
출력여부 Y/N |
void |
updateTbloomDcOrder(BloomDcVO bloomDcVO)
할인출력 순서 변경 |
void |
updateTbloomOption(BloomOptionVO bloomOptionVO)
옵션순서 수정 |
void |
updateTbloomOptionCntTp(BloomOptionVO bloomOptionVO)
노출여부 |
void |
updateTbloomOptionHide(BloomOptionVO bloomOptionVO)
노출 Y/N |
void |
updateTbloomTime(BloomTimeVO bloomTimeVO)
시설물 이용시간 순서변경 |
void |
updateTbloomTimeHide(BloomTimeVO bloomTimeVO)
시설물 이용시간 노출 Y/N 변경 |
java.util.List<BloomOrderVO> |
userOrderList(BloomOrderVO bloomOrderVO)
예약자 리스트 |
java.util.List<BloomVO> |
viewHoliDay()
시설물 리스트 |
BloomVO |
viewRloom(BloomVO bloomVO)
시설물 상세정보 |
BloomVO |
viewRloom(java.lang.Long indexNo)
|
java.util.List<BloomVO> |
viewRloomList(BloomVO bloomVO)
시설물 전체리스트 |
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 |
---|
public BloomDAO()
Method Detail |
---|
public int selectRloomTotal(BloomVO bloomVO) throws java.lang.Exception
java.lang.Exception
public java.util.List<BloomVO> selectRloom(BloomVO bloomVO) throws java.lang.Exception
bloomVO
-
java.lang.Exception
public java.lang.Long insertRloom(BloomVO bloomVO) throws java.lang.Exception
bloomVO
-
java.lang.Exception
public void deleteRloom(BloomVO bloomVO) throws java.lang.Exception
bloomVO
-
java.lang.Exception
public void updateRloomYn(BloomVO bloomVO) throws java.lang.Exception
bloomVO
-
java.lang.Exception
public BloomVO viewRloom(BloomVO bloomVO) throws java.lang.Exception
bloomVO
-
java.lang.Exception
public BloomVO viewRloom(java.lang.Long indexNo) throws java.lang.Exception
java.lang.Exception
public java.util.List<BloomVO> viewRloomList(BloomVO bloomVO) throws java.lang.Exception
bloomVO
-
java.lang.Exception
public java.util.List<BloomTimeVO> selectTbloomTime(java.lang.Long indexNo) throws java.lang.Exception
bloomTimeVO
-
java.lang.Exception
public BloomTimeVO selectTbloomTimeVo(java.lang.Long idexSeq) throws java.lang.Exception
bloomTimeVO
-
java.lang.Exception
public java.util.List<BloomOptionVO> selectTbloomOption(java.lang.Long indexNo) throws java.lang.Exception
indexNo
-
java.lang.Exception
public java.util.List<BloomDcVO> selectTbloomDc(java.lang.Long indexNo) throws java.lang.Exception
indexNo
-
java.lang.Exception
public void insertTbloomTime(BloomTimeVO bloomTimeVO) throws java.lang.Exception
bloomTimeVO
-
java.lang.Exception
public void updateTbloomTime(BloomTimeVO bloomTimeVO) throws java.lang.Exception
bloomTimeVO
-
java.lang.Exception
public void updateAllTbloomTime(BloomTimeVO bloomTimeVO) throws java.lang.Exception
bloomTimeVO
-
java.lang.Exception
public void deleteTbloomTime(java.lang.Long idexSeq) throws java.lang.Exception
idexSeq
-
java.lang.Exception
public void updateTbloomTimeHide(BloomTimeVO bloomTimeVO) throws java.lang.Exception
idexSeq
-
java.lang.Exception
public void insertTbloomOption(BloomOptionVO bloomOptionVO) throws java.lang.Exception
bloomOptionVO
-
java.lang.Exception
public void deleteTbloomOption(java.lang.Long idexSeq) throws java.lang.Exception
idexSeq
-
java.lang.Exception
public void updateTbloomOption(BloomOptionVO bloomOptionVO) throws java.lang.Exception
bloomOptionVO
-
java.lang.Exception
public void updateAllTbloomOption(BloomOptionVO bloomOptionVO) throws java.lang.Exception
bloomOptionVO
-
java.lang.Exception
public void updateTbloomOptionHide(BloomOptionVO bloomOptionVO) throws java.lang.Exception
bloomOptionVO
-
java.lang.Exception
public void updateTbloomOptionCntTp(BloomOptionVO bloomOptionVO) throws java.lang.Exception
bloomOptionVO
-
java.lang.Exception
public void insertTbloomDc(BloomDcVO bloomDcVO) throws java.lang.Exception
bloomDcVO
-
java.lang.Exception
public void deleteTbloomDc(java.lang.Long idexSeq) throws java.lang.Exception
idexSeq
-
java.lang.Exception
public void updateTbloomDcHide(BloomDcVO bloomDcVO) throws java.lang.Exception
bloomDcVO
-
java.lang.Exception
public void updateTbloomDcOrder(BloomDcVO bloomDcVO) throws java.lang.Exception
bloomDcVO
-
java.lang.Exception
public void updateAllTbloomDcOrder(BloomDcVO bloomDcVO) throws java.lang.Exception
bloomDcVO
-
java.lang.Exception
public void updateTbloomDcEtc(BloomDcVO bloomDcVO) throws java.lang.Exception
bloomDcVO
-
java.lang.Exception
public java.util.List<BloomVO> viewHoliDay() throws java.lang.Exception
bloomVO
-
java.lang.Exception
public int selectHoliDayCount(BloomHoliDayVO bloomHoliDayVO) throws java.lang.Exception
bloomHoliDayVO
-
java.lang.Exception
public java.util.List<BloomHoliDayVO> selectHoliDayList(BloomHoliDayVO bloomHoliDayVO) throws java.lang.Exception
bloomHoliDayVO
-
java.lang.Exception
public void insertHoliDay(BloomHoliDayVO bloomHoliDayVO) throws java.lang.Exception
bloomHoliDayVO
-
java.lang.Exception
public void deleteHoliDayList(java.lang.Long idexSeq) throws java.lang.Exception
idexSeq
-
java.lang.Exception
public int selectOrderTotal(BloomOrderVO bloomOrderVO) throws java.lang.Exception
bloomOrderVO
-
java.lang.Exception
public java.util.List<BloomOrderVO> selectOrderList(BloomOrderVO bloomOrderVO) throws java.lang.Exception
bloomOrderVO
-
java.lang.Exception
public BloomOrderVO selectOrderView(BloomOrderVO bloomOrderVO) throws java.lang.Exception
bloomOrderVO
-
java.lang.Exception
public java.util.List<BloomOrderOptionVO> selectOrderOption(BloomOrderOptionVO bloomOrderOptionVO) throws java.lang.Exception
bloomOrderOptionVO
-
java.lang.Exception
public void updateOrderView(BloomOrderVO bloomOrderVO) throws java.lang.Exception
bloomOrderVO
-
java.lang.Exception
public void orderCancel(BloomOrderVO bloomOrderVO) throws java.lang.Exception
bloomOrderVO
-
java.lang.Exception
public void orderCompleteAct(BloomOrderVO bloomOrderVO) throws java.lang.Exception
bloomOrderVO
-
java.lang.Exception
public void orderCancelAct(BloomOrderVO bloomOrderVO) throws java.lang.Exception
bloomOrderVO
-
java.lang.Exception
public void insertRloomfile(BloomFileVO bloomFileVO) throws java.lang.Exception
bloomFileVO
-
java.lang.Exception
public java.util.List<BloomFileVO> selectRloomfile(BloomFileVO bloomFileVO) throws java.lang.Exception
bloomFileVO
-
java.lang.Exception
public void deleteRloomfile(java.lang.Long fileSid) throws java.lang.Exception
fileSid
-
java.lang.Exception
public java.util.List<BloomHoliDayVO> selectUserHoliDayList(BloomHoliDayVO bloomHoliDayVO) throws java.lang.Exception
bloomHoliDayVO
-
java.lang.Exception
public java.util.List<BloomTimeVO> selectUserTbloomTime(BloomTimeVO bloomTimeVO) throws java.lang.Exception
bloomTimeVO
-
java.lang.Exception
public java.util.List<BloomOrderVO> userOrderList(BloomOrderVO bloomOrderVO) throws java.lang.Exception
bloomOrderVO
-
java.lang.Exception
public int reserveOrderCnt(BloomOrderVO bloomOrderVO) throws java.lang.Exception
bloomOrderVO
-
java.lang.Exception
public void insertReserveOrder(BloomOrderVO bloomOrderVO) throws java.lang.Exception
bloomOrderVO
-
java.lang.Exception
public int reserveOrderListCnt(BloomOrderVO bloomOrderVO) throws java.lang.Exception
bloomOrderVO
-
java.lang.Exception
public java.util.List<BloomOrderVO> reserveOrderList(BloomOrderVO bloomOrderVO) throws java.lang.Exception
bloomOrderVO
-
java.lang.Exception
public java.util.List<BloomOptionVO> selectOrderBloomOptionList(BloomOptionVO bloomOptionVO) throws java.lang.Exception
bloomOptionVO
-
java.lang.Exception
public java.util.List<BloomDcVO> selectReserveTbloomDc(BloomDcVO bloomDcVO) throws java.lang.Exception
bloomDcVO
-
java.lang.Exception
public void updateReserveCancel(BloomOrderVO bloomOrderVO) throws java.lang.Exception
bloomOrderVO
-
java.lang.Exception
public void reserveOrderOpUpdate(BloomOrderVO bloomOrderVO) throws java.lang.Exception
bloomOrderVO
-
java.lang.Exception
public void reserveOrderUpdate(BloomOrderVO bloomOrderVO) throws java.lang.Exception
bloomOrderVO
-
java.lang.Exception
public void reserveOrderOpInsert(BloomOrderVO bloomOrderVO) throws java.lang.Exception
bloomOrderVO
-
java.lang.Exception
public java.util.List<BloomOrderVO> reserveOrderBank(BloomOrderVO bloomOrderVO) throws java.lang.Exception
bloomOrderVO
-
java.lang.Exception
public int reserveOrderBankCnt(BloomOrderVO bloomOrderVO) throws java.lang.Exception
bloomOrderVO
-
java.lang.Exception
public void reserveOrderBankSuccess(BloomOrderVO bloomOrderVO) throws java.lang.Exception
bloomOrderVO
-
java.lang.Exception
public void deleteRloomMainfile(BloomFileVO bloomFileVO) throws java.lang.Exception
bloomFileVO
-
java.lang.Exception
public void updateRloom(BloomVO bloomVO) throws java.lang.Exception
bloomVO
-
java.lang.Exception
public java.util.List<BloomTimeVO> selectHoliDaytime(java.lang.Long indexNo) throws java.lang.Exception
indexNo
-
java.lang.Exception
public BloomVO selectBloomDetail(BloomVO bloomVO) throws java.lang.Exception
bloomVO
-
java.lang.Exception
public void insertBloomDetail(BloomVO bloomVO) throws java.lang.Exception
bloomVO
-
java.lang.Exception
public void updateBloomDetail(BloomVO bloomVO) throws java.lang.Exception
bloomVO
-
java.lang.Exception
public void deleteBloomDetail(BloomVO bloomVO) throws java.lang.Exception
bloomVO
-
java.lang.Exception
public int deleteBloomDetailCnt(long idexNo) throws java.lang.Exception
java.lang.Exception
public int selectSalesTotal(BloomSalesVO bloomSalesVO) throws java.lang.Exception
bloomSalesVO
-
java.lang.Exception
public java.util.List<BloomSalesVO> selectSales(BloomSalesVO bloomSalesVO) throws java.lang.Exception
bloomSalesVO
-
java.lang.Exception
public java.util.List<BloomSalesVO> selectAllSales(BloomSalesVO bloomSalesVO) throws java.lang.Exception
bloomSalesVO
-
java.lang.Exception
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |