public static PageData <RuleConfig> GetConfigRules(int pageIndex, string keyWords, string requestType, string serviceName, int?runStatus, int?status)
{
var conn = DapperDbContext.GetConnection;
var sqlBuilder = new StringBuilder();
sqlBuilder.AppendLine("select r.*,rownum as rowno from ruleconfig r where 1=1 ");
if (!string.IsNullOrEmpty(keyWords))
{
sqlBuilder.AppendFormat("and (Upper(r.Description) like Upper('%{0}%') or Upper(r.Method) like Upper('%{0}%') or Upper(r.PostBody) like Upper('%{0}%') or Upper(r.ContentType) like Upper('%{0}%') or Upper(userName) like Upper('%{0}%')) ", keyWords.ToUpper()).AppendLine();
}
if (!string.IsNullOrEmpty(requestType))
{
sqlBuilder.AppendFormat("and upper(r.method) like Upper('%{0}%') ", requestType.ToUpper()).AppendLine();
}
if (runStatus.HasValue && runStatus > 0)
{
sqlBuilder.AppendFormat("and r.RunStatus = {0} ", runStatus.Value).AppendLine();
}
if (status.HasValue && status > 0)
{
sqlBuilder.AppendFormat("and r.status = {0} ", status.Value).AppendLine();
}
if (!string.IsNullOrEmpty(serviceName))
{
sqlBuilder.AppendFormat("and Upper(r.ServiceName) like Upper('%{0}') ", serviceName.ToUpper()).AppendLine();
}
return(DapperDbContext.ExecuteWithPageing <RuleConfig>(sqlBuilder.ToString(), pageIndex));
}
public static PageData <MonitorLogRecordConfigView> GetConfigRulesWithLogs(int pageIndex, string keyWords, string method, string serviceName, int?status, DateTime beginTime, DateTime endTime)
{
var sqlBuilder = new StringBuilder();
sqlBuilder.AppendLine("select m.responseMessage,m.ruleconfigid,m.operationtype,m.message,m.createtime,m.executetime,m.statusCode,m.statusCodeDescription,r.*,rownum as rowno from monitorlogrecord m inner join ruleconfig r on m.ruleconfigid = r.id where 1=1 ");
if (!string.IsNullOrEmpty(keyWords))
{
sqlBuilder.AppendFormat("and (Upper(r.Description) like Upper('%{0}%') or Upper(r.Method) like Upper('%{0}%') or Upper(r.PostBody) like Upper('%{0}%') or Upper(r.ContentType) like Upper('%{0}%') or Upper(userName) like Upper('%{0}%')) ", keyWords.ToUpper()).AppendLine();
}
if (!string.IsNullOrEmpty(method))
{
sqlBuilder.AppendFormat("and upper(r.Method) like Upper('%{0}%') ", method.ToUpper()).AppendLine();
}
if (status.HasValue && status > 0)
{
sqlBuilder.AppendFormat("and r.Status = {0} ", status.Value).AppendLine();
}
if (!string.IsNullOrEmpty(serviceName))
{
sqlBuilder.AppendFormat("and upper(r.ServiceName) like Upper('%{0}') ", serviceName.ToUpper()).AppendLine();
}
sqlBuilder.AppendFormat("and m.CreateTime >= to_date('{0:yyyy-MM-dd}','yyyy-mm-dd') ", beginTime).AppendLine();
sqlBuilder.AppendFormat("and m.CreateTime <= to_date('{0:yyyy-MM-dd}','yyyy-mm-dd') ", endTime.AddDays(1)).AppendLine();
return(DapperDbContext.ExecuteWithPageing <MonitorLogRecordConfigView>(sqlBuilder.ToString(), pageIndex));
}
public static PageData <SystemLog> GetSystemLogs(int pageIndex, string keyWords, string callsite, string logLevel, DateTime beginTime, DateTime endTime)
{
var sqlBuilder = new StringBuilder();
sqlBuilder.AppendLine("select r.*,rownum as rowno from SysLog r where 1=1 ");
if (!string.IsNullOrEmpty(keyWords))
{
sqlBuilder.AppendFormat("and (Upper(r.Message) like Upper('%{0}%') or Upper(r.callsite) like Upper('%{0}%')) ", keyWords.ToUpper()).AppendLine();
}
if (!string.IsNullOrEmpty(callsite))
{
sqlBuilder.AppendFormat("and upper(r.callsite) like Upper('%{0}') ", callsite).AppendLine();
}
if (!string.IsNullOrEmpty(logLevel))
{
sqlBuilder.AppendFormat("and r.LogLevel = '{0}' ", logLevel).AppendLine();
}
sqlBuilder.AppendFormat("and r.CreateTime >= to_date('{0:yyyy-MM-dd}','yyyy-mm-dd') ", beginTime).AppendLine();
sqlBuilder.AppendFormat("and r.CreateTime <= to_date('{0:yyyy-MM-dd}','yyyy-mm-dd') ", endTime.AddDays(1)).AppendLine();
return(DapperDbContext.ExecuteWithPageing <SystemLog>(sqlBuilder.ToString(), pageIndex));
}
