GetAll(Nullable<Int32>,Nullable<Int32>,String,String,Nullable<DateTime>) Method
- Last UpdatedNov 06, 2025
- 3 minute read
'Declaration
Public Overloads Shared Function GetAll( _
ByVal lineId As Nullable(Of Integer), _
ByVal attrId As Nullable(Of Integer), _
ByVal attrValue As String, _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date) _
) As DataSet
'Usage
Dim lineId As Nullable(Of Integer)
Dim attrId As Nullable(Of Integer)
Dim attrValue As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = LineAttr.GetAll(lineId, attrId, attrValue, lastEditBy, lastEditAt)
public static DataSet GetAll(
Nullable<int> lineId,
Nullable<int> attrId,
string attrValue,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- lineId
- Optional filter parameter. Holds the ID of a line whose attribute records are being retrieved.
- attrId
- Optional filter parameter. Holds the ID of an attribute.
- attrValue
- Optional filter parameter. Holds the value of an attribute.
- lastEditBy
- Optional filter parameter. Holds the ID of a user who created or last updated a line attribute record.
- lastEditAt
- Optional filter parameter. Holds the date and time when a line attribute record was created or last updated.
Return Value
Returns a DataSet that contains all the records in the Line_Attr table that satisfy the specified filters. If no matching records are found, an empty DataSet is returned.
The columns of the returned DataSet are described below.
|
Column Name |
Description |
|---|---|
|
line_id |
An integer that is the ID of the line to which the attribute applies. |
|
line_name |
A string that is the name of the line to which the attribute applies. |
|
attr_id |
An integer that is the attribute ID. |
|
attr_desc |
A string that is the description of the attribute. |
|
attr_value |
A string that is the value for this attribute. The contents of this field depend on the data type specified in the data_type column. |
|
notes |
A string that is any notes for this attribute. |
|
predefined |
A boolean flag which specifies whether the attribute must be assigned from a predefined set of values. |
|
data_type |
An integer that is an enumeration that indicates the data type of the attribute, from the Attr table. 0 = string (<= 80 characters; the default data type) 1 = drop-down list of values defined in the Attr_Set table 2 = integer 3 = currency 4 = color 5 = datetime 6 = floating point number 7 = percent 8 = check box 9 = non-editable 10 = time of day 11 = item reason (only if attr_grp = 3) 12 = long string (> 80 characters) |
|
entry_type |
An integer that is an enumeration that indicates the type of entry to allow for this attribute, from the Attr table. 0 = value only (the default) 1 = notes only 2 = value and notes |
|
last_edit_comment |
A string that holds any comments about why record was added or last updated. |
|
last_edit_by |
A string that is the ID of the user who added or last updated this record. |
|
last_edit_at |
A datetime that is when the record was added or last updated. |