/// <summary>
/// mssql
/// </summary>
/// <param name="models"></param>
/// <param name="_repository"></param>
public static async void BulkInsertAsync(IEnumerable <TEntity> models, IRepository <TEntity> _repository)
{
if (_repository == null)
{
throw new ArgumentNullException(nameof(_repository));
}
try
{
await Task.Run(() => _repository.BulkInsert(models));
}
catch (Exception e) //异步吞掉异常，不然进程奔溃
{
var log = new SysErrorLog
{
ErrReferrer = "",
ErrSource = e.Source,
ErrTime = DateTime.Now
};
log.ErrTimestr = log.ErrTime.ToString("yyyyMMdd");
log.ErrStack = e.StackTrace;
log.ErrType = SysErrorType.bulkInsert.ToString();
log.ErrUrl = "/recordmanage/RecordManage/add_batch";
log.ErrIp = "";
log.ErrMessage = e.Message;
using (SKContext context = new SKContext())
{
context.SysErrorLogs.Add(log);
context.SaveChanges();
}
}
}
//public void Log(string msg, string funcCode, string userCode)
//{
// SysOperationLog log = new SysOperationLog();
// log.ID = GetNextID().ToString();
// log.UpdatedDate = DateTime.Now;
// log.UserCode = userCode;
// log.MEMO = msg;
// log.FuncCode = funcCode;
// DBContext.SaveAndUpdate<SysOperationLog>(log);
//}
public void SaveLog(SysErrorLog log)
{
log.CreatedDate = DateTime.Now;
log.UpdatedDate = DateTime.Now;
log.ID = PubHelper.GetHelper(DBContext).GetNextID().ToString();
DBContext.Create <SysErrorLog>(log);
}
public void Insert(SysErrorLog log)
{
using (SKContext db = new SKContext())
{
db.SysErrorLogs.Add(log);
db.SaveChanges();
}
}
public void Error(string msg, string userCode, string funcCode)
{
SysErrorLog log = new SysErrorLog();
log.ID = GetNextID().ToString();
log.CreatedDate = DateTime.Now;
log.FuncCode = funcCode;
log.UserCode = userCode;
log.INFO = msg;
log.LogType = "USER";
DBContext.SaveAndUpdate <SysErrorLog>(log);
}
public void Error(Exception ex, string userCode, string funcCode)
{
SysErrorLog log = new SysErrorLog();
log.ID = GetNextID().ToString();
log.CreatedDate = DateTime.Now;
log.FuncCode = funcCode;
log.UserCode = userCode;
log.INFO = ex == null ? "" : ex.StackTrace;
log.LogType = "SYSTEM";
DBContext.SaveAndUpdate <SysErrorLog>(log);
}
static void Main(string[] args)
{
SysErrorLog e = new SysErrorLog()
{
ErrorMessage = "测试dapper对象插入",
Memo = "55",
RelationId = "5",
TableName = "table",
UpdateTime = DateTime.Now
};
int tip = (int)conn.Insert <SysErrorLog>(e);
}
public static void Log(string source, string messge, string trace, bool isDelay = false)
{
SysErrorLog log = new SysErrorLog
{
LogDate = DateTime.Now,
LogUser = AppContextBase.CurrentUserID,
SubSys = Convert.ToInt32(AppContextBase.CurrentSysId),
LogSource = source,
LogMessage = messge,
LogStackTrace = trace
};
if (isDelay)
BackgroundWorker.DoWork<SysErrorLog>(log, 2, e => e.Save( ));
else
log.Save( );
}
public static SysErrorLog CreateLogError(Exception e)
{
var log = new SysErrorLog
{
ErrReferrer = HttpContext.Current.Request.UserAgent,
ErrSource = e.Source,
ErrTime = DateTime.Now,
ErrTimestr = DateTime.Now.ToString("yyyyMMdd"),
ErrStack = e.StackTrace,
ErrType = SysErrorType.system.ToString(),
ErrUrl = HttpContext.Current.Request.Url.OriginalString,
ErrIp = HttpContext.Current.Request.UserHostAddress,
ErrMessage = e.Message
};
return(log);
}
/// <summary>
/// 记录对接日志
/// </summary>
/// <param name="dock_url"></param>
/// <param name="warnings"></param>
/// <param name="message"></param>
private void CreateLogError(string dock_url, string warnings, string message)
{
var log = new SysErrorLog
{
ErrReferrer = dock_url,
ErrSource = warnings,
ErrTime = DateTime.Now,
ErrTimestr = DateTime.Now.ToString("yyyyMMdd"),
ErrStack = "第三方对接",
ErrType = SysErrorType.docking.ToString(),
ErrUrl = dock_url,
ErrIp = "",
ErrMessage = message
};
using (SKContext context = new SKContext())
{
context.SysErrorLogs.Add(log);
context.SaveChanges();
}
}
public void Insert(DateTime? LogDate,string LogSource,string LogMessage,string LogStackTrace,int? SubSys,int? LogUser)
{
SysErrorLog item = new SysErrorLog();
item.LogDate = LogDate;
item.LogSource = LogSource;
item.LogMessage = LogMessage;
item.LogStackTrace = LogStackTrace;
item.SubSys = SubSys;
item.LogUser = LogUser;
item.Save(UserName);
}
public void Update(int Id,DateTime? LogDate,string LogSource,string LogMessage,string LogStackTrace,int? SubSys,int? LogUser)
{
SysErrorLog item = new SysErrorLog();
item.MarkOld();
item.IsLoaded = true;
item.Id = Id;
item.LogDate = LogDate;
item.LogSource = LogSource;
item.LogMessage = LogMessage;
item.LogStackTrace = LogStackTrace;
item.SubSys = SubSys;
item.LogUser = LogUser;
item.Save(UserName);
}
