Show / Hide Table of Contents

Class ListTableRows.CustomSearch

Class representing a custom search against table 'Category'.

Inheritance
object
SqlCommand
PrivateSelect
IdxBase
ListTableRows.TableRowsIdx
ListTableRows.CustomSearch
Implements
ICloneable
ISentryIgnorable
Inherited Members
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.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()
Namespace: SuperOffice.CRM.Lists
Assembly: SoDataBase.dll
Syntax
public sealed class ListTableRows.CustomSearch : ListTableRows.TableRowsIdx, ICloneable, ISentryIgnorable

Constructors

CustomSearch(TableInfo)

Constructor for class TableRows.CustomSearch. This class represents a custom search against table defined with tableInfo

Declaration
public CustomSearch(TableInfo tableInfo)
Parameters
Type Name Description
TableInfo tableInfo

TableInfo to create a custom search against

Remarks

By adding restrictions and order by information, a custom query can be formatted against the database.
If this is not added, all the rows in the table are returned.

Properties

InnerJoinRestriction

Implementation of the join-restriction.

Declaration
protected override JoinRestriction InnerJoinRestriction { get; }
Property Value
Type Description
JoinRestriction
Overrides
IdxBase.InnerJoinRestriction

InnerOrderBy

Implementation of the OrderBy clause.

Declaration
protected override OrderBy InnerOrderBy { get; }
Property Value
Type Description
OrderBy
Overrides
IdxBase.InnerOrderBy

InnerRestriction

Restriction (e.g. sql: WHERE) for the select statement.

Declaration
protected override Restriction InnerRestriction { get; }
Property Value
Type Description
Restriction

RestrictionObject holding the restrictions for the select statement.

Overrides
PrivateSelect.InnerRestriction

JoinRestriction

Joinrestriction for the select-statement.

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

OrderBy

Implementation of the OrderBy clause.

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

Restriction

Restriction (e.g. sql: WHERE) for the select statement.

Declaration
public Restriction Restriction { get; set; }
Property Value
Type Description
Restriction

RestrictionObject holding the restrictions for the select statement.

TableInfo

Get the TableInfo for the custom search.

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

Instance of TableInfo

Methods

RestrictionAnd(Restriction)

Add a restriction to the current one, using the And binding. If there is no current restriction, the incoming one becomes the current restriction.

Declaration
public void RestrictionAnd(Restriction newRestriction)
Parameters
Type Name Description
Restriction newRestriction

Restriction to add

RestrictionOr(Restriction)

Add a restriction to the current one, using the Or binding. If there is no current restriction, the incoming one becomes the current restriction.

Declaration
public void RestrictionOr(Restriction newRestriction)
Parameters
Type Name Description
Restriction newRestriction

Restriction to add

UpdateRow(TableRowBase)

Update the TableRow with the values from the index.

Declaration
public override void UpdateRow(TableRowBase row)
Parameters
Type Name Description
TableRowBase row

The row to update. This must be an instance of TableRow.

Overrides
IdxBase.UpdateRow(TableRowBase)
Remarks

This method does nothing for a the CustomSearch class.

Implements

ICloneable
ISentryIgnorable

Extension Methods

EnumUtil.MapEnums<From, To>(From)
Converters.MapEnums<From, To>(From)
QueryExectionExtensions.ExecuteNonQuery(SqlCommand)
QueryExectionExtensions.ExecuteNonQueryAsync(SqlCommand, CancellationToken)
QueryExectionExtensions.ExecuteReader(SqlCommand, bool)
QueryExectionExtensions.ExecuteReaderAsync(SqlCommand, bool, CancellationToken)
QueryExectionExtensions.ExecuteScalarAsync<T>(SqlCommand, bool, CancellationToken)
QueryExectionExtensions.ExecuteScalarAsync<T>(SqlCommand, CancellationToken)
QueryExectionExtensions.ExecuteScalar<T>(SqlCommand)
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top