kchangmonitor.cs

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

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

namespace WindowsApplication1.KaoChangManage
{
    public partial class KChangMonitor : Form
    {
        baseclass.OperateAndValidate opAndvalidate = new baseclass.OperateAndValidate();
        baseclass.BaseOperate boperate = new baseclass.BaseOperate();
        public KChangMonitor()
        {
            InitializeComponent();
        }

        #region 关闭窗口
        private void tsbtnExit_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        #endregion

        #region 显示所有信息
        private void toolStripBtnAll_Click(object sender, EventArgs e)
        {
            DataSet myds = boperate.getds("select s_number as 学号,zuoweiid as 座位号,kname as 考场名称,loginstatus as 登陆状态, remaintime as 剩余考试时间 from zuoci order by kname", "zuoci");
            dataGridView1.DataSource = myds.Tables[0];
        }
        #endregion

        #region 搜索
        private void tsbtnLook_Click(object sender, EventArgs e)
        {
            if (tscboxCondition.Text.Trim() == "" || tstxtKeyWord.Text.Trim() == "")
                MessageBox.Show("请输入完整的信息！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            else
            {
                switch (tscboxCondition.Text.Trim())
                {
                    case "学号":
                        DataSet myds = boperate.getds("select s_number as 学号,zuoweiid as 座位号,kname as 考场名称,loginstatus as 登陆状态, remaintime as 剩余考试时间 from zuoci where s_number  like '%" + tstxtKeyWord.Text.Trim() + "%' order by kname ", "zuoci");
                        dataGridView1.DataSource = myds.Tables[0];
                        break;
                    case "座位号":
                        myds = boperate.getds("select s_number as 学号,zuoweiid as 座位号,kname as 考场名称,loginstatus as 登陆状态, remaintime as 剩余考试时间 from zuoci where zuoweiid  like '%" + tstxtKeyWord.Text.Trim() + "%' order by kname ", "zuoci");
                        dataGridView1.DataSource = myds.Tables[0];
                        break;
                    case "考场名称":
                        myds = boperate.getds("select s_number as 学号,zuoweiid as 座位号,kname as 考场名称,loginstatus as 登陆状态, remaintime as 剩余考试时间 from zuoci where kname like '%" + tstxtKeyWord.Text.Trim() + "%' order by kname ", "zuoci");
                        dataGridView1.DataSource = myds.Tables[0];
                        break;
                    case "登录状态":
                        myds = boperate.getds("select s_number as 学号,zuoweiid as 座位号,kname as 考场名称,loginstatus as 登陆状态, remaintime as 剩余考试时间 from zuoci where loginstatus like '% " + tstxtKeyWord.Text.Trim() + "%' order by kname ", "zuoci");
                        dataGridView1.DataSource = myds.Tables[0];
                        break;
                    default:
                        break;
                }
            }
        }
        #endregion

        #region 计时器
        private void timer_Tick(object sender, EventArgs e)
        {
            //每分钟刷新一次数据表
            DataSet myds = boperate.getds("select s_number as 学号,zuoweiid as 座位号,kname as 考场名称,loginstatus as 登陆状态, remaintime as 剩余考试时间 from zuoci order by kname", "zuoci");
            dataGridView1.DataSource = myds.Tables[0];
        }
        #endregion
        
        private void KChangMonitor_Load(object sender, EventArgs e)
        {
            DataSet myds = boperate.getds("select s_number as 学号,zuoweiid as 座位号,kname as 考场名称,loginstatus as 登陆状态, remaintime as 剩余考试时间 from zuoci order by kname", "zuoci");
            dataGridView1.DataSource = myds.Tables[0];
            if (myds.Tables[0].Rows.Count <= 0)
            {
                dataGridView1.AllowUserToAddRows = true;
            }
        }

        private void tscboxCondition_SelectedIndexChanged(object sender, EventArgs e)
        {
            switch (tscboxCondition.Text.Trim())
            {
                case "学号":
                    tSComboBoxBind("select  distinct s_number from zuoci  order by s_number ", "s_number");
                    break;
                case "座位号":
                    tSComboBoxBind("select  distinct zuoweiid from zuoci  order by zuoweiid ", "zuoweiid");
                    break;
                case "考场名称":
                    tSComboBoxBind("select distinct kname from zuoci", "kname");
                    break;
                case "登录状态":
                    tSComboBoxBind("select  distinct loginstatus  from zuoci  ", "loginstatus");
                    break;
                default:
                    break;
            }
        }

        #region 给ToolStripComboBox绑定数据
        private void tSComboBoxBind(string sql,string rowname)
        {
            tstxtKeyWord.Items.Clear();
            DataSet myds = boperate.getds(sql, "zuoci");
            foreach (DataRow row in myds.Tables[0].Rows)
            {
                tstxtKeyWord.Items.Add(row[rowname].ToString());
            }
        }
        #endregion

    }
}