public static IList <GradeCourse> GetGradeCourse(int micYear, GradeCode gradeCode)
{
using (AppBLL bll = new AppBLL())
{
var sql = "SELECT a.Academicyear,a.GradeNo, a.CourseCode, b.FullName"
+ " FROM tbCourseUse a LEFT OUTER JOIN"
+ " tdCourseCode b ON a.coursecode = b.CourseCode"
+ " where a.Academicyear=@micYear"
+ " and a.GradeNo=@gradeNo";
return(bll.FillListByText <GradeCourse>(sql, new { micYear = micYear, gradeNo = gradeCode.GradeNo }));
}
}
public static IList <GradeCourse> GetGradeCourse(GradeCode gradeCode, int flag)
{
using (AppBLL bll = new AppBLL())
{
var sql = "SELECT a.Academicyear,a.GradeNo, a.CourseCode, b.FullName" +
" FROM tbCourseUse a LEFT OUTER JOIN" +
" tdCourseCode b ON a.coursecode = b.CourseCode" +
" where (@flag=-1 or b.IsDownLoad = @flag)" +
" and a.GradeNo=@gradeNo" +
" group by a.Academicyear,a.gradeno,a.coursecode, b.FullName";
return(bll.FillListByText <GradeCourse>(sql, new { gradeNo = gradeCode.GradeNo, flag = flag }));
}
}
public static IList <GradeClass> GetGradeClass(int academicYear, GradeCode gradeCode)
{
try
{
using (AppBLL bll = new AppBLL())
{
var sql = "select a.SystemID, a.GradeNo, AcadEmicYear, ClassNo, ClassType, IsDelete,b.GradeName, b.GradeBriefName from tbGradeClass a, tdGradeCode b" +
" where a.Gradeno=b.GradeNO" +
" and a.GradeNO=@gradeCode" +
" and a.AcadEmicYear=@micYear";
return(bll.FillListByText <GradeClass>(sql, new { micYear = academicYear, gradeCode = gradeCode.GradeNo }));
}
}
catch (Exception ex)
{
throw ex;
}
}
public static IList <TestType> GetTestTypeByCourse(int micYear, GradeCourse gradeCourse, GradeCode gradeCode)
{
using (AppBLL bll = new AppBLL())
{
var sql = " SELECT a.TestType as Code, b.TypeName as Name"
+ " FROM s_tb_testlogin a INNER JOIN"
+ " s_tb_TestTypeInfo b ON a.TestType = b.TestType"
+ " where a.AcademicYear=@micYear"
+ " and a.coursecode in ('00000', @courseCode)"
+ " and a.GradeNo in ('00',@gradeNo)"
+ " group by a.testtype,b.typename "
+ " order by a.testtype ";
return(bll.FillListByText <TestType>(sql, new { micYear = micYear, courseCode = gradeCourse.CourseCode, gradeNo = gradeCode.GradeNo }));
}
}
