// GET: /Platform/SysLog/
/// <summary>
/// </summary>
/// <param name="keyword">
/// </param>
/// <param name="ordering">
/// </param>
/// <param name="pageIndex">
/// </param>
/// <param name="search">
/// </param>
/// <returns>
/// </returns>
public ActionResult Index(string keyword, string ordering, int pageIndex = 1, bool search = false, bool toExcelFile = false)
{
var model =
_sysLogService.GetAll()
.Select(
a =>
new
{
a.MachineName,
a.Log,
a.CreatedDateTime,
a.Id
}).Search(keyword);
model = model.OrderByDescending(a => a.CreatedDateTime);
if (search)
{
model = model.Search(Request.Query);
}
if (!string.IsNullOrEmpty(ordering))
{
model = model.OrderBy(ordering);
}
if (toExcelFile)
{
return(model.ToExcelFile());
}
return(View(model.PageResult(pageIndex, 20)));
}
//
// GET: /Platform/SysLog/
/// <summary>
///
/// </summary>
/// <param name="keyword"></param>
/// <param name="ordering"></param>
/// <param name="pageIndex"></param>
/// <param name="search"></param>
/// <returns></returns>
public ActionResult Index(string keyword, string ordering, int pageIndex = 1, bool search = false)
{
var model =
_sysLogService.GetAll()
.Select(
a =>
new
{
a.Log,
a.CreatedDateTime
}).Search(keyword);
if (search)
{
model = model.Search(Request.QueryString);
}
model = !string.IsNullOrEmpty(ordering) ? model.OrderBy(ordering, null) : model.OrderByDescending(a => a.CreatedDateTime);
return(View(model.ToPagedList(pageIndex)));
}
//
// GET: /Platform/SysLog/
public ActionResult Index(string keyword, string ordering, int pageIndex = 1)
{
var model = _sysLogService.GetAll().Select(a => new { a.Level, a.Message, a.CreatedDate }).Search(keyword);
if (!string.IsNullOrEmpty(ordering))
{
model = model.OrderBy(ordering, null);
}
if (!string.IsNullOrEmpty(Request["report"]))
{
//导出
var reportModel = new Report(model.ToReportSource());
return(new ReportResult(reportModel));
}
return(View(model.ToPagedList(pageIndex)));
}
public IActionResult Index1()
{
var model = _ISysLogService.GetAll().PageResult(1, 20);
return(View(model));
}
public FileResult Details(int width = 1000, int height = 618)
{
var sysUserLog = _sysUserLogService.GetAllEnt();
var sysLog = _sysLogService.GetAll();
var chart = new Chart {
Height = height, Width = width,
};
var chartArea = new ChartArea("Area1")
{
AxisX = { Interval = 1 }, BackColor = Color.Transparent
};
chartArea.AxisX.LabelStyle.ForeColor = Color.White;
chartArea.AxisY.LabelStyle.ForeColor = Color.White;
chartArea.AxisY2.LabelStyle.ForeColor = Color.White;
chartArea.AxisX.LineColor = Color.White;
chartArea.AxisY.LineColor = Color.White;
chartArea.AxisY2.LineColor = Color.White;
chartArea.AxisX.MajorTickMark.LineColor = Color.White;
chartArea.AxisY.MajorTickMark.LineColor = Color.White;
chartArea.AxisY2.MajorTickMark.LineColor = Color.White;
chartArea.AxisX.MajorGrid.LineColor = Color.White;
chartArea.AxisY.MajorGrid.LineColor = Color.White;
chartArea.AxisY2.MajorGrid.LineColor = Color.White;
chart.ChartAreas.Add(chartArea);
var legend = new Legend();
chart.Legends.Add(legend);
chart.BackColor = Color.Transparent;
var seriescountAll = new Series("使用次数");
var countAll =
sysUserLog.GroupBy(a => DbFunctions.TruncateTime(a.CreatedDate))
.Select(a => new { Key = a.Key.Value, Count = a.Count() })
.OrderBy(a => a.Key);
seriescountAll.ChartArea = "Area1";
seriescountAll.IsVisibleInLegend = true;
seriescountAll.IsValueShownAsLabel = true;
seriescountAll.Points.DataBind(countAll, "Key", "Count", "");
seriescountAll.ChartType = SeriesChartType.Column;
seriescountAll.LabelForeColor = Color.White;
chart.Series.Add(seriescountAll);
var seriescountUser = new Series("登陆用户数量");
var countUser =
sysUserLog.GroupBy(a => DbFunctions.TruncateTime(a.CreatedDate)).Select(
a => new { Key = a.Key.Value, Count = a.Select(c => c.SysUserId).Distinct().Count() })
.OrderBy(a => a.Key);
seriescountUser.ChartArea = "Area1";
seriescountUser.IsVisibleInLegend = true;
seriescountUser.IsValueShownAsLabel = true;
seriescountUser.Points.DataBind(countUser, "Key", "Count", "");
seriescountUser.ChartType = SeriesChartType.Column;
seriescountUser.YAxisType = AxisType.Secondary;
seriescountUser.LabelForeColor = Color.White;
chart.Series.Add(seriescountUser);
//var seriessysLogChart = new Series("系统日志");
//var sysLogChart =
// sysLog.GroupBy(a => DbFunctions.TruncateTime(a.CreatedDate))
// .Select(a => new { Key = a.Key.Value, Count = a.Count() })
// .OrderBy(a => a.Key);
//seriessysLogChart.ChartArea = "Area1";
//seriessysLogChart.IsVisibleInLegend = true;
//seriessysLogChart.IsValueShownAsLabel = true;
//seriessysLogChart.Points.DataBind(sysLogChart, "Key", "Count", "");
//seriessysLogChart.ChartType = SeriesChartType.Column;
//seriescountUser.YAxisType = AxisType.Secondary;
//chart.Series.Add(seriessysLogChart);
var imageStream = new MemoryStream();
chart.SaveImage(imageStream, ChartImageFormat.Png);
imageStream.Position = 0;
return(new FileStreamResult(imageStream, "image/png"));
}