GetAll(Nullable<Int32>,String,Nullable<Int32>,Nullable<Int32>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,String,Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,Nullable<Boolean>,String,Nullable<DateTime>) Method
- Last UpdatedNov 06, 2025
- 6 minute read
'Declaration
Public Overloads Shared Function GetAll( _
ByVal reasCd As Nullable(Of Integer), _
ByVal reasDesc As String, _
ByVal reasGrpId As Nullable(Of Integer), _
ByVal stateCd As Nullable(Of Integer), _
ByVal runtime As Nullable(Of Boolean), _
ByVal downtime As Nullable(Of Boolean), _
ByVal setuptime As Nullable(Of Boolean), _
ByVal teardownTime As Nullable(Of Boolean), _
ByVal fixedtime As Nullable(Of Boolean), _
ByVal vartime As Nullable(Of Boolean), _
ByVal failure As Nullable(Of Boolean), _
ByVal defLabCd As String, _
ByVal displaySeq As Nullable(Of Integer), _
ByVal priority As Nullable(Of Integer), _
ByVal newReasonCode As Nullable(Of Integer), _
ByVal entityEnabled As Nullable(Of Boolean), _
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 stateCd As Nullable(Of Integer)
Dim runtime As Nullable(Of Boolean)
Dim downtime As Nullable(Of Boolean)
Dim setuptime As Nullable(Of Boolean)
Dim teardownTime As Nullable(Of Boolean)
Dim fixedtime As Nullable(Of Boolean)
Dim vartime As Nullable(Of Boolean)
Dim failure As Nullable(Of Boolean)
Dim defLabCd As String
Dim displaySeq As Nullable(Of Integer)
Dim priority As Nullable(Of Integer)
Dim newReasonCode As Nullable(Of Integer)
Dim entityEnabled As Nullable(Of Boolean)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = UtilReas.GetAll(reasCd, reasDesc, reasGrpId, stateCd, runtime, downtime, setuptime, teardownTime, fixedtime, vartime, failure, defLabCd, displaySeq, priority, newReasonCode, entityEnabled, lastEditBy, lastEditAt)
public static DataSet GetAll(
Nullable<int> reasCd,
string reasDesc,
Nullable<int> reasGrpId,
Nullable<int> stateCd,
Nullable<bool> runtime,
Nullable<bool> downtime,
Nullable<bool> setuptime,
Nullable<bool> teardownTime,
Nullable<bool> fixedtime,
Nullable<bool> vartime,
Nullable<bool> failure,
string defLabCd,
Nullable<int> displaySeq,
Nullable<int> priority,
Nullable<int> newReasonCode,
Nullable<bool> entityEnabled,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- reasCd
- Optional filter parameter. Holds the code of a utilization reason to be retrieved.
- reasDesc
- Optional filter parameter. Holds a utilization reason description.
- reasGrpId
- Optional filter parameter. Holds the utilization reason group ID to which utilization reasons are linked.
- stateCd
- Optional filter parameter. Holds a state code.
- runtime
- Optional filter parameter. Holds a flag that indicates whether utilization reasons count toward runtime events.
- downtime
- Optional filter parameter. Holds a flag that indicates whether utilization reasons count toward downtime events.
- setuptime
- Optional filter parameter. Holds a flag that indicates whether utilization reasons count toward setup time events.
- teardownTime
- Optional filter parameter. Holds a flag that indicates whether utilization reasons count toward teardown time events.
- fixedtime
- Optional filter parameter. Holds a flag that indicates whether utilization reasons count toward fixed-time events.
- vartime
- Optional filter parameter. Holds a flag that indicates whether utilization reasons count toward variable-time events.
- failure
- Optional filter parameter. Holds a flag that indicates whether any time that the entity spends in this utilization reason code is considered failure time.
- defLabCd
- Optional filter parameter. Holds a default labor code for utilization reasons when they are manually selected.
- displaySeq
- Optional filter parameter. Holds a utilization reason display sequence number. This number determines the order of utilization reasons when they are listed under their utilization reason group in the user interface.
- priority
- Optional filter parameter. Holds the utilization reason's priority, which is used to determine the reason for a line that has two or more bottleneck entities with differing reasons.
- newReasonCode
- Optional filter parameter. Holds the utilization reason to which a reason should change when the maximum duration is exceeded.
- entityEnabled
- Optional filter parameter. Holds the flag that indicates whether an entity in this utilization reason is considered to be enabled.
- lastEditBy
- Optional filter parameter. Holds the user who added or last changed a utilization reason record.
- lastEditAt
- Optional filter parameter. Holds a date/time when utilization reason records were added or last modified.
Return Value
Returns a DataSet that contains all the records in the Util_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 utilization reason code. |
|
reas_desc |
A string that is the description of the utilization reason. |
|
reas_grp_id |
An integer that is the ID of the utilization reason group. |
|
reas_grp_desc |
A string that is the description of the utilization reason group, from the util_reas_grp.reas_grp_desc column linked to this reason. |
|
state_cd |
An integer that is the utilization state code for this reason. |
|
state_desc |
A string that is the description of the utilization state, from the util_state.state_cd linked to this reason. |
|
color |
An integer that indicates the RGB background color for the utilization state when displayed in the user interface. |
|
runtime |
A Boolean flag that indicates whether this utilization reason is used for runtime events. |
|
downtime |
A Boolean flag that indicates whether this utilization reason is used for downtime events. |
|
setuptime |
A Boolean flag that indicates whether this utilization reason is used for setup time events. |
|
teardowntime |
A Boolean flag that indicates whether this utilization reason is used for teardown time events. |
|
fixedtime |
A Boolean flag that indicates whether this utilization reason is used for fixed time events. |
|
vartime |
A Boolean flag that indicates whether this utilization reason is used for variable time events. |
|
failure |
A Boolean flag that indicates whether any time that the entity spends in this utilization reason code is considered failure time. |
|
def_lab_cd |
A string that is the default labor code for the utilization reason when it is manually selected. |
|
lab_desc |
A string that is the description of the labor code, from the labor_cat.lab_desc column linked to this default labor code. |
|
display_seq |
An integer that is the display sequence of this reason. This number determines the order of utilization reasons when they are listed under their utilization reason group in the user interface. |
|
priority |
An integer that is the priority of the utilization reason. The priority number is used to determine the reason for a line that has two or more bottleneck entities with differing reasons. |
|
max_duration |
An integer that is the maximum duration, in seconds, that the utilization reason is not considered to be in a severe condition or before the reason is changed to a new utilization reason code.
|
|
new_reas_cd |
An integer that is the utilization reason code to which the reason should change when the maximum duration is exceeded. |
|
standard_time |
A floating point number that is the standard amount of time, in minutes, that an entity is expected to be in this utilization reason. |
|
min_time |
A floating point number that is the minimum amount of time, in minutes, that an entity is expected to be in this utilization reason. |
|
max_time |
A floating point number that is the maximum amount of time, in minutes, that an entity is expected to be in this utilization reason. |
|
ent_enabled |
A Boolean flag that indicates whether an entity in this utilization reason is to be considered enabled. |
|
category1 |
A string that is the content of the category1 field. |
|
category2 |
A string that is the content of the category2 field. |
|
category3 |
A string that is the content of the category3 field. |
|
category4 |
A string that is the content of the category4 field. |
|
spare1 |
A string that is the content of the spare1 field. |
|
spare2 |
A string that is the content of the spare2 field. |
|
spare3 |
A string that is the content of the spare3 field. |
|
spare4 |
A string that is the content of the 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 specifies when the record was added or last updated. |