public DataTable ShowProfession() { string SqlString = "select ProNum AS 专业号,ProName AS 专业名,Profession.deptNum AS 系别号,Department.DeptName as 系部名称 from dbo.Profession join Department on Profession.deptNum=Department.DeptNum"; DataBaseOperaClass objDataBase = new DataBaseOperaClass(); DataTable objDataTable = objDataBase.ShowTable(SqlString); return (objDataTable); }
public DataTable ShowStuInfo() { string SqlString = "Select * From V_Student_All_Info"; DataBaseOperaClass objDataBase = new DataBaseOperaClass(); DataTable objDataTable = objDataBase.ShowTable(SqlString); return (objDataTable); }
//获取所有班级信息 public DataTable ShowTeaching() { string Sqlstring = "Select TeaName AS 教师姓名,Semester AS 学期,CourseName AS 授课名称 From Teacher,Teaching,Course Where Teacher.TeaNum=Teaching.TeaNum and Course.CourseNum=Teaching.CourseNum"; DataBaseOperaClass objDataBase = new DataBaseOperaClass(); DataTable objDataTable = objDataBase.ShowTable(Sqlstring); return (objDataTable); }
//任务14 //获取所有班级信息 public DataTable ShowClass() { //string Sqlstring = "select ClaNum AS 班级号,ClaName AS 班级名,DeptNum AS 系别编号,ProNum AS 专业编号 from dbo.Class"; string SqlString = "Select * From V_ClassInfo"; DataBaseOperaClass objDataBase = new DataBaseOperaClass(); DataTable objDataTable = objDataBase.ShowTable(SqlString); return (objDataTable); }
//获取表格数据给下拉字段使用: public string[] GetSchNum() { string SqlString = "Select SchNum AS 学校代码, SchName AS 校区 From School"; DataBaseOperaClass objDataBase = new DataBaseOperaClass(); DataTable objTable = objDataBase.ShowTable(SqlString); string[] SchNum = new string[objTable.Rows.Count]; for (int i = 0; i < objTable.Rows.Count; i++) SchNum[i] = objTable.Rows[i][0].ToString(); return (SchNum); }