webfrmstudent.aspx.vb

网络版教务管理系统.rar

Public Class WebfrmStudent
    Inherits System.Web.UI.Page


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

    Protected WithEvents Image2 As System.Web.UI.WebControls.Image
    Protected WithEvents Label1 As System.Web.UI.WebControls.Label
    Protected WithEvents Image1 As System.Web.UI.WebControls.Image
    Protected WithEvents Button4 As System.Web.UI.WebControls.Button
    Protected WithEvents Button1 As System.Web.UI.WebControls.Button
    Protected WithEvents TextBox5 As System.Web.UI.WebControls.TextBox
    Protected WithEvents TextBox2 As System.Web.UI.WebControls.TextBox
    Protected WithEvents TextBox1 As System.Web.UI.WebControls.TextBox
    Protected WithEvents Label3 As System.Web.UI.WebControls.Label
    Protected WithEvents TextBox3 As System.Web.UI.WebControls.TextBox
    Protected WithEvents TextBox4 As System.Web.UI.WebControls.TextBox
    Protected WithEvents Label4 As System.Web.UI.WebControls.Label
    Protected WithEvents Label6 As System.Web.UI.WebControls.Label
    Protected WithEvents Label7 As System.Web.UI.WebControls.Label
    Protected WithEvents Label8 As System.Web.UI.WebControls.Label
    Protected WithEvents Label9 As System.Web.UI.WebControls.Label
    Protected WithEvents Label10 As System.Web.UI.WebControls.Label
    Protected WithEvents TextBox6 As System.Web.UI.WebControls.TextBox
    Protected WithEvents TextBox7 As System.Web.UI.WebControls.TextBox
    Protected WithEvents Button2 As System.Web.UI.WebControls.Button
    Protected WithEvents Button3 As System.Web.UI.WebControls.Button
    Protected WithEvents Button5 As System.Web.UI.WebControls.Button
    Protected WithEvents Select1 As System.Web.UI.HtmlControls.HtmlSelect
    Protected WithEvents Label2 As System.Web.UI.WebControls.Label
    Protected WithEvents Label5 As System.Web.UI.WebControls.Label
    Protected WithEvents Label11 As System.Web.UI.WebControls.Label
    Protected WithEvents TEXTAREA1 As System.Web.UI.HtmlControls.HtmlTextArea
    '该调用是 Web 窗体设计器所必需的。
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()

    End Sub

    Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
        'CODEGEN: 此方法调用是 Web 窗体设计器所必需的
        '不要使用代码编辑器修改它。
        InitializeComponent()
    End Sub


