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.CreateListReader(SoConnection, PrivateSelect, Sentry[])
ListSelect.CreateListReader(SoConnection, PrivateSelect, Int32, 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.ForceJoinOrder
PrivateSelect.SqlType
SqlCommand.Origin
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 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(Int32, Boolean)

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
Int32 contactid

Restriction on contact_id.

Boolean retired

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

ToSaleList()

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

Declaration
public SaleList ToSaleList()
Returns
Type Description
SaleList

The contact list.

Operators

Implicit(SaleList.SaleListQuery to SaleList)

Implicit operator. Will return a contact list based on the in-parameter.

Declaration
public static implicit operator SaleList(SaleList.SaleListQuery q)
Parameters
Type Name Description
SaleList.SaleListQuery q

The query we want to build the person list on.

Returns
Type Description
SaleList

Contact list based on the in-parameter.

Implements

System.ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)
QueryExectionExtensions.ExecuteReader(SqlCommand, Boolean)
QueryExectionExtensions.ExecuteScalar<T>(SqlCommand)
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