GetAll Method (LaborCat)
- Last UpdatedMar 17, 2026
- 2 minute read
The GetAll() method retrieves one or more labor category records from the Labor_Cat table, as specified by the filter parameters. Passing no filter parameters will retrieve all labor category records from the table.
'Declaration
Public Shared Function GetAll( _
ByVal labCd As String, _
ByVal labDesc As String, _
ByVal fixedtime As Nullable(Of Boolean), _
ByVal vartime As Nullable(Of Boolean), _
ByVal color As Nullable(Of Integer), _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date) _
) As DataSet
'Usage
Dim labCd As String
Dim labDesc As String
Dim fixedtime As Nullable(Of Boolean)
Dim vartime As Nullable(Of Boolean)
Dim color As Nullable(Of Integer)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = LaborCat.GetAll(labCd, labDesc, fixedtime, vartime, color, lastEditBy, lastEditAt)
public static DataSet GetAll(
string labCd,
string labDesc,
Nullable<bool> fixedtime,
Nullable<bool> vartime,
Nullable<int> color,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- labCd
- Optional. Holds the code for a labor category.
- labDesc
- Optional filter parameter. Holds the description for a labor category.
- fixedtime
- Optional filter parameter. Holds a flag that specifies whether the labor category is a fixed-time category.
- vartime
- Optional filter parameter. Holds a flag that specifies whether the labor category is a variable-time category.
- color
- Optional filter parameter. Holds an integer that identifies the background color for this labor category when displayed in the user interface.
- lastEditBy
- Optional filter parameter. Holds the user who added or last changed this record.
- lastEditAt
- Optional filter parameter. Holds the date/time when this record was added or last edited.
Return Value
Returns a DataSet that contains all the records in the Labor_Cat 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 |
|---|---|
|
lab_cd |
A string that is the labor code. |
|
lab_desc |
A string that is the description of the labor code. |
|
fixedtime |
A Boolean that is a flag that indicates whether this labor belongs to a fixed time category. |
|
vartime |
A Boolean that is a flag that indicates whether this labor belongs to a variable time category. |
|
color |
An integer that indicates the background color for this labor category when displayed in the user interface. |
|
std_crew |
A floating point number that is the number of workers for this labor category. |
|
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. |