form_khcjcx.cs

一个很简单的考试系统。实用性很强啊！数据库在里面

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
using C1.Win.C1Chart;

namespace bizdb
{
	/// <summary>
	/// Form_khcjcx 的摘要说明。
	/// </summary>
	public class Form_khcjcx : System.Windows.Forms.Form
	{
		private System.Windows.Forms.CheckBox chk_stat;
		private System.Windows.Forms.Panel panel;
		private System.Windows.Forms.CheckBox chk_kscj;
		private System.Windows.Forms.CheckBox chk_id;
		private System.Windows.Forms.CheckBox chk_name;
		private System.Windows.Forms.ComboBox cbo_kscj;
		private System.Windows.Forms.TextBox txt_id;
		private System.Windows.Forms.TextBox txt_name;
		private System.Windows.Forms.Button btn_query2;
		private System.Windows.Forms.RadioButton ridbtn_ndtj;
		private System.Windows.Forms.RadioButton ridbtn_dktj;
		private System.Windows.Forms.Button btn_print;
		private System.Windows.Forms.Button btn_stat;
		private System.Windows.Forms.DataGrid dg2;
		private System.Windows.Forms.Label lbl_ksrq;
		private System.Windows.Forms.ComboBox cbo_nbkskm;
		private System.Windows.Forms.Label lbl_nbkskm;
		private System.Windows.Forms.GroupBox grp_dktj;
		private System.Windows.Forms.Label lbl_rs1;
		private System.Windows.Forms.Label lbl_hgrs1;
		private System.Windows.Forms.Label lbl_bmksrs1;
		private System.Windows.Forms.TextBox txt_bhgrs1;
		private System.Windows.Forms.TextBox txt_hgrs1;
		private System.Windows.Forms.TextBox txt_bmksrs1;
		private System.Windows.Forms.Label lbl_bhgrs1;
		private System.Windows.Forms.GroupBox grp_khcj;
		private System.Windows.Forms.GroupBox grp_ndtj;
		private System.Windows.Forms.Label lbl_hgrs2;
		private System.Windows.Forms.Label lbl_bmksrs2;
		private System.Windows.Forms.Label lbl_kskm2;
		private System.Windows.Forms.TextBox txt_bhgrs2;
		private System.Windows.Forms.TextBox txt_hgrs2;
		private System.Windows.Forms.TextBox txt_bmksrs2;
		private System.Windows.Forms.TextBox txt_kskm2;
		private System.Windows.Forms.Label lbl_bhgrs2;
		private System.Windows.Forms.Label lbl_rs2;
		private System.Windows.Forms.TextBox txt_kskm1;
		private System.Windows.Forms.Label lbl_kskm1;
		private System.Windows.Forms.DateTimePicker dtp_time;
		private System.Windows.Forms.Label lbl_jsrq;
		private System.Windows.Forms.DateTimePicker dtp_jsrq;
		private C1.Win.C1Chart.C1Chart Chart_dktj;
		private C1.Win.C1Chart.C1Chart Chart_ndtj;
		private dbAccess db = new dbAccess();
		private System.Windows.Forms.Label lbl_hgl1;
		private System.Windows.Forms.TextBox txt_hgl1;
		private System.Windows.Forms.TextBox txt_hgl2;
		private System.Windows.Forms.Label lbl_hgl2;
	
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;

		public Form_khcjcx()
		{
			//
			// Windows 窗体设计器支持所必需的
			//
			InitializeComponent();

			//
			// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
			//
		}

		/// <summary>
		/// 清理所有正在使用的资源。
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if( disposing )
			{
				if(components != null)
				{
					components.Dispose();
				}
			}
			base.Dispose( disposing );
		}

