//更新数据网格的显示
public void UpdateDataGrid()
{
DataAccess.Classes objClass = new DataAccess.Classes(_className);
DataSet objDataSet = objClass.FillByAllCourse();
this._dgvCourse.DataSource = objDataSet.Tables[0];
}
private void cboClassName_SelectedIndexChanged(object sender, EventArgs e)
{
DataAccess.Classes objClass = DataAccess.Classes.CreateInstance(this.cboClassName.SelectedItem.ToString());
if (objClass != null)
{
this.txtDirector.Text = objClass.Director;
this.dtpCreateDate.Value = objClass.EntranceDate;
this.txtRemark.Text = objClass.Remark;
}
}
//添加课程
public void Add(string subjectName, string teacher, DateTime beginDate, DateTime finishDate, string remark)
{
DataAccess.Classes objClass = new DataAccess.Classes(_className);
if (objClass.GetDataReaderBySubjectName(subjectName).HasRows)
{
MessageBox.Show("该班已有课程" + subjectName + "，请重新输入！", "课程已存在", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (DataAccess.Course.Add(_className, subjectName, teacher, beginDate, finishDate, remark) > 0)
{
UpdateDataGrid();
MessageBox.Show("成功添加课程！", "操作成功", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("添加课程失败！", "操作失败", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
public int FillCboByAllStudentNo(ComboBox cbo, int studentNo, string className)
{
cbo.Items.Clear();
int position = 0;
int i = 0;
DataAccess.Classes objClass = new DataAccess.Classes(className);
DataTable studentNos = objClass.GetAllStudentNo();
foreach (DataRow row in studentNos.Rows)
{
int stuNo = Int32.Parse(row[0].ToString());
cbo.Items.Add(stuNo);
if (stuNo == studentNo)
{
position = i;
}
i++;
}
cbo.SelectedIndex = position;
return(position);
}
