Class ProjectEventList.ProjectEventListQuery

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

ProjectEventList.ProjectEventListQuery

ProjectEventList.CustomSearch

ProjectEventList.FromProject

Implements

ICloneable

Inherited Members

ListSelect._restriction

ListSelect._joinRestriction

ListSelect._fields

ListSelect._orderBy

ListSelect._groupBy

ListSelect.CreateListReader(SoConnection, PrivateSelect, params Sentry[])

ListSelect.CreateListReader(SoConnection, PrivateSelect, int, 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 ProjectEventList.ProjectEventListQuery : ListSelect, ICloneable

Fields

_assPersonTableInfo

The PersonTableInfo to use in the list (associate).

Declaration

protected PersonTableInfo _assPersonTableInfo

Field Value

Type	Description
PersonTableInfo

_associateTableInfo

The AssociateTableInfo to use in the list.

Declaration

protected AssociateTableInfo _associateTableInfo

Field Value

Type	Description
AssociateTableInfo

_audienceConfigTableInfo

The AudienceConfigTableInfo to use in the list.

Declaration

protected AudienceConfigTableInfo _audienceConfigTableInfo

Field Value

Type	Description
AudienceConfigTableInfo

_audienceLayoutLinkTableInfo

The AudienceLayoutLinkTableInfo to use in the list.

Declaration

protected AudienceLayoutLinkTableInfo _audienceLayoutLinkTableInfo

Field Value

Type	Description
AudienceLayoutLinkTableInfo

_audienceLayoutTableInfo

The AudienceLayoutTableInfo to use in the list.

Declaration

protected AudienceLayoutTableInfo _audienceLayoutTableInfo

Field Value

Type	Description
AudienceLayoutTableInfo

_audienceVisibilityTableInfo

The AudienceVisibilityTableInfo to use in the list.

Declaration

protected AudienceVisibilityTableInfo _audienceVisibilityTableInfo

Field Value

Type	Description
AudienceVisibilityTableInfo

_categoryTableNumber

Tablenumber for Category table

Declaration

protected int _categoryTableNumber

Field Value

Type	Description
int

_dynamicTableInfo

Used for linking in a table dynamically

TableInfo ti = SoDatabase.GetCurrent().Dictionary.GetFromTableNumber(5).GetTableInfo();

Declaration

protected TableInfo _dynamicTableInfo

Field Value

Type	Description
TableInfo

_externalEventTableInfo

The ExternalEventTableInfo to use in the list.

Declaration

protected ExternalEventTableInfo _externalEventTableInfo

Field Value

Type	Description
ExternalEventTableInfo

_personInterestTableNumber

Tablenumber for PersonInterest table

Declaration

protected int _personInterestTableNumber

Field Value

Type	Description
int

_personTableInfo

The PersonTableInfo to use in the list.

Declaration

protected PersonTableInfo _personTableInfo

Field Value

Type	Description
PersonTableInfo

_projectMemberTableInfo

The ProjectMemberTableInfo to use in the list

Declaration

protected ProjectMemberTableInfo _projectMemberTableInfo

Field Value

Type	Description
ProjectMemberTableInfo

_projectMemberTableNumber

Tablenumber for ProjectMember table

Declaration

protected int _projectMemberTableNumber

Field Value

Type	Description
int

_projectTableInfo

The ProjectTableInfo to use in the list.

Declaration

protected ProjectTableInfo _projectTableInfo

Field Value

Type	Description
ProjectTableInfo

_projectTableNumber

Tablenumber for Project table

Declaration

protected int _projectTableNumber

Field Value

Type	Description
int

_publishTableInfo

The PublishTableInfo to use in the list.

Declaration

protected PublishTableInfo _publishTableInfo

Field Value

Type	Description
PublishTableInfo

_textTableInfo

The TextTableInfo to use in the list.

Declaration

protected TextTableInfo _textTableInfo

Field Value

Type	Description
TextTableInfo

_textTableInfoSignOffConfirmationText

The TextTableInfo to use in the list (SignOffConfirmationText).

Declaration

protected TextTableInfo _textTableInfoSignOffConfirmationText

Field Value

Type	Description
TextTableInfo

_textTableInfoSignOffText

The TextTableInfo to use in the list (SignOffText).

Declaration

protected TextTableInfo _textTableInfoSignOffText

Field Value

Type	Description
TextTableInfo

_textTableInfoSignOnConfirmationText

The TextTableInfo to use in the list (SignOnConfirmationText).

Declaration

protected TextTableInfo _textTableInfoSignOnConfirmationText

Field Value

Type	Description
TextTableInfo

_textTableInfoSignOnText

The AssociateTableInfo to use in the list (SignOnText).

Declaration

protected TextTableInfo _textTableInfoSignOnText

Field Value

Type	Description
TextTableInfo

Methods

ParseQueryStructure(int, int)

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

Declaration

protected virtual void ParseQueryStructure(int projectId, int personId)

Parameters

Type	Name	Description
int	projectId	Restriction on project_id.
int	personId	Restriction on person_id.

ToProjectEventList()

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

Declaration

public ProjectEventList ToProjectEventList()

Returns

Type	Description
ProjectEventList	The person list.

Operators

implicit operator ProjectEventList(ProjectEventListQuery)

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

Declaration

public static implicit operator ProjectEventList(ProjectEventList.ProjectEventListQuery q)

Parameters

Type	Name	Description
ProjectEventList.ProjectEventListQuery	q	The query we want to build the person list on.

Returns

Type	Description
ProjectEventList	Person list based on the in-parameter.

Implements

ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)

Converters.MapEnums<From, To>(From)

QueryExectionExtensions.ExecuteNonQuery(SqlCommand)

QueryExectionExtensions.ExecuteReader(SqlCommand, bool)

QueryExectionExtensions.ExecuteScalar<T>(SqlCommand)