GetAll Method (JobStep)
- Last UpdatedNov 06, 2025
- 5 minute read
'Declaration
Public Shared Function GetAll( _
ByVal woId As String, _
ByVal operId As String, _
ByVal seqNo As Nullable(Of Integer), _
ByVal stepNo As Nullable(Of Integer), _
ByVal stepName As String, _
ByVal stepSeq As Nullable(Of Integer), _
ByVal actionType As Nullable(Of Integer), _
ByVal completeCond As Nullable(Of Integer), _
ByVal enterData As Nullable(Of Boolean), _
ByVal stepGrpId As Nullable(Of Integer), _
ByVal spcChar As String, _
ByVal dataLogGrpId As Nullable(Of Integer), _
ByVal controlType As Nullable(Of Integer), _
ByVal spare1 As String, _
ByVal spare2 As String, _
ByVal spare3 As String, _
ByVal spare4 As String, _
ByVal spare5 As String, _
ByVal spare6 As String, _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date) _
) As DataSet
'Usage
Dim woId As String
Dim operId As String
Dim seqNo As Nullable(Of Integer)
Dim stepNo As Nullable(Of Integer)
Dim stepName As String
Dim stepSeq As Nullable(Of Integer)
Dim actionType As Nullable(Of Integer)
Dim completeCond As Nullable(Of Integer)
Dim enterData As Nullable(Of Boolean)
Dim stepGrpId As Nullable(Of Integer)
Dim spcChar As String
Dim dataLogGrpId As Nullable(Of Integer)
Dim controlType As Nullable(Of Integer)
Dim spare1 As String
Dim spare2 As String
Dim spare3 As String
Dim spare4 As String
Dim spare5 As String
Dim spare6 As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = JobStep.GetAll(woId, operId, seqNo, stepNo, stepName, stepSeq, actionType, completeCond, enterData, stepGrpId, spcChar, dataLogGrpId, controlType, spare1, spare2, spare3, spare4, spare5, spare6, lastEditBy, lastEditAt)
public static DataSet GetAll(
string woId,
string operId,
Nullable<int> seqNo,
Nullable<int> stepNo,
string stepName,
Nullable<int> stepSeq,
Nullable<int> actionType,
Nullable<int> completeCond,
Nullable<bool> enterData,
Nullable<int> stepGrpId,
string spcChar,
Nullable<int> dataLogGrpId,
Nullable<int> controlType,
string spare1,
string spare2,
string spare3,
string spare4,
string spare5,
string spare6,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- woId
- Optional filter parameter. Holds the ID of the work order to which a job step belongs.
- operId
- Optional filter parameter. Holds the ID of the operation to which a job step belongs.
- seqNo
- Optional filter parameter. Holds the operation sequence number to which a job step belongs.
- stepNo
- Optional filter parameter. Holds a job step number.
- stepName
- Optional filter parameter. Holds the name of a job step.
- stepSeq
- Optional filter parameter. Holds a job step sequence number.
- actionType
Optional filter parameter. Holds an enumeration that indicates the job step's action type:
0 = Normal (default)
1 = Log data
2 = Add production
3 = Add consumption
4 = Operator acknowledge
5 = Enter form data
6 = Enter SPC data
- completeCond
Optional filter parameter. Holds an enumeration that indicates the job step's complete condition:
2 = std. time elapses
3 = operator completes manually (default)
4 = message is dismissed (only allowable if actionType = 4)
- enterData
- Optional filter parameter. Holds a flag that indicates whether step data can be entered.
- stepGrpId
- Optional filter parameter. Holds the ID of the step group for a step.
- spcChar
- Optional filter parameter. Holds the SPC characteristic to be collected at a step.
- dataLogGrpId
- Optional filter parameter. Holds the ID of the data log group for a step.
- controlType
- Optional filter parameter. Holds the control type.
- 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.
- spare5
- Optional filter parameter. Holds the contents of the user-defined spare5 field.
- spare6
- Optional filter parameter. Holds the contents of the user-defined spare6 field.
- lastEditBy
- Optional filter parameter. Holds the ID of the user who added or last updated a job step record.
- lastEditAt
- Optional filter parameter. Holds the date/time when a job step record was added or last updated.
Return Value
Returns a DataSet that contains all the records in the Job_Step 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 |
|---|---|
|
wo_id |
A string that is the ID of the work order. |
|
oper_id |
A string that is the ID of the operation. |
|
seq_no |
An integer that is the sequence number. |
|
step_no |
An integer that is the step number. |
|
step_name |
A string that is the step name. |
|
step_desc |
A string that is the step description. |
|
action_type |
An integer that is the action type. |
|
std_time |
A double-precision floating point number that is the hours allowed for this step |
|
complete_cond |
An integer that is an enumeration value that indicates the step's complete condition. |
|
allow_bypass |
A Boolean that is a flag that indicates whether users can bypass the step. |
|
enter_data |
A Boolean that is a flag that indicates whether step data can be entered. |
|
step_grp_id |
An integer that is the ID of the step group. |
|
spc_char |
A string that is the SPC characteristic to be collected at this step |
|
form_name |
A string that is the link to an optional form (usually in a ‘Forms’ application) for this step. |
|
reqd_rep |
An integer that is the number of lots/sublots for which this step must be performed. |
|
control_type |
An integer that is the control type. |
|
high_limit |
A double-precision floating point number that is the maximium allowable value if control type =1. |
|
low_limit |
A double-precision floating point number that is the minimium allowable value if control type =1. |
|
limit_warning |
A Boolean that is a flag that indicates whether the limit has been reached if control type =1. |
|
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. |
|
spare5 |
A string that is the contents of the user-defined spare5 field. |
|
spare6 |
A string that is the contents of the user-defined spare6 field. |
|
step_grp_desc |
A string that is the step group descirption. |
|
step_grp_seq |
An integer that is step group sequence number. |
|
repeatability |
A Boolean that is a flag that, if false, indicates whether this step is done once per operation (e.g., a setup step for the operation) or, if true, for every lot produced during the operation. |
|
can_log_data |
A Boolean that is a flag that indicates whether the step can log data. |
|
serial_no_lvl |
An integer that is the serial number level:
|
|
executions |
An integer that is total number of repeatable steps that are completed. |
|
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. |
|
step_grp_last_edit_comment |
A string that contains any comments about why the corresponding step group record was added or updated. |
|
step_grp_last_edit_by |
A string that contains the ID of the user who added or last updated the corresponding step group record. |
|
step_grp_last_edit_at |
A datetime that indicates when the corresponding step group record was added or last updated. |
|
row_id |
An integer that is row ID. |
|
data_log_groups |
An integer that is the data log groups count. |