/// <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();
}
