Show / Hide Table of Contents

Class PersonList.PersonListQuery

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
PersonList.PersonListQuery
PersonList.CustomSearch
PersonList.FromContact
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 PersonListQuery : ListSelect, ICloneable

Properties

AssociateTableInfo

Get AssociateTableInfo

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

CategoryTableInfo

Get CategoryTableInfo

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

ContactCategoryTableInfo

Get Contacts CategoryTableInfo

Declaration
public CategoryTableInfo ContactCategoryTableInfo { get; }
Property Value
Type Description
CategoryTableInfo

ContactFaxTableInfo

Get ContactFaxTableInfo

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

ContactPhoneTableInfo

Get ContactPhoneTableInfo

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

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

FaxPhoneTableInfo

Get FaxPhoneTableInfo

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

MobilePhoneTableInfo

Get MobilePhoneTableInfo

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

PersonInterestTableInfo

Get PersonInterestTableInfo

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

PersonTableInfo

Get PersonTableInfo

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

PersPosTableInfo

Get PersPosTableInfo

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

PhoneTableInfo

Get PhoneTableInfo

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

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

ToPersonList()

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

Declaration
public PersonList ToPersonList()
Returns
Type Description
PersonList

The person list.

Operators

Implicit(PersonList.PersonListQuery to PersonList)

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

Declaration
public static implicit operator PersonList(PersonList.PersonListQuery q)
Parameters
Type Name Description
PersonList.PersonListQuery q

The query we want to build the person list on.

Returns
Type Description
PersonList

Person 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