/// <summary>
/// 根据题目ID获取题目信息
/// </summary>
/// <param name="titleID">题目ID</param>
/// <returns></returns>
public Title GetTiByTitleID(int titleID)
{
TeacherService teacherService = new TeacherService();
string sql = string.Format("SELECT * FROM Title WHERE TitleID={0}", titleID);
Title title = new Title();
int teacherID = 0;
title.Student = null;
SqlDataReader reader = DBHelper.GetReader(sql);
if (reader.Read())
{
title.TitleID = Convert.ToInt32(reader["TitleID"]);
title.TitleName = reader["TitleName"].ToString();
title.Counts = Convert.ToInt32(reader["Counts"]);
title.State = Convert.ToInt32(reader["State"]);
title.HasChooseNum = Convert.ToInt32(reader["HasChooseNum"]);
try
{
teacherID = Convert.ToInt32(reader["TeacherID"]);
}
catch (Exception)
{
}
title.Description = reader["Description"].ToString();
reader.Close();
title.Teacher = teacherService.GetTeacherByID(teacherID);
}
reader.Close();
return(title);
}
/// <summary>
/// 获取题目列表
/// </summary>
/// <param name="teacherID">教师登录（工号）ID</param>
/// <returns></returns>
public List <Title> GetTitleListByTeacherId(int teacherID)
{
StudentService studentService = new StudentService();
string sql = string.Format("SELECT * FROM Title WHERE TeacherID={0}", teacherID);
TeacherService teacherService = new TeacherService();
List <Title> list = new List <Title>();
int teacherId = 0;
int studentId = 0;
DataTable table = DBHelper.GetDataSet(sql);
foreach (DataRow rows in table.Rows)
{
Title title = new Title();
title.TitleID = Convert.ToInt32(rows["TitleID"]);
title.Counts = Convert.ToInt32(rows["Counts"]);
title.TitleName = rows["TitleName"].ToString();
title.State = Convert.ToInt32(rows["State"]);
title.HasChooseNum = Convert.ToInt32(rows["HasChooseNum"]);
title.Description = rows["Description"].ToString();
try
{
teacherId = Convert.ToInt32(rows["TeacherID"]);
}
catch (Exception)
{
}
try
{
studentId = Convert.ToInt32(rows["StudentID"]);
}
catch (Exception)
{
}
title.Teacher = teacherService.GetTeacherByID(teacherId);
title.Student = studentService.GetStudentBySID(studentId);
list.Add(title);
}
return(list);
}