Class SORFCTRecordData

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

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

Please use this class instead of a full SORFCTRow 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 SORFCTTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Constructors

SORFCTRecordData()

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

Declaration
public SORFCTRecordData()
Remarks

Please use this class instead of a full SORFCTRow 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 SORFCTTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Fields

AggregateFunction

-1=NULL, 0=Sum, 1=Count, 2=Avg, 3=Max, 4=Min

Declaration
public short AggregateFunction
Field Value
Type Description
short
Remarks

Please use this class instead of a full SORFCTRow 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 SORFCTTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Caption

row/column headers

Declaration
public string Caption
Field Value
Type Description
string
Remarks

Please use this class instead of a full SORFCTRow 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 SORFCTTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

CaptionResId

resource id if translatable resource

Declaration
public uint CaptionResId
Field Value
Type Description
uint
Remarks

Please use this class instead of a full SORFCTRow 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 SORFCTTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Content

if field type in (0,1,2,3) then Field name from db to be selected

Declaration
public string Content
Field Value
Type Description
string
Remarks

Please use this class instead of a full SORFCTRow 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 SORFCTTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

DisplayType

-1=NULL, 0=Normal, 1=column

Declaration
public short DisplayType
Field Value
Type Description
short
Remarks

Please use this class instead of a full SORFCTRow 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 SORFCTTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

FieldType

-1=NULL, 0=hidden, 1=Column, 2=Row, 3=Data, 6=pagenr, 7=title, 8=associatename

Declaration
public short FieldType
Field Value
Type Description
short
Remarks

Please use this class instead of a full SORFCTRow 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 SORFCTTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

GroupFooterType

-1=NULL, 0=none, 1=Sum, 2=Avg, 3=Count

Declaration
public short GroupFooterType
Field Value
Type Description
short
Remarks

Please use this class instead of a full SORFCTRow 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 SORFCTTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

NumberFormat

Formatting for data strings, like #0, #000.00 etc

Declaration
public string NumberFormat
Field Value
Type Description
string
Remarks

Please use this class instead of a full SORFCTRow 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 SORFCTTableInfo 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 SORFCTRow 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 SORFCTTableInfo 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 SORFCTRow 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 SORFCTTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

SORFCTId

Primary key

Declaration
public int SORFCTId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SORFCTRow 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 SORFCTTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

SORSectionId

Foreign key to Section

Declaration
public int SORSectionId
Field Value
Type Description
int
Remarks

Please use this class instead of a full SORFCTRow 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 SORFCTTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

TotalsCaption

Caption for totals row/column headers

Declaration
public string TotalsCaption
Field Value
Type Description
string
Remarks

Please use this class instead of a full SORFCTRow 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 SORFCTTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

TotalsResId

resource id if translatable resource

Declaration
public uint TotalsResId
Field Value
Type Description
uint
Remarks

Please use this class instead of a full SORFCTRow 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 SORFCTTableInfo 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 SORFCTRow 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 SORFCTTableInfo 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 SORFCTRow 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 SORFCTTableInfo 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 SORFCTRow 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 SORFCTTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Extension Methods