/// <summary> /// 資料查詢方法 /// </summary> /// <param name="options"></param> /// <returns></returns> protected QueryData <DefaultScheduler> Query(QueryPageOptions options) { var data = (string.IsNullOrEmpty(options.SearchText) ? TaskServicesManager.ToList() : TaskServicesManager.ToList().Where(t => t.Name.Contains(options.SearchText, StringComparison.OrdinalIgnoreCase))).OrderBy(s => s.Name).Select(s => new DefaultScheduler() { Name = s.Name, Status = s.Status, NextRuntime = s.NextRuntime, CreatedTime = s.CreatedTime, Triggers = s.Triggers, LastRuntime = s.LastRuntime, LastRunResult = s.Triggers.First().LastResult, TriggerExpression = s.Triggers.First()?.ToString() ?? "" }); return(new QueryData <DefaultScheduler>() { Items = data, TotalCount = data.Count(), PageIndex = 1, PageItems = data.Count() }); }
public IEnumerable <object> Get() { return(TaskServicesManager.ToList().Select(s => new { s.Name, Status = s.Status.ToString(), s.LastRuntime, s.CreatedTime, s.NextRuntime, LastRunResult = s.Triggers.First().LastResult.ToString(), TriggerExpression = s.Triggers.First().ToString() }).OrderBy(s => s.Name)); }
public object Get() { if (!User.IsInRole("Administrators")) { return(false); } // New Users var user = UserHelper.RetrieveNewUsers(); var usersCount = user.Count(); user = user.Take(6); user.AsParallel().ForAll(n => { var ts = DateTime.Now - n.RegisterTime; if (ts.TotalMinutes < 5) { n.Period = "刚刚"; } else if (ts.Days > 0) { n.Period = string.Format("{0}天", ts.Days); } else if (ts.Hours > 0) { n.Period = string.Format("{0}小时", ts.Hours); } else if (ts.Minutes > 0) { n.Period = string.Format("{0}分钟", ts.Minutes); } }); // Tasks var task = TaskServicesManager.ToList().Where(s => s.NextRuntime != null).Select(s => new { s.Name, s.LastRuntime, s.LastRunResult }); var tasksCount = task.Count(); //Message var message = MessageHelper.Retrieves(User.Identity.Name); var messagesCount = message.Count(); message = message.Take(6); message.AsParallel().ForAll(m => m.FromIcon = Url.Content(m.FromIcon)); //Apps var apps = ExceptionsHelper.Retrieves().Where(n => n.Category != "DB"); var appExceptionsCount = apps.Count(); apps = apps.Take(6); apps.AsParallel().ForAll(n => { n.ExceptionType = n.ExceptionType.Split('.').Last(); var ts = DateTime.Now - n.LogTime; if (ts.TotalMinutes < 5) { n.Period = "刚刚"; } else if (ts.Days > 0) { n.Period = string.Format("{0}天", ts.Days); } else if (ts.Hours > 0) { n.Period = string.Format("{0}小时", ts.Hours); } else if (ts.Minutes > 0) { n.Period = string.Format("{0}分钟", ts.Minutes); } }); //Dbs var dbs = ExceptionsHelper.Retrieves().Where(n => n.Category == "DB"); var dbExceptionsCount = dbs.Count(); dbs = dbs.Take(6); dbs.AsParallel().ForAll(n => { var ts = DateTime.Now - n.LogTime; if (ts.TotalMinutes < 5) { n.Period = "刚刚"; } else if (ts.Days > 0) { n.Period = string.Format("{0}天", ts.Days); } else if (ts.Hours > 0) { n.Period = string.Format("{0}小时", ts.Hours); } else if (ts.Minutes > 0) { n.Period = string.Format("{0}分钟", ts.Minutes); } }); return(new { NewUsersCount = usersCount, TasksCount = tasksCount, MessagesCount = messagesCount, AppExceptionsCount = appExceptionsCount, DbExceptionsCount = dbExceptionsCount, Users = user.Select(i => new { i.Period, i.UserName, i.DisplayName, i.Description }), Tasks = task.Take(6), Messages = message, Apps = apps.Select(n => new { n.ExceptionType, n.Message, n.Period }), Dbs = dbs.Select(n => new { n.ErrorPage, n.Message, n.Period }) }); }