Show / Hide Table of Contents

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, 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 ProjectEventListQuery : ListSelect, ICloneable

Fields

_associateTableInfo

The AssociateTableInfo to use in the list.

Declaration
protected AssociateTableInfo _associateTableInfo
Field Value
Type Description
AssociateTableInfo

_assPersonTableInfo

The PersonTableInfo to use in the list (associate).

Declaration
protected PersonTableInfo _assPersonTableInfo
Field Value
Type Description
PersonTableInfo

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

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

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

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

_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(Int32, Int32)

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

Restriction on project_id.

Int32 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(ProjectEventList.ProjectEventListQuery to ProjectEventList)

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

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