home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
66.142.0.142
/
66.142.0.142.tar
/
66.142.0.142
/
viewScheduleview.aspx.vb
< prev
next >
Wrap
Text File
|
2010-08-24
|
21KB
|
698 lines
Imports System.Data
Imports System.Data.Common
Imports System.Xml
Imports System.IO
Imports System.Data.OleDb
'
' ASP.NET code-behind class (Page)
'
Partial Class viewScheduleview
Inherits AspNetMaker7_tfpssnet
' Page object
Public viewSchedule_view As cviewSchedule_view
'
' Page Class
'
Class cviewSchedule_view
Inherits AspNetMakerPage
Implements IDisposable
' Used by system generated functions
Private RsWrk As Object, sSqlWrk As String, sWhereWrk As String
Private arwrk As Object
Private armultiwrk() As String
' Page URL
Public ReadOnly Property PageUrl() As String
Get
Dim Url As String = ew_CurrentPage() & "?"
If viewSchedule.UseTokenInUrl Then Url = Url & "t=" & viewSchedule.TableVar & "&" ' Add page token
Return Url
End Get
End Property
' Validate page request
Public Function IsPageRequest() As Boolean
Dim Result As Boolean
If viewSchedule.UseTokenInUrl Then
Result = False
If ObjForm IsNot Nothing Then
Result = (viewSchedule.TableVar = ObjForm.GetValue("t"))
End If
If ew_Get("t") <> "" Then
Result = (viewSchedule.TableVar = ew_Get("t"))
End If
Return Result
End If
Return True
End Function
' viewSchedule
Public Property viewSchedule() As cviewSchedule
Get
Return ParentPage.viewSchedule
End Get
Set(ByVal v As cviewSchedule)
ParentPage.viewSchedule = v
End Set
End Property
' viewSchedule
Public Property tblEmployees() As ctblEmployees
Get
Return ParentPage.tblEmployees
End Get
Set(ByVal v As ctblEmployees)
ParentPage.tblEmployees = v
End Set
End Property
'
' Constructor
' - init objects
' - open connection
'
Public Sub New(ByRef APage As AspNetMaker7_tfpssnet)
m_ParentPage = APage
m_Page = Me
m_PageID = "view"
m_PageObjName = "viewSchedule_view"
m_PageObjTypeName = "cviewSchedule_view"
' Table Name
m_TableName = "viewSchedule"
' Initialize table object
viewSchedule = New cviewSchedule(Me)
tblEmployees = New ctblEmployees(Me)
' Connect to database
Conn = New cConnection()
End Sub
'
' Subroutine Page_Init
' - called before page main
' - check Security
' - set up response header
' - call page load events
'
Public Sub Page_Init()
Security = New cAdvancedSecurity(Me)
If Not Security.IsLoggedIn() Then Security.AutoLogin()
If Not Security.IsLoggedIn() Then
Security.SaveLastUrl()
Page_Terminate("login.aspx")
End If
' Table Permission loading event
Security.TablePermission_Loading()
Security.LoadCurrentUserLevel(TableName)
' Table Permission loaded event
Security.TablePermission_Loaded()
If Not Security.CanView Then
Security.SaveLastUrl()
Page_Terminate("viewSchedulelist.aspx")
End If
' User ID loading event
Security.UserID_Loading()
If Security.IsLoggedIn() Then Call Security.LoadUserID()
' User ID loaded event
Security.UserID_Loaded()
If Security.IsLoggedIn() And ew_Empty(Security.CurrentUserID) Then
Message = "You do not have the right permission to view the page"
Page_Terminate("viewSchedulelist.aspx")
End If
' Global page loading event (in ewglobal*.vb)
ParentPage.Page_Loading()
' Page load event, used in current page
Page_Load()
End Sub
'
' Class terminate
' - clean up page object
'
Public Sub Dispose() Implements IDisposable.Dispose
Page_Terminate("")
End Sub
'
' Sub Page_Terminate
' - called when exit page
' - clean up connection and objects
' - if URL specified, redirect to URL
'
Sub Page_Terminate(url As String)
' Page unload event, used in current page
Page_Unload()
' Global page unloaded event (in ewglobal*.vb)
ParentPage.Page_Unloaded()
' Close connection
Conn.Dispose()
Security = Nothing
viewSchedule.Dispose()
tblEmployees.Dispose()
' Go to URL if specified
If url <> "" Then
HttpContext.Current.Response.Clear()
HttpContext.Current.Response.Redirect(url)
End If
End Sub
Public lDisplayRecs As Integer ' Number of display records
Public lStartRec As Integer, lStopRec As Integer, lTotalRecs As Integer, lRecRange As Integer
Public lRecCnt As Integer
Public sSrchWhere As String
'
' Page main processing
'
Sub Page_Main()
Dim sReturnUrl As String = ""
Dim bMatchRecord As Boolean = False
If IsPageRequest Then ' Validate request
If ew_Get("schSchID") <> "" Then
viewSchedule.schSchID.QueryStringValue = ew_Get("schSchID")
Else
sReturnUrl = "viewSchedulelist.aspx" ' Return to list
End If
' Get action
viewSchedule.CurrentAction = "I" ' Display form
Select Case viewSchedule.CurrentAction
Case "I" ' Get a record to display
If Not LoadRow() Then ' Load record based on key
Message = "No records found" ' Set no record message
sReturnUrl = "viewSchedulelist.aspx" ' No matching record, return to list
End If
End Select
Else
sReturnUrl = "viewSchedulelist.aspx" ' Not page request, return to list
End If
If sReturnUrl <> "" Then Page_Terminate(sReturnUrl)
' Render row
viewSchedule.RowType = EW_ROWTYPE_VIEW
RenderRow()
End Sub
Public Pager As Object
'
' Set up Starting Record parameters
'
Sub SetUpStartRec()
Dim nPageNo As Integer
' Exit if lDisplayRecs = 0
If lDisplayRecs = 0 Then Exit Sub
If IsPageRequest Then ' Validate request
' Check for a "start" parameter
If ew_Get(EW_TABLE_START_REC) <> "" AndAlso IsNumeric(ew_Get(EW_TABLE_START_REC)) Then
lStartRec = ew_ConvertToInt(ew_Get(EW_TABLE_START_REC))
viewSchedule.StartRecordNumber = lStartRec
ElseIf ew_Get(EW_TABLE_PAGE_NO) <> "" AndAlso IsNumeric(ew_Get(EW_TABLE_PAGE_NO)) Then
nPageNo = ew_ConvertToInt(ew_Get(EW_TABLE_PAGE_NO))
lStartRec = (nPageNo-1)*lDisplayRecs+1
If lStartRec <= 0 Then
lStartRec = 1
ElseIf lStartRec >= ((lTotalRecs-1)\lDisplayRecs)*lDisplayRecs+1 Then
lStartRec = ((lTotalRecs-1)\lDisplayRecs)*lDisplayRecs+1
End If
viewSchedule.StartRecordNumber = lStartRec
End If
End If
lStartRec = viewSchedule.StartRecordNumber
' Check if correct start record counter
If lStartRec <= 0 Then ' Avoid invalid start record counter
lStartRec = 1 ' Reset start record counter
viewSchedule.StartRecordNumber = lStartRec
ElseIf lStartRec > lTotalRecs Then ' Avoid starting record > total records
lStartRec = ((lTotalRecs-1)\lDisplayRecs)*lDisplayRecs+1 ' Point to last page first record
viewSchedule.StartRecordNumber = lStartRec
ElseIf (lStartRec-1) Mod lDisplayRecs <> 0 Then
lStartRec = ((lStartRec-1)\lDisplayRecs)*lDisplayRecs+1 ' Point to page boundary
viewSchedule.StartRecordNumber = lStartRec
End If
End Sub
'
' Load default values
'
Sub LoadDefaultValues()
End Sub
'
' Load row based on key values
'
Function LoadRow() As Boolean
Dim RsRow As OleDbDataReader
Dim sFilter As String = viewSchedule.KeyFilter
' Row Selecting event
viewSchedule.Row_Selecting(sFilter)
' Load SQL based on filter
viewSchedule.CurrentFilter = sFilter
Dim sSql As String = viewSchedule.SQL
' Write SQL for debug
If EW_DEBUG_ENABLED Then ew_Write(sSql)
Try
RsRow = Conn.GetTempDataReader(sSql)
If Not RsRow.Read() Then
Return False
Else
LoadRowValues(RsRow) ' Load row values
' Row Selected event
viewSchedule.Row_Selected(RsRow)
Return True
End If
Catch
If EW_DEBUG_ENABLED Then Throw
Return False
Finally
Conn.CloseTempDataReader()
End Try
End Function
'
' Load row values from recordset
'
Sub LoadRowValues(ByRef RsRow As OleDbDataReader)
viewSchedule.schSchID.DbValue = RsRow("schSchID")
viewSchedule.schDate.DbValue = RsRow("schDate")
viewSchedule.schEvtID.DbValue = RsRow("schEvtID")
viewSchedule.schPartsID.DbValue = RsRow("schPartsID")
viewSchedule.schCallTime.DbValue = RsRow("schCallTime")
viewSchedule.schStartTime.DbValue = RsRow("schStartTime")
viewSchedule.schEndTime.DbValue = RsRow("schEndTime")
viewSchedule.schOutTime.DbValue = RsRow("schOutTime")
viewSchedule.schLocID.DbValue = RsRow("schLocID")
viewSchedule.schEmpID.DbValue = RsRow("schEmpID")
viewSchedule.schPosID.DbValue = RsRow("schPosID")
viewSchedule.schTypID.DbValue = RsRow("schTypID")
viewSchedule.schNotes.DbValue = RsRow("schNotes")
viewSchedule.schActualStart.DbValue = RsRow("schActualStart")
viewSchedule.schActualEnd.DbValue = RsRow("schActualEnd")
viewSchedule.schDateCreated.DbValue = RsRow("schDateCreated")
viewSchedule.schStatus.DbValue = RsRow("schStatus")
End Sub
'
' Render row values based on field settings
'
Sub RenderRow()
' Row Rendering event
viewSchedule.Row_Rendering()
'
' Common render codes for all row types
'
' schDate
viewSchedule.schDate.CellCssStyle = ""
viewSchedule.schDate.CellCssClass = ""
' schEvtID
viewSchedule.schEvtID.CellCssStyle = ""
viewSchedule.schEvtID.CellCssClass = ""
' schPartsID
viewSchedule.schPartsID.CellCssStyle = ""
viewSchedule.schPartsID.CellCssClass = ""
' schCallTime
viewSchedule.schCallTime.CellCssStyle = ""
viewSchedule.schCallTime.CellCssClass = ""
' schStartTime
viewSchedule.schStartTime.CellCssStyle = ""
viewSchedule.schStartTime.CellCssClass = ""
' schEndTime
viewSchedule.schEndTime.CellCssStyle = ""
viewSchedule.schEndTime.CellCssClass = ""
' schOutTime
viewSchedule.schOutTime.CellCssStyle = ""
viewSchedule.schOutTime.CellCssClass = ""
' schLocID
viewSchedule.schLocID.CellCssStyle = ""
viewSchedule.schLocID.CellCssClass = ""
' schEmpID
viewSchedule.schEmpID.CellCssStyle = ""
viewSchedule.schEmpID.CellCssClass = ""
' schPosID
viewSchedule.schPosID.CellCssStyle = ""
viewSchedule.schPosID.CellCssClass = ""
' schTypID
viewSchedule.schTypID.CellCssStyle = ""
viewSchedule.schTypID.CellCssClass = ""
' schNotes
viewSchedule.schNotes.CellCssStyle = ""
viewSchedule.schNotes.CellCssClass = ""
' schActualStart
viewSchedule.schActualStart.CellCssStyle = ""
viewSchedule.schActualStart.CellCssClass = ""
' schActualEnd
viewSchedule.schActualEnd.CellCssStyle = ""
viewSchedule.schActualEnd.CellCssClass = ""
' schDateCreated
viewSchedule.schDateCreated.CellCssStyle = ""
viewSchedule.schDateCreated.CellCssClass = ""
' schStatus
viewSchedule.schStatus.CellCssStyle = ""
viewSchedule.schStatus.CellCssClass = ""
'
' View Row
'
If viewSchedule.RowType = EW_ROWTYPE_VIEW Then ' View row
' schDate
viewSchedule.schDate.ViewValue = viewSchedule.schDate.CurrentValue
viewSchedule.schDate.ViewValue = ew_FormatDateTime(viewSchedule.schDate.ViewValue, 6)
viewSchedule.schDate.CssStyle = ""
viewSchedule.schDate.CssClass = ""
viewSchedule.schDate.ViewCustomAttributes = ""
' schEvtID
If ew_NotEmpty(viewSchedule.schEvtID.CurrentValue) Then
sSqlWrk = "SELECT [evtDescription] FROM [tblEvents] WHERE [evtID] = " & ew_AdjustSql(viewSchedule.schEvtID.CurrentValue) & ""
sSqlWrk = sSqlWrk & " ORDER BY [evtDescription] "
RsWrk = Conn.GetTempDataReader(sSqlWrk)
If RsWrk.Read() Then
viewSchedule.schEvtID.ViewValue = RsWrk("evtDescription")
Else
viewSchedule.schEvtID.ViewValue = viewSchedule.schEvtID.CurrentValue
End If
Conn.CloseTempDataReader()
Else
viewSchedule.schEvtID.ViewValue = System.DBNull.Value
End If
viewSchedule.schEvtID.CssStyle = ""
viewSchedule.schEvtID.CssClass = ""
viewSchedule.schEvtID.ViewCustomAttributes = ""
' schPartsID
If ew_NotEmpty(viewSchedule.schPartsID.CurrentValue) Then
sSqlWrk = "SELECT [prtDescription] FROM [tblParts] WHERE [prtID] = " & ew_AdjustSql(viewSchedule.schPartsID.CurrentValue) & ""
sSqlWrk = sSqlWrk & " ORDER BY [prtDescription] "
RsWrk = Conn.GetTempDataReader(sSqlWrk)
If RsWrk.Read() Then
viewSchedule.schPartsID.ViewValue = RsWrk("prtDescription")
Else
viewSchedule.schPartsID.ViewValue = viewSchedule.schPartsID.CurrentValue
End If
Conn.CloseTempDataReader()
Else
viewSchedule.schPartsID.ViewValue = System.DBNull.Value
End If
viewSchedule.schPartsID.CssStyle = ""
viewSchedule.schPartsID.CssClass = ""
viewSchedule.schPartsID.ViewCustomAttributes = ""
' schCallTime
viewSchedule.schCallTime.ViewValue = viewSchedule.schCallTime.CurrentValue
viewSchedule.schCallTime.ViewValue = ew_FormatDateTime(viewSchedule.schCallTime.ViewValue, 14)
viewSchedule.schCallTime.CssStyle = ""
viewSchedule.schCallTime.CssClass = ""
viewSchedule.schCallTime.ViewCustomAttributes = ""
' schStartTime
viewSchedule.schStartTime.ViewValue = viewSchedule.schStartTime.CurrentValue
viewSchedule.schStartTime.ViewValue = ew_FormatDateTime(viewSchedule.schStartTime.ViewValue, 14)
viewSchedule.schStartTime.CssStyle = ""
viewSchedule.schStartTime.CssClass = ""
viewSchedule.schStartTime.ViewCustomAttributes = ""
' schEndTime
viewSchedule.schEndTime.ViewValue = viewSchedule.schEndTime.CurrentValue
viewSchedule.schEndTime.ViewValue = ew_FormatDateTime(viewSchedule.schEndTime.ViewValue, 14)
viewSchedule.schEndTime.CssStyle = ""
viewSchedule.schEndTime.CssClass = ""
viewSchedule.schEndTime.ViewCustomAttributes = ""
' schOutTime
viewSchedule.schOutTime.ViewValue = viewSchedule.schOutTime.CurrentValue
viewSchedule.schOutTime.ViewValue = ew_FormatDateTime(viewSchedule.schOutTime.ViewValue, 14)
viewSchedule.schOutTime.CssStyle = ""
viewSchedule.schOutTime.CssClass = ""
viewSchedule.schOutTime.ViewCustomAttributes = ""
' schLocID
If ew_NotEmpty(viewSchedule.schLocID.CurrentValue) Then
sSqlWrk = "SELECT [locDescription] FROM [tblLocations] WHERE [locID] = " & ew_AdjustSql(viewSchedule.schLocID.CurrentValue) & ""
sSqlWrk = sSqlWrk & " ORDER BY [locDescription] "
RsWrk = Conn.GetTempDataReader(sSqlWrk)
If RsWrk.Read() Then
viewSchedule.schLocID.ViewValue = RsWrk("locDescription")
Else
viewSchedule.schLocID.ViewValue = viewSchedule.schLocID.CurrentValue
End If
Conn.CloseTempDataReader()
Else
viewSchedule.schLocID.ViewValue = System.DBNull.Value
End If
viewSchedule.schLocID.CssStyle = ""
viewSchedule.schLocID.CssClass = ""
viewSchedule.schLocID.ViewCustomAttributes = ""
' schEmpID
If ew_NotEmpty(viewSchedule.schEmpID.CurrentValue) Then
sSqlWrk = "SELECT [empName] FROM [tblEmployees] WHERE [empID] = " & ew_AdjustSql(viewSchedule.schEmpID.CurrentValue) & ""
sSqlWrk = sSqlWrk & " ORDER BY [empFirstName] "
RsWrk = Conn.GetTempDataReader(sSqlWrk)
If RsWrk.Read() Then
viewSchedule.schEmpID.ViewValue = RsWrk("empName")
Else
viewSchedule.schEmpID.ViewValue = viewSchedule.schEmpID.CurrentValue
End If
Conn.CloseTempDataReader()
Else
viewSchedule.schEmpID.ViewValue = System.DBNull.Value
End If
viewSchedule.schEmpID.CssStyle = ""
viewSchedule.schEmpID.CssClass = ""
viewSchedule.schEmpID.ViewCustomAttributes = ""
' schPosID
If ew_NotEmpty(viewSchedule.schPosID.CurrentValue) Then
sSqlWrk = "SELECT [posDescription] FROM [tblPositions] WHERE [posID] = " & ew_AdjustSql(viewSchedule.schPosID.CurrentValue) & ""
sSqlWrk = sSqlWrk & " ORDER BY [posDescription] "
RsWrk = Conn.GetTempDataReader(sSqlWrk)
If RsWrk.Read() Then
viewSchedule.schPosID.ViewValue = RsWrk("posDescription")
Else
viewSchedule.schPosID.ViewValue = viewSchedule.schPosID.CurrentValue
End If
Conn.CloseTempDataReader()
Else
viewSchedule.schPosID.ViewValue = System.DBNull.Value
End If
viewSchedule.schPosID.CssStyle = ""
viewSchedule.schPosID.CssClass = ""
viewSchedule.schPosID.ViewCustomAttributes = ""
' schTypID
If ew_NotEmpty(viewSchedule.schTypID.CurrentValue) Then
sSqlWrk = "SELECT [typDescription] FROM [tblTypes] WHERE [typID] = " & ew_AdjustSql(viewSchedule.schTypID.CurrentValue) & ""
sSqlWrk = sSqlWrk & " ORDER BY [typDescription] "
RsWrk = Conn.GetTempDataReader(sSqlWrk)
If RsWrk.Read() Then
viewSchedule.schTypID.ViewValue = RsWrk("typDescription")
Else
viewSchedule.schTypID.ViewValue = viewSchedule.schTypID.CurrentValue
End If
Conn.CloseTempDataReader()
Else
viewSchedule.schTypID.ViewValue = System.DBNull.Value
End If
viewSchedule.schTypID.CssStyle = ""
viewSchedule.schTypID.CssClass = ""
viewSchedule.schTypID.ViewCustomAttributes = ""
' schNotes
viewSchedule.schNotes.ViewValue = viewSchedule.schNotes.CurrentValue
viewSchedule.schNotes.CssStyle = ""
viewSchedule.schNotes.CssClass = ""
viewSchedule.schNotes.ViewCustomAttributes = ""
' schActualStart
viewSchedule.schActualStart.ViewValue = viewSchedule.schActualStart.CurrentValue
viewSchedule.schActualStart.ViewValue = ew_FormatDateTime(viewSchedule.schActualStart.ViewValue, 14)
viewSchedule.schActualStart.CssStyle = ""
viewSchedule.schActualStart.CssClass = ""
viewSchedule.schActualStart.ViewCustomAttributes = ""
' schActualEnd
viewSchedule.schActualEnd.ViewValue = viewSchedule.schActualEnd.CurrentValue
viewSchedule.schActualEnd.ViewValue = ew_FormatDateTime(viewSchedule.schActualEnd.ViewValue, 14)
viewSchedule.schActualEnd.CssStyle = ""
viewSchedule.schActualEnd.CssClass = ""
viewSchedule.schActualEnd.ViewCustomAttributes = ""
' schDateCreated
viewSchedule.schDateCreated.ViewValue = viewSchedule.schDateCreated.CurrentValue
viewSchedule.schDateCreated.ViewValue = ew_FormatDateTime(viewSchedule.schDateCreated.ViewValue, 6)
viewSchedule.schDateCreated.CssStyle = ""
viewSchedule.schDateCreated.CssClass = ""
viewSchedule.schDateCreated.ViewCustomAttributes = ""
' schStatus
If ew_NotEmpty(viewSchedule.schStatus.CurrentValue) Then
sSqlWrk = "SELECT [stDescription] FROM [tblScheduleStatus] WHERE [stID] = " & ew_AdjustSql(viewSchedule.schStatus.CurrentValue) & ""
sSqlWrk = sSqlWrk & " ORDER BY [stDescription] "
RsWrk = Conn.GetTempDataReader(sSqlWrk)
If RsWrk.Read() Then
viewSchedule.schStatus.ViewValue = RsWrk("stDescription")
Else
viewSchedule.schStatus.ViewValue = viewSchedule.schStatus.CurrentValue
End If
Conn.CloseTempDataReader()
Else
viewSchedule.schStatus.ViewValue = System.DBNull.Value
End If
viewSchedule.schStatus.CssStyle = ""
viewSchedule.schStatus.CssClass = ""
viewSchedule.schStatus.ViewCustomAttributes = ""
' View refer script
' schDate
viewSchedule.schDate.HrefValue = ""
' schEvtID
viewSchedule.schEvtID.HrefValue = ""
' schPartsID
viewSchedule.schPartsID.HrefValue = ""
' schCallTime
viewSchedule.schCallTime.HrefValue = ""
' schStartTime
viewSchedule.schStartTime.HrefValue = ""
' schEndTime
viewSchedule.schEndTime.HrefValue = ""
' schOutTime
viewSchedule.schOutTime.HrefValue = ""
' schLocID
viewSchedule.schLocID.HrefValue = ""
' schEmpID
viewSchedule.schEmpID.HrefValue = ""
' schPosID
viewSchedule.schPosID.HrefValue = ""
' schTypID
viewSchedule.schTypID.HrefValue = ""
' schNotes
viewSchedule.schNotes.HrefValue = ""
' schActualStart
viewSchedule.schActualStart.HrefValue = ""
' schActualEnd
viewSchedule.schActualEnd.HrefValue = ""
' schDateCreated
viewSchedule.schDateCreated.HrefValue = ""
' schStatus
viewSchedule.schStatus.HrefValue = ""
End If
' Row Rendered event
viewSchedule.Row_Rendered()
End Sub
'
' Show link optionally based on user ID
'
Function ShowOptionLink() As Boolean
If Security.IsLoggedIn() AndAlso Not Security.IsAdmin() Then
Return Security.IsValidUserID(viewSchedule.schEmpID.CurrentValue)
End If
Return True
End Function
' Page Load event
Public Sub Page_Load()
'HttpContext.Current.Response.Write("Page Load")
End Sub
' Page Unload event
Public Sub Page_Unload()
'HttpContext.Current.Response.Write("Page Unload")
End Sub
End Class
'
' ASP.NET Page_Load event
'
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Response.Buffer = EW_RESPONSE_BUFFER
Response.Cache.SetCacheability(HttpCacheability.NoCache)
' Page init
viewSchedule_view = New cviewSchedule_view(Me)
viewSchedule_view.Page_Init()
' Page main processing
viewSchedule_view.Page_Main()
End Sub
'
' ASP.NET Page_Unload event
'
Protected Sub Page_Unload(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Unload
' Dispose page object
If viewSchedule_view IsNot Nothing Then viewSchedule_view.Dispose()
End Sub
End Class