Public EventCancelled As Boolean ' Event cancelled
Public CancelMessage As String ' Cancel message
' Row Type
Public RowType As Integer
Public CssClass As String = "" ' CSS class
Public CssStyle As String = "" ' CSS style
Public RowClientEvents As String = "" ' Row client events
' Row Attribute
Public ReadOnly Property RowAttributes() As String
Get
Dim sAtt As String = ""
If ew_NotEmpty(CssStyle) Then
sAtt = sAtt & " style=""" & CssStyle.Trim() & """"
End If
If ew_NotEmpty(CssClass) Then
sAtt = sAtt & " class=""" & CssClass.Trim() & """"
End If
If m_Export = "" Then
If ew_NotEmpty(RowClientEvents) Then
sAtt = sAtt & " " & RowClientEvents.Trim()
End If
End If
Return sAtt
End Get
End Property
' Export
Private m_Export As String
Public Property Export() As String
Get
Return m_Export
End Get
Set(ByVal Value As String)
m_Export = Value
End Set
End Property
' Export Original Value
Public ExportOriginalValue As Boolean = EW_EXPORT_ORIGINAL_VALUE
' Export All
Public ExportAll As Boolean = EW_EXPORT_ALL
' Send Email
Public SendEmail As Boolean
' Custom Inner Html
Public TableCustomInnerHtml As Object
'
' Field objects
'
Public Function FieldByName(Name As String) As Object
If Name = "empID" Then Return empID
If Name = "empPayrollNumber" Then Return empPayrollNumber
If Name = "empUsername" Then Return empUsername
If Name = "empName" Then Return empName
If Name = "empFirstName" Then Return empFirstName
If Name = "empLastName" Then Return empLastName
If Name = "empAddress" Then Return empAddress
If Name = "empCity" Then Return empCity
If Name = "empState" Then Return empState
If Name = "empZIP" Then Return empZIP
If Name = "empPhone" Then Return empPhone
If Name = "empStatusID" Then Return empStatusID
If Name = "empStartDate" Then Return empStartDate
If Name = "empPositionID" Then Return empPositionID
If Name = "empRate" Then Return empRate
If Name = "empLastRaiseDate" Then Return empLastRaiseDate
If Name = "empLastRaiseAmount" Then Return empLastRaiseAmount
If Name = "empEmail" Then Return empEmail
If Name = "empLiftCert" Then Return empLiftCert
If Name = "empForkCert" Then Return empForkCert
If Name = "empDriveAuth" Then Return empDriveAuth
If Name = "empTimeClock" Then Return empTimeClock
If Name = "empIsActive" Then Return empIsActive
If Name = "empUserPass" Then Return empUserPass
If Name = "empUserLevel" Then Return empUserLevel
Return Nothing
End Function
' empID
Private m_empID As cField
Public ReadOnly Property empID() As cField
Get
If m_empID Is Nothing Then m_empID = New cField("tblEmployees", "x_empID", "empID", "[empID]", 3, OleDbType.Integer, EW_DATATYPE_NUMBER, 0)
Return m_empID
End Get
End Property
' empPayrollNumber
Private m_empPayrollNumber As cField
Public ReadOnly Property empPayrollNumber() As cField
Get
If m_empPayrollNumber Is Nothing Then m_empPayrollNumber = New cField("tblEmployees", "x_empPayrollNumber", "empPayrollNumber", "[empPayrollNumber]", 3, OleDbType.Integer, EW_DATATYPE_NUMBER, 0)
Return m_empPayrollNumber
End Get
End Property
' empUsername
Private m_empUsername As cField
Public ReadOnly Property empUsername() As cField
Get
If m_empUsername Is Nothing Then m_empUsername = New cField("tblEmployees", "x_empUsername", "empUsername", "[empUsername]", 202, OleDbType.VarWChar, EW_DATATYPE_STRING, 0)
Return m_empUsername
End Get
End Property
' empName
Private m_empName As cField
Public ReadOnly Property empName() As cField
Get
If m_empName Is Nothing Then m_empName = New cField("tblEmployees", "x_empName", "empName", "[empName]", 202, OleDbType.VarWChar, EW_DATATYPE_STRING, 0)
Return m_empName
End Get
End Property
' empFirstName
Private m_empFirstName As cField
Public ReadOnly Property empFirstName() As cField
Get
If m_empFirstName Is Nothing Then m_empFirstName = New cField("tblEmployees", "x_empFirstName", "empFirstName", "[empFirstName]", 202, OleDbType.VarWChar, EW_DATATYPE_STRING, 0)
Return m_empFirstName
End Get
End Property
' empLastName
Private m_empLastName As cField
Public ReadOnly Property empLastName() As cField
Get
If m_empLastName Is Nothing Then m_empLastName = New cField("tblEmployees", "x_empLastName", "empLastName", "[empLastName]", 202, OleDbType.VarWChar, EW_DATATYPE_STRING, 0)
Return m_empLastName
End Get
End Property
' empAddress
Private m_empAddress As cField
Public ReadOnly Property empAddress() As cField
Get
If m_empAddress Is Nothing Then m_empAddress = New cField("tblEmployees", "x_empAddress", "empAddress", "[empAddress]", 202, OleDbType.VarWChar, EW_DATATYPE_STRING, 0)
Return m_empAddress
End Get
End Property
' empCity
Private m_empCity As cField
Public ReadOnly Property empCity() As cField
Get
If m_empCity Is Nothing Then m_empCity = New cField("tblEmployees", "x_empCity", "empCity", "[empCity]", 202, OleDbType.VarWChar, EW_DATATYPE_STRING, 0)
Return m_empCity
End Get
End Property
' empState
Private m_empState As cField
Public ReadOnly Property empState() As cField
Get
If m_empState Is Nothing Then m_empState = New cField("tblEmployees", "x_empState", "empState", "[empState]", 202, OleDbType.VarWChar, EW_DATATYPE_STRING, 0)
Return m_empState
End Get
End Property
' empZIP
Private m_empZIP As cField
Public ReadOnly Property empZIP() As cField
Get
If m_empZIP Is Nothing Then m_empZIP = New cField("tblEmployees", "x_empZIP", "empZIP", "[empZIP]", 202, OleDbType.VarWChar, EW_DATATYPE_STRING, 0)
Return m_empZIP
End Get
End Property
' empPhone
Private m_empPhone As cField
Public ReadOnly Property empPhone() As cField
Get
If m_empPhone Is Nothing Then m_empPhone = New cField("tblEmployees", "x_empPhone", "empPhone", "[empPhone]", 202, OleDbType.VarWChar, EW_DATATYPE_STRING, 0)
Return m_empPhone
End Get
End Property
' empStatusID
Private m_empStatusID As cField
Public ReadOnly Property empStatusID() As cField
Get
If m_empStatusID Is Nothing Then m_empStatusID = New cField("tblEmployees", "x_empStatusID", "empStatusID", "[empStatusID]", 3, OleDbType.Integer, EW_DATATYPE_NUMBER, 0)
Return m_empStatusID
End Get
End Property
' empStartDate
Private m_empStartDate As cField
Public ReadOnly Property empStartDate() As cField
Get
If m_empStartDate Is Nothing Then m_empStartDate = New cField("tblEmployees", "x_empStartDate", "empStartDate", "[empStartDate]", 135, OleDbType.DBTimeStamp, EW_DATATYPE_DATE, 6)
Return m_empStartDate
End Get
End Property
' empPositionID
Private m_empPositionID As cField
Public ReadOnly Property empPositionID() As cField
Get
If m_empPositionID Is Nothing Then m_empPositionID = New cField("tblEmployees", "x_empPositionID", "empPositionID", "[empPositionID]", 3, OleDbType.Integer, EW_DATATYPE_NUMBER, 0)
Return m_empPositionID
End Get
End Property
' empRate
Private m_empRate As cField
Public ReadOnly Property empRate() As cField
Get
If m_empRate Is Nothing Then m_empRate = New cField("tblEmployees", "x_empRate", "empRate", "[empRate]", 6, OleDbType.Currency, EW_DATATYPE_NUMBER, 0)
Return m_empRate
End Get
End Property
' empLastRaiseDate
Private m_empLastRaiseDate As cField
Public ReadOnly Property empLastRaiseDate() As cField
Get
If m_empLastRaiseDate Is Nothing Then m_empLastRaiseDate = New cField("tblEmployees", "x_empLastRaiseDate", "empLastRaiseDate", "[empLastRaiseDate]", 135, OleDbType.DBTimeStamp, EW_DATATYPE_DATE, 6)
Return m_empLastRaiseDate
End Get
End Property
' empLastRaiseAmount
Private m_empLastRaiseAmount As cField
Public ReadOnly Property empLastRaiseAmount() As cField
Get
If m_empLastRaiseAmount Is Nothing Then m_empLastRaiseAmount = New cField("tblEmployees", "x_empLastRaiseAmount", "empLastRaiseAmount", "[empLastRaiseAmount]", 6, OleDbType.Currency, EW_DATATYPE_NUMBER, 0)
Return m_empLastRaiseAmount
End Get
End Property
' empEmail
Private m_empEmail As cField
Public ReadOnly Property empEmail() As cField
Get
If m_empEmail Is Nothing Then m_empEmail = New cField("tblEmployees", "x_empEmail", "empEmail", "[empEmail]", 202, OleDbType.VarWChar, EW_DATATYPE_STRING, 0)
Return m_empEmail
End Get
End Property
' empLiftCert
Private m_empLiftCert As cField
Public ReadOnly Property empLiftCert() As cField
Get
If m_empLiftCert Is Nothing Then m_empLiftCert = New cField("tblEmployees", "x_empLiftCert", "empLiftCert", "[empLiftCert]", 11, OleDbType.Boolean, EW_DATATYPE_BOOLEAN, 0)
Return m_empLiftCert
End Get
End Property
' empForkCert
Private m_empForkCert As cField
Public ReadOnly Property empForkCert() As cField
Get
If m_empForkCert Is Nothing Then m_empForkCert = New cField("tblEmployees", "x_empForkCert", "empForkCert", "[empForkCert]", 11, OleDbType.Boolean, EW_DATATYPE_BOOLEAN, 0)
Return m_empForkCert
End Get
End Property
' empDriveAuth
Private m_empDriveAuth As cField
Public ReadOnly Property empDriveAuth() As cField
Get
If m_empDriveAuth Is Nothing Then m_empDriveAuth = New cField("tblEmployees", "x_empDriveAuth", "empDriveAuth", "[empDriveAuth]", 11, OleDbType.Boolean, EW_DATATYPE_BOOLEAN, 0)
Return m_empDriveAuth
End Get
End Property
' empTimeClock
Private m_empTimeClock As cField
Public ReadOnly Property empTimeClock() As cField
Get
If m_empTimeClock Is Nothing Then m_empTimeClock = New cField("tblEmployees", "x_empTimeClock", "empTimeClock", "[empTimeClock]", 11, OleDbType.Boolean, EW_DATATYPE_BOOLEAN, 0)
Return m_empTimeClock
End Get
End Property
' empIsActive
Private m_empIsActive As cField
Public ReadOnly Property empIsActive() As cField
Get
If m_empIsActive Is Nothing Then m_empIsActive = New cField("tblEmployees", "x_empIsActive", "empIsActive", "[empIsActive]", 11, OleDbType.Boolean, EW_DATATYPE_BOOLEAN, 0)
Return m_empIsActive
End Get
End Property
' empUserPass
Private m_empUserPass As cField
Public ReadOnly Property empUserPass() As cField
Get
If m_empUserPass Is Nothing Then m_empUserPass = New cField("tblEmployees", "x_empUserPass", "empUserPass", "[empUserPass]", 202, OleDbType.VarWChar, EW_DATATYPE_STRING, 0)
Return m_empUserPass
End Get
End Property
' empUserLevel
Private m_empUserLevel As cField
Public ReadOnly Property empUserLevel() As cField
Get
If m_empUserLevel Is Nothing Then m_empUserLevel = New cField("tblEmployees", "x_empUserLevel", "empUserLevel", "[empUserLevel]", 3, OleDbType.Integer, EW_DATATYPE_NUMBER, 0)
Return m_empUserLevel
End Get
End Property
' Table level events
' Recordset Selecting event
Public Sub Recordset_Selecting(ByRef filter As String)