public static void AddExceptionLog(ExceptionLog model) { var db = new GrainManageDB(); var sql = "insert into log_exception(Path,InputParameter,Message,StackTrace,ClientIP,CreatedAt) values(@Path,@InputParameter,@Message,@StackTrace,@ClientIP,@CreatedAt)"; db.Execute(sql, model); }
public static int DeleteExceptionLog(params int[] ids) { var db = new GrainManageDB(); var sql = string.Format("delete from log_exception where Id in ({0})", string.Join(",", ids)); return(db.Execute(sql)); }
public static int AddLoginLog(LoginLog model) { var db = new GrainManageDB(); model.CreatedAt = DateTime.Now; var sql = "insert into log_login(UserName,LoginIP,Status,Level,CreatedAt) values(@UserName,@LoginIP,@Status,@Level,@CreatedAt)"; return(db.Execute(sql, model)); }
public static int UpdateActionLog(dynamic model) { var db = new GrainManageDB(); return(db.Execute("update log_action set Status=@Status,EndTime=@EndTime,TimeSpan=@TimeSpan where Id=@Id ", model)); }