Package ru.bitel.oss.systems.inventory.service.server.bean

Class ServiceDao

java.lang.Object
ru.bitel.common.dao.AbstarctDaoConstant
ru.bitel.common.dao.AbstractDao<B>
ru.bitel.common.dao.AbstractIdDao<Service>
ru.bitel.oss.systems.inventory.service.server.bean.ServiceDao
All Implemented Interfaces:
AutoCloseable, ru.bitel.common.worker.Recyclable
public class ServiceDao extends ru.bitel.common.dao.AbstractIdDao<Service> implements ru.bitel.common.worker.Recyclable

  • Nested Class Summary

    Nested classes/interfaces inherited from class ru.bitel.common.dao.AbstractDao

    ru.bitel.common.dao.AbstractDao.ResultSetIterator

  • Field Summary

    Fields inherited from class ru.bitel.common.dao.AbstractDao

    cacheFilter, cacheJoin, cacheOrderBy, cachePaged, cachePS, cacheWhat, con, getByIdPS, moduleId, orderByPattern, tableName

    Fields inherited from class ru.bitel.common.dao.AbstarctDaoConstant

    ERROR, fields, SQL_ALL, SQL_AND, SQL_CALC_FOUND_ROWS, 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_ON_DUPLICATE_KEY_UPDATE, SQL_ORDER, SQL_SELECT, SQL_SET, SQL_UPDATE, SQL_VALUES, SQL_WHERE

  • Constructor Summary

    Constructors
    Constructor
    Description
    ServiceDao(Connection con)
     

  • Method Summary

    Modifier and Type
    Method
    Description
    void
    delete(int contractId, int id)
     
    void
    deleteByProduct(int contractId, int productId)
     
    protected Service
    getFromRS(ResultSet rs)
     
    List<Service>
    list(int contractId, int productId)
     
    List<Service>
    list(int moduleId, int contractId, int accountId, boolean kernel, Date timeFrom, Date timeTo, Date timeFromIntersect, Date timeToIntersect, boolean needNonActive, boolean titleLoad)
     
    void
    recycle()
     
    void
    updateDeviceState(int contractId, int tvAccountId, int serviceId, short deviceState)
     
    protected void
    updateImpl(Service b)
     

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

    delete, get, getAndDelete, getAndUpdate, opt

    Methods inherited from class ru.bitel.common.dao.AbstractDao

    close, delete, deleteImpl, eq, get, getById, getImpl, getListFromRS, getPeriod, getQueryById, getSQLOrder, getTableName, list, list, listImpl, listImpl, listImplPS, listImplPS, ormFromResultSet, ormUpdateImpl, ormUpdateImpl, ormUpdateImpl, ormUpdateImpl, processException, setStatementParam, update

    Methods inherited from class ru.bitel.common.dao.AbstarctDaoConstant

    getLogger, getSQLOrder

    Methods inherited from class java.lang.Object

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

  • Constructor Details

  • Method Details

    • list

      public List<Service> list(int contractId, int productId) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException

    • list

      public List<Service> list(int moduleId, int contractId, int accountId, boolean kernel, Date timeFrom, Date timeTo, Date timeFromIntersect, Date timeToIntersect, boolean needNonActive, boolean titleLoad) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException

    • getFromRS

      protected Service getFromRS(ResultSet rs) throws SQLException, ru.bitel.bgbilling.common.BGException
      Specified by:
      getFromRS in class ru.bitel.common.dao.AbstractDao<Service>
      Throws:
      SQLException
      ru.bitel.bgbilling.common.BGException

    • updateImpl

      protected void updateImpl(Service b) throws ru.bitel.bgbilling.common.BGException, SQLException
      Specified by:
      updateImpl in class ru.bitel.common.dao.AbstractDao<Service>
      Throws:
      ru.bitel.bgbilling.common.BGException
      SQLException

    • updateDeviceState

      public void updateDeviceState(int contractId, int tvAccountId, int serviceId, short deviceState) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException

    • delete

      public void delete(int contractId, int id) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException

    • deleteByProduct

      public void deleteByProduct(int contractId, int productId) throws ru.bitel.bgbilling.common.BGException
      Throws:
      ru.bitel.bgbilling.common.BGException

    • recycle

      public void recycle()
      Specified by:
      recycle in interface ru.bitel.common.worker.Recyclable
      Overrides:
      recycle in class ru.bitel.common.dao.AbstractDao<Service>