com.retek.component.customerorder.impl.persistence.db.oracle
Class OracleBaseCustomerOrderFinder

java.lang.Object
  extended bycom.retek.commons.domain.core.persistence.db.DbOperation
      extended bycom.retek.component.customerorder.impl.persistence.db.oracle.OracleBaseCustomerOrderFinder
Direct Known Subclasses:
OracleCustomerOrderFinder, OracleCustomerOrderReferenceFinder, OracleCustomerOrderTransactionCountReader

public abstract class OracleBaseCustomerOrderFinder
extends DbOperation


Field Summary
protected  OrderSearchCriteria criteria
           
protected  RDate expirationCompareDate
           
protected  java.util.Set sellingSkuRefs
           
protected  java.util.Map tenderTypeAuthPeriods
           
 
Fields inherited from class com.retek.commons.domain.core.persistence.db.DbOperation
DUMMY_VERSION_UNTIL_VERSION_COLUMN_ADDED
 
Constructor Summary
protected OracleBaseCustomerOrderFinder(java.sql.Connection connectionVal)
           
protected OracleBaseCustomerOrderFinder(DbOperation parentOperation)
           
 
Method Summary
protected  void addActivePendReasonFilter(java.lang.StringBuffer sql)
           
protected  void addBannerFilter(java.lang.StringBuffer sql, java.util.List bindVariableList)
           
protected  void addCancelByFilter(java.lang.StringBuffer sql, java.util.List bindVariableList)
           
protected  void addCriteriaFilters(java.lang.StringBuffer theSql, java.util.List bindVariableList)
           
protected  void addCustomerFilter(java.lang.StringBuffer sql, java.util.List bindVariableList)
           
protected  void addCustomerOrderNumberFilter(java.lang.StringBuffer sql, java.util.List bindVariableList)
           
protected  void addDirectShipOrderIdFilter(java.lang.StringBuffer sql, java.util.List bindVariableList)
           
protected  void addHasOrderLineDirectShipOrdersFilter(java.lang.StringBuffer sql)
           
protected  void addIsOrderLineDirectShipFilter(java.lang.StringBuffer sql)
           
protected  void addMailOrderBatchRefFilter(java.lang.StringBuffer sql, java.util.List bindVariableList)
           
protected  void addOrderLineBackOrderedQuantityIsPositiveFilter(java.lang.StringBuffer sql)
           
protected  void addOrderLineEstimatedShipDateLessThanOrEqualToDate(java.lang.StringBuffer sql, java.util.List bindVariableList)
           
protected  void addOrderLineReleaseDateLessThanOrEqualToDate(java.lang.StringBuffer sql, java.util.List bindVariableList)
           
protected  void addOrderLineReservedQuantityIsPositiveFilter(java.lang.StringBuffer sql)
           
protected  void addOrderLineStateFilter(java.lang.StringBuffer sql, java.util.List bindVariableList)
           
protected  void addOrderStatusFilter(java.lang.StringBuffer sql, java.util.List bindVariableList)
           
protected  void addOrderTypeFilter(java.lang.StringBuffer sql, java.util.List bindVariableList)
           
protected  void addPaymentFilters(java.lang.StringBuffer sql, java.util.List bindVariableList)
           
protected  void addPendReasonFilter(java.lang.StringBuffer sql, java.util.List bindVariableList)
           
protected  void addReleaseDateFilter(java.lang.StringBuffer sql, java.util.List bindVariableList)
           
protected  void addRmaNumberFilter(java.lang.StringBuffer sql, java.util.List bindVariableList)
           
protected  void addSellingSkuFilter(java.lang.StringBuffer sql, java.util.List bindVariableList)
           
protected  void addSettlementIsProcessedFilter(java.lang.StringBuffer sql, java.util.List bindVariableList)
           
protected  void addSupplierFilter(java.lang.StringBuffer sql, java.util.List bindVariableList)
           
protected  boolean idsAreNotAlpha()
           
protected  boolean isNumeric(java.lang.String s)
           
 
Methods inherited from class com.retek.commons.domain.core.persistence.db.DbOperation
checkUpdate, close, doPerform, getCallableStatement, getConnection, getRetekPreparedStatement, getStatement, perform, setInitialState
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

criteria

protected OrderSearchCriteria criteria

sellingSkuRefs

