Package org.bgerp.plugin.inventory.dao
Class DeviceDAO
java.lang.Object
ru.bgcrm.dao.CommonDAO
org.bgerp.plugin.inventory.dao.DeviceDAO
DAO for
Device.
Soft delete via deleted_at / deleted_by.-
Nested Class Summary
Nested classes/interfaces inherited from class ru.bgcrm.dao.CommonDAO
CommonDAO.ObjectExtractor<T>, CommonDAO.RecordUpdater<T extends Id> -
Field Summary
Fields inherited from class ru.bgcrm.dao.CommonDAO
con, log, SQL_AND, SQL_DELETE, SQL_DELETE_FROM, SQL_DESC, SQL_DISTINCT, SQL_FROM, SQL_GROUP_BY, SQL_INNER_JOIN, SQL_INSERT_IGNORE_INTO, SQL_INSERT_INTO, SQL_LEFT_JOIN, SQL_LIMIT, SQL_ON_DUP_KEY_UPDATE, SQL_ORDER_BY, SQL_REPLACE, SQL_SELECT, SQL_SELECT_ALL_FROM, SQL_SELECT_COUNT_ROWS, SQL_SET, SQL_UNION_ALL, SQL_UPDATE, SQL_VALUES, SQL_VALUES_1, SQL_VALUES_2, SQL_VALUES_3, SQL_VALUES_4, SQL_VALUES_5, SQL_WHERE -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionvoiddelete(int id, int userId) Soft-delete.static Deviceget(int id) getList(boolean includeDeleted) getListByParent(int parentDeviceId) getListByStatus(String status) voidrestore(int id) Restore soft-deleted device.voidInserts or updates a device.Methods inherited from class ru.bgcrm.dao.CommonDAO
deleteById, foundRows, getById, getGroupedIds, getGroupedIds, getIds, getIds, getPageLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, update, updateColumn, updateIds, updateIds, updateOrInsert
-
Constructor Details
-
DeviceDAO
-
-
Method Details
-
getList
- Throws:
SQLException
-
getListByStatus
- Throws:
SQLException
-
getListByParent
- Throws:
SQLException
-
get
- Throws:
SQLException
-
update
Inserts or updates a device. Setsidon the object when inserting.- Throws:
SQLException
-
delete
Soft-delete.- Throws:
SQLException
-
restore
Restore soft-deleted device.- Throws:
SQLException
-
fromRs
- Throws:
SQLException
-