/// <summary>
/// 获取报表列表
/// </summary>
/// <param name="requestDto"></param>
/// <returns></returns>
public async Task <GetReportListAsyncResponseDto> GetMyAppyList(GetReportListAsyncRequestDto request)
{
var sqlWhere = $@" `enable` = 1 ";
if (!string.IsNullOrWhiteSpace(request.ApplyUserName))
{
sqlWhere = $"{sqlWhere} AND (apply_user_name like @ApplyUserName) ";
}
if (!string.IsNullOrWhiteSpace(request.KeyWord))
{
sqlWhere = $"{sqlWhere} AND (LOCATE(@KeyWord, demand) OR LOCATE(@KeyWord, name) ) ";
}
if (request.StartTime != null)
{
request.StartTime = request.StartTime?.Date;
sqlWhere = $"{sqlWhere} AND creation_date > @StartTime ";
}
if (request.EndTime != null)
{
request.EndTime = request.EndTime?.AddDays(1).Date;
sqlWhere = $"{sqlWhere} AND creation_date < @EndTime ";
}
if (request.RecordStatus > -1 && request.RecordStatus < 3)
{
sqlWhere = $"{sqlWhere} AND record_status = @RecordStatus ";
}
var sqlStr = $@"SELECT
theme_guid,
apply_user_name,
NAME,
demand,
sqlstr,
record_status,
Sort,
created_by,
creation_date,
last_updated_by,
last_updated_date
FROM
t_report_theme
WHERE
{sqlWhere}
ORDER BY
creation_date DESC " ;
return(await MySqlHelper.QueryByPageAsync <GetReportListAsyncRequestDto, GetReportListAsyncResponseDto, GetReportListAsyncItemDto>(sqlStr, request));
}
public async Task <IActionResult> GetReportListAsync([FromBody] GetReportListAsyncRequestDto requestDto)
{
var responseList = await new CommonReportThemeBiz().GetMyAppyList(requestDto);
return(Success(responseList));
}
