sSqlWrk = "SELECT [empName] FROM [tblEmployees] WHERE [empID] = " & ew_AdjustSql(schEmpID.CurrentValue) & ""
sSqlWrk = sSqlWrk & " ORDER BY [empFirstName] "
RsWrk = Conn.GetTempDataReader(sSqlWrk)
If RsWrk.Read() Then
schEmpID.ViewValue = RsWrk("empName")
Else
schEmpID.ViewValue = schEmpID.CurrentValue
End If
Conn.CloseTempDataReader()
Else
schEmpID.ViewValue = System.DBNull.Value
End If
schEmpID.CssStyle = ""
schEmpID.CssClass = ""
schEmpID.ViewCustomAttributes = ""
' schPosID
If ew_NotEmpty(schPosID.CurrentValue) Then
sSqlWrk = "SELECT [posDescription] FROM [tblPositions] WHERE [posID] = " & ew_AdjustSql(schPosID.CurrentValue) & ""
sSqlWrk = sSqlWrk & " ORDER BY [posDescription] "
RsWrk = Conn.GetTempDataReader(sSqlWrk)
If RsWrk.Read() Then
schPosID.ViewValue = RsWrk("posDescription")
Else
schPosID.ViewValue = schPosID.CurrentValue
End If
Conn.CloseTempDataReader()
Else
schPosID.ViewValue = System.DBNull.Value
End If
schPosID.CssStyle = ""
schPosID.CssClass = ""
schPosID.ViewCustomAttributes = ""
' schTypID
If ew_NotEmpty(schTypID.CurrentValue) Then
sSqlWrk = "SELECT [typDescription] FROM [tblTypes] WHERE [typID] = " & ew_AdjustSql(schTypID.CurrentValue) & ""
sSqlWrk = sSqlWrk & " ORDER BY [typDescription] "
RsWrk = Conn.GetTempDataReader(sSqlWrk)
If RsWrk.Read() Then
schTypID.ViewValue = RsWrk("typDescription")
Else
schTypID.ViewValue = schTypID.CurrentValue
End If
Conn.CloseTempDataReader()
Else
schTypID.ViewValue = System.DBNull.Value
End If
schTypID.CssStyle = ""
schTypID.CssClass = ""
schTypID.ViewCustomAttributes = ""
' schDate
schDate.HrefValue = ""
' schEvtID
schEvtID.HrefValue = ""
' schPartsID
schPartsID.HrefValue = ""
' schLocID
schLocID.HrefValue = ""
' schCallTime
schCallTime.HrefValue = ""
' schStartTime
schStartTime.HrefValue = ""
' schEndTime
schEndTime.HrefValue = ""
' schOutTime
schOutTime.HrefValue = ""
' schEmpID
schEmpID.HrefValue = ""
' schPosID
schPosID.HrefValue = ""
' schTypID
schTypID.HrefValue = ""
' schDepID
schDepID.HrefValue = ""
' Row Rendered event
Row_Rendered()
End Sub
Public CurrentAction As String ' Current action
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(ByVal Name As String) As Object
If Name = "schSchID" Then Return schSchID
If Name = "schDate" Then Return schDate
If Name = "schEvtID" Then Return schEvtID
If Name = "schPartsID" Then Return schPartSID
If Name = "schCallTime" Then Return schCallTime
If Name = "schStartTime" Then Return schStartTime
If Name = "schEndTime" Then Return schEndTime
If Name = "schOutTime" Then Return schOutTime
If Name = "schLocID" Then Return schLocID
If Name = "schEmpID" Then Return schEmpID
If Name = "schPosID" Then Return schPosID
If Name = "schTypID" Then Return schTypID
If Name = "schDepID" Then Return schDepID
If Name = "schDepID" Then Return schDepID
If Name = "schNotes" Then Return schNotes
Return Nothing
End Function
' schSchID
Private m_schSchID As cField
Public ReadOnly Property schSchID() As cField
Get
If m_schSchID Is Nothing Then m_schSchID = New cField("askScheduleReport", "x_schSchID", "schSchID", "askScheduleReport.schSchID", 3, OleDbType.Integer, EW_DATATYPE_NUMBER, 0)
Return m_schSchID
End Get
End Property
' schDate
Private m_schDate As cField
Public ReadOnly Property schDate() As cField
Get
If m_schDate Is Nothing Then m_schDate = New cField("askScheduleReport", "x_schDate", "schDate", "askScheduleReport.schDate", 7, OleDbType.Date, EW_DATATYPE_DATE, 6)
Return m_schDate
End Get
End Property
' schEvtID
Private m_schEvtID As cField
Public ReadOnly Property schEvtID() As cField
Get
If m_schEvtID Is Nothing Then m_schEvtID = New cField("askScheduleReport", "x_schEvtID", "schEvtID", "askScheduleReport.schEvtID", 3, OleDbType.Integer, EW_DATATYPE_NUMBER, 0)
Return m_schEvtID
End Get
End Property
' schPartsID
Private m_schPartsID As cField
Public ReadOnly Property schPartsID() As cField
Get
If m_schPartsID Is Nothing Then m_schPartsID = New cField("askScheduleReport", "x_schPartsID", "schPartsID", "askScheduleReport.schPartsID", 3, OleDbType.Integer, EW_DATATYPE_NUMBER, 0)
Return m_schPartsID
End Get
End Property
' schLocID
Private m_schLocID As cField
Public ReadOnly Property schLocID() As cField
Get
If m_schLocID Is Nothing Then m_schLocID = New cField("askScheduleReport", "x_schLocID", "schLocID", "[schLocID]", 3, OleDbType.Integer, EW_DATATYPE_NUMBER, 0)
Return m_schLocID
End Get
End Property
' schEmpID
Private m_schEmpID As cField
Public ReadOnly Property schEmpID() As cField
Get
If m_schEmpID Is Nothing Then m_schEmpID = New cField("askScheduleReport", "x_schEmpID", "schEmpID", "askScheduleReport.schEmpID", 3, OleDbType.Integer, EW_DATATYPE_NUMBER, 0)
Return m_schEmpID
End Get
End Property
' schPosID
Private m_schPosID As cField
Public ReadOnly Property schPosID() As cField
Get
If m_schPosID Is Nothing Then m_schPosID = New cField("askScheduleReport", "x_schPosID", "schPosID", "[schPosID]", 3, OleDbType.Integer, EW_DATATYPE_NUMBER, 0)
Return m_schPosID
End Get
End Property
' schTypID
Private m_schTypID As cField
Public ReadOnly Property schTypID() As cField
Get
If m_schTypID Is Nothing Then m_schTypID = New cField("askScheduleReport", "x_schTypID", "schTypID", "[schTypID]", 3, OleDbType.Integer, EW_DATATYPE_NUMBER, 0)
Return m_schTypID
End Get
End Property
' schDepID
Private m_schDepID As cField
Public ReadOnly Property schDepID() As cField
Get
If m_schDepID Is Nothing Then m_schDepID = New cField("askScheduleReport", "x_schDepID", "schDepID", "[schDepID]", 3, OleDbType.Integer, EW_DATATYPE_NUMBER, 0)
Return m_schDepID
End Get
End Property
' schCallTime
Private m_schCallTime As cField
Public ReadOnly Property schCallTime() As cField
Get
If m_schCallTime Is Nothing Then m_schCallTime = New cField("askScheduleReport", "x_schCallTime", "schCallTime", "[schCallTime]", 135, OleDbType.DBTimeStamp, EW_DATATYPE_DATE, 4)
Return m_schDate
End Get
End Property
' schStartTime
Private m_schStartTime As cField
Public ReadOnly Property schStartTime() As cField
Get
If m_schStartTime Is Nothing Then m_schStartTime = New cField("askScheduleReport", "x_schStartTime", "schStartTime", "[schStartTime]", 135, OleDbType.DBTimeStamp, EW_DATATYPE_DATE, 4)
Return m_schDate
End Get
End Property
' schEndTime
Private m_schEndTime As cField
Public ReadOnly Property schEndTime() As cField
Get
If m_schEndTime Is Nothing Then m_schEndTime = New cField("askScheduleReport", "x_schEndTime", "schEndTime", "[schEndTime]", 135, OleDbType.DBTimeStamp, EW_DATATYPE_DATE, 4)
Return m_schDate
End Get
End Property
' schOutTime
Private m_schOutTime As cField
Public ReadOnly Property schOutTime() As cField
Get
If m_schOutTime Is Nothing Then m_schOutTime = New cField("askScheduleReport", "x_schOutTime", "schOutTime", "[schOutTime]", 135, OleDbType.DBTimeStamp, EW_DATATYPE_DATE, 4)
Return m_schDate
End Get
End Property
' schNotes
Private m_schNotes As cField
Public ReadOnly Property schNotes() As cField
Get
If m_schNotes Is Nothing Then m_schNotes = New cField("askScheduleReport", "x_schNotes", "schNotes", "[schNotes]", 203, OleDbType.LongVarWChar, EW_DATATYPE_MEMO, 0)
Return m_schNotes
End Get
End Property
' Table level events
' Recordset Selecting event
Public Sub Recordset_Selecting(ByRef filter As String)
' Enter your code here
End Sub
' Recordset Selected event
Public Sub Recordset_Selected(ByVal rs As DbDataReader)