GetAll Method (UserName)

• Visual Basic
• C#

'Declaration
 
Public Shared Function GetAll( _
   ByVal userId As String, _
   ByVal userDesc As String, _
   ByVal active As Nullable(Of Boolean), _
   ByVal hourlyCost As Nullable(Of Double), _
   ByVal langId As Nullable(Of Integer), _
   ByVal defaultDeptId As String, _
   ByVal lastLogIn As Nullable(Of Date), _
   ByVal lastPasswordChange As Nullable(Of Date), _
   ByVal authMethod As Nullable(Of Integer), _
   ByVal defaultLabCd As String, _
   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 DataSet

'Usage
 
Dim userId As String
Dim userDesc As String
Dim active As Nullable(Of Boolean)
Dim hourlyCost As Nullable(Of Double)
Dim langId As Nullable(Of Integer)
Dim defaultDeptId As String
Dim lastLogIn As Nullable(Of Date)
Dim lastPasswordChange As Nullable(Of Date)
Dim authMethod As Nullable(Of Integer)
Dim defaultLabCd As String
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 DataSet
 
value = UserName.GetAll(userId, userDesc, active, hourlyCost, langId, defaultDeptId, lastLogIn, lastPasswordChange, authMethod, defaultLabCd, spare1, spare2, spare3, spare4, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   string userId,
   string userDesc,
   Nullable<bool> active,
   Nullable<double> hourlyCost,
   Nullable<int> langId,
   string defaultDeptId,
   Nullable<DateTime> lastLogIn,
   Nullable<DateTime> lastPasswordChange,
   Nullable<int> authMethod,
   string defaultLabCd,
   string spare1,
   string spare2,
   string spare3,
   string spare4,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

userId

Optional filter parameter. Holds the ID of a user. For example, an employee number or name of an employee.

userDesc

Optional filter parameter. Holds the description for a user. For example, name of an employee.

active

Optional filter parameter. Holds a flag that specifies whether the state of the user is active in the MES system.

hourlyCost

Optional filter parameter. Holds the cost of a labor per hour.

langId

Optional filter parameter. Holds the ID of a user's preferred language.

defaultDeptId

Optional filter parameter. Holds the default department ID of a user.

lastLogIn

Optional filter parameter. Holds the date and time when a user last logged on to the system, in local time (stored in UTC).

lastPasswordChange

Optional filter parameter. Holds the date and time when a user last changed the password, in local time (stored in UTC).

authMethod

Optional filter parameter. Holds an authentication method. The value 0 indicates "Internal" and 1 indicates "Windows (future)".

defaultLabCd

Optional filter parameter. Holds the default labor code of a user.

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.

lastEditBy

Optional filter parameter. A string which contains the ID of the user who created or last modified this record.

lastEditAt

Optional filter parameter. Holds the date/time when a user name record was added or last updated.

Return Value