GetAll Method (LaborExec)
- Last UpdatedNov 06, 2025
- 3 minute read
The GetAll() method retrieves one or more labor exec records in the Labor_Exec table, as specified by the filter parameters. Passing no filter parameters will retrieve all labor exec records from the table.
'Declaration
Public Shared Function GetAll( _
ByVal entId As Nullable(Of Integer), _
ByVal defLabCd As String, _
ByVal defDeptId As String, _
ByVal multipleOperators As Nullable(Of Integer), _
ByVal spare1 As String, _
ByVal spare2 As String, _
ByVal spare3 As String, _
ByVal spare4 As String, _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date) _
) As DataSet
'Usage
Dim entId As Nullable(Of Integer)
Dim defLabCd As String
Dim defDeptId As String
Dim multipleOperators As Nullable(Of Integer)
Dim spare1 As String
Dim spare2 As String
Dim spare3 As String
Dim spare4 As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = LaborExec.GetAll(entId, defLabCd, defDeptId, multipleOperators, spare1, spare2, spare3, spare4, lastEditBy, lastEditAt)
public static DataSet GetAll(
Nullable<int> entId,
string defLabCd,
string defDeptId,
Nullable<int> multipleOperators,
string spare1,
string spare2,
string spare3,
string spare4,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- entId
- Optional filter parameter. Holds the ID of an entity whose labor exec records are being retrieved.
- defLabCd
- Optional filter parameter. Holds a default labor code.
- defDeptId
- Optional filter parameter. Holds a default department ID.
- multipleOperators
- Optional filter parameter. Holds the number of simultaneous operators that are allowed.
- spare1
- Optional filter parameter. Holds the contents of the user-defined spare1 field.
- spare2
- Optional filter parameter. Holds the contents of the user-defined spare2 field.
- spare3
- Optional filter parameter. Holds the contents of the user-defined spare3 field.
- spare4
- Optional filter parameter. Holds the contents of the user-defined spare4 field.
- lastEditBy
- Optional filter parameter. Holds the ID of user who added or last updated this record.
- lastEditAt
- Optional filter parameter. Holds the date/time when this record was added or last updated.
Return Value
Returns a DataSet that contains all the records in the Labor_Exec 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 |
|---|---|
|
ent_id |
An integer that is the ID of the entity that is capturing labor. |
|
ent_name |
A string that is the name of the entity, from the ent.ent_name column linked to this entity. |
|
def_lab_cd |
A string that is the default labor code for this entity. |
|
lab_desc |
A string that is the description of the labor category, from the lab_cat.lab_desc column linked to the def_lab_cd. |
|
def_dept_id |
A string that is the default department ID for this entity. |
|
dept_desc |
A string that is the description of the labor department, from the labor_dept.dept_desc column linked to the def_dept_id. |
|
multiple_operators |
A Boolean that is a flag that indicates whether multiple operators are allowed to logon to this entity at a given time. |
|
cur_raw_reas_cd |
A string that is the current raw reason code received for this entity. |
|
def_raw_reas_cd |
A string that is the default raw reason code for this entity. |
|
lab_cd_reqd |
A Boolean that is a flag that indicates whether the entity is currently waiting for the user to enter a final code. |
|
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 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. |