public List <CreateTaskLogInfo> GetList(int publishmentSystemId, int totalNum) { var list = new List <CreateTaskLogInfo>(); if (publishmentSystemId > 0) { //string sqlString = // $"SELECT TOP {totalNum} ID, CreateType, PublishmentSystemID, TaskName, TimeSpan, IsSuccess, ErrorMessage, AddDate FROM siteserver_CreateTaskLog WHERE PublishmentSystemID = @PublishmentSystemID"; string sqlString = SqlUtils.GetTopSqlString("siteserver_CreateTaskLog", "ID, CreateType, PublishmentSystemID, TaskName, TimeSpan, IsSuccess, ErrorMessage, AddDate", "WHERE PublishmentSystemID = @PublishmentSystemID", totalNum); var parms = new IDataParameter[] { GetParameter(ParmPublishmentSystemId, EDataType.Integer, publishmentSystemId) }; using (var rdr = ExecuteReader(sqlString, parms)) { while (rdr.Read()) { var i = 0; var info = new CreateTaskLogInfo(GetInt(rdr, i++), ECreateTypeUtils.GetEnumType(GetString(rdr, i++)), GetInt(rdr, i++), GetString(rdr, i++), GetString(rdr, i++), GetBool(rdr, i++), GetString(rdr, i++), GetDateTime(rdr, i)); list.Add(info); } rdr.Close(); } } else { //string sqlString = // $"SELECT TOP {totalNum} ID, CreateType, PublishmentSystemID, TaskName, TimeSpan, IsSuccess, ErrorMessage, AddDate FROM siteserver_CreateTaskLog"; var sqlString = SqlUtils.GetTopSqlString("siteserver_CreateTaskLog", "ID, CreateType, PublishmentSystemID, TaskName, TimeSpan, IsSuccess, ErrorMessage, AddDate", string.Empty, totalNum); using (var rdr = ExecuteReader(sqlString)) { while (rdr.Read()) { var i = 0; var info = new CreateTaskLogInfo(GetInt(rdr, i++), ECreateTypeUtils.GetEnumType(GetString(rdr, i++)), GetInt(rdr, i++), GetString(rdr, i++), GetString(rdr, i++), GetBool(rdr, i++), GetString(rdr, i++), GetDateTime(rdr, i)); list.Add(info); } rdr.Close(); } } return(list); }
public List <CreateTaskInfo> GetList(int publishmentSystemId, int totalNum) { var list = new List <CreateTaskInfo>(); if (publishmentSystemId > 0) { //string sqlString = // $"SELECT TOP {totalNum} ID, CreateType, PublishmentSystemID, ChannelID, ContentID, TemplateID FROM siteserver_CreateTask WHERE PublishmentSystemID = @PublishmentSystemID ORDER BY ID DESC"; var sqlString = SqlUtils.GetTopSqlString("siteserver_CreateTask", "ID, CreateType, PublishmentSystemID, ChannelID, ContentID, TemplateID", "WHERE PublishmentSystemID = @PublishmentSystemID ORDER BY ID DESC", totalNum); var parms = new IDataParameter[] { GetParameter(ParmPublishmentSystemId, EDataType.Integer, publishmentSystemId) }; using (var rdr = ExecuteReader(sqlString, parms)) { while (rdr.Read()) { var i = 0; var info = new CreateTaskInfo(GetInt(rdr, i++), ECreateTypeUtils.GetEnumType(GetString(rdr, i++)), GetInt(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i)); list.Add(info); } rdr.Close(); } } else { //string sqlString = // $"SELECT TOP {totalNum} ID, CreateType, PublishmentSystemID, ChannelID, ContentID, TemplateID FROM siteserver_CreateTask ORDER BY ID DESC"; var sqlString = SqlUtils.GetTopSqlString("siteserver_CreateTask", "ID, CreateType, PublishmentSystemID, ChannelID, ContentID, TemplateID", "ORDER BY ID DESC", totalNum); using (var rdr = ExecuteReader(sqlString)) { while (rdr.Read()) { var i = 0; var info = new CreateTaskInfo(GetInt(rdr, i++), ECreateTypeUtils.GetEnumType(GetString(rdr, i++)), GetInt(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i)); list.Add(info); } rdr.Close(); } } return(list); }
public CreateTaskInfo GetLastPendingTask() { CreateTaskInfo info = null; //var sqlString = "SELECT TOP 1 ID, CreateType, PublishmentSystemID, ChannelID, ContentID, TemplateID FROM siteserver_CreateTask ORDER BY ID"; var sqlString = SqlUtils.GetTopSqlString("siteserver_CreateTask", "ID, CreateType, PublishmentSystemID, ChannelID, ContentID, TemplateID", "ORDER BY ID", 1); using (var rdr = ExecuteReader(sqlString)) { if (rdr.Read()) { var i = 0; info = new CreateTaskInfo(GetInt(rdr, i++), ECreateTypeUtils.GetEnumType(GetString(rdr, i++)), GetInt(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i)); } rdr.Close(); } return(info); }
/// <summary> /// 一次获取多个任务 /// </summary> /// <param name="topNum"></param> /// <returns></returns> public List <CreateTaskInfo> GetLastPendingTasks(int topNum) { List <CreateTaskInfo> list = null; var sqlString = SqlUtils.GetTopSqlString("siteserver_CreateTask", "ID, CreateType, PublishmentSystemID, ChannelID, ContentID, TemplateID", "ORDER BY ID", topNum); using (var rdr = ExecuteReader(sqlString)) { while (rdr.Read()) { var i = 0; var info = new CreateTaskInfo(GetInt(rdr, i++), ECreateTypeUtils.GetEnumType(GetString(rdr, i++)), GetInt(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i)); list.Add(info); } rdr.Close(); } return(list); }
void rptContents_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { var publishmentSystemId = SqlUtils.EvalInt(e.Item.DataItem, "PublishmentSystemID"); var taskName = SqlUtils.EvalString(e.Item.DataItem, "TaskName"); var createType = ECreateTypeUtils.GetEnumType(SqlUtils.EvalString(e.Item.DataItem, "CreateType")); var timeSpan = SqlUtils.EvalString(e.Item.DataItem, "TimeSpan"); var publishmentSystemInfo = PublishmentSystemManager.GetPublishmentSystemInfo(publishmentSystemId); if (publishmentSystemInfo == null) { e.Item.Visible = false; return; } var addDate = SqlUtils.EvalDateTime(e.Item.DataItem, "AddDate"); var isSuccess = SqlUtils.EvalString(e.Item.DataItem, "IsSuccess"); var errorMessage = SqlUtils.EvalString(e.Item.DataItem, "ErrorMessage"); var ltlPublishmentSystem = (Literal)e.Item.FindControl("ltlPublishmentSystem"); var ltlTaskName = (Literal)e.Item.FindControl("ltlTaskName"); var ltlCreateType = (Literal)e.Item.FindControl("ltlCreateType"); var ltlTimeSpan = (Literal)e.Item.FindControl("ltlTimeSpan"); var ltlAddDate = (Literal)e.Item.FindControl("ltlAddDate"); var ltlIsSuccess = (Literal)e.Item.FindControl("ltlIsSuccess"); var ltlErrorMessage = (Literal)e.Item.FindControl("ltlErrorMessage"); ltlPublishmentSystem.Text = publishmentSystemInfo.PublishmentSystemName; ltlTaskName.Text = taskName; ltlTimeSpan.Text = timeSpan; ltlCreateType.Text = ECreateTypeUtils.GetText(createType); ltlAddDate.Text = DateUtils.GetDateAndTimeString(addDate); ltlIsSuccess.Text = StringUtils.GetTrueOrFalseImageHtml(isSuccess); ltlErrorMessage.Text = errorMessage; } }
public void GetCount(int publishmentSystemId, out int indexCount, out int channelsCount, out int contentsCount, out int filesCount) { indexCount = 0; channelsCount = 0; contentsCount = 0; filesCount = 0; if (publishmentSystemId > 0) { const string sqlString = "SELECT COUNT(*) AS TOTAL, CreateType FROM siteserver_CreateTask WHERE PublishmentSystemID = @PublishmentSystemID GROUP BY CreateType"; var parms = new IDataParameter[] { GetParameter(ParmPublishmentSystemId, EDataType.Integer, publishmentSystemId) }; using (var rdr = ExecuteReader(sqlString, parms)) { while (rdr.Read()) { var total = GetInt(rdr, 0); var createType = ECreateTypeUtils.GetEnumType(GetString(rdr, 1)); if (createType == ECreateType.Index) { indexCount += total; } else if (createType == ECreateType.Channel) { channelsCount += total; } else if (createType == ECreateType.Content) { contentsCount += total; } else if (createType == ECreateType.File) { filesCount += total; } else if (createType == ECreateType.AllContent) { contentsCount += total; } } rdr.Close(); } } else { const string sqlString = "SELECT COUNT(*) AS TOTAL, CreateType FROM siteserver_CreateTask GROUP BY CreateType"; using (var rdr = ExecuteReader(sqlString)) { while (rdr.Read()) { var total = GetInt(rdr, 0); var createType = ECreateTypeUtils.GetEnumType(GetString(rdr, 1)); if (createType == ECreateType.Index) { indexCount += total; } else if (createType == ECreateType.Channel) { channelsCount += total; } else if (createType == ECreateType.Content) { contentsCount += total; } else if (createType == ECreateType.File) { filesCount += total; } else if (createType == ECreateType.AllContent) { contentsCount += total; } } rdr.Close(); } } }