GetAll Method (StandardOper)
- Last UpdatedNov 06, 2025
- 3 minute read
'Declaration
Public Shared Function GetAll( _
ByVal operId As String, _
ByVal operDesc As String, _
ByVal checkInv As Nullable(Of Boolean), _
ByVal schedToEntId As Nullable(Of Integer), _
ByVal operType As String, _
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 operId As String
Dim operDesc As String
Dim checkInv As Nullable(Of Boolean)
Dim schedToEntId As Nullable(Of Integer)
Dim operType As String
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 = StandardOper.GetAll(operId, operDesc, checkInv, schedToEntId, operType, spare1, spare2, spare3, spare4, lastEditBy, lastEditAt)
public static DataSet GetAll(
string operId,
string operDesc,
Nullable<bool> checkInv,
Nullable<int> schedToEntId,
string operType,
string spare1,
string spare2,
string spare3,
string spare4,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- operId
- Optional filter parameter. Holds the ID of an operation.
- operDesc
- Optional filter parameter. Holds the description of an operation.
- checkInv
- Optional filter parameter. Holds a flag that specifies whether sufficient component inventory is required to change the operation's state to Ready.
- schedToEntId
- Optional filter parameter. Holds the ID of an entity to which an operation is scheduled.
- operType
- Optional filter parameter. Holds the type of an operation. Can be used to help determine which job instances to create when importing schedules from an ERP system.
- 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 a user who added or last updated a standard operation record.
- lastEditAt
- Optional filter parameter. Holds the date/time when a standard operation record was added or last updated.
Return Value
Returns a DataSet that contains all the records in the Std_Oper 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 |
|---|---|
|
oper_id |
A string that is the ID of the operation. |
|
oper_desc |
A string that is the operation description. |
|
def_reject_rate |
A floating point number that is the default reject rate for this operation. |
|
check_inv |
A Boolean that is a flag that specifies whether sufficient component inventory is required to change the operation state to Ready. |
|
sched_to_ent_id |
An integer that is the ID of the entity to which this operation is scheduled. |
|
oper_type |
A string that is the type of this operation. May be used to help determine which job instances to create when importing schedules from an ERP system. |
|
oper_cost |
A floating point number that is the additional (non-labor, non-machine, non-material) cost associated specifically with this operation. |
|
deviation_above |
A floating point number that is the portion of the start quantity by which total production may deviate above. |
|
deviation_below |
A floating point number that is the portion of the start quantity by which total production may deviate below. |
|
assoc_file |
A string that is the associated file for this operation. |
|
assoc_file_type |
A string that is the type of the associated file. |
|
notes |
A string that is notes about this operation. |
|
entity_exists |
A Boolean that is a flag that indicates whether at least one record for this standard operation exists in the Std_Oper_Ent_Link table. |
|
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. |
|
row_id |
An integer that is the unique row identifier, for the audit trail. |