Class PhoneSearchProvider

Search phone numbers for matching stripped numbers, across person and contacts. Return company name + department, or person name. Use AdditionInfo to restrict search to just Person or Contact phone numbers using "P" or "C".

Inheritance
System.Object
AnyTableListProviderBase
PhoneSearchProvider
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: SuperOffice.CRM.Lists
Assembly: SoDataBase.dll
Syntax
[MDOProviderPlugin("phonesearch")]
[MDOAdditionalInfo("Person only search", "P")]
[MDOAdditionalInfo("Company only search", "C")]
public class PhoneSearchProvider : AnyTableListProviderBase, ISoListProvider, ISoList, IPlugin
Remarks

Returns: list item with

id = person or contact id

Name = company name + phone number or person name + company name + phone number

ExtraInfo + Tooltip = GSM formatted phone number (with country prefix)

Full Name = person name or company name

Type = "Person" or "Contact"

IconHint = "Person" or "Contact"

Constructors

PhoneSearchProvider()

Constructor

Declaration
public PhoneSearchProvider()

Fields

_contactTable

Declaration
protected ContactTableInfo _contactTable
Field Value
Type Description
ContactTableInfo

_personContactTable

Declaration
protected ContactTableInfo _personContactTable
Field Value
Type Description
ContactTableInfo

_personTable

Declaration
protected PersonTableInfo _personTable
Field Value
Type Description
PersonTableInfo

_phoneTable

Declaration
protected PhoneTableInfo _phoneTable
Field Value
Type Description
PhoneTableInfo

ProviderName

Declaration
public const string ProviderName = "phonesearch"
Field Value
Type Description
System.String

Properties

TableInfo

The main table info for the query.

Declaration
protected override TableInfo TableInfo { get; }
Property Value
Type Description
TableInfo
Overrides

Methods

GetMainQuery()

Obtain the main query for the Phone search

Declaration
protected override Select GetMainQuery()
Returns
Type Description
Select

Query for the Phone
Overrides

Init()

Declaration
protected override void Init()
Overrides

OnRead(SoDataReader, Int16)

Declaration
protected override ISoListItem OnRead(SoDataReader reader, short lastRank)
Parameters
Type Name Description
SoDataReader reader
System.Int16 lastRank
Returns
Type Description
ISoListItem
Overrides

SetSearchRestriction(Select, String)

Set the search restriction on the list.

Declaration
protected override void SetSearchRestriction(Select sql, string searchValue)
Parameters
Type Name Description
Select sql

Query to set the search restriction on.
System.String searchValue

The value of the search restriction.
Overrides

Implements

Extension Methods

EnumUtil.MapEnums<From, To>(From)