Package ru.bitel.bgbilling.kernel.tariff.server.dao

Class TariffLabelDao

java.lang.Object
ru.bitel.bgbilling.kernel.base.server.logger.BGLogger
ru.bitel.bgbilling.common.dao.AbstractDaoConstant
ru.bitel.bgbilling.kernel.tariff.server.dao.TariffLabelDao
public class TariffLabelDao extends ru.bitel.bgbilling.common.dao.AbstractDaoConstant

  • Field Summary

    Fields
    Modifier and Type
    Field
    Description
    protected static final String
    TABLE_TARIFF_LABEL
     
    protected static final String
    TABLE_TARIFF_LABEL_LINK
     

    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
    TariffLabelDao(Connection con)
     

  • Method Summary

    Modifier and Type
    Method
    Description
    Set<Integer>
    getTariffIdsByLabelId(int labelId)
    Получить коды тарифов имеющих заданную метку
    Set<Integer>
    getTariffLabelIds(int tariffPlanId)
     
    List<TariffLabelItem>
    getTariffLabelItemList()
     
    void
    removeTariffLabelItem(int tariffLabelItemId)
     
    void
    setTariffLabelIds(int tariffPlanId, Set<Integer> labelIds)
     
    void
    updateTariffLabelTreeItem(TariffLabelItem tariffLabelItem)
     

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

    getPeriod, 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, warn

    Methods inherited from class java.lang.Object

    clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

  • Field Details

  • Constructor Details

    • TariffLabelDao

      public TariffLabelDao(Connection con)

  • Method Details

    • getTariffLabelItemList

      public List<TariffLabelItem> getTariffLabelItemList() throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException

    • getTariffLabelIds

      public Set<Integer> getTariffLabelIds(int tariffPlanId) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException

    • getTariffIdsByLabelId

      public Set<Integer> getTariffIdsByLabelId(int labelId) throws ru.bitel.bgbilling.common.BGException
      Получить коды тарифов имеющих заданную метку
      Parameters:
      labelId - - код метки
      Throws:
      ru.bitel.bgbilling.common.BGException

    • setTariffLabelIds

      public void setTariffLabelIds(int tariffPlanId, Set<Integer> labelIds) throws SQLException
      Throws:
      SQLException

    • updateTariffLabelTreeItem

      public void updateTariffLabelTreeItem(TariffLabelItem tariffLabelItem) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException

    • removeTariffLabelItem

      public void removeTariffLabelItem(int tariffLabelItemId) throws SQLException
      Throws:
      SQLException