Class SORCriteriaRecordData

POCO (Plain Old CLR Object) class that can be used to hold data corresponding to a row from the SORCriteria table.

Inheritance
object
SORCriteriaRecordData
Inherited Members
Namespace: SuperOffice.CRM.Rows
Assembly: SoDataBase.dll
Syntax
public class SORCriteriaRecordData
Remarks

Please use this class instead of a full SORCriteriaRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SORCriteriaTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Constructors

SORCriteriaRecordData()

POCO (Plain Old CLR Object) class that can be used to hold data corresponding to a row from the SORCriteria table.

Declaration
public SORCriteriaRecordData()
Remarks

Please use this class instead of a full SORCriteriaRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SORCriteriaTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Fields

FieldName

Database field name

Declaration
public string FieldName
Field Value
Type Description
string
Remarks

Please use this class instead of a full SORCriteriaRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SORCriteriaTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Locked

If 1, then this crierion is locked and its value cannot be changed outside of Reporter Studio

Declaration
public short Locked
Field Value
Type Description
short
Remarks

Please use this class instead of a full SORCriteriaRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SORCriteriaTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Registered

Registered when in UTC.

Declaration
public DateTime Registered
Field Value
Type Description
DateTime
Remarks

Please use this class instead of a full SORCriteriaRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SORCriteriaTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

RegisteredAssociateId

Registered by whom

Declaration
public int RegisteredAssociateId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SORCriteriaRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SORCriteriaTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

SORCriteriaId

Primary key

Declaration
public int SORCriteriaId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SORCriteriaRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SORCriteriaTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

SOROperatorsId

Operator foreign key

Declaration
public int SOROperatorsId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SORCriteriaRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SORCriteriaTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

SORPublishId

Owning publish name

Declaration
public int SORPublishId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SORCriteriaRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SORCriteriaTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Updated

Last updated when in UTC.

Declaration
public DateTime Updated
Field Value
Type Description
DateTime
Remarks

Please use this class instead of a full SORCriteriaRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SORCriteriaTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

UpdatedAssociateId

Last updated by whom

Declaration
public int UpdatedAssociateId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SORCriteriaRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SORCriteriaTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

UpdatedCount

Number of updates made to this record

Declaration
public short UpdatedCount
Field Value
Type Description
short
Remarks

Please use this class instead of a full SORCriteriaRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SORCriteriaTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

UseIt

1=criterion is in use, otherwise 0

Declaration
public short UseIt
Field Value
Type Description
short
Remarks

Please use this class instead of a full SORCriteriaRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SORCriteriaTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Value1

First part of value

Declaration
public string Value1
Field Value
Type Description
string
Remarks

Please use this class instead of a full SORCriteriaRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SORCriteriaTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Value2

Second part of value

Declaration
public string Value2
Field Value
Type Description
string
Remarks

Please use this class instead of a full SORCriteriaRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SORCriteriaTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

WhereOrder

relative order in where clause

Declaration
public short WhereOrder
Field Value
Type Description
short
Remarks

Please use this class instead of a full SORCriteriaRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding SORCriteriaTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Extension Methods