/// <summary>
/// 批量把系统日志数据导入到库中保存
/// </summary>
/// <param name="systemLogTable">系统日志数据</param>
/// <returns>成功保存记录数</returns>
public int LogImportToDB(DataTable systemLogTable)
{
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder.AppendLine("INSERT INTO SystemLog");
sqlBuilder.Append("SELECT LogTb.Id,LogTb.Module,LogTb.Content,LogTb.ThreadId,");
sqlBuilder.AppendLine("LogTb.Level,LogTb.Version,LogTb.CreateTime");
sqlBuilder.AppendLine("FROM @SystemLogTable AS LogTb");
string sql = sqlBuilder.ToString();
SqlParameter param = new SqlParameter("@SystemLogTable", systemLogTable);
param.SqlDbType = SqlDbType.Structured;
param.TypeName = "dbo.SystemLogType";
using (var db = new InterfaceMonitorDB())
{
int rows = db.Database.ExecuteSqlCommand(sql, param);
return(rows);
}
}
/// <summary>
/// 批量把系统日志数据导入到库中保存
/// </summary>
/// <param name="systemLogTable">系统日志数据</param>
/// <returns>成功保存记录数</returns>
public int LogImportToDB(DataTable requestLogTable)
{
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder.AppendLine("INSERT INTO RequestLog");
sqlBuilder.Append("SELECT LogTb.Id,LogTb.Name,LogTb.RequestUrl,LogTb.RequestMethod,");
sqlBuilder.Append("LogTb.RequestMsg,LogTb.ResponseMsg,LogTb.ExceptionMsg,LogTb.ReferenceId,");
sqlBuilder.AppendLine("LogTb.ReferenceTable,LogTb.Level,LogTb.Version,LogTb.CreateTime");
sqlBuilder.AppendLine("FROM @RequestLogTable AS LogTb");
string sql = sqlBuilder.ToString();
SqlParameter param = new SqlParameter("@RequestLogTable", requestLogTable);
param.SqlDbType = SqlDbType.Structured;
param.TypeName = "dbo.RequestLogType";
using (var db = new InterfaceMonitorDB())
{
int rows = db.Database.ExecuteSqlCommand(sql, param);
return(rows);
}
}
