/// <summary>
/// Returns a bar chart for a given set of values.
/// </summary>
/// <param name="seriesSet"></param>
/// <param name="xValues"></param>
/// <param name="title"></param>
/// <returns></returns>
public static DotNet.Highcharts.Highcharts GetBarChart(List <DotNet.Highcharts.Options.Series> seriesSet, List <string> xValues, string title)
{
DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts(title);
chart.InitChart(new Chart
{
Height = 320,
Width = 320,
DefaultSeriesType = ChartTypes.Column
});
chart.SetXAxis(new XAxis
{
Categories = xValues.ToArray()
});
chart.SetLegend(new Legend {
Enabled = false
});
chart.SetSeries(seriesSet.ToArray());
chart.SetTitle(new DotNet.Highcharts.Options.Title {
Text = title.Replace("_", " ")
});
return(chart);
}
public static DotNet.Highcharts.Highcharts GetBarChart(List <string> xValues, List <Object> yValues, string YAxisTitle, string chartTitle)
{
DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts(chartTitle)
.InitChart(new DotNet.Highcharts.Options.Chart {
DefaultSeriesType = ChartTypes.Column
})
.SetPlotOptions(new PlotOptions
{
Column = new PlotOptionsColumn
{
Stacking = Stackings.Normal,
}
});
chart.SetXAxis(new XAxis
{
Categories = xValues.ToArray(),
});
chart.SetSeries(new DotNet.Highcharts.Options.Series
{
Data = new Data(yValues.ToArray()),
Name = YAxisTitle
});
chart.SetTitle(new DotNet.Highcharts.Options.Title {
Text = chartTitle
});
return(chart);
}
public static DotNet.Highcharts.Highcharts GetBarChart(List<string> xValues, List<Object> yValues, string YAxisTitle, string chartTitle)
{
DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts(chartTitle)
.InitChart(new DotNet.Highcharts.Options.Chart { DefaultSeriesType = ChartTypes.Column })
.SetPlotOptions(new PlotOptions
{
Column = new PlotOptionsColumn
{
Stacking = Stackings.Normal,
}
});
chart.SetXAxis(new XAxis
{
Categories = xValues.ToArray(),
});
chart.SetSeries(new DotNet.Highcharts.Options.Series
{
Data = new Data(yValues.ToArray()),
Name = YAxisTitle
});
chart.SetTitle(new DotNet.Highcharts.Options.Title { Text = chartTitle });
return chart;
}
public PartialViewResult GetChart()
{
DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart");
//初始化
DotNet.Highcharts.Options.Chart chartOption = new DotNet.Highcharts.Options.Chart();
chartOption.DefaultSeriesType = DotNet.Highcharts.Enums.ChartTypes.Line;
chartOption.Width = 400;
chartOption.Height = 400;
chart.InitChart(chartOption);
//设置标题
DotNet.Highcharts.Options.Title title = new DotNet.Highcharts.Options.Title();
title.Align = DotNet.Highcharts.Enums.HorizontalAligns.Center;
title.Text = "图表";
chart.SetTitle(title);
//提示
DotNet.Highcharts.Options.Tooltip tooltip = new DotNet.Highcharts.Options.Tooltip();
tooltip.ValueSuffix = "摄氏度";
chart.SetTooltip(tooltip);
DotNet.Highcharts.Options.PlotOptions plotOptions = new DotNet.Highcharts.Options.PlotOptions();
plotOptions.Bar = new DotNet.Highcharts.Options.PlotOptionsBar();
plotOptions.Bar.DataLabels = new DotNet.Highcharts.Options.PlotOptionsBarDataLabels();
plotOptions.Bar.DataLabels.Enabled = true;
chart.SetPlotOptions(plotOptions);
//横坐标
DotNet.Highcharts.Options.XAxis xs = new DotNet.Highcharts.Options.XAxis {
Categories = new[] { "jan", "feb" }
};
List <string> cList = new List <string>();
cList.Add("jan");
cList.Add("feb");
xs.Categories = cList.ToArray();
xs.Title = new DotNet.Highcharts.Options.XAxisTitle();
xs.Title.Text = "月份";
chart.SetXAxis(xs);
//纵坐标
DotNet.Highcharts.Options.YAxis ys = new DotNet.Highcharts.Options.YAxis();
ys.Title = new DotNet.Highcharts.Options.YAxisTitle();
ys.Title.Text = "温度";
chart.SetYAxis(ys);
//设置表现值
DotNet.Highcharts.Options.Series ss = new DotNet.Highcharts.Options.Series();
List <object> oList = new List <object>();
oList.Add(29);
oList.Add(33);
ss.Data = new DotNet.Highcharts.Helpers.Data(oList.ToArray());
ss.Name = "温度";
chart.SetSeries(ss);
return(PartialView("_PartialChartView", chart));
}
public DotNet.Highcharts.Highcharts GetChart(SimpleChartModel chartModel)
{
DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts(chartModel.ContainerId);
//初始化
DotNet.Highcharts.Options.Chart chartOption = new DotNet.Highcharts.Options.Chart();
chartOption.DefaultSeriesType = chartModel.ChartType;
chartOption.Width = chartModel.Width;
chartOption.Height = chartModel.Height;
chart.InitChart(chartOption);
//设置标题
DotNet.Highcharts.Options.Title title = new DotNet.Highcharts.Options.Title();
title.Align = DotNet.Highcharts.Enums.HorizontalAligns.Center;
title.Text = chartModel.Title;
chart.SetTitle(title);
//提示
DotNet.Highcharts.Options.Tooltip tooltip = new DotNet.Highcharts.Options.Tooltip();
tooltip.ValueSuffix = chartModel.ValueSuffix;
chart.SetTooltip(tooltip);
DotNet.Highcharts.Options.PlotOptions plotOptions = new DotNet.Highcharts.Options.PlotOptions();
plotOptions.Bar = new DotNet.Highcharts.Options.PlotOptionsBar();
plotOptions.Bar.DataLabels = new DotNet.Highcharts.Options.PlotOptionsBarDataLabels();
plotOptions.Bar.DataLabels.Enabled = true;
chart.SetPlotOptions(plotOptions);
//横坐标
DotNet.Highcharts.Options.XAxis xs = new DotNet.Highcharts.Options.XAxis();
xs.Categories = chartModel.XList.ToArray();
xs.Title = new DotNet.Highcharts.Options.XAxisTitle();
xs.Title.Text = chartModel.XTitle;
chart.SetXAxis(xs);
//纵坐标
DotNet.Highcharts.Options.YAxis ys = new DotNet.Highcharts.Options.YAxis();
ys.Title = new DotNet.Highcharts.Options.YAxisTitle();
ys.Title.Text = chartModel.YTitle;
chart.SetYAxis(ys);
//设置表现值
List <DotNet.Highcharts.Options.Series> ssList = new List <DotNet.Highcharts.Options.Series>();
foreach (YSeries yserires in chartModel.SeriesList)
{
DotNet.Highcharts.Options.Series ss = new DotNet.Highcharts.Options.Series();
ss.Data = new DotNet.Highcharts.Helpers.Data(yserires.YSeriesList.ToArray());
ss.Name = yserires.YName;
ssList.Add(ss);
}
chart.SetSeries(ssList.ToArray());
return(chart);
}
public static DotNet.Highcharts.Highcharts GetPieChart(Series seriesSet, string title)
{
DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts(title);
chart.InitChart(new Chart
{
Height = 250,
Width = 250,
DefaultSeriesType = ChartTypes.Pie
});
chart.SetSeries(seriesSet);
chart.SetTitle(new DotNet.Highcharts.Options.Title {
Text = title
});
return(chart);
}
public DotNet.Highcharts.Highcharts GetPieChart(SimpleChartModel chartModel)
{
DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts(chartModel.ContainerId);
//初始化
DotNet.Highcharts.Options.Chart chartOption = new DotNet.Highcharts.Options.Chart();
chartOption.DefaultSeriesType = chartModel.ChartType;
chartOption.Width = chartModel.Width;
chartOption.Height = chartModel.Height;
chart.InitChart(chartOption);
//设置标题
DotNet.Highcharts.Options.Title title = new DotNet.Highcharts.Options.Title();
title.Align = DotNet.Highcharts.Enums.HorizontalAligns.Center;
title.Text = chartModel.Title;
chart.SetTitle(title);
//提示
DotNet.Highcharts.Options.Tooltip tooltip = new DotNet.Highcharts.Options.Tooltip();
tooltip.ValueSuffix = chartModel.ValueSuffix;
tooltip.PointFormat = "{point.name}: <b>{point.y}</b>";
chart.SetTooltip(tooltip);
//饼图
DotNet.Highcharts.Options.PlotOptions plotOptions = new DotNet.Highcharts.Options.PlotOptions();
plotOptions.Pie = new DotNet.Highcharts.Options.PlotOptionsPie();
plotOptions.Pie.AllowPointSelect = true;
plotOptions.Pie.Cursor = DotNet.Highcharts.Enums.Cursors.Pointer;
plotOptions.Pie.ShowInLegend = true;
plotOptions.Pie.DataLabels = new DotNet.Highcharts.Options.PlotOptionsPieDataLabels();
plotOptions.Pie.DataLabels.Enabled = true;
plotOptions.Pie.DataLabels.Format = "<b>{point.name}</b>: {point.y}个";
chart.SetPlotOptions(plotOptions);
//设置表现值
List <DotNet.Highcharts.Options.Series> ssList = new List <DotNet.Highcharts.Options.Series>();
DotNet.Highcharts.Options.Series ss = new DotNet.Highcharts.Options.Series();
ss.Type = DotNet.Highcharts.Enums.ChartTypes.Pie;
ss.Name = chartModel.Title;
ss.Data = new DotNet.Highcharts.Helpers.Data(chartModel.pieDataList.ToArray());
ssList.Add(ss);
chart.SetSeries(ssList.ToArray());
return(chart);
}
public static DotNet.Highcharts.Highcharts GetLineChart(List<DotNet.Highcharts.Options.Series> seriesSet, List<string> xValues, string title,int dimensions=300)
{
DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts(title);
chart.InitChart(new Chart
{
Height = dimensions,
Width = dimensions
});
chart.SetXAxis(new XAxis
{
Categories = xValues.ToArray()
});
chart.SetSeries(seriesSet.ToArray());
chart.SetTitle(new DotNet.Highcharts.Options.Title { Text = title });
return chart;
}
public ActionResult Index2()
{
var itemSales = db.salesLineItem.GroupBy(s => s.item).Select(s => new { item = s.Key.name, sum = s.Sum(b => b.quantity) });
string[] namesOfItems = new string[10];
int i = 0;
foreach (var itm in itemSales)
{
namesOfItems[i] = itm.item;
i++;
if (i == 10)
{
break;
}
}
object[] sumOfItems = new object[10];
i = 0;
foreach (var itm in itemSales)
{
sumOfItems[i] = itm.sum;
i++;
if (i == 10)
{
break;
}
}
DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart");
chart.SetXAxis(new XAxis
{
Categories = namesOfItems
});
chart.SetSeries(new Series
{
Data = new Data(sumOfItems)
});
return(View(chart));
}
public static DotNet.Highcharts.Highcharts GetLineChart(List <DotNet.Highcharts.Options.Series> seriesSet, List <string> xValues, string title, int dimensions = 300)
{
DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts(title);
chart.InitChart(new Chart
{
Height = dimensions,
Width = dimensions
});
chart.SetXAxis(new XAxis
{
Categories = xValues.ToArray()
});
chart.SetSeries(seriesSet.ToArray());
chart.SetTitle(new DotNet.Highcharts.Options.Title {
Text = title
});
return(chart);
}
public static DotNet.Highcharts.Highcharts GetAreaChart(List<DotNet.Highcharts.Options.Series> seriesSet, List<string> xValues, string title)
{
DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts(title);
chart.InitChart(new Chart
{
Height = 300,
Width = 300,
DefaultSeriesType = ChartTypes.Area
});
chart.SetXAxis(new XAxis
{
Categories = xValues.ToArray()
});
chart.SetSeries(seriesSet.ToArray());
chart.SetTitle(new DotNet.Highcharts.Options.Title { Text = title });
return chart;
}
public static DotNet.Highcharts.Highcharts GetAreaChart(List <DotNet.Highcharts.Options.Series> seriesSet, List <string> xValues, string title)
{
DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts(title);
chart.InitChart(new Chart
{
Height = 300,
Width = 300,
DefaultSeriesType = ChartTypes.Area
});
chart.SetXAxis(new XAxis
{
Categories = xValues.ToArray()
});
chart.SetSeries(seriesSet.ToArray());
chart.SetTitle(new DotNet.Highcharts.Options.Title {
Text = title
});
return(chart);
}
private void loadSummaryPieChart()
{
queryString = "select count(*) as count, CASE greatest(Neutral,Happy,Sad,Angry,Surprised,Scared,Disgusted)" +
" WHEN Neutral THEN 'Neutral'" +
" WHEN Happy THEN 'Happy'" +
" WHEN Sad THEN 'Sad'" +
" WHEN Angry THEN 'Angry'" +
" WHEN Surprised THEN 'Surprised'" +
" WHEN Scared THEN 'Scared'" +
" WHEN Disgusted THEN 'Disgusted'" +
" else 'Unknown'" +
" END AS maxColumn from alef.emotions where Student_id=" + studentId +
" and Timestamp BETWEEN " + start + " AND " + end + " group by maxColumn;";
DataTable data = loadDatafromDB(queryString);
var percentages = new List <object[]>();
double totalNumOfRecords = 0;
foreach (DataRow dr in data.Rows)
{
totalNumOfRecords += Convert.ToDouble(dr["count"]);
}
foreach (DataRow dr in data.Rows)
{
double percentage = Math.Round((((Convert.ToDouble(dr["count"])) / totalNumOfRecords) * 100.0), 2);
percentages.Add(new object[] { dr["maxColumn"].ToString(), percentage.ToString() });
}
Title title = new DotNet.Highcharts.Options.Title();
title.Text = "";
DotNet.Highcharts.Highcharts chart2 = new DotNet.Highcharts.Highcharts("chart2").SetTitle(title);
chart2.SetSeries(new Series
{
Type = DotNet.Highcharts.Enums.ChartTypes.Pie,
Data = new Data(percentages.ToArray())
});
ltrChart2.Text = chart2.ToHtmlString();
}
private void plotConsolidatedData()
{
//All data graph
DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart").InitChart(new Chart
{
ZoomType = DotNet.Highcharts.Enums.ZoomTypes.X,
})
.SetXAxis(new[] {
new XAxis
{
Id = "Month Axes",
Categories = datesList,
Labels = new XAxisLabels {
Step = 15, StaggerLines = 1
}
// MinRange=30*24
}
//, new XAxis
// {
// Id="RAM_X",
// Type=DotNet.Highcharts.Enums.AxisTypes.Datetime,
// // Max=350
// }
});
chart.SetTitle(new Title {
Text = "Space Weather and Altitude"
});
chart.SetSeries(new[]
{ new Series
{
YAxis = "Sunspot",
XAxis = "Month Axes",
Name = "Smoothed SSN",
Data = new Data(smoothedSSNList)
// PlotOptionsLine=new PlotOptionsLine{PointInterval=24*24*3600000, PointStart=new PointStart(Convert.ToDateTime(datesList[0]))}
},
// new Series
// {
// Name="CPD",
// Data = new Data(cpd2),
// Color= System.Drawing.Color.Red,
// Type=DotNet.Highcharts.Enums.ChartTypes.Columnrange,
// XAxis="RAM_X",
// YAxis="RAM_Y",
// PlotOptionsColumnrange=new PlotOptionsColumnrange{
// Tooltip=new PlotOptionsColumnrangeTooltip{
// PointFormat = "{point.low:%e %b, %y} - {point.high:%e %b, %y}",
// HeaderFormat = "<b>{series.name}:</b>{point.y}<br />"
//}
// }
// {PointFormat = "{point.low:%e %b, %y} - {point.high:%e %b, %y}",
//HeaderFormat = "<b>{series.name}:</b>{point.x}<br />"})
// },
new Series
{
XAxis = "Month Axes",
YAxis = "Altitude",
Name = "Altitude",
Data = new Data(altitudeList)
},
new Series
{
XAxis = "Month Axes",
YAxis = "Sunspot",
Name = "Monthly SSN",
Data = new Data(monthlySSNList)
},
new Series
{
XAxis = "Month Axes",
YAxis = "Altitude",
Name = "Average Dose Values",
Data = new Data(avgDoseInAllDataList)
} });
chart.SetYAxis(new[] {
new YAxis
{
Id = "Sunspot",
Min = 0,
Max = 400,
TickInterval = 25,
Title = new YAxisTitle {
Text = "Sunspot Number"
}
},
new YAxis
{
Id = "Altitude",
Min = 0,
Max = 500,
TickInterval = 30,
Opposite = true,
Title = new YAxisTitle {
Text = "Altitude [km] and dose values [µGy]"
}
},
// new YAxis{
// Type=DotNet.Highcharts.Enums.AxisTypes.Linear,
// Id="RAM_Y",
//}
});
ltrChart.Text = chart.ToHtmlString();
}
private void plotRAMData()
{
//RAM graph
DotNet.Highcharts.Highcharts RAMChart = new DotNet.Highcharts.Highcharts("chart1").InitChart(new Chart
{
ZoomType = DotNet.Highcharts.Enums.ZoomTypes.Y,
Type = DotNet.Highcharts.Enums.ChartTypes.Columnrange,
Inverted = true
})
.SetXAxis(new[] {
new XAxis
{
Type = DotNet.Highcharts.Enums.AxisTypes.Linear,
Max = 350,
Reversed = false,
Title = new XAxisTitle {
Text = "Dose values [µGy]"
}
}
}).SetYAxis(new[] {
new YAxis {
Type = DotNet.Highcharts.Enums.AxisTypes.Datetime,
Title = new YAxisTitle {
Text = "Date"
}
}
});
RAMChart.SetTitle(new Title {
Text = "RAM and CPD"
})
.SetTooltip(new Tooltip
{
PointFormat = "{point.low:%e %b, %y} - {point.high:%e %b, %y}",
HeaderFormat = "<b>{series.name}:</b>{point.x}<br />"
});
RAMChart.SetSeries(new[]
{ new Series
{
Name = "CPD",
Data = new Data(cpd),
Color = System.Drawing.Color.Red
},
new Series
{
Name = "SM-1",
Data = new Data(loc1),
},
new Series
{
Name = "SM-2",
Data = new Data(loc2)
},
new Series
{
Name = "SM-3",
Data = new Data(loc3)
},
new Series
{
Name = "SM-4",
Data = new Data(loc4)
} });
ltrRAM.Text = RAMChart.ToHtmlString();
}
/// <summary>
/// Returns a bar chart for a given set of values.
/// </summary>
/// <param name="seriesSet"></param>
/// <param name="xValues"></param>
/// <param name="title"></param>
/// <returns></returns>
public static DotNet.Highcharts.Highcharts GetBarChart(List<DotNet.Highcharts.Options.Series> seriesSet, List<string> xValues, string title)
{
DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts(title);
chart.InitChart(new Chart
{
Height = 320,
Width = 320,
DefaultSeriesType = ChartTypes.Column
});
chart.SetXAxis(new XAxis
{
Categories = xValues.ToArray()
});
chart.SetLegend(new Legend { Enabled = false });
chart.SetSeries(seriesSet.ToArray());
chart.SetTitle(new DotNet.Highcharts.Options.Title { Text = title.Replace("_", " ")});
return chart;
}
public static DotNet.Highcharts.Highcharts GetPieChart(Series seriesSet, string title)
{
DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts(title);
chart.InitChart(new Chart
{
Height = 250,
Width = 250,
DefaultSeriesType = ChartTypes.Pie
});
chart.SetSeries(seriesSet);
chart.SetTitle(new DotNet.Highcharts.Options.Title { Text = title });
return chart;
}
