Package ru.bgcrm.dao

Class ParamDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.dao.ParamDAO

public class ParamDAO
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	Description
static final String	DIRECTORY_TYPE_PARAMETER

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	Description
ParamDAO(Connection connection)
ParamDAO(Connection con, int userId)

Method Summary

Modifier and Type	Method	Description
void	deleteParameter(int id)
Map<Integer,List<IdTitle>>	getListParamValuesMap()
Parameter	getParameter(int id)
List<ParameterHistory>	getParameterHistory(String object, Parameter parameter, int id)
Map<Integer,Set<Integer>>	getParameterIdsByGroupIds()
List<Parameter>	getParameterList(String objectType, int paramGroupId)
List<Parameter>	getParameterList(String objectType, int paramGroupId, Set<Integer> parameterIdList)
void	getParameterList(SearchResult<Parameter> searchResult, String objectType, int parameterId, String filter, String parameterType, int paramGroupId, Set<Integer> parameterIdList)
void	getParameterList(SearchResult<Parameter> searchResult, String objectType, String filter, int paramGroupId, Set<Integer> parameterIdList)
Map<String,List<Parameter>>	getParameterMapByObjectType()
Map<Integer,IdTitleTree>	getTreeParamValuesMap()
void	updateParameter(Parameter parameter)

Methods inherited from class ru.bgcrm.dao.CommonDAO

buildPlaceholders, deleteById, execute, execute, execute, executeBatch, 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 Details

DIRECTORY_TYPE_PARAMETER

public static final String DIRECTORY_TYPE_PARAMETER

See Also:

• Constant Field Values

Constructor Details

ParamDAO

public ParamDAO(Connection connection)

ParamDAO

public ParamDAO(Connection con,
 int userId)

Method Details

getParameter

public Parameter getParameter(int id)
                       throws SQLException

Throws:

SQLException

getTreeParamValuesMap

public Map<Integer,IdTitleTree> getTreeParamValuesMap()
                                               throws SQLException

Throws:

SQLException

updateParameter

public void updateParameter(Parameter parameter)
                     throws SQLException

Throws:

SQLException

deleteParameter

public void deleteParameter(int id)
                     throws BGException

Throws:

BGException

getParameterMapByObjectType

public Map<String,List<Parameter>> getParameterMapByObjectType()
                                                        throws SQLException

Throws:

SQLException

getParameterIdsByGroupIds

public Map<Integer,Set<Integer>> getParameterIdsByGroupIds()
                                                    throws SQLException

Throws:

SQLException

getListParamValuesMap

public Map<Integer,List<IdTitle>> getListParamValuesMap()
                                                 throws SQLException

Throws:

SQLException

getParameterList

public List<Parameter> getParameterList(String objectType,
 int paramGroupId)
                                 throws SQLException

Throws:

SQLException

getParameterList

public void getParameterList(SearchResult<Parameter> searchResult,
 String objectType,
 String filter,
 int paramGroupId,
 Set<Integer> parameterIdList)
                      throws BGException

Throws:

BGException

getParameterList

public void getParameterList(SearchResult<Parameter> searchResult,
 String objectType,
 int parameterId,
 String filter,
 String parameterType,
 int paramGroupId,
 Set<Integer> parameterIdList)
                      throws BGException

Throws:

BGException

getParameterList

public List<Parameter> getParameterList(String objectType,
 int paramGroupId,
 Set<Integer> parameterIdList)
                                 throws SQLException

Throws:

SQLException

getParameterHistory

public List<ParameterHistory> getParameterHistory(String object,
 Parameter parameter,
 int id)
                                           throws SQLException

Throws:

SQLException