Class CustomTableRow<TTableInfo>.CustomSearch
Class representing a custom search against the table. Use this class to create a query that is pre-populated with the correct TableInfo and return fields; you can then add your own restrictions and other clauses to the query. The result will be a CustomTableRow. If your query matches more than one row in the database, the result will reflect the first row only.
Inherited Members
Namespace: SuperOffice.CRM.Rows
Assembly: SoDataBase.dll
Syntax
public sealed class CustomSearch : CustomTableRow<TTableInfo>.CustomTableRowIdx, ICloneable, ISentryIgnorableConstructors
CustomSearch(TTableInfo)
Constructor for class CustomTableRow.CustomSearch. This class represents a custom search against the table.
Declaration
public CustomSearch(TTableInfo tableInfo)Parameters
| Type | Name | Description |
|---|---|---|
| TTableInfo | tableInfo |
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
InnerOrderBy
Implementation of the OrderBy clause.
Declaration
protected override OrderBy InnerOrderBy { get; }Property Value
| Type | Description |
|---|---|
| OrderBy |
Overrides
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
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. |
Methods
RestrictionAnd(Restriction)
Calling this method is equivalent to the statement Restriction = Restriction.And( <argument> ), including protection against null Restrictions. Use it as a convenient shorthand if you are building complex restrictions out of smaller parts.
Declaration
public void RestrictionAnd(Restriction rightHandSide)Parameters
| Type | Name | Description |
|---|---|---|
| Restriction | rightHandSide | The right-hand side of the AND, the left-hand side is this objects' current Restriction. |
RestrictionOr(Restriction)
Calling this method is equivalent to the statement Restriction = Restriction.Or( <argument> ), including protection against null Restrictions. Use it as a convenient shorthand if you are building complex restrictions out of smaller parts.
Declaration
public void RestrictionOr(Restriction rightHandSide)Parameters
| Type | Name | Description |
|---|---|---|
| Restriction | rightHandSide | The right-hand side of the OR, the left-hand side is this objects' current Restriction. |
UpdateRow(TableRowBase)
Update the CustomTableRow 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 CustomTableRow. |
Overrides
Remarks
This method does nothing for a the CustomSearch class.