Class QuoteLineExtenderBase

This is the base class for all extenders that add QuoteLine fields to their base query. It handles all QuoteLine-related fields. Derived classes should simply implement the method to join a QuoteLineTableInfo to the .

Inheritance

Object

ExtensibleColumnsBase

ExtenderBase<QuoteLineTableInfo>

TableExtenderBase<QuoteLineTableInfo>

QuoteLineExtenderBase

QlSmQuoteLineExtender

QlSmQuoteLineExtenderV2

QuoteAlternativeQuoteLineExtender

QuoteLineQuoteLineExtender

Implements

IArchiveProviderQueryMapping

IArchiveExtender

IArchiveProviderDoesExtend

IArchiveProviderHasColumns

IArchiveProviderExtensible

Inherited Members

TableExtenderBase<QuoteLineTableInfo>._ourTable

TableExtenderBase<QuoteLineTableInfo>.ModifyQuery()

TableExtenderBase<QuoteLineTableInfo>.TableToExtend

TableExtenderBase<QuoteLineTableInfo>.MainTableName

ExtenderBase<QuoteLineTableInfo>.GetRankRestriction(FieldInfo)

ExtenderBase<QuoteLineTableInfo>.StyleHintPrefix

ExtensibleColumnsBase._minuteFields

ExtensibleColumnsBase.Visible

ExtensibleColumnsBase.Invisible

ExtensibleColumnsBase.AllowOrderBy

ExtensibleColumnsBase.DenyOrderBy

ExtensibleColumnsBase.GetAllRestriction

ExtensibleColumnsBase.GetNoneRestriction

ExtensibleColumnsBase.SetParent(IArchiveProviderExtensible)

ExtensibleColumnsBase.AddAvailableColumn(ArchiveColumnInfo[])

ExtensibleColumnsBase.GetAvailableColumns()

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 QuoteLineExtenderBase : TableExtenderBase<QuoteLineTableInfo>, IArchiveProviderQueryMapping, IArchiveExtender, IArchiveProviderDoesExtend, IArchiveProviderHasColumns, IArchiveProviderExtensible, IPlugin

Constructors

QuoteLineExtenderBase()

Declaration

protected QuoteLineExtenderBase()

QuoteLineExtenderBase(QuoteLineExtenderBase.Features)

Construct the extender and all all standard extenders (all features)

Declaration

protected QuoteLineExtenderBase(QuoteLineExtenderBase.Features features)

Parameters

Type	Name	Description
QuoteLineExtenderBase.Features	features

Fields

_colCategory

Declaration

protected ArchiveColumnInfo _colCategory

Field Value

Type	Description
ArchiveColumnInfo

_colCode

Declaration

protected ArchiveColumnInfo _colCode

Field Value

Type	Description
ArchiveColumnInfo

_colCost

Declaration

protected ArchiveColumnInfo _colCost

Field Value

Type	Description
ArchiveColumnInfo

_colDeliveredQuantity

Declaration

protected ArchiveColumnInfo _colDeliveredQuantity

Field Value

Type	Description
ArchiveColumnInfo

_colDescription

Declaration

protected ArchiveColumnInfo _colDescription

Field Value

Type	Description
ArchiveColumnInfo

_colDiscountAmount

Declaration

protected ArchiveColumnInfo _colDiscountAmount

Field Value

Type	Description
ArchiveColumnInfo

_colDiscountAmountSuggestedByConnector

Declaration

protected ArchiveColumnInfo _colDiscountAmountSuggestedByConnector

Field Value

Type	Description
ArchiveColumnInfo

_colDiscountPercent

Declaration

protected ArchiveColumnInfo _colDiscountPercent

Field Value

Type	Description
ArchiveColumnInfo

_colDiscountPercentSuggestedByConnector

Declaration

protected ArchiveColumnInfo _colDiscountPercentSuggestedByConnector

Field Value

Type	Description
ArchiveColumnInfo

_colEarningAmount

Declaration

protected ArchiveColumnInfo _colEarningAmount

Field Value

Type	Description
ArchiveColumnInfo

_colEarningPercent

Declaration

protected ArchiveColumnInfo _colEarningPercent

Field Value

Type	Description
ArchiveColumnInfo

_colERPProductKey

Declaration

protected ArchiveColumnInfo _colERPProductKey

Field Value

Type	Description
ArchiveColumnInfo

