/// <summary>
/// 查询指定年份所有通过审核的论题
/// </summary>
/// <param name="procName">存储过程名</param>
/// <param name="year">需要指定的年份</param>
/// <returns></returns>
public List <PassExamineThesis> QueryAllPassExamineThesis(string procName, int year)
{
SqlParameter yearParameter = new SqlParameter("@year", year);
CommomQuery <PassExamineThesis> query = new CommomQuery <PassExamineThesis>();
return(query.ProcedureQueryToList(procName, new SqlParameter[] { yearParameter },
new PassExamineThesisRowMapper()));
}
/// <summary>
/// 查询指定年份教师拟定的论题
/// </summary>
/// <param name="teacherid"></param>
/// <param name="year"></param>
/// <returns></returns>
public List <PartOfThesisInfo> QueryAllThesisOfTeacher(string teacherid, int year)
{
SqlParameter yearParameter = new SqlParameter("@year", year);
SqlParameter tidParameter = new SqlParameter("@tid", teacherid);
CommomQuery <PartOfThesisInfo> query = new CommomQuery <PartOfThesisInfo>();
return(query.ProcedureQueryToList("QueryAllOfThesisDrawByTeacher",
new SqlParameter[] { yearParameter, tidParameter }, new PartOfThesisRowMapper()));
}
public List <StudentMakeThesis> QueryStudentMakeThesisInfo(string teacherid, int year)
{
SqlParameter statusParameter = new SqlParameter("@whether_make_topic", "是");
SqlParameter teacheridParameter = new SqlParameter("@teacher_id", teacherid);
SqlParameter using_year = new SqlParameter("@using_year", year);
CommomQuery <StudentMakeThesis> query = new CommomQuery <StudentMakeThesis>();
return(query.ProcedureQueryToList("QueryStudentMakeThesisInfo", new SqlParameter[]
{ statusParameter, teacheridParameter, using_year }, new StudentMakeThesisRowMapper()));
}
/// <summary>
/// 查询选了指导老师非自拟题学生的学号、姓名、课题号、课题名
/// </summary>
/// <param name="proc"></param>
/// <param name="args"></param>
/// <returns></returns>
public List <ChooseTeacherThesis> QueryChooseTeacherThesisInfo(string proc, SqlParameter[] args)
{
CommomQuery <ChooseTeacherThesis> query = new CommomQuery <ChooseTeacherThesis>();
return(query.ProcedureQueryToList(proc, args, new ChooseTeacherThesisRowMapper()));
}
public List <ChoosedThesisStuNameList> QueryTeacherChooseAllOfStudent(string procedureName, SqlParameter[] args)
{
CommomQuery <ChoosedThesisStuNameList> query = new CommomQuery <ChoosedThesisStuNameList>();
return(query.ProcedureQueryToList(procedureName, args, new ChoosedThesisStuNameRowMapper()));
}
/// <summary>
/// 查询教师已经同意指导的学生的姓名、班级、论题名、论题来源
/// </summary>
/// <param name="proc">存储过程名</param>
/// <param name="args">存储过程需要的参数</param>
/// <returns></returns>
public List <TGuidingStudentInfo> QueryChoosedGuidingStudent(string proc, SqlParameter[] args)
{
CommomQuery <TGuidingStudentInfo> query = new CommomQuery <TGuidingStudentInfo>();
return(query.ProcedureQueryToList(proc, args, new GuideStudentTableRowMapper()));
}