GetAll Method (SubLot)

• Visual Basic
• C#

'Declaration
 
Public Shared Function GetAll( _
   ByVal itemId As String, _
   ByVal lotNo As String, _
   ByVal subLotNo As String, _
   ByVal parent As String, _
   ByVal level As Nullable(Of Integer), _
   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 subLotNo As String
Dim parent As String
Dim level As Nullable(Of Integer)
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 = SubLot.GetAll(itemId, lotNo, subLotNo, parent, level, gradeCd, statusCd, expiryDate, isSerialNo, spare1, spare2, spare3, spare4, spare5, spare6, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   string itemId,
   string lotNo,
   string subLotNo,
   string parent,
   Nullable<int> level,
   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 sublot(s) that store the item.

lotNo

Optional filter parameter. Holds the identifier of lot that sublots are a part of.

subLotNo

Optional filter parameter. Holds the sublot identifier for the sublot to retrieve.

parent

Optional filter parameter. Holds the lot or sublot that is the parent of the sublot(s) retrieving.

level

Optional filter parameter. Holds the sublot level of the sublot(s) retrieving.

gradeCd

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

statusCd

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

expiryDate

Optional filter parameter. Holds the date and time of sublots 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, if set to true, specifies whether a sublot number is a serial number.

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