home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
66.142.0.142
/
66.142.0.142.tar
/
66.142.0.142
/
viewEmployeeslist.aspx.vb
< prev
next >
Wrap
Text File
|
2010-08-26
|
18KB
|
665 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 viewEmployeeslist
Inherits AspNetMaker7_tfpssnet
' Page object
Public viewEmployees_list As cviewEmployees_list
'
' Page Class
'
Class cviewEmployees_list
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 viewEmployees.UseTokenInUrl Then Url = Url & "t=" & viewEmployees.TableVar & "&" ' Add page token
Return Url
End Get
End Property
' Validate page request
Public Function IsPageRequest() As Boolean
Dim Result As Boolean
If viewEmployees.UseTokenInUrl Then
Result = False
If ObjForm IsNot Nothing Then
Result = (viewEmployees.TableVar = ObjForm.GetValue("t"))
End If
If ew_Get("t") <> "" Then
Result = (viewEmployees.TableVar = ew_Get("t"))
End If
Return Result
End If
Return True
End Function
' viewEmployees
Public Property viewEmployees() As cviewEmployees
Get
Return ParentPage.viewEmployees
End Get
Set(ByVal v As cviewEmployees)
ParentPage.viewEmployees = v
End Set
End Property
' viewEmployees
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 = "list"
m_PageObjName = "viewEmployees_list"
m_PageObjTypeName = "cviewEmployees_list"
' Table Name
m_TableName = "viewEmployees"
' Initialize table object
viewEmployees = New cviewEmployees(Me)
tblEmployees = New ctblEmployees(Me)
' Connect to database
Conn = New cConnection()
' Initialize list options
ListOptions = New cListOptions
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.CanList Then
Security.SaveLastUrl()
Page_Terminate("login.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("")
End If
viewEmployees.Export = ew_Get("export") ' Get export parameter
ParentPage.gsExport = viewEmployees.Export ' Get export parameter, used in header
ParentPage.gsExportFile = viewEmployees.TableVar ' Get export file, used in header
' 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
viewEmployees.Dispose()
tblEmployees.Dispose()
ListOptions = Nothing
' 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 sSrchWhere As String
Public lRecCnt As Integer
Public lEditRowCnt As Integer
Public lRowCnt As Integer, lRowIndex As Integer
Public lOptionCnt As Integer
Public lRecPerRow As Integer, lColCnt As Integer
Public sDeleteConfirmMsg As String ' Delete confirm message
Public sDbMasterFilter As String, sDbDetailFilter As String
Public bMasterRecordExists As Boolean
Public ListOptions As Object
Public sMultiSelectKey As String
Public x_ewPriv As Integer
'
' Page main processing
'
Public Sub Page_Main()
lDisplayRecs = 20
lRecRange = EW_PAGER_RANGE
lRecCnt = 0 ' Record count
' Search filters
Dim sSrchAdvanced As String = "" ' Advanced search filter
Dim sSrchBasic As String = "" ' Basic search filter
Dim sFilter As String = ""
sSrchWhere = "" ' Search WHERE clause
' Master/Detail
sDbMasterFilter = "" ' Master filter
sDbDetailFilter = "" ' Detail filter
If IsPageRequest Then ' Validate request
' Set up records per page dynamically
SetUpDisplayRecs()
' Handle reset command
ResetCmd()
' Set Up Sorting Order
SetUpSortOrder()
End If
' Restore display records
If (viewEmployees.RecordsPerPage = -1 OrElse viewEmployees.RecordsPerPage > 0) Then
lDisplayRecs = viewEmployees.RecordsPerPage ' Restore from Session
Else
lDisplayRecs = 20 ' Load default
End If
' Load Sorting Order
LoadSortOrder()
' Build filter
sFilter = ""
If Not Security.CanList Then
sFilter = "(0=1)" ' Filter all records
End If
If sDbDetailFilter <> "" Then
If sFilter <> "" Then
sFilter = "(" & sFilter & ") AND (" & sDbDetailFilter & ")"
Else
sFilter = sDbDetailFilter
End If
End If
If sSrchWhere <> "" Then
If sFilter <> "" Then
sFilter = "(" & sFilter & ") AND (" & sSrchWhere & ")"
Else
sFilter = sSrchWhere
End If
End If
' Set up filter in Session
viewEmployees.SessionWhere = sFilter
viewEmployees.CurrentFilter = ""
End Sub
'
' Set up number of records displayed per page
'
Sub SetUpDisplayRecs()
Dim sWrk As String
sWrk = ew_Get(EW_TABLE_REC_PER_PAGE)
If sWrk <> "" Then
If IsNumeric(sWrk) Then
lDisplayRecs = ew_ConvertToInt(sWrk)
Else
If ew_SameText(sWrk, "all") Then ' Display all records
lDisplayRecs = -1
Else
lDisplayRecs = 20 ' Non-numeric, load default
End If
End If
viewEmployees.RecordsPerPage = lDisplayRecs ' Save to Session
' Reset start position
lStartRec = 1
viewEmployees.StartRecordNumber = lStartRec
End If
End Sub
'
' Set up Sort parameters based on Sort Links clicked
'
Sub SetUpSortOrder()
Dim sOrderBy As String
Dim sSortField As String, sLastSort As String, sThisSort As String
Dim bCtrl As Boolean
' Check for Ctrl pressed
bCtrl = (ew_Get("ctrl") <> "")
' Check for an Order parameter
If ew_Get("order") <> "" Then
viewEmployees.CurrentOrder = ew_Get("order")
viewEmployees.CurrentOrderType = ew_Get("ordertype")
viewEmployees.UpdateSort(viewEmployees.empID, bCtrl) ' empID
viewEmployees.UpdateSort(viewEmployees.empPayrollNumber, bCtrl) ' empPayrollNumber
viewEmployees.UpdateSort(viewEmployees.empUsername, bCtrl) ' empUsername
viewEmployees.UpdateSort(viewEmployees.empName, bCtrl) ' empName
viewEmployees.UpdateSort(viewEmployees.empPhone, bCtrl) ' empPhone
viewEmployees.UpdateSort(viewEmployees.empEmail, bCtrl) ' empEmail
viewEmployees.StartRecordNumber = 1 ' Reset start position
End If
End Sub
'
' Load Sort Order parameters
'
Sub LoadSortOrder()
Dim sOrderBy As String
sOrderBy = viewEmployees.SessionOrderBy ' Get order by from Session
If sOrderBy = "" Then
If viewEmployees.SqlOrderBy <> "" Then
sOrderBy = viewEmployees.SqlOrderBy
viewEmployees.SessionOrderBy = sOrderBy
End If
End If
End Sub
'
' Reset command based on querystring parameter "cmd"
' - reset: reset search parameters
' - resetall: reset search and master/detail parameters
' - resetsort: reset sort parameters
'
Sub ResetCmd()
Dim sCmd As String
' Get reset cmd
If ew_Get("cmd") <> "" Then
sCmd = ew_Get("cmd")
' Reset sort criteria
If ew_SameText(sCmd, "resetsort") Then
Dim sOrderBy As String = ""
viewEmployees.SessionOrderBy = sOrderBy
viewEmployees.empID.Sort = ""
viewEmployees.empPayrollNumber.Sort = ""
viewEmployees.empUsername.Sort = ""
viewEmployees.empName.Sort = ""
viewEmployees.empPhone.Sort = ""
viewEmployees.empEmail.Sort = ""
End If
' Reset start position
lStartRec = 1
viewEmployees.StartRecordNumber = lStartRec
End If
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))
viewEmployees.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
viewEmployees.StartRecordNumber = lStartRec
End If
End If
lStartRec = viewEmployees.StartRecordNumber
' Check if correct start record counter
If lStartRec <= 0 Then ' Avoid invalid start record counter
lStartRec = 1 ' Reset start record counter
viewEmployees.StartRecordNumber = lStartRec
ElseIf lStartRec > lTotalRecs Then ' Avoid starting record > total records
lStartRec = ((lTotalRecs-1)\lDisplayRecs)*lDisplayRecs+1 ' Point to last page first record
viewEmployees.StartRecordNumber = lStartRec
ElseIf (lStartRec-1) Mod lDisplayRecs <> 0 Then
lStartRec = ((lStartRec-1)\lDisplayRecs)*lDisplayRecs+1 ' Point to page boundary
viewEmployees.StartRecordNumber = lStartRec
End If
End Sub
'
' Load default values
'
Sub LoadDefaultValues()
End Sub
'
' Load recordset
'
Function LoadRecordset() As OleDbDataReader
' Recordset Selecting event
viewEmployees.Recordset_Selecting(viewEmployees.CurrentFilter)
' Load list page SQL
Dim sSql As String = viewEmployees.ListSQL
' Write SQL for debug
If EW_DEBUG_ENABLED Then ew_Write(sSql)
' Count
lTotalRecs = -1
' Load recordset
Dim Rs As OleDbDataReader = Conn.GetDataReader(sSql)
If lTotalRecs < 0 AndAlso Rs.HasRows Then
lTotalRecs = 0
While Rs.Read()
lTotalRecs = lTotalRecs + 1
End While
Rs.Close()
Rs = Conn.GetDataReader(sSql)
End If
' Recordset Selected event
viewEmployees.Recordset_Selected(Rs)
Return Rs
End Function
'
' Load row based on key values
'
Function LoadRow() As Boolean
Dim RsRow As OleDbDataReader
Dim sFilter As String = viewEmployees.KeyFilter
' Row Selecting event
viewEmployees.Row_Selecting(sFilter)
' Load SQL based on filter
viewEmployees.CurrentFilter = sFilter
Dim sSql As String = viewEmployees.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
viewEmployees.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)
viewEmployees.empID.DbValue = RsRow("empID")
viewEmployees.empPayrollNumber.DbValue = RsRow("empPayrollNumber")
viewEmployees.empUsername.DbValue = RsRow("empUsername")
viewEmployees.empName.DbValue = RsRow("empName")
viewEmployees.empFirstName.DbValue = RsRow("empFirstName")
viewEmployees.empLastName.DbValue = RsRow("empLastName")
viewEmployees.empAddress.DbValue = RsRow("empAddress")
viewEmployees.empCity.DbValue = RsRow("empCity")
viewEmployees.empState.DbValue = RsRow("empState")
viewEmployees.empZIP.DbValue = RsRow("empZIP")
viewEmployees.empPhone.DbValue = RsRow("empPhone")
viewEmployees.empEmail.DbValue = RsRow("empEmail")
viewEmployees.empUserPass.DbValue = RsRow("empUserPass")
End Sub
'
' Render row values based on field settings
'
Sub RenderRow()
' Row Rendering event
viewEmployees.Row_Rendering()
'
' Common render codes for all row types
'
' empID
viewEmployees.empID.CellCssStyle = ""
viewEmployees.empID.CellCssClass = ""
' empPayrollNumber
viewEmployees.empPayrollNumber.CellCssStyle = ""
viewEmployees.empPayrollNumber.CellCssClass = ""
' empUsername
viewEmployees.empUsername.CellCssStyle = ""
viewEmployees.empUsername.CellCssClass = ""
' empName
viewEmployees.empName.CellCssStyle = ""
viewEmployees.empName.CellCssClass = ""
' empPhone
viewEmployees.empPhone.CellCssStyle = ""
viewEmployees.empPhone.CellCssClass = ""
' empEmail
viewEmployees.empEmail.CellCssStyle = ""
viewEmployees.empEmail.CellCssClass = ""
'
' View Row
'
If viewEmployees.RowType = EW_ROWTYPE_VIEW Then ' View row
' empID
viewEmployees.empID.ViewValue = viewEmployees.empID.CurrentValue
viewEmployees.empID.CssStyle = ""
viewEmployees.empID.CssClass = ""
viewEmployees.empID.ViewCustomAttributes = ""
' empPayrollNujber
viewEmployees.empPayrollNumber.ViewValue = viewEmployees.empPayrollNumber.CurrentValue
viewEmployees.empPayrollNumber.CssStyle = ""
viewEmployees.empPayrollNumber.CssClass = ""
viewEmployees.empPayrollNumber.ViewCustomAttributes = ""
' empUsername
viewEmployees.empUsername.ViewValue = viewEmployees.empUsername.CurrentValue
viewEmployees.empUsername.CssStyle = ""
viewEmployees.empUsername.CssClass = ""
viewEmployees.empUsername.ViewCustomAttributes = ""
' empName
viewEmployees.empName.ViewValue = viewEmployees.empName.CurrentValue
viewEmployees.empName.CssStyle = ""
viewEmployees.empName.CssClass = ""
viewEmployees.empName.ViewCustomAttributes = ""
' empPhone
viewEmployees.empPhone.ViewValue = viewEmployees.empPhone.CurrentValue
viewEmployees.empPhone.CssStyle = ""
viewEmployees.empPhone.CssClass = ""
viewEmployees.empPhone.ViewCustomAttributes = ""
' empEmail
viewEmployees.empEmail.ViewValue = viewEmployees.empEmail.CurrentValue
viewEmployees.empEmail.CssStyle = ""
viewEmployees.empEmail.CssClass = ""
viewEmployees.empEmail.ViewCustomAttributes = ""
' View refer script
' empID
viewEmployees.empID.HrefValue = ""
' empPayrollNumber
viewEmployees.empPayrollNumber.HrefValue = ""
' empUsername
viewEmployees.empUsername.HrefValue = ""
' empName
viewEmployees.empName.HrefValue = ""
' empPhone
viewEmployees.empPhone.HrefValue = ""
' empEmail
viewEmployees.empEmail.HrefValue = ""
End If
' Row Rendered event
viewEmployees.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(viewEmployees.empID.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
' Form Custom Validate event
Public Function Form_CustomValidate(ByRef CustomError As String) As Boolean
'Return error message in CustomError
Return True
End Function
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
viewEmployees_list = New cviewEmployees_list(Me)
viewEmployees_list.Page_Init()
' Page main processing
viewEmployees_list.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 viewEmployees_list IsNot Nothing Then viewEmployees_list.Dispose()
End Sub
End Class