frmstudent.cs

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

		public override void LoadData()
		{
			string strFilter;
			if ( txbOne.Text.Trim().Length == 0 )
			{
				if ( txbTwo.Text.Trim().Length == 0 )
				{
					if ( txbThree.Text.Trim().Length == 0 )
						strFilter = "";
					else
					{
						strFilter = "where 年级 like '";
						strFilter += txbThree.Text.Trim() + "%'";
					}
				}
				else
				{
					strFilter = "where 姓名 like '";
					strFilter += txbTwo.Text.Trim() + "%'";
					if ( txbThree.Text.Trim().Length != 0 )
					{
						strFilter += " and 年级 like '";
						strFilter += txbThree.Text.Trim() + "%'";
					}
				}
			}
			else
			{
				strFilter = "where 学号 like '" + txbOne.Text.Trim() + "%'";
				if ( txbTwo.Text.Trim().Length != 0 )
				{
					strFilter += " and 姓名 like '" + txbTwo.Text.Trim() + "%'";
					if ( txbThree.Text.Trim().Length != 0 )
						strFilter += " and 年级 like '" + txbThree.Text.Trim() + "%'";
				}
				else
				{
					if ( txbThree.Text.Trim().Length != 0 )
						strFilter += " and 年级 like '" + txbThree.Text.Trim() + "%'";
				}
			}
			dataSet11.Clear();
			sqlConnection1.ConnectionString = DataBase.sConn;
			// string strSQL;
			sqlDataAdapter1.SelectCommand.CommandText = "select * from 学生信息 " + strFilter;
			// 根据查询条件重新填充dataSet11
			sqlDataAdapter1.Fill( dataSet11 );
			dtData = dataSet11.Tables[ "学生信息" ];
			if ( dtData.Columns.Count < 15 )
			{
				dtData.Columns.Add( "班级" );
				dtData.Columns.Add( "政治面貌" );
				dtData.Columns.Add( "民族" );
				dtData.Columns.Add( "籍贯" );
				dtData.Columns.Add( "学籍" );
			}
			bmData = this.BindingContext[ dataSet11, "学生信息" ];
			if ( bmData.Count != 0 )
				bmData.Position = 0;
		}

		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.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;
			bmData = this.BindingContext[ dataSet11, "学生信息" ];
			lblCount.Text = "记录数： " + dtData.Rows.Count.ToString();
			SetDetailData();
		}

		private void SetDetailData()
		{
			DataTable dtClassId, dtPolity, dtNation, dtBirthPlace, dtStatus;
			DataBase db = new DataBase();
			dtClassId = db.RunSelectSQL( "select 班级编号,班级名称 from 班级信息 order by 班级名称" ).Table;
			dtPolity = db.RunSelectSQL( "select 政治面貌编号,政治面貌 from 政治面貌代码表" ).Table;
			dtNation = db.RunSelectSQL( "select 民族编号,民族 from 民族代码表" ).Table;
			dtBirthPlace = db.RunSelectSQL( "select 籍贯编号,籍贯 from 籍贯代码表" ).Table;
			dtStatus = db.RunSelectSQL( "select 学籍编号,学籍名称 from 学籍代码表" ).Table;
			DataView dv;
			for ( int i = 0; i < dtData.Rows.Count; i ++ )
			{
				dv = dtClassId.DefaultView;
				dv.RowFilter = "班级编号='" + dtData.Rows[ i ][ "班级编号" ] + "'";
				dtData.Rows[ i ][ "班级" ] = dv[ 0 ][ 1 ];
				dv = dtPolity.DefaultView;
				dv.RowFilter = "政治面貌编号='" + dtData.Rows[ i ][ "政治面脑编号" ] + "'";
				dtData.Rows[ i ][ "政治面貌" ] = dv[ 0 ][ 1 ];
				dv = dtNation.DefaultView;
				dv.RowFilter = "民族编号='" + dtData.Rows[ i ][ "民族编号" ] + "'";
				dtData.Rows[ i ][ "民族" ] = dv[ 0 ][ 1 ];
				dv = dtBirthPlace.DefaultView;
				dv.RowFilter = "籍贯编号='" + dtData.Rows[ i ][ "籍贯编号" ] + "'";
				dtData.Rows[ i ][ "籍贯" ] = dv[ 0 ][ 1 ];
				dv = dtStatus.DefaultView;
				dv.RowFilter = "学籍编号='" + dtData.Rows[ i ][ "学籍编号" ] + "'";
				dtData.Rows[ i ][ "学籍" ] = dv[ 0 ][ 1 ];
			}
		}

		public override void SetTextBoxState(bool bState)
		{
			this.GroupBox1.Enabled = !bState;
		}

		public override void Clear()
		{
			this.txbClassId.Text = "";
			this.txbGrade.Text = "";
			this.txbName.Text = "";
			this.cbbBirthPlace.Text = "";
			this.cbbClassId.Text = "";
			this.cbbNation.Text = "";
			this.cbbPolity.Text = "";
			this.cbbSex.Text = "";
			this.cbbStatus.Text = "";
		}

		public override void SaveForAdd()
		{
			DataRow dr = dataSet11.Tables[ "学生信息" ].NewRow();
			try
			{
				dr[ "学号" ] = this.txbClassId.Text.Trim();
				dr[ "姓名" ] = this.txbName.Text.Trim();
				dr[ "年级" ] = this.txbGrade.Text.Trim();
				dr[ "性别" ] = this.cbbSex.Text.Trim();
				dr[ "年级" ] = this.txbGrade.Text.Trim();
				dr[ "身份证号" ] = this.txbPID.Text.Trim();
				dr[ "政治面貌编号" ] = this.cbbPolity.SelectedValue;
				dr[ "民族编号" ] = this.cbbNation.SelectedValue;
				dr[ "籍贯编号" ] = this.cbbBirthPlace.SelectedValue;
				dr[ "班级编号" ] = this.cbbClassId.SelectedValue;
				dr[ "学籍编号" ] = this.cbbStatus.SelectedValue;
			}
			catch( Exception ex )
			{
				MessageBox.Show( "数据格式不正确！" + ex.ToString() );
				return;
			}
			try
			{
				dataSet11.Tables[ "学生信息" ].Rows.Add( dr );
				if ( dataSet11.HasChanges() )
				{
					sqlDataAdapter1.Update( dataSet11 );
				}
			}
			catch ( Exception ex )
			{
				MessageBox.Show( ex.ToString() );
			}
			LoadData();
			dgdList.DataSource = dtData.DefaultView;
		}

		public override void DeleteData()
		{
			try
			{
				// 删除当前行的数据
				dataSet11.Tables[ "学生信息" ].Rows[ bmData.Position ].Delete();
				if ( dataSet11.HasChanges() )
				{
					sqlDataAdapter1.Update( dataSet11 );
				}
			}
			catch ( Exception ex )
			{
				MessageBox.Show( "数据删除失败!" + ex.ToString() );
			}
		}

		public override void SaveForUpdate()
		{
			try
			{
				int row = dgdList.CurrentCell.RowNumber;
				dgdList.CurrentCell = new DataGridCell( ( row + 1 ) % bmData.Count, 0 );
				// 判断是否有更新的数据
				if ( dataSet11.HasChanges() )
					sqlDataAdapter1.Update( dataSet11 );
			}
			catch ( Exception ex )
			{
				MessageBox.Show( "数据修改失败!" + ex.ToString() );
			}
		}


	}
}