#End Region

    Public sqlstr As String
    Public DS As DataSet
    Public Count As Integer

    Private Sub Page_Load(ByVal sender As System.Object, _
    ByVal e As System.EventArgs) Handles MyBase.Load
        '在此处放置初始化页的用户代码
        If IsPostBack = False Then
            Me.Select1.Items.Clear()
            Me.Select1.Items.Add("男")
            Me.Select1.Items.Add("女")
            Me.Select1.SelectedIndex = 0
            LoadData()
            Indexs = 0
            ShowData(ShowData(Indexs))
        End If
    End Sub

    Public ReadOnly Property StudentInfo() As Student
        Get
            Dim std As New Student()
            std.Number = Trim(Me.TextBox1.Text)
            std.Name = Trim(Me.TextBox2.Text)
            std.Sex = Trim(Me.Select1.Value)
            std.InClass = Trim(Me.TextBox3.Text)
            std.Telphone = Trim(Me.TextBox4.Text)
            std.Address = Trim(Me.TextBox5.Text)
            std.EnterDay = Trim(Me.TextBox6.Text)
            std.Birthday = CDate(Me.TextBox7.Text)
            std.Other = Trim(Me.TEXTAREA1.Value)
            Return std
        End Get
    End Property

    Private Sub Button1_Click(ByVal sender As System.Object, _
    ByVal e As System.EventArgs) Handles Button1.Click
        Dim std As New Student()
        std = StudentInfo
        sqlstr = "INSERT INTO  studentInfo " _
       & "(学号,姓名,性别,班号,联系电话,家庭住址,入校日期,出生日期,备注) " & _
       "VALUES ( '" & std.Number & "','" & std.Name & "','" & std.Sex & "'," & _
       "'" & std.InClass & "','" & std.Telphone & "','" & std.Address & "'," & _
       "'" & std.EnterDay & "','" & std.Birthday & "','" & std.Other & "' )"
        If UpdateDataBase(sqlstr) = True Then
            LoadData()
            Indexs = 0
            ShowData(ShowData(Indexs))
        End If
    End Sub

    Public Sub ShowData(ByVal std As Student)
        Me.TextBox1.Text = std.Number
        Me.TextBox2.Text = std.Name
        Me.TextBox3.Text = std.InClass
        Me.TextBox4.Text = std.Telphone
        Me.TextBox5.Text = std.Address
        Me.TextBox6.Text = std.EnterDay
        Me.TextBox7.Text = std.Birthday
        Me.Select1.Value = std.Sex
        Me.TEXTAREA1.Value = std.Other
    End Sub

    Public Function LoadData() As DataSet
        sqlstr = "SELECT * FROM studentInfo"
        DS = New DataSet()
        DS.Clear()
        DS = GetDataFromDB(sqlstr)
        Count = DS.Tables(0).Rows.Count
        Return DS
    End Function

    Public Function ShowData(ByVal index) As Student
        Dim stdInfo As New Student()
        DS = LoadData()
        If index >= DS.Tables(0).Rows.Count Then
            index = 0
        End If
        If index < 0 Then
            index = DS.Tables(0).Rows.Count - 1
        End If
        stdInfo.Number = DS.Tables(0).Rows(index)("学号")
        stdInfo.Name = DS.Tables(0).Rows(index)("姓名")
        stdInfo.Sex = DS.Tables(0).Rows(index)("性别")
        stdInfo.InClass = DS.Tables(0).Rows(index)("班号")
        stdInfo.Telphone = DS.Tables(0).Rows(index)("联系电话")
        stdInfo.Address = DS.Tables(0).Rows(index)("家庭住址")
        stdInfo.EnterDay = DS.Tables(0).Rows(index)("入校日期")
        stdInfo.Birthday = DS.Tables(0).Rows(index)("出生日期")
        stdInfo.Other = DS.Tables(0).Rows(index)("备注")
        Count = DS.Tables(0).Rows.Count
        Me.Label11.Text = index + 1 & "  OF  " & Count
        Return stdInfo
    End Function

    Private Sub Button4_Click(ByVal sender As System.Object, _
    ByVal e As System.EventArgs) Handles Button4.Click
        Indexs = Indexs + 1
        ShowData(ShowData(Indexs))
    End Sub

    Private Sub Button5_Click(ByVal sender As System.Object, _
    ByVal e As System.EventArgs) Handles Button5.Click
        Indexs = Indexs - 1
        ShowData(ShowData(Indexs))
    End Sub

    Private Sub Button3_Click(ByVal sender As System.Object, _
    ByVal e As System.EventArgs) Handles Button3.Click
        sqlstr = "DELETE FROM studentInfo WHERE (学号=" & _
        "'" & Trim(Me.TextBox1.Text) & "') "
        If UpdateDataBase(sqlstr) = True Then
            LoadData()
            Indexs = 0
            ShowData(ShowData(Indexs))
        End If
    End Sub

    Private Sub Button2_Click(ByVal sender As System.Object, _
    ByVal e As System.EventArgs) Handles Button2.Click
        Dim std As New Student()
        std = StudentInfo
        sqlstr = "UPDATE  studentInfo SET 班号='" & std.InClass & "'," & _
        "联系电话='" & std.Telphone & "',家庭住址='" & std.Address & "'," & _
        "备注='" & std.Other & "'  WHERE 学号='" & std.Number & "' "
        If UpdateDataBase(sqlstr) = True Then
            LoadData()
            Indexs = 0
            ShowData(ShowData(Indexs))
        End If
    End Sub

End Class