xgmm.aspx.vb

VB.NET和SQLSERver2000编写在线考试系统

Public Class xgmm
    Inherits System.Web.UI.Page

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

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

    End Sub
    Protected WithEvents ImageButton1 As System.Web.UI.WebControls.ImageButton
    Protected WithEvents Label2 As System.Web.UI.WebControls.Label
    Protected WithEvents TextBox1 As System.Web.UI.WebControls.TextBox
    Protected WithEvents Label1 As System.Web.UI.WebControls.Label
    Protected WithEvents TextBox2 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 Label4 As System.Web.UI.WebControls.Label
    Protected WithEvents Textbox4 As System.Web.UI.WebControls.TextBox
    Protected WithEvents Label5 As System.Web.UI.WebControls.Label
    Protected WithEvents DropDownList1 As System.Web.UI.WebControls.DropDownList
    Protected WithEvents Image10 As System.Web.UI.WebControls.Image
    Protected WithEvents Image9 As System.Web.UI.WebControls.Image
    Protected WithEvents Image7 As System.Web.UI.WebControls.Image
    Protected WithEvents Image6 As System.Web.UI.WebControls.Image
    Protected WithEvents Image5 As System.Web.UI.WebControls.Image
    Protected WithEvents Image4 As System.Web.UI.WebControls.Image
    Protected WithEvents Image3 As System.Web.UI.WebControls.Image
    Protected WithEvents Image8 As System.Web.UI.WebControls.Image
    Protected WithEvents Imagebutton2 As System.Web.UI.WebControls.ImageButton

    '注意: 以下占位符声明是 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
    Public Sub message(ByVal str As String)
        Dim strscript As String = "<script language=javascript>alert('" & str & "')</script>"
        RegisterClientScriptBlock("系统消息", strscript)
    End Sub
    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        '在此处放置初始化页的用户代码
        If Not IsPostBack Then
            Try
                If (Session("userpower") <> 3) Then
                    Response.End()
                End If
            Catch ex As Exception
                Response.Write("您还登录,请您先登录<a href='SuperLogin.aspx'>首页</a>")
                Response.End()
            End Try
        End If
    End Sub

    Private Sub ImageButton1_Click(ByVal sender As System.Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles ImageButton1.Click
        Dim name As String = Trim(TextBox1.Text)
        Dim psd As String = Trim(TextBox2.Text)
        Dim pass1 As String = Trim(Textbox3.Text)
        Dim pass2 As String = Trim(Textbox4.Text)
        If name = "" Or psd = "" Or pass1 = "" Or pass2 = "" Then
            message("输入不能为空")
        Else
            If (pass1 <> pass2) Then
                message("两次密码不一致")
            Else
                Dim q As SqlClass = New SqlClass
                q.Open()
                Dim str As String
                    Select Case DropDownList1.SelectedIndex
                    Case 0
                        str = "select 用户名 from 用户记录表 where 用户名='" & name & "' and  密码='" & psd & "'"
                    Case 1
                        str = "select 用户名 from 单位记录表 where 用户名='" & name & "' and  密码='" & psd & "'"
                    Case 2
                        str = "select 用户名 from 超级用户表 where 用户名='" & name & "' and  密码='" & psd & "'"
                End Select
                If (q.GetString(str) <> "") Then
                    Select Case DropDownList1.SelectedIndex
                        Case 0
                            str = "update 用户记录表 set 密码='" & pass1 & "' where 用户名='" & name & "'"
                        Case 1
                            str = "update 单位记录表 set 密码='" & pass1 & "' where 用户名='" & name & "'"
                        Case 2
                            str = "update 超级单位表 set 密码='" & pass1 & "' where 用户名='" & name & "'"
                    End Select
                    q.ExecuteSQL(str)
                    message("提交成功")
                    TextBox1.Text = ""
                Else
                    message("用户名或密码有误")
                End If
                q.close()
            End If

        End If
    End Sub

    Private Sub Imagebutton2_Click(ByVal sender As System.Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles Imagebutton2.Click
        Response.Redirect("idmanage.aspx")
    End Sub
End Class