GetAll Method (JobRoute)
- Last UpdatedNov 06, 2025
- 3 minute read
'Declaration
Public Shared Function GetAll( _
ByVal woId As String, _
ByVal operId As String, _
ByVal seqNo As Nullable(Of Integer), _
ByVal inputOperId As String, _
ByVal inputSeqNo As Nullable(Of Integer), _
ByVal inputPercent As Nullable(Of Double), _
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 inputOperId As String
Dim inputSeqNo As Nullable(Of Integer)
Dim inputPercent As Nullable(Of Double)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = JobRoute.GetAll(woId, operId, seqNo, inputOperId, inputSeqNo, inputPercent, lastEditBy, lastEditAt)
public static DataSet GetAll(
string woId,
string operId,
Nullable<int> seqNo,
string inputOperId,
Nullable<int> inputSeqNo,
Nullable<double> inputPercent,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- woId
- Optional filter parameter. Holds the work order ID of a job.
- operId
- Optional filter parameter. Holds the operation ID of a job.
- seqNo
- Optional filter parameter. Holds the operation sequence number of a job .
- inputOperId
- Optional filter parameter. Holds the operation ID of ta he job from which the input quantity will be obtained.
- inputSeqNo
- Optional filter parameter. Holds the operation sequence number of a job from which the input quantity will be obtained.
- inputPercent
- Optional filter parameter. Holds a percent value that specifies how much of the input job's production comes to a job.
- lastEditBy
- Optional filter parameter. Holds the ID of the user who added or last changed the attribute record.
- lastEditAt
- Optional filter parameter. Holds a date/time when the record was added or last edited.
Return Value
Returns a DataSet that contains all the the records in the Job_Route 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 work order ID of the job route. |
|
oper_id |
A string that is the operation ID of the job route. |
|
seq_no |
An integer that is the operation sequence number of the job route. |
|
input_oper_id |
A string that is the operation ID of the job from which input quantity will be gotten. |
|
input_seq_no |
An integer that is the sequence number of the job from which input quantity will be gotten. |
|
input_percent |
A double that is the percentage of the input job’s production that comes to this job. Default = 100% = 1. |
|
last_edit_comment |
A string that contains comments about why record was changed. |
|
last_edit_by |
A string that is the ID of the user that last edited this record. |
|
last_edit_at |
A datetime that is the date/time when the record was added or last modified. |
|
mod_id |
The current modification ID of the record in the table. This ID is binary number that increments each time the record’s table row is modified. Optionally used for optimistic concurrency control when performing updates or deletes. |