CreateListFromFilter Method (StorageExec)

• Visual Basic
• C#

'Declaration
 
Public Shared Function CreateListFromFilter( _
   ByVal entId As Nullable(Of Integer), _
   ByVal storageType As String, _
   ByVal status As Nullable(Of Integer), _
   ByVal maxCapacity As Nullable(Of Double), _
   ByVal uomId As Nullable(Of Integer), _
   ByVal tare As Nullable(Of Double), _
   ByVal tareUomId As Nullable(Of Integer), _
   ByVal autoDelZeroInv As Nullable(Of Boolean), _
   ByVal allowNegQty As Nullable(Of Boolean), _
   ByVal scannableId As String, _
   ByVal allowMultipleItems As Nullable(Of Boolean), _
   ByVal allowMultipleLots As Nullable(Of Boolean), _
   ByVal movable As Nullable(Of Boolean), _
   ByVal storageEntId As Nullable(Of Integer), _
   ByVal allowDirtyState As Nullable(Of Boolean), _
   ByVal logStateTransitions As Nullable(Of Boolean), _
   ByVal indistinguishableLots As Nullable(Of Boolean), _
   ByVal unlisted As Nullable(Of Boolean), _
   ByVal spareInt1 As Nullable(Of Integer), _
   ByVal spareInt2 As Nullable(Of Integer), _
   ByVal spareInt3 As Nullable(Of Integer), _
   ByVal spareInt4 As Nullable(Of Integer), _
   ByVal spare1 As String, _
   ByVal spare2 As String, _
   ByVal spare3 As String, _
   ByVal spare4 As String, _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date) _
) As BindingList(Of StorageExec)

'Usage
 
Dim entId As Nullable(Of Integer)
Dim storageType As String
Dim status As Nullable(Of Integer)
Dim maxCapacity As Nullable(Of Double)
Dim uomId As Nullable(Of Integer)
Dim tare As Nullable(Of Double)
Dim tareUomId As Nullable(Of Integer)
Dim autoDelZeroInv As Nullable(Of Boolean)
Dim allowNegQty As Nullable(Of Boolean)
Dim scannableId As String
Dim allowMultipleItems As Nullable(Of Boolean)
Dim allowMultipleLots As Nullable(Of Boolean)
Dim movable As Nullable(Of Boolean)
Dim storageEntId As Nullable(Of Integer)
Dim allowDirtyState As Nullable(Of Boolean)
Dim logStateTransitions As Nullable(Of Boolean)
Dim indistinguishableLots As Nullable(Of Boolean)
Dim unlisted As Nullable(Of Boolean)
Dim spareInt1 As Nullable(Of Integer)
Dim spareInt2 As Nullable(Of Integer)
Dim spareInt3 As Nullable(Of Integer)
Dim spareInt4 As Nullable(Of Integer)
Dim spare1 As String
Dim spare2 As String
Dim spare3 As String
Dim spare4 As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As BindingList(Of StorageExec)
 
value = StorageExec.CreateListFromFilter(entId, storageType, status, maxCapacity, uomId, tare, tareUomId, autoDelZeroInv, allowNegQty, scannableId, allowMultipleItems, allowMultipleLots, movable, storageEntId, allowDirtyState, logStateTransitions, indistinguishableLots, unlisted, spareInt1, spareInt2, spareInt3, spareInt4, spare1, spare2, spare3, spare4, lastEditBy, lastEditAt)

public static BindingList<StorageExec> CreateListFromFilter( 
   Nullable<int> entId,
   string storageType,
   Nullable<int> status,
   Nullable<double> maxCapacity,
   Nullable<int> uomId,
   Nullable<double> tare,
   Nullable<int> tareUomId,
   Nullable<bool> autoDelZeroInv,
   Nullable<bool> allowNegQty,
   string scannableId,
   Nullable<bool> allowMultipleItems,
   Nullable<bool> allowMultipleLots,
   Nullable<bool> movable,
   Nullable<int> storageEntId,
   Nullable<bool> allowDirtyState,
   Nullable<bool> logStateTransitions,
   Nullable<bool> indistinguishableLots,
   Nullable<bool> unlisted,
   Nullable<int> spareInt1,
   Nullable<int> spareInt2,
   Nullable<int> spareInt3,
   Nullable<int> spareInt4,
   string spare1,
   string spare2,
   string spare3,
   string spare4,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

entId

Optional filter parameter. Holds an entity that can store material.

storageType

Optional filter parameter. Holds a user-defined string used for sorting.

status

Optional filter parameter. Holds the status of a storage entity.

maxCapacity

Optional filter parameter. Holds a maximum storage capacity.

uomId

Optional filter parameter. Holds the ID of a unit of measure for maxCapacity.

tare

Optional filter parameter. Holds a weight of the entity when empty.

tareUomId

Optional filter parameter. Holds the ID of a unit of measure for the tare weight.

autoDelZeroInv

Optional filter parameter. Holds a flag that indicates whether to delete the row from the Item_Inv table when the quantity left is less than or equal to zero.

allowNegQty

Optional filter parameter. Holds a flag that indicates whether the storage entity allows negative quantity left values.

scannableId

Optional filter parameter. Holds a bar code scan ID to uniquely identify the entity.

allowMultipleItems

Optional filter parameter. Holds a flag that indicates whether different items can be stored within this storage entity.

allowMultipleLots

Optional filter parameter. Holds a flag that indicates whether different lot numbers can be stored within this entity.

movable

Optional filter parameter. Holds a flag that indicates whether this storage entity is movable.

storageEntId

Optional filter parameter. Holds the ID of another entity where this storage entity is currently located (only used when this storage entity is movable).

allowDirtyState

Optional filter parameter. Holds a flag that indicates whether the Dirty state (status = 2) is available for this storage entity.

logStateTransitions

Optional filter parameter. Holds a flag that indicates whether state transitions are logged for this entity.

indistinguishableLots

Optional filter parameter. Holds a flag that indicates whether inventory stored in this entity cannot be separated by lot number when consumed, shipped, or transferred out.

unlisted

Optional filter parameter. Holds a flag that indicates whether this entity will not be displayed in certain trees and lists of storage entities.

spareInt1

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

spareInt2

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

spareInt3

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

spareInt4

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

spare1

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

spare2

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

spare3

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

spare4

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

lastEditBy

Optional filter parameter. Holds the user who last added or changed a storage exec record.

lastEditAt

Optional filter parameter. Holds the date/time when a storage exec record was last added or changed.

Return Value