/// <summary>
/// 获取管理员信息
/// </summary>
/// <param name="loginID">管理员登录账号（ID）</param>
/// <returns>管理员信息</returns>
public Admin GetAdminByID(string loginID)
{
int roleID = 0;
string sql = string.Format("SELECT * FROM Admin WHERE LoginID='{0}'", loginID);
Admin admin = new Admin();
try
{
SqlDataReader reader = DBHelper.GetReader(sql);
if (reader.Read())
{
admin.AID = Convert.ToInt32(reader["AID"]);
admin.LoginID = reader["LoginID"].ToString();
admin.LoginPass = reader["LoginPass"].ToString();
roleID = Convert.ToInt32(reader["ARID"]);
reader.Close();
admin.UserRole = UserRoleService.GetUserRoleByUID(roleID);
}
reader.Close();
}
catch (Exception)
{
throw;
}
return(admin);
}
/// <summary>
/// 根据学生登录（学号）ID获取学生信息
/// </summary>
/// <param name="studentID">学生登录（学号）ID</param>
/// <returns>学生信息</returns>
public Student GetStudentByStudentID(string studentID)
{
int userRoleID = 0; //用户角色ID
int titleID = 0; //题目ID
string sql = string.Format("SELECT * FROM Student WHERE StudentID ='{0}'", studentID);
SqlDataReader reader = DBHelper.GetReader(sql);
if (reader.Read())
{
student.SID = Convert.ToInt32(reader["SID"]);
student.StudentAddress = reader["StudentAddress"].ToString();
student.StudentClass = reader["StudentClass"].ToString();
student.StudentMail = reader["StudentMail"].ToString();
student.StudentName = reader["StudentName"].ToString();
student.SudentState = Convert.ToInt32(reader["SudentState"]);
student.StudentID = reader["StudentID"].ToString();
student.StudentPass = reader["StudentPass"].ToString();
student.StudentPhone = reader["StudentPhone"].ToString();
userRoleID = Convert.ToInt32(reader["SRID"]);
try
{
titleID = Convert.ToInt32(reader["STitleID"]);
}
catch (Exception)
{ }
reader.Close();
student.Role = UserRoleService.GetUserRoleByUID(userRoleID);
student.Title = titleServer.GetTiByTitleID(titleID);
}
reader.Close();
return(student);
}
/// <summary>
/// 获取上传自定义题目的学生
/// </summary>
/// <returns>上传自定义题目的学生信息</returns>
public List <Student> GetStudentByUpLoadTitle()
{
List <Student> list = new List <Student>();
int userRoleID = 0; //用户角色ID
int titleID = 0; //题目ID
string sql = string.Format("SELECT * FROM Student WHERE SID IN (SELECT StudentID FROM Title GROUP BY StudentID)");
DataTable table = DBHelper.GetDataSet(sql);
foreach (DataRow rows in table.Rows)
{
Student student = new Student();
student.SID = Convert.ToInt32(rows["SID"]);
student.StudentAddress = rows["StudentAddress"].ToString();
student.StudentClass = rows["StudentClass"].ToString();
student.StudentMail = rows["StudentMail"].ToString();
student.StudentName = rows["StudentName"].ToString();
student.SudentState = Convert.ToInt32(rows["SudentState"]);
student.StudentID = rows["StudentID"].ToString();
student.StudentPass = rows["StudentPass"].ToString();
student.StudentPhone = rows["StudentPhone"].ToString();
userRoleID = Convert.ToInt32(rows["SRID"]);
try
{
titleID = Convert.ToInt32(rows["STitleID"]);
}
catch (Exception)
{
}
student.Role = UserRoleService.GetUserRoleByUID(userRoleID);
student.Title = titleServer.GetTiByTitleID(titleID);
list.Add(student);
}
return(list);
}
/// <summary>
/// 根据教师登录（工号）ID获取教师信息
/// </summary>
/// <param name="teacherID">教师登录（工号）ID</param>
/// <returns>教师信息</returns>
public Teacher GetTeacherByTeacherID(string teacherID)
{
string sql = string.Format("SELECT * FROM Teacher WHERE TeacherID='{0}'", teacherID);
SqlDataReader reader = DBHelper.GetReader(sql);
Teacher teacher = new Teacher();
int roleId = 0;
if (reader.Read())
{
teacher.TEID = Convert.ToInt32(reader["TEID"]);
teacher.TeacherID = reader["TeacherID"].ToString();
teacher.TeacherName = reader["TeacherName"].ToString();
teacher.TeacherAddress = reader["TeacherAddress"].ToString();
teacher.TeacherMail = reader["TeacherMail"].ToString();
teacher.TeacherPass = reader["TeacherPass"].ToString();
teacher.TeacherPhone = reader["TeacherPhone"].ToString();
teacher.TeacherState = Convert.ToInt32(reader["TeacherState"]);
roleId = Convert.ToInt32(reader["TRID"]);
reader.Close();
teacher.UserRole = UserRoleService.GetUserRoleByUID(roleId);
}
reader.Close();
return(teacher);
}
/// <summary>
/// 查询已上传标题的教师
/// </summary>
/// <returns></returns>
public List <Teacher> GetTeacherHasUpLoadTitle()
{
string sql = string.Format("SELECT * FROM Teacher WHERE TEID IN (SELECT TeacherID FROM Title GROUP BY TeacherID)");
DataTable table = DBHelper.GetDataSet(sql);
List <Teacher> list = new List <Teacher>();
int roleId = 0;
foreach (DataRow row in table.Rows)
{
Teacher teacher = new Teacher();
teacher.TEID = Convert.ToInt32(row["TEID"]);
teacher.TeacherID = row["TeacherID"].ToString();
teacher.TeacherName = row["TeacherName"].ToString();
teacher.TeacherAddress = row["TeacherAddress"].ToString();
teacher.TeacherMail = row["TeacherMail"].ToString();
teacher.TeacherPass = row["TeacherPass"].ToString();
teacher.TeacherPhone = row["TeacherPhone"].ToString();
teacher.TeacherState = Convert.ToInt32(row["TeacherState"]);
roleId = Convert.ToInt32(row["TRID"]);
teacher.UserRole = UserRoleService.GetUserRoleByUID(roleId);
list.Add(teacher);
}
return(list);
}
/// <summary>
/// 获取所有教师
/// </summary>
/// <returns></returns>
public List <Teacher> GetTeacherList()
{
List <Teacher> list = new List <Teacher>();
string sql = string.Format("SELECT * FROM Teacher");
DataTable table = DBHelper.GetDataSet(sql);
int roleID = 0;
foreach (DataRow rows in table.Rows)
{
Teacher teacher = new Teacher();
teacher.TEID = Convert.ToInt32(rows["TEID"]);
teacher.TeacherID = rows["TeacherID"].ToString();
teacher.TeacherName = rows["TeacherName"].ToString();
teacher.TeacherAddress = rows["TeacherAddress"].ToString();
teacher.TeacherMail = rows["TeacherMail"].ToString();
teacher.TeacherPass = rows["TeacherPass"].ToString();
teacher.TeacherPhone = rows["TeacherPhone"].ToString();
teacher.TeacherState = Convert.ToInt32(rows["TeacherState"]);
roleID = Convert.ToInt32(rows["TRID"]);
teacher.UserRole = UserRoleService.GetUserRoleByUID(roleID);
list.Add(teacher);
}
return(list);
}