_colExtraField1

Declaration

protected ArchiveColumnInfo _colExtraField1

Field Value

Type	Description
ArchiveColumnInfo

_colExtraField2

Declaration

protected ArchiveColumnInfo _colExtraField2

Field Value

Type	Description
ArchiveColumnInfo

_colExtraField3

Declaration

protected ArchiveColumnInfo _colExtraField3

Field Value

Type	Description
ArchiveColumnInfo

_colExtraField4

Declaration

protected ArchiveColumnInfo _colExtraField4

Field Value

Type	Description
ArchiveColumnInfo

_colExtraField5

Declaration

protected ArchiveColumnInfo _colExtraField5

Field Value

Type	Description
ArchiveColumnInfo

_colFamily

Declaration

protected ArchiveColumnInfo _colFamily

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

_colMinimumPrice

Declaration

protected ArchiveColumnInfo _colMinimumPrice

Field Value

Type	Description
ArchiveColumnInfo

_colName

Declaration

protected ArchiveColumnInfo _colName

Field Value

Type	Description
ArchiveColumnInfo

_colPriceUnit

Declaration

protected ArchiveColumnInfo _colPriceUnit

Field Value

Type	Description
ArchiveColumnInfo

_colPriceUnitSubscriptionQuantityUnit

Declaration

protected ArchiveColumnInfo _colPriceUnitSubscriptionQuantityUnit

Field Value

Type	Description
ArchiveColumnInfo

_colPriceUnitSubscriptionUnit

Declaration

protected ArchiveColumnInfo _colPriceUnitSubscriptionUnit

Field Value

Type	Description
ArchiveColumnInfo

_colQuantity

Declaration

protected ArchiveColumnInfo _colQuantity

Field Value

Type	Description
ArchiveColumnInfo

_colQuantityUnit

Declaration

protected ArchiveColumnInfo _colQuantityUnit

Field Value

Type	Description
ArchiveColumnInfo

_colQuoteAlternativeId

Declaration

protected ArchiveColumnInfo _colQuoteAlternativeId

Field Value

Type	Description
ArchiveColumnInfo

_colQuoteLineId

Declaration

protected ArchiveColumnInfo _colQuoteLineId

Field Value

Type	Description
ArchiveColumnInfo

_colQuotelineSubTotal

Declaration

protected ArchiveColumnInfo _colQuotelineSubTotal

Field Value

Type	Description
ArchiveColumnInfo

_colQuotelineTotalPriceIncVAT

Declaration

protected ArchiveColumnInfo _colQuotelineTotalPriceIncVAT

Field Value

Type	Description
ArchiveColumnInfo

_colQuotelineTotalPriceWithAlternativeDiscount

Declaration

protected ArchiveColumnInfo _colQuotelineTotalPriceWithAlternativeDiscount

Field Value

Type	Description
ArchiveColumnInfo

_colQuotelineVATAmount

Declaration

protected ArchiveColumnInfo _colQuotelineVATAmount

Field Value

Type	Description
ArchiveColumnInfo

_colRank

Declaration

protected ArchiveColumnInfo _colRank

Field Value

Type	Description
ArchiveColumnInfo

_colReason

Declaration

protected ArchiveColumnInfo _colReason

Field Value

Type	Description
ArchiveColumnInfo

_colRegisteredBy

Declaration

protected ArchiveColumnInfo _colRegisteredBy

Field Value

Type	Description
ArchiveColumnInfo

_colRegisteredByFullName

Declaration

protected ArchiveColumnInfo _colRegisteredByFullName

Field Value

Type	Description
ArchiveColumnInfo

_colRegisteredDate

Declaration

protected ArchiveColumnInfo _colRegisteredDate

Field Value

Type	Description
ArchiveColumnInfo

_colStatus

Declaration

protected ArchiveColumnInfo _colStatus

Field Value

Type	Description
ArchiveColumnInfo

_colSubscriptionQuantity

Declaration

protected ArchiveColumnInfo _colSubscriptionQuantity

Field Value

Type	Description
ArchiveColumnInfo

_colSubscriptionStart

Declaration

protected ArchiveColumnInfo _colSubscriptionStart

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

_colThumbnailLarge

Declaration

protected ArchiveColumnInfo _colThumbnailLarge

Field Value

Type	Description
ArchiveColumnInfo

_colTotalCost

Declaration

protected ArchiveColumnInfo _colTotalCost

