newsystem.cs

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

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace WindowsApplication1
{
    public partial class NewSystem : Form
    {
        SqlConnection cn = new SqlConnection("server = (local);UID = sa;PWD = sa;database = test1;trusted_connection = true"); 
        baseclass.BaseOperate boperate = new baseclass.BaseOperate();
        public NewSystem()
        {
            InitializeComponent();
        }

        private void NewSystem_Load(object sender, EventArgs e)
        {
            SqlCommand cmd = new SqlCommand("select start from start where id='"+ 1 +"'",cn);
            if (cn.State == ConnectionState.Closed)
                cn.Open();
            if(cmd.ExecuteScalar().ToString() == 1.ToString())
            {
                btnOk.Enabled = false;
                MessageBox.Show("考试进行中，不能进行系统初始化！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            if (cn.State == ConnectionState.Open)
                cn.Close();
        }
        /// <summary>
        /// 系统初始化
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                //清空选择题表，判断题表，程序设计题表
                if (checkPanduan.Checked || checkprogram.Checked || checkchoose.Checked)
                {
                    DataSet myds = boperate.getds("select * from shiti", "shiti");
                    //判断试题表是否为空,为空则可以直接清空选择题表，判断题表，程序设计题表，否则要先清空试题表，试卷表。
                    if (myds.Tables[0].Rows.Count > 0)
                    {
                        if (MessageBox.Show("该表中的信息已被试题表使用，若要删除该表的信息请先清除试题表和试卷表中的信息，是否要清除试卷表和试题表中的信息？", "删除确定", MessageBoxButtons.YesNo) == DialogResult.Yes)
                        {
                            boperate.getcom("delete from paper");
                            boperate.getcom("delete from shiti");
                            //清空判断题表
                            if (checkPanduan.Checked)
                            {
                                boperate.getcom("delete from panduan");
                                checkPanduan.Checked = false;
                            }
                            //清空程序题表
                            if (checkprogram.Checked)
                            {
                                boperate.getcom("delete from program");
                                checkprogram.Checked = false;
                            }
                            //清空选择题表
                            if (checkchoose.Checked)
                            {
                                boperate.getcom("delete from choose");
                                checkchoose.Checked = false;
                            }
                        }
                    }
                    else
                    {
                        //清空判断题表
                        if (checkPanduan.Checked)
                        {
                            boperate.getcom("delete from panduan");
                            checkPanduan.Checked = false;
                        }
                        //清空程序题表
                        if (checkprogram.Checked)
                        {
                            boperate.getcom("delete from program");
                            checkprogram.Checked = false;
                        }
                        //清空选择题表
                        if (checkchoose.Checked)
                        {
                            boperate.getcom("delete from choose");
                            checkchoose.Checked = false;
                        }
                    }
                }
                //清空试卷表
                if (checkpaper.Checked)
                {
                    boperate.getcom("delete from paper");
                    checkpaper.Checked = false;
                }
                //清空试题表
                if (checkshiti.Checked)
                {
                    DataSet myds = boperate.getds("select * from paper", "paper");
                    //判断试卷表是否为空,为空则可以直接清空试题表，否则要先清空试卷表。
                    if (myds.Tables[0].Rows.Count > 0)
                    {
                        if (MessageBox.Show("该表中的信息已被试卷表使用，若要删除该表的信息请先清除试卷表中的信息，是否要清除试卷表中的信息？", "删除确定", MessageBoxButtons.YesNo) == DialogResult.Yes)
                        {
                            boperate.getcom("delete from paper");
                            boperate.getcom("delete from shiti");
                            checkshiti.Checked = false;
                        }
                    }
                    else
                    {
                        boperate.getcom("delete from shiti");
                        checkshiti.Checked = false;
                    }
                }
                //清空学生信息表
                if (checkstudent.Checked)
                {
                    if (MessageBox.Show("如果删除学生信息，与改名学生相关的成绩表、违纪表、座次表中的信息都将被删除", "删除确定", MessageBoxButtons.YesNo) == DialogResult.Yes)
                    {
                        boperate.getcom("delete from student");
                        checkstudent.Checked = false;
                    }
                }
                //清空用户信息表
                if (checkuser.Checked)
                {
                    boperate.getcom("delete from userinfo");
                    checkuser.Checked = false;
                }
                //清空座次表
                if (checkzuoci.Checked)
                {
                    boperate.getcom("delete from zuoci");
                    checkzuoci.Checked = false;
                }
                //清空成绩表
                if (checkMark.Checked)
                {
                    boperate.getcom("delete from marks");
                    checkMark.Checked = false;
                }
                //清空违纪信息表
                if (checkweiji.Checked)
                {
                    boperate.getcom("delete from weiji");
                    checkweiji.Checked = false;
                }
                //清空考场信息表
                if (checkkchang.Checked)
                {
                    boperate.getcom("delete from kaochang");
                    checkkchang.Checked = false;
                }
                //清空模板信息表
                if (checkmuban.Checked)
                {
                    boperate.getcom("delete from moban");
                    checkmuban.Checked = false;
                }
                //清空院系表
                if (checkDepart.Checked)
                {
                    if (MessageBox.Show("如果删除院系表中内容，相应专业、班级表等其他表中相关的信息的内容都会删除，是否清空院系表？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.OK)
                    {
                        boperate.getcom("delete from department");
                    }
                    checkDepart.Checked = false;
                }
                //清空专业表
                if (checkprofession.Checked)
                {
                    if (MessageBox.Show("如果删除专业中内容，相应班级表等其他表中相关的内容都会删除，是否清空专业表？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.OK)
                    {
                        boperate.getcom("delete from profession");
                    }
                    checkprofession.Checked = false;
                }
                //清空班级表
                if (checkclass.Checked)
                {
                    if (MessageBox.Show("如果删除班级表中内容，相应学生表等其他表中的相关内容都会删除，是否清空班级表？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.OK)
                    {
                        boperate.getcom("delete from class");
                    }
                    checkclass.Checked = false;
                }
                //清空程序题答案表
                if (checkpanswer.Checked)
                {
                    boperate.getcom("delete from panswer");
                    checkpanswer.Checked = false;
                }
                //清空答案表
                if (checkanswer.Checked)
                {
                    boperate.getcom("delete from answer");
                    checkanswer.Checked = false;
                }
                //清空所有数据库中的数据表
                if (checkAll.Checked)
                {
                    if (MessageBox.Show("确定要清空所有表？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.OK)
                    {
                        DeleteAll();
                    }
                    checkAll.Checked = false;
                }
                MessageBox.Show("数据清理成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            catch(Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

        }


        #region 清空所有数据表
        public void DeleteAll()
        {
            string[] sql = new string[18];
            sql[0] = "delete from choose";
            sql[1] = "delete from class";
            sql[2] = "delete from department";
            sql[3] = "delete from kaochang";
            sql[4] = "delete from marks";
            sql[5] = "delete from moban";
            sql[6] = "delete from panduan";
            sql[7] = "delete from paper";
            sql[8] = "delete from profession";
            sql[9] = "delete from program";
            sql[10] = "delete from shiti";
            sql[11] = "delete from start";
            sql[12] = "delete from student";
            sql[13] = "delete from userinfo";
            sql[14] = "delete from weiji";
            sql[15] = "delete from zuoci";
            sql[16] = "delete from answer";
            sql[17] = "delete from panswer";
            for (int i = 0; i < 18; i++)
                boperate.getcom(sql[i]);
        }
        #endregion
        /// <summary>
        /// 关闭对话框
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        

       
    }
}