GetAll Method (UomConv)
- Last UpdatedNov 06, 2025
- 3 minute read
'Declaration
Public Shared Function GetAll( _
ByVal fromUomId As Nullable(Of Integer), _
ByVal toUomId As Nullable(Of Integer), _
ByVal itemId As String, _
ByVal factor As Nullable(Of Double), _
ByVal offset As Nullable(Of Double), _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date), _
ByVal rowId As Nullable(Of Integer) _
) As DataSet
'Usage
Dim fromUomId As Nullable(Of Integer)
Dim toUomId As Nullable(Of Integer)
Dim itemId As String
Dim factor As Nullable(Of Double)
Dim offset As Nullable(Of Double)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim rowId As Nullable(Of Integer)
Dim value As DataSet
value = UomConv.GetAll(fromUomId, toUomId, itemId, factor, offset, lastEditBy, lastEditAt, rowId)
public static DataSet GetAll(
Nullable<int> fromUomId,
Nullable<int> toUomId,
string itemId,
Nullable<double> factor,
Nullable<double> offset,
string lastEditBy,
Nullable<DateTime> lastEditAt,
Nullable<int> rowId
)
Parameters
- fromUomId
- Optional filter parameter. Holds the ID of the the starting unit of measurement.
- toUomId
- Optional filter parameter. Holds the ID of the resulting unit of measurement.
- itemId
- Optional filter parameter. Holds the ID of the item for which the conversion is valid.
- factor
- Optional filter parameter. Holds the factor value used in the conversion.
- offset
- Optional filter parameter. Holds the offset used in the conversion.
- lastEditBy
- Optional filter parameter. Holds the ID of the user who added or last updated a uom record.
- lastEditAt
- Optional filter parameter. Holds the date and time when a uom record was added or last updated.
- rowId
- Optional filter parameter. Holds the ID of the row to retrieve.
Return Value
Returns a DataSet that contains all the records in the Uom_Conv 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 |
|---|---|
|
from_uom_id |
An integer that is the ID of the starting unit of measure. |
|
from_description |
A string that is the description of the starting unit of measure. |
|
from_abbreviation |
A string that is the abbreviation of the starting unit of measure. |
|
to_uom_id |
A integer that is the resulting unit of measure. |
|
to_description |
A string that is the description of the resulting unit of measure. |
|
to_abbreviation |
A string that is the abbreviation of the resulting unit of measure. |
|
item_id |
An integer that is the ID of the item for which the conversion is valid. |
|
factor |
A double that is the factor by which to multiply the quantity. |
|
offset |
An integer that is the offset to add to the multiplied quantity to obtain the final result. |
|
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 contains comments about why the record was updated. |
|
last_edit_by |
A string that is the ID of the user who added or last updated this record. |
|
last_edit_at |
A date and time that indicates when the record was added or last updated. |
|
row_id |
An integer that is the ID of the row.Unique row identifier. |