Show / Hide Table of Contents

Class ContactList.ContactListQuery

PersonListQuery 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
ContactList.ContactListQuery
ContactList.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.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.Archives
Assembly: SoDataBase.dll
Syntax
public abstract class ContactListQuery : 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

EmailTableInfo

Get EmailTableInfo

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

PersonTableInfo

Get PersonTableInfo

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

PhoneTableInfo

Get PhoneTableInfo

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

PostalAddressTableInfo

Get PostalAddressTableInfo

Declaration
public AddressTableInfo PostalAddressTableInfo { get; }
Property Value
Type Description
AddressTableInfo

StreetAddressTableInfo

Get StreetAddressTableInfo

Declaration
public AddressTableInfo StreetAddressTableInfo { get; }
Property Value
Type Description
AddressTableInfo

URLTableInfo

Get URLTableInfo

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

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 includeOwnerInfo)
Parameters
Type Name Description
Int32 contactid

Restriction on contact_id.

Boolean includeOwnerInfo

If true we get person info for the contacts owning associate.

ToContactList()

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

Declaration
public ContactList ToContactList()
Returns
Type Description
ContactList

The contact list.

Operators

Implicit(ContactList.ContactListQuery to ContactList)

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

Declaration
public static implicit operator ContactList(ContactList.ContactListQuery q)
Parameters
Type Name Description
ContactList.ContactListQuery q

The query we want to build the person list on.

Returns
Type Description
ContactList

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.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