Package ru.bgcrm.plugin.ufanet.dao

Class SimDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.plugin.ufanet.dao.SimDAO

public class SimDAO
extends CommonDAO

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, dateFormat_DDMMYYYY, dateFormat_DDMMYYYY_HHMM, log, SQL_AND, SQL_DELETE, SQL_DESC, SQL_FROM, SQL_GROUP_BY, SQL_INNER_JOIN, SQL_INSERT, SQL_INSERT_IGNORE, SQL_LEFT_JOIN, SQL_LEFT_OUTER_JOIN, SQL_LIMIT, SQL_ON_DUP_KEY_UPDATE, SQL_OR, 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	Description
SimDAO(Connection con)

Method Summary

Modifier and Type	Method	Description
void	addSimCard(List<SimCard> list)
static List<SimCardCategory>	getCategoryList()
SimCard	getSimCard(int id)
static SimCard	getSimCardFromRs(ResultSet rs)
static SimCard	getSimCardFromRs(ResultSet rs, boolean loadTitles)
List<SimCard>	getSimCardList(List<Integer> ids)
static List<SimCardStatus>	getStatusList()
List<SimCard>	searchSimCard(Set<Integer> categoryIdSet, Set<Integer> statusIdSet)
void	searchSIMCard(SearchResult<SimCard> searchResult, DynActionForm form)
void	updateSimCategory(int id, int categoryId)
void	updateSimStatus(int id, int statusId, int uid)
void	updateSimStatus(int id, int statusId, int customerId, int uid)

Methods inherited from class ru.bgcrm.dao.CommonDAO

buildPlaceholders, deleteById, execute, execute, execute, executeBatch, executeInsert, executeUpdate, getById, getFoundRows, getFoundRows, getGroupedIds, getGroupedIds, getIds, getIds, getLikePattern, getLikePatternEnd, getLikePatternStart, getLikePatternSub, getMySQLLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, sqlToBgException, update, updateColumn, updateIds, updateIds

Methods inherited from class java.lang.Object

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

Constructor Details

SimDAO

public SimDAO(Connection con)

Method Details

searchSIMCard

public void searchSIMCard(SearchResult<SimCard> searchResult,
 DynActionForm form)
                   throws BGException

Throws:

BGException

getSimCardList

public List<SimCard> getSimCardList(List<Integer> ids)
                             throws BGException

Throws:

BGException

getSimCard

public SimCard getSimCard(int id)
                   throws BGException

Throws:

BGException

updateSimStatus

public void updateSimStatus(int id,
 int statusId,
 int customerId,
 int uid)
                     throws SQLException

Throws:

SQLException

updateSimStatus

public void updateSimStatus(int id,
 int statusId,
 int uid)
                     throws SQLException

Throws:

SQLException

updateSimCategory

public void updateSimCategory(int id,
 int categoryId)
                       throws SQLException

Throws:

SQLException

searchSimCard

public List<SimCard> searchSimCard(Set<Integer> categoryIdSet,
 Set<Integer> statusIdSet)
                            throws SQLException

Throws:

SQLException

getSimCardFromRs

public static SimCard getSimCardFromRs(ResultSet rs,
 boolean loadTitles)
                                throws SQLException

Throws:

SQLException

getSimCardFromRs

public static SimCard getSimCardFromRs(ResultSet rs)
                                throws SQLException

Throws:

SQLException

getStatusList

public static List<SimCardStatus> getStatusList()
                                         throws BGException

Throws:

BGException

getCategoryList

public static List<SimCardCategory> getCategoryList()
                                             throws BGException

Throws:

BGException

addSimCard

public void addSimCard(List<SimCard> list)
                throws SQLException

Throws:

SQLException