GetAll Method (ItemReas)
- Last UpdatedNov 06, 2025
- 3 minute read
'Declaration
Public Shared Function GetAll( _
ByVal reasCd As Nullable(Of Integer), _
ByVal reasDesc As String, _
ByVal reasGrpId As Nullable(Of Integer), _
ByVal itemGradeCd As Nullable(Of Integer), _
ByVal itemStatusCd As Nullable(Of Integer), _
ByVal reasGrpType As Nullable(Of Integer), _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date) _
) As DataSet
'Usage
Dim reasCd As Nullable(Of Integer)
Dim reasDesc As String
Dim reasGrpId As Nullable(Of Integer)
Dim itemGradeCd As Nullable(Of Integer)
Dim itemStatusCd As Nullable(Of Integer)
Dim reasGrpType As Nullable(Of Integer)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = ItemReas.GetAll(reasCd, reasDesc, reasGrpId, itemGradeCd, itemStatusCd, reasGrpType, lastEditBy, lastEditAt)
public static DataSet GetAll(
Nullable<int> reasCd,
string reasDesc,
Nullable<int> reasGrpId,
Nullable<int> itemGradeCd,
Nullable<int> itemStatusCd,
Nullable<int> reasGrpType,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- reasCd
- Optional filter parameter. Holds the code that identifies a reason.
- reasDesc
- Optional filter parameter. Holds the description of a reason.
- reasGrpId
- Optional filter parameter. Holds the ID of the reason group for an item reason.
- itemGradeCd
- Optional filter parameter. Holds the item grade code for an item reason.
- itemStatusCd
- Optional filter parameter. Holds the item status code for an item reason.
- reasGrpType
- Optional filter parameter. Holds a reason group type.
- 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_Reas 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 |
|---|---|
|
reas_cd |
An integer that is the item reason code. |
|
reas_desc |
A string that is the description of the item reason. |
|
reas_grp_id |
An integer that is the ID of the item reason group |
|
reas_grp_desc |
A string that is the description of the item reason group, from the item_reas_grp.reas_grp_desc column linked to this reason. |
|
item_grade_cd |
An integer that is the item grade code for this reason. |
|
item_grade_desc |
A string that is the unique item grade description, from the item_grade.item_grade_desc column linked to this reason. |
|
good_prod |
A Boolean that is a flag that indicates whether this item reason is used for good production, from the item_grade.good_prod column. |
|
scrapped |
A Boolean that is a flag that indicates whether this item reason is used for scrap production, from the item_grade.scrapped column. |
|
Item_grade_color |
An integer that indicates the background color for this item grade when displayed in user interface, from the item_grade.color column. |
|
item_status_desc |
A string that is description of the item state, from the item_state.item_status_desc column. |
|
item_state_color |
An integer that indicates the background color for this state description when displayed in the user interface, from the item_state.color column. |
|
reas_grp_type |
An integer that is the reason group type, from the item_reas_grp.reas_grp_type column:
|
|
display_seq |
An integer that is the display sequence of this item reason. |
|
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. |