ru.bgcrm.dao.process

Class ProcessTypeDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.dao.process.ProcessTypeDAO

public class ProcessTypeDAO
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
ProcessTypeDAO(java.sql.Connection con)

Method Summary

Methods

Modifier and Type	Method and Description
boolean	checkProcessTypeForDelete(int id) true если каталог пуст и можно удалять
boolean	checkType(int id, int parentId, java.lang.String title) true если можно добавить скрипт с таким именем в данный каталог
boolean	deleteProcessType(int id)
java.util.List<ProcessType>	getFullProcessTypeList()
ProcessType	getProcessType(int id)
java.util.Set<java.lang.Integer>	getProcessTypeParameterIds(int typeId)
java.util.List<Status>	getProcessTypeStatusList(ProcessType type)
java.util.List<Status>	getSortedProcessTypeStatusList(ProcessType type, java.util.List<java.lang.Integer> sortingId)
TypeTreeItem	getTypeTreeRoot()
void	searchProcessType(SearchResult<ProcessType> searchResult, int parentId, java.lang.Boolean archive)
void	updateProcessType(ProcessType processType, int user)
void	updateTypeProperties(ProcessType type)

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

ProcessTypeDAO

public ProcessTypeDAO(java.sql.Connection con)

Method Detail

searchProcessType

public void searchProcessType(SearchResult<ProcessType> searchResult,
                     int parentId,
                     java.lang.Boolean archive)
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

getProcessType

public ProcessType getProcessType(int id)
                           throws java.sql.SQLException

Throws:

java.sql.SQLException

getFullProcessTypeList

public java.util.List<ProcessType> getFullProcessTypeList()
                                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

getProcessTypeParameterIds

public java.util.Set<java.lang.Integer> getProcessTypeParameterIds(int typeId)
                                                            throws BGException

Throws:

BGException

getSortedProcessTypeStatusList

public java.util.List<Status> getSortedProcessTypeStatusList(ProcessType type,
                                                    java.util.List<java.lang.Integer> sortingId)
                                                      throws java.sql.SQLException

Throws:

java.sql.SQLException

getProcessTypeStatusList

public java.util.List<Status> getProcessTypeStatusList(ProcessType type)
                                                throws java.sql.SQLException

Throws:

java.sql.SQLException

updateProcessType

public void updateProcessType(ProcessType processType,
                     int user)
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

updateTypeProperties

public void updateTypeProperties(ProcessType type)
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

checkProcessTypeForDelete

public boolean checkProcessTypeForDelete(int id)
                                  throws java.sql.SQLException

true если каталог пуст и можно удалять

Parameters:

id -

Throws:

java.sql.SQLException

deleteProcessType

public boolean deleteProcessType(int id)
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

getTypeTreeRoot

public TypeTreeItem getTypeTreeRoot()
                             throws java.sql.SQLException

Throws:

java.sql.SQLException

checkType

public boolean checkType(int id,
                int parentId,
                java.lang.String title)
                  throws java.sql.SQLException

true если можно добавить скрипт с таким именем в данный каталог

Parameters:

parentId -

name -

Returns:

Throws:

java.sql.SQLException