Package ru.bitel.oss.systems.inventory.service.server.bean

Class ServiceDao

java.lang.Object

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

ru.bitel.common.dao.AbstarctDaoConstant

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

ru.bitel.common.dao.AbstractIdDao<Service>

ru.bitel.oss.systems.inventory.service.server.bean.ServiceDao

All Implemented Interfaces:

AutoCloseable

public class ServiceDao
extends ru.bitel.common.dao.AbstractIdDao<Service>

Nested Class Summary

Nested classes/interfaces inherited from class ru.bitel.common.dao.AbstractDao

ru.bitel.common.dao.AbstractDao.ResultSetIterator

Field Summary

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

cacheFilter, cacheJoin, cacheOrderBy, cachePaged, cachePS, cacheWhat, con, getByIdPS, moduleId, orderByPattern, tableName

Fields inherited from class ru.bitel.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
ServiceDao(Connection con)

Method Summary

Modifier and Type	Method	Description
void	close()
void	delete(int contractId, int id)
void	deleteByProduct(int contractId, int productId)
protected Service	getFromRS(ResultSet rs)
List<Service>	list(int contractId, int productId)
List<Service>	list(int moduleId, int contractId, int accountId, boolean kernel, Date timeFrom, Date timeTo, Date timeFromIntersect, Date timeToIntersect, boolean needNonActive, boolean titleLoad)
void	updateDeviceState(int contractId, int tvAccountId, int serviceId, short deviceState)
protected void	updateImpl(Service b)

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

delete, get, getAndDelete, getAndUpdate, opt

Methods inherited from class ru.bitel.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, processException, setStatementParam, update

Methods inherited from class ru.bitel.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

ServiceDao

public ServiceDao(Connection con)

Method Details

list

public List<Service> list(int contractId,
 int productId)
                   throws ru.bitel.bgbilling.common.BGException

Throws:

ru.bitel.bgbilling.common.BGException

list

public List<Service> list(int moduleId,
 int contractId,
 int accountId,
 boolean kernel,
 Date timeFrom,
 Date timeTo,
 Date timeFromIntersect,
 Date timeToIntersect,
 boolean needNonActive,
 boolean titleLoad)
                   throws ru.bitel.bgbilling.common.BGException

Throws:

ru.bitel.bgbilling.common.BGException

getFromRS

protected Service getFromRS(ResultSet rs)
                     throws SQLException,
ru.bitel.bgbilling.common.BGException

Specified by:

getFromRS in class ru.bitel.common.dao.AbstractDao<Service>

Throws:

SQLException

ru.bitel.bgbilling.common.BGException

updateImpl

protected void updateImpl(Service b)
                   throws ru.bitel.bgbilling.common.BGException,
SQLException

Specified by:

updateImpl in class ru.bitel.common.dao.AbstractDao<Service>

Throws:

ru.bitel.bgbilling.common.BGException

SQLException

updateDeviceState

public void updateDeviceState(int contractId,
 int tvAccountId,
 int serviceId,
 short deviceState)
                       throws ru.bitel.bgbilling.common.BGException

Throws:

ru.bitel.bgbilling.common.BGException

delete

public void delete(int contractId,
 int id)
            throws Exception

Throws:

Exception

deleteByProduct

public void deleteByProduct(int contractId,
 int productId)
                     throws Exception

Throws:

Exception

close

public void close()
           throws ru.bitel.bgbilling.common.BGException

Specified by:

close in interface AutoCloseable

Overrides:

close in class ru.bitel.common.dao.AbstractDao<Service>

Throws:

ru.bitel.bgbilling.common.BGException