public async Task <IActionResult> ExportIntegralInfoAsync([FromBody] ExportIntegralInfoRequestDto request)
{
ScoreBiz scoreBiz = new ScoreBiz();
var response = await scoreBiz.ExportIntegralInfoAsync(request);
return(Success(new ExportIntegralInfoResponseDto {
Items = response
}));
}
public async Task <IEnumerable <GetIntegralInfoPageItemDto> > ExportIntegralInfoAsync(ExportIntegralInfoRequestDto request)
{
var sqlWhere = $@"1 = 1 and enable=1 and user_guid=@UserGuid and user_type_guid='{UserType.Doctor.ToString()}'";
var sqlOrderBy = "creation_date desc";
var sql = $@"
SELECT Score_Guid,User_Guid,Variation,Reason ,Creation_Date FROM t_utility_score
WHERE
{sqlWhere}
ORDER BY
{sqlOrderBy}" ;
using (var conn = MySqlHelper.GetConnection())
{
return(await conn.QueryAsync <GetIntegralInfoPageItemDto>(sql, request));
}
}