		#region Windows 窗体设计器生成的代码
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			this.chk_stat = new System.Windows.Forms.CheckBox();
			this.panel = new System.Windows.Forms.Panel();
			this.dtp_jsrq = new System.Windows.Forms.DateTimePicker();
			this.lbl_jsrq = new System.Windows.Forms.Label();
			this.chk_kscj = new System.Windows.Forms.CheckBox();
			this.chk_id = new System.Windows.Forms.CheckBox();
			this.chk_name = new System.Windows.Forms.CheckBox();
			this.cbo_kscj = new System.Windows.Forms.ComboBox();
			this.txt_id = new System.Windows.Forms.TextBox();
			this.txt_name = new System.Windows.Forms.TextBox();
			this.btn_query2 = new System.Windows.Forms.Button();
			this.ridbtn_ndtj = new System.Windows.Forms.RadioButton();
			this.ridbtn_dktj = new System.Windows.Forms.RadioButton();
			this.btn_print = new System.Windows.Forms.Button();
			this.btn_stat = new System.Windows.Forms.Button();
			this.dg2 = new System.Windows.Forms.DataGrid();
			this.lbl_ksrq = new System.Windows.Forms.Label();
			this.cbo_nbkskm = new System.Windows.Forms.ComboBox();
			this.lbl_nbkskm = new System.Windows.Forms.Label();
			this.grp_dktj = new System.Windows.Forms.GroupBox();
			this.txt_hgl1 = new System.Windows.Forms.TextBox();
			this.lbl_hgl1 = new System.Windows.Forms.Label();
			this.Chart_dktj = new C1.Win.C1Chart.C1Chart();
			this.lbl_rs1 = new System.Windows.Forms.Label();
			this.lbl_hgrs1 = new System.Windows.Forms.Label();
			this.lbl_bmksrs1 = new System.Windows.Forms.Label();
			this.lbl_kskm1 = new System.Windows.Forms.Label();
			this.txt_bhgrs1 = new System.Windows.Forms.TextBox();
			this.txt_hgrs1 = new System.Windows.Forms.TextBox();
			this.txt_bmksrs1 = new System.Windows.Forms.TextBox();
			this.txt_kskm1 = new System.Windows.Forms.TextBox();
			this.lbl_bhgrs1 = new System.Windows.Forms.Label();
			this.grp_khcj = new System.Windows.Forms.GroupBox();
			this.grp_ndtj = new System.Windows.Forms.GroupBox();
			this.txt_hgl2 = new System.Windows.Forms.TextBox();
			this.lbl_hgl2 = new System.Windows.Forms.Label();
			this.Chart_ndtj = new C1.Win.C1Chart.C1Chart();
			this.lbl_hgrs2 = new System.Windows.Forms.Label();
			this.lbl_bmksrs2 = new System.Windows.Forms.Label();
			this.lbl_kskm2 = new System.Windows.Forms.Label();
			this.txt_bhgrs2 = new System.Windows.Forms.TextBox();
			this.txt_hgrs2 = new System.Windows.Forms.TextBox();
			this.txt_bmksrs2 = new System.Windows.Forms.TextBox();
			this.txt_kskm2 = new System.Windows.Forms.TextBox();
			this.lbl_bhgrs2 = new System.Windows.Forms.Label();
			this.lbl_rs2 = new System.Windows.Forms.Label();
			this.dtp_time = new System.Windows.Forms.DateTimePicker();
			this.panel.SuspendLayout();
			((System.ComponentModel.ISupportInitialize)(this.dg2)).BeginInit();
			this.grp_dktj.SuspendLayout();
			((System.ComponentModel.ISupportInitialize)(this.Chart_dktj)).BeginInit();
			this.grp_ndtj.SuspendLayout();
			((System.ComponentModel.ISupportInitialize)(this.Chart_ndtj)).BeginInit();
			this.SuspendLayout();
			// 
			// chk_stat
			// 
			this.chk_stat.Location = new System.Drawing.Point(592, 16);
			this.chk_stat.Name = "chk_stat";
			this.chk_stat.Size = new System.Drawing.Size(48, 24);
			this.chk_stat.TabIndex = 47;
			this.chk_stat.Text = "统计";
			this.chk_stat.CheckedChanged += new System.EventHandler(this.chk_stat_CheckedChanged);
			// 
			// panel
			// 
			this.panel.Controls.Add(this.dtp_jsrq);
			this.panel.Controls.Add(this.lbl_jsrq);
			this.panel.Controls.Add(this.chk_kscj);
			this.panel.Controls.Add(this.chk_id);
			this.panel.Controls.Add(this.chk_name);
			this.panel.Controls.Add(this.cbo_kscj);
			this.panel.Controls.Add(this.txt_id);
			this.panel.Controls.Add(this.txt_name);
			this.panel.Controls.Add(this.btn_query2);
			this.panel.Location = new System.Drawing.Point(24, 48);
			this.panel.Name = "panel";
			this.panel.Size = new System.Drawing.Size(552, 72);
			this.panel.TabIndex = 46;
			this.panel.Paint += new System.Windows.Forms.PaintEventHandler(this.panel_Paint);
			// 
			// dtp_jsrq
			// 
			this.dtp_jsrq.Location = new System.Drawing.Point(344, 8);
			this.dtp_jsrq.Name = "dtp_jsrq";
			this.dtp_jsrq.Size = new System.Drawing.Size(120, 21);
			this.dtp_jsrq.TabIndex = 37;
			this.dtp_jsrq.Visible = false;
			// 
			// lbl_jsrq
			// 
			this.lbl_jsrq.Location = new System.Drawing.Point(272, 8);
			this.lbl_jsrq.Name = "lbl_jsrq";
			this.lbl_jsrq.Size = new System.Drawing.Size(56, 16);
			this.lbl_jsrq.TabIndex = 36;
			this.lbl_jsrq.Text = "结束日期";
			this.lbl_jsrq.Visible = false;
			// 
			// chk_kscj
			// 
			this.chk_kscj.Location = new System.Drawing.Point(256, 40);
			this.chk_kscj.Name = "chk_kscj";
			this.chk_kscj.Size = new System.Drawing.Size(80, 24);
			this.chk_kscj.TabIndex = 35;
			this.chk_kscj.Text = "考试成绩";
			this.chk_kscj.CheckedChanged += new System.EventHandler(this.chk_kscj_CheckedChanged);
			// 
			// chk_id
			// 
			this.chk_id.Location = new System.Drawing.Point(16, 40);
			this.chk_id.Name = "chk_id";
			this.chk_id.Size = new System.Drawing.Size(80, 24);
			this.chk_id.TabIndex = 34;
			this.chk_id.Text = "身份证号";
			this.chk_id.CheckedChanged += new System.EventHandler(this.chk_id_CheckedChanged);
			// 
			// chk_name
			// 
			this.chk_name.Location = new System.Drawing.Point(16, 8);
			this.chk_name.Name = "chk_name";
			this.chk_name.Size = new System.Drawing.Size(80, 24);
			this.chk_name.TabIndex = 33;
			this.chk_name.Text = "考生姓名";
			this.chk_name.CheckedChanged += new System.EventHandler(this.chk_name_CheckedChanged);
			// 
			// cbo_kscj
			// 
			this.cbo_kscj.Enabled = false;
			this.cbo_kscj.Location = new System.Drawing.Point(344, 40);
			this.cbo_kscj.Name = "cbo_kscj";
			this.cbo_kscj.Size = new System.Drawing.Size(88, 20);
			this.cbo_kscj.TabIndex = 32;
			// 
			// txt_id
			// 
			this.txt_id.Enabled = false;
			this.txt_id.Location = new System.Drawing.Point(96, 40);
			this.txt_id.Name = "txt_id";
			this.txt_id.Size = new System.Drawing.Size(120, 21);
			this.txt_id.TabIndex = 31;
			this.txt_id.Text = "";
			// 
			// txt_name
			// 
			this.txt_name.Enabled = false;
			this.txt_name.Location = new System.Drawing.Point(96, 8);
			this.txt_name.Name = "txt_name";
			this.txt_name.Size = new System.Drawing.Size(120, 21);
			this.txt_name.TabIndex = 30;
			this.txt_name.Text = "";
			// 
			// btn_query2
			// 
			this.btn_query2.Location = new System.Drawing.Point(472, 40);
			this.btn_query2.Name = "btn_query2";
			this.btn_query2.Size = new System.Drawing.Size(72, 24);
			this.btn_query2.TabIndex = 29;
			this.btn_query2.Text = "查询(&Q)";
			this.btn_query2.Click += new System.EventHandler(this.btn_query2_Click);
			// 
			// ridbtn_ndtj
			// 
			this.ridbtn_ndtj.Enabled = false;
			this.ridbtn_ndtj.Location = new System.Drawing.Point(680, 48);
			this.ridbtn_ndtj.Name = "ridbtn_ndtj";
			this.ridbtn_ndtj.Size = new System.Drawing.Size(72, 24);
			this.ridbtn_ndtj.TabIndex = 44;
			this.ridbtn_ndtj.Text = "年度统计";
			this.ridbtn_ndtj.CheckedChanged += new System.EventHandler(this.ridbtn_ndtj_CheckedChanged);
			// 
			// ridbtn_dktj
			// 
			this.ridbtn_dktj.Enabled = false;
			this.ridbtn_dktj.Location = new System.Drawing.Point(680, 24);
			this.ridbtn_dktj.Name = "ridbtn_dktj";
			this.ridbtn_dktj.Size = new System.Drawing.Size(72, 24);
			this.ridbtn_dktj.TabIndex = 43;
			this.ridbtn_dktj.Text = "单科统计";
			this.ridbtn_dktj.CheckedChanged += new System.EventHandler(this.ridbtn_dktj_CheckedChanged);
			// 
			// btn_print
			// 
			this.btn_print.Enabled = false;
			this.btn_print.Location = new System.Drawing.Point(688, 88);
			this.btn_print.Name = "btn_print";
			this.btn_print.TabIndex = 42;
			this.btn_print.Text = "打印";
			this.btn_print.Visible = false;
			// 
			// btn_stat
			// 
			this.btn_stat.Enabled = false;
			this.btn_stat.Location = new System.Drawing.Point(592, 88);
			this.btn_stat.Name = "btn_stat";
			this.btn_stat.TabIndex = 41;
			this.btn_stat.Text = "统计";
			this.btn_stat.Visible = false;
			this.btn_stat.Click += new System.EventHandler(this.btn_stat_Click);
			// 
			// dg2
			// 
			this.dg2.DataMember = "";
			this.dg2.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dg2.Location = new System.Drawing.Point(16, 128);
			this.dg2.Name = "dg2";
			this.dg2.ReadOnly = true;
			this.dg2.Size = new System.Drawing.Size(760, 168);
			this.dg2.TabIndex = 37;
			// 
			// lbl_ksrq