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