GetAll Method (Lot)

• Visual Basic
• C#

'Declaration
 
Public Shared Function GetAll( _
   ByVal itemId As String, _
   ByVal lotNo As String, _
   ByVal gradeCd As Nullable(Of Integer), _
   ByVal statusCd As Nullable(Of Integer), _
   ByVal expiryDate As Nullable(Of Date), _
   ByVal isSerialNo As Nullable(Of Boolean), _
   ByVal spare1 As String, _
   ByVal spare2 As String, _
   ByVal spare3 As String, _
   ByVal spare4 As String, _
   ByVal spare5 As String, _
   ByVal spare6 As String, _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date) _
) As DataSet

'Usage
 
Dim itemId As String
Dim lotNo As String
Dim gradeCd As Nullable(Of Integer)
Dim statusCd As Nullable(Of Integer)
Dim expiryDate As Nullable(Of Date)
Dim isSerialNo As Nullable(Of Boolean)
Dim spare1 As String
Dim spare2 As String
Dim spare3 As String
Dim spare4 As String
Dim spare5 As String
Dim spare6 As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = Lot.GetAll(itemId, lotNo, gradeCd, statusCd, expiryDate, isSerialNo, spare1, spare2, spare3, spare4, spare5, spare6, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   string itemId,
   string lotNo,
   Nullable<int> gradeCd,
   Nullable<int> statusCd,
   Nullable<DateTime> expiryDate,
   Nullable<bool> isSerialNo,
   string spare1,
   string spare2,
   string spare3,
   string spare4,
   string spare5,
   string spare6,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

itemId

Optional filter parameter. Holds the item_id of lot(s) that store the item.

lotNo

Optional filter parameter. Holds the identifier of lot.

gradeCd

Optional filter parameter. Holds the item grade of the lot.

statusCd

Optional filter parameter. Holds the item status of the lot.

expiryDate

Optional filter parameter. Holds the date and time of lots that are at this expiry date and time or later. This is a fixed time that is not related to a local time or UTC.

Note: This parameter is not currently used by the system.

isSerialNo

Optional filter parameter. Holds a flag that retrieves lot(s) with a specified serial number setting.

spare1

Optional filter parameter. Holds the contents of a user-defined spare1 field.

spare2

Optional filter parameter. Holds the contents of a user-defined spare2 field.

spare3

Optional filter parameter. Holds the contents of a user-defined spare3 field.

spare4

Optional filter parameter. Holds the contents of a user-defined spare4 field.

spare5

Optional filter parameter. Holds the contents of a user-defined spare5 field.

spare6

Optional filter parameter. Holds the contents of a user-defined spare6 field.

lastEditBy

Optional filter parameter. Holds the ID of the user who added or last changed the record.

lastEditAt

Optional filter parameter. Holds the date/time when the record was added or last updated.

Return Value