addpaper.aspx.vb

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

Public Class AddPaper
    Inherits System.Web.UI.Page

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

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

    End Sub
    Protected WithEvents Textbox5 As System.Web.UI.WebControls.TextBox
    Protected WithEvents Textbox6 As System.Web.UI.WebControls.TextBox
    Protected WithEvents Textbox7 As System.Web.UI.WebControls.TextBox
    Protected WithEvents Textbox8 As System.Web.UI.WebControls.TextBox
    Protected WithEvents Textbox9 As System.Web.UI.WebControls.TextBox
    Protected WithEvents Textbox10 As System.Web.UI.WebControls.TextBox
    Protected WithEvents Textbox11 As System.Web.UI.WebControls.TextBox
    Protected WithEvents Textbox12 As System.Web.UI.WebControls.TextBox
    Protected WithEvents Textbox13 As System.Web.UI.WebControls.TextBox
    Protected WithEvents Textbox14 As System.Web.UI.WebControls.TextBox
    Protected WithEvents Textbox15 As System.Web.UI.WebControls.TextBox
    Protected WithEvents Textbox16 As System.Web.UI.WebControls.TextBox
    Protected WithEvents Textbox4 As System.Web.UI.WebControls.TextBox
    Protected WithEvents Button1 As System.Web.UI.WebControls.Button
    Protected WithEvents Textbox1 As System.Web.UI.WebControls.TextBox
    Protected WithEvents Textbox2 As System.Web.UI.WebControls.TextBox
    Protected WithEvents Textbox3 As System.Web.UI.WebControls.TextBox
    Protected WithEvents Textbox17 As System.Web.UI.WebControls.TextBox
    Protected WithEvents ImageButton1 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 Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim name As String = Trim(Textbox1.Text)
        Dim pass1 As String = Trim(Textbox2.Text)
        Dim pass2 As String = Trim(Textbox3.Text)
        If Textbox4.Text = "" Or Textbox5.Text = "" Or Textbox6.Text = "" Or Textbox7.Text = "" Or Textbox8.Text = "" Or Textbox9.Text = "" Or Textbox10.Text = "" Or Textbox11.Text = "" Or Textbox12.Text = "" Or Textbox13.Text = "" Or Textbox14.Text = "" Or Textbox15.Text = "" Or Textbox16.Text = "" Or Textbox17.Text = "" Or name = "" Or pass1 = "" Or pass2 = "" Then
            message("输入不能为空")
        Else
            If (pass1 <> pass2) Then
                message("两次密码不一致")
            Else
                Dim s As String = Textbox4.Text.Substring(0, Textbox4.Text.Length - 3)
                Dim q As SqlClass = New SqlClass
                q.Open()
                Dim str As String
                Dim signal As Boolean = True
                Try
                    str = "insert into 单位记录表(用户名,密码,题库,权限) values('" & name & "','" & pass1 & "','" & s & "','题库维护用户')"
                    q.ExecuteSQL(str)
                    signal = True
                Catch ex As Exception
                    message("用户名已经存在")
                    signal = False
                End Try
                If signal Then
                    Try
                        str = "CREATE TABLE [dbo].[" & s & "] ([试题ID] [int] IDENTITY (1, 1) NOT NULL ,[专业] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,[试题题型] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,[试题难易] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,[试题分数] [int] NOT NULL ,[试题] [varchar] (400) COLLATE Chinese_PRC_CI_AS NOT NULL ,[答案] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,[附加参数] [int] NOT NULL ) ON [PRIMARY]"
                        q.ExecuteSQL(str)
                        str = "insert into 试卷名称表(试卷名称,总分,时间,难度,单项选择题量,多项选择题量,判断题量,排序题量,单项选择分数,多项选择分数,判断分数,排序分数,专业,试卷编号) values('" & Textbox4.Text & "'," & Textbox5.Text & "," & Textbox6.Text & ",'" & Textbox17.Text & "'," & Textbox7.Text & "," & Textbox8.Text & "," & Textbox9.Text & "," & Textbox10.Text & "," & Textbox11.Text & "," & Textbox12.Text & "," & Textbox13.Text & "," & Textbox14.Text & ",'" & Textbox15.Text & "','" & Textbox16.Text & "')"
                        q.ExecuteSQL(str)
                        message("提交成功")
                    Catch ex As Exception
                        message("提交失败")
                    End Try
                End If
                q.close()
                End If

        End If
    End Sub

    Private Sub ImageButton1_Click(ByVal sender As System.Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles ImageButton1.Click
        Response.Redirect("Selectuser.aspx")
    End Sub
End Class