Class ActivityList.ActivityListQuery

ActivityListQuery is a nested class containing the necessary information to provide its outer class with enough information to build the list.

Inheritance

object

SqlCommand

TableExpression

ActivityList.ActivityListQuery

ActivityList.FromContact

ActivityList.FromProject

Inherited Members

TableExpression.GetTableInfos()

TableExpression.Add(params Select[])

TableExpression.TableExp

TableExpression.TableExpOrderBy

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.ToString()

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 ActivityList.ActivityListQuery : TableExpression

Fields

_a

The AppointmentTableInfo to use in the list.

Declaration

protected AppointmentTableInfo _a

Field Value

Type	Description
AppointmentTableInfo

_ass

The AssociateTableInfo to use in the list.

Declaration

protected AssociateTableInfo _ass

Field Value

Type	Description
AssociateTableInfo

_assRegistered

The AssociateTableInfo to use in the list for the user who created the appointment.

Declaration

protected AssociateTableInfo _assRegistered

Field Value

Type	Description
AssociateTableInfo

_associates

Associates of interest.

Declaration

protected int[] _associates

Field Value

Type	Description
int[]

_contact_id

The contact of interest.

Declaration

protected int _contact_id

Field Value

Type	Description
int

_d

The DocumentTableInfo to use in the list.

Declaration

protected DocumentTableInfo _d

Field Value

Type	Description
DocumentTableInfo

_date

What kind of time period do we want to look at?

Declaration

protected DateTimeSearchType _date

Field Value

Type	Description
DateTimeSearchType

_dt

The DocTmplTableInfo to use in the list.

Declaration

protected DocTmplTableInfo _dt

Field Value

Type	Description
DocTmplTableInfo

_dummyParameter

Dummy parameter. Used as null-value in the queries.

Declaration

protected Parameter _dummyParameter

Field Value

Type	Description
Parameter

_endDate

Enddate (and time) for DateTimeSearchType-less queries.

Declaration

protected DateTime _endDate

Field Value

Type	Description
DateTime

_p

The PersonTableInfo to use in the list.

Declaration

protected PersonTableInfo _p

Field Value

Type	Description
PersonTableInfo

_personRegistered

The AssociateTableInfo to use in the list for the user who created the appointment.

Declaration

protected PersonTableInfo _personRegistered

Field Value

Type	Description
PersonTableInfo

_pr

The ProjectTableInfo to use in the list.

Declaration

protected ProjectTableInfo _pr

Field Value

Type	Description
ProjectTableInfo

_prob

The ProbTableInfo to use in the list.

Declaration

protected ProbTableInfo _prob

Field Value

Type	Description
ProbTableInfo

_project_id

Project of interest.

Declaration

protected int _project_id

Field Value

Type	Description
int

_s

The SaleTableInfo to use in the list.

Declaration

protected SaleTableInfo _s

Field Value

Type	Description
SaleTableInfo

_startDate

Startdate (and time) for DateTimeSearchType-less queries.

Declaration

protected DateTime _startDate

Field Value

Type	Description
DateTime

_t

The TextTableInfo to use in the list.

Declaration

protected TextTableInfo _t

Field Value

Type	Description
TextTableInfo

_ta

The TaskTableInfo to use in the list.

Declaration

protected TaskTableInfo _ta

Field Value

Type	Description
TaskTableInfo

_type

How to filter information.

Declaration

protected ArchiveFilterType _type

Field Value

Type	Description
ArchiveFilterType

Properties

SqlType

SqlType

Declaration

public override SqlType SqlType { get; }

Property Value

Type	Description
SqlType

Overrides

SqlCommand.SqlType

Methods

ToActivityList()

ToActivityList creates the ActivityList based on the information that is contained in its class.

Declaration

public ActivityList ToActivityList()

Returns

Type	Description
ActivityList	The ActivityList.

Operators

implicit operator ActivityList(ActivityListQuery)

Implicit operator. Will return an ActivityList based on the in-parameter.

Declaration

public static implicit operator ActivityList(ActivityList.ActivityListQuery q)

Parameters

Type	Name	Description
ActivityList.ActivityListQuery	q	The query we want to build the ActivityList on.

Returns

Type	Description
ActivityList	ActivityList based on the in-parameter.

Extension Methods

EnumUtil.MapEnums<From, To>(From)

Converters.MapEnums<From, To>(From)

QueryExectionExtensions.ExecuteNonQuery(SqlCommand)

QueryExectionExtensions.ExecuteReader(SqlCommand, bool)

QueryExectionExtensions.ExecuteScalar<T>(SqlCommand)