Class FocCableDao
DAO кабелей ВОЛС.
-
Nested Class Summary
Nested classes/interfaces inherited from class ru.bitel.bgbilling.common.dao.AbstractDao
ru.bitel.bgbilling.common.dao.AbstractDao.ListParams -
Field Summary
Fields inherited from class ru.bitel.bgbilling.common.dao.AbstractDao
orderByPatternFields inherited from class ru.bitel.bgbilling.common.dao.AbstractDaoConstant
con, ERROR, fields, moduleId, SQL_ALL, SQL_AND, 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_ORDER, SQL_SELECT, SQL_SET, SQL_UPDATE, SQL_VALUES, SQL_WHERE, tableName -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionvoidclearStockItemLink(int stockItemId) Сброс привязки к товару склада у всех кабелей, привязанных к указанному товару.intcountByNode(int nodeId) intcountByStockItem(int stockItemId) Подсчёт кабелей, привязанных к указанному товару склада.protected FocCablegetList()protected Stringprotected voidupdateImpl(FocCable cable) Methods inherited from class ru.bitel.bgbilling.common.dao.AbstractIdDao
delete, executeUpdate, get, getAndDelete, getAndUpdate, loadData, opt, prepareStatement, sqlCommand, sqlCommandAndTable, sqlInsertValues, sqlQuery, sqlUpdateSet, sqlWhereIdMethods inherited from class ru.bitel.bgbilling.common.dao.AbstractDao
deleteImpl, dropTemporaryTable, eq, get, getById, getImpl, getListFromRS, getPeriod, getQueryWithFilter, list, list, list, listCountImplPS, listImpl, listImplPS, ormFromResultSet, ormUpdateImpl, ormUpdateImpl, ormUpdateImpl, ormUpdateImpl, queryPeriod, setPageRecordCount, updateMethods inherited from class ru.bitel.bgbilling.common.dao.AbstractDaoConstant
getPlaceholders, getSQLOrder, getSQLOrderFields, getTableName, psSetDate, psSetDateOrNull, psSetInt, psSetIntOrNull, psSetPeriod, psSetString, psSetStringOrNull, psSetTimestampOrNull, queryAndIn, setStatementParam, sqlDelete, sqlDeleteBatch, sqlInsert, sqlInsertBatch, sqlInsertGetId, sqlInsertGetLongId, sqlInsertOnDuplicateKeyUpdate, sqlInsertSelect, sqlInsertUpdateById, sqlSelectCountAsInt, sqlUpdate, sqlUpdateBatchMethods inherited from class ru.bitel.bgbilling.kernel.base.server.logger.BGLogger
error, error, error, getLogger, logError, logError, logError, warn
-
Constructor Details
-
FocCableDao
-
-
Method Details
-
getFromRS
- Specified by:
getFromRSin classru.bitel.bgbilling.common.dao.AbstractDao<FocCable>- Throws:
SQLException
-
getQueryById
- Overrides:
getQueryByIdin classru.bitel.bgbilling.common.dao.AbstractDao<FocCable>
-
updateImpl
- Specified by:
updateImplin classru.bitel.bgbilling.common.dao.AbstractDao<FocCable>- Throws:
SQLException
-
getList
- Throws:
SQLException
-
countByNode
- Throws:
SQLException
-
countByStockItem
Подсчёт кабелей, привязанных к указанному товару склада.- Throws:
SQLException
-
clearStockItemLink
Сброс привязки к товару склада у всех кабелей, привязанных к указанному товару.- Throws:
SQLException
-