ru.bgcrm.dao

Class WorkTypeDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.dao.WorkTypeDAO

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

Method Summary

Methods

Modifier and Type	Method and Description
void	copyWorkDaysCalendar(int calendarId, int from, int to)
void	deleteWorkType(int id)
java.util.Set<WorkDaysCalendarExclude>	getWorkDaysCalendarExcludeSet(int calendarId)
WorkType	getWorkType(int id)
java.util.List<WorkType>	getWorkTypeList()
java.util.List<WorkType>	getWorkTypeList(java.util.Set<?> workTypeIds)
java.util.Map<java.lang.Integer,WorkType>	getWorkTypeMap()
void	searchWorkType(SearchResult<WorkType> searchResult, int category)
void	updateWorkDaysCalendar(int calendarId, int type, java.util.Date date)
void	updateWorkType(WorkType workType)

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

WorkTypeDAO

public WorkTypeDAO(java.sql.Connection con)

Method Detail

searchWorkType

public void searchWorkType(SearchResult<WorkType> searchResult,
                  int category)
                    throws BGException

Throws:

BGException

getWorkTypeList

public java.util.List<WorkType> getWorkTypeList()
                                         throws BGException

Throws:

BGException

getWorkTypeList

public java.util.List<WorkType> getWorkTypeList(java.util.Set<?> workTypeIds)
                                         throws BGException

Throws:

BGException

getWorkTypeMap

public java.util.Map<java.lang.Integer,WorkType> getWorkTypeMap()
                                                         throws BGException

Throws:

BGException

updateWorkType

public void updateWorkType(WorkType workType)
                    throws BGException

Throws:

BGException

getWorkType

public WorkType getWorkType(int id)
                     throws BGException

Throws:

BGException

deleteWorkType

public void deleteWorkType(int id)
                    throws BGException

Throws:

BGException

updateWorkDaysCalendar

public void updateWorkDaysCalendar(int calendarId,
                          int type,
                          java.util.Date date)
                            throws BGException

Throws:

BGException

copyWorkDaysCalendar

public void copyWorkDaysCalendar(int calendarId,
                        int from,
                        int to)
                          throws BGException

Throws:

BGException

getWorkDaysCalendarExcludeSet

public java.util.Set<WorkDaysCalendarExclude> getWorkDaysCalendarExcludeSet(int calendarId)
                                                                     throws BGException

Throws:

BGException