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)