//获取教师员工 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); }