Class ProductDao
java.lang.Object
ru.bitel.common.dao.AbstarctDaoConstant
ru.bitel.common.dao.AbstractDao<B>
ru.bitel.common.dao.AbstractIdDao<Product>
ru.bitel.oss.systems.inventory.product.server.bean.ProductDao
- 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, logger, moduleId, orderByPattern, tableName
Fields inherited from class ru.bitel.common.dao.AbstarctDaoConstant
ERROR, fields, SQL_CALC_FOUND_ROWS, SQL_DELETE, SQL_DISTINCT, SQL_EQ, SQL_EQCS, SQL_FROM, SQL_GROUP, SQL_IN, SQL_INSERT, SQL_LIMIT, SQL_ON_DUPLICATE_KEY_UPDATE, SQL_ORDER, SQL_SELECT, SQL_SET, SQL_UPDATE, SQL_VALUES, SQL_WHERE
-
Constructor Summary
-
Method Summary
Modifier and TypeMethodDescriptionvoid
checkProductSpecActivationModeDelete
(int activationModeId) void
checkProductSpecDelete
(int productSpecId) void
deactivate
(Product product, boolean customer) int
delete
(int contractId, int id) get
(int contractId, int id) getAndDelete
(int contractId, int id) protected Product
list
(int moduleId, int contractId, int accountId, boolean kernel, Date timeFrom, Date timeTo, Date timeFromIntersect, Date timeToIntersect, boolean needNonActive, boolean titleLoad) Получение списка продуктов договора.void
recycle()
void
updateDeviceState
(int contractId, int tvAccountId, int productId, String deviceProductId, short deviceState) Обновление состояния продукта.protected void
updateImpl
(Product product) Methods inherited from class ru.bitel.common.dao.AbstractIdDao
delete, get, getAndDelete, getAndUpdate
Methods inherited from class ru.bitel.common.dao.AbstractDao
close, 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
-
Field Details
-
getByContractAndIdPS
-
-
Constructor Details
-
ProductDao
-
ProductDao
-
-
Method Details
-
getFromRS
- Specified by:
getFromRS
in classru.bitel.common.dao.AbstractDao<Product>
- Throws:
SQLException
-
updateImpl
protected void updateImpl(Product product) throws ru.bitel.bgbilling.common.BGException, SQLException - Specified by:
updateImpl
in classru.bitel.common.dao.AbstractDao<Product>
- Throws:
ru.bitel.bgbilling.common.BGException
SQLException
-
deactivate
public void deactivate(Product product, boolean customer) throws ru.bitel.bgbilling.common.BGException - Throws:
ru.bitel.bgbilling.common.BGException
-
list
public List<Product> list(int moduleId, int contractId, int accountId, boolean kernel, Date time) throws ru.bitel.bgbilling.common.BGException - Throws:
ru.bitel.bgbilling.common.BGException
-
list
public List<Product> 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 Получение списка продуктов договора.- Parameters:
moduleId
- ID модуля, если <0, то продукты всех модулей, ==0 - продукты ядраcontractId
- ID договораaccountId
-kernel
- включать ли продукты ядра, если moduleId >=0timeFrom
-timeTo
-timeFromIntersect
-timeToIntersect
-needNonActive
-titleLoad
-- Returns:
- Throws:
ru.bitel.bgbilling.common.BGException
-
delete
public int delete(int contractId, int id) throws ru.bitel.bgbilling.common.BGException - Throws:
ru.bitel.bgbilling.common.BGException
-
updateDeviceState
public void updateDeviceState(int contractId, int tvAccountId, int productId, String deviceProductId, short deviceState) throws ru.bitel.bgbilling.common.BGException Обновление состояния продукта.- Parameters:
contractId
- ID договораtvAccountId
- ID аккаунтаproductId
- ID продуктаdeviceProductId
- новый ID продукта на MW (внешний ID)deviceState
- новое состояние продукта на MW (внешнее состояние)- Throws:
ru.bitel.bgbilling.common.BGException
-
get
- Throws:
ru.bitel.bgbilling.common.BGException
-
getAndDelete
- Throws:
ru.bitel.bgbilling.common.BGException
-
recycle
public void recycle() throws ru.bitel.bgbilling.common.BGException- Overrides:
recycle
in classru.bitel.common.dao.AbstractDao<Product>
- Throws:
ru.bitel.bgbilling.common.BGException
-
checkProductSpecDelete
public void checkProductSpecDelete(int productSpecId) throws ru.bitel.bgbilling.common.BGException - Throws:
ru.bitel.bgbilling.common.BGException
-
checkProductSpecActivationModeDelete
public void checkProductSpecActivationModeDelete(int activationModeId) throws ru.bitel.bgbilling.common.BGException - Throws:
ru.bitel.bgbilling.common.BGException
-