/// <summary>
/// 查找详细
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public static ResultPaging <RecordDto> GetRecord(RecordParam param)
{
ResultPaging <RecordDto> resultPaging = new ResultPaging <RecordDto>();
resultPaging.Data = new List <RecordDto>();
try
{
using (var conn = DapperFactory.CrateMysqlConnection())
{
resultPaging.Data = conn.Query <RecordDto>(@"SELECT
a.EnrollNumber, (CASE WHEN b.Name IS NULL THEN a.EnrollNumber ELSE b.`Name` END) as Name,a.AttendancedOn as Attendanced
FROM
attendancerecord AS a
LEFT JOIN personsetting AS b ON a.EnrollNumber = b.EnrollNumber
WHERE a.EnrollNumber = @EnrollNumber or b.Name LIKE @Name order by a.AttendancedOn desc", new { EnrollNumber = param.Search, Name = '%' + param.Search + '%' }).Skip((param.PageIndex - 1) * param.PageSize).Take(param.PageSize).ToList();
resultPaging.Result = true;
resultPaging.Message = $"Search:{param.Search},PageIndex:{param.PageIndex},PageSize:{param.PageSize}";
}
}
catch (Exception ex)
{
resultPaging.Result = false;
resultPaging.Message = ex.Message;
}
return(resultPaging);
}
public BasePagingHandler(ILogger <THandler> logger)
{
_logger = logger ?? throw new ArgumentNullException(nameof(logger));
ActionResult = new ResultPaging <TDto>()
{
IsValid = false,
Response = null,
Errors = new Error()
};
}
protected ResultPaging <TDto> GenerateModelError(ResultPaging <TDto> result, IList <ValidationFailure> errors)
{
_logger.LogWarning("Error response, {@result}", result);
result.IsValid = false;
foreach (var error in errors)
{
result.Errors.Code = error.ErrorCode;
result.Errors.Message = error.ErrorMessage;
}
return(result);
}
