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 and Description
SimDAO(java.sql.Connection con)

Method Summary

Modifier and Type	Method and Description
void	addSimCard(java.util.List<SimCard> list)
static java.util.List<SimCardCategory>	getCategoryList()
SimCard	getSimCard(int id)
static SimCard	getSimCardFromRs(java.sql.ResultSet rs)
static SimCard	getSimCardFromRs(java.sql.ResultSet rs, boolean loadTitles)
java.util.List<SimCard>	getSimCardList(java.util.List<java.lang.Integer> ids)
static java.util.List<SimCardStatus>	getStatusList()
void	searchSIMCard(SearchResult<SimCard> searchResult, DynActionForm form)
java.util.List<SimCard>	searchSimCard(java.util.Set<java.lang.Integer> categoryIdSet, java.util.Set<java.lang.Integer> statusIdSet)
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

deleteById, execute, execute, execute, 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 Detail

SimDAO

public SimDAO(java.sql.Connection con)

Method Detail

searchSIMCard

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

Throws:

BGException

getSimCardList

public java.util.List<SimCard> getSimCardList(java.util.List<java.lang.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 java.sql.SQLException

Throws:

java.sql.SQLException

updateSimStatus

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

Throws:

java.sql.SQLException

updateSimCategory

public void updateSimCategory(int id,
                              int categoryId)
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

searchSimCard

public java.util.List<SimCard> searchSimCard(java.util.Set<java.lang.Integer> categoryIdSet,
                                             java.util.Set<java.lang.Integer> statusIdSet)
                                      throws java.sql.SQLException

Throws:

java.sql.SQLException

getSimCardFromRs

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

Throws:

java.sql.SQLException

getSimCardFromRs

public static SimCard getSimCardFromRs(java.sql.ResultSet rs)
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

getStatusList

public static java.util.List<SimCardStatus> getStatusList()
                                                   throws BGException

Throws:

BGException

getCategoryList

public static java.util.List<SimCardCategory> getCategoryList()
                                                       throws BGException

Throws:

BGException

addSimCard

public void addSimCard(java.util.List<SimCard> list)
                throws java.sql.SQLException

Throws:

java.sql.SQLException