GetAll Method (ItemGrade)
- Last UpdatedNov 06, 2025
- 3 minute read
'Declaration
Public Shared Function GetAll( _
ByVal itemGradeCd As Nullable(Of Integer), _
ByVal itemGradeDesc As String, _
ByVal goodProd As Nullable(Of Boolean), _
ByVal scrapped As Nullable(Of Boolean), _
ByVal color As Nullable(Of Integer), _
ByVal pref As Nullable(Of Integer), _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date) _
) As DataSet
'Usage
Dim itemGradeCd As Nullable(Of Integer)
Dim itemGradeDesc As String
Dim goodProd As Nullable(Of Boolean)
Dim scrapped As Nullable(Of Boolean)
Dim color As Nullable(Of Integer)
Dim pref As Nullable(Of Integer)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = ItemGrade.GetAll(itemGradeCd, itemGradeDesc, goodProd, scrapped, color, pref, lastEditBy, lastEditAt)
public static DataSet GetAll(
Nullable<int> itemGradeCd,
string itemGradeDesc,
Nullable<bool> goodProd,
Nullable<bool> scrapped,
Nullable<int> color,
Nullable<int> pref,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- itemGradeCd
- Optional filter parameter. Holds the code of an item grade.
- itemGradeDesc
- Optional filter parameter. Holds the description of an item grade.
- goodProd
- Optional filter parameter. Holds a flag that specifies whether an item grade indicates good production (set to true) or a rejected item (set to false).
- scrapped
- Optional filter parameter. Holds a flag that specifies whether an item grade indicates a scrapped item (set to true) or normal consumption (set to false).
- color
- Optional filter parameter. Holds an integer that indicates the grade's RGB background color in the user interface.
- pref
- Holds a number that indicates the preference ordering of the grade. Used in shipping and consumption. Must be greater than 0. The default is 1.
- lastEditBy
- Optional filter parameter. Holds the ID of a user who added or last updated this type of record.
- lastEditAt
- Optional filter parameter. Holds a date/time when this type of record was added or last updated.
Return Value
Returns a DataSet that contains all the records in the Item_Grade 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 |
|---|---|
|
item_grade_cd |
An integer that is the grade code for an item. |
|
item_grade_desc |
A string that describes the grade of this item. |
|
good_prod |
A Boolean that is a flag that indicates whether this grade should be accounted as a good production. If no, then the item is accounted as a rejected item. |
|
scrapped |
A Boolean that is a flag that indicates whether this grade should be treated as scrapped. |
|
color |
An integer that indicates the background color for this grade description when displayed in the user interface. |
|
pref |
An integer that is the grade’s preference number. |
|
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 datetime that indicates when the record was added or last updated. |