全部代码.txt

The Management Information System of Library using .NET

        End If

        mBook_author.Value = Me.txtBook_author.Text.Trim   '6    
        If Me.cboBook_sort.SelectedIndex <> Me.cboBook_sort.Items.Count - 1 Then
            mBook_sort.Value = Me.cboBook_sort.SelectedValue    '11
        Else
            mBook_sort.Value = ""
        End If
        'Response.Write(mBook_sort.Value)


        Try
            cn.Open()
            dr = cmd.ExecuteReader
            Me.dbg.DataSource = dr
            Me.dbg.DataBind()
            Me.LabelInfo.Text = "共检索到" + Me.dbg.Items.Count.ToString + "条记录"
            ' Me.Label8.Text = "共检索到" + ds.Tables(0).Rows.Count.ToString + "条记录"
        Catch ex As Exception
            Response.Redirect("error.aspx?errmsg=" + ex.Message.Replace(Chr(13), "<BR>"))
        Finally
            cn.Close()
            If Not cn Is Nothing Then
                cn.Dispose()
            End If
        End Try
    End Function

    Private Sub btnQuery_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnQuery.Click
        Me.search()
    End Sub

 
End Class
Public Class sessionf
    Inherits System.Web.UI.Page

#Region " Web 窗体设计器生成的代码 "

    '该调用是 Web 窗体设计器所必需的。
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()

    End Sub

    '注意: 以下占位符声明是 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
        '在此处放置初始化页的用户代码
        Session.Abandon()
        Page.Response.Redirect("login.aspx")
    End Sub

End Class
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
Imports System.Data.SqlClient
Public Class Form1
    Inherits System.Windows.Forms.Form

#Region " Windows 窗体设计器生成的代码 "

    Public Sub New()
        MyBase.New()

        '该调用是 Windows 窗体设计器所必需的。
        InitializeComponent()

        '在 InitializeComponent() 调用之后添加任何初始化

    End Sub

    '窗体重写 dispose 以清理组件列表。
    Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
        If disposing Then
            If Not (components Is Nothing) Then
                components.Dispose()
            End If
        End If
        MyBase.Dispose(disposing)
    End Sub

    'Windows 窗体设计器所必需的
    Private components As System.ComponentModel.IContainer

    '注意: 以下过程是 Windows 窗体设计器所必需的
    '可以使用 Windows 窗体设计器修改此过程。
    '不要使用代码编辑器修改它。
    Friend WithEvents DataGrid1 As System.Windows.Forms.DataGrid
    Friend WithEvents btnSave As System.Windows.Forms.Button
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
        Me.DataGrid1 = New System.Windows.Forms.DataGrid
        Me.btnSave = New System.Windows.Forms.Button
        CType(Me.DataGrid1, System.ComponentModel.ISupportInitialize).BeginInit()
        Me.SuspendLayout()
        '
        'DataGrid1
        '
        Me.DataGrid1.DataMember = ""
        Me.DataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText
        Me.DataGrid1.Location = New System.Drawing.Point(40, 24)
        Me.DataGrid1.Name = "DataGrid1"
        Me.DataGrid1.Size = New System.Drawing.Size(224, 112)
        Me.DataGrid1.TabIndex = 0
        '
        'btnSave
        '
        Me.btnSave.Location = New System.Drawing.Point(120, 144)
        Me.btnSave.Name = "btnSave"
        Me.btnSave.Size = New System.Drawing.Size(64, 24)
        Me.btnSave.TabIndex = 1
        Me.btnSave.Text = "&Save"
        '
        'Form1
        '
        Me.AutoScaleBaseSize = New System.Drawing.Size(6, 14)
        Me.ClientSize = New System.Drawing.Size(320, 181)
        Me.Controls.Add(Me.btnSave)
        Me.Controls.Add(Me.DataGrid1)
        Me.Name = "Form1"
        Me.Text = "Form1"
        CType(Me.DataGrid1, System.ComponentModel.ISupportInitialize).EndInit()
        Me.ResumeLayout(False)

    End Sub

#End Region
    Dim cnLIB2004 As SqlConnection
    Dim daBooksort As SqlDataAdapter
    Dim dsbooksort As DataSet
    Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load
       
        cnLIB2004 = New SqlConnection("server=(local);database=lib2004;uid=sa;pwd=3893300")
        daBooksort = New SqlDataAdapter("select * from booksort", cnLIB2004)
        dsbooksort = New DataSet

        daBooksort.Fill(dsbooksort, "booksort")
        Me.DataGrid1.DataSource = dsbooksort.Tables(0)
        cnLIB2004.Dispose()
        daBooksort.Dispose()

    End Sub

   
    Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
        dsbooksort.AcceptChanges()
        daBooksort.Update(dsbooksort.Tables(0))
    End Sub
End Class
Imports System.Data
Imports System.Data.SqlClient
Public Class CdataService
    Protected Connection As SqlConnection
    Private m_DSN As String
    '构建一个带有参数的sqlcommand
    Private Overloads Function CreateCommand(ByVal sprocName As String, ByVal parameters() As IDataParameter) As SqlCommand
        Dim command As SqlCommand = New SqlCommand(sprocName, Connection)
        command.CommandType = CommandType.StoredProcedure
        Dim para As SqlParameter
        For Each para In parameters
            command.Parameters.Add(para)
        Next
        command.Parameters.Add(New SqlParameter("Return Value", _
        SqlDbType.Int, _
        4, _
        System.Data.ParameterDirection.ReturnValue, _
         False, _
          0, _
          0, _
          String.Empty, _
          DataRowVersion.Default, _
          Nothing))
        Return command
    End Function
    '构建一个没有参数的sqlcommand
    Private Overloads Function CreateCommand(ByVal sprocName As String) As SqlCommand
        Dim command As SqlCommand = New SqlCommand(sprocName, Connection)
        command.CommandType = CommandType.StoredProcedure

        command.Parameters.Add(New SqlParameter("Return Value", _
        SqlDbType.Int, _
        4, _