Show / Hide Table of Contents

Class SaleList.SaleListQuery

SaleListQuery is a nested class containing the necessary information to provide its outer class with enough information to build the list.

Inheritance
object
SqlCommand
PrivateSelect
ListSelect
SaleList.SaleListQuery
SaleList.CustomSearch
Implements
ICloneable
Inherited Members
ListSelect._restriction
ListSelect._joinRestriction
ListSelect._fields
ListSelect._orderBy
ListSelect._groupBy
ListSelect.CreateListReaderAsync(SoConnection, PrivateSelect, CancellationToken, params Sentry[])
ListSelect.CreateListReaderAsync(SoConnection, PrivateSelect, int, CancellationToken, params Sentry[])
ListSelect.InnerRestriction
ListSelect.InnerReturnFields
ListSelect.InnerOrderBy
ListSelect.InnerGroupBy
ListSelect.InnerJoinRestriction
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.IsDistinct
PrivateSelect.ForceRecompile
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
object.Equals(object)
object.Equals(object, object)
object.ReferenceEquals(object, object)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
Namespace: SuperOffice.CRM.Archives
Assembly: SoDataBase.dll
Syntax
public abstract class SaleList.SaleListQuery : ListSelect, ICloneable

Properties

AssociateTableInfo

Get AssociateTableInfo

Declaration
public AssociateTableInfo AssociateTableInfo { get; }
Property Value
Type Description
AssociateTableInfo

ContactTableInfo

Get ContactTableInfo

Declaration
public ContactTableInfo ContactTableInfo { get; }
Property Value
Type Description
ContactTableInfo

CurrencyTableInfo

Get CurrencyTableInfo

Declaration
public CurrencyTableInfo CurrencyTableInfo { get; }
Property Value
Type Description
CurrencyTableInfo

PersonTableInfo

Get PersonTableInfo

Declaration
public PersonTableInfo PersonTableInfo { get; }
Property Value
Type Description
PersonTableInfo

ProjectTableInfo

Get ProjectTableInfo

Declaration
public ProjectTableInfo ProjectTableInfo { get; }
Property Value
Type Description
ProjectTableInfo

SaleTableInfo

Get SaleTableInfo

Declaration
public SaleTableInfo SaleTableInfo { get; }
Property Value
Type Description
SaleTableInfo

SaleTypeTableInfo

Get CurrencyTableInfo

Declaration
public SaleTypeTableInfo SaleTypeTableInfo { get; }
Property Value
Type Description
SaleTypeTableInfo

TextTableInfo

Get TextTableInfo

Declaration
public TextTableInfo TextTableInfo { get; }
Property Value
Type Description
TextTableInfo

Methods

ParseQueryStructure(int, bool)

Load builds the select-structure for the current list. If we have restrictions on contact_id, we give it as in-parameter.

Declaration
protected virtual void ParseQueryStructure(int contactid, bool retired)
Parameters
Type Name Description
int contactid

Restriction on contact_id.

bool retired

True: Get all persons. False: do not get the retired people

ToSaleListAsync(CancellationToken)

ToSaleList creates the person list based on the information that is contained in its class.

Declaration
public Task<SaleList> ToSaleListAsync(CancellationToken cancellationToken = default)
Parameters
Type Name Description
CancellationToken cancellationToken
Returns
Type Description
Task<SaleList>

The contact list.

Implements

ICloneable

Extension Methods

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