public ActionResult GetTotalRecordByStatus(DtoStudyTaskSearch search)
{
search.StudentId = GetCurrentUser().StudentId;
search.TaskType = StudyTaskTypeEnum.系统课后任务;
StudentPracticeBll bll = new StudentPracticeBll();
var entities = bll.GetTotalRecordByStatus(search);
return(Json(new SuccessJsonResponse(entities), JsonRequestBehavior.AllowGet));
}
public ActionResult GetStudyTasks(DtoStudyTaskSearch search)
{
search.StudentId = GetCurrentUser().StudentId;
search.TaskType = StudyTaskTypeEnum.系统课后任务;
StudentPracticeBll bll = new StudentPracticeBll();
var entities = bll.GetStudyTasks(search);
var list = entities.ConvertTo <IList <StudyTaskListViewModel> >();
var table = AbhsTableFactory.Create(list, search.Pagination.TotalCount);
return(Json(table, JsonRequestBehavior.AllowGet));
}
public ActionResult ListStudyTasks(DtoStudyTaskSearch historySearch)
{
string condition = string.Empty;
if (historySearch.TaskStatus.HasValue())
{
condition = JsonConvert.SerializeObject(historySearch);
}
ViewBag.HistorySearch = condition;
return(View());
}
public void StudentTaskRepository_GetEntities_ShouldReturn()
{
var search = new DtoStudyTaskSearch
{
Pagination = new PagingObject(1, 10),
StudentId = 10011,
TaskType = StudyTaskTypeEnum.系统课后任务,
TaskStatus = "1"
};
var result = new StudentTaskRepository().GetEntities(search);
Assert.IsNotNull(result);
}
public IList <DtoStatusTotalRecord> GetTotalRecordByStatus(DtoStudyTaskSearch search)
{
var sqlBuilder = new StringBuilder();
sqlBuilder.Append(@"SELECT COUNT(1) AS TotalRecord,Yuk_Status AS Status
FROM Yw_StudentTask WHERE 1 = 1");
sqlBuilder.Append(" AND Yuk_TaskType = @TaskType");
sqlBuilder.Append(" AND Yuk_StudentId = @StudentId");
sqlBuilder.Append(" GROUP BY Yuk_Status");
return(Query <DtoStatusTotalRecord>(
sqlBuilder.ToString(),
new { TaskType = search.TaskType, StudentId = search.StudentId }).ToList());
}
public IList <DtoStudyTaskListItem> GetEntities(DtoStudyTaskSearch search)
{
StringBuilder fieldBuilder = new StringBuilder();
fieldBuilder.Append("Ycs_Name AS CourseName,");
fieldBuilder.Append("Yuk_FinishTime AS FinishTime,");
fieldBuilder.Append("Yuk_CreateTime AS StartTime,");
fieldBuilder.Append("Yuk_LessonIndex AS LessonIndex,");
fieldBuilder.Append("Yuk_Status AS Status,");
fieldBuilder.Append("Yuk_SubjectCount AS SubjectCount");
fieldBuilder.Append(",Yuk_TaskId AS StudyTaskId");
fieldBuilder.Append(",Yuk_Id AS StudentTaskId");
StringBuilder whereBuilder = new StringBuilder();
whereBuilder.Append("Yw_StudentTask");
whereBuilder.Append(" INNER JOIN Yw_Course ON Yuk_CourseId = Ycs_Id");
//whereBuilder.Append(" INNER JOIN Yw_CourseLesson ON Ycl_Id = Yuk_LessonId");
whereBuilder.Append(" WHERE Yuk_StudentId = @studentId");
whereBuilder.Append(" AND Yuk_TaskType = @taskType");
if (search.TaskStatusParameter != null && search.TaskStatusParameter.Any())
{
whereBuilder.Append(" AND Yuk_Status in @taskStatuses");
}
string orderby = "Yuk_CreateTime DESC";
var parameters = new
{
studentId = search.StudentId,
taskType = (int)search.TaskType,
taskStatuses = search.TaskStatusParameter
};
return(QueryPaging <DtoStudyTaskListItem>(
fieldBuilder.ToString(),
whereBuilder.ToString(),
orderby,
search.Pagination,
parameters).ToList());
}
public IList <DtoStatusTotalRecord> GetTotalRecordByStatus(DtoStudyTaskSearch search)
{
var result = StudentTaskRepository.GetTotalRecordByStatus(search);
return(result);
}
public IList <DtoStudyTaskListItem> GetStudyTasks(DtoStudyTaskSearch search)
{
var studyTasks = StudentTaskRepository.GetEntities(search);
return(studyTasks);
}
