Imports System.Data.SqlClient
Public Class userinfo
    Inherits System.Web.UI.Page

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

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

    End Sub
    Protected WithEvents spAuid As System.Web.UI.HtmlControls.HtmlGenericControl
    Protected WithEvents spAuname As System.Web.UI.HtmlControls.HtmlGenericControl
    Protected WithEvents spAuadr As System.Web.UI.HtmlControls.HtmlGenericControl
    Protected WithEvents spAusex As System.Web.UI.HtmlControls.HtmlGenericControl
    Protected WithEvents spAusort As System.Web.UI.HtmlControls.HtmlGenericControl
    Protected WithEvents spAuadddate As System.Web.UI.HtmlControls.HtmlGenericControl
    Protected WithEvents spAuemail As System.Web.UI.HtmlControls.HtmlGenericControl
    Protected WithEvents spAuremarks As System.Web.UI.HtmlControls.HtmlGenericControl
    Protected WithEvents spBorrowQinkuang As System.Web.UI.HtmlControls.HtmlGenericControl
    Protected WithEvents spTotalBorrowNo As System.Web.UI.HtmlControls.HtmlGenericControl
    Protected WithEvents spMaxBorrowDays As System.Web.UI.HtmlControls.HtmlGenericControl
    Protected WithEvents spBookcode As System.Web.UI.HtmlControls.HtmlGenericControl
    Protected WithEvents IMG1 As System.Web.UI.HtmlControls.HtmlImage

    '注意: 以下占位符聲明是 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("UID") Is Nothing Then
            Page.Response.Redirect("login.aspx")
        End If
        If Not IsPostBack Then
            If Not Session("UID") Is Nothing Then
                AuTextBind(Session("UID"))
                setBorrowState(Session("UID"))
            Else
                Page.Response.Redirect("login.aspx")
            End If

        End If
    End Sub
    '顯示某讀者基本情況
    Function AuTextBind(ByVal strAu_id As String)
        Dim cnlib2004 As SqlConnection
        Dim cmdAuBorrowList As SqlCommand
        Dim drAuBorrowList As SqlDataReader

        cnlib2004 = New SqlConnection(ConfigurationSettings.AppSettings("cncstr"))
        cmdAuBorrowList = New SqlCommand
        With cmdAuBorrowList
            .CommandType = CommandType.StoredProcedure
            .CommandText = "Select1Au"
            .Connection = cnlib2004
        End With
        Dim mAu_id As New SqlParameter("@Au_id", SqlDbType.NVarChar, 50) '1
        cmdAuBorrowList.Parameters.Add(mAu_id)
        mAu_id.Value = strAu_id
        Try
            cnlib2004.Open()
            drAuBorrowList = cmdAuBorrowList.ExecuteReader(CommandBehavior.SingleRow)
            With drAuBorrowList
                If .Read() Then
                    Me.spAuadddate.InnerHtml = CType(.Item("Au_adddate"), String)
                    Me.spAuadr.InnerHtml = .Item("Au_adr")
                    Me.spAuname.InnerHtml = .Item("Au_name")
                    Me.spAusex.InnerHtml = .Item("Au_sex")
                    Me.spAusort.InnerHtml = .Item("Au_sort")
                    Me.spAuid.InnerHtml = strAu_id
                    Me.spAuemail.InnerHtml = .Item("Au_email")
                    Me.spAuremarks.InnerHtml = .Item("Au_remarks")
                Else
                   
                End If
            End With

        Catch ex As Exception
            Response.Write(ex.Message)
        Finally
            cnlib2004.Close()
        End Try
    End Function

    '顯示讀者借書狀態 最大借書冊書,當前借書冊數 等
    Function setBorrowState(ByVal strAu_id As String)
        Dim cnlib2004 As SqlConnection
        Dim cmd As SqlCommand
        Dim dr As SqlDataReader
        Dim CurBorrowNo As Int16
        Dim AllborrowNo As Int16
        Dim BorrowDays As Int16
        Dim BorrowBooks As Int16
        cnlib2004 = New SqlConnection(ConfigurationSettings.AppSettings("cncstr"))
        cmd = New SqlCommand
        With cmd
            .CommandType = CommandType.StoredProcedure
            .CommandText = "SelectAuCurrentBorrowNo"
            .Connection = cnlib2004
        End With
        Dim mAu_id As New SqlParameter("@Au_id", SqlDbType.NVarChar, 50) '1
        cmd.Parameters.Add(mAu_id)
        mAu_id.Value = strAu_id

        Try
            cnlib2004.Open()
            CurBorrowNo = CType(cmd.ExecuteScalar, Int16)

            cmd.CommandText = "SelectAuAllBorrowNo"
            AllborrowNo = CType(cmd.ExecuteScalar, Int16)

            cmd.CommandText = "SelectAuSortInfo"
            dr = cmd.ExecuteReader(CommandBehavior.SingleRow)

            While dr.Read()
                BorrowDays = dr.Item("Au_borrowdays")
                BorrowBooks = dr.Item("Au_borrowbooks")
            End While

            Me.spTotalBorrowNo.InnerHtml = "共借書" + AllborrowNo.ToString + "冊"
            Me.spMaxBorrowDays.InnerHtml = BorrowDays.ToString + "天"

            Me.spBorrowQinkuang.InnerHtml = "[" + CurBorrowNo.ToString + "/"
            Me.spBorrowQinkuang.InnerHtml += BorrowBooks.ToString + "]"
        Catch ex As Exception
            Response.Redirect("error.aspx?errmsg=" + ex.Message)
        Finally
            cnlib2004.Close()
        End Try
    End Function

 
End Class