Show / Hide Table of Contents

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
Object
ExtensibleColumnsBase
ExtenderBase<ProductTableInfo>
TableExtenderBase<ProductTableInfo>
ProductExtenderBase
ProductProductExtender
Implements
IArchiveProviderQueryMapping
IArchiveExtender
IArchiveProviderDoesExtend
IArchiveProviderHasColumns
IArchiveProviderExtensible
Inherited Members
TableExtenderBase<ProductTableInfo>._ourTable
TableExtenderBase<ProductTableInfo>.ModifyQuery()
TableExtenderBase<ProductTableInfo>.TableToExtend
TableExtenderBase<ProductTableInfo>.MainTableName
ExtenderBase<ProductTableInfo>.SetJoin()
ExtenderBase<ProductTableInfo>.GetRankRestriction(FieldInfo)
ExtenderBase<ProductTableInfo>.StyleHintPrefix
ExtensibleColumnsBase._minuteFields
ExtensibleColumnsBase.Visible
ExtensibleColumnsBase.Invisible
ExtensibleColumnsBase.AllowOrderBy
ExtensibleColumnsBase.DenyOrderBy
ExtensibleColumnsBase.GetAllRestriction
ExtensibleColumnsBase.GetNoneRestriction
ExtensibleColumnsBase.SetParent(IArchiveProviderExtensible)
ExtensibleColumnsBase.AddAvailableColumn(ArchiveColumnInfo[])
ExtensibleColumnsBase.GetAvailableColumns()
ExtensibleColumnsBase.SetDesiredColumns(String[])
ExtensibleColumnsBase.SetOrderBy(ArchiveOrderByInfo[])
ExtensibleColumnsBase.SetOrderByMapping(String, String[])
ExtensibleColumnsBase.SetOrderByMapping(ArchiveColumnInfo, ArchiveColumnInfo[])
ExtensibleColumnsBase.SetPrefixes(String, String)
ExtensibleColumnsBase.SetLocalAbsolutePrefixes(String, String)
ExtensibleColumnsBase.SetIconHint(String)
ExtensibleColumnsBase.SetRestriction(ArchiveRestrictionInfo[])
ExtensibleColumnsBase.AddLocalRestriction(ArchiveRestrictionInfo[])
ExtensibleColumnsBase.AddExtensionProvider(IArchiveExtender)
ExtensibleColumnsBase.GetExtensionProviders()
ExtensibleColumnsBase.GetTableInfosFromExtensionProviders()
ExtensibleColumnsBase.PopulateRowFromReader(SoDataReader, ArchiveRow)
ExtensibleColumnsBase.SuppressTableResults(SoDataReader, TableInfo)
ExtensibleColumnsBase.SuppressDeepTableResults(SoDataReader, TableInfo)
ExtensibleColumnsBase.AddColumnNameOverride(String, String)
ExtensibleColumnsBase.ApplyColumnNameOverrides(ArchiveRow)
ExtensibleColumnsBase.AddSubExtenderMapping(String, ExtensibleColumnsBase[])
ExtensibleColumnsBase.WantColumnForOutput(String[])
ExtensibleColumnsBase.WantColumnForOutput(ArchiveColumnInfo[])
ExtensibleColumnsBase.WantColumnForOutput(List<ArchiveColumnInfo>)
ExtensibleColumnsBase.WantColumnForRestriction(String[])
ExtensibleColumnsBase.WantColumnForRestriction(ArchiveColumnInfo[])
ExtensibleColumnsBase.WantColumnForOrderBy(String[])
ExtensibleColumnsBase.GetColumnOrderBy(String)
ExtensibleColumnsBase.WantColumnForOrderBy(ArchiveColumnInfo[])
ExtensibleColumnsBase.WantColumnForAnything(String[])
ExtensibleColumnsBase.WantColumnForAnything(ArchiveColumnInfo[])
ExtensibleColumnsBase.IsQueryNeeded()
ExtensibleColumnsBase.IsQueryRestriction()
ExtensibleColumnsBase.GetLeftOuterOrInnerJoin(Equal)
ExtensibleColumnsBase.GetLeftOuterOrInnerJoin(Equal, Restriction)
ExtensibleColumnsBase.SetLeftOuterOrInnerJoin(Equal)
ExtensibleColumnsBase.SetLeftOuterOrInnerJoin(Equal, Restriction)
ExtensibleColumnsBase.MapReturnField(ArchiveSelect, FieldInfo, Boolean, String, ArchiveColumnInfo[])
ExtensibleColumnsBase.MapIdField(FieldInfo)
ExtensibleColumnsBase.MapAssociateField(FieldInfo, ArchiveColumnInfo)
ExtensibleColumnsBase.MapEjUserField(FieldInfo, ArchiveColumnInfo)
ExtensibleColumnsBase.MapSimpleReturnField(FieldInfo, ArchiveColumnInfo[])
ExtensibleColumnsBase.MapSimpleImageField(FieldInfo, ArchiveColumnInfo, Int32, Int32)
ExtensibleColumnsBase.MapPictureBlob(FieldInfo, ArchiveColumnInfo, BlobLinkType, Int32, Int32, Int32)
ExtensibleColumnsBase.MapSimpleCustomField(FieldInfo, ArchiveColumnInfo[])
ExtensibleColumnsBase.MapSimpleListReturnField(FieldInfo, String, ArchiveColumnInfo[])
ExtensibleColumnsBase.MapOrderByField(FieldInfo, ArchiveColumnInfo)
ExtensibleColumnsBase.ActivateAsLinkField(String, ArchiveColumnInfo[])
ExtensibleColumnsBase.HasAvailableColumn(String)
ExtensibleColumnsBase.AddAndInitializeExtensionProvider<ExtenderType>(ExtenderType, String, String)
ExtensibleColumnsBase.AddAndInitializeExtensionProvider<ExtenderType>(ExtenderType)
ExtensibleColumnsBase.HasRestriction(String)
ExtensibleColumnsBase.ExtractRestrictions(String)
ExtensibleColumnsBase.ExtractRestrictions(ArchiveColumnInfo)
ExtensibleColumnsBase.ExtractRestriction(String)
ExtensibleColumnsBase.ExtractRestriction(ArchiveColumnInfo)
ExtensibleColumnsBase.ProcessRestrictions()
ExtensibleColumnsBase.ProcessOrderBy()
ExtensibleColumnsBase.PopulateSimpleFields(SoDataReader, ArchiveRow)
ExtensibleColumnsBase.CalculateOrderbyValue(String, SoDataReader, ArchiveColumnData)
ExtensibleColumnsBase.AddDbInfo(ArchiveColumnData, FieldInfo)
ExtensibleColumnsBase.AddDbInfo(ArchiveColumnData, Int32)
ExtensibleColumnsBase.ForceDisable()
ExtensibleColumnsBase.GetAssociateData(Int32)
ExtensibleColumnsBase.GetEjUserData(Int32)
ExtensibleColumnsBase.GetColumnIndex(ArchiveColumnInfo)
ExtensibleColumnsBase.GetColumnIndexFromReader(SoDataReader, FieldInfo, Int32)
ExtensibleColumnsBase.ConvertDbTypeToString(Object, ExtensibleColumnsBase.DbColumnBinding)
ExtensibleColumnsBase.GetStandardTooltipHint(SoDataReader, FieldInfo)
ExtensibleColumnsBase.GetLinkHint(SoDataReader, String)
ExtensibleColumnsBase.SetNonZeroBoolRestriction(ArchiveColumnInfo)
ExtensibleColumnsBase.AddUpdatedByMapping(ArchiveColumnInfo, FieldInfo, FieldInfo)
ExtensibleColumnsBase.AddRegisteredMapping(ArchiveColumnInfo, FieldInfo, ArchiveColumnInfo, FieldInfo)
ExtensibleColumnsBase.AddLastUpdatedMapping(ArchiveColumnInfo, FieldInfo, FieldInfo)
ExtensibleColumnsBase.AddUpdatedBy(SoDataReader, ArchiveRow, ArchiveColumnInfo, FieldInfo, FieldInfo)
ExtensibleColumnsBase.AddUpdatedDate(SoDataReader, ArchiveRow, ArchiveColumnInfo, FieldInfo, FieldInfo)
ExtensibleColumnsBase.AddAssociateFullName(SoDataReader, ArchiveRow, ArchiveColumnInfo, FieldInfo[])
ExtensibleColumnsBase.GetIdFieldTag(SoDataReader)
ExtensibleColumnsBase.GetArchiveColumnName(SoField)
ExtensibleColumnsBase.ExtensibleHelper
ExtensibleColumnsBase.ColumnHelper
ExtensibleColumnsBase.RestrictionHelper
ExtensibleColumnsBase.Parent
ExtensibleColumnsBase.DisableSubtreeIfNoRestriction
ExtensibleColumnsBase.RestrictionSetForSubtree
ExtensibleColumnsBase.ForceQueryNeeded
ExtensibleColumnsBase.ForceRestriction
ExtensibleColumnsBase.BlockOrderBy
ExtensibleColumnsBase.IdField
ExtensibleColumnsBase.LastSubExtenderWins
ExtensibleColumnsBase.ParentPrimaryKey
ExtensibleColumnsBase.QuoteAlternativeId
ExtensibleColumnsBase.SaleId
ExtensibleColumnsBase.NamePrefix
ExtensibleColumnsBase.DisplayNamePrefix
ExtensibleColumnsBase.RootQuery
ExtensibleColumnsBase.OrderBySlots
ExtensibleColumnsBase.PopulateDisplayValue
ExtensibleColumnsBase.PopulateTooltipHint
ExtensibleColumnsBase.DebugXML
Object.ToString()
Object.Equals(Object)
Object.Equals(Object, Object)
Object.ReferenceEquals(Object, Object)
Object.GetHashCode()
Object.GetType()
Object.MemberwiseClone()
Namespace: SuperOffice.CRM.ArchiveLists
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
Type Description
ArchiveColumnInfo

