public void Excute(Dictionary <string, string> jobParams)
{
// JobExcuteDto jobLog = new JobExcuteDto();
// jobLog.JobId = jobParams["jobId"];
// jobLog.ExcuteTime = DateTime.Now;
// //开始监视代码运行时间
// Stopwatch stopwatch = new Stopwatch();
// stopwatch.Restart();
var Sqldb = DbInstanceFactory.GetInstance();
try
{
var log = new easy_log();
log.log_summary = "hangfireJob任务";
log.log_message = DateTime.Now.ToString();
log.log_type = 1;
log.log_time = DateTime.Now;
Sqldb.Insert(log).ExecuteAffrows();
}
catch (Exception e)
{
//LoggerHelper.Exception(e);
//jobLog.EX = e;
//jobLog.ExcuteResult = 1;
}
throw new Exception("this exception from job listener");
//stopwatch.Stop(); // 停止监视
//jobLog.ElapsedTime = stopwatch.Elapsed.TotalMilliseconds; //总秒数
///LoggerHelper.JobLog(jobLog);
}
private void DoWork()
{
try
{
//Console.WriteLine("服务开始了吗");
while (true)
{
List <easy_log> logs = new List <easy_log>();
for (int i = 0; i < 100; i++)
{ //队列中取log
LogDto log = LogQueueInstance.GetLog();
if (log == null)
{
break;
}
if (log != null)
{
easy_log logModel = new easy_log();
logModel.log_summary = log.LogSummary;
logModel.log_message = log.LogMessage;
logModel.log_type = log.LogType;
logModel.log_time = log.LogTime;
logs.Add(logModel);
}
}
List <cms_visit> visits = new List <cms_visit>();
for (int i = 0; i < 100; i++)
{ //队列中取log
cms_visit visit = VisitQueueInstance.GetVisit();
if (visit == null)
{
break;
}
visits.Add(visit);
}
try
{
if (logs.Count > 0)
{
_freeSql.Insert(logs).ExecuteAffrows();
}
if (visits.Count > 0)
{
_freeSql.Insert(visits).ExecuteAffrows();
}
}
catch (Exception ex)
{
_logger.LogError(ex.ToString());
}
Thread.Sleep(100);
}
}
catch (Exception ex)
{
_logger.LogError(ex.ToString());
}
}
public void Excute(string wxAppId, string taskId)
{
try
{
var Sqldb = DbInstanceFactory.GetInstance();
var log = new easy_log();
log.log_summary = "hangfireJob任务";
log.log_message = DateTime.Now.ToString();
log.log_type = 1;
log.log_time = DateTime.Now;
Sqldb.Insert(log).ExecuteAffrows();
Sqldb.Update <hangfire_task>().Set(s => s.excute_time, DateTime.Now)
.Where(s => s.id == taskId).ExecuteAffrows();
}
catch (Exception e)
{
LoggerHelper.Exception(e);
}
}
private void DoWork()
{
try
{
//Console.WriteLine("服务开始了吗");
while (true)
{
List <easy_log> logs = new List <easy_log>();
List <sys_sql_log> sqllogs = new List <sys_sql_log>();
for (int i = 0; i < 300; i++)
{ //队列中取log
LogDto log = LogQueueInstance.GetLog();
if (log == null)
{
break;
}
if (log.LogType == 5)
{
sys_sql_log sqllog = new sys_sql_log();
sqllog.table_name = log.LogSummary;
sqllog.sql_string = log.LogMessage;
sqllog.excute_time = log.LogTime;
sqllog.elapsed_time = log.ElapsedTime;
sqllogs.Add(sqllog);
}
else
{
easy_log logModel = new easy_log();
logModel.log_summary = log.LogSummary;
logModel.log_message = log.LogMessage;
logModel.log_type = log.LogType;
logModel.log_time = log.LogTime;
logs.Add(logModel);
}
}
//List<cms_visit> visits = new List<cms_visit>();
//for (int i = 0; i < 100; i++)
//{ //队列中取log
// cms_visit visit = VisitQueueInstance.GetVisit();
// if (visit == null)
// {
// break;
// }
// visits.Add(visit);
//}
try
{
if (logs.Count > 0)
{
_freeSql.Insert(logs).ExecuteAffrows();
}
//if (visits.Count > 0)
//{
// _freeSql.Insert(visits).ExecuteAffrows();
//}
if (sqllogs.Count > 0)
{
_freeSql.Insert(sqllogs).ExecuteAffrows();
}
}
catch (Exception ex)
{
_logger.LogError(ex.ToString());
}
Thread.Sleep(5000);
}
}
catch (Exception ex)
{
_logger.LogError(ex.ToString());
}
}
private void DoWork()
{
try
{
//Console.WriteLine("服务开始了吗");
while (true)
{
List <easy_log> logs = new List <easy_log>(300);
List <sys_sql_log> sqllogs = new List <sys_sql_log>(300);
List <crontab_history> jobLogs = new List <crontab_history>(300);
for (int i = 0; i < 300; i++)
{ //队列中取log
LogDto log = LogQueueInstance.GetLog();
if (log == null)
{
break;
}
if (log.LogType == 6)
{
crontab_history crontabModel = new crontab_history();
crontabModel.job_id = log.LogSummary;
crontabModel.error_message = log.LogMessage;
crontabModel.excute_time = log.LogTime;
crontabModel.excute_result = log.ExcuteResult;
if (log.ElapsedTime < 1000)
{
crontabModel.elapsed_time = $"{log.ElapsedTime}毫秒";
}
else
{
decimal elaspedSeconds = Math.Round((decimal)log.ElapsedTime / 1000, 1);
crontabModel.elapsed_time = $"{elaspedSeconds}秒";
}
jobLogs.Add(crontabModel);
continue;
}
if (log.LogType == 5)
{
sys_sql_log sqllog = new sys_sql_log();
sqllog.table_name = log.LogSummary;
sqllog.sql_string = log.LogMessage;
sqllog.excute_time = log.LogTime;
sqllog.elapsed_time = log.ElapsedTime;
sqllogs.Add(sqllog);
}
else
{
easy_log logModel = new easy_log();
logModel.log_summary = log.LogSummary;
logModel.log_message = log.LogMessage;
logModel.log_type = log.LogType;
logModel.log_time = log.LogTime;
logs.Add(logModel);
}
}
//List<cms_visit> visits = new List<cms_visit>();
//for (int i = 0; i < 100; i++)
//{ //队列中取log
// cms_visit visit = VisitQueueInstance.GetVisit();
// if (visit == null)
// {
// break;
// }
// visits.Add(visit);
//}
try
{
if (logs.Count > 0)
{
_freeSql.Insert(logs).ExecuteAffrows();
}
//if (visits.Count > 0)
//{
// _freeSql.Insert(visits).ExecuteAffrows();
//}
if (sqllogs.Count > 0)
{
_freeSql.Insert(sqllogs).ExecuteAffrows();
}
if (jobLogs.Count > 0)
{
_freeSql.Insert(jobLogs).ExecuteAffrows();
}
}
catch (Exception ex)
{
_logger.LogError(ex.ToString());
}
Thread.Sleep(5000);
}
}
catch (Exception ex)
{
_logger.LogError(ex.ToString());
}
}
