form_khcjcx.cs

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

				"ern=\"Dash\" Thickness=\"1\" /><GridMinor AutoSpace=\"True\" Color=\"LightGray\" Pattern" +
				"=\"Dash\" Thickness=\"1\" /><Text /></Axis><Axis UnitMajor=\"5\" UnitMinor=\"2.5\" AutoM" +
				"ajor=\"True\" AutoMinor=\"True\" AutoMax=\"True\" AutoMin=\"True\" Max=\"25\" Min=\"6\" _onT" +
				"op=\"0\" Compass=\"West\"><GridMajor AutoSpace=\"True\" Color=\"LightGray\" Pattern=\"Das" +
				"h\" Thickness=\"1\" /><GridMinor AutoSpace=\"True\" Color=\"LightGray\" Pattern=\"Dash\" " +
				"Thickness=\"1\" /><Text /></Axis><Axis UnitMajor=\"0\" UnitMinor=\"0\" AutoMajor=\"True" +
				"\" AutoMinor=\"True\" AutoMax=\"True\" AutoMin=\"True\" Max=\"0\" Min=\"0\" _onTop=\"0\" Comp" +
				"ass=\"East\"><GridMajor AutoSpace=\"True\" Color=\"LightGray\" Pattern=\"Dash\" Thicknes" +
				"s=\"1\" /><GridMinor AutoSpace=\"True\" Color=\"LightGray\" Pattern=\"Dash\" Thickness=\"" +
				"1\" /><Text /></Axis></Axes><ChartGroupsCollection><ChartGroup><ShowOutline>True<" +
				"/ShowOutline><HiLoData>FillFalling=True,FillTransparent=True,FullWidth=False,Sho" +
				"wClose=True,ShowOpen=True</HiLoData><ChartType>XYPlot</ChartType><Name>Group1</N" +
				"ame><Bar>ClusterOverlap=0,ClusterWidth=50</Bar><DataSerializer Hole=\"3.402823466" +
				"3852886E+38\" DefaultSet=\"True\"><DataSeriesCollection><DataSeriesSerializer><Seri" +
				"esLabel>series 0</SeriesLabel><DataTypes>Single;Single;Double;Double;Double</Dat" +
				"aTypes><DataFields>;;;;</DataFields><SymbolStyle Color=\"Coral\" Shape=\"Box\" /><X>" +
				"1;2;3;4;5</X><Y1 /><Y>20;22;19;24;25</Y><LineStyle Color=\"DarkGoldenrod\" Pattern" +
				"=\"Solid\" Thickness=\"1\" /><Tag /><Y2 /><Y3 /></DataSeriesSerializer><DataSeriesSe" +
				"rializer><SeriesLabel>series 1</SeriesLabel><DataTypes>Single;Single;Double;Doub" +
				"le;Double</DataTypes><DataFields>;;;;</DataFields><SymbolStyle Color=\"Cornflower" +
				"Blue\" Shape=\"Dot\" /><X>1;2;3;4;5</X><Y1 /><Y>8;12;10;12;15</Y><LineStyle Color=\"" +
				"DarkGray\" Pattern=\"Solid\" Thickness=\"1\" /><Tag /><Y2 /><Y3 /></DataSeriesSeriali" +
				"zer><DataSeriesSerializer><SeriesLabel>series 2</SeriesLabel><DataTypes>Single;S" +
				"ingle;Double;Double;Double</DataTypes><DataFields>;;;;</DataFields><SymbolStyle " +
				"Color=\"Cornsilk\" Shape=\"Tri\" /><X>1;2;3;4;5</X><Y1 /><Y>10;16;17;15;23</Y><LineS" +
				"tyle Color=\"DarkGreen\" Pattern=\"Solid\" Thickness=\"1\" /><Tag /><Y2 /><Y3 /></Data" +
				"SeriesSerializer><DataSeriesSerializer><SeriesLabel>series 3</SeriesLabel><DataT" +
				"ypes>Single;Single;Double;Double;Double</DataTypes><DataFields>;;;;</DataFields>" +
				"<SymbolStyle Color=\"Crimson\" Shape=\"Diamond\" /><X>1;2;3;4;5</X><Y1 /><Y>16;19;15" +
				";22;18</Y><LineStyle Color=\"DarkKhaki\" Pattern=\"Solid\" Thickness=\"1\" /><Tag /><Y" +
				"2 /><Y3 /></DataSeriesSerializer></DataSeriesCollection></DataSerializer><Bubble" +
				">EncodingMethod=Diameter,MaximumSize=20,MinimumSize=5</Bubble><Pie>OtherOffset=0" +
				",Start=0</Pie><Polar>Degrees=True,PiRatioAnnotations=True,Start=0</Polar><Stacke" +
				"d>False</Stacked><Radar>Degrees=True,Filled=False,Start=0</Radar><Visible>True</" +
				"Visible></ChartGroup><ChartGroup><ShowOutline>True</ShowOutline><HiLoData>FillFa" +
				"lling=True,FillTransparent=True,FullWidth=False,ShowClose=True,ShowOpen=True</Hi" +
				"LoData><ChartType>XYPlot</ChartType><Name>Group2</Name><Bar>ClusterOverlap=0,Clu" +
				"sterWidth=50</Bar><DataSerializer Hole=\"3.4028234663852886E+38\" /><Bubble>Encodi" +
				"ngMethod=Diameter,MaximumSize=20,MinimumSize=5</Bubble><Pie>OtherOffset=0,Start=" +
				"0</Pie><Polar>Degrees=True,PiRatioAnnotations=True,Start=0</Polar><Stacked>False" +
				"</Stacked><Radar>Degrees=True,Filled=False,Start=0</Radar><Visible>True</Visible" +
				"></ChartGroup></ChartGroupsCollection></Chart2DPropBag>";
			this.Chart_ndtj.Size = new System.Drawing.Size(264, 184);
			this.Chart_ndtj.TabIndex = 26;
			// 
			// lbl_hgrs2
			// 
			this.lbl_hgrs2.Location = new System.Drawing.Point(8, 120);
			this.lbl_hgrs2.Name = "lbl_hgrs2";
			this.lbl_hgrs2.Size = new System.Drawing.Size(56, 16);
			this.lbl_hgrs2.TabIndex = 18;
			this.lbl_hgrs2.Text = "合格人数";
			// 
			// lbl_bmksrs2
			// 
			this.lbl_bmksrs2.Location = new System.Drawing.Point(8, 88);
			this.lbl_bmksrs2.Name = "lbl_bmksrs2";
			this.lbl_bmksrs2.Size = new System.Drawing.Size(56, 16);
			this.lbl_bmksrs2.TabIndex = 16;
			this.lbl_bmksrs2.Text = "考试人数";
			// 
			// lbl_kskm2
			// 
			this.lbl_kskm2.Location = new System.Drawing.Point(8, 24);
			this.lbl_kskm2.Name = "lbl_kskm2";
			this.lbl_kskm2.Size = new System.Drawing.Size(56, 16);
			this.lbl_kskm2.TabIndex = 15;
			this.lbl_kskm2.Text = "考试科目";
			// 
			// txt_bhgrs2
			// 
			this.txt_bhgrs2.BackColor = System.Drawing.SystemColors.Window;
			this.txt_bhgrs2.Location = new System.Drawing.Point(72, 152);
			this.txt_bhgrs2.Name = "txt_bhgrs2";
			this.txt_bhgrs2.ReadOnly = true;
			this.txt_bhgrs2.Size = new System.Drawing.Size(32, 21);
			this.txt_bhgrs2.TabIndex = 24;
			this.txt_bhgrs2.Text = "";
			this.txt_bhgrs2.TextAlign = System.Windows.Forms.HorizontalAlignment.Right;
			// 
			// txt_hgrs2
			// 
			this.txt_hgrs2.BackColor = System.Drawing.SystemColors.Window;
			this.txt_hgrs2.Location = new System.Drawing.Point(72, 120);
			this.txt_hgrs2.Name = "txt_hgrs2";
			this.txt_hgrs2.ReadOnly = true;
			this.txt_hgrs2.Size = new System.Drawing.Size(32, 21);
			this.txt_hgrs2.TabIndex = 23;
			this.txt_hgrs2.Text = "";
			this.txt_hgrs2.TextAlign = System.Windows.Forms.HorizontalAlignment.Right;
			// 
			// txt_bmksrs2
			// 
			this.txt_bmksrs2.BackColor = System.Drawing.SystemColors.Window;
			this.txt_bmksrs2.Location = new System.Drawing.Point(72, 88);
			this.txt_bmksrs2.Name = "txt_bmksrs2";
			this.txt_bmksrs2.ReadOnly = true;
			this.txt_bmksrs2.Size = new System.Drawing.Size(32, 21);
			this.txt_bmksrs2.TabIndex = 21;
			this.txt_bmksrs2.Text = "";
			this.txt_bmksrs2.TextAlign = System.Windows.Forms.HorizontalAlignment.Right;
			// 
			// txt_kskm2
			// 
			this.txt_kskm2.BackColor = System.Drawing.SystemColors.Window;
			this.txt_kskm2.Location = new System.Drawing.Point(64, 24);
			this.txt_kskm2.Name = "txt_kskm2";
			this.txt_kskm2.ReadOnly = true;
			this.txt_kskm2.Size = new System.Drawing.Size(176, 21);
			this.txt_kskm2.TabIndex = 20;
			this.txt_kskm2.Text = "";
			// 
			// lbl_bhgrs2
			// 
			this.lbl_bhgrs2.Location = new System.Drawing.Point(8, 152);
			this.lbl_bhgrs2.Name = "lbl_bhgrs2";
			this.lbl_bhgrs2.Size = new System.Drawing.Size(72, 16);
			this.lbl_bhgrs2.TabIndex = 19;
			this.lbl_bhgrs2.Text = "不合格人数";
			// 
			// lbl_rs2
			// 
			this.lbl_rs2.Location = new System.Drawing.Point(72, 64);
			this.lbl_rs2.Name = "lbl_rs2";
			this.lbl_rs2.Size = new System.Drawing.Size(32, 16);
			this.lbl_rs2.TabIndex = 25;
			this.lbl_rs2.Text = "人数";
			// 
			// dtp_time
			// 
			this.dtp_time.Location = new System.Drawing.Point(368, 16);
			this.dtp_time.Name = "dtp_time";
			this.dtp_time.Size = new System.Drawing.Size(120, 21);
			this.dtp_time.TabIndex = 48;
			// 
			// Form_khcjcx
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(792, 573);
			this.Controls.Add(this.dtp_time);
			this.Controls.Add(this.chk_stat);
			this.Controls.Add(this.panel);
			this.Controls.Add(this.ridbtn_ndtj);
			this.Controls.Add(this.ridbtn_dktj);
			this.Controls.Add(this.btn_print);
			this.Controls.Add(this.btn_stat);
			this.Controls.Add(this.dg2);
			this.Controls.Add(this.lbl_ksrq);
			this.Controls.Add(this.cbo_nbkskm);
			this.Controls.Add(this.lbl_nbkskm);
			this.Controls.Add(this.grp_dktj);
			this.Controls.Add(this.grp_khcj);
			this.Controls.Add(this.grp_ndtj);
			this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;
			this.Name = "Form_khcjcx";
			this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
			this.Text = "Form_khcjcx";
			this.Load += new System.EventHandler(this.Form_khcjcx_Load);
			this.panel.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dg2)).EndInit();
			this.grp_dktj.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.Chart_dktj)).EndInit();
			this.grp_ndtj.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.Chart_ndtj)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

		private void chk_stat_CheckedChanged(object sender, System.EventArgs e)
		{
			if (chk_stat.Checked)
			{
				panel.Visible=false;
				ridbtn_dktj.Enabled=true;
				ridbtn_ndtj.Enabled=true;
				btn_stat.Visible=true;
				btn_print.Visible=true;
				dg2.Height=168;
				dg2.DataSource=null;
			}
			else
			{
				panel.Visible=true;
				ridbtn_dktj.Enabled=false;
				ridbtn_ndtj.Enabled=false;
				btn_stat.Visible=false;
				btn_print.Visible=false;
				ridbtn_dktj.Checked=false;
				ridbtn_ndtj.Checked=false;
				dg2.Height=424;
				dg2.DataSource=null;
			}
		}

		private void Form_khcjcx_Load(object sender, System.EventArgs e)
		{
			//连接数据库，选出数据，填充数据集
			SqlConnection conkskm = new SqlConnection();
			conkskm.ConnectionString=db.connStr;
			SqlCommand cmdkskm = new SqlCommand("select cou_name from Course,examInfo where examInfo.cou_no=Course.cou_no group by cou_name",conkskm);
			SqlDataAdapter adkskm = new SqlDataAdapter(cmdkskm);
			DataSet dskskm = new DataSet();
			adkskm.Fill(dskskm,"kskm");
			int i,j;
			j=dskskm.Tables[0].Rows.Count;
			string[] couname = new string[j];
			for(i=0;i<j;i++)
			{
				//填充cbo_nbkskm
				cbo_nbkskm.Items.Add(dskskm.Tables[0].Rows[i]["cou_name"].ToString());
			}
			//填充cbo_kscj
			cbo_kscj.Items.Add("0-59");
			cbo_kscj.Items.Add("60-69");
			cbo_kscj.Items.Add("70-79");
			cbo_kscj.Items.Add("80-89");
			cbo_kscj.Items.Add("90-100");
			dg2.Height=424;
			
		}

		private void ridbtn_dktj_CheckedChanged(object sender, System.EventArgs e)
		{
			if(ridbtn_dktj.Checked)
			{
				grp_dktj.Visible=true;
				grp_ndtj.Visible=false;
				btn_stat.Enabled=true;
				txt_kskm1.Text="";
				txt_bmksrs1.Text="";
				txt_hgrs1.Text="";
				txt_bhgrs1.Text="";
				txt_hgl1.Text="";
				Chart_dktj.Reset();
				dg2.DataSource=null;
			}
			else
			{
				grp_dktj.Visible=false;
				btn_stat.Enabled=false;
			}
		}

		private void ridbtn_ndtj_CheckedChanged(object sender, System.EventArgs e)
		{
			if(ridbtn_ndtj.Checked)
			{
				grp_dktj.Visible=false;
				grp_ndtj.Visible=true;
				btn_stat.Enabled=true;
				txt_kskm2.Text="";
				txt_bmksrs2.Text="";
				txt_hgrs2.Text="";
				txt_bhgrs2.Text="";
				txt_hgl2.Text="";
				Chart_ndtj.Reset();
				dg2.DataSource=null;
			}
			else
			{
				grp_ndtj.Visible=false;
				btn_stat.Enabled=false;
			}
		}

		private void btn_stat_Click(object sender, System.EventArgs e)
		{
			try
			{
				SqlConnection contj = new SqlConnection();
				contj.ConnectionString=db.connStr;
				if(cbo_nbkskm.Text=="")
				{
					MessageBox.Show("请选择考试科目。");
				}
				else
				{

					if(ridbtn_dktj.Checked)
					{	
						Chart_dktj.Reset();
						SqlCommand cmddktj = new SqlCommand("select  examInfo.stu_id 学号,stu_name 姓名,stu_identityNo 身份证号, cou_name 考试科目,exaI_examTime 考试时间,exaI_score 考试成绩 from Course,examInfo,Student where examInfo.cou_no=Course.cou_no and examInfo.stu_id=Student.stu_id and Course.cou_name='"+cbo_nbkskm.Text+"' and examInfo.exaI_examTime='"+dtp_time.Value.Date+"' and exaI_score is not null",contj);
						SqlDataAdapter addktj = new SqlDataAdapter(cmddktj);
						DataSet dsdktj = new DataSet();
						addktj.Fill(dsdktj);
						int j;
						j=dsdktj.Tables[0].Rows.Count;
						float[] fs=new float [j];
						int i=0;
						foreach(DataRow dr in dsdktj.Tables[0].Rows)
						{
							fs[i]=float.Parse(dr["考试成绩"].ToString());
							i++;
						}
						int m=0,n=0;
						for(i=0;i<j;i++)
						{
							if(fs[i]<60)
							{
								m++;
							}
							else
							{
								n++;
							}
						}
						ChartGroup grp = Chart_dktj.ChartGroups[0];
						grp.ChartType = Chart2DTypeEnum.Pie;
						ChartData dat = grp.ChartData;
						dat.SeriesList.Clear();
						int [] SliceValue=new int[]{n,m};
						Color [] ColorValue = new Color []{Color.LightGreen,Color.Red};
						for(int slice=0; slice < SliceValue.Length; slice++)