protected java.util.Set sellingSkuRefs

expirationCompareDate

protected RDate expirationCompareDate

tenderTypeAuthPeriods

protected java.util.Map tenderTypeAuthPeriods
Constructor Detail

OracleBaseCustomerOrderFinder

protected OracleBaseCustomerOrderFinder(java.sql.Connection connectionVal)

OracleBaseCustomerOrderFinder

protected OracleBaseCustomerOrderFinder(DbOperation parentOperation)
Method Detail

addBannerFilter

protected void addBannerFilter(java.lang.StringBuffer sql,
                               java.util.List bindVariableList)

addCustomerFilter

protected void addCustomerFilter(java.lang.StringBuffer sql,
                                 java.util.List bindVariableList)

addCustomerOrderNumberFilter

protected void addCustomerOrderNumberFilter(java.lang.StringBuffer sql,
                                            java.util.List bindVariableList)

addCancelByFilter

protected void addCancelByFilter(java.lang.StringBuffer sql,
                                 java.util.List bindVariableList)

addReleaseDateFilter

protected void addReleaseDateFilter(java.lang.StringBuffer sql,
                                    java.util.List bindVariableList)

addOrderLineEstimatedShipDateLessThanOrEqualToDate

protected void addOrderLineEstimatedShipDateLessThanOrEqualToDate(java.lang.StringBuffer sql,
                                                                  java.util.List bindVariableList)

addOrderLineReleaseDateLessThanOrEqualToDate

protected void addOrderLineReleaseDateLessThanOrEqualToDate(java.lang.StringBuffer sql,
                                                            java.util.List bindVariableList)

addSupplierFilter

protected void addSupplierFilter(java.lang.StringBuffer sql,
                                 java.util.List bindVariableList)

addSellingSkuFilter

protected void addSellingSkuFilter(java.lang.StringBuffer sql,
                                   java.util.List bindVariableList)

addOrderLineStateFilter

protected void addOrderLineStateFilter(java.lang.StringBuffer sql,
                                       java.util.List bindVariableList)

addHasOrderLineDirectShipOrdersFilter

protected void addHasOrderLineDirectShipOrdersFilter(java.lang.StringBuffer sql)

addDirectShipOrderIdFilter

protected void addDirectShipOrderIdFilter(java.lang.StringBuffer sql,
                                          java.util.List bindVariableList)

addIsOrderLineDirectShipFilter

protected void addIsOrderLineDirectShipFilter(java.lang.StringBuffer sql)

addOrderLineReservedQuantityIsPositiveFilter

protected void addOrderLineReservedQuantityIsPositiveFilter(java.lang.StringBuffer sql)

addOrderLineBackOrderedQuantityIsPositiveFilter

protected void addOrderLineBackOrderedQuantityIsPositiveFilter(java.lang.StringBuffer sql)

addOrderStatusFilter

protected void addOrderStatusFilter(java.lang.StringBuffer sql,
                                    java.util.List bindVariableList)

addOrderTypeFilter

protected void addOrderTypeFilter(java.lang.StringBuffer sql,
                                  java.util.List bindVariableList)

addPaymentFilters

protected void addPaymentFilters(java.lang.StringBuffer sql,
                                 java.util.List bindVariableList)

addMailOrderBatchRefFilter

protected void addMailOrderBatchRefFilter(java.lang.StringBuffer sql,
                                          java.util.List bindVariableList)

addActivePendReasonFilter

protected void addActivePendReasonFilter(java.lang.StringBuffer sql)

addPendReasonFilter

protected void addPendReasonFilter(java.lang.StringBuffer sql,
                                   java.util.List bindVariableList)

isNumeric

protected boolean isNumeric(java.lang.String s)

addSettlementIsProcessedFilter

protected void addSettlementIsProcessedFilter(java.lang.StringBuffer sql,
                                              java.util.List bindVariableList)

addRmaNumberFilter

protected void addRmaNumberFilter(java.lang.StringBuffer sql,
                                  java.util.List bindVariableList)

idsAreNotAlpha

protected boolean idsAreNotAlpha()

addCriteriaFilters

protected void addCriteriaFilters(java.lang.StringBuffer theSql,
                                  java.util.List bindVariableList)


Copyright © 2004 Retek Inc. All Rights Reserved. - Generated at Fri, 10/22/2004 07:28