/// <summary>
/// 批量插入
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public bool BatchInsert(List <TLogsDebugLog> list)
{
//使用SqlBulkCopy
var result = false;
using (var conn = DapperHelper.CreateConnection())
{
//list转DataTable
var dt = LogNewHelper.ConvertToDataTable(list);
using (var sqlbulkcopy = new SqlBulkCopy((SqlConnection)conn))
{
sqlbulkcopy.BatchSize = list.Count;
sqlbulkcopy.DestinationTableName = "t_logs_debug_log";//tableName
for (var i = 0; i < dt.Columns.Count; i++)
{
sqlbulkcopy.ColumnMappings.Add(dt.Columns[i].ColumnName, dt.Columns[i].ColumnName);
}
sqlbulkcopy.WriteToServer(dt);
result = true;
}
}
return(result);
}
static DebugLogManager()
{
//Autofac初始化
container = LogNewHelper.BuildAutofacContainer();
using (var scope = container.BeginLifetimeScope())
{
_debugLogService = scope.Resolve <ILogsDebugLogService>();
}
}
public MainService()
{
tasks = new List <Task>();
cancelToken = new CancellationTokenSource();
//Autofac初始化
container = LogNewHelper.BuildAutofacContainer();
//rabbitMQ初始化
var config = System.Configuration.ConfigurationManager.GetSection("rabbitMQ") as RabbitMQConfigurationSection;
rabbitMQProxy = new RabbitMQWrapper(new RabbitMQConfig
{
Host = config.HostName,
VirtualHost = config.VHost,
HeartBeat = 60,
AutomaticRecoveryEnabled = true,
UserName = config.UserName,
Password = config.Password
});
}
