GetAll Method (Line)
- Last UpdatedNov 06, 2025
- 4 minute read
'Declaration
Public Shared Function GetAll( _
ByVal lineId As Nullable(Of Integer), _
ByVal lineName As String, _
ByVal lineClass As Nullable(Of Boolean), _
ByVal originLineClassId As Nullable(Of Integer), _
ByVal laborLoad As Nullable(Of Integer), _
ByVal maxWO As Nullable(Of Integer), _
ByVal prodEntId As Nullable(Of Integer), _
ByVal bottleneckEntId As Nullable(Of Integer), _
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 lineId As Nullable(Of Integer)
Dim lineName As String
Dim lineClass As Nullable(Of Boolean)
Dim originLineClassId As Nullable(Of Integer)
Dim laborLoad As Nullable(Of Integer)
Dim maxWO As Nullable(Of Integer)
Dim prodEntId As Nullable(Of Integer)
Dim bottleneckEntId As Nullable(Of Integer)
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 = Line.GetAll(lineId, lineName, lineClass, originLineClassId, laborLoad, maxWO, prodEntId, bottleneckEntId, spare1, spare2, spare3, spare4, lastEditBy, lastEditAt)
public static DataSet GetAll(
Nullable<int> lineId,
string lineName,
Nullable<bool> lineClass,
Nullable<int> originLineClassId,
Nullable<int> laborLoad,
Nullable<int> maxWO,
Nullable<int> prodEntId,
Nullable<int> bottleneckEntId,
string spare1,
string spare2,
string spare3,
string spare4,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- lineId
- Optional filter parameter. Holds the ID of the line or line class.
- lineName
- Optional filter parameter. Holds the name of the line or line class.
- lineClass
- Optional filter parameter. Holds the flag that specifies whether the line is a line class.
- originLineClassId
- Optional filter parameter. Holds the ID of the line class to which the line belongs.
- laborLoad
- Optional filter parameter. Holds the number of people required to run the line that is reported to ERP.
- maxWO
- Optional filter parameter. Holds the maximum number of simultaneous works orders permitted on the line.
- prodEntId
- Optional filter parameter. Holds the ID of the entity that is the source of the production amount of the line.
- bottleneckEntId
- Optional filter parameter. Holds the identity of the entity that is designated as the bottleneck on the line.
- spare1
- Optional filter parameter. Holds user-defined content for the spare1 field.
- spare2
- Optional filter parameter. Holds user-defined content for the spare2 field.
- spare3
- Optional filter parameter. Holds user-defined content for the spare3 field.
- spare4
- Optional filter parameter. Holds user-defined content for the spare4 field.
- lastEditBy
- Optional filter parameter. Holds the name of the user who added or last changed an entity record.
- lastEditAt
- Optional filter parameter. Holds a date/time of when an entity record was added or last changed.
Return Value
Returns a DataSet that contains a DataRow for each line record from the Line table that satisfies the specified filter criteria. If no matching records are found, an empty DataSet is returned.
The columns of the returned DataSet are described below.
| Column Name | Description |
|---|---|
|
line_id |
An integer that is the ID of the line or line class. |
|
line_name |
A string that is the name of the line. |
| line_class | A Boolean flag that specifies whether the line is a line class. |
| origin_line_class_id |
An integer that is the ID of the line class from which this line was instantiated. If null and line_class is false, this line was not instantiated from a line class. If null and line_class is true, this record defines a line class. |
|
labor_load |
An integer that specifies the number of people required to run the line that is reported to ERP. |
|
max_wo |
An integer that specifies the maximum number of simultaneous work orders permitted on the line. |
|
prod_ent_id |
An integer that identifies the entity that is the source of the production amount for the line. |
|
prod_uom |
An integer that identifies the standard production rate unit of measure for reporting the production rate. |
|
batch_size |
A double-precision floating point number that identifies the standard batch size for reporting the production rate. |
|
std_item_id |
A string that identifies the standard item to use for reporting the production rate. |
| item_display |
A string that identifies the item in the user interface. The value that determines the format of the identifier is defined in the system attribute Item display (attr_id 210 in the System_Attr table): 0 = item_id 1 = item_desc 2 = item_id(item_desc) 3 = item_desc(item_id) |
| uom_description | A string that is the description of the unit of measure for the item, from the Uom table. |
|
bottleneck_ent_id |
An integer that identifies the entity that is designated as the bottleneck on the line. Other entities in the same child order position as the bottleneck entity will also be considered to be bottleneck entities. |
|
target_util |
A double-precision floating point number that represents the KPI target for utilization (availability). |
|
target_qual |
A double-precision floating point number that represents the KPI target for quality. |
|
target_perf |
A double-precision floating point number that represents the KPI target for performance. |
|
target_oee |
A double-precision floating point number that represents the KPI target for OEE. |
|
spare1 |
A string that is the contents of the spare1 field. |
|
spare2 |
A string that is the contents of the spare2 field. |
|
spare3 |
A string that is the contents of the spare3 field. |
|
spare4 |
A string that is the contents of the spare4 field. |
|
last_edit_comment |
A string that is the comment about why the record was added or changed. |
|
last_edit_by |
A string that is the user ID of the user who added or last edited this record. |
|
last_edit_at |
A datetime that identifies when the record was added or last modified. |