/// <summary> /// 设置条件 /// </summary> /// <param name="command"></param> /// <param name="filter"></param> private static void SetCondition(DataCommand command, ExamTestFilter filter) { //测验类型 if (filter.mode.HasValue) { command.QuerySetCondition("t.mode", ConditionOperation.Equal, DbType.Int32, filter.mode.Value); } //针对文档 if (!string.IsNullOrEmpty(filter.document_name)) { command.QuerySetCondition("d.name", ConditionOperation.Like, DbType.String, filter.document_name); } //针对模拟考试 if (filter.examid.HasValue) { command.QuerySetCondition("t.exam_id", ConditionOperation.Equal, DbType.Int32, filter.examid.Value); } //开始日期 if (filter.StartTime.HasValue) { command.QuerySetCondition("t.begin_time", ConditionOperation.MoreThanEqual, DbType.DateTime, filter.StartTime); } //结束日期 if (filter.EndTime.HasValue) { command.QuerySetCondition("t.begin_time", ConditionOperation.LessThan, DbType.DateTime, filter.EndTime.Value.AddDays(1)); } command.ReplaceAndSetSQLTag("TagOrder" + filter.sortColumn, filter.sortColumn); command.CommandText = command.CommandText.Replace("#STRWHERE#", command.QueryConditionString); }
/// <summary> /// 查询历史记录 不分页 /// </summary> /// <param name="filter"></param> /// <returns></returns> public static List <ExamTestView> ExportExamTestList(ExamTestFilter filter) { var cmd = new DataCommand("MockTest.ExportExamTestList"); SetCondition(cmd, filter); return(cmd.ExecuteEntityList <ExamTestView>()); }
/// <summary> /// 测验历史记录分页查询 /// </summary> /// <param name="filter"></param> /// <returns></returns> public static QueryResult <ExamTestView> SearchExamTestPageLists(ExamTestFilter filter) { var cmd = new DataCommand("MockTest.SearchExamTestPageLists"); SetCondition(cmd, filter); //排序 return(cmd.Query <ExamTestView>(filter, filter.sortColumn + " desc ", null, true)); }
public ActionResult ExamTestQuery() { ExamTestFilter filter = BuildQueryFilterEntity <ExamTestFilter>(); return(AjaxGridJson(MockTestBasisService.SearchExamTestPageLists(filter))); }
/// <summary> /// 测验历史记录分不分页查询 /// </summary> /// <param name="filter"></param> /// <returns></returns> public List <ExamTestView> ExportExamTestList(ExamTestFilter filter) { var data = MockTestDA.ExportExamTestList(filter); return(data); }
/// <summary> /// 测验历史记录分页查询 /// </summary> /// <param name="filter"></param> /// <returns></returns> public QueryResult <ExamTestView> SearchExamTestPageLists(ExamTestFilter filter) { var data = MockTestDA.SearchExamTestPageLists(filter); return(data); }