Add Method (Lot)
- Last UpdatedNov 06, 2025
- 3 minute read
The Add() method adds a new lot record to the lot table.
'Declaration
Public Shared Sub Add( _
ByVal sessionId As Integer, _
ByVal itemId As String, _
ByVal lotNo As String, _
ByVal gradeCd As DBInt, _
ByVal statusCd As DBInt, _
ByVal expiryDate As DBDateTime, _
ByVal isSerialNo As Nullable(Of Boolean), _
ByVal spare1 As DBString, _
ByVal spare2 As DBString, _
ByVal spare3 As DBString, _
ByVal spare4 As DBString, _
ByVal spare5 As DBString, _
ByVal spare6 As DBString, _
ByVal lastEditComment As DBString, _
ByRef lastEditAt As Date _
)
'Usage
Dim sessionId As Integer
Dim itemId As String
Dim lotNo As String
Dim gradeCd As DBInt
Dim statusCd As DBInt
Dim expiryDate As DBDateTime
Dim isSerialNo As Nullable(Of Boolean)
Dim spare1 As DBString
Dim spare2 As DBString
Dim spare3 As DBString
Dim spare4 As DBString
Dim spare5 As DBString
Dim spare6 As DBString
Dim lastEditComment As DBString
Dim lastEditAt As Date
Lot.Add(sessionId, itemId, lotNo, gradeCd, statusCd, expiryDate, isSerialNo, spare1, spare2, spare3, spare4, spare5, spare6, lastEditComment, lastEditAt)
public static void Add(
int sessionId,
string itemId,
string lotNo,
DBInt gradeCd,
DBInt statusCd,
DBDateTime expiryDate,
Nullable<bool> isSerialNo,
DBString spare1,
DBString spare2,
DBString spare3,
DBString spare4,
DBString spare5,
DBString spare6,
DBString lastEditComment,
out DateTime lastEditAt
)
Parameters
- sessionId
- Required. Holds the session ID and thus the user who is making this method call.
- itemId
- Required. Holds the ID of the item. Part of key to identify lot.
- lotNo
- Required. Holds the lot number of the item.
- gradeCd
- Optional. Holds the grade code of the lot, if not overridden for a sublot or a particular inventory record.
- statusCd
- Optional. Holds the status code of the lot, if not overridden for a sublot or a particular inventory record.
- expiryDate
Optional. Holds the expiry date and time of the lot, if not overridden for a sublot or a particular inventory record. 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. Holds a flag that, if set to true, specifies the serial number of the lot.
- spare1
- Optional. Holds the contents of the user-defined spare1 field.
- spare2
- Optional. Holds the contents of the user-defined spare2 field.
- spare3
- Optional. Holds the contents of the user-defined spare3 field.
- spare4
- Optional. Holds the contents of the user-defined spare4 field.
- spare5
- Optional. Holds the contents of the user-defined spare5 field.
- spare6
- Optional. Holds the contents of the user-defined spare6 field.
- lastEditComment
- Optional. Holds comments that describes why this record is being added.
- lastEditAt
- Output. Holds the returned date/time when this record was added. The lastEditAt parameter is used by other methods that modify or delete this type of record for optimistic concurrency control.
Observe the following input parameter rules:
- Required non-DB* parameters: Must pass a value. Cannot be empty or null.
-
Optional non-DB* parameters: Either enter a value or pass a null. If passing a null and a default value has been defined, the default value will be used for the parameter.
-
Required DB* parameters: Must pass a value. To enter an empty value for the parameter, pass DB*.null (e.g., DBInt.null).
-
Optional DB* parameters: To enter no value for the parameter, pass DB*.null (e.g., DBInt.null). To use the default value for the parameter if one has been defined for the object being added, pass a null.