GetAll Method (ItemClass)
- Last UpdatedNov 06, 2025
- 4 minute read
'Declaration
Public Shared Function GetAll( _
ByVal itemClassId As String, _
ByVal itemClassDesc As String, _
ByVal produced As Nullable(Of Boolean), _
ByVal consumed As Nullable(Of Boolean), _
ByVal obsolete As Nullable(Of Boolean), _
ByVal purchased As Nullable(Of Boolean), _
ByVal sold As Nullable(Of Boolean), _
ByVal lotNoFormat As String, _
ByVal lastLotNo As String, _
ByVal subLotNoFormat As String, _
ByVal lastSubLotNo As String, _
ByVal serialNoLvl As Nullable(Of Integer), _
ByVal invUniqueByJob As Nullable(Of Boolean), _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date) _
) As DataSet
'Usage
Dim itemClassId As String
Dim itemClassDesc As String
Dim produced As Nullable(Of Boolean)
Dim consumed As Nullable(Of Boolean)
Dim obsolete As Nullable(Of Boolean)
Dim purchased As Nullable(Of Boolean)
Dim sold As Nullable(Of Boolean)
Dim lotNoFormat As String
Dim lastLotNo As String
Dim subLotNoFormat As String
Dim lastSubLotNo As String
Dim serialNoLvl As Nullable(Of Integer)
Dim invUniqueByJob As Nullable(Of Boolean)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = ItemClass.GetAll(itemClassId, itemClassDesc, produced, consumed, obsolete, purchased, sold, lotNoFormat, lastLotNo, subLotNoFormat, lastSubLotNo, serialNoLvl, invUniqueByJob, lastEditBy, lastEditAt)
public static DataSet GetAll(
string itemClassId,
string itemClassDesc,
Nullable<bool> produced,
Nullable<bool> consumed,
Nullable<bool> obsolete,
Nullable<bool> purchased,
Nullable<bool> sold,
string lotNoFormat,
string lastLotNo,
string subLotNoFormat,
string lastSubLotNo,
Nullable<int> serialNoLvl,
Nullable<bool> invUniqueByJob,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- itemClassId
- Optional filter parameter. Holds the ID of the item class.
- itemClassDesc
- Optional filter parameter. Holds the description of a item class.
- produced
- Optional filter parameter. Holds a flag that specifies whether to include item classes that can have produced items. The flag indicate the type of items contained in the item class.
- consumed
- Optional filter parameter. Holds a flag that specifies whether to include item classes that can have consumed items. The flag indicate the type of items contained in the item class.
- obsolete
- Optional filter parameter. Holds a flag that specifies whether to include item classes that can have obsolete items. The flag indicate the type of items contained in the item class.
- purchased
- Optional filter parameter. Holds a flag that specifies whether to include item classes that can have purchased items. The flag indicate the type of items contained in the item class.
- sold
- Optional filter parameter. Holds a flag that specifies whether an item class can have produced items. The flag indicate the type of items contained in the item class.
- lotNoFormat
- Optional filter parameter. Holds the format of a lot number.
- lastLotNo
- Optional filter parameter. Holds the last lot number that was used for an item.
- subLotNoFormat
- Optional filter parameter. Holds the format of a sublot number.
- lastSubLotNo
- Optional filter parameter. Holds the last sublot number that was used for an item.
- serialNoLvl
- Optional filter parameter. Holds the items based on the specified level.
- invUniqueByJob
- Optional filter parameter. Holds a flag that specifies whether a class's item inventory is unique by job.
- 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_Class 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_class_id |
A string that is the ID of the item class is returned. |
|
item_class_desc |
A string that is the description of the item class is returned. |
|
produced |
A Boolean that is a flag that indicates whether this class contains produced items. |
|
consumed |
A Boolean that is a flag that indicates whether this class contains consumed items. |
|
obsolete |
A Boolean that is a flag that indicates whether this class is obsolete. |
|
purchased |
A Boolean that is a flag that indicates whether items of this class are purchased. |
|
sold |
A Boolean that is a flag that indicates whether items of this class are sold. |
|
lot_no_format |
A string that is the default lot number format for the items that belongs to this class. |
|
last_lot_no |
A string that is the last assigned lot number to any of its items. |
|
sublot_no_format |
A string that is the default sublot number format for the items that belong to this class. |
|
last_sublot_no |
A string that is the last assigned sublot number to any of the items in this item class. |
|
serial_no_lvl |
An integer that is the default serial number level when creating items for this class. |
|
inv_unique_by_job |
A Boolean that indicates whether inventory quantities for this class are uniquely identified by the job that produced them, in addition to ent_id, item_id, lot_no, and sublot_no. |
|
spare1 |
A string that is the contents of the user-defined spare1 field. |
|
spare2 |
A string that is the contents of the user-defined spare2 field. |
|
spare3 |
A string that is the contents of the user-defined spare3 field. |
|
spare4 |
A string that is the contents of the user-defined spare4 field. |
|
last_edit_comment |
A string that contains comments about why the record was added or changed. |
|
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. |