public class FulfillmentJDBCHelperBean extends BaseJDBCHelper implements javax.ejb.SessionBean
Modifier and Type | Field and Description |
---|---|
static java.lang.String | findCalcodeDescriptionLongDescriptionSQL
sql String
|
static java.lang.String | findFFMAndOrderItemsList
sql String
|
static java.lang.String | findFfmcenterByFfmcenterIdAndLanguageId
sql String
|
static java.lang.String | findFfmcenterIdAndDisplayName
sql String
|
static java.lang.String | findFfmcenterListByLanguageId
sql String
|
static java.lang.String | findFfmcenterListByLanguageIdAndStoreId
sql String
|
static java.lang.String | findFfmcenterNameAndIdByStoreId
sql String
|
static java.lang.String | findFulfillmentCenterDescriptionDescriptionSQL
sql String
|
static java.lang.String | findFulfillmentDescriptionByFulfillmentCenterId
sql String
|
static java.lang.String | findShipModeListByStoreentId
sql String
|
static java.lang.String | findShipModeListByStoreentIdAndLanguageId
sql String
|
static java.lang.String | findShipModeListByStoreentIdAndLanguageId_DB2J
sql String
|
static java.lang.String | findStaddress
sql String
|
static java.lang.String | updateCalcodeDescriptionLongDescriptionSQL
sql String
|
static java.lang.String | updateFulfillmentCenterDescriptionDescriptionSQL
sql String
|
Constructor and Description |
---|
FulfillmentJDBCHelperBean() |
Modifier and Type | Method and Description |
---|---|
int | checkFulfillmentCenterByMemberIdAndFulfillmentCenterId(java.lang.Long memberId, java.lang.Integer ffmcId) |
int | checkFulfillmentCenterByMemberIdAndFulfillmentCenterId(java.lang.Long memberId, java.lang.Integer ffmcId, boolean flush) |
static java.util.Vector | convertResultSetToTableForAvailableReceiptMaxAndMinPrecedence(java.sql.ResultSet rs) |
static java.util.Vector | convertResultSetToTableForFFMAndOrderItems(java.sql.ResultSet rs) |
static java.util.Vector | convertResultSetToTableForFfmcenterByFfmcenterIdAndLanguageId(java.sql.ResultSet rs) |
static java.util.Vector | convertResultSetToTableForFfmcenterIdAndDisplayName(java.sql.ResultSet rs) |
static java.util.Vector | convertResultSetToTableForFfmcenterListByLanguageId(java.sql.ResultSet rs) |
static java.util.Vector | convertResultSetToTableForFfmcenterListByLanguageIdAndStoreId(java.sql.ResultSet rs) |
static java.util.Vector | convertResultSetToTableForFfmcenterNameAndIdByStoreId(java.sql.ResultSet rs) |
static java.util.Vector | convertResultSetToTableForFulfillmentDescriptionByFulfillmentCenterId(java.sql.ResultSet rs) |
static java.util.Vector | convertResultSetToTableForShipModeListByStoreentId(java.sql.ResultSet rs) |
static java.util.Vector | convertResultSetToTableForShipModeListByStoreentIdAndLanguageId(java.sql.ResultSet rs) |
static java.util.Vector | convertResultSetToTableForStaddress(java.sql.ResultSet rs) |
void | ejbActivate()
ejbActivate method comment
|
void | ejbCreate()
ejbCreate method comment
|
void | ejbPassivate()
ejbPassivate method comment
|
void | ejbRemove()
ejbRemove method comment
|
java.lang.String | findCalcodeDescriptionLongDescription(java.lang.Integer aCalcodeId, java.lang.Integer aLanguageId) |
java.lang.String | findCalcodeDescriptionLongDescription(java.lang.Integer aCalcodeId, java.lang.Integer aLanguageId, boolean flush) |
java.util.Vector | findFFMAndOrderItemsList(java.lang.Integer languageId, java.lang.Integer storeId) |
java.util.Vector | findFFMAndOrderItemsList(java.lang.Integer languageId, java.lang.Integer storeId, boolean flush) |
java.util.Vector | findFfmcenterByFfmcenterIdAndLanguageId(java.lang.Integer ffmCenterId, java.lang.Integer languageId) |
java.util.Vector | findFfmcenterByFfmcenterIdAndLanguageId(java.lang.Integer ffmCenterId, java.lang.Integer languageId, boolean flush) |
java.util.Vector | findFfmcenterIdAndDisplayName(java.lang.Integer storeId) |
java.util.Vector | findFfmcenterIdAndDisplayName(java.lang.Integer storeId, boolean flush) |
java.util.Vector | findFfmcenterListByLanguageId(java.lang.Integer languageId, java.lang.Integer storeId) |
java.util.Vector | findFfmcenterListByLanguageId(java.lang.Integer languageId, java.lang.Integer storeId, boolean flush) |
java.util.Vector | findFfmcenterListByLanguageIdAndStoreId(java.lang.Integer languageId, java.lang.Integer storeId) |
java.util.Vector | findFfmcenterListByLanguageIdAndStoreId(java.lang.Integer languageId, java.lang.Integer storeId, boolean flush) |
java.util.Vector | findFfmcenterNameAndIdByStoreId(java.lang.Integer storeId) |
java.util.Vector | findFfmcenterNameAndIdByStoreId(java.lang.Integer storeId, boolean flush) |
java.util.Vector | findFfmcenterNameAndIdByStoreId(java.lang.Integer storeId, java.lang.String dropShip)
Overloaded finder for dropship flag Creation date: (4/28/04 )
|
java.lang.String | findFulfillmentCenterDescriptionDescription(java.lang.Integer aFulfillmentCenterId, java.lang.Integer aLanguageId) |
java.lang.String | findFulfillmentCenterDescriptionDescription(java.lang.Integer aFulfillmentCenterId, java.lang.Integer aLanguageId, boolean flush) |
java.util.Vector | findFulfillmentDescriptionByFulfillmentCenterId(java.lang.Integer ffmCenterId) |
java.util.Vector | findFulfillmentDescriptionByFulfillmentCenterId(java.lang.Integer ffmCneterId, boolean flush) |
java.util.Vector | findShipModeListByStoreentId(java.lang.Integer storeentId) |
java.util.Vector | findShipModeListByStoreentId(java.lang.Integer storeentId, boolean flush) |
java.util.Vector | findShipModeListByStoreentIdAndLanguageId(java.lang.Integer storeentId, java.lang.Integer languageId) |
java.util.Vector | findShipModeListByStoreentIdAndLanguageId(java.lang.Integer storeentId, java.lang.Integer languageId, boolean flush) |
java.util.Vector | findStaddress(java.lang.Integer ffmCenterId, java.lang.Integer languageId) |
java.util.Vector | findStaddress(java.lang.Integer ffmCneterId, java.lang.Integer languageId, boolean flush) |
javax.ejb.SessionContext | getSessionContext()
getSessionContext method comment
|
void | setSessionContext(javax.ejb.SessionContext ctx)
setSessionContext method comment
|
int | updateCalcodeDescriptionLongDescription(java.lang.Integer aCalcodeId, java.lang.Integer aLanguageId, java.lang.String aLongDescription) |
int | updateCalcodeDescriptionLongDescription(java.lang.Integer aCalcodeId, java.lang.Integer aLanguageId, java.lang.String aLongDescription, boolean flush) |
int | updateFulfillmentCenterDescriptionDescription(java.lang.Integer aFulfillmentCenterId, java.lang.Integer aLanguageId, java.lang.String aDescription) |
int | updateFulfillmentCenterDescriptionDescription(java.lang.Integer aFulfillmentCenterId, java.lang.Integer aLanguageId, java.lang.String aDescription, boolean flush) |
public static final java.lang.String findFFMAndOrderItemsList
public static final java.lang.String findFfmcenterIdAndDisplayName
public static final java.lang.String findShipModeListByStoreentIdAndLanguageId
public static final java.lang.String findShipModeListByStoreentIdAndLanguageId_DB2J
public static final java.lang.String findFfmcenterNameAndIdByStoreId
public static final java.lang.String findFfmcenterListByLanguageId
public static final java.lang.String findFfmcenterListByLanguageIdAndStoreId
public static final java.lang.String findFfmcenterByFfmcenterIdAndLanguageId
public static final java.lang.String findStaddress
public static final java.lang.String findShipModeListByStoreentId
public static final java.lang.String findFulfillmentDescriptionByFulfillmentCenterId
public static final java.lang.String findCalcodeDescriptionLongDescriptionSQL
public static final java.lang.String updateCalcodeDescriptionLongDescriptionSQL
public static final java.lang.String findFulfillmentCenterDescriptionDescriptionSQL
public static final java.lang.String updateFulfillmentCenterDescriptionDescriptionSQL
public static java.util.Vector convertResultSetToTableForAvailableReceiptMaxAndMinPrecedence(java.sql.ResultSet rs) throws java.sql.SQLException
public static java.util.Vector convertResultSetToTableForFFMAndOrderItems(java.sql.ResultSet rs) throws java.sql.SQLException
public static java.util.Vector convertResultSetToTableForFfmcenterByFfmcenterIdAndLanguageId(java.sql.ResultSet rs) throws java.sql.SQLException
public static java.util.Vector convertResultSetToTableForFfmcenterIdAndDisplayName(java.sql.ResultSet rs) throws java.sql.SQLException
public static java.util.Vector convertResultSetToTableForFfmcenterListByLanguageId(java.sql.ResultSet rs) throws java.sql.SQLException
public static java.util.Vector convertResultSetToTableForFfmcenterListByLanguageIdAndStoreId(java.sql.ResultSet rs) throws java.sql.SQLException
public static java.util.Vector convertResultSetToTableForFfmcenterNameAndIdByStoreId(java.sql.ResultSet rs) throws java.sql.SQLException
public static java.util.Vector convertResultSetToTableForFulfillmentDescriptionByFulfillmentCenterId(java.sql.ResultSet rs) throws java.sql.SQLException
public static java.util.Vector convertResultSetToTableForShipModeListByStoreentId(java.sql.ResultSet rs) throws java.sql.SQLException
public static java.util.Vector convertResultSetToTableForShipModeListByStoreentIdAndLanguageId(java.sql.ResultSet rs) throws java.sql.SQLException
public static java.util.Vector convertResultSetToTableForStaddress(java.sql.ResultSet rs) throws java.sql.SQLException
public void ejbActivate()
public void ejbCreate() throws javax.ejb.CreateException
public void ejbPassivate()
public void ejbRemove()
public java.util.Vector findFFMAndOrderItemsList(java.lang.Integer languageId, java.lang.Integer storeId) throws javax.naming.NamingException, java.sql.SQLException
public java.util.Vector findFFMAndOrderItemsList(java.lang.Integer languageId, java.lang.Integer storeId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
public java.util.Vector findFfmcenterByFfmcenterIdAndLanguageId(java.lang.Integer ffmCenterId, java.lang.Integer languageId) throws javax.naming.NamingException, java.sql.SQLException
public java.util.Vector findFfmcenterByFfmcenterIdAndLanguageId(java.lang.Integer ffmCenterId, java.lang.Integer languageId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
public java.util.Vector findFfmcenterIdAndDisplayName(java.lang.Integer storeId) throws javax.naming.NamingException, java.sql.SQLException
public java.util.Vector findFfmcenterIdAndDisplayName(java.lang.Integer storeId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
public java.util.Vector findFfmcenterListByLanguageId(java.lang.Integer languageId, java.lang.Integer storeId) throws javax.naming.NamingException, java.sql.SQLException
public java.util.Vector findFfmcenterListByLanguageId(java.lang.Integer languageId, java.lang.Integer storeId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
public java.util.Vector findFfmcenterListByLanguageIdAndStoreId(java.lang.Integer languageId, java.lang.Integer storeId) throws javax.naming.NamingException, java.sql.SQLException
public java.util.Vector findFfmcenterListByLanguageIdAndStoreId(java.lang.Integer languageId, java.lang.Integer storeId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
public java.util.Vector findFfmcenterNameAndIdByStoreId(java.lang.Integer storeId, java.lang.String dropShip) throws javax.naming.NamingException, java.sql.SQLException
public java.util.Vector findFfmcenterNameAndIdByStoreId(java.lang.Integer storeId) throws javax.naming.NamingException, java.sql.SQLException
public java.util.Vector findFfmcenterNameAndIdByStoreId(java.lang.Integer storeId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
public java.util.Vector findFulfillmentDescriptionByFulfillmentCenterId(java.lang.Integer ffmCenterId) throws javax.naming.NamingException, java.sql.SQLException
public java.util.Vector findFulfillmentDescriptionByFulfillmentCenterId(java.lang.Integer ffmCneterId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
public java.util.Vector findShipModeListByStoreentId(java.lang.Integer storeentId) throws javax.naming.NamingException, java.sql.SQLException
public java.util.Vector findShipModeListByStoreentId(java.lang.Integer storeentId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
public java.util.Vector findShipModeListByStoreentIdAndLanguageId(java.lang.Integer storeentId, java.lang.Integer languageId) throws javax.naming.NamingException, java.sql.SQLException
public java.util.Vector findShipModeListByStoreentIdAndLanguageId(java.lang.Integer storeentId, java.lang.Integer languageId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
public java.util.Vector findStaddress(java.lang.Integer ffmCenterId, java.lang.Integer languageId) throws javax.naming.NamingException, java.sql.SQLException
public java.util.Vector findStaddress(java.lang.Integer ffmCneterId, java.lang.Integer languageId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
public int checkFulfillmentCenterByMemberIdAndFulfillmentCenterId(java.lang.Long memberId, java.lang.Integer ffmcId) throws javax.naming.NamingException, java.sql.SQLException
public int checkFulfillmentCenterByMemberIdAndFulfillmentCenterId(java.lang.Long memberId, java.lang.Integer ffmcId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
public javax.ejb.SessionContext getSessionContext()
public void setSessionContext(javax.ejb.SessionContext ctx)
public java.lang.String findCalcodeDescriptionLongDescription(java.lang.Integer aCalcodeId, java.lang.Integer aLanguageId) throws javax.naming.NamingException, java.sql.SQLException
public java.lang.String findCalcodeDescriptionLongDescription(java.lang.Integer aCalcodeId, java.lang.Integer aLanguageId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
public java.lang.String findFulfillmentCenterDescriptionDescription(java.lang.Integer aFulfillmentCenterId, java.lang.Integer aLanguageId) throws javax.naming.NamingException, java.sql.SQLException
public java.lang.String findFulfillmentCenterDescriptionDescription(java.lang.Integer aFulfillmentCenterId, java.lang.Integer aLanguageId, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
public int updateCalcodeDescriptionLongDescription(java.lang.Integer aCalcodeId, java.lang.Integer aLanguageId, java.lang.String aLongDescription) throws javax.naming.NamingException, java.sql.SQLException
public int updateCalcodeDescriptionLongDescription(java.lang.Integer aCalcodeId, java.lang.Integer aLanguageId, java.lang.String aLongDescription, boolean flush) throws javax.naming.NamingException, java.sql.SQLException
public int updateFulfillmentCenterDescriptionDescription(java.lang.Integer aFulfillmentCenterId, java.lang.Integer aLanguageId, java.lang.String aDescription) throws javax.naming.NamingException, java.sql.SQLException
public int updateFulfillmentCenterDescriptionDescription(java.lang.Integer aFulfillmentCenterId, java.lang.Integer aLanguageId, java.lang.String aDescription, boolean flush) throws javax.naming.NamingException, java.sql.SQLException