ru.bgcrm.plugin.bgbilling.dao

Class CommonContractDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.plugin.bgbilling.dao.CommonContractDAO

Direct Known Subclasses:

CommonContractDAOWrapper

public class CommonContractDAO
extends CommonDAO

Nested Class Summary

Nested classes/interfaces inherited from class ru.bgcrm.dao.CommonDAO

CommonDAO.ObjectExtractor<T>, CommonDAO.RecordUpdater<T extends Id>

Field Summary

Fields

Modifier and Type	Field and Description
protected CommonContractConfig	config
protected java.lang.String	SELECT_QUERY_START

Fields inherited from class ru.bgcrm.dao.CommonDAO

con, dateFormat_DDMMYYYY, dateFormat_DDMMYYYY_HHMM, log, SQL_AND, SQL_DELETE, SQL_DESC, SQL_FROM, SQL_GROUP_BY, SQL_INNER_JOIN, SQL_INSERT, SQL_INSERT_IGNORE, SQL_LEFT_JOIN, SQL_LEFT_OUTER_JOIN, SQL_LIMIT, SQL_ON_DUP_KEY_UPDATE, SQL_OR, SQL_ORDER_BY, SQL_REPLACE, SQL_SELECT, SQL_SELECT_ALL_FROM, SQL_SELECT_COUNT_ROWS, SQL_SET, SQL_UPDATE, SQL_WHERE

Constructor Summary

Constructors

Constructor and Description
CommonContractDAO(java.sql.Connection con)

Method Summary

Modifier and Type	Method and Description
void	changeCustomerLink(int commonContractId, int customerId)
CommonContract	createCommonContract(int areaId, int number, int customerId)
CommonContract	createCommonContract(int customerId, ParameterAddressValue address)
CommonContract	createCommonContractWithTitle(int customerId, java.lang.String title, ParameterAddressValue address)
void	deleteCommonContract(int id)
CommonContract	getContract(CommonContract result, java.sql.PreparedStatement ps)
CommonContract	getContractByAreaAndNumber(int areaId, int number)
CommonContract	getContractByCustomerId(int id)
CommonContract	getContractById(int id)
CommonContract	getContractCommon(int customerId, java.lang.String contractNumber)
java.util.List<CommonContract>	getContractList(int customerId)
java.lang.String	getContractNumber(int commonContractId, int serviceCode)
java.lang.String	getContractNumber(int commonContractId, java.lang.String serviceCode)
java.lang.String	getContractNumber(int commonContractId, java.lang.String serviceCode, boolean isServiceCodeNeeded)
int	getNextCommonContractNumber(int cityId, java.sql.Connection con)
void	updateCommonContract(CommonContract contract)

Methods inherited from class ru.bgcrm.dao.CommonDAO

deleteById, execute, execute, execute, executeInsert, executeUpdate, getById, getFoundRows, getFoundRows, getGroupedIds, getGroupedIds, getIds, getIds, getLikePattern, getLikePatternEnd, getLikePatternStart, getLikePatternSub, getMySQLLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, sqlToBgException, update, updateColumn, updateIds, updateIds

Methods inherited from class java.lang.Object

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

Field Detail

config

protected CommonContractConfig config

SELECT_QUERY_START

protected final java.lang.String SELECT_QUERY_START

See Also:

Constant Field Values

Constructor Detail

CommonContractDAO

public CommonContractDAO(java.sql.Connection con)

Method Detail

getContractNumber

public java.lang.String getContractNumber(int commonContractId,
                                          int serviceCode)
                                   throws BGException

Throws:

BGException

getContractNumber

public java.lang.String getContractNumber(int commonContractId,
                                          java.lang.String serviceCode)
                                   throws BGException

Throws:

BGException

getContractNumber

public java.lang.String getContractNumber(int commonContractId,
                                          java.lang.String serviceCode,
                                          boolean isServiceCodeNeeded)
                                   throws BGException

Throws:

BGException

getContractById

public CommonContract getContractById(int id)
                               throws BGException

Throws:

BGException

getContractByCustomerId

public CommonContract getContractByCustomerId(int id)
                                       throws BGException

Throws:

BGException

getContractByAreaAndNumber

public CommonContract getContractByAreaAndNumber(int areaId,
                                                 int number)
                                          throws BGException

Throws:

BGException

getContract

public CommonContract getContract(CommonContract result,
                                  java.sql.PreparedStatement ps)
                           throws BGException

Throws:

BGException

getContractList

public java.util.List<CommonContract> getContractList(int customerId)
                                               throws BGException

Throws:

BGException

getContractCommon

public CommonContract getContractCommon(int customerId,
                                        java.lang.String contractNumber)
                                 throws BGException

Throws:

BGException

createCommonContract

public CommonContract createCommonContract(int areaId,
                                           int number,
                                           int customerId)
                                    throws BGException

Throws:

BGException

createCommonContract

public CommonContract createCommonContract(int customerId,
                                           ParameterAddressValue address)
                                    throws BGException

Throws:

BGException

changeCustomerLink

public void changeCustomerLink(int commonContractId,
                               int customerId)
                        throws BGMessageException

Throws:

BGMessageException

updateCommonContract

public void updateCommonContract(CommonContract contract)
                          throws BGException

Throws:

BGException

getNextCommonContractNumber

public int getNextCommonContractNumber(int cityId,
                                       java.sql.Connection con)
                                throws BGException

Throws:

BGException

createCommonContractWithTitle

public CommonContract createCommonContractWithTitle(int customerId,
                                                    java.lang.String title,
                                                    ParameterAddressValue address)
                                             throws BGException

Throws:

BGException

deleteCommonContract

public void deleteCommonContract(int id)
                          throws BGException

Throws:

BGException