Imports System
Imports System.Data
Imports System.Data.SqlClient

Public Class mail
    Inherits System.Web.UI.Page
    Dim myDataView As DataView
    Dim SQLstr As String

#Region " Web 窗體設計器生成的代碼 "

    '該調用是 Web 窗體設計器所必需的。
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()

    End Sub
    Protected WithEvents mydatagrid As System.Web.UI.WebControls.DataGrid

    '注意: 以下占位符聲明是 Web 窗體設計器所必需的。
    '不要刪除或移動它。
    Private designerPlaceholderDeclaration As System.Object

    Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
        'CODEGEN: 此方法調用是 Web 窗體設計器所必需的
        '不要使用代碼編輯器修改它。
        InitializeComponent()
    End Sub

#End Region

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        '在此處放置初始化頁的用戶代碼
        '<---------------------------判斷是否是正常登陸用戶-------------------------------------->
        If Session("login_name") = "" Then
            Response.Redirect("login.aspx")
        End If
        '<------------------------------按用戶單位顯示數據表------------------------------>
        If Global.ReturnSingleInfo("SELECT 權限 FROM person WHERE 登陸名='" & Session("login_name") & "'") = "00" Then '如果是超級用戶就可以查看所有的庫
            SQLstr = "Select * From card "
            myDataView = Global.CreateDataView(SQLstr)
            mydatagrid.DataSource = myDataView
            mydatagrid.DataBind()
        Else  '不是超級用戶就按單位情況查詢
            SQLstr = "Select * From card where 使用單位='" & Global.ReturnSingleInfo("SELECT 單位 FROM person WHERE 登陸名='" & Session("login_name") & "'") & "' "
            myDataView = Global.CreateDataView(SQLstr)
            mydatagrid.DataSource = myDataView
            mydatagrid.DataBind()
        End If
    End Sub

    '<-------------當用戶翻頁時處理------------------->
    Sub ChangePage(ByVal Sender As Object, ByVal e As DataGridPageChangedEventArgs) Handles mydatagrid.PageIndexChanged
        mydatagrid.CurrentPageIndex = e.NewPageIndex
        '<------------在對當前頁在進行一次查詢然后再次與DataView控件綁定------------------->
        SQLstr = "Select * From card "
        myDataView = Global.CreateDataView(SQLstr)
        mydatagrid.DataSource = myDataView
        mydatagrid.DataBind()
    End Sub

End Class