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