public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
PageUtils.CheckRequestParameter("ServiceType");
_serviceType = EServiceTypeUtils.GetEnumType(Body.GetQueryString("ServiceType"));
if (Body.IsQueryExists("Delete"))
{
var taskId = Body.GetQueryInt("TaskID");
try
{
DataProvider.TaskDao.Delete(taskId);
SuccessDeleteMessage();
}
catch (Exception ex)
{
FailDeleteMessage(ex);
}
}
if (Body.IsQueryExists("Enabled"))
{
var taskId = Body.GetQueryInt("TaskID");
var isEnabled = Body.GetQueryBool("IsEnabled");
var func = isEnabled ? "启用" : "禁用";
try
{
DataProvider.TaskDao.UpdateState(taskId, isEnabled);
SuccessMessage($"{func}定时任务成功。");
}
catch (Exception ex)
{
FailMessage(ex, $"{func}定时任务失败。");
}
}
if (!IsPostBack)
{
var taskName = EServiceTypeUtils.GetText(_serviceType);
if (PublishmentSystemId > 0)
{
BreadCrumb(AppManager.Cms.LeftMenu.IdConfigration, AppManager.Cms.LeftMenu.Configuration.IdConfigurationTask, taskName + "任务", AppManager.Cms.Permission.WebSite.Configration);
}
else
{
BreadCrumbService(AppManager.Service.LeftMenu.Task, taskName + "任务", AppManager.Service.Permission.ServiceTask);
}
AddTask.Text = $"添加{taskName}任务";
AddTask.Attributes.Add("onclick", ModalTaskAdd.GetOpenWindowStringToAdd(_serviceType, PublishmentSystemId));
BindGrid();
}
}
public List <TaskInfo> GetAllTaskInfoList()
{
var list = new List <TaskInfo>();
const string sqlString = "SELECT TaskID, TaskName, IsSystemTask, PublishmentSystemID, ServiceType, ServiceParameters, FrequencyType, PeriodIntervalMinute, StartDay, StartWeekday, StartHour, IsEnabled, AddDate, LastExecuteDate, Description, OnlyOnceDate FROM siteserver_Task";
using (var rdr = ExecuteReader(sqlString))
{
while (rdr.Read())
{
var i = 0;
var info = new TaskInfo(GetInt(rdr, i++), GetString(rdr, i++), GetBool(rdr, i++), GetInt(rdr, i++), EServiceTypeUtils.GetEnumType(GetString(rdr, i++)), GetString(rdr, i++), EFrequencyTypeUtils.GetEnumType(GetString(rdr, i++)), GetInt(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i++), GetBool(rdr, i++), GetDateTime(rdr, i++), GetDateTime(rdr, i++), GetString(rdr, i++), GetDateTime(rdr, i));
list.Add(info);
}
rdr.Close();
}
return(list);
}
public List <TaskInfo> GetTaskInfoList(EServiceType serviceType, int publishmentSystemId)
{
var list = new List <TaskInfo>();
const string sqlString = "SELECT TaskID, TaskName, IsSystemTask, PublishmentSystemID, ServiceType, ServiceParameters, FrequencyType, PeriodIntervalMinute, StartDay, StartWeekday, StartHour, IsEnabled, AddDate, LastExecuteDate, Description, OnlyOnceDate FROM siteserver_Task WHERE ServiceType = @ServiceType AND PublishmentSystemID = @PublishmentSystemID";
var parms = new IDataParameter[]
{
GetParameter(ParmServiceType, EDataType.VarChar, 50, EServiceTypeUtils.GetValue(serviceType)),
GetParameter(ParmPublishmentSystemId, EDataType.Integer, publishmentSystemId)
};
using (var rdr = ExecuteReader(sqlString, parms))
{
while (rdr.Read())
{
var i = 0;
var info = new TaskInfo(GetInt(rdr, i++), GetString(rdr, i++), GetBool(rdr, i++), GetInt(rdr, i++), EServiceTypeUtils.GetEnumType(GetString(rdr, i++)), GetString(rdr, i++), EFrequencyTypeUtils.GetEnumType(GetString(rdr, i++)), GetInt(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i++), GetBool(rdr, i++), GetDateTime(rdr, i++), GetDateTime(rdr, i++), GetString(rdr, i++), GetDateTime(rdr, i));
list.Add(info);
}
rdr.Close();
}
return(list);
}
public TaskInfo GetTaskInfo(int taskId)
{
TaskInfo info = null;
var parms = new IDataParameter[]
{
GetParameter(ParmTaskId, EDataType.Integer, taskId)
};
using (var rdr = ExecuteReader(SqlSelectById, parms))
{
if (rdr.Read())
{
var i = 0;
info = new TaskInfo(GetInt(rdr, i++), GetString(rdr, i++), GetBool(rdr, i++), GetInt(rdr, i++), EServiceTypeUtils.GetEnumType(GetString(rdr, i++)), GetString(rdr, i++), EFrequencyTypeUtils.GetEnumType(GetString(rdr, i++)), GetInt(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i++), GetBool(rdr, i++), GetDateTime(rdr, i++), GetDateTime(rdr, i++), GetString(rdr, i++), GetDateTime(rdr, i));
}
rdr.Close();
}
return(info);
}
public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
_serviceType = EServiceTypeUtils.GetEnumType(Body.GetQueryString("ServiceType"));
if (!IsPostBack)
{
EFrequencyTypeUtils.AddListItems(FrequencyType, false);
for (var i = 1; i < 32; i++)
{
StartDay.Items.Add(new ListItem(i + "日", i.ToString()));
}
for (var i = 1; i < 8; i++)
{
var weekName = string.Empty;
if (i == 1)
{
weekName = "星期一";
}
else if (i == 2)
{
weekName = "星期二";
}
else if (i == 3)
{
weekName = "星期三";
}
else if (i == 4)
{
weekName = "星期四";
}
else if (i == 5)
{
weekName = "星期五";
}
else if (i == 6)
{
weekName = "星期六";
}
else if (i == 7)
{
weekName = "星期日";
}
StartWeekday.Items.Add(new ListItem(weekName, i.ToString()));
}
for (var i = 0; i < 24; i++)
{
StartHour.Items.Add(new ListItem(i + "点", i.ToString()));
}
var listItem = new ListItem("周", "5040");
PeriodIntervalType.Items.Add(listItem);
listItem = new ListItem("天", "720");
PeriodIntervalType.Items.Add(listItem);
listItem = new ListItem("小时", "12");
PeriodIntervalType.Items.Add(listItem);
listItem = new ListItem("分钟", "1");
listItem.Selected = true;
PeriodIntervalType.Items.Add(listItem);
if (_serviceType == EServiceType.Create)
{
PlaceHolder_Create.Visible = true;
if (PublishmentSystemId != 0)
{
NodeManager.AddListItems(CreateChannelIDCollection.Items, PublishmentSystemInfo, false, true, Body.AdministratorName);
}
else
{
var arraylist = PublishmentSystemManager.GetPublishmentSystemIdList();
foreach (int publishmentSystemID in arraylist)
{
var publishmentSystemInfo = PublishmentSystemManager.GetPublishmentSystemInfo(publishmentSystemID);
var item = new ListItem(publishmentSystemInfo.PublishmentSystemName, publishmentSystemInfo.PublishmentSystemId.ToString());
CreateChannelIDCollection.Items.Add(item);
}
}
ECreateTypeUtils.AddListItems(CreateCreateTypes);
}
else if (_serviceType == EServiceType.Gather)
{
PlaceHolder_Gather.Visible = true;
if (PublishmentSystemId != 0)
{
var gatherRuleNameArrayList = DataProvider.GatherRuleDao.GetGatherRuleNameArrayList(PublishmentSystemId);
var gatherTypeValue = EGatherTypeUtils.GetValue(EGatherType.Web);
var gatherTypeText = EGatherTypeUtils.GetText(EGatherType.Web);
foreach (string gatherName in gatherRuleNameArrayList)
{
GatherListBox.Items.Add(new ListItem(gatherName + "(" + gatherTypeText + ")", gatherTypeValue + "_" + gatherName));
}
gatherRuleNameArrayList = DataProvider.GatherDatabaseRuleDao.GetGatherRuleNameArrayList(PublishmentSystemId);
gatherTypeValue = EGatherTypeUtils.GetValue(EGatherType.Database);
gatherTypeText = EGatherTypeUtils.GetText(EGatherType.Database);
foreach (string gatherName in gatherRuleNameArrayList)
{
GatherListBox.Items.Add(new ListItem(gatherName + "(" + gatherTypeText + ")", gatherTypeValue + "_" + gatherName));
}
gatherRuleNameArrayList = DataProvider.GatherFileRuleDao.GetGatherRuleNameArrayList(PublishmentSystemId);
gatherTypeValue = EGatherTypeUtils.GetValue(EGatherType.File);
gatherTypeText = EGatherTypeUtils.GetText(EGatherType.File);
foreach (string gatherName in gatherRuleNameArrayList)
{
GatherListBox.Items.Add(new ListItem(gatherName + "(" + gatherTypeText + ")", gatherTypeValue + "_" + gatherName));
}
GatherHelp.Text = "选择需要定时执行的采集名称";
}
else
{
var arraylist = PublishmentSystemManager.GetPublishmentSystemIdList();
foreach (int publishmentSystemID in arraylist)
{
var publishmentSystemInfo = PublishmentSystemManager.GetPublishmentSystemInfo(publishmentSystemID);
var item = new ListItem(publishmentSystemInfo.PublishmentSystemName, publishmentSystemInfo.PublishmentSystemId.ToString());
GatherListBox.Items.Add(item);
}
GatherHelp.Text = "选择需要定时采集的站点";
}
}
else if (_serviceType == EServiceType.Backup)
{
PlaceHolder_Backup.Visible = true;
if (PublishmentSystemId != 0)
{
PlaceHolder_Backup_PublishmentSystem.Visible = false;
}
else
{
PlaceHolder_Backup_PublishmentSystem.Visible = true;
var arraylist = PublishmentSystemManager.GetPublishmentSystemIdList();
foreach (int publishmentSystemID in arraylist)
{
var publishmentSystemInfo = PublishmentSystemManager.GetPublishmentSystemInfo(publishmentSystemID);
var item = new ListItem(publishmentSystemInfo.PublishmentSystemName, publishmentSystemInfo.PublishmentSystemId.ToString());
BackupPublishmentSystemIDCollection.Items.Add(item);
}
}
EBackupTypeUtils.AddListItems(BackupType);
}
if (Body.IsQueryExists("TaskID"))
{
var taskId = Body.GetQueryInt("TaskID");
var taskInfo = DataProvider.TaskDao.GetTaskInfo(taskId);
if (taskInfo != null)
{
TaskName.Text = taskInfo.TaskName;
TaskName.Enabled = false;
ControlUtils.SelectListItems(FrequencyType, EFrequencyTypeUtils.GetValue(taskInfo.FrequencyType));
ControlUtils.SelectListItems(StartDay, taskInfo.StartDay.ToString());
ControlUtils.SelectListItems(StartWeekday, taskInfo.StartWeekday.ToString());
ControlUtils.SelectListItems(StartHour, taskInfo.StartHour.ToString());
if (taskInfo.PeriodIntervalMinute % 5040 == 0)
{
PeriodInterval.Text = Convert.ToInt32(taskInfo.PeriodIntervalMinute / 5040).ToString();
ControlUtils.SelectListItems(PeriodIntervalType, "5040");
}
else if (taskInfo.PeriodIntervalMinute % 720 == 0)
{
PeriodInterval.Text = Convert.ToInt32(taskInfo.PeriodIntervalMinute / 720).ToString();
ControlUtils.SelectListItems(PeriodIntervalType, "720");
}
else if (taskInfo.PeriodIntervalMinute % 12 == 0)
{
PeriodInterval.Text = Convert.ToInt32(taskInfo.PeriodIntervalMinute / 12).ToString();
ControlUtils.SelectListItems(PeriodIntervalType, "12");
}
else
{
PeriodInterval.Text = taskInfo.PeriodIntervalMinute.ToString();
ControlUtils.SelectListItems(PeriodIntervalType, "1");
}
Description.Text = taskInfo.Description;
if (_serviceType == EServiceType.Create)
{
var taskCreateInfo = new TaskCreateInfo(taskInfo.ServiceParameters);
if (taskCreateInfo.IsCreateAll)
{
foreach (ListItem item in CreateChannelIDCollection.Items)
{
item.Selected = true;
}
CreateIsCreateAll.Checked = true;
}
else
{
var channelIdList = TranslateUtils.StringCollectionToStringList(taskCreateInfo.ChannelIDCollection);
ControlUtils.SelectListItems(CreateChannelIDCollection, channelIdList);
CreateIsCreateAll.Checked = false;
}
var createTypeArrayList = TranslateUtils.StringCollectionToStringList(taskCreateInfo.CreateTypes);
foreach (ListItem item in CreateCreateTypes.Items)
{
if (createTypeArrayList.Contains(item.Value))
{
item.Selected = true;
}
else
{
item.Selected = false;
}
}
}
else if (_serviceType == EServiceType.Gather)
{
var taskGatherInfo = new TaskGatherInfo(taskInfo.ServiceParameters);
if (PublishmentSystemId != 0)
{
var webGatherNames = TranslateUtils.StringCollectionToStringList(taskGatherInfo.WebGatherNames);
var databaseGatherNames = TranslateUtils.StringCollectionToStringList(taskGatherInfo.DatabaseGatherNames);
var fileGatherNames = TranslateUtils.StringCollectionToStringList(taskGatherInfo.FileGatherNames);
foreach (ListItem item in GatherListBox.Items)
{
var gatherType = EGatherTypeUtils.GetEnumType(item.Value.Split('_')[0]);
var gatherName = item.Value.Substring(item.Value.Split('_')[0].Length + 1);
if (gatherType == EGatherType.Web && webGatherNames.Contains(gatherName))
{
item.Selected = true;
}
else if (gatherType == EGatherType.Database && databaseGatherNames.Contains(gatherName))
{
item.Selected = true;
}
else if (gatherType == EGatherType.File && fileGatherNames.Contains(gatherName))
{
item.Selected = true;
}
}
}
else
{
var publishmentSystemIdList = TranslateUtils.StringCollectionToStringList(taskGatherInfo.PublishmentSystemIDCollection);
ControlUtils.SelectListItems(GatherListBox, publishmentSystemIdList);
}
}
else if (_serviceType == EServiceType.Backup)
{
var taskBackupInfo = new TaskBackupInfo(taskInfo.ServiceParameters);
if (taskInfo.PublishmentSystemID == 0)
{
if (taskBackupInfo.IsBackupAll)
{
foreach (ListItem item in BackupPublishmentSystemIDCollection.Items)
{
item.Selected = true;
}
BackupIsBackupAll.Checked = true;
}
else
{
var publishmentSystemIdList = TranslateUtils.StringCollectionToStringList(taskBackupInfo.PublishmentSystemIDCollection);
ControlUtils.SelectListItems(BackupPublishmentSystemIDCollection, publishmentSystemIdList);
BackupIsBackupAll.Checked = false;
}
}
else
{
ControlUtils.SelectListItems(BackupPublishmentSystemIDCollection, taskInfo.PublishmentSystemID.ToString());
}
ControlUtils.SelectListItems(BackupType, EBackupTypeUtils.GetValue(taskBackupInfo.BackupType));
}
}
}
FrequencyType_SelectedIndexChanged(null, EventArgs.Empty);
}
}
