Show / Hide Table of Contents

Class PriceListRows.IdxValidFromValidTo

Class representing index 'IValidFromValidToIsActiveIsER'. This particular class implements a from-the-left subset of the fields, to ease coding of these efficient searches

Inheritance
Object
SqlCommand
PrivateSelect
IdxBase
IdxBase<PriceListTableInfo>
PriceListRow.PriceListRowIdxBase
PriceListRows.PriceListRowsIdx
PriceListRows.IdxValidFromValidTo
Implements
ICloneable
ISentryIgnorable
Inherited Members
PrivateSelect._isDistinct
PrivateSelect.GetTableInfos()
PrivateSelect.GetRelations(TableInfo)
PrivateSelect.GetRelations(TableInfo, SoTable)
PrivateSelect.IsTableOuterJoined(TableInfo)
PrivateSelect.GetTablesInOrderBy()
PrivateSelect.GetTablesLeadingToTable(TableInfo)
PrivateSelect.ValidateJoin()
PrivateSelect.Clone()
PrivateSelect.CloneSelect()
PrivateSelect.ToString()
PrivateSelect.GetCachingHash()
PrivateSelect.GetRestrictionTables()
PrivateSelect.CreateOrderBy()
PrivateSelect.InnerReturnFields
PrivateSelect.InnerOrderBy
PrivateSelect.IsDistinct
PrivateSelect.ForceRecompile
PrivateSelect.InnerGroupBy
PrivateSelect.InnerJoinRestriction
PrivateSelect.SqlType
SqlCommand.Origin
SqlCommand.AdditionalInfo
SqlCommand.AddIgnoreAutoSentryTableInfo(TableInfo)
SqlCommand.AddIgnoreAutoSentryTableInfo(IEnumerable<TableInfo>)
SqlCommand.RemoveIgnoreAutoSentryTableInfo(TableInfo)
SqlCommand.ClearIgnoreAutoSentryTableInfos()
SqlCommand.IsAutoSentryIgnoredOnTableInfo(TableInfo)
SqlCommand.GetPrivateSaves()
SqlCommand.GetInserts()
SqlCommand.GetUpdates()
SqlCommand.GetDeletes()
SqlCommand.GetSelect()
SqlCommand.AutoSentryIgnoredTables
Namespace: SuperOffice.CRM.Rows
Assembly: SoDataBase.dll
Syntax
public sealed class IdxValidFromValidTo : PriceListRows.PriceListRowsIdx, ICloneable, ISentryIgnorable

Constructors

IdxValidFromValidTo(DateTime, DateTimeSearchType, DateTime, DateTimeSearchType)

Constructor for class PriceListRows.IdxValidFromValidTo This class represents index 'IValidFromValidToIsActiveIsERPCopy'.

Declaration
public IdxValidFromValidTo(DateTime validFrom, DateTimeSearchType validFromSearchType, DateTime validTo, DateTimeSearchType validToSearchType)
Parameters
Type Name Description
DateTime validFrom
DateTimeSearchType validFromSearchType

How to search for ValidFrom

DateTime validTo
DateTimeSearchType validToSearchType

How to search for ValidTo

IdxValidFromValidTo(DateTime, DateTime)

Constructor for class PriceListRows.IdxValidFromValidTo This class represents index 'IValidFromValidToIsActiveIsERPCopy'. This particular class implements a from-the-left subset of the fields, to ease coding of these efficient searches

Declaration
public IdxValidFromValidTo(DateTime validFrom, DateTime validTo)
Parameters
Type Name Description
DateTime validFrom
DateTime validTo

Properties

InnerRestriction

The Restriction passed to the Select statement.

Declaration
protected override Restriction InnerRestriction { get; }
Property Value
Type Description
Restriction

Restriction object holding the restrictions for the select statement.

Overrides
PrivateSelect.InnerRestriction

ValidFrom

The date (inclusive) the pricelist start to be valid. This can be DateTime.MinValue to signal that it doesn't have a specific start date.

Declaration
public DateTime ValidFrom { get; set; }
Property Value
Type Description
DateTime

ValidTo

The date (inclusive) the pricelist ends to be valid. This can be DateTime.MaxValue to signal that it doesn't have a specific end date.

Declaration
public DateTime ValidTo { get; set; }
Property Value
Type Description
DateTime

Methods

UpdateRow(TableRowBase)

Update the PriceListRow with the values from the index.

Declaration
public override void UpdateRow(TableRowBase baseRow)
Parameters
Type Name Description
TableRowBase baseRow

The row to update. This must be an instance of PriceListRow.

Overrides
SuperOffice.CRM.Rows.IdxBase.UpdateRow(SuperOffice.CRM.Rows.TableRowBase)

Implements

System.ICloneable
ISentryIgnorable

Extension Methods

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