Class EngineerWarehouseDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

org.bgerp.plugin.inventory.sync1c.dao.EngineerWarehouseDAO

public class EngineerWarehouseDAO
extends CommonDAO

DAO for EngineerWarehouse (inventory_sync1c_engineer_warehouse table).

Nested Class Summary

Nested classes/interfaces inherited from class CommonDAO

CommonDAO.ObjectExtractor<T>, CommonDAO.RecordUpdater<T>

Field Summary

Fields inherited from class 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

Constructor	Description
EngineerWarehouseDAO(Connection con)

Method Summary

Modifier and Type	Method	Description
void	create(EngineerWarehouse ew)
void	delete(int id)
static EngineerWarehouse	fromRs(ResultSet rs)
EngineerWarehouse	get(int id)
EngineerWarehouse	getByStoreId(int storeId)
List<EngineerWarehouse>	getListByInstance(int instanceId)
List<EngineerWarehouse>	getListByUser(int userId)
void	updateStoreId(int ewId, int storeId)

Methods inherited from class CommonDAO

deleteById, foundRows, getById, getGroupedIds, getGroupedIds, getIds, getIds, getPageLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, update, updateColumn, updateIds, updateIds, updateOrInsert

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

EngineerWarehouseDAO

public EngineerWarehouseDAO(Connection con)

Method Details

getListByInstance

public List<EngineerWarehouse> getListByInstance(int instanceId)
                                          throws SQLException

Throws:

SQLException

getListByUser

public List<EngineerWarehouse> getListByUser(int userId)
                                      throws SQLException

Throws:

SQLException

getByStoreId

public EngineerWarehouse getByStoreId(int storeId)
                               throws SQLException

Throws:

SQLException

get

public EngineerWarehouse get(int id)
                      throws SQLException

Throws:

SQLException

create

public void create(EngineerWarehouse ew)
            throws SQLException

Throws:

SQLException

updateStoreId

public void updateStoreId(int ewId,
 int storeId)
                   throws SQLException

Throws:

SQLException

delete

public void delete(int id)
            throws SQLException

Throws:

SQLException

fromRs

public static EngineerWarehouse fromRs(ResultSet rs)
                                throws SQLException

Throws:

SQLException