Add(Int32,String,DBString,Nullable<Int32>,DBDouble,DBInt,DBInt,DBInt,DBInt,DBInt,DBInt,DBInt,Nullable<Int32>,Nullable<Boolean>,DBInt,DBInt,DBInt,Nullable<Int32>,DBString,DBString,DBString,DBString,DBString,DateTime,Int32) Method
- Last UpdatedNov 06, 2025
- 5 minute read
'Declaration
Public Overloads Shared Sub Add( _
ByVal sessionId As Integer, _
ByVal freqName As String, _
ByVal freqDesc As DBString, _
ByVal freqType As Nullable(Of Integer), _
ByVal interval As DBDouble, _
ByVal intervalUnit As DBInt, _
ByVal prodResetOption As DBInt, _
ByVal offsetStart As DBInt, _
ByVal offsetStartUnit As DBInt, _
ByVal offsetEnd As DBInt, _
ByVal offsetEndUnit As DBInt, _
ByVal samplesPerShift As DBInt, _
ByVal multiplier As Nullable(Of Integer), _
ByVal enabled As Nullable(Of Boolean), _
ByVal expiryTime As DBInt, _
ByVal expiryUnit As DBInt, _
ByVal warningTime As DBInt, _
ByVal warningUnit As Nullable(Of Integer), _
ByVal spare1 As DBString, _
ByVal spare2 As DBString, _
ByVal spare3 As DBString, _
ByVal spare4 As DBString, _
ByVal lastEditComment As DBString, _
ByRef lastEditAt As Date, _
ByRef freqId As Integer _
)
'Usage
Dim sessionId As Integer
Dim freqName As String
Dim freqDesc As DBString
Dim freqType As Nullable(Of Integer)
Dim interval As DBDouble
Dim intervalUnit As DBInt
Dim prodResetOption As DBInt
Dim offsetStart As DBInt
Dim offsetStartUnit As DBInt
Dim offsetEnd As DBInt
Dim offsetEndUnit As DBInt
Dim samplesPerShift As DBInt
Dim multiplier As Nullable(Of Integer)
Dim enabled As Nullable(Of Boolean)
Dim expiryTime As DBInt
Dim expiryUnit As DBInt
Dim warningTime As DBInt
Dim warningUnit As Nullable(Of Integer)
Dim spare1 As DBString
Dim spare2 As DBString
Dim spare3 As DBString
Dim spare4 As DBString
Dim lastEditComment As DBString
Dim lastEditAt As Date
Dim freqId As Integer
SampleFreq.Add(sessionId, freqName, freqDesc, freqType, interval, intervalUnit, prodResetOption, offsetStart, offsetStartUnit, offsetEnd, offsetEndUnit, samplesPerShift, multiplier, enabled, expiryTime, expiryUnit, warningTime, warningUnit, spare1, spare2, spare3, spare4, lastEditComment, lastEditAt, freqId)
public static void Add(
int sessionId,
string freqName,
DBString freqDesc,
Nullable<int> freqType,
DBDouble interval,
DBInt intervalUnit,
DBInt prodResetOption,
DBInt offsetStart,
DBInt offsetStartUnit,
DBInt offsetEnd,
DBInt offsetEndUnit,
DBInt samplesPerShift,
Nullable<int> multiplier,
Nullable<bool> enabled,
DBInt expiryTime,
DBInt expiryUnit,
DBInt warningTime,
Nullable<int> warningUnit,
DBString spare1,
DBString spare2,
DBString spare3,
DBString spare4,
DBString lastEditComment,
out DateTime lastEditAt,
out int freqId
)
Parameters
- sessionId
- Required. Holds the session ID and thus the user who is making this method.
- freqName
- Required. Holds the unique name of the sample plan frequency for display.
- freqDesc
- Optional. Holds the description of the sample plan frequency.
- freqType
Optional. Holds the type of sample plan frequency.
0 = shift
1 (default) = calendar time
2 = run time
3 = production
4 = main item produced changes (job_bom.current_subst for bom_pos = 0)
5 = item consumed at any BOM position changes
6 = the lot number of the main item produced changes (job_bom.def_lot_no for bom_pos = 0)
7 = the lot number of an item consumed at any BOM position changes
8 = the job changes
9 = utilization changes from runtime to downtime
10 = utilization changes from runtime to idle time
11 = utilization changes from downtime to runtime
12 = utilization changes from downtime to idle time
13 = utilization changes from idle time to runtime
14 = utilization changes from idle time to downtime
15 = inventory is received
16 = a new specification value is downloaded for the job running on a job position
17 = a step with action_type 6 starts
18 = a step with action_type 6 finishes
- interval
- Optional. Holds the amount of time or production between samples.
- intervalUnit
Optional. Holds an enumeration that indicates the units for the amount of time or production between samples:
0 = seconds
1= minutes
2 = hours
3 = days
4 = weeks
5 = units of product
6 = number of lots
7 = number of jobs
8 = number of segment responses: 0 – 4 are used when freq_type = 0, 1, or 2 (shift, calendar time, run time); 5 – 8 when freq_type = 3 (production)
- prodResetOption
Optional. Holds an enumeration that indicates what causes the count of production between samples to be reset. Used only if freq_type = 3 (production).
0 = nothing (no reset ever)
1 = job changes on job_exec (disallowed if interval_unit = 7)
2 = main item produced changes
3 = shift changes on entity
4 = entity utilization changes from runtime or downtime to idle time
- offsetStart
- Optional. Holds the offset value from the start of the shift.
- offsetStartUnit
Optional. Holds an enumeration that indicates the units for the offset value from the start of the shift:
1= minutes
2 = hours
3 = days
- offsetEnd
- Optional. Holds the offset value from the end of the shift.
- offsetEndUnit
Optional. Holds an enumeration that indicates the units for the end of the shift:
1= minutes
2 = hours
3 = days
- samplesPerShift
- Optional. Holds the number of times to ready an event between the offsets from the ends of a shift
- multiplier
- Optional. Holds the sample size multiplier.
- enabled
- Optional. Holds a flag that, if true, specifies that the sample frequency can be used at runtime.
- expiryTime
- Optional. Holds the amount of time to wait for the sample to be pulled before changing its status to MISSING.
- expiryUnit
Optional. Holds an enumeration that indicates the units for the expiryTime parameter:
1= minutes
2 = hours
3 = days
- warningTime
- Optional. Holds the amount of time to wait for a sample to be pulled before changing its status to READY WARNING.
- warningUnit
Optional. Holds an enumeration that indicates the units for the warningTime parameter:
1= minutes (default)
2 = hours
3 = days
- spare1
- Optional. Holds a value defined by language term 5157.
- spare2
- Optional. Holds a value defined by language term 5158.
- spare3
- Optional. Holds a value defined by language term 5159.
- spare4
- Optional. Holds a value defined by language term 5160.
- lastEditComment
- Optional. Holds comments that describe why this record is being added.
- lastEditAt
- Out parameter. Holds the date and time that this record was added.
- freqId
- Out parameter. Holds the ID assigned to this record when it is added. The freqId parameter is used by other methods that modify or delete this type of record.
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.