Class PriceListProvider

List of pricelists from the PriceList table. Supported values in the AdditionalInfo:

  • alltrue|false. If true is specified, inactive items is also returned.
  • QuoteConnectionIdGets items for a specific Quote connection. If not specified, only SuperOffice pricelists (where IsErpCopy=false) will be returned.
AdditionalInfo string: "all=true&QuoteConnectionId=2"
Inheritance
Object
AnyTableListProviderBase
PriceListProvider
Inherited Members
Namespace: SuperOffice.CRM.Lists
Assembly: SoDataBase.dll
Syntax
[MDOProviderPlugin("PriceList")]
[MDOAdditionalInfoSeparator("&")]
[MDOAdditionalInfo("all", "Return all pricelists, not just the active ones", true)]
[MDOAdditionalInfo("quoteconnectionid", "Return only pricelists on the given connection", 123)]
public class PriceListProvider : AnyTableListProviderBase, ISoListProvider, ISoList, IPlugin

Constructors

PriceListProvider()

List of pricelists from the PriceList table. Supported values in the AdditionalInfo:

  • alltrue|false. If true is specified, inactive items is also returned.
  • QuoteConnectionIdGets items for a specific Quote connection. If not specified, only SuperOffice pricelists (where IsErpCopy=false) will be returned.
AdditionalInfo string: "all=true&QuoteConnectionId=2"
Declaration
public PriceListProvider()

Fields

ProviderName

The name of the provider.

Declaration
public const string ProviderName = "PriceList"
Field Value
Type Description
String

Properties

TableInfo

List of pricelists from the PriceList table. Supported values in the AdditionalInfo:

  • alltrue|false. If true is specified, inactive items is also returned.
  • QuoteConnectionIdGets items for a specific Quote connection. If not specified, only SuperOffice pricelists (where IsErpCopy=false) will be returned.
AdditionalInfo string: "all=true&QuoteConnectionId=2"
Declaration
protected override TableInfo TableInfo { get; }
Property Value
Type Description
TableInfo
Overrides

Methods

GetMainQuery()

List of pricelists from the PriceList table. Supported values in the AdditionalInfo:

  • alltrue|false. If true is specified, inactive items is also returned.
  • QuoteConnectionIdGets items for a specific Quote connection. If not specified, only SuperOffice pricelists (where IsErpCopy=false) will be returned.
AdditionalInfo string: "all=true&QuoteConnectionId=2"
Declaration
protected override Select GetMainQuery()
Returns
Type Description
Select
Overrides

Init()

List of pricelists from the PriceList table. Supported values in the AdditionalInfo:

  • alltrue|false. If true is specified, inactive items is also returned.
  • QuoteConnectionIdGets items for a specific Quote connection. If not specified, only SuperOffice pricelists (where IsErpCopy=false) will be returned.
AdditionalInfo string: "all=true&QuoteConnectionId=2"
Declaration
protected override void Init()
Overrides

OnRead(SoDataReader, Int16)

List of pricelists from the PriceList table. Supported values in the AdditionalInfo:

  • alltrue|false. If true is specified, inactive items is also returned.
  • QuoteConnectionIdGets items for a specific Quote connection. If not specified, only SuperOffice pricelists (where IsErpCopy=false) will be returned.
AdditionalInfo string: "all=true&QuoteConnectionId=2"
Declaration
protected override ISoListItem OnRead(SoDataReader reader, short lastRank)
Parameters
Type Name Description
SoDataReader reader
Int16 lastRank
Returns
Type Description
ISoListItem
Overrides

SetSearchRestriction(Select, String)

List of pricelists from the PriceList table. Supported values in the AdditionalInfo:

  • alltrue|false. If true is specified, inactive items is also returned.
  • QuoteConnectionIdGets items for a specific Quote connection. If not specified, only SuperOffice pricelists (where IsErpCopy=false) will be returned.
AdditionalInfo string: "all=true&QuoteConnectionId=2"
Declaration
protected override void SetSearchRestriction(Select sql, string searchValue)
Parameters
Type Name Description
Select sql
String searchValue
Overrides

Implements

Extension Methods

EnumUtil.MapEnums<From, To>(From)