protected Boolean rbtnCheck_Click(object sender, EventArgs e)
{
ObjectQuery <tblScheduler> SchedulerObjs;
string strWhere;
string orderBy;
string taskName;
taskName = rtxtTaskName.Text.Trim() + "-CreateSD";
if (taskName != null && taskName != string.Empty)
{
strWhere = " and it.TaskName='" + taskName + "'";
orderBy = "it.ScheduleID desc";
BLL_ScheduleTasks = new ScheduleTasksBLL();
SchedulerObjs = BLL_ScheduleTasks.GetSchedulers(strWhere, orderBy);
if (this.KeyId != string.Empty)
{
if (SchedulerObjs.Count() > 1)//编辑的时候包括自己
{
MessageBox(false, true, false,
GetGlobalResourceObject("WebResource", "TaskDetailForm_lnkMessage_ErrorMessage").ToString());
return(false);
}
else
{
pnlMessage.Visible = false;
}
}
else
{
if (SchedulerObjs.Count() > 0)
{
MessageBox(false, true, false,
GetGlobalResourceObject("WebResource", "TaskDetailForm_lnkMessage_ErrorMessage").ToString());
return(false);
}
else
{
pnlMessage.Visible = false;
}
}
}
return(true);
}
protected Boolean JudgeRunTime(string startDate, string endDate)
{
string strWhere;
string orderBy;
ObjectQuery <tblScheduler> SchedulerObjs;
BLL_ScheduleTasks = new ScheduleTasksBLL();
//检测新建Task的起始时间段内，不包含旧的Task时间
strWhere = " and it.RunOnlyStart>=cast('" + startDate + "' as System.DateTime) and it.RunOnlyStart<=cast('" + endDate + "' as System.DateTime)";
orderBy = "it.TaskName desc";
SchedulerObjs = BLL_ScheduleTasks.GetSchedulers(strWhere, orderBy);
if (this.KeyId == string.Empty)//插入验证
{
if (SchedulerObjs.Count() > 0)
{
MessageBox(false, true, false,
GetGlobalResourceObject("WebResource", "TaskDetailForm_rdEndTime_Message").ToString());
return(false);
}
}
else
{
if (SchedulerObjs.Count() > 1)//更新验证
{
MessageBox(false, true, false,
GetGlobalResourceObject("WebResource", "TaskDetailForm_rdEndTime_Message").ToString());
return(false);
}
}
strWhere = " and it.RunOnlyEnd>=cast('" + startDate + "' as System.DateTime) and it.RunOnlyEnd<=cast('" + endDate + "' as System.DateTime)";
orderBy = "it.TaskName desc";
SchedulerObjs = BLL_ScheduleTasks.GetSchedulers(strWhere, orderBy);
if (this.KeyId == string.Empty)//插入验证
{
if (SchedulerObjs.Count() > 0)
{
MessageBox(false, true, false,
GetGlobalResourceObject("WebResource", "TaskDetailForm_rdEndTime_Message").ToString());
return(false);
}
}
else
{
if (SchedulerObjs.Count() > 1)//更新验证
{
MessageBox(false, true, false,
GetGlobalResourceObject("WebResource", "TaskDetailForm_rdEndTime_Message").ToString());
return(false);
}
}
//检测旧Task的起始时间段内，不包含的新建Task时间
strWhere = " and it.RunOnlyStart<=cast('" + startDate + "' as System.DateTime) and it.RunOnlyEnd>=cast('" + startDate + "' as System.DateTime)";
orderBy = "it.TaskName desc";
SchedulerObjs = BLL_ScheduleTasks.GetSchedulers(strWhere, orderBy);
if (this.KeyId == string.Empty)//插入验证
{
if (SchedulerObjs.Count() > 0)
{
MessageBox(false, true, false,
GetGlobalResourceObject("WebResource", "TaskDetailForm_rdEndTime_Message").ToString());
return(false);
}
}
else
{
if (SchedulerObjs.Count() > 1)//更新验证
{
MessageBox(false, true, false,
GetGlobalResourceObject("WebResource", "TaskDetailForm_rdEndTime_Message").ToString());
return(false);
}
}
strWhere = " and it.RunOnlyStart<=cast('" + endDate + "' as System.DateTime) and it.RunOnlyEnd>=cast('" + endDate + "' as System.DateTime)";
orderBy = "it.TaskName desc";
SchedulerObjs = BLL_ScheduleTasks.GetSchedulers(strWhere, orderBy);
if (this.KeyId == string.Empty)//插入验证
{
if (SchedulerObjs.Count() > 0)
{
MessageBox(false, true, false,
GetGlobalResourceObject("WebResource", "TaskDetailForm_rdEndTime_Message").ToString());
return(false);
}
}
else
{
if (SchedulerObjs.Count() > 1)//更新验证
{
MessageBox(false, true, false,
GetGlobalResourceObject("WebResource", "TaskDetailForm_rdEndTime_Message").ToString());
return(false);
}
}
return(true);
}
public void GridViewDataBinding()
{
Boolean isExtit;
StringBuilder jobExpetion;
this.OrderBy = " it.StartTime desc ";
string whereStr;
whereStr = "";
BLL_ScheduleTasks = new ScheduleTasksBLL();
SchedulerObjList = BLL_ScheduleTasks.GetSchedulers(whereStr, OrderBy);//查询SD的job信息
BLL_vSysJobs = new vSysJobsBLL();
if (SchedulerObjList.Count() > 0)
{
BLL_ScheduleLog = new vScheduleLogBLL();
TasksTempList = new List <TasksTemp>();
foreach (tblScheduler item in SchedulerObjList)
{
this.OrderBy = " it.name desc";
whereStr = " and it.name='" + item.TaskName + "'";
vSysJobsObjs = BLL_vSysJobs.GetVSysJobs(whereStr, this.OrderBy);
if (vSysJobsObjs.Count() > 0)
{//job存在
foreach (vSchedulerTasks Temp in vSysJobsObjs)
{
TasksTempObj = new TasksTemp();
TasksTempObj.ScheduleID = item.ScheduleID;
TasksTempObj.TaskName = item.TaskName.Substring(0, item.TaskName.LastIndexOf("-"));//截取-CreateSD;
TasksTempObj.ScheduleType = item.ScheduleType;
TasksTempObj.Enable = Temp.enabled;
if (TasksTempObj.Enable.Equals(1))
{//job运行
TasksTempObj.StatusImageURL = GetGlobalResourceObject("WebResource", "ScheduleTasksForm_CustomerMessage_Message").ToString();
TasksTempObj.Status = "Enable";
}
else
{//job停止运行
TasksTempObj.StatusImageURL = GetGlobalResourceObject("WebResource", "ScheduleTasksForm_CustomerMessage_Message").ToString();
TasksTempObj.Status = "Disable";
}
TasksTempObj.Next_run_date = Temp.RunOnlyEnd.ToString();
TasksTempObj.Last_run_date = Temp.RunOnlyStart.ToString();
TasksTempObj.LogResult = BLL_ScheduleLog.FindJobResultByScheduleId(
item.ScheduleID.ToString(),
item.RunOnlyStart.ToString(),
item.RunOnlyEnd.ToString());
}
TasksTempList.Add(TasksTempObj);
}
else
{//job不存在
TasksTempObj = new TasksTemp();
TasksTempObj.ScheduleID = item.ScheduleID;
TasksTempObj.TaskName = item.TaskName.Substring(0, item.TaskName.LastIndexOf("-"));//截取-CreateSD;;
TasksTempObj.ScheduleType = item.ScheduleType;
TasksTempObj.StatusImageURL = GetGlobalResourceObject("WebResource", "ScheduleTasksForm_CustomerMessage_Message").ToString();
TasksTempObj.Status = "Disable";
TasksTempList.Add(TasksTempObj);
}
}
}
this.OrderBy = " it.name desc";
whereStr = "";
vOnlyJobsObjs = BLL_vSysJobs.GetVOnlyJobs(whereStr, this.OrderBy);//查询job的系统信息
jobExpetion = new StringBuilder();
foreach (vOnlySysJobs job in vOnlyJobsObjs)
{
isExtit = SchedulerObjList.Any(it => it.TaskName == job.name); //在SD中是否存在相应的Taskname
if (!isExtit) //不存在
{
if (job.name.IndexOf("-CreateSD") > 0) //是否SD创建
{
pnlMessage.Visible = true; //显示提示信息
//在系统中存在为-CreateSD结尾的job但是在SD数据库中不存在
if (jobExpetion.ToString() == string.Empty)
{
jobExpetion.Append("Job Excepetion:" + " ");
jobExpetion.Append("\"" + job.name + "\"");
}
else
{
jobExpetion.Append(",\"" + job.name + "\"");
}
}
}
}
if (pnlMessage.Visible == true && SuccessFlag == null)//显示异常job信息
{
jobExpetion.Append(" ");
jobExpetion.Append(GetGlobalResourceObject("WebResource", "ScheduleTasksForm_JobExcepeciton_Message").ToString());
MessageBox(false, true, false,
jobExpetion.ToString());
}
else
{
pnlMessage.Visible = false;
}
RadGrid.DataSource = TasksTempList;
}
