GetAll Method (SubLotLevelDesc)
- Last UpdatedNov 06, 2025
- 2 minute read
The GetAll() method retrieves one or more sublot level description records from the Sublot_Level_Desc table, as specified by the filter parameters. Passing no filter parameters will retrieve all sublot level description records from the table.
'Declaration
Public Shared Function GetAll( _
ByVal itemId As String, _
ByVal level As Nullable(Of Integer), _
ByVal levelDesc As String, _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date) _
) As DataSet
'Usage
Dim itemId As String
Dim level As Nullable(Of Integer)
Dim levelDesc As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = SubLotLevelDesc.GetAll(itemId, level, levelDesc, lastEditBy, lastEditAt)
public static DataSet GetAll(
string itemId,
Nullable<int> level,
string levelDesc,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- itemId
- Optional filter parameter. Holds the item_id of sublot level(s) that store the item.
- level
- Optional filter parameter. Holds the sublot level.
- levelDesc
- Optional filter parameter. Holds the sublot level description.
- lastEditBy
- Optional filter parameter. Holds the ID of the user who added or last changed the record.
- lastEditAt
- Optional filter parameter. Holds the date/time when the record was added or last updated.
Return Value
Returns a DataSet that contains all the records in the Sublot_Level_Desc 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 Names |
Description |
|---|---|
|
item_id |
A string that is the ID of the item. |
|
lvl |
A string that is the level of the sublot. |
|
lvl_desc |
A string that is the description of the sublot level. |
|
last_edit_comment |
A string that contains comments about why the record was added or updated. |
|
last_edit_by |
A string that is the ID of the user who added or last updated this record. |
|
last_edit_at |
A date/time that indicates when the record was added or last updated. |