/// <summary>
/// 运营-获取单条申请以及发送列表
/// </summary>
/// <param name="requestDto"></param>
/// <returns></returns>
public async Task <GetOneApproveWithListResponseDto> GetOneApproveWithList(GetOneApproveWithListRequestDto requestDto)
{
using (var conn = MySqlHelper.GetConnection())
{
var sqlStr = @"SELECT
th.theme_guid,
th.name,
th.demand,
th.condition_demand,
th.sqlstr,
ap.approve_guid,
ap.apply_user_guid,
u.user_name AS ApplyUserName,
ap.sql_writer_guid,
u2.user_name AS SQLWriterName,
ap.creation_date
FROM
t_report_approve AS ap
LEFT JOIN t_report_theme AS th ON ap.theme_guid = th.theme_guid
AND ap.ENABLE =
TRUE LEFT JOIN t_utility_user AS u ON ap.apply_user_guid = u.user_guid
LEFT JOIN t_utility_user AS u2 ON ap.sql_writer_guid = u2.user_guid
WHERE
th.`enable` = TRUE
AND ap.approve_guid = @ApproveGuid " ;
var response = await conn.QueryFirstAsync <GetOneApproveWithListResponseDto>(sqlStr, new { requestDto.ApproveGuid });
return(response);
}
}
public async Task <IActionResult> GetOneApproveWithList([FromBody] GetOneApproveWithListRequestDto requestDto)
{
var response = await new CommonReportThemeBiz().GetOneApproveWithList(requestDto);
if (response == null)
{
return(Failed(ErrorCode.DataBaseError, "无数据，请检查!"));
}
return(Success(response));
}