📄 frmsubject.cs
字号:
new System.Data.Common.DataColumnMapping("学分", "学分")})});
this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT 课程编号, 课程名称, 课程简称, 拼音码, 本学期课程, 教师, 开课系别, 学分 FROM 课程信息";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = "INSERT INTO 课程信息(课程编号, 课程名称, 课程简称, 拼音码, 本学期课程, 教师, 开课系别, 学分) VALUES (@课程编号, @课程名称" +
", @课程简称, @拼音码, @本学期课程, @教师, @开课系别, @学分); SELECT 课程编号, 课程名称, 课程简称, 拼音码, 本学期课程, 教师" +
", 开课系别, 学分 FROM 课程信息 WHERE (课程编号 = @课程编号)";
this.sqlInsertCommand1.Connection = this.sqlConnection1;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@课程编号", System.Data.SqlDbType.Int, 4, "课程编号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@课程名称", System.Data.SqlDbType.VarChar, 40, "课程名称"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@课程简称", System.Data.SqlDbType.VarChar, 40, "课程简称"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@拼音码", System.Data.SqlDbType.VarChar, 6, "拼音码"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@本学期课程", System.Data.SqlDbType.VarChar, 2, "本学期课程"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@教师", System.Data.SqlDbType.VarChar, 10, "教师"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@开课系别", System.Data.SqlDbType.VarChar, 30, "开课系别"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@学分", System.Data.SqlDbType.Int, 4, "学分"));
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = @"UPDATE 课程信息 SET 课程编号 = @课程编号, 课程名称 = @课程名称, 课程简称 = @课程简称, 拼音码 = @拼音码, 本学期课程 = @本学期课程, 教师 = @教师, 开课系别 = @开课系别, 学分 = @学分 WHERE (课程编号 = @Original_课程编号) AND (学分 = @Original_学分 OR @Original_学分 IS NULL AND 学分 IS NULL) AND (开课系别 = @Original_开课系别 OR @Original_开课系别 IS NULL AND 开课系别 IS NULL) AND (拼音码 = @Original_拼音码 OR @Original_拼音码 IS NULL AND 拼音码 IS NULL) AND (教师 = @Original_教师 OR @Original_教师 IS NULL AND 教师 IS NULL) AND (本学期课程 = @Original_本学期课程) AND (课程名称 = @Original_课程名称) AND (课程简称 = @Original_课程简称); SELECT 课程编号, 课程名称, 课程简称, 拼音码, 本学期课程, 教师, 开课系别, 学分 FROM 课程信息 WHERE (课程编号 = @课程编号)";
this.sqlUpdateCommand1.Connection = this.sqlConnection1;
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@课程编号", System.Data.SqlDbType.Int, 4, "课程编号"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@课程名称", System.Data.SqlDbType.VarChar, 40, "课程名称"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@课程简称", System.Data.SqlDbType.VarChar, 40, "课程简称"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@拼音码", System.Data.SqlDbType.VarChar, 6, "拼音码"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@本学期课程", System.Data.SqlDbType.VarChar, 2, "本学期课程"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@教师", System.Data.SqlDbType.VarChar, 10, "教师"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@开课系别", System.Data.SqlDbType.VarChar, 30, "开课系别"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@学分", System.Data.SqlDbType.Int, 4, "学分"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_课程编号", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "课程编号", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_学分", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "学分", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_开课系别", System.Data.SqlDbType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "开课系别", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_拼音码", System.Data.SqlDbType.VarChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "拼音码", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_教师", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "教师", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_本学期课程", System.Data.SqlDbType.VarChar, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "本学期课程", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_课程名称", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "课程名称", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_课程简称", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "课程简称", System.Data.DataRowVersion.Original, null));
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = @"DELETE FROM 课程信息 WHERE (课程编号 = @Original_课程编号) AND (学分 = @Original_学分 OR @Original_学分 IS NULL AND 学分 IS NULL) AND (开课系别 = @Original_开课系别 OR @Original_开课系别 IS NULL AND 开课系别 IS NULL) AND (拼音码 = @Original_拼音码 OR @Original_拼音码 IS NULL AND 拼音码 IS NULL) AND (教师 = @Original_教师 OR @Original_教师 IS NULL AND 教师 IS NULL) AND (本学期课程 = @Original_本学期课程) AND (课程名称 = @Original_课程名称) AND (课程简称 = @Original_课程简称)";
this.sqlDeleteCommand1.Connection = this.sqlConnection1;
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_课程编号", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "课程编号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_学分", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "学分", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_开课系别", System.Data.SqlDbType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "开课系别", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_拼音码", System.Data.SqlDbType.VarChar, 6, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "拼音码", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_教师", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "教师", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_本学期课程", System.Data.SqlDbType.VarChar, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "本学期课程", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_课程名称", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "课程名称", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_课程简称", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "课程简称", System.Data.DataRowVersion.Original, null));
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=VIEWSONIC;packet size=4096;integrated security=SSPI;data source=VI" +
"EWSONIC;persist security info=False;initial catalog=eisbook";
//
// dataSet11
//
this.dataSet11.DataSetName = "DataSet1";
this.dataSet11.Locale = new System.Globalization.CultureInfo("zh-CN");
//
// frmSubject
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(600, 341);
this.Controls.Add(this.GroupBox1);
this.Name = "frmSubject";
this.Controls.SetChildIndex(this.dgdList, 0);
this.Controls.SetChildIndex(this.GroupBox1, 0);
((System.ComponentModel.ISupportInitialize)(this.dgdList)).EndInit();
this.GroupBox1.ResumeLayout(false);
this.GroupBox2.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
this.ResumeLayout(false);
} #endregion 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() );
}
}
public override void SetTextBoxState(bool bState)
{
GroupBox1.Enabled = !bState;
}
public override void SaveForAdd()
{
DataRow dr = dataSet11.Tables[ "课程信息" ].NewRow();
try
{
dr[ "课程编号" ] = txbCourseId.Text.Trim();
dr[ "课程名称" ] = txbCourseName.Text.Trim();
dr[ "课程简称" ] = txbCourseSName.Text.Trim();
dr[ "拼音码" ] = txbPY.Text.Trim();
dr[ "教师" ] = txbTeacher.Text.Trim();
dr[ "开课系别" ] = txbDept.Text.Trim();
dr[ "学分" ] = txbCreditHour.Text.Trim();
dr[ "本学期课程" ] = cbbSubject.SelectedValue;
}
catch ( Exception ex )
{
MessageBox.Show( "数据格式不正确！" );
return;
}
try
{
dataSet11.Tables[ "课程信息" ].Rows.Add( dr );
if ( dataSet11.HasChanges( ))
sqlDataAdapter1.Update( dataSet11 );
}
catch ( Exception ex )
{
MessageBox.Show( "数据添加失败！" );
}
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 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();
}
public override void Prepare()
{
this.Text = "课程信息维护";
Label1.Text = "课程编号";
Label2.Text = "课程名称";
Label3.Text = "拼音码";
DataTable dtTemp = new DataTable();
dtTemp.Columns.Add( "display" );
dtTemp.Columns.Add( "value" );
DataRow dr = dtTemp.NewRow();
dr[ 0 ] = "是";
dr[ 1 ] = "Y";
dtTemp.Rows.Add( dr );
dr[ 0 ] = "否";
dr[ 1 ] = "N";
dtTemp.Rows.Add( dr );
cbbSubject.DataSource = dtTemp.DefaultView;
cbbSubject.DisplayMember = "display";
cbbSubject.ValueMember = "value";
}
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 '";
strFilter += txbOne.Text.Trim() + "%'";
if ( txbTwo.Text.Trim().Length != 0 )
{
strFilter += " and 课程名称 like '";
strFilter += txbTwo.Text.Trim() + "%'";
if ( txbThree.Text.Trim().Length != 0 )
{
strFilter += " and 拼音码 like '";
strFilter += txbThree.Text.Trim() + "%'";
}
}
}
dataSet11.Clear();
sqlConnection1.ConnectionString = DataBase.sConn;
string strSQL;
sqlDataAdapter1.SelectCommand.CommandText = "select * from 课程信息 " + strFilter;
sqlDataAdapter1.Fill( dataSet11 );
dtData = dataSet11.Tables[ "课程信息" ];
bmData = this.BindingContext[ dataSet11, "课程信息" ];
if ( bmData.Count != 0 )
bmData.Position = 0;
}
public override void Clear()
{
txbCourseId.Text = "";
txbCourseName.Text = "";
txbCourseSName.Text = "";
txbCreditHour.Text = "";
txbDept.Text = "";
txbPY.Text = "";
txbTeacher.Text = "";
}
}}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -