/// <summary> /// 获取院校列表 /// </summary> /// <param name="auth">授权人员</param> /// <returns>院校信息列表</returns> public static Department[] GetDepartments(School school, Authentication auth) { if (auth.CheckAllows("departments", Permission.SELECT)) { List<Department> departments = new List<Department>(); String SQL = @"SELECT TOP 1000 * FROM [dbo].[departments] WHERE [schoolid] = {0};"; SQL = String.Format(SQL, school.ID); SqlCommand cmd = new SqlCommand(SQL, auth.Connection); using (SqlDataReader data = cmd.ExecuteReader()) { while (data.Read()) { departments.Add(new Department(data)); } } return departments.ToArray(); } return new Department[0]; }
public Major(String name, Department Parent, School school) { ID = -1; Name = name; ParentSchoolID = Parent.ParentSchoolID; ParentDepartmentID = Parent.ID; ParentDepartment = Parent.Name; ParentSchool = school.Name; }
/// <summary> /// 获取指定院校下的专业列表 /// </summary> /// <param name="school">所属院校</param> /// <param name="auth">授权人员</param> /// <returns>指定院校下的专业列表</returns> public static Major[] GetMajor(School school, Authentication auth) { if (auth.CheckAllows("MajorView", Permission.SELECT)) { List<Major> majors = new List<Major>(); String SQL = @"SELECT * FROM [dbo].[MajorView] WHERE [schoolid] = {0};"; SQL = String.Format(SQL, school.ID); SqlCommand cmd = new SqlCommand(SQL, auth.Connection); using (SqlDataReader data = cmd.ExecuteReader()) { while (data.Read()) { majors.Add(new Major(data)); } } return majors.ToArray(); } return new Major[0]; }
/// <summary> /// 通过编号查找院校 /// </summary> /// <param name="id">要查找的院校ID</param> /// <param name="auth">授权人员</param> /// <exception cref="NoPermissionException">NoPermissionException</exception> /// <returns>查找到的院校实例,或者没有找到时返回默认实例。</returns> public static School Search(Int32 id, Authentication auth) { if (auth.CheckAllows("schools", Permission.SELECT)) { String SQL = @"SELECT TOP 1 * FROM [dbo].[schools] WHERE [schoolid] = {0};"; SQL = String.Format(SQL, id); SqlCommand cmd = new SqlCommand(SQL, auth.Connection); SqlDataReader data = cmd.ExecuteReader(); School s = null; if (data.Read()) { s = new School(data); } else { s = new School(); } data.Close(); return s; } throw new NoPermissionException(); }