Class FocPortDao

java.lang.Object
ru.bitel.bgbilling.kernel.base.server.logger.BGLogger
ru.bitel.bgbilling.common.dao.AbstractDaoConstant
ru.bitel.bgbilling.common.dao.AbstractDao<FocPort>
ru.bitel.bgbilling.common.dao.AbstractIdDao<FocPort>
ru.bitel.bgbilling.plugins.shop.server.dao.FocPortDao

public class FocPortDao extends ru.bitel.bgbilling.common.dao.AbstractIdDao<FocPort>
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

    orderByPattern

    Fields 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
    Constructor
    Description
    FocPortDao(Connection con, int moduleId)
     
  • Method Summary

    Modifier and Type
    Method
    Description
    void
    clearStockItemLink(int stockItemId)
    Сброс привязки к товару склада у всех портов, привязанных к указанному товару.
    int
    countByStockItem(int stockItemId)
    Подсчёт портов, привязанных к указанному товару склада.
    void
    deleteByNodeId(int nodeId)
     
    protected FocPort
     
    getList(int nodeId)
     
    protected String
     
    protected void
     

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

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

    Methods 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, update

    Methods 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, sqlUpdateBatch

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

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

    Methods inherited from class java.lang.Object

    clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
  • Constructor Details

    • FocPortDao

      public FocPortDao(Connection con, int moduleId)
  • Method Details

    • getFromRS

      protected FocPort getFromRS(ResultSet rs) throws SQLException
      Specified by:
      getFromRS in class ru.bitel.bgbilling.common.dao.AbstractDao<FocPort>
      Throws:
      SQLException
    • getQueryById

      protected String getQueryById()
      Overrides:
      getQueryById in class ru.bitel.bgbilling.common.dao.AbstractDao<FocPort>
    • updateImpl

      protected void updateImpl(FocPort port) throws SQLException
      Specified by:
      updateImpl in class ru.bitel.bgbilling.common.dao.AbstractDao<FocPort>
      Throws:
      SQLException
    • getList

      public List<FocPort> getList(int nodeId) throws SQLException
      Throws:
      SQLException
    • deleteByNodeId

      public void deleteByNodeId(int nodeId) throws SQLException
      Throws:
      SQLException
    • countByStockItem

      public int countByStockItem(int stockItemId) throws SQLException
      Подсчёт портов, привязанных к указанному товару склада.
      Throws:
      SQLException
    • clearStockItemLink

      public void clearStockItemLink(int stockItemId) throws SQLException
      Сброс привязки к товару склада у всех портов, привязанных к указанному товару.
      Throws:
      SQLException