public void Update(TaskInfo info)
{
var updateParms = new IDataParameter[]
{
GetParameter(ParmTaskName, EDataType.NVarChar, 50, info.TaskName),
GetParameter(ParmIsSystemTask, EDataType.VarChar, 18, info.IsSystemTask.ToString()),
GetParameter(ParmPublishmentSystemId, EDataType.Integer, info.PublishmentSystemID),
GetParameter(ParmServiceType, EDataType.VarChar, 50, EServiceTypeUtils.GetValue(info.ServiceType)),
GetParameter(ParmServiceParameters, EDataType.NText, info.ServiceParameters),
GetParameter(ParmFrequencyType, EDataType.VarChar, 50, EFrequencyTypeUtils.GetValue(info.FrequencyType)),
GetParameter(ParmPeriodIntervalMinute, EDataType.Integer, info.PeriodIntervalMinute),
GetParameter(ParmStartDay, EDataType.Integer, info.StartDay),
GetParameter(ParmStartWeekday, EDataType.Integer, info.StartWeekday),
GetParameter(ParmStartHour, EDataType.Integer, info.StartHour),
GetParameter(ParmIsEnabled, EDataType.VarChar, 18, info.IsEnabled.ToString()),
GetParameter(ParmAddDate, EDataType.DateTime, info.AddDate),
GetParameter(ParmLastExecuteDate, EDataType.DateTime, info.LastExecuteDate),
GetParameter(ParmDescription, EDataType.NVarChar, 255, info.Description),
GetParameter(ParmTaskId, EDataType.Integer, info.TaskID),
GetParameter(ParmOnlyOnceDate, EDataType.DateTime, info.OnlyOnceDate)
};
ExecuteNonQuery(SqlUpdateTask, updateParms);
ServiceManager.ClearTaskCache();
}
public static string GetRedirectUrl(int publishmentSystemId, EServiceType serviceType)
{
return(PageUtils.GetCmsUrl(nameof(PageTask), new NameValueCollection
{
{ "PublishmentSystemID", publishmentSystemId.ToString() },
{ "ServiceType", EServiceTypeUtils.GetValue(serviceType) }
}));
}
public static string GetOpenWindowStringToAdd(EServiceType serviceType, int publishmentSystemId)
{
return(PageUtils.GetOpenWindowString("添加任务", PageUtils.GetCmsUrl(nameof(ModalTaskAdd), new NameValueCollection
{
{ "ServiceType", EServiceTypeUtils.GetValue(serviceType) },
{ "PublishmentSystemID", publishmentSystemId.ToString() }
})));
}
public void DeleteSystemTask(int publishmentSystemId, EServiceType serviceType)
{
const string sqlString = "DELETE FROM siteserver_Task WHERE PublishmentSystemID = @PublishmentSystemID AND IsSystemTask = @IsSystemTask AND ServiceType = @ServiceType";
var parms = new IDataParameter[]
{
GetParameter(ParmPublishmentSystemId, EDataType.Integer, publishmentSystemId),
GetParameter(ParmIsSystemTask, EDataType.VarChar, 18, true.ToString()),
GetParameter(ParmServiceType, EDataType.VarChar, 50, EServiceTypeUtils.GetValue(serviceType))
};
ExecuteNonQuery(sqlString, parms);
ServiceManager.ClearTaskCache();
}
private void DgContents_ItemDataBound(object sender, DataGridItemEventArgs e)
{
if (e.Item.ItemType != ListItemType.Item && e.Item.ItemType != ListItemType.AlternatingItem)
{
return;
}
var taskInfo = (TaskInfo)e.Item.DataItem;
var ltlSite = (Literal)e.Item.FindControl("ltlSite");
var ltlTaskName = (Literal)e.Item.FindControl("ltlTaskName");
var ltlIsEnabled = (Literal)e.Item.FindControl("ltlIsEnabled");
var ltlFrequencyType = (Literal)e.Item.FindControl("ltlFrequencyType");
var ltlLastExecuteDate = (Literal)e.Item.FindControl("ltlLastExecuteDate");
var ltlEditHtml = (Literal)e.Item.FindControl("ltlEditHtml");
var ltlEnabledHtml = (Literal)e.Item.FindControl("ltlEnabledHtml");
var ltlDeleteHtml = (Literal)e.Item.FindControl("ltlDeleteHtml");
if (ltlSite != null)
{
ltlSite.Text = GetSiteHtml(taskInfo.PublishmentSystemID);
}
ltlTaskName.Text = taskInfo.TaskName;
ltlIsEnabled.Text = StringUtils.GetTrueOrFalseImageHtml(taskInfo.IsEnabled.ToString());
ltlFrequencyType.Text = EFrequencyTypeUtils.GetText(taskInfo.FrequencyType);
if (taskInfo.LastExecuteDate > DateUtils.SqlMinValue)
{
ltlLastExecuteDate.Text = DateUtils.GetDateAndTimeString(taskInfo.LastExecuteDate);
}
if (!taskInfo.IsSystemTask)
{
ltlEditHtml.Text = GetEditHtml(taskInfo.TaskID, taskInfo.PublishmentSystemID);
ltlDeleteHtml.Text = GetDeleteHtml(taskInfo.TaskID, taskInfo.TaskName, taskInfo.PublishmentSystemID);
}
var urlTask = PageUtils.GetCmsUrl(nameof(PageTask), new NameValueCollection
{
{ "PublishmentSystemID", taskInfo.PublishmentSystemID.ToString() },
{ "TaskID", taskInfo.TaskID.ToString() },
{ "ServiceType", EServiceTypeUtils.GetValue(taskInfo.ServiceType) },
{ "Enabled", true.ToString() },
{ "IsEnabled", (!taskInfo.IsEnabled).ToString() }
});
ltlEnabledHtml.Text =
$"<a href=\"{urlTask}\" onClick=\"javascript:return confirm('此操作将{(taskInfo.IsEnabled ? "禁用" : "启用")}任务“{taskInfo.TaskName}”，确认吗？');\">{(taskInfo.IsEnabled ? "禁用" : "启用")}</a>";
}
private string GetDeleteHtml(int taskId, string taskName, int publishmentSystemId)
{
if (PublishmentSystemId != 0 && publishmentSystemId != PublishmentSystemId)
{
return(string.Empty);
}
var urlDelete = PageUtils.GetCmsUrl(nameof(PageTask), new NameValueCollection
{
{ "PublishmentSystemID", PublishmentSystemId.ToString() },
{ "TaskID", taskId.ToString() },
{ "ServiceType", EServiceTypeUtils.GetValue(_serviceType) },
{ "Delete", true.ToString() }
});
return
($"<a href=\"{urlDelete}\" onClick=\"javascript:return confirm('此操作将删除{EServiceTypeUtils.GetText(_serviceType)}任务“{taskName}”，确认吗？');\">删除</a>");
}
public int Insert(TaskInfo info)
{
int id;
const string sqlString = "INSERT INTO siteserver_Task (TaskName, IsSystemTask, PublishmentSystemID, ServiceType, ServiceParameters, FrequencyType, PeriodIntervalMinute, StartDay, StartWeekday, StartHour, IsEnabled, AddDate, LastExecuteDate, Description, OnlyOnceDate) VALUES (@TaskName, @IsSystemTask, @PublishmentSystemID, @ServiceType, @ServiceParameters, @FrequencyType, @PeriodIntervalMinute, @StartDay, @StartWeekday, @StartHour, @IsEnabled, @AddDate, @LastExecuteDate, @Description, @OnlyOnceDate)";
var parms = new IDataParameter[]
{
GetParameter(ParmTaskName, EDataType.NVarChar, 50, info.TaskName),
GetParameter(ParmIsSystemTask, EDataType.VarChar, 18, info.IsSystemTask.ToString()),
GetParameter(ParmPublishmentSystemId, EDataType.Integer, info.PublishmentSystemID),
GetParameter(ParmServiceType, EDataType.VarChar, 50, EServiceTypeUtils.GetValue(info.ServiceType)),
GetParameter(ParmServiceParameters, EDataType.NText, info.ServiceParameters),
GetParameter(ParmFrequencyType, EDataType.VarChar, 50, EFrequencyTypeUtils.GetValue(info.FrequencyType)),
GetParameter(ParmPeriodIntervalMinute, EDataType.Integer, info.PeriodIntervalMinute),
GetParameter(ParmStartDay, EDataType.Integer, info.StartDay),
GetParameter(ParmStartWeekday, EDataType.Integer, info.StartWeekday),
GetParameter(ParmStartHour, EDataType.Integer, info.StartHour),
GetParameter(ParmIsEnabled, EDataType.VarChar, 18, info.IsEnabled.ToString()),
GetParameter(ParmAddDate, EDataType.DateTime, info.AddDate),
GetParameter(ParmLastExecuteDate, EDataType.DateTime, info.LastExecuteDate),
GetParameter(ParmDescription, EDataType.NVarChar, 255, info.Description),
GetParameter(ParmOnlyOnceDate, EDataType.DateTime, info.OnlyOnceDate)
};
using (var conn = GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
id = ExecuteNonQueryAndReturnId(trans, sqlString, parms);
ServiceManager.ClearTaskCache();
trans.Commit();
}
catch (Exception)
{
trans.Rollback();
throw;
}
}
}
return(id);
}
public List <int> GetTaskIdList(EServiceType serviceType)
{
var list = new List <int>();
const string sqlString = "SELECT TaskID FROM siteserver_Task WHERE ServiceType = @ServiceType";
var parms = new IDataParameter[]
{
GetParameter(ParmServiceType, EDataType.VarChar, 50, EServiceTypeUtils.GetValue(serviceType))
};
using (var rdr = ExecuteReader(sqlString, parms))
{
while (rdr.Read())
{
list.Add(GetInt(rdr, 0));
}
rdr.Close();
}
return(list);
}
public List <TaskInfo> GetTaskInfoList(EServiceType serviceType)
{
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";
var parms = new IDataParameter[]
{
GetParameter(ParmServiceType, EDataType.VarChar, 50, EServiceTypeUtils.GetValue(serviceType))
};
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 bool IsSystemTaskExists(int publishmentSystemId, EServiceType serviceType)
{
var exists = false;
const string sqlString = "SELECT TaskID FROM siteserver_Task WHERE PublishmentSystemID = @PublishmentSystemID AND IsSystemTask = @IsSystemTask AND ServiceType = @ServiceType";
var parms = new IDataParameter[]
{
GetParameter(ParmPublishmentSystemId, EDataType.Integer, publishmentSystemId),
GetParameter(ParmIsSystemTask, EDataType.VarChar, 18, true.ToString()),
GetParameter(ParmServiceType, EDataType.VarChar, 50, EServiceTypeUtils.GetValue(serviceType))
};
using (var rdr = ExecuteReader(sqlString, parms))
{
if (rdr.Read() && !rdr.IsDBNull(0))
{
exists = true;
}
rdr.Close();
}
return(exists);
}
