scoreanalyse.cs

c#写图书管理系统 界面美观 功能齐全 配有完整的数据库

				{
					if(this.conn1.State==ConnectionState.Closed)this.conn1.Open();						
					this.commandStr="select Course from SelectCourse where Class='"+this.comboClass.Text+"' and Semester='"+this.comboSemester.Text+"'";
					this.Command1.CommandText=this.commandStr;
					this.DataReader1=this.Command1.ExecuteReader();
					while(this.DataReader1.Read())
					{
						this.comboCourse.Items.Add(this.DataReader1["Course"].ToString());
					
					}
					this.DataReader1.Close();								

				}

				catch(Exception E)
				{
					MessageBox.Show(E.ToString());
				}
				finally
				{
					this.conn1.Close();			
				}				
			
			}

		private void btnExit_Click(object sender, System.EventArgs e)
		{
			this.Close();
		}

		private void button1_Click(object sender, System.EventArgs e)
		{
			double AverageMark;
			double MaxMark=0;
			double MinMark=100;
			double sum=0;
			double score;


			for(int i=0;i<this.DataSetScore.Tables[0].Rows.Count;i++)
			{
				score=Convert.ToDouble(this.DataSetScore.Tables[0].Rows[i]["Score"]);
				if(MaxMark<score)MaxMark=score;
				if(MinMark>score)MinMark=score;				
				sum+=score;
			}

			AverageMark=sum/(Convert.ToDouble(this.DataSetScore.Tables[0].Rows.Count));	
		
			ListViewItem li = new ListViewItem ( ) ;
			li.SubItems.Clear ( ) ;
			li.SubItems[0].Text ="平均分";			
			li.SubItems.Add (AverageMark.ToString()) ;
			this.listView1.Items.Add ( li ) ;

			ListViewItem li2 = new ListViewItem ( ) ;
			li2.SubItems.Clear ( ) ;
			li2.SubItems[0].Text ="最高分";			
			li2.SubItems.Add (MaxMark.ToString()) ;
			this.listView1.Items.Add ( li2 ) ;
			
			ListViewItem li3 = new ListViewItem ( ) ;
			li3.SubItems.Clear ( ) ;
			li3.SubItems[0].Text ="最低分";			
			li3.SubItems.Add (MinMark.ToString()) ;
			this.listView1.Items.Add ( li3 ) ;

		}

		private void checkBox1_CheckedChanged(object sender, System.EventArgs e)
		{
			if(this.checkBox1.Checked)
			{
				this.chart1.ChartAreas["Default"].Area3DStyle.Enable3D = true;
				this.numericUpDown1.Enabled=true;
				this.numericUpDown2.Enabled=true;

			}
			else
			{
				this.chart1.ChartAreas["Default"].Area3DStyle.Enable3D = false;
				this.numericUpDown1.Enabled=false;
				this.numericUpDown2.Enabled=false;
			}


		}

		private void comboBoxChartType_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			string selectSeries=this.comboBoxChartType.Text;
			int j=this.chart1.Series.Count;
			switch(selectSeries)
			{
				case "line":
					for(int m=0;m<j;m++)
					{
						this.chart1.Series[m].ChartType="Line";
						this.chart1.Refresh();
					}
					break;
				case "Column":
					for(int m=0;m<j;m++)
					{
						this.chart1.Series[m].ChartType="Column";
						this.chart1.Refresh();
					}
					break;
				case "Spline":
					for(int m=0;m<j;m++)
					{
						this.chart1.Series[m].ChartType="Spline";
						this.chart1.Refresh();
					}
					break;
				case "StepLine":
					for(int m=0;m<j;m++)
					{
						this.chart1.Series[m].ChartType="StepLine";
						this.chart1.Refresh();
					}
					break;
				case "Pie":
					for(int m=0;m<j;m++)
					{
						this.chart1.Series[m].ChartType="Pie";
						this.chart1.Refresh();
					}
					break;
				case "Doughnut":
					for(int m=0;m<j;m++)
					{
						this.chart1.Series[m].ChartType="Doughnut";
						this.chart1.Refresh();
					}
					break;
			}					
			
		}

		private void BackColorCom_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			chart1.ChartAreas["Default"].BackColor = Color.FromName(BackColorCom.GetItemText(BackColorCom.SelectedItem));
		}

		private void ForeColorCom_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			chart1.ChartAreas["Default"].BackGradientEndColor = Color.FromName(ForeColorCom.GetItemText(ForeColorCom.SelectedItem));
		
		}

		private void HatchStyle_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			if( HatchStyle.SelectedItem != null )
				chart1.BackHatchStyle = (ChartHatchStyle)ChartHatchStyle.Parse(typeof(ChartHatchStyle), HatchStyle.GetItemText(HatchStyle.SelectedItem));		
		
		}

		private void Gradient_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			if( Gradient.SelectedItem != null )
				chart1.BackGradientType = (GradientType)GradientType.Parse(typeof(GradientType), Gradient.GetItemText(Gradient.SelectedItem));
		}

		private void BorderColor_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			chart1.BorderColor = Color.FromName(BorderColor.GetItemText(BorderColor.SelectedItem));
		
		}

		private void BorderSizeCom_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			if( BorderSizeCom.SelectedItem != null )
				chart1.BorderWidth = int.Parse(BorderSizeCom.GetItemText(BorderSizeCom.SelectedItem));
		
		}

		private void BorderStyle_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			if( BorderStyle.SelectedItem != null )
				chart1.BorderStyle = (ChartDashStyle)ChartDashStyle.Parse(typeof(ChartDashStyle), BorderStyle.GetItemText(BorderStyle.SelectedItem));
		
		}

		private void numericUpDown1_ValueChanged(object sender, System.EventArgs e)
		{
			if(this.numericUpDown1.Value==180)
			{
				this.numericUpDown1.Value=-180;
			}
			if(this.numericUpDown1.Value==-180)
			{
				this.numericUpDown1.Value=180;
			}			
			this.chart1.ChartAreas["Default"].Area3DStyle.XAngle=Convert.ToInt16(this.numericUpDown1.Value);
		}

		private void numericUpDown2_ValueChanged(object sender, System.EventArgs e)
		{
			this.chart1.ChartAreas["Default"].Area3DStyle.YAngle=Convert.ToInt16(this.numericUpDown2.Value);
		}

		private void button8_Click(object sender, System.EventArgs e)
		{
			Series series = this.chart1.Series.Add("Grade");
			series.ChartArea = "Default";
			series.ChartType = "Line";
			series.BorderWidth = 2;			
			series.ShowLabelAsValue=true;
			series.MarkerStyle=MarkerStyle.Square;
			series.MarkerSize=7;
			series.MarkerColor=Color.Red;
			series.Color=Color.Red;
			this.Yvalue_Caculate();
			this.chart1.Series["Grade"].Points.DataBindXY(Xvalue,Yvalue);
		
		}
		
		private void Yvalue_Caculate()
		{
			for(int i=0;i<4;i++)
				Yvalue[i]=0;
			for(int i=0;i<this.DataSetScore.Tables[0].Rows.Count;i++)
			{
				double score=Convert.ToDouble(this.DataSetScore.Tables[0].Rows[i]["Score"]);
				if(score<60)Yvalue[0]++;
				if((60<=score)&(score<70))Yvalue[1]++;
				if((70<=score)&(score<85))Yvalue[2]++;
				if(85<=score)Yvalue[3]++;				
			}

		}

		private void tabControl1_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			if(this.tabControl1.SelectedIndex==2)
			{
				foreach(string colorName in Enum.GetNames(typeof(ChartHatchStyle)))
				{
					HatchStyle.Items.Add(colorName);
				}
		
				// Add Chart Gradient types to control.
				foreach(string colorName in Enum.GetNames(typeof(GradientType)))
				{
					Gradient.Items.Add(colorName);
				}

				// Add Chart Line styles to control.
				foreach(string colorName in Enum.GetNames(typeof(ChartDashStyle)))
				{
					BorderStyle.Items.Add(colorName);
				}				

			}
		}

		private void btnList_Click(object sender, System.EventArgs e)
		{
			double AverageMark;
			double MaxMark=0;
			double MinMark=100;
			double sum=0;
			double score;


			for(int i=0;i<this.DataSetScore.Tables[0].Rows.Count;i++)
			{
				score=Convert.ToDouble(this.DataSetScore.Tables[0].Rows[i]["Score"]);
				if(MaxMark<score)MaxMark=score;
				if(MinMark>score)MinMark=score;				
				sum+=score;
			}

			AverageMark=sum/(Convert.ToDouble(this.DataSetScore.Tables[0].Rows.Count));	
		
			ListViewItem li = new ListViewItem ( ) ;
			li.SubItems.Clear ( ) ;
			li.SubItems[0].Text ="平均分";			
			li.SubItems.Add (AverageMark.ToString()) ;
			this.listView1.Items.Add ( li ) ;

			ListViewItem li2 = new ListViewItem ( ) ;
			li2.SubItems.Clear ( ) ;
			li2.SubItems[0].Text ="最高分";			
			li2.SubItems.Add (MaxMark.ToString()) ;
			this.listView1.Items.Add ( li2 ) ;
			
			ListViewItem li3 = new ListViewItem ( ) ;
			li3.SubItems.Clear ( ) ;
			li3.SubItems[0].Text ="最低分";			
			li3.SubItems.Add (MinMark.ToString()) ;
			this.listView1.Items.Add ( li3 ) ;
		
		}

		private void btnChart_Click(object sender, System.EventArgs e)
		{
			if(this.chart1.Series.Count==0)
			{
				Series series = this.chart1.Series.Add("Grade");			
				series.ChartArea = "Default";
				series.ChartType = "Line";
				series.BorderWidth = 2;			
				series.ShowLabelAsValue=true;
				series.MarkerStyle=MarkerStyle.Square;
				series.MarkerSize=7;
				series.MarkerColor=Color.Red;
				series.Color=Color.Red;
			}
			this.Yvalue_Caculate();
			this.chart1.Series["Grade"].Points.DataBindXY(Xvalue,Yvalue);
		
		}

		



		}

	}