//刷新网格:★改为按当前登录用户来显示选课信息: private void ShowCurrentLoginUserInfo() { #region 使用SQL语句刷新表格的方法,已注释。改到三层架构的数据访问层了。 // string SqlString = "select Student.StuNum AS 学号,Class.ClaName AS 班级,StuName AS 姓名,Course.CourseName AS 所选课程,SelCourse.CourseNum AS 课程编号,Credit AS 学分,Score AS 成绩 from Student join Class on Student.ClaNum=Class.ClaNum join SelCourse on Student.StuNum=SelCourse.StuNum join Course on SelCourse.CourseNum=Course.CourseNum"; // DataBaseOperaClass objDataBase = new DataBaseOperaClass(); // dgvSelCourse.DataSource = objDataBase.ShowTable(SqlString); // #endregion //SelCourseBLL objSelCourseBLL = new SelCourseBLL(); //dgvSelCourse.DataSource = objSelCourseBLL.ShowSelCourse(); #region 按学号查找已经选课的学生的选课信息: //★★进行查找前,先清空表格内容: cbxCourseNum.Text = ""; dgvSelCourse.DataSource = 0; SelCourseBLL objSelCourseBLLClass = new SelCourseBLL(); SelCourseModel objSelCourseModel = new SelCourseModel(); objSelCourseModel.StuNum = txtStuNum.Text; dgvSelCourse.DataSource = objSelCourseBLLClass.CheckStuSeletCourseResult(objSelCourseModel); #endregion }
//查找 private void btnSearch_Click(object sender, EventArgs e) { #region 按学号查找已经选课的学生 //★★进行查找前,先清空表格内容: cbxCourseNum.Text = ""; dgvSelCourse.DataSource = 0; SelCourseBLL objSelCourseBLLClass = new SelCourseBLL(); SelCourseModel objSelCourseModel = new SelCourseModel(); objSelCourseModel.StuNum = cbxStuNum.Text; objSelCourseModel.CourseName = cbxCourseName.Text; if (objSelCourseBLLClass.SearchSeledCourseStu(objSelCourseModel) == true) { MessageBox.Show("数据已找到!\n请查阅!!"); dgvSelCourse.DataSource = objSelCourseBLLClass.CheckStuSeletCourseResult(objSelCourseModel); } //▲▲▲数据查找到后,怎样接收到数据表格中?★★要在逻辑层、数据访问层定义一个返回类型为:DataTable的方法吗?怎样定义? //已经定义了了返回类型为bool的方法。那么应该用方法重载实现么?上面这样写好不好? // dgvSelCourse.DataSource=objSelCourseBLLClass.SearchSeledCourseStu(); else { MessageBox.Show("查找完毕,没有找到相关数据。\n请检查搜索条件!\n 该学生可能还没进行选课!"); } #endregion }
//查找: private void btnSearch_Click(object sender, EventArgs e) { #region 按学号查找已经选课的学生的选课信息: //★★进行查找前,先清空表格内容: cbxCourseNum.Text = ""; dgvSelCourse.DataSource = 0; SelCourseBLL objSelCourseBLLClass = new SelCourseBLL(); SelCourseModel objSelCourseModel = new SelCourseModel(); objSelCourseModel.StuNum = txtStuNum.Text; dgvSelCourse.DataSource = objSelCourseBLLClass.CheckStuSeletCourseResult(objSelCourseModel); #endregion }