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="depart">所属院系</param>
/// <param name="auth">授权人员</param>
/// <returns>指定院系下的专业列表</returns>
public static Major[] GetMajor(Department depart, Authentication auth)
{
if (auth.CheckAllows("MajorView", Permission.SELECT))
{
List<Major> majors = new List<Major>();
String SQL = @"SELECT * FROM [dbo].[MajorView] WHERE [departid] = {0};";
SQL = String.Format(SQL, depart.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>
/// 通过ID查找院系
/// </summary>
/// <param name="id">院系ID</param>
/// <param name="auth">授权人员</param>
/// <returns>查找到的院系实例或者查找失败返回默认实例</returns>
public static Department Search(Int32 id, Authentication auth)
{
if (auth.CheckAllows("departments", 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);
Department s = null;
using (SqlDataReader data = cmd.ExecuteReader())
{
if (data.Read())
{
s = new Department(data);
}
else
{
s = new Department();
}
}
return s;
}
throw new NoPermissionException();
}