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