//获取教师员工
public DataTable ShowTeacher()
{
string SqlString = "Select TeaNum AS 工号,TeaName AS 姓名,TeaSex AS 性别, TeaAdress AS 联系地址,TeaPhone AS 联系电话,TeaTitle AS 职称,TeaProField AS 专业方向 From dbo.Teacher";
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
DataTable ObjDataTable = objDataBase.GetDataSet(SqlString).Tables[0];
return (ObjDataTable);
}
//返回查找结果：
public DataTable SearchTea(TeacherModel objTeacherModel)
{
string SqlString = "Select TeaNum AS 工号,TeaName AS 姓名,TeaSex AS 性别, TeaAdress AS 联系地址,TeaPhone AS 联系电话,TeaTitle AS 职称,TeaProField AS 专业方向 From dbo.Teacher Where TeaNum='"+objTeacherModel.TeaNum+"'";
DataBaseOperaClass objDataBaseOperaClass=new DataBaseOperaClass();
DataTable objDataTable = objDataBaseOperaClass.GetDataSet(SqlString).Tables[0];
return (objDataTable);
}
public DataTable ShowSchoolInfo()
{
string SqlString = "Select SchNum AS 学校代码, SchName AS 校区 From School";
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
DataTable objDataTalbe = objDataBase.GetDataSet(SqlString).Tables[0];
return (objDataTalbe);
}
//查找教师员工
public bool SearchTeacher(TeacherModel objTeacherModel)
{
string SqlString = "SELECT *FROM Teacher where TeaName='" + objTeacherModel.TeaName + "'";
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
if (objDataBase.GetDataSet(SqlString ).Tables[0].Rows.Count >0)
return (true);
else
return (false);
}
//查找班级信息
public bool SearchClass(ClassModel objClassModel)
{
string Sqlstring = "select * from Class where ClaNum ='" + objClassModel.ClaNum+ "'";
DataBaseOperaClass objDataBaseOperaClass = new DataBaseOperaClass();
if (objDataBaseOperaClass.GetDataSet(Sqlstring).Tables[0].Rows.Count > 0)
return (true);
else
return (false);
}
//获取所有课程：
public DataTable ShowCourse()
{
string SqlString = "select CourseNum as 课程号,CourseName as 课程名称,Credit AS 学分,ProOrPub as 范围,NeedOrOpt AS 类型 ,Course.DeptNum AS 系编号, Department.DeptName as 系别 from Course join Department on Course.DeptNum=Department.DeptNum order by CourseNum desc";
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
DataTable objDataTable = objDataBase.GetDataSet(SqlString).Tables[0];
return (objDataTable);
}
public DataTable ShowTableSelCourse()
{
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();
DataTable objDataTalbe = objDataBase.GetDataSet(SqlString).Tables[0];
return (objDataTalbe);
}
public DataTable ShowDepartment()
{
string SqlString = "select DeptNum AS 系别号,DeptName AS 系别名,department.SchNum AS 校区号,School.SchName AS 学校名称 from dbo.Department join School on Department.SchNum=School.SchNum";
DataBaseOperaClass objDataBase = new DataBaseOperaClass();
DataTable objDataTalbe = objDataBase.GetDataSet(SqlString).Tables[0];
return (objDataTalbe);
}
