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