browsescore.cs

C#编写的学籍管理系统

			this.listView1.Location = new System.Drawing.Point(21, 126);
			this.listView1.Name = "listView1";
			this.listView1.Size = new System.Drawing.Size(352, 327);
			this.listView1.SmallImageList = this.imageList1;
			this.listView1.StateImageList = this.imageList1;
			this.listView1.TabIndex = 42;
			this.listView1.SelectedIndexChanged += new System.EventHandler(this.listView1_SelectedIndexChanged);
			// 
			// button3
			// 
			this.button3.Location = new System.Drawing.Point(565, 432);
			this.button3.Name = "button3";
			this.button3.Size = new System.Drawing.Size(100, 30);
			this.button3.TabIndex = 43;
			this.button3.Text = "删除成绩";
			this.button3.Click += new System.EventHandler(this.button3_Click);
			// 
			// BrowseScore
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(8, 18);
			this.ClientSize = new System.Drawing.Size(853, 471);
			this.Controls.Add(this.button3);
			this.Controls.Add(this.listView1);
			this.Controls.Add(this.dataGrid1);
			this.Controls.Add(this.button2);
			this.Controls.Add(this.button1);
			this.Controls.Add(this.label6);
			this.Controls.Add(this.label5);
			this.Controls.Add(this.groupBox1);
			this.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedDialog;
			this.Name = "BrowseScore";
			this.Text = "浏览学生成绩";
			this.Load += new System.EventHandler(this.BrowseScore_Load);
			this.groupBox1.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

		private void BrowseScore_Load(object sender, System.EventArgs e)
		{
			oleDbConnection1.Open();
			string sql="select specialtyid,specialtyname from specialtyinfo";
			OleDbDataAdapter adp=new OleDbDataAdapter(sql,oleDbConnection1);
			
			DataSet ds=new DataSet();
			adp.Fill(ds,"specialty");
			comboBox1.DataSource=ds.Tables["specialty"].DefaultView;
			comboBox1.DisplayMember="specialtyname";
			comboBox1.ValueMember="specialtyid";

			textBox1.Text=System.DateTime.Now.Year.ToString().Trim();
		}

		private void comboBox1_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			textBox1.Clear();
			comboBox2.DataSource=null;
			comboBox2.SelectedIndex=-1;
		}

		public bool strisyear(string s)
		{
			if (s.Trim().Length!=4)
				return (false);
			else
			{
				int n=1;
				for (int i=0;i<=s.Length-1;i++)
				{
					if (!System.Char.IsNumber(s[i]))
					{
						n=-1;
						break;
					}
				}
				if (n==1)
					return (true);
				else
					return (false);
			}
		}

		private void textBox1_TextChanged(object sender, System.EventArgs e)
		{
			if (textBox1.Text.Trim()!="" && textBox1.Text.Trim().Length==4 && strisyear(textBox1.Text.Trim()))
			{
				string sql="select classid,classname from classinfo where specialtyname='"+comboBox1.Text.ToString()+"' and year(enrolmenttime)="+textBox1.Text.ToString();
				OleDbDataAdapter adp=new OleDbDataAdapter(sql,oleDbConnection1);
				DataSet ds=new DataSet();
				ds.Clear();
				adp.Fill(ds,"class");
				if (ds.Tables["class"].Rows.Count!=0)
				{
					comboBox2.DisplayMember="classname";
					comboBox2.ValueMember="classid";
					comboBox2.DataSource=ds.Tables[0].DefaultView;
				}
				else
				{
				    comboBox2.DataSource=null;
					comboBox2.SelectedIndex=-1;
				}
				// comboBox2.Items.Clear();
				// OleDbDataReader dr;
				// OleDbCommand cmd=new OleDbCommand(sql,oleDbConnection1);
				//dr=cmd.ExecuteReader();
				//while (dr.Read())
				//{
				//    comboBox2.Items.Add(dr.GetString(1).ToString());
				// }
			}
			else
			{
				comboBox2.DataSource=null;
				comboBox2.SelectedIndex=-1;
			}
		}

		private void textBox1_Leave(object sender, System.EventArgs e)
		{
			if (!strisyear(textBox1.Text.Trim()))
			{
				MessageBox.Show("请输入合法的入学年份","错误提示");
				textBox1.Text=System.DateTime.Now.Year.ToString().Trim();
				comboBox2.DataSource=null;
			}
		}

		private void comboBox2_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			dataGrid1.DataSource=null;
			dataGrid1.CaptionText="";
			if (comboBox2.DataSource!=null)
			{
				
				OleDbConnection cn1=new OleDbConnection("Data Source=xsxxdb.mdb;Jet OLEDB:Engine Type=5;Provider=Microsoft.Jet.OLEDB.4.0");
				cn1.Open();
				string sql="select year(enrolmenttime) from classinfo where classid="+comboBox2.SelectedValue;
				OleDbCommand cmd=new OleDbCommand(sql,cn1);
				int rxnf=Int32.Parse(cmd.ExecuteScalar().ToString());
				
				sql="select length from classinfo where classid="+comboBox2.SelectedValue.ToString().Trim();
				cmd.CommandText=sql;
				int nianzhi=Int32.Parse(cmd.ExecuteScalar().ToString());
				
				int nf=rxnf;
				comboBox3.Items.Clear();
				for (int i=1;i<=nianzhi*2;i++)
				{
					comboBox3.Items.Add(nf+""+((i+1)%2+1));
			   
					if (i%2==0) nf++;
				}
				listView1.Items.Clear();
				cmd.CommandText="select studentnumber,name from studentinfo where classid="+comboBox2.SelectedValue+" order by studentnumber asc";
				OleDbDataReader dr=cmd.ExecuteReader();
				while (dr.Read())
				{
					ListViewItem item1=new ListViewItem();
					item1.Text=dr.GetString(1)+"("+dr.GetString(0)+")";
					item1.Tag=dr.GetString(0);
					item1.ImageIndex=0;
					listView1.Items.Add(item1);
				}
				cn1.Close();
			}
			else 
			{
				listView1.Items.Clear();
				comboBox3.Items.Clear();
				comboBox3.SelectedIndex=-1;
			}

		}

		private void comboBox2_TextChanged(object sender, System.EventArgs e)
		{

		}

		private void comboBox3_SelectedIndexChanged(object sender, System.EventArgs e)
		{
				dataGrid1.DataSource=null;
		}
        DataSet ds;
		private void listView1_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			string xuehao=listView1.Items[listView1.FocusedItem.Index].Tag.ToString().Trim();
			string xq=comboBox3.Text.Trim();
			if (xq!="")
			{
				//string sql="select id as 编号,xuehao as 学号,kecheng as 课程,cj as 成绩 from cjxx where xuehao='"+xuehao+"' and xq='"+xq+"'";
				string sql="select scoreid as 自动编号,a1.course as 课程,b1.score as 成绩,'已录入' as 状态 from (select * from courseinfo where classid=(select studentinfo.classid from studentinfo where studentnumber='"+xuehao+"') and semester='"+xq+"') as a1 left join (select * from scoreinfo where studentnumber='"+xuehao+"' and semester='"+xq+"') as b1 on a1.course=b1.course";
				OleDbDataAdapter adp=new OleDbDataAdapter(sql,oleDbConnection1);
				ds=new DataSet();
				adp.Fill(ds,"score");
				if (ds.Tables["score"].Rows.Count!=0)
				{
				    dataGrid1.DataSource=ds.Tables["score"].DefaultView;
					dataGrid1.CaptionText=listView1.Items[listView1.FocusedItem.Index].Text.Trim()+"同学的成绩如下";
					for (int i=0;i<=ds.Tables["score"].Rows.Count-1;i++)
					{
						if (ds.Tables["score"].Rows[i][0].ToString()=="")
							dataGrid1[i,0]=0;
						if (ds.Tables["score"].Rows[i][2].ToString()=="")
						{
							dataGrid1[i,2]=0;
							dataGrid1[i,3]="等待录入";
						}
					}
				}
				else
				{
					dataGrid1.DataSource=null;
					dataGrid1.CaptionText="暂时无成绩信息";
				}
			}
			else
			{
				MessageBox.Show("请选定一个学期","提示");
			}
		}
       
		private void button1_Click(object sender, System.EventArgs e)
		{
			if (dataGrid1.DataSource!=null && ds.Tables["score"].Rows[dataGrid1.CurrentCell.RowNumber][0].ToString().Trim()!="0")
			{
				ModifyScore modifyscore=new ModifyScore();
				modifyscore.Tag=ds.Tables["score"].Rows[dataGrid1.CurrentCell.RowNumber][0].ToString().Trim();
				modifyscore.label1.Text=ds.Tables["score"].Rows[dataGrid1.CurrentCell.RowNumber][1].ToString().Trim();
				modifyscore.textBox1.Text=ds.Tables["score"].Rows[dataGrid1.CurrentCell.RowNumber][2].ToString().Trim();
				modifyscore.ShowDialog();
			}
			else
				MessageBox.Show("此成绩尚未录入，不能修改");
		}

		private void button3_Click(object sender, System.EventArgs e)
		{
			if (dataGrid1.DataSource!=null && ds.Tables["score"].Rows[dataGrid1.CurrentCell.RowNumber][0].ToString().Trim()!="0")
			{
				if ("0"!=ds.Tables["score"].Rows[dataGrid1.CurrentCell.RowNumber][0].ToString().Trim())
				{
					string sql="delete * from scoreinfo where scoreid="+ds.Tables["score"].Rows[dataGrid1.CurrentCell.RowNumber][0].ToString().Trim();
					OleDbCommand cmd=new OleDbCommand(sql,oleDbConnection1);
					cmd.ExecuteNonQuery();
					MessageBox.Show("成绩'"+ds.Tables["score"].Rows[dataGrid1.CurrentCell.RowNumber][1].ToString().Trim()+":("+ds.Tables["score"].Rows[dataGrid1.CurrentCell.RowNumber][2].ToString().Trim()+")'删除成功");
				}
				else
                   MessageBox.Show("此成绩尚未录入，不能删除");
			}
			else
				MessageBox.Show("此成绩尚未录入，不能删除");
		}
	}
}