Class FocNodeDao

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

public class FocNodeDao extends ru.bitel.bgbilling.common.dao.AbstractIdDao<FocNode>
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
    FocNodeDao(Connection con, int moduleId)
     
  • Method Summary

    Modifier and Type
    Method
    Description
    void
    clearStockItemLink(int stockItemId)
    Сброс привязки к товару склада у всех узлов, привязанных к указанному товару.
    int
    countByStockItem(int stockItemId)
    Подсчёт узлов, привязанных к указанному товару склада.
    int
    countChildren(int nodeId)
     
    protected FocNode
     
     
    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

    • FocNodeDao

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

    • getFromRS

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

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

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

      public List<FocNode> getList() throws SQLException
      Throws:
      SQLException
    • countChildren

      public int countChildren(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