GetAll(Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,Nullable<DateTime>) Method
- Last UpdatedNov 06, 2025
- 2 minute read
'Declaration
Public Overloads Shared Function GetAll( _
ByVal sampleId As Nullable(Of Integer), _
ByVal charId As Nullable(Of Integer), _
ByVal ruleId As Nullable(Of Integer), _
ByVal lastEditAt As Nullable(Of Date) _
) As DataSet
'Usage
Dim sampleId As Nullable(Of Integer)
Dim charId As Nullable(Of Integer)
Dim ruleId As Nullable(Of Integer)
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = SampleCharRuleLink.GetAll(sampleId, charId, ruleId, lastEditAt)
public static DataSet GetAll(
Nullable<int> sampleId,
Nullable<int> charId,
Nullable<int> ruleId,
Nullable<DateTime> lastEditAt
)
Parameters
- sampleId
- Optional filter parameter. Holds the Identity of the sample.
- charId
- Optional filter parameter. Holds the Characteristic Id.
- ruleId
- Optional filter parameter. Holds the Specification Id from which the sample was generated.
- lastEditAt
- Optional filter parameter. Holds the datetime that this record was added.
Return Value
Returns a DataSet that contains records from the Sample_Char_Rule_Link 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 ID of the sample. |
|
sample_name |
A string that is the name of the sample. |
|
char_id |
An integer that is the unique ID of the characteristic. |
|
char_name |
A string that is the name of the characteristic. |
|
rule_id |
An integer that identifies the SPC rule that was violated. |
|
rule_desc |
A string that describes the SPC rule that was violated. |
|
priority |
An integer that specifies the priority of the control rule. |
|
note |
A string that is a note about this sample for this characteristic. |
|
cause_id |
An integer that is the ID of the cause for this characteristic of this sample. |
|
last_edit_at |
A datetime that specifies when the record was added or last updated. |