//刷新网格：★改为按当前登录用户来显示选课信息：
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
}
