GetAll(Nullable<Int32>,Nullable<Int32>,String,String,String,String,Nullable<Int32>,Nullable<Int32>,String,Nullable<Int32>,String,String,Nullable<Int32>,Nullable<Int32>,String,String,String,String,Nullable<DateTime>,Nullable<DateTime>,Nullable<DateTime>,String,Nullable<DateTime>,Nullable<Boolean>,String,Nullable<DateTime>,String,Nullable<Int32>,Nullable<Int32>,String,String,String,String,Nullable<Int32>,String,Nullable<DateTime>) Method
- Last UpdatedNov 06, 2025
- 8 minute read
'Declaration
Public Overloads Shared Function GetAll( _
ByVal sampleId As Nullable(Of Integer), _
ByVal entId As Nullable(Of Integer), _
ByVal sampleName As String, _
ByVal itemId As String, _
ByVal woId As String, _
ByVal operId As String, _
ByVal seqNo As Nullable(Of Integer), _
ByVal contextEntId As Nullable(Of Integer), _
ByVal contextItemId As String, _
ByVal itemCategoryId As Nullable(Of Integer), _
ByVal processId As String, _
ByVal contextOperId As String, _
ByVal freqId As Nullable(Of Integer), _
ByVal planId As Nullable(Of Integer), _
ByVal segmentRequirementId As String, _
ByVal segmentResponseId As String, _
ByVal lotNo As String, _
ByVal subLotNo As String, _
ByVal requestedTime As Nullable(Of Date), _
ByVal expiryTime As Nullable(Of Date), _
ByVal warningTime As Nullable(Of Date), _
ByVal pulledBy As String, _
ByVal pulledTime As Nullable(Of Date), _
ByVal final As Nullable(Of Boolean), _
ByVal finalizedBy As String, _
ByVal finalizedAt As Nullable(Of Date), _
ByVal verifiedBy As String, _
ByVal sampleStatus As Nullable(Of Integer), _
ByVal sampleResult As Nullable(Of Integer), _
ByVal spare1 As String, _
ByVal spare2 As String, _
ByVal spare3 As String, _
ByVal spare4 As String, _
ByVal priority As Nullable(Of Integer), _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date) _
) As DataSet
'Usage
Dim sampleId As Nullable(Of Integer)
Dim entId As Nullable(Of Integer)
Dim sampleName As String
Dim itemId As String
Dim woId As String
Dim operId As String
Dim seqNo As Nullable(Of Integer)
Dim contextEntId As Nullable(Of Integer)
Dim contextItemId As String
Dim itemCategoryId As Nullable(Of Integer)
Dim processId As String
Dim contextOperId As String
Dim freqId As Nullable(Of Integer)
Dim planId As Nullable(Of Integer)
Dim segmentRequirementId As String
Dim segmentResponseId As String
Dim lotNo As String
Dim subLotNo As String
Dim requestedTime As Nullable(Of Date)
Dim expiryTime As Nullable(Of Date)
Dim warningTime As Nullable(Of Date)
Dim pulledBy As String
Dim pulledTime As Nullable(Of Date)
Dim final As Nullable(Of Boolean)
Dim finalizedBy As String
Dim finalizedAt As Nullable(Of Date)
Dim verifiedBy As String
Dim sampleStatus As Nullable(Of Integer)
Dim sampleResult As Nullable(Of Integer)
Dim spare1 As String
Dim spare2 As String
Dim spare3 As String
Dim spare4 As String
Dim priority As Nullable(Of Integer)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = Sample.GetAll(sampleId, entId, sampleName, itemId, woId, operId, seqNo, contextEntId, contextItemId, itemCategoryId, processId, contextOperId, freqId, planId, segmentRequirementId, segmentResponseId, lotNo, subLotNo, requestedTime, expiryTime, warningTime, pulledBy, pulledTime, final, finalizedBy, finalizedAt, verifiedBy, sampleStatus, sampleResult, spare1, spare2, spare3, spare4, priority, lastEditBy, lastEditAt)
public static DataSet GetAll(
Nullable<int> sampleId,
Nullable<int> entId,
string sampleName,
string itemId,
string woId,
string operId,
Nullable<int> seqNo,
Nullable<int> contextEntId,
string contextItemId,
Nullable<int> itemCategoryId,
string processId,
string contextOperId,
Nullable<int> freqId,
Nullable<int> planId,
string segmentRequirementId,
string segmentResponseId,
string lotNo,
string subLotNo,
Nullable<DateTime> requestedTime,
Nullable<DateTime> expiryTime,
Nullable<DateTime> warningTime,
string pulledBy,
Nullable<DateTime> pulledTime,
Nullable<bool> final,
string finalizedBy,
Nullable<DateTime> finalizedAt,
string verifiedBy,
Nullable<int> sampleStatus,
Nullable<int> sampleResult,
string spare1,
string spare2,
string spare3,
string spare4,
Nullable<int> priority,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- sampleId
- Optional filter parameter. Holds the ID of the sample.
- entId
- Optional filter parameter. Holds the ID of the entity at which the sample was generated.
- sampleName
- Optional filter parameter. Holds the sample name (created according to sample_plan.sample_name).
- itemId
- Optional filter parameter. Holds the ID of the item from which the sample was generated.
- woId
- Optional filter parameter. Holds the ID of the work order used to identify the job for which the sample was generated.
- operId
- Optional filter parameter. Holds the ID of the operation used to identify the job for which the sample was generated.
- seqNo
- Optional filter parameter. Holds the sequence number used to identify the job for which the sample was generated.
- contextEntId
- Optional filter parameter. Holds the ID of the entity or entity class for the specification that caused the sample to be generated.
- contextItemId
- Optional filter parameter. Holds the ID of the item for the specification that caused the sample to be generated.
- itemCategoryId
- Optional filter parameter. Holds the ID of the item category for the specification that caused the sample to be generated.
- processId
- Optional filter parameter. Holds the ID of the process for the specification that caused the sample to be generated. The processId and contextOperId must both be null or must both be non-null.
- contextOperId
- Optional filter parameter. Holds the ID of the operation for the specification that caused the sample to be generated. The processId and contextOperId must both be null or must both be non-null.
- freqId
- Optional filter parameter. Holds the ID of the sample plan frequency based upon which the sample was generated.
- planId
- Optional filter parameter. Holds the ID of the sample plan that is associated to the sample.
- segmentRequirementId
- Optional filter parameter. User-specified S95 field.
- segmentResponseId
- Optional filter parameter. User-specified S95 field.
- lotNo
- Optional filter parameter. Holds the number of the lot from which the sample was pulled.
- subLotNo
- Optional filter parameter. Holds the number of the sublot from which the sample was pulled.
- requestedTime
- Optional filter parameter. Holds the local date/time when the sample was requested (readied).
- expiryTime
- Optional filter parameter. Holds the local date/time when the sample request expires.
- warningTime
- Optional filter parameter. Holds the local date/time when the sample request turned to READY WARNING.
- pulledBy
- Optional filter parameter. Holds the name of the person who pulled the sample.
- pulledTime
- Optional filter parameter. Holds the local date/time when the sample was pulled.
- final
- Optional filter parameter. Holds the flag that indicates whether the sample has been marked as final, which would prohibit editing of any data associated with this sample.
- finalizedBy
- Optional filter parameter. Holds the name of the person who marked the sample as final.
- finalizedAt
- Optional filter parameter. Holds the local date/time when the sample was marked as final.
- verifiedBy
- Optional filter parameter. Holds the name of the person who verified the sample.
- sampleStatus
- Optional filter parameter. Holds the status of the sample. 1 = READY, 2 = READY WARNING, 3 = MISSED, 4 = IN PROGRESS, 5 = LATE, 6 = COMPLETE, 7 = COMPLETE LATE, 8 = CANCELLED.
- sampleResult
- Optional filter parameter. Holds the result state of the sample. 1 = PENDING , 2 = GOOD, 3 = OOC, 4 = OOS, 5 = OOC KEY, 6 = OOS KEY, 7 = OOC CRITICAL, 8 = OOS CRITICAL.
- 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.
- priority
- Optional filter parameter. Holds the priority of measuring the sample.
- lastEditBy
- Optional filter parameter. Holds the ID of a user who added or last updated a sample record.
- lastEditAt
- Optional filter parameter. Holds the datetime that this record was added or last modified.
Return Value
Returns a DataSet that contains records from the Sample 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 |
|---|---|
|
sample_id |
An integer that is the unique identifier of the sample. |
|
sample_name |
A string that is the name of the sample. |
|
ent_id |
An integer that is the ID of the entity at which the sample was generated. |
|
item_id |
A string that is the ID of the item from which the sample was generated. |
|
wo_id |
A string that is the ID of the work order that is used to identify the job for which the sample was generated. |
|
oper_id |
A string that is the ID of the operation that is used to identify the job for which the sample was generated. |
|
seq_no |
An integer that is the sequence number that is used to identify the job for which the sample was generated. |
|
context_ent_id |
An integer that is the ID of the entity or entity class for the specification that caused the sample to be generated. |
|
context_item_id |
A string that is the ID of the item for the specification that caused the sample to be generated. |
|
item_category_id |
An integer that is the ID of the item category for the specification that caused the sample to be generated. If the value is not null, then the context_item_id must be null. |
|
process_id |
A string that is the ID of the process for the specification that caused the sample to be generated. |
|
context_oper_id |
A string that is the ID of the operation for the specification that caused the sample to be generated. |
|
freq_id |
An integer that is the ID of the sample plan frequency based upon which the sample was generated. |
|
plan_id |
An integer that is the ID of the sample plan that is associated to the sample. |
|
segment_requirement_id |
A string for the user-specified S95 field. |
|
segment_response_id |
A string for the user-specified S95 field. |
|
lot_no |
A string that is the number of the lot from which the sample was pulled. |
|
sublot_no |
A string that is the number of the sublot from which the sample was pulled. |
|
requested_time_utc |
A datetime that is the UTC date/time when the sample was requested (readied). |
|
requested_time_local |
A datetime that is the local date/time, relative to the entity that corresponds to the sample, when the sample was requested (readied). |
|
requested_time |
A datetime that is the local date/time, relative to the client who is requesting the data from the server, when the sample was requested (readied). |
|
expiry_time_utc |
A datetime that is the UTC date/time when the sample request expires. |
|
expiry_time_local |
A datetime that is the local date/time, relative to the entity that corresponds to the sample, when the sample request expires. |
|
expiry_time |
A datetime that is the local date/time, relative to the client who is requesting the data from the server, when the sample request expires. |
|
warning_time_utc |
A datetime that is the UTC date/time when the sample request turns to READY WARNING. |
|
warning_time_local |
A datetime that is the local date/time, relative to the entity that corresponds to the sample, when the sample request turns to READY WARNING. |
|
warning_time |
A datetime that is the local date/time, relative to the client who is requesting the data from the server, when the sample request turns to READY WARNING. |
|
pulled_by |
A string that identifies the person who pulled the sample. |
|
pulled_time_utc |
A datetime that is the UTC date/time when the sample was pulled. |
|
pulled_time_local |
A datetime that is the local date/time, relative to the entity that corresponds to the sample, when the sample was pulled. |
|
pulled_time |
A datetime that is the local date/time, relative to the client who is requesting the data from the server, when the sample was pulled. |
|
final |
A Boolean that is a flag that indicates whether the sample has been marked as final, which would prohibit editing of any data associated with this sample. |
|
finalized_by |
A string that identifies the person who marked the sample as final. |
|
finalized_at_utc |
A datetime that is the UTC date/time when the sample was marked as final. |
|
finalized_at_local |
A datetime that is the local date/time, relative to the entity that corresponds to the sample, when the sample was marked as final. |
|
finalized_at |
A datetime that is the local date/time, relative to the client who is requesting the data from the server, when the sample was marked as final. |
|
verified_by |
A string that identifies the person who verified the sample. |
|
sample_status |
An integer that is the status of the sample. |
|
sample_result |
An integer that is the result state of the sample. |
|
spare1 |
A string that is the sample spare1 value. |
|
spare2 |
A string that is the sample spare2 value. |
|
spare3 |
A string that is the sample spare3 value. |
|
spare4 |
A string that is the sample spare4 value. |
|
priority |
An integer that is the priority of measuring the sample. |
|
last_edit_comment |
A string that contains comments about why the record was added or modified. |
|
last_edit_by |
A string that is the user who created or last modified this record. |
|
last_edit_at |
A datetime value that is the date/time when the record was added or last modified. |