ru.bgcrm.dao

Class ParamDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.dao.ParamDAO

public class ParamDAO
extends CommonDAO

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.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_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
ParamDAO(java.sql.Connection connection)
ParamDAO(java.sql.Connection con, int userId)

Method Summary

Methods

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

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

Field Detail

DIRECTORY_TYPE_PARAMETER

public static final java.lang.String DIRECTORY_TYPE_PARAMETER

See Also:

Constant Field Values

Constructor Detail

ParamDAO

public ParamDAO(java.sql.Connection connection)

ParamDAO

public ParamDAO(java.sql.Connection con,
        int userId)

Method Detail

getParameter

public Parameter getParameter(int id)
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

getTreeParamValuesMap

public java.util.Map<java.lang.Integer,IdTitleTree> getTreeParamValuesMap()
                                                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

updateParameter

public void updateParameter(Parameter parameter)
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

deleteParameter

public void deleteParameter(int id)
                     throws BGException

Throws:

BGException

getParameterMapByObjectType

public java.util.Map<java.lang.String,java.util.List<Parameter>> getParameterMapByObjectType()
                                                                                      throws java.sql.SQLException

Throws:

java.sql.SQLException

getParameterIdsByGroupIds

public java.util.Map<java.lang.Integer,java.util.Set<java.lang.Integer>> getParameterIdsByGroupIds()
                                                                                            throws java.sql.SQLException

Throws:

java.sql.SQLException

getListCountParamValuesMap

public java.util.Map<java.lang.Integer,java.util.Map<java.lang.Integer,java.lang.String>> getListCountParamValuesMap()
                                                                                                              throws java.sql.SQLException

Throws:

java.sql.SQLException

getListParamValuesMap

public java.util.Map<java.lang.Integer,java.util.List<IdTitle>> getListParamValuesMap()
                                                                               throws java.sql.SQLException

Throws:

java.sql.SQLException

getParameterList

public java.util.List<Parameter> getParameterList(java.lang.String objectType,
                                         int paramGroupId)
                                           throws java.sql.SQLException

Throws:

java.sql.SQLException

getParameterList

public void getParameterList(SearchResult<Parameter> searchResult,
                    java.lang.String objectType,
                    java.lang.String titleOrCommentFilter,
                    int paramGroupId,
                    java.util.Set<java.lang.Integer> parameterIdList)
                      throws BGException

Throws:

BGException

getParameterList

public java.util.List<Parameter> getParameterList(java.lang.String objectType,
                                         int paramGroupId,
                                         java.util.Set<java.lang.Integer> parameterIdList)
                                           throws java.sql.SQLException

Throws:

java.sql.SQLException

getParameterHistory

public java.util.List<ParameterHistory> getParameterHistory(java.lang.String object,
                                                   Parameter parameter,
                                                   int id)
                                                     throws java.sql.SQLException

Throws:

java.sql.SQLException