public async Task <DatabaseResponse> GetContentAsync(ContentApprovalRequest contentApprovalRequest)
{
try
{
SqlParameter[] parameters =
{
new SqlParameter("@QrcId", SqlDbType.Int),
new SqlParameter("@CategoryID", SqlDbType.Int),
new SqlParameter("@UserId", SqlDbType.Int),
new SqlParameter("@PageNo", SqlDbType.Int),
new SqlParameter("@PageSize", SqlDbType.Int)
};
parameters[0].Value = contentApprovalRequest.QrcId;
parameters[1].Value = contentApprovalRequest.CategoryId;
parameters[2].Value = contentApprovalRequest.UserId;
parameters[3].Value = contentApprovalRequest.PageNo;
parameters[4].Value = contentApprovalRequest.PageSize;
_DataHelper = new DataAccessHelper("sps_ContentForApproval", parameters, _configuration);
DataTable dt = new DataTable();
int result = await _DataHelper.RunAsync(dt);
List <QrcManagement> content = new List <QrcManagement>();
if (dt != null && dt.Rows.Count > 0)
{
content = (from model in dt.AsEnumerable()
select new QrcManagement()
{
RowNumber = model.Field <Int64>("RowNumber"),
ContentId = model.Field <int>("ContentId"),
ContentApprovalId = model.Field <int>("ContentApprovalId"),
Title = model.Field <string>("Title"),
CreatedOn = model.Field <DateTime>("CreatedOn"),
ContentType = model.Field <int>("ContentType"),
CategoryId = model.Field <int>("CategoryId"),
TotalRows = model.Field <Int64>("TotalRows")
}).ToList();
}
return(new DatabaseResponse {
ResponseCode = result, Results = content
});
}
catch (Exception ex)
{
Log.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical));
throw;
}
finally
{
_DataHelper.Dispose();
}
}
/// <summary>
/// 文本审核接口能够识别文本信息中的色情、政治等有害内容，帮助用户及时、精准地防范违规风险，可用于内容审核、敏感信息过滤、舆情监控等场景。
///
/// 该功能基于10万级大规模敏感词库，结合多种文本对抗方法、政策权威指令等，并运用了深度学习技术，高效识别高危有害内容。同时我们会根据大规模语料和实时反误杀系统，不断更新迭代，确保效果持续提升。
///
/// 文本审核接口目前提供以下三个功能：
///
/// 1、文本恶意级别：将文本分为3个级别，包括正常、恶意、可疑送审；
///
/// 2、文本恶意类型：把文本分为9个类别，包括正常、政治、色情、辱骂/低俗、暴恐/毒品、广告/灌水、迷信/邪教、其他违法、综合；
///
/// 3、恶意关键词：文本中所有涉嫌恶意的关键词。
/// </summary>
/// <param name="req">参考<see cref="ContentApprovalRequest"/></param>
/// <returns>参考<see cref="ContentApprovalResponse"/>实例</returns>
public async Task <ContentApprovalResponse> ContentApproval(ContentApprovalRequest req)
{
JsonResponseModel <ContentApprovalResponse> rsp = null;
try
{
var strResp = await this.InternalRequest(req, "ContentApproval");
rsp = JsonConvert.DeserializeObject <JsonResponseModel <ContentApprovalResponse> >(strResp);
}
catch (JsonSerializationException e)
{
throw new TencentCloudSDKException(e.Message);
}
return(rsp.Response);
}
public async Task <IActionResult> GetContentApproval(ContentApprovalRequest contentApprovalRequest)
{
try
{
QrcDataAccess _qrcAccess = new QrcDataAccess(_iconfiguration, _converter);
DatabaseResponse response = await _qrcAccess.GetContentAsync(contentApprovalRequest);
if (response.ResponseCode == (int)DbReturnValue.RecordExists)
{
return(Ok(new OperationResponse
{
HasSucceeded = true,
IsDomainValidationErrors = false,
Message = EnumExtensions.GetDescription(DbReturnValue.RecordExists),
ReturnedObject = response.Results
}));
}
else
{
Log.Error(EnumExtensions.GetDescription(DbReturnValue.NotExists));
return(Ok(new OperationResponse
{
HasSucceeded = false,
IsDomainValidationErrors = false,
Message = EnumExtensions.GetDescription(DbReturnValue.NotExists),
ReturnedObject = response.Results
}));
}
}
catch (Exception ex)
{
Log.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical));
return(Ok(new OperationResponse
{
HasSucceeded = false,
Message = StatusMessages.ServerError,
StatusCode = ((int)ResponseStatus.ServerError).ToString(),
IsDomainValidationErrors = false
}));
}
}
