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