frmcourse.cs

简单的学生成绩管理系统。实现学生成绩学号管理

using System;
using System.Collections;
using System.ComponentModel;
using System.Drawing;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
using Microsoft.VisualBasic;

namespace 教务管理系统
{
	public class frmCourse : 教务管理系统.frmBase
	{
		private System.ComponentModel.IContainer components = null;
		private DataTable dtList;

		public frmCourse()
		{
			// 该调用是 Windows 窗体设计器所必需的。
			InitializeComponent();

			// TODO: 在 InitializeComponent 调用后添加任何初始化
		}

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

		#region 设计器生成的代码
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			// 
			// txbOne
			// 
			this.txbOne.Name = "txbOne";
			this.txbOne.KeyDown += new System.Windows.Forms.KeyEventHandler(this.txbOne_KeyDown);
			// 
			// frmCourse
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(600, 341);
			this.Name = "frmCourse";

		}
		#endregion

		public override void SetDataGrid()
		{
			LoadData();
			// 定义一个DataGrid表样式
			DataGridTableStyle ts = new DataGridTableStyle();
			DataGridTextBoxColumn aCol;
			int numCols = dtData.Columns.Count;
			for ( int i = 0; i < numCols; i ++ )
			{
				aCol = new DataGridTextBoxColumn();
				aCol.MappingName = dtData.Columns[ i ].ColumnName;
				aCol.HeaderText = dtData.Columns[ i ].ColumnName;
				aCol.NullText = "";
				aCol.ReadOnly = true;
				ts.GridColumnStyles.Add( aCol );
			}
			ts.PreferredRowHeight = 30;
			ts.AlternatingBackColor = Color.LightGray;
			ts.AllowSorting = false;
			ts.MappingName = dtData.TableName;
			dgdList.TableStyles.Clear();
			dgdList.TableStyles.Add( ts );
			DataView dv = dtData.DefaultView;
			dv.AllowNew = false;
			dv.AllowDelete = false;
			dgdList.DataSource = dv;
		}

		public override void Prepare()
		{
			this.Text = "课程查询";
			dgdList.Dock = DockStyle.Fill;
			ToolBar1.Visible = false;
			Label1.Text = "学号";
			Label2.Text = "姓名";
			Label3.Text = "班级";
			txbTwo.ReadOnly = true;
			txbThree.ReadOnly = true;
			InitDataTable();
		}

		private void InitDataTable()
		{
			dtList = new DataTable();
			dtList.Columns.Add( "星期一" );
			dtList.Columns.Add( "星期二" );
			dtList.Columns.Add( "星期三" );
			dtList.Columns.Add( "星期四" );
			dtList.Columns.Add( "星期五" );
			DataRow dr;
			for ( int i = 0; i <= 9; i ++ )
			{
				dr = dtList.NewRow();
				dtList.Rows.Add( dr );
			}
		}

		private void txbOne_KeyDown(object sender, System.Windows.Forms.KeyEventArgs e)
		{
			if ( e.KeyCode == Keys.Enter )
				SetDataGrid();
		}

		public override void LoadData()
		{
			string strFilter = "";
			if ( txbOne.Text.Trim().Length == 0 )
			{
				return;
			}
			else
			{
				strFilter = "and 学号='" + txbOne.Text.Trim() + "'";
			}
			DataBase db = new DataBase();
			string strSQL = "select 姓名, 班级名称 from 学生信息 as a, 班级信息 as b where a.班级编号=b.班级编号 and 学号='" + txbOne.Text.Trim() + "'";
			DataView dv = db.RunSelectSQL( strSQL );
			if ( dv.Count == 0 )
			{
				MessageBox.Show( "学号错误" );
				return;
			}
			txbTwo.Text = dv[ 0 ][ 0 ].ToString().Trim();
			txbThree.Text = dv[ 0 ][ 1 ].ToString().Trim();
			strSQL = "select b.课程名称,a.上课时间天,a.上课时间节,a.上课地点 from 选课表 as c, 课程表 as a, 课程信息 as b where a.课程编号=b.课程编号 and c.课序号=a.课序号";
			dtData = db.RunSelectSQL(strSQL + strFilter + " order by a.课序号 ").Table;
			db.Dispose();
			for ( int j = 0; j <= 4; j ++ )
			{
				for( int i = 0; i <= 9; i ++ )
				{
					dtList.Rows[ i ][ j ] = "";
				}
			}
			int col, line;
			for ( int i = 0; i <= dtData.Rows.Count; i ++ )
			{
				col = Int32.Parse( dtData.Rows[ i ][ 1 ].ToString() ) - 1;
				line = Int32.Parse( dtData.Rows[ i ][ 2 ].ToString() ) - 1;
				dtList.Rows[ line ][ col ] = dtData.Rows[ i ][ 0 ].ToString().Trim() +
					"\n" + dtData.Rows[ i ][ 3 ].ToString().Trim();
			}
		}
	}
}