Class ServiceDao
java.lang.Object
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
-
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
-
Method Summary
Modifier and TypeMethodDescriptionvoid
close()
void
delete
(int contractId, int id) void
deleteByProduct
(int contractId, int productId) protected Service
list
(int contractId, int productId) 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
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
getLogger, getSQLOrder
-
Constructor Details
-
ServiceDao
-
-
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 classru.bitel.common.dao.AbstractDao<Service>
- Throws:
SQLException
ru.bitel.bgbilling.common.BGException
-
updateImpl
- Specified by:
updateImpl
in classru.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 ru.bitel.bgbilling.common.BGException - Throws:
ru.bitel.bgbilling.common.BGException
-
deleteByProduct
public void deleteByProduct(int contractId, int productId) throws ru.bitel.bgbilling.common.BGException - Throws:
ru.bitel.bgbilling.common.BGException
-
close
public void close() throws ru.bitel.bgbilling.common.BGException- Specified by:
close
in interfaceAutoCloseable
- Overrides:
close
in classru.bitel.common.dao.AbstractDao<Service>
- Throws:
ru.bitel.bgbilling.common.BGException
-