/// <summary>
/// 删除一天的邮件发送日志
/// </summary>
/// <param name="times"></param>
public bool DeleteOneSendEmailOprLog(string times)
{
string strSql = "delete from SendEmailLog where";
if (times != string.Empty)
{
strSql += " times=" + "'" + times + "'";
}
int index = _idbRead.ExecuteNonQuery(strSql);
if (index == -5)
{
return(false);
}
return(true);
}
public async Task <JArray> Execute(JObject data)
{
dynamic dataDto = data;
bool isQuery = dataDto.IsQuery;
string query = dataDto.Code;
if (string.IsNullOrEmpty(query.Trim()))
{
return(new JArray());
}
int connectionId = dataDto.ConnectionId;
var connectionByPermission = await ContentManagementContext.MasterDataKeyValues
.Where(md => (md.Id == connectionId && md.TypeId == (int)EntityIdentity.SqlServerConnections) ||
(md.ForeignKey3 == connectionId && md.TypeId == (int)EntityIdentity.Permission)).ToListAsync();
var connection = connectionByPermission.FirstOrDefault(con => con.Id == connectionId);
if (connection == null)
{
throw new KhodkarInvalidException(LanguageManager.ToAsErrorMessage(ExceptionKey.NotFound, " Connection "));
}
var permission = connectionByPermission.FirstOrDefault(prm => prm.ForeignKey3 == connectionId &&
prm.TypeId == (int)EntityIdentity.Permission);
if (permission == null)
{
throw new KhodkarInvalidException(LanguageManager.ToAsErrorMessage(ExceptionKey.NotFound, " Permission "));
}
if (!AuthorizeManager.IsAuthorize(permission.ForeignKey2))
{
throw new UnauthorizedAccessException(LanguageManager.ToAsErrorMessage(ExceptionKey.InvalidGrant));
}
if (isQuery)
{
return(_dataBaseManager.ExecuteQuery(connection.SecondCode, query));
}
else
{
return(_dataBaseManager.ExecuteNonQuery(connection.SecondCode, query));
}
}