Class ProductExtenderBase
This is the base class for all extenders that add Product fields to their base query. It handles all product-related fields.
Derived classes should simply implement
the method to join a ProductTableInfo to the .
The column names need to be synchronized with the so the fastsearch GUI can do its job
Inheritance
ProductExtenderBase
Assembly: SoDataBase.dll
Syntax
public abstract class ProductExtenderBase : TableExtenderBase<ProductTableInfo>, IArchiveProviderQueryMapping, IArchiveExtender, IArchiveProviderDoesExtend, IArchiveProviderHasColumns, IArchiveProviderExtensible, IPlugin
Constructors
ProductExtenderBase()
Construct the extender and all all standard extenders (all features)
Declaration
public ProductExtenderBase()
Fields
_colCode
Declaration
protected ArchiveColumnInfo _colCode
Field Value
_colCost
Declaration
protected ArchiveColumnInfo _colCost
Field Value
_colDefaultSubscriptionQuantity
Declaration
protected ArchiveColumnInfo _colDefaultSubscriptionQuantity
Field Value
_colDescription
Declaration
protected ArchiveColumnInfo _colDescription
Field Value
_colERPProductKey
Declaration
protected ArchiveColumnInfo _colERPProductKey
Field Value
Declaration
protected ArchiveColumnInfo _colExtra1
Field Value
Declaration
protected ArchiveColumnInfo _colExtra2
Field Value
Declaration
protected ArchiveColumnInfo _colExtra3
Field Value
Declaration
protected ArchiveColumnInfo _colExtra4
Field Value
Declaration
protected ArchiveColumnInfo _colExtra5
Field Value
Declaration
protected ArchiveColumnInfo _colExtraInfo
Field Value
_colInAssortment
Declaration
protected ArchiveColumnInfo _colInAssortment
Field Value
_colIsSubscription
Declaration
protected ArchiveColumnInfo _colIsSubscription
Field Value
_colItemNumber
Declaration
protected ArchiveColumnInfo _colItemNumber
Field Value
_colListPrice
Declaration
protected ArchiveColumnInfo _colListPrice
Field Value
_colMinimumsPrice
Declaration
protected ArchiveColumnInfo _colMinimumsPrice
Field Value
_colName
Declaration
protected ArchiveColumnInfo _colName
Field Value
_colPriceListId
Declaration
protected ArchiveColumnInfo _colPriceListId
Field Value
_colPriceUnit
Declaration
protected ArchiveColumnInfo _colPriceUnit
Field Value
_colProductCategory
Declaration
protected ArchiveColumnInfo _colProductCategory
Field Value
_colProductFamily
Declaration
protected ArchiveColumnInfo _colProductFamily
Field Value
_colProductId
Declaration
protected ArchiveColumnInfo _colProductId
Field Value
_colProductType
Declaration
protected ArchiveColumnInfo _colProductType
Field Value
_colQuantityUnit
Declaration
protected ArchiveColumnInfo _colQuantityUnit
Field Value
_colRegisteredBy
Declaration
protected ArchiveColumnInfo _colRegisteredBy
Field Value
_colRegisteredDate
Declaration
protected ArchiveColumnInfo _colRegisteredDate
Field Value
_colSubscriptionUnit
Declaration
protected ArchiveColumnInfo _colSubscriptionUnit
Field Value
_colSupplier
Declaration
protected ArchiveColumnInfo _colSupplier
Field Value
_colSupplierCode
Declaration
protected ArchiveColumnInfo _colSupplierCode
Field Value
_colThumbnail
Declaration
protected ArchiveColumnInfo _colThumbnail
Field Value
_colUpdatedBy
Declaration
protected ArchiveColumnInfo _colUpdatedBy
Field Value
_colUpdatedDate
Declaration
protected ArchiveColumnInfo _colUpdatedDate
Field Value
_colURL
Declaration
protected ArchiveColumnInfo _colURL
Field Value
_colVAT
Declaration
protected ArchiveColumnInfo _colVAT
Field Value
_colVATInfo
Declaration
protected ArchiveColumnInfo _colVATInfo
Field Value
ColumnCode
Declaration
public const string ColumnCode = "code"
Field Value
ColumnCost
Declaration
public const string ColumnCost = "cost"
Field Value
ColumnDefaultSubscriptionQuantity
Declaration
public const string ColumnDefaultSubscriptionQuantity = "defaultSubscriptionQuantity"
Field Value
ColumnDescription
Declaration
public const string ColumnDescription = "description"
Field Value
ColumnErpPriceListKey
Declaration
public const string ColumnErpPriceListKey = "erpPriceListKey"
Field Value
ColumnErpProductKey
Declaration
public const string ColumnErpProductKey = "erpProductKey"
Field Value
ColumnExtraField1
Declaration
public const string ColumnExtraField1 = "extraField1"
Field Value
ColumnExtraField2
Declaration
public const string ColumnExtraField2 = "extraField2"
Field Value
ColumnExtraField3
Declaration
public const string ColumnExtraField3 = "extraField3"
Field Value
ColumnExtraField4
Declaration
public const string ColumnExtraField4 = "extraField4"
Field Value
ColumnExtraField5
Declaration
public const string ColumnExtraField5 = "extraField5"
Field Value
ColumnExtraInfo
Declaration
public const string ColumnExtraInfo = "extraInfo"
Field Value
ColumnInAssortment
Declaration
public const string ColumnInAssortment = "inAssortment"
Field Value
ColumnIsSubscription
Declaration
public const string ColumnIsSubscription = "isSubscription"
Field Value
ColumnItemNumber
Declaration
public const string ColumnItemNumber = "itemNumber"
Field Value
ColumnListPrice
Declaration
public const string ColumnListPrice = "listPrice"
Field Value
ColumnMinimumPrice
Declaration
public const string ColumnMinimumPrice = "minimumPrice"
Field Value
ColumnName
Declaration
public const string ColumnName = "name"
Field Value
ColumnPriceListId
Declaration
public const string ColumnPriceListId = "priceListId"
Field Value
ColumnPriceListName
Declaration
public const string ColumnPriceListName = "priceListName"
Field Value
ColumnPriceUnit
Declaration
public const string ColumnPriceUnit = "priceUnit"
Field Value
ColumnProductCategory
Declaration
public const string ColumnProductCategory = "productCategoryKey"
Field Value
ColumnProductFamily
Declaration
public const string ColumnProductFamily = "productFamilyKey"
Field Value
ColumnProductType
Declaration
public const string ColumnProductType = "productTypeKey"
Field Value
ColumnQuantityUnit
Declaration
public const string ColumnQuantityUnit = "quantityUnit"
Field Value
ColumnSubscriptionUnit
Declaration
public const string ColumnSubscriptionUnit = "subscriptionUnit"
Field Value
ColumnSupplier
Declaration
public const string ColumnSupplier = "supplier"
Field Value
ColumnSupplierCode
Declaration
public const string ColumnSupplierCode = "supplierCode"
Field Value
ColumnThumbnail
Declaration
public const string ColumnThumbnail = "thumbnail"
Field Value
ColumnUrl
Declaration
public const string ColumnUrl = "url"
Field Value
ColumnVat
Declaration
public const string ColumnVat = "vat"
Field Value
ColumnVatInfo
Declaration
public const string ColumnVatInfo = "vatInfo"
Field Value
PrefixPricelist
Declaration
public const string PrefixPricelist = "priceList"
Field Value
Methods
ConditionalLookupItem(Boolean, String, String)
Declaration
public static ISoListItem ConditionalLookupItem(bool isErpCopy, string listName, string idOrItem)
Parameters
Returns
InnerModifyQuery()
Add/map return fields to the query; call SetJoin to obtain the contact table info instance from
the derived class
Declaration
protected override void InnerModifyQuery()
Overrides
SuperOffice.CRM.ArchiveLists.ExtenderBase<SuperOffice.CRM.Data.ProductTableInfo>.InnerModifyQuery()
InnerPopulateRowFromReader(SoDataReader, ArchiveRow)
Derived classes should implement the population of ColumnData items for columns
that are NOT handled by this base class in this method. Whether a column is handled by
this base class is part of its database binding information, set by the various MapXXX methods.
Declaration
protected override void InnerPopulateRowFromReader(SoDataReader reader, ArchiveRow row)
Parameters
Type |
Name |
Description |
SoDataReader |
reader |
Data reader with the query result (one row)
|
ArchiveRow |
row |
archive row to be populated
|
Overrides
SuperOffice.CRM.ArchiveLists.TableExtenderBase<SuperOffice.CRM.Data.ProductTableInfo>.InnerPopulateRowFromReader(SuperOffice.Data.SoDataReader, SuperOffice.CRM.ArchiveLists.ArchiveRow)
Implements
Extension Methods
EnumUtil.MapEnums<From, To>(From)