_colCost

Declaration
protected ArchiveColumnInfo _colCost
Field Value
Type Description
ArchiveColumnInfo

_colDefaultSubscriptionQuantity

Declaration
protected ArchiveColumnInfo _colDefaultSubscriptionQuantity
Field Value
Type Description
ArchiveColumnInfo

_colDescription

Declaration
protected ArchiveColumnInfo _colDescription
Field Value
Type Description
ArchiveColumnInfo

_colERPProductKey

Declaration
protected ArchiveColumnInfo _colERPProductKey
Field Value
Type Description
ArchiveColumnInfo

_colExtra1

Declaration
protected ArchiveColumnInfo _colExtra1
Field Value
Type Description
ArchiveColumnInfo

_colExtra2

Declaration
protected ArchiveColumnInfo _colExtra2
Field Value
Type Description
ArchiveColumnInfo

_colExtra3

Declaration
protected ArchiveColumnInfo _colExtra3
Field Value
Type Description
ArchiveColumnInfo

_colExtra4

Declaration
protected ArchiveColumnInfo _colExtra4
Field Value
Type Description
ArchiveColumnInfo

_colExtra5

Declaration
protected ArchiveColumnInfo _colExtra5
Field Value
Type Description
ArchiveColumnInfo

_colExtraInfo

