Class FocCableDao

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

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

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

    • FocCableDao

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

    • getFromRS

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

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

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

      public List<FocCable> getList() throws SQLException
      Throws:
      SQLException
    • countByNode

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