public async Task <IActionResult> GetIntegralInfoPageAsync([FromBody] GetIntegralInfoPageRequestDto request)
{
ScoreBiz scoreBiz = new ScoreBiz();
var response = await scoreBiz.GetIntegralInfoPageAsync(request);
return(Success(response));
}
public async Task <GetIntegralInfoPageResponseDto> GetIntegralInfoPageAsync(GetIntegralInfoPageRequestDto 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 * FROM(
SELECT * FROM t_utility_score
)___T
WHERE
{sqlWhere}
ORDER BY
{sqlOrderBy}" ;
return(await MySqlHelper.QueryByPageAsync <GetIntegralInfoPageRequestDto, GetIntegralInfoPageResponseDto, GetIntegralInfoPageItemDto>(sql, request));
}
