GetAll Method (ProdRateHistory)
- Last UpdatedNov 06, 2025
- 4 minute read
'Declaration
Public Shared Function GetAll( _
ByVal lineId As Nullable(Of Integer), _
ByVal entId As Nullable(Of Integer), _
ByVal startTime As Nullable(Of Date), _
ByVal endTime As Nullable(Of Date), _
ByVal stdItemId As String, _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date), _
ByVal rowId As Nullable(Of Integer) _
) As DataSet
'Usage
Dim lineId As Nullable(Of Integer)
Dim entId As Nullable(Of Integer)
Dim startTime As Nullable(Of Date)
Dim endTime As Nullable(Of Date)
Dim stdItemId As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim rowId As Nullable(Of Integer)
Dim value As DataSet
value = ProdRateHistory.GetAll(lineId, entId, startTime, endTime, stdItemId, lastEditBy, lastEditAt, rowId)
public static DataSet GetAll(
Nullable<int> lineId,
Nullable<int> entId,
Nullable<DateTime> startTime,
Nullable<DateTime> endTime,
string stdItemId,
string lastEditBy,
Nullable<DateTime> lastEditAt,
Nullable<int> rowId
)
Parameters
- lineId
- Optional filter parameter. Holds the ID of a production line.
- entId
- Optional filter parameter. Holds the ID of an entity.
- startTime
- Optional filter parameter. Holds the start time of a production rate period.
- endTime
- Optional filter parameter. Holds the end time of a production rate period.
- stdItemId
- Optional filter parameter. Holds a standard item used for reporting the production rate.
- lastEditBy
- Optional filter parameter. Holds the name of a user who added or last changed a production rate history record.
- lastEditAt
- Optional filter parameter. Holds a date/time of when a production rate history record was added or last changed.
- rowId
- Optional filter parameter. Holds the ID of a particular production rate history record.
Return Value
Returns a DataSet that contains all the records in the Prod_Rate_History 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 |
|---|---|
|
line_id |
An integer that is the ID of the line. |
|
ent_id |
An integer that is the ID of the entity. |
|
ent_name |
A string that is the name of the entity. |
|
start_time_utc |
A datetime that is the starting time, in UTC, of the period to which a production rate history record applies. |
|
start_time_local |
A datetime that is the starting time, in the local time of the MES Middleware server, of the period to which a production rate history record applies. |
|
start_time |
A datetime that is the starting time, in the local time of the client who is requesting data from the server, of the period to which a production rate history record applies. |
|
end_time_utc |
A datetime that is the ending time, in UTC, of the period to which a production rate history record applies. If non-null, it should equal the start_time_* of the next production rate history record for this entity, unless the ability for the entity to run jobs was removed. |
|
end_time_local |
A datetime that is the ending time, in the local time of the MES Middleware server, of the period to which a production rate history record applies. If non-null, it should equal the start_time_* of the next production rate history record for this entity, unless the ability for the entity to run jobs was removed. |
|
end_time |
A datetime that is the ending time, in the local time of the client who is requesting data from the server, of the period to which a production rate history record applies. If non-null, it should equal the start_time_* of the next production rate history record for this entity, unless the ability for the entity to run jobs was removed. |
|
est_prod_rate |
An integer that is the estimated batch rate or time. |
|
prod_uom |
An integer that is the ID of the unit of measure associated with the estimated production rate. |
|
uom_description |
A string that is the description of the unit of measure associated with the estimated production rate. |
|
batch_size |
An integer that is the standard batch size used for reporting the production rate. |
|
std_item_id |
A string that is the ID of the standard item used for reporting the production rate. |
|
item_desc |
A string that is the description of the standard item used for reporting the production rate. |
|
item_display |
A string that describes display information about the standard item used for reporting the production rate. |
|
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. |
|
row_id |
An integer that uniquely identifies the production rate history record. |