Class TargetValueExtenderBase
Base extender class that handles target values. Can give you a stream of target values with associate and period/year, based on given criteria.
Inheritance
TargetValueExtenderBase
Assembly: SoDataBase.BusinessLogic.dll
Syntax
public abstract class TargetValueExtenderBase : TableExtenderBase<TargetAssignmentValueTableInfo>, IArchiveProviderQueryMapping, IArchiveExtender, IArchiveProviderDoesExtend, IArchiveProviderHasColumns, IArchiveProviderExtensible
Constructors
TargetValueExtenderBase()
Declaration
protected TargetValueExtenderBase()
Fields
TargetAssignmentIdColName
Declaration
public const string TargetAssignmentIdColName = "targetAssignmentId"
Field Value
TargetPeriodColName
Declaration
public const string TargetPeriodColName = "targetPeriod"
Field Value
TargetPeriodNumberColName
Declaration
public const string TargetPeriodNumberColName = "targetPeriodNumber"
Field Value
TargetPeriodTypeColName
Declaration
public const string TargetPeriodTypeColName = "targetPeriodType"
Field Value
TargetValueColName
Declaration
public const string TargetValueColName = "targetValue"
Field Value
_colTargetAssignmentDimensionItemId
Declaration
protected ArchiveColumnInfo _colTargetAssignmentDimensionItemId
Field Value
_colTargetAssignmentId
Declaration
protected ArchiveColumnInfo _colTargetAssignmentId
Field Value
_colTargetAssociate
Declaration
protected ArchiveColumnInfo _colTargetAssociate
Field Value
Declaration
protected ArchiveColumnInfo _colTargetContactId
Field Value
_colTargetCurrency
Declaration
protected ArchiveColumnInfo _colTargetCurrency
Field Value
_colTargetDimensionEntityType
Declaration
protected ArchiveColumnInfo _colTargetDimensionEntityType
Field Value
_colTargetDimensionListField
Declaration
protected ArchiveColumnInfo _colTargetDimensionListField
Field Value
_colTargetDimensionMeasurementUnit
Declaration
protected ArchiveColumnInfo _colTargetDimensionMeasurementUnit
Field Value
_colTargetDimensionTargetTypeName
Declaration
protected ArchiveColumnInfo _colTargetDimensionTargetTypeName
Field Value
_colTargetPeriod
Declaration
protected ArchiveColumnInfo _colTargetPeriod
Field Value
_colTargetPeriodNumber
Declaration
protected ArchiveColumnInfo _colTargetPeriodNumber
Field Value
_colTargetPeriodType
Declaration
protected ArchiveColumnInfo _colTargetPeriodType
Field Value
_colTargetUserGroup
Declaration
protected ArchiveColumnInfo _colTargetUserGroup
Field Value
_colTargetValue
Declaration
protected ArchiveColumnInfo _colTargetValue
Field Value
_colTargetYear
Declaration
protected ArchiveColumnInfo _colTargetYear
Field Value
_targetAssignmentInfoTable
Declaration
protected TargetAssignmentInfoTableInfo _targetAssignmentInfoTable
Field Value
_targetDimensionTable
Declaration
protected TargetDimensionTableInfo _targetDimensionTable
Field Value
_targetEntityTypeLookup
Declaration
protected Dictionary<string, ISoListItem> _targetEntityTypeLookup
Field Value
_targetGroupTable
Declaration
protected TargetGroupTableInfo _targetGroupTable
Field Value
_targetPeriodTable
Declaration
protected TargetPeriodTableInfo _targetPeriodTable
Field Value
Properties
EndDate
Declaration
public DateTime EndDate { get; }
Property Value
StartDate
Declaration
public DateTime StartDate { get; }
Property Value
Methods
InnerModifyQuery()
Add/map return fields to the query
Declaration
protected override void InnerModifyQuery()
Overrides
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
ProcessOrderBy()
Process order by information during query modification. For each order by column that
matches a known database binding, add the orderby clause to the query. If the column has
a separate fieldinfo specified for its orderby (as specified by MapOrderByField(FieldInfo, ArchiveColumnInfo),
this field is used, otherwise the display field is used).
Declaration
protected override void ProcessOrderBy()
Overrides
SetOrderBy(ArchiveOrderByInfo[])
Set the order by parameters. This method sets the order by parameters of this provider,
as well as invoking the same call on all known extenders. Recursion will take it to the bottom.
This method actually only saves the orderby specification for use during query processing.
Any column name overrides
are processed, i.e., replaced with the original inner names, so that the inner providers do not see the overrides.
Declaration
public override void SetOrderBy(ArchiveOrderByInfo[] orderBy)
Parameters
Overrides
Implements
Extension Methods