//更新数据网格的显示 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); }