Field Value

Type	Description
ArchiveColumnInfo

_colTotalPrice

Declaration

protected ArchiveColumnInfo _colTotalPrice

Field Value

Type	Description
ArchiveColumnInfo

_colType

Declaration

protected ArchiveColumnInfo _colType

Field Value

Type	Description
ArchiveColumnInfo

_colUnitListPriceSubscriptionQuantity

Declaration

protected ArchiveColumnInfo _colUnitListPriceSubscriptionQuantity

Field Value

Type	Description
ArchiveColumnInfo

_colUpdatedBy

Declaration

protected ArchiveColumnInfo _colUpdatedBy

Field Value

Type	Description
ArchiveColumnInfo

_colUpdatedByFullName

Declaration

protected ArchiveColumnInfo _colUpdatedByFullName

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

ColumnIsSubscription

Declaration

public const string ColumnIsSubscription = "isSubscription"

Field Value

Type	Description
String

ColumnName

Declaration

public const string ColumnName = "name"

Field Value

Type	Description
String

ColumnPriceUnit

Declaration

public const string ColumnPriceUnit = "priceUnit"

Field Value

Type	Description
String

ColumnProductCategoryKey

Declaration

public const string ColumnProductCategoryKey = "productCategoryKey"

Field Value

Type	Description
String

ColumnProductFamilyKey

Declaration

public const string ColumnProductFamilyKey = "productFamilyKey"

Field Value

Type	Description
String

ColumnProductTypeKey

Declaration

public const string ColumnProductTypeKey = "productTypeKey"

Field Value

Type	Description
String

ColumnQuantityUnit

Declaration

public const string ColumnQuantityUnit = "quantityUnit"

Field Value

Type	Description
String

ColumnQuotelineSubTotal

Declaration

public const string ColumnQuotelineSubTotal = "subTotal"

Field Value

Type	Description
String

ColumnQuotelineTotalPriceIncVAT

Declaration

public const string ColumnQuotelineTotalPriceIncVAT = "totalPriceIncVAT"

Field Value

Type	Description
String

ColumnQuotelineTotalPriceWithAlternativeDiscount

Declaration

public const string ColumnQuotelineTotalPriceWithAlternativeDiscount = "totalPriceWithAlternativeDiscount"

Field Value

Type	Description
String

ColumnQuotelineVATAmount

Declaration

public const string ColumnQuotelineVATAmount = "vatAmount"

Field Value

Type	Description
String

ColumnRank

Declaration

public const string ColumnRank = "rank"

Field Value

Type	Description
String

ColumnSubscriptionUnit

Declaration

public const string ColumnSubscriptionUnit = "subscriptionUnit"

Field Value

Type	Description
String

ColumnVatInfo

Declaration

public const string ColumnVatInfo = "vatInfo"

Field Value

Type	Description
String

Methods

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.QuoteLineTableInfo>.InnerModifyQuery()

InnerPopulateRowFromReader(SoDataReader, ArchiveRow)

Override: Set status icon if column selected; always set style hint

Declaration

protected override void InnerPopulateRowFromReader(SoDataReader reader, ArchiveRow row)

Parameters

Type	Name	Description
SoDataReader	reader
ArchiveRow	row

Overrides

SuperOffice.CRM.ArchiveLists.TableExtenderBase<SuperOffice.CRM.Data.QuoteLineTableInfo>.InnerPopulateRowFromReader(SuperOffice.Data.SoDataReader, SuperOffice.CRM.ArchiveLists.ArchiveRow)

SetDesiredColumns(String[])

Declaration

public override void SetDesiredColumns(params string[] columnIds)

Parameters

Type	Name	Description
String[]	columnIds

Overrides

ExtensibleColumnsBase.SetDesiredColumns(String[])

SetJoin()

Declaration

protected override QuoteLineTableInfo SetJoin()

Returns

Type	Description
QuoteLineTableInfo

Overrides

SuperOffice.CRM.ArchiveLists.ExtenderBase<SuperOffice.CRM.Data.QuoteLineTableInfo>.SetJoin()

Implements

IArchiveProviderQueryMapping

IArchiveExtender

IArchiveProviderDoesExtend

IArchiveProviderHasColumns

IArchiveProviderExtensible

Extension Methods

EnumUtil.MapEnums<From, To>(From)

Converters.MapEnums<From, To>(From)