public class CustomerLinkDAO extends CommonLinkDAO
CommonDAO.ObjectExtractor<T>, CommonDAO.RecordUpdater<T extends Id>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 and Description |
|---|
CustomerLinkDAO(java.sql.Connection con) |
| Modifier and Type | Method and Description |
|---|---|
protected java.lang.String |
getColumnName() |
protected EntityLogDAO |
getEntityLogDAO() |
java.util.List<Contract> |
getLinkedContracts(int customerId) |
java.util.List<Pair<java.lang.Integer,Contract>> |
getLinkedContracts(java.lang.String contractTitle,
boolean disableStrictMode) |
java.util.List<Contract> |
getLinkedContractsByCustomerIdAndContractTitle(int customerId,
java.lang.String contractTitle,
boolean strictMode) |
java.util.List<Contract> |
getLinkedContractsByTitle(java.lang.String contractTitle,
boolean strictMode)
Метод получения списка связанных договоров по его заголовку
|
protected java.lang.String |
getObjectType() |
protected java.lang.String |
getTable() |
void |
searchCustomerByLink(SearchResult<Customer> searchResult,
CommonObjectLink link) |
addLink, addLinkAndLog, addLinkIfNotExist, copyLinks, copyLinks, deleteLink, deleteLinkAndLog, deleteLinksTo, deleteLinksWithType, deleteObjectLinks, getLinkDAO, getLinkedCustomer, getLinkedCustomers, getLinkingObjectLinksWithType, getObjectLinksWithType, isLinkExists, prepareLink, updateLinkTitlesdeleteById, 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, updateIdsprotected java.lang.String getTable()
getTable in class CommonLinkDAOprotected java.lang.String getColumnName()
getColumnName in class CommonLinkDAOprotected java.lang.String getObjectType()
getObjectType in class CommonLinkDAOprotected EntityLogDAO getEntityLogDAO()
getEntityLogDAO in class CommonLinkDAOpublic void searchCustomerByLink(SearchResult<Customer> searchResult, CommonObjectLink link) throws BGException
BGExceptionpublic java.util.List<Contract> getLinkedContractsByTitle(java.lang.String contractTitle, boolean strictMode) throws BGException
contractTitle - заголовок запросаstrictMode - режим поиска, по аналогии с java - strict это equals, а !strict это containsBGExceptionpublic java.util.List<Contract> getLinkedContractsByCustomerIdAndContractTitle(int customerId, java.lang.String contractTitle, boolean strictMode) throws BGException
BGExceptionpublic java.util.List<Pair<java.lang.Integer,Contract>> getLinkedContracts(java.lang.String contractTitle, boolean disableStrictMode) throws BGException
BGExceptionpublic java.util.List<Contract> getLinkedContracts(int customerId) throws BGException
getLinkedContracts in class CommonLinkDAOBGException