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

Class ServiceDao

java.lang.Object

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

ru.bitel.bgbilling.common.dao.AbstractDaoConstant

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

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

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

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

Field Summary

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

orderByPattern

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

con, ERROR, fields, moduleId, 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, tableName

Constructor Summary

Constructors

Constructor	Description
ServiceDao(Connection con)

Method Summary

Modifier and Type	Method	Description
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 service)

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

delete, executeUpdate, get, getAndDelete, getAndUpdate, opt, prepareStatement, sqlCommand, sqlCommandAndTable, sqlInsertValues, sqlQuery, sqlUpdateSet, sqlWhereId

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

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

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

getSQLOrder, getTableName, psSetDate, psSetDateOrNull, psSetInt, psSetIntOrNull, psSetPeriod, psSetString, psSetStringOrNull, psSetTimestampOrNull, queryAndIn

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

error, error, error, getLogger, logError, logError, warn

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 SQLException

Throws:

SQLException

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 SQLException

Throws:

SQLException

getFromRS

protected Service getFromRS(ResultSet rs)
                     throws SQLException

Specified by:

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

Throws:

SQLException

updateImpl

protected void updateImpl(Service service)
                   throws SQLException

Specified by:

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

Throws:

SQLException

updateDeviceState

public void updateDeviceState(int contractId,
 int tvAccountId,
 int serviceId,
 short deviceState)
                       throws SQLException

Throws:

SQLException

delete

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

Throws:

SQLException

deleteByProduct

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

Throws:

SQLException