GetAll Method (JobBomDefault)
- Last UpdatedNov 06, 2025
- 2 minute read
The GetAll() method retrieves one or more job BOM default records from the Job_Bom_Default table, as specified by the filter parameters. Passing no filter parameters will retrieve all job BOM default records from the table.
'Declaration
Public Shared Function GetAll( _
ByVal itemId As String, _
ByVal entId As Nullable(Of Integer), _
ByVal bomPos As Nullable(Of Integer), _
ByVal storageEntId As Nullable(Of Integer), _
ByVal rejectEntId As Nullable(Of Integer), _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date) _
) As DataSet
'Usage
Dim itemId As String
Dim entId As Nullable(Of Integer)
Dim bomPos As Nullable(Of Integer)
Dim storageEntId As Nullable(Of Integer)
Dim rejectEntId As Nullable(Of Integer)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = JobBomDefault.GetAll(itemId, entId, bomPos, storageEntId, rejectEntId, lastEditBy, lastEditAt)
public static DataSet GetAll(
string itemId,
Nullable<int> entId,
Nullable<int> bomPos,
Nullable<int> storageEntId,
Nullable<int> rejectEntId,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- itemId
Optional filter parameter. Holds the ID of a component item.
- entId
Optional filter parameter. Holds the ID of an entity on which the job is scheduled or run.
- bomPos
Optional filter parameter. Holds a BOM position.
- storageEntId
Optional filter parameter. Holds the ID of a storage entity that is used to store good production.
- rejectEntId
Optional filter parameter. Holds the ID of a storage entity that is used to store rejected production.
- lastEditBy
Optional filter parameter. Holds the ID of the user who added or last updated a job BOM default record.
- lastEditAt
Optional filter parameter. Holds the date/time when a job BOM default record was added or last updated.
Return Value
Returns a DataSet that contains all the records in the Job_Bom_Default 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.
|
ColumnName |
Description |
|---|---|
|
item_id |
A string that is the ID of the component item. |
|
ent_id |
A string that is the ID of the entity on which job is scheduled or run. |
|
bom_pos |
An integer that is the BOM position. |
|
storage_ent_id |
An integer that is the ID of the storage entity that is used to store items or by-products. |
|
reject_ent_id |
An integer that is the ID of the entity to store rejected production items. If set to null, the Def_Storage_Ent_Id is used. |
|
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. |