begintest.cs

程序设计语言上机考试系统

using System;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;

namespace WindowsApplication1.KaoChangManage
{
    public partial class BeginTest : Form
    {
        SqlConnection cn = new SqlConnection("SERVER=(local);UID=sa;PWD=sa;Trusted_Connection=True;DATABASE=test1");
        baseclass.BaseOperate boperate = new baseclass.BaseOperate();
        baseclass.OperateAndValidate opAndvalidate = new baseclass.OperateAndValidate();
        public BeginTest()
        {
            InitializeComponent();
            SqlCommand cmd = new SqlCommand("select start from start where id = '"+ 1.ToString() +"'", cn);
            if (cn.State == ConnectionState.Closed)
                cn.Open();
            if (cmd.ExecuteScalar().ToString() == 1.ToString())
            {
                MessageBox.Show("考试已经开始！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                btnOK.Enabled = false;
            }
            if (cn.State == ConnectionState.Open)
                cn.Close();
        }
        #region 考试开始
        private void btnOK_Click(object sender, EventArgs e)
        {
            
            if (MessageBox.Show("是否要开始考试！", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information) == DialogResult.OK)
            {
                SqlCommand cmd = new SqlCommand("select * from paper ", cn);
                if (cn.State == ConnectionState.Closed)
                    cn.Open();
                //判断试卷表中是否有信息，没有信息不能开始考试
                if (null == cmd.ExecuteScalar())
                {
                    MessageBox.Show("试卷表中没有信息，请重新确定是否已经发放试卷", "提示");
                    if (cn.State == ConnectionState.Open)
                        cn.Close();
                }
                if(!opAndvalidate.validateNum(comBTime.Text.Trim()))
                    errorProvider1.SetError(comBTime,"请输入正整数！");
                else
                {
                    errorProvider1.Clear();
                    //清空答案表和程序题答案表
                    boperate.getcom("delete from answer");
                    boperate.getcom("delete from panswer");
                    cmd = new SqlCommand("select * from start where id ='"+ "1" +"'",cn);
                    //如果start表中没有内容添加新开始项
                    if (null == cmd.ExecuteScalar())
                    {
                        boperate.getcom("insert into start (id,start,[time])values(1,1,'" + comBTime.Text.Trim() + "')");
                        boperate.getcom("update zuoci set loginstatus ='" + "未登录" + "'where loginstatus ='" + "已交卷" + "'");

                        MessageBox.Show("考试开始！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                    else
                    {
                        //如果start表中有内容更新原来的开始项
                        boperate.getcom("update start set start = '" + "1" + "',[time] = '" + comBTime.Text.Trim() + "'where id = '" + "1" + "'");
                        boperate.getcom("update zuoci set loginstatus ='" + "未登录" + "'where loginstatus ='" + "已交卷" + "'");

                        MessageBox.Show("考试开始！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                    if (cn.State == ConnectionState.Open)
                        cn.Close();
                    this.Close();
                }
            }
        }
        #endregion
        
        private void btnQuit_Click(object sender, EventArgs e)
        {
            this.Close();
        }
    }
}