Declaration
protected ArchiveColumnInfo _colExtraInfo
Field Value
Type Description
ArchiveColumnInfo

_colInAssortment

Declaration
protected ArchiveColumnInfo _colInAssortment
Field Value
Type Description
ArchiveColumnInfo

_colIsSubscription

Declaration
protected ArchiveColumnInfo _colIsSubscription
Field Value
Type Description
ArchiveColumnInfo

_colItemNumber

Declaration
protected ArchiveColumnInfo _colItemNumber
Field Value
Type Description
ArchiveColumnInfo

_colListPrice

Declaration
protected ArchiveColumnInfo _colListPrice
Field Value
Type Description
ArchiveColumnInfo

_colMinimumsPrice

Declaration
protected ArchiveColumnInfo _colMinimumsPrice
Field Value
Type Description
ArchiveColumnInfo

_colName

Declaration
protected ArchiveColumnInfo _colName
Field Value
Type Description
ArchiveColumnInfo

_colPriceListId

Declaration
protected ArchiveColumnInfo _colPriceListId
Field Value
Type Description
ArchiveColumnInfo

_colPriceUnit

Declaration
protected ArchiveColumnInfo _colPriceUnit
Field Value
Type Description
ArchiveColumnInfo

_colProductCategory

Declaration
protected ArchiveColumnInfo _colProductCategory
Field Value
Type Description
ArchiveColumnInfo

_colProductFamily

Declaration
protected ArchiveColumnInfo _colProductFamily
Field Value
Type Description
ArchiveColumnInfo

_colProductId

Declaration
protected ArchiveColumnInfo _colProductId
Field Value
Type Description
ArchiveColumnInfo

_colProductType

Declaration
protected ArchiveColumnInfo _colProductType
Field Value
Type Description
ArchiveColumnInfo

_colQuantityUnit

Declaration
protected ArchiveColumnInfo _colQuantityUnit
Field Value
Type Description
ArchiveColumnInfo

_colRegisteredBy

Declaration
protected ArchiveColumnInfo _colRegisteredBy
Field Value
Type Description
ArchiveColumnInfo

_colRegisteredDate

Declaration
protected ArchiveColumnInfo _colRegisteredDate
Field Value
Type Description
ArchiveColumnInfo

_colSubscriptionUnit

Declaration
protected ArchiveColumnInfo _colSubscriptionUnit
Field Value
Type Description
ArchiveColumnInfo

_colSupplier

Declaration
protected ArchiveColumnInfo _colSupplier
Field Value
Type Description
ArchiveColumnInfo

_colSupplierCode

Declaration
protected ArchiveColumnInfo _colSupplierCode
Field Value
Type Description
ArchiveColumnInfo

_colThumbnail

Declaration
protected ArchiveColumnInfo _colThumbnail
Field Value
Type Description
ArchiveColumnInfo

_colUpdatedBy

Declaration
protected ArchiveColumnInfo _colUpdatedBy
Field Value
Type Description
ArchiveColumnInfo

_colUpdatedDate

Declaration
protected ArchiveColumnInfo _colUpdatedDate
Field Value
Type Description
ArchiveColumnInfo

_colURL

Declaration
protected ArchiveColumnInfo _colURL
Field Value
Type Description
ArchiveColumnInfo

_colVAT

Declaration
protected ArchiveColumnInfo _colVAT
Field Value
Type Description
ArchiveColumnInfo

_colVATInfo

Declaration
protected ArchiveColumnInfo _colVATInfo
Field Value
Type Description
ArchiveColumnInfo

ColumnCode

Declaration
public const string ColumnCode = "code"
Field Value
Type Description
String

ColumnCost

Declaration
public const string ColumnCost = "cost"
Field Value
Type Description
String

ColumnDefaultSubscriptionQuantity

Declaration
public const string ColumnDefaultSubscriptionQuantity = "defaultSubscriptionQuantity"
Field Value
Type Description
String

ColumnDescription

Declaration
public const string ColumnDescription = "description"
Field Value
Type Description
String

ColumnErpPriceListKey

Declaration
public const string ColumnErpPriceListKey = "erpPriceListKey"
Field Value
Type Description
String

ColumnErpProductKey

Declaration
public const string ColumnErpProductKey = "erpProductKey"
Field Value
Type Description
String

ColumnExtraField1

Declaration
public const string ColumnExtraField1 = "extraField1"
Field Value
Type Description
String

ColumnExtraField2

Declaration
public const string ColumnExtraField2 = "extraField2"
Field Value
Type Description
String

ColumnExtraField3

Declaration
public const string ColumnExtraField3 = "extraField3"
Field Value
Type Description
String

ColumnExtraField4

Declaration
public const string ColumnExtraField4 = "extraField4"
Field Value
Type Description
String

ColumnExtraField5

Declaration
public const string ColumnExtraField5 = "extraField5"
Field Value
Type Description
String

ColumnExtraInfo

Declaration
public const string ColumnExtraInfo = "extraInfo"
Field Value
Type Description
String

ColumnInAssortment

Declaration
public const string ColumnInAssortment = "inAssortment"
Field Value
Type Description
String

ColumnIsSubscription

Declaration
public const string ColumnIsSubscription = "isSubscription"
Field Value
Type Description
String

ColumnItemNumber

Declaration
public const string ColumnItemNumber = "itemNumber"
Field Value
Type Description
String

ColumnListPrice

Declaration
public const string ColumnListPrice = "listPrice"
Field Value
Type Description
String

ColumnMinimumPrice

Declaration
public const string ColumnMinimumPrice = "minimumPrice"
Field Value
Type Description
String

ColumnName

Declaration
public const string ColumnName = "name"
Field Value
Type Description
String

ColumnPriceListId

Declaration
public const string ColumnPriceListId = "priceListId"
Field Value
Type Description
String

ColumnPriceListName

Declaration
public const string ColumnPriceListName = "priceListName"
Field Value
Type Description
String

ColumnPriceUnit

Declaration
public const string ColumnPriceUnit = "priceUnit"
Field Value
Type Description
String

ColumnProductCategory

Declaration
public const string ColumnProductCategory = "productCategoryKey"
Field Value
Type Description
String

ColumnProductFamily

Declaration
public const string ColumnProductFamily = "productFamilyKey"
Field Value
Type Description
String

ColumnProductType

Declaration
public const string ColumnProductType = "productTypeKey"
Field Value
Type Description
String

ColumnQuantityUnit

Declaration
public const string ColumnQuantityUnit = "quantityUnit"
Field Value
Type Description
String

ColumnSubscriptionUnit

Declaration
public const string ColumnSubscriptionUnit = "subscriptionUnit"
Field Value
Type Description
String

ColumnSupplier

Declaration
public const string ColumnSupplier = "supplier"
Field Value
Type Description
String

ColumnSupplierCode

Declaration
public const string ColumnSupplierCode = "supplierCode"
Field Value
Type Description
String

ColumnThumbnail

Declaration
public const string ColumnThumbnail = "thumbnail"
Field Value
Type Description
String

ColumnUrl

Declaration
public const string ColumnUrl = "url"
Field Value
Type Description
String

ColumnVat

Declaration
public const string ColumnVat = "vat"
Field Value
Type Description
String

ColumnVatInfo

Declaration
public const string ColumnVatInfo = "vatInfo"
Field Value
Type Description
String

PrefixPricelist

Declaration
public const string PrefixPricelist = "priceList"
Field Value
Type Description
String

Methods

ConditionalLookupItem(Boolean, String, String)

Declaration
public static ISoListItem ConditionalLookupItem(bool isErpCopy, string listName, string idOrItem)
Parameters
Type Name Description
Boolean isErpCopy
String listName
String idOrItem
Returns
Type Description
ISoListItem

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

IArchiveProviderQueryMapping
IArchiveExtender
IArchiveProviderDoesExtend
IArchiveProviderHasColumns
IArchiveProviderExtensible

Extension Methods

EnumUtil.MapEnums<From, To>(From)
Converters.MapEnums<From, To>(From)
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top