GetProdCount(String,String,Nullable<Int32>,Nullable<Int32>,Nullable<DateTime>,Nullable<DateTime>,String,String,String,String,String,String,Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,Nullable<Double>,Nullable<Double>,String,String,String,Nullable<Boolean>,Nullable<Int32>,Nullable<Boolean>,Nullable<Int32>,String,String,String,String,String,String,String,String,String,Nullable<DateTime>,Nullable<DateTime>,Nullable<Int32>,Int32) Method
- Last UpdatedNov 06, 2025
- 5 minute read
The GetProdCount() method retrieves a count of production records based on the supplied filter.
'Declaration
Public Overloads Shared Sub GetProdCount( _
ByVal woId As String, _
ByVal operId As String, _
ByVal seqNo As Nullable(Of Integer), _
ByVal shiftId As Nullable(Of Integer), _
ByVal shiftStartStart As Nullable(Of Date), _
ByVal shiftStartEnd As Nullable(Of Date), _
ByVal itemId As String, _
ByVal itemDesc As String, _
ByVal lotNo As String, _
ByVal rmLotNo As String, _
ByVal subLotNo As String, _
ByVal rmSubLotNo As String, _
ByVal reasCd As Nullable(Of Integer), _
ByVal gradeCd As Nullable(Of Integer), _
ByVal statusCd As Nullable(Of Integer), _
ByVal runEntId As Nullable(Of Integer), _
ByVal storageEntId As Nullable(Of Integer), _
ByVal qtyMin As Nullable(Of Double), _
ByVal qtyMax As Nullable(Of Double), _
ByVal userId As String, _
ByVal userDesc As String, _
ByVal extRef As String, _
ByVal goodProd As Nullable(Of Boolean), _
ByVal processedFlag As Nullable(Of Integer), _
ByVal byproduct As Nullable(Of Boolean), _
ByVal moveStatus As Nullable(Of Integer), _
ByVal genealogyId As String, _
ByVal eventId As String, _
ByVal segmentRequirementId As String, _
ByVal segmentResponseId As String, _
ByVal comments As String, _
ByVal spare1 As String, _
ByVal spare2 As String, _
ByVal spare3 As String, _
ByVal spare4 As String, _
ByVal createdAtStart As Nullable(Of Date), _
ByVal createdAtEnd As Nullable(Of Date), _
ByVal rowId As Nullable(Of Integer), _
ByRef noOfProdRecords As Integer _
)
'Usage
Dim woId As String
Dim operId As String
Dim seqNo As Nullable(Of Integer)
Dim shiftId As Nullable(Of Integer)
Dim shiftStartStart As Nullable(Of Date)
Dim shiftStartEnd As Nullable(Of Date)
Dim itemId As String
Dim itemDesc As String
Dim lotNo As String
Dim rmLotNo As String
Dim subLotNo As String
Dim rmSubLotNo As String
Dim reasCd As Nullable(Of Integer)
Dim gradeCd As Nullable(Of Integer)
Dim statusCd As Nullable(Of Integer)
Dim runEntId As Nullable(Of Integer)
Dim storageEntId As Nullable(Of Integer)
Dim qtyMin As Nullable(Of Double)
Dim qtyMax As Nullable(Of Double)
Dim userId As String
Dim userDesc As String
Dim extRef As String
Dim goodProd As Nullable(Of Boolean)
Dim processedFlag As Nullable(Of Integer)
Dim byproduct As Nullable(Of Boolean)
Dim moveStatus As Nullable(Of Integer)
Dim genealogyId As String
Dim eventId As String
Dim segmentRequirementId As String
Dim segmentResponseId As String
Dim comments As String
Dim spare1 As String
Dim spare2 As String
Dim spare3 As String
Dim spare4 As String
Dim createdAtStart As Nullable(Of Date)
Dim createdAtEnd As Nullable(Of Date)
Dim rowId As Nullable(Of Integer)
Dim noOfProdRecords As Integer
ItemProd.GetProdCount(woId, operId, seqNo, shiftId, shiftStartStart, shiftStartEnd, itemId, itemDesc, lotNo, rmLotNo, subLotNo, rmSubLotNo, reasCd, gradeCd, statusCd, runEntId, storageEntId, qtyMin, qtyMax, userId, userDesc, extRef, goodProd, processedFlag, byproduct, moveStatus, genealogyId, eventId, segmentRequirementId, segmentResponseId, comments, spare1, spare2, spare3, spare4, createdAtStart, createdAtEnd, rowId, noOfProdRecords)
public static void GetProdCount(
string woId,
string operId,
Nullable<int> seqNo,
Nullable<int> shiftId,
Nullable<DateTime> shiftStartStart,
Nullable<DateTime> shiftStartEnd,
string itemId,
string itemDesc,
string lotNo,
string rmLotNo,
string subLotNo,
string rmSubLotNo,
Nullable<int> reasCd,
Nullable<int> gradeCd,
Nullable<int> statusCd,
Nullable<int> runEntId,
Nullable<int> storageEntId,
Nullable<double> qtyMin,
Nullable<double> qtyMax,
string userId,
string userDesc,
string extRef,
Nullable<bool> goodProd,
Nullable<int> processedFlag,
Nullable<bool> byproduct,
Nullable<int> moveStatus,
string genealogyId,
string eventId,
string segmentRequirementId,
string segmentResponseId,
string comments,
string spare1,
string spare2,
string spare3,
string spare4,
Nullable<DateTime> createdAtStart,
Nullable<DateTime> createdAtEnd,
Nullable<int> rowId,
out int noOfProdRecords
)
Parameters
- woId
- Optional filter parameter. Holds the work order ID for identifying the job that produced an item.
- operId
- Optional filter parameter. Holds the operation ID for identifying the job that produced an item.
- seqNo
- Optional filter parameter. Holds the operation sequence number for identifying the job that produced an item.
- shiftId
- Optional filter parameter. Holds the ID of the shift during which an item was produced.
- shiftStartStart
- Optional filter parameter. Holds the start time of the shift during which an item was produced.
- shiftStartEnd
- Optional filter parameter. Holds the end time of the shift during which an item was produced.
- itemId
- Optional filter parameter. Holds an item ID.
- itemDesc
- Optional filter parameter. Holds an item description.
- lotNo
- Optional filter parameter. Holds the lot number to which an item belongs.
- rmLotNo
- Optional filter parameter. Holds the lot number of the raw material from which a lot/sublot was produced.
- subLotNo
- Optional filter parameter. Holds the sublot number to which an item belongs.
- rmSubLotNo
- Optional filter parameter. Holds the sublot number of the raw material from which a lot/sublot was produced.
- reasCd
- Optional filter parameter. Holds a reason code that uniquely identifies grade + status of goods produced.
- gradeCd
- Optional filter parameter. Holds the grade code of a produced item.
- statusCd
- Optional filter parameter. Holds the status code of a produced item.
- runEntId
- Optional filter parameter. Holds the ID of the entity on which the job that produced an item is running.
- storageEntId
- Optional filter parameter. Holds the ID of the storage entity to which the produced item was moved.
- qtyMin
- Optional filter parameter. Holds the minimum amount of an item that must be produced.
- qtyMax
- Optional filter parameter. Holds the maximum amount of an item that must be produced.
- userId
- Optional filter parameter. Holds the ID of the user who ran the job that produced an item.
- userDesc
- Optional filter parameter. Holds the description of the user who ran the job that produced an item.
- extRef
- Optional filter parameter. Holds the reference to the external system for defect tracking or any other purpose.
- goodProd
- Optional filter parameter. Holds a flag that specifies whether an item is designated as good production.
- processedFlag
- Optional filter parameter. Holds a flag that specifies whether an item was processed.
- byproduct
- Optional filter parameter. Holds a flag that specifies whether an item is a by-product.
- moveStatus
Optional filter parameter. Holds an integer that indicates whether the lot been moved to the next operation.
0=not moved to the next operation
1=moved to the next operation
- genealogyId
- Optional filter parameter. Holds the genealogy ID.
- eventId
- Optional filter parameter. Holds the event ID.
- segmentRequirementId
- Optional filter parameter. Holds the segment requirement ID.
- segmentResponseId
- Optional filter parameter. Holds the segment response ID.
- comments
- Optional filter parameter. Holds comments about the produced item.
- spare1
- Optional filter parameter. Holds the contents of the user-defined spare1 field.
- spare2
- Optional filter parameter. Holds the contents of the user-defined spare2 field.
- spare3
- Optional filter parameter. Holds the contents of the user-defined spare3 field.
- spare4
- Optional filter parameter. Holds the contents of the user-defined spare4 field.
- createdAtStart
- Optional filter parameter. Holds the start date/time when this type of record was created.
- createdAtEnd
- Optional filter parameter. Holds the end date/time when this type of record was created.
- rowId
- Optional filter parameter. Holds the row ID of an item production record.
- noOfProdRecords
- Output. Holds the returned number of item production records that match the specified filters.