Package ru.bitel.bgbilling.modules.megogo.server.bean

Class MegogoContractTryAndBuyDao

java.lang.Object

ru.bitel.bgbilling.kernel.base.server.logger.BGLogger

ru.bitel.bgbilling.common.dao.AbstarctDaoConstant

ru.bitel.bgbilling.common.dao.AbstractDao<B>

ru.bitel.bgbilling.common.dao.AbstractIdDao<MegogoContractTryAndBuy>

ru.bitel.bgbilling.modules.megogo.server.bean.MegogoContractTryAndBuyDao

public class MegogoContractTryAndBuyDao
extends ru.bitel.bgbilling.common.dao.AbstractIdDao<MegogoContractTryAndBuy>

Field Summary

Fields inherited from class ru.bitel.bgbilling.common.dao.AbstractDao

con, moduleId, orderByPattern, tableName

Fields inherited from class ru.bitel.bgbilling.common.dao.AbstarctDaoConstant

ERROR, fields, SQL_ALL, SQL_AND, SQL_CALC_FOUND_ROWS, SQL_DELETE, SQL_DISTINCT, SQL_EQ, SQL_EQCS, SQL_FROM, SQL_GROUP, SQL_IN, SQL_INSERT, SQL_JOIN, SQL_LEFT_JOIN, SQL_LIMIT, SQL_NOT_IN, SQL_ON, SQL_ON_DUPLICATE_KEY_UPDATE, SQL_ORDER, SQL_SELECT, SQL_SET, SQL_UPDATE, SQL_VALUES, SQL_WHERE

Constructor Summary

Constructors

Constructor	Description
MegogoContractTryAndBuyDao(Connection con, int moduleId)

Method Summary

Modifier and Type	Method	Description
MegogoContractTryAndBuy	getContractTBByIdSub(int idSub)	Получить try&buy договора по подписке.
List<MegogoContractTryAndBuy>	getContractTBList(int contractId, Period period, int idTB)	Получить список try&buy.
protected MegogoContractTryAndBuy	getFromRS(ResultSet rs)
protected void	updateImpl(MegogoContractTryAndBuy contractTB)

Methods inherited from class ru.bitel.bgbilling.common.dao.AbstractIdDao

delete, executeUpdate, get, getAndDelete, getAndUpdate, opt, sqlCommand, sqlCommandAndTable, sqlQuery, sqlWhereId

Methods inherited from class ru.bitel.bgbilling.common.dao.AbstractDao

delete, deleteImpl, eq, get, getById, getImpl, getListFromRS, getPeriod, getQueryById, getSQLOrder, getTableName, list, list, listImpl, listImpl, listImplPS, listImplPS, ormFromResultSet, ormUpdateImpl, ormUpdateImpl, ormUpdateImpl, ormUpdateImpl, setStatementParam, update

Methods inherited from class ru.bitel.bgbilling.common.dao.AbstarctDaoConstant

getSQLOrder

Methods inherited from class ru.bitel.bgbilling.kernel.base.server.logger.BGLogger

error, error, error, getLogger, logError, logError

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

MegogoContractTryAndBuyDao

public MegogoContractTryAndBuyDao(Connection con,
 int moduleId)

Method Details

getContractTBByIdSub

public MegogoContractTryAndBuy getContractTBByIdSub(int idSub)
                                             throws SQLException

Получить try&buy договора по подписке.

Parameters:

idSub - - код подписки( id таблицы megogo_contract_subscription )

Returns:

Throws:

SQLException

getContractTBList

public List<MegogoContractTryAndBuy> getContractTBList(int contractId,
 Period period,
 int idTB)
                                                throws SQLException

Получить список try&buy.

Parameters:

contractId - - код договова.

period - - за какой период, если null( хоть одна из дат ), то за весь.

idTB - - код Try&Buy( из таблицы megogo_try_and_buy )

Returns:

Throws:

ru.bitel.bgbilling.common.BGException

SQLException

getFromRS

protected MegogoContractTryAndBuy getFromRS(ResultSet rs)
                                     throws SQLException

Specified by:

getFromRS in class ru.bitel.bgbilling.common.dao.AbstractDao<MegogoContractTryAndBuy>

Throws:

SQLException

updateImpl

protected void updateImpl(MegogoContractTryAndBuy contractTB)
                   throws SQLException

Specified by:

updateImpl in class ru.bitel.bgbilling.common.dao.AbstractDao<MegogoContractTryAndBuy>

Throws:

SQLException