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