public async Task <IEnumerable <QuestionBanks> > SearchQuestionAsync(QuestionSearch model)
{
try
{
var dbfactory = DbFactoryProvider.GetFactory();
using (var db = (SqlConnection)dbfactory.GetConnection())
{
await db.OpenAsync();
string questionQuery = "SELECT * FROM dbo.QuestionBankView WHERE " +
"(@QuestionTypeId IS NULL OR QuestionTypeId = @QuestionTypeId) " +
"AND (@QuestionCategoryId IS NULL OR QuestionCategoryId = @QuestionCategoryId) " +
"AND (@QuestionComplexityId IS NULL OR QuestionComplexityId = @QuestionComplexityId) " +
"AND (Question LIKE @Question)";
var result = await db.QueryAsync <QuestionBanks>(questionQuery,
new
{
QuestionTypeId = model.QuestionTypeId == 0 ? (int?)null : (int?)model.QuestionTypeId,
QuestionCategoryId = model.QuestionCategoryId == 0 ? (int?)null : (int?)model.QuestionCategoryId,
QuestionComplexityId = model.QuestionComplexityId == 0 ? (int?)null : (int?)model.QuestionComplexityId,
Question = "%" + model.Question + "%"
});
Console.WriteLine(questionQuery);
return(result);
}
}
catch (Exception)
{
throw;
}
}
public PagedResponse <QuestionDto> Execute(QuestionSearch search)
{
var query = _context.Questions.AsQueryable();
if (!string.IsNullOrEmpty(search.Title) || !string.IsNullOrWhiteSpace(search.Title))
{
query = query.Where(question => question.Title.ToLower().Contains(search.Title.ToLower()));
}
return(query.Paged <QuestionDto, Question>(search, _mapper));
}
public async Task <ApiResponse> SearchQuestionBankAsync(QuestionSearch model)
{
try
{
var result = await _questionService.SearchQuestionAsync(model);
return(HttpResponse(200, "", result));
}
catch (Exception e)
{
_logger.Log(LogType.Error, () => e.Message, e);
return(HttpResponse(500, e.Message));
}
}
public IActionResult Get([FromQuery] QuestionSearch search, [FromServices] IGetQuestionsQuery query)
{
return(Ok(_executor.ExecuteQuery(query, search)));
}
public List <QuestionDetail> SearchQuestions([FromBody] QuestionSearch searchParms)
{
ModuleBuilderManager m = new ModuleBuilderManager();
return(m.SearchQuestions(searchParms));
}
/// <summary>
/// 搜索题目信息
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public PagerModel <Questions> Search(QuestionSearchRequest request)
{
QuestionSearch search = new QuestionSearch(request);
return(search.Search());
}
