ru.bgcrm.plugin.bgbilling.dao

Class CommonContractDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.plugin.bgbilling.dao.CommonContractDAO

public class CommonContractDAO
extends CommonDAO

Field Summary

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_LEFT_JOIN, SQL_LIMIT, 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

Methods

Modifier and Type	Method and Description
void	changeCustomerLink(int commonContractId, 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	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)
void	updateCommonContract(CommonContract contract)

Methods inherited from class ru.bgcrm.dao.CommonDAO

addLikeSql, convertDateToSqlDate, convertDateToTimestamp, deleteById, getFoundRows, getGroupedIds, getGroupedIds, getIds, getIds, getLikePattern, getMySQLLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, sqlToBgException, updateColumn, updateIds, updateIds

Methods inherited from class java.lang.Object

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

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

getContractById

public CommonContract getContractById(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 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

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