public void Execute(IJobExecutionContext context)
{
try
{
LogHelper.WriteLog("PRO_MON_COMPLETE_OVERTIME_CNT_JOB");
var db = gzswDB.GetInstance();
model.SVR_TIM_EVENT e = db.SingleOrDefault <model.SVR_TIM_EVENT>("select * from SVR_TIM_EVENT where PROGRAM_METHOD='PRO_MON_COMPLETE_OVERTIME_CNT'");
if (null != e)
{
SVR_TIM_EVENT_LOG log = new SVR_TIM_EVENT_LOG();
log.EVENT_GUID = e.EVENT_GUID;
log.RUN_TIME = DateTime.Now;
log.RUN_STATE = 1;
log.PAR_INFO = "";
log.ERROR_INFO = "";
ExecuteProd(log);
db.Insert("SVR_TIM_EVENT_LOG", "SEQ", log);//写日志
}
}
catch (Exception ex)
{
LogHelper.ErrorLog("PRO_MON_COMPLETE_OVERTIME_CNT_JOB.Execute", ex);
}
}
public void Execute(IJobExecutionContext context)
{
try
{
LogHelper.WriteLog("PRO_STAT_STAFF_QUALITY_STAT_D_JOB");
var db = gzswDB.GetInstance();
model.SVR_TIM_EVENT e = db.SingleOrDefault <model.SVR_TIM_EVENT>("select * from SVR_TIM_EVENT where PROGRAM_METHOD='PRO_STAT_STAFF_QUALITY_STAT_D'");
if (null != e)
{
SVR_TIM_EVENT_LOG log = new SVR_TIM_EVENT_LOG();
log.EVENT_GUID = e.EVENT_GUID;
log.RUN_TIME = DateTime.Now;
log.RUN_STATE = 1;
log.PAR_INFO = "";
log.ERROR_INFO = "";
while (true)
{
bool continu = ExecuteProd(log);
db.Insert("SVR_TIM_EVENT_LOG", "SEQ", log);//写日志
if (!continu)
{
break;
}
}
}
}
catch (Exception ex)
{
LogHelper.ErrorLog("PRO_STAT_STAFF_QUALITY_STAT_D_JOB.Execute", ex);
}
}
public void Execute(IJobExecutionContext context)
{
try
{
LogHelper.WriteLog("PRO_WARN_MON_JOB");
var db = gzswDB.GetInstance();
model.SVR_TIM_EVENT e = db.SingleOrDefault <model.SVR_TIM_EVENT>("From SVR_TIM_EVENT where PROGRAM_METHOD='PRO_WARN_MON'");
if (null != e)
{
SVR_TIM_EVENT_LOG log = new SVR_TIM_EVENT_LOG();
log.EVENT_GUID = e.EVENT_GUID;
log.RUN_TIME = DateTime.Now;
log.RUN_STATE = 2;
log.PAR_INFO = "";
log.ERROR_INFO = "";
try
{
db.Execute("exec PRO_WARN_MON");
log.RUN_STATE = 1;
}
catch (Exception ex)
{
log.ERROR_INFO = ex.Message;
log.RUN_STATE = 2;
}
db.Insert("SVR_TIM_EVENT_LOG", "SEQ", log);//写日志
}
}
catch (Exception ex)
{
LogHelper.ErrorLog("PRO_WARN_MON_JOB.Execute", ex);
}
}
