examscorelistform.cs

来自「一个不错的文档」· CS 代码 · 共 236 行

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

namespace MySchoolPrj.ExamInfo
{
    public partial class ExamScoreListForm : Form
    {
        public ExamScoreListForm()
        {
            InitializeComponent();
        }
        private UserHelper grade;

        internal UserHelper Grade
        {
            get { return grade; }
            set { grade = value; }
        }

       //设置状态信息
        public void setExam()
        {
            switch (UserHelper.grade)
            {
                case 1:
                    btnAdd.Visible = false;
                    btnCel.Visible = false;
                    btnFind.Visible = true;
                    btnRes.Visible = true;
                    btnExit.Visible = true;
                    break;
                case 2:
                    btnAdd.Visible = true;
                    btnCel.Visible = true;
                    btnFind.Visible = true;
                    btnRes.Visible = true;
                    btnExit.Visible = true;

                    break;
                case 3:
                    btnAdd.Visible = true;
                    btnCel.Visible = true;
                    btnFind.Visible = true;
                    btnRes.Visible = true;
                    btnExit.Visible = true;

                    break;
            }
        }
        //获取考试信息
        public void getExam()
        {
            try
            {
                DBHelper.con.Open();
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = DBHelper.con;
                cmd.CommandType = CommandType.Text;
                string sql = "select * from exam";
                cmd.CommandText = sql;

                SqlDataAdapter dap = new SqlDataAdapter();
                dap.SelectCommand = cmd;
                DataTable dt = new DataTable();
                dap.Fill(dt);
                dgvExam.DataSource = dt;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                DBHelper.con.Close();
            }
        }
        //初始化DataGridView的显示
        public void initDg()
        {
            //整行选择
            dgvExam.SelectionMode = DataGridViewSelectionMode.FullRowSelect;

            dgvExam.RowHeadersVisible = false;
            //设置该行选项是否为只读
            dgvExam.ReadOnly = true;
            //不可以添加项
            dgvExam.AllowUserToAddRows = false;
            //不可以多选
            dgvExam.MultiSelect = false;
            //设置DataGridView的属性
            for (int i = 0; i < dgvExam.Columns.Count; i++)
            {
                dgvExam.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable;
                string headerText = dgvExam.Columns[i].HeaderText;
                switch (headerText)
                {
                    case "examId":
                        dgvExam.Columns[i].HeaderText = "考试编号";
                        dgvExam.Columns[i].Width = 110;
                        break;
                    case "stuId":
                        dgvExam.Columns[i].HeaderText = "学生编号";
                        dgvExam.Columns[i].Width = 110;
                        break;
                    case "courseId":
                        dgvExam.Columns[i].HeaderText = "课程编号";
                        dgvExam.Columns[i].Width = 110;
                        break;
                    case "WrittenScore":
                        dgvExam.Columns[i].HeaderText = "笔试成绩";
                        dgvExam.Columns[i].Width = 110;
                        break;
                    case "LabScore":
                        dgvExam.Columns[i].HeaderText = "机试成绩";
                        dgvExam.Columns[i].Width = 110;
                        break;
                }

            }
        }
        //删除学生信息
        public void delExam(string stuID)
        {
            try
            {
                //数据库连接
                DBHelper.con.Open();
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = DBHelper.con;
                cmd.CommandType = CommandType.Text;
                string sql = string.Format("delete from exam where examId = '{0}'", stuID);
                cmd.CommandText = sql;
                cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                DBHelper.con.Close();
            }
        }
        //设置初始化信息
        private void ExamScoreListForm_Load(object sender, EventArgs e)
        {
            setExam();
            getExam();
            initDg();
        }
        //增加信息
        private void btnAdd_Click(object sender, EventArgs e)
        {
            AddExamScoreForm addexamscorefrom = new AddExamScoreForm();
            addexamscorefrom.ShowDialog();
            getExam();
        }
        //删除信息
        private void btnCel_Click(object sender, EventArgs e)
        {
            
                DialogResult res = MessageBox.Show("你确定删除吗？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
                if (res == DialogResult.Cancel)
                    return;
                if (dgvExam.Rows.Count > 0)
                {
                int curRow = dgvExam.CurrentRow.Index;
                DataTable dt = (DataTable)dgvExam.DataSource;
                string examId = dt.Rows[curRow]["examId"].ToString();
                delExam(examId);
                getExam();
            }
            else
            {
                MessageBox.Show("没有要删除的信息!");
            }
        }
        //查询信息
        private void btnFind_Click(object sender, EventArgs e)
        {
            try
            {
                //数据库链接
                DBHelper.con.Open();
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = DBHelper.con;
                cmd.CommandType = CommandType.Text;
                string sql = "select *from exam where 1=1";
                if (ckStu.Checked)
                    sql += " and stuID='" + txtStuId.Text + "'";
                if (ckExamID.Checked)
                    sql += " and examID='" + txtExamID.Text + "'";
                if (ckCourse.Checked)
                    sql += " and courseID='" + txtCourseID.Text + "'";
                cmd.CommandText = sql;

                SqlDataAdapter dap = new SqlDataAdapter();
                dap.SelectCommand = cmd;
                DataTable dt = new DataTable();
                dap.Fill(dt);
                dgvExam.DataSource = dt;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                DBHelper.con.Close();
            }
        }
       //重置
        private void btnRes_Click(object sender, EventArgs e)
        {
            ckCourse.Checked = false;
            ckExamID.Checked = false;
            ckStu.Checked = false;
            txtStuId.Text="";
            txtExamID.Text="";
            txtCourseID.Text="";
            getExam();
        }
        //关闭窗体
        private void btnExit_Click(object sender, EventArgs e)
        {
            this.Close();
        }
    }
}