/// <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); }