frmeditscore.cs

一个学籍管理系统 以在某高校投入使用了

			this.btnCancle.TabIndex = 5;
			this.btnCancle.Text = "取消";
			this.btnCancle.Click += new System.EventHandler(this.btnCancle_Click);
			// 
			// frmEditScore
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(1028, 669);
			this.Controls.Add(this.btnCancle);
			this.Controls.Add(this.bbtnDel);
			this.Controls.Add(this.btnEdit);
			this.Controls.Add(this.groupBox3);
			this.Controls.Add(this.groupBox2);
			this.Controls.Add(this.groupBox1);
			this.Name = "frmEditScore";
			this.Text = "浏览学生成绩";
			this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
			this.Load += new System.EventHandler(this.frmEditScore_Load);
			this.groupBox1.ResumeLayout(false);
			this.groupBox2.ResumeLayout(false);
			this.groupBox3.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

		private void frmEditScore_Load(object sender, System.EventArgs e)
		{
			setDataGridStyle();
			string Sql = "select * from Class..SpecialtyInfo";
			if(c.IsExits(Sql)==true)
			{
				string tableName = "SpecialtyInfo";
				this.cboSpec.DataSource=da.ExecuteDataTable(Sql,tableName);
				this.cboSpec.DisplayMember="SpecialtyName";
				this.cboSpec.SelectedIndex=0;
			}
			else
			{
				this.cboSpec.Items.Add("尚未添加专业");
				this.cboSpec.SelectedIndex=0;
			}
		}

		
		private void setDataGridStyle()
		{
			DataGridTableStyle dgs = new DataGridTableStyle();
			dgs.MappingName="ScoreInfo";
			this.dataGrid1.TableStyles.Add(dgs);

			DataGridColumnStyle dgs1 = new DataGridTextBoxColumn();
			dgs1.HeaderText="自动编号";
			dgs1.MappingName="ScoreID";
			dgs1.Width=100;
			
			DataGridColumnStyle dgs2 = new DataGridTextBoxColumn();
			dgs2.HeaderText="课程";
			dgs2.MappingName="Course";
			dgs2.Width=100;

			DataGridColumnStyle dgs3 = new DataGridTextBoxColumn();
			dgs3.HeaderText="成绩";
			dgs3.MappingName="Score";
			dgs3.Width=100;

			DataGridColumnStyle dgs4 = new DataGridTextBoxColumn();
			dgs4.HeaderText="状态";
			dgs4.MappingName="State";
			dgs4.Width=100;

			
			dgs.GridColumnStyles.Add(dgs1);
			dgs.GridColumnStyles.Add(dgs2);
			dgs.GridColumnStyles.Add(dgs3);
			dgs.GridColumnStyles.Add(dgs4);
			

		}

		/// <summary>
		/// 向学生的ListView添加数据
		/// </summary>
		private void AddListStu()
		{
			this.listView1.Items.Clear();
			string Sql1 = "select * from Class..StudentInfo where ClassID = (select ClassID from Class..ClassInfo where ClassName = '"+this.cboClass.Text+"')";
			ArrayList name = new ArrayList();
			ArrayList Number = new ArrayList();
			name=c.getDatas(Sql1,2);
			Number = c.getDatas(Sql1,1);

			for(int i = 0; i<name.Count;i++)
			{
				ListViewItem item1 = new ListViewItem();
				item1.Text=name[i]+"("+Number[i]+")";
				item1.Tag=Number[i];
				item1.ImageIndex=0;
				this.listView1.Items.Add(item1);
			}
		}
		/// <summary>
		/// 为学期附值
		/// </summary>
		private void getSeme(int year,int length)
		{
			for(int i=0;i<length;i++)
			{
				for(int j=1;j<=2;j++)
				{
					int Year =year+i; 
					this.cboSeme.Items.Add(Year.ToString()+j.ToString());
				}
			}
		}

		/// <summary>
		/// 添加班级信息
		/// </summary>
		private void AddClass()
		{
			
			string Sql = "select * from Class..ClassInfo where SpecialtyName = '"+this.cboSpec.Text+"' and year(BeginTime)='"+this.txtYear.Text+"'";
			if(c.IsExits(Sql)==true)
			{
				this.cboSeme.Items.Clear();
				string table = "ClassInfo";
				this.cboClass.DataSource=da.ExecuteDataTable(Sql,table);
				this.cboClass.DisplayMember="ClassName";
				this.cboClass.ValueMember="ClassID";
				this.cboClass.SelectedIndex=0;
				string Year=c.getData(Sql,4);
				this.getSeme(int.Parse(this.txtYear.Text),int.Parse(Year));
				this.cboSeme.SelectedIndex=0;
			}
			else
			{
				this.cboClass.DataSource=null;
				this.cboSeme.Items.Clear();
				this.cboClass.Items.Add("未找到相应班级");
				this.cboSeme.Items.Add("请输入班级信息");
				this.cboClass.SelectedIndex=0;
				this.cboSeme.SelectedIndex=0;
			}
		}
		private void txtYear_TextChanged(object sender, System.EventArgs e)
		{
			if(c.IsYear(this.txtYear.Text)==true&&this.txtYear.Text.Length==4)
			{
				AddClass();
			}
		}

		private void cboSpec_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			AddClass();
		}

		private void cboClass_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			AddListStu();
		}

		private void AddDataGrid()
		{
			string name = this.listView1.Items[this.listView1.FocusedItem.Index].Text;
			string number = this.listView1.Items[this.listView1.FocusedItem.Index].Tag.ToString();
			string Sql = "Select * from Class..ScoreInfo where Semester = '"+this.cboSeme.Text
				+"' and StudentNumber = '"+this.listView1.Items[this.listView1.FocusedItem.Index].Tag.ToString()+"'";
			string table="ScoreInfo";
			this.dataGrid1.DataSource=da.ExecuteDataTable(Sql,table);
			this.dataGrid1.CaptionText=name+"同学的成绩如下";
			dt=(DataTable)this.dataGrid1.DataSource;
		}
		private void listView1_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			AddDataGrid();
		}

		private void bbtnDel_Click(object sender, System.EventArgs e)
		{
			if(this.ScoreID=="")
			{
				MessageBox.Show("请选择要删除的成绩!","提示信息!",MessageBoxButtons.OK,MessageBoxIcon.Question);
			}
			else
			{
				if(MessageBox.Show("确认删除!","提示信息!",MessageBoxButtons.OKCancel,MessageBoxIcon.Question,MessageBoxDefaultButton.Button2)==DialogResult.OK)
				{
					string Sql = "update Class..ScoreInfo set Score = 0,State = '等待录入' where ScoreID = "+this.ScoreID+"";
					c.EditData(Sql);
					AddDataGrid();
				}
			}
		}

		private void dataGrid1_CurrentCellChanged(object sender, EventArgs e)
		{
			if(this.dataGrid1.VisibleRowCount>0)
			{
				this.ScoreID = this.dt.Rows[this.dataGrid1.CurrentRowIndex][0].ToString();
			}
		}

		private void dataGrid1_GotFocus(object sender, EventArgs e)
		{
			if(this.dataGrid1.VisibleRowCount>0)
			{
				this.ScoreID = this.dt.Rows[this.dataGrid1.CurrentRowIndex][0].ToString();
			}
		}

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

		private void btnEdit_Click(object sender, System.EventArgs e)
		{
			if(this.ScoreID=="")
			{
				MessageBox.Show("请选择要修改的成绩!","提示信息!",MessageBoxButtons.OK,MessageBoxIcon.Question);
			}
			else if(this.dt.Rows[this.dataGrid1.CurrentRowIndex][5].ToString()=="等待录入")
			{
				MessageBox.Show("该成绩尚未录入，不能修改!","提示信息!",MessageBoxButtons.OK,MessageBoxIcon.Question);
			}
			else
			{
				string Course = this.dt.Rows[this.dataGrid1.CurrentRowIndex][3].ToString();
				string Score = this.dt.Rows[this.dataGrid1.CurrentRowIndex][4].ToString();
				
				frmUpdateScore f = new frmUpdateScore(Course,Score,this.ScoreID);
				f.UpdateEvent+=new UpdateHandler(f_UpdateEvent);
				f.ShowDialog();
			}
		}

		private void f_UpdateEvent()
		{
			AddDataGrid();
		}
	}
}