Imports System.Data.SqlClient
'borrec.aspx.vb
'本代碼室borrec.aspx
'本窗體用來顯示當(dāng)前登陸讀者的所有借書記錄,包括還過的書和沒有還過的書
'數(shù)學(xué)00-2班 翟靖軒 編寫
'2004-5-20
Public Class borrec
    Inherits System.Web.UI.Page
    Dim CnNO As Int32

#Region " Web 窗體設(shè)計器生成的代碼 "

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

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

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

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

#End Region
    Property countNo() As Int32
        Set(ByVal value As Int32)
            CnNO = value
        End Set
        Get
            Return CnNO
        End Get
    End Property
    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")
        Else
            If Not IsPostBack Then
                mydatabind(Session("UID"))
            End If

        End If
    End Sub


    Function mydatabind(ByVal strAu_id As String)
        Dim cnlib2004 As SqlConnection
        Dim cmdAuBorrowList As SqlCommand
        Dim dr As SqlDataReader

        cnlib2004 = New SqlConnection(ConfigurationSettings.AppSettings("cncstr"))
        cmdAuBorrowList = New SqlCommand

        With cmdAuBorrowList
            .CommandType = CommandType.StoredProcedure
            .CommandText = "SelectAuAllBorrowList"
            .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()
            dr = cmdAuBorrowList.ExecuteReader

            Me.dbgborrowlist.DataSource = dr
            'Me.dbgborrowlist.DataBind()
            ' Me.countNo = Me.dbgborrowlist.Items.Count
            Me.DataBind()
        Catch ex As Exception
            Response.Redirect("error.aspx?errmsg=" + ex.Message)
        Finally
            cnlib2004.Close()
        End Try
    End Function
End Class