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);
}
