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);
}
}
/// <summary>
/// 返回值bool：是否继续执行该job
/// </summary>
/// <param name="log"></param>
/// <returns></returns>
private bool ExecuteProd(SVR_TIM_EVENT_LOG log)
{
try
{
var db = new Database();
var parlist = db.Fetch <SVR_TIM_EVENT_PAR>("select * from SVR_TIM_EVENT_PAR where EVENT_GUID=@0 order by PAR_ORD asc", log.EVENT_GUID);
log.PAR_INFO = string.Join(",", parlist.Select(obj => obj.PAR_VALUE));
log.RUN_TIME = DateTime.Now;
db.Execute("exec PRO_REPORT_STAT_D @0, @1", parlist.Select(obj => obj.PAR_VALUE).ToArray());
var par1 = parlist.FirstOrDefault(obj => obj.PAR_ORD == 1);
if (null != par1)
{
var nextpar = DateTime.Parse(par1.PAR_VALUE).AddDays(1);
par1.PAR_VALUE = nextpar.ToString("yyyy-MM-dd");
db.Save(par1);//更新参数
if (nextpar <= DateTime.Today)
{
return(true);//继续执行
}
return(false);
}
}
catch (Exception ex)
{
log.ERROR_INFO = ex.Message;
log.RUN_STATE = 2;
}
return(false);
}
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);
}
}
/// <summary>
/// 返回值bool：是否继续执行该job
/// </summary>
/// <param name="log"></param>
/// <returns></returns>
private void ExecuteProd(SVR_TIM_EVENT_LOG log)
{
try
{
var db = gzswDB.GetInstance();
db.Execute("exec PRO_INIT_QUEUEDEAL_D");
}
catch (Exception ex)
{
log.ERROR_INFO = ex.Message;
log.RUN_STATE = 2;
}
}
/// <summary>
/// 返回值bool：是否继续执行该job
/// </summary>
/// <param name="log"></param>
/// <returns></returns>
private bool ExecuteProd(SVR_TIM_EVENT_LOG log)
{
try
{
var db = gzswDB.GetInstance();
var parlist = db.Fetch <SVR_TIM_EVENT_PAR>("select * from SVR_TIM_EVENT_PAR where EVENT_GUID=@0 order by PAR_ORD asc", log.EVENT_GUID);
var par1 = parlist.FirstOrDefault(obj => obj.PAR_ORD == 1);
log.PAR_INFO = string.Join(",", parlist.Select(obj => obj.PAR_VALUE));
log.RUN_TIME = DateTime.Now;
if (!CHkParam(par1))
{
log.ERROR_INFO = "参数检查不通过！";
log.RUN_STATE = 2;
return(false);
}
try
{
db.Execute("exec PRO_CHK_STAFFCHK_EVENT_D @0, @1", parlist.Select(obj => obj.PAR_VALUE).ToArray());
if (null != par1)
{
var nextpar = DateTime.Parse(par1.PAR_VALUE).AddDays(1);
par1.PAR_VALUE = nextpar.ToString("yyyy-MM-dd");
db.Save(par1);//更新参数
if (nextpar < DateTime.Today)
{
return(true);//继续执行
}
return(false);
}
}
catch (Exception ex)
{
log.ERROR_INFO = ex.Message;
log.RUN_STATE = 2;
LogHelper.ErrorLog("", ex);
return(false);
}
}
catch (Exception ex)
{
log.ERROR_INFO = ex.Message;
log.RUN_STATE = 2;
}
return(false);
}
/// <summary>
/// 返回值bool：是否继续执行该job
/// </summary>
/// <param name="log"></param>
/// <returns></returns>
private void ExecuteProd(SVR_TIM_EVENT_LOG log)
{
try
{
var db = gzswDB.GetInstance();
log.PAR_INFO = "";
log.RUN_TIME = DateTime.Now;
db.Execute("exec PRO_MON_ABAN_RT");
}
catch (Exception ex)
{
log.ERROR_INFO = ex.Message;
log.RUN_STATE = 2;
}
}