protected override void BatchCommit()
{
if (!string.IsNullOrEmpty(XXF.Common.XXFConfig.TimeWatchConnectionString))
{
var timewatchinfoTable = DataTableHelper.ConvertToDataTable <tb_timewatchlog_api_model>(TempQueue);
var dict = new Dictionary <string, string>
{
//{"sqlservercreatetime", "sqlservercreatetime"},
{ "logcreatetime", "logcreatetime" },
{ "time", "time" },
{ "projectname", "projectname" },
{ "url", "url" },
{ "tag", "tag" },
{ "msg", "msg" },
{ "fromip", "fromip" }
};
using (var c = Db.DbConfig.CreateConn(Db.DbType.SQLSERVER, XXF.Common.XXFConfig.TimeWatchConnectionString))
{
c.Open();
c.BeginTransaction();
try
{
c.SqlBulkCopy(timewatchinfoTable, BatchTable + DateTime.Now.ToString("yyyyMMdd"), "", new List <ProcedureParameter>(), dict, 0);
c.Commit();
}
catch (Exception exp)
{
c.Rollback();
}
}
}
}
protected override void BatchCommit()
{
if (!string.IsNullOrEmpty(Config.UnityLogConnectString))
{
if (TempQueue.Count > 500)
{
var dict = new Dictionary <string, string>
{
{ "logcreatetime", "logcreatetime" },
{ "logtype", "logtype" },
{ "projectname", "projectname" },
{ "logtag", "logtag" },
{ "msg", "msg" }
};
var timewatchinfoTable = DataTableHelper.ConvertToDataTable <tb_log_model>(TempQueue);
using (var c = Db.DbConfig.CreateConn(Db.DbType.SQLSERVER, Config.UnityLogConnectString))
{
c.Open();
c.BeginTransaction();
try
{
c.SqlBulkCopy(timewatchinfoTable, BatchTable + DateTime.Now.ToString("yyyyMM"), "", new List <ProcedureParameter>(), dict, 0);
c.Commit();
}
catch (Exception exp)
{
c.Rollback();
}
}
}
else
{
foreach (var t in TempQueue)
{
try
{
SqlHelper.ExcuteSql(Config.UnityLogConnectString, (c) =>
{
tb_log_dal logdal = new tb_log_dal();
logdal.Add(c, t);
});
}
catch { }
}
}
}
}
protected virtual void BatchCommit()
{
if (!string.IsNullOrEmpty(XXF.Common.XXFConfig.TimeWatchConnectionString))
{
var timewatchinfoTable = DataTableHelper.ConvertToDataTable <T>(TempQueue);
using (var c = Db.DbConfig.CreateConn(Db.DbType.SQLSERVER, XXF.Common.XXFConfig.TimeWatchConnectionString))
{
c.Open();
c.BeginTransaction();
try
{
c.SqlBulkCopy(timewatchinfoTable, BatchTable + DateTime.Now.ToString("yyyyMMdd"), "", new List <ProcedureParameter>(), 0);
c.Commit();
}
catch (Exception exp)
{
c.Rollback();
}
}
}
}
