public ActionResult ListCourses(DtoCoursesSearch historySearch)
{
string condition = string.Empty;
if (historySearch != null && historySearch.Pagination.PageIndex > 1)
{
condition = JsonConvert.SerializeObject(historySearch);
}
ViewBag.HistorySearch = condition;
return(View());
}
public void StudentCourseProgressRepository_GetCoursesAttended_ShouldSuccess()
{
var search = new DtoCoursesSearch()
{
StudentId = 10011
};
var result = new StudentCourseProgressRepository().GetCoursesAttended(search);
Assert.IsNotNull(result);
Assert.IsTrue(result.Count > 0);
}
public ActionResult GetCoursesAttended(DtoCoursesSearch search)
{
search.StudentId = GetCurrentUser().StudentId;
StudentStudyBll bll = new StudentStudyBll();
IList <StudentPractice.DtoCourse> courses = bll.GetCoursesAttended(search);
var result = courses.ConvertTo <IList <CourseListItemVm> >();
var table = AbhsTableFactory.Create(result, search.Pagination.TotalCount);
return(Json(table, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 获取上过课的课程
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public IList <StudentPractice.DtoCourse> GetCoursesAttended(DtoCoursesSearch search)
{
StringBuilder fieldBuilder = new StringBuilder();
fieldBuilder.Append("Ycs_Name AS CourseName");
fieldBuilder.Append(", Ycs_CourseType AS CourseType");
fieldBuilder.Append(", Yps_CourseId AS CourseId");
fieldBuilder.Append(", Yps_NextLessonIndex AS NextLessonIndex");
fieldBuilder.Append(", Ycs_Grade AS Grade");
fieldBuilder.Append(", Ycc_Name AS ClassName");
fieldBuilder.Append(", Bsl_SchoolName AS SchoolName");
fieldBuilder.Append(", Ycs_LessonCount AS LessonCount");
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder.Append("Yw_StudentCourseProgress");
sqlBuilder.Append(" INNER JOIN Yw_Course ON Ycs_Id = Yps_CourseId");
sqlBuilder.Append(" LEFT JOIN Yw_SchoolClass ON Ycc_Id = Yps_ClassId");
sqlBuilder.Append(" LEFT JOIN Bas_School ON Bsl_Id = Yps_SchoolId");
sqlBuilder.Append(" WHERE Yps_LessonFinishedCount > 0");//过滤上过课的课程
if (search.StudentId > 0)
{
sqlBuilder.Append(" AND Yps_StudentId = @studentId");
}
string orderby = "Yps_CreateTime DESC";
var parameters = new
{
studentId = search.StudentId
};
//return Query<StudentPractice.DtoCourse>(
// sqlBuilder.ToString(),
// new { studentId = search.StudentId }).ToList();
return(QueryPaging <StudentPractice.DtoCourse>(
fieldBuilder.ToString(),
sqlBuilder.ToString(),
orderby,
search.Pagination,
parameters).ToList());
}
public IList <StudentPractice.DtoCourse> GetCoursesAttended(DtoCoursesSearch search)
{
return(ScpRepository.GetCoursesAttended(search));
}