public async Task <IActionResult> GetConditionListAsync([FromBody] GetConditionOrColumnListRequest request)
{
string[] strArr = new string[] { "condition", "column" };
if (!strArr.Contains(request.RecordType.ToLower().Trim()))
{
return(Failed(ErrorCode.DataBaseError, "查询类型输入有误，请检查!"));
}
var responseList = await new CommonReportThemeBiz().GetConditionListAsync(request);
return(Success(responseList.OrderBy(a => a.Sort)));
}
/// <summary>
/// IT-我的审核列表
/// </summary>
/// <param name="requestDto"></param>
/// <returns></returns>
public async Task <List <GetConditionOrColumnListResponseDto> > GetConditionListAsync(GetConditionOrColumnListRequest request)
{
var sqlStr = @"SELECT
condition_guid,
theme_guid,
NAME,
field_code,
value_type,
value_range,
record_type,
required,
sort
FROM
t_report_condition
WHERE
`enable` = 1
AND theme_guid = @ThemeGuid
AND record_type = @RecordType" ;
using (var conn = MySqlHelper.GetConnection())
{
var response = (await conn.QueryAsync <GetConditionOrColumnListResponseDto>(sqlStr, new { request.ThemeGuid, request.RecordType })).ToList();
return(response);
}
}