private readonly string sql = ""; // 日志sql语句
public DbLogEventHandler(LoggingDbOptions dbLogOptions)
{
_dbLogOptions = dbLogOptions;
if (_dbLogOptions.IsDbSharding)
{
switch (_dbLogOptions.DbShardingRule)
{
case 1:
tableName = tableName + "_" + DbShardingHelper.DayRule(DateTime.Now);
break;
case 2:
tableName = tableName + "_" + DbShardingHelper.MonthRule(DateTime.Now);
break;
}
}
sql = string.Format(@"INSERT INTO {0} (Id,AddTime,ClassName,ProjectName, LogTag, LogType, LogMessage, IP)
VALUES (@Id,@AddTime,@ClassName,@ProjectName, @LogTag, @LogType, @LogMessage, @IP)"
, tableName);
}
public void AddCollect(DbConn PubConn, tb_performance_collect_model model)
{
SqlHelper.Visit(ps =>
{
//服务器id
ps.Add("@serverid", model.serverid);
//cpu信息
ps.Add("@cpu", model.cpu);
//内存字节
ps.Add("@memory", model.memory);
//网络上传字节
ps.Add("@networkupload", model.networkupload);
//网络下载字节
ps.Add("@networkdownload", model.networkdownload);
//io读字节
ps.Add("@ioread", model.ioread);
//io写字节
ps.Add("@iowrite", model.iowrite);
//
ps.Add("@iisrequest", model.iisrequest);
//创建时间
ps.Add("@createtime", model.createtime);
return(PubConn.ExecuteSql(string.Format(@"insert into tb_performance_collect{0}(serverid,cpu,memory,networkupload,networkdownload,ioread,iowrite,iisrequest,createtime)
values(@serverid,@cpu,@memory,@networkupload,@networkdownload,@ioread,@iowrite,@iisrequest,@createtime)" , DbShardingHelper.DayRule(DateTime.Now)), ps.ToParameters()));
});
}