echarts呈现数据表图形
程序员文章站
2022-07-05 17:02:33
讲一下echarts的用法，列举了两个图表，一个是单柱图，一个是多柱图，至于饼状图，只许更改echarts的类型就好了 一、首先是要两个div，用来存放两个图表 二、需要用js从后台获取json数据（可以从cs页面获取，也可以通过一般处理程序，这里用的一般处理程序） <%--单个柱状图--%>
JS代码
单个柱状图读取方式
多个柱状图读取方式
讲一下echarts的用法，列举了两个图表，一个是单柱图，一个是多柱图，至于饼状图，只许更改echarts的类型就好了
一、首先是要两个div，用来存放两个图表
<div class="div-frm" style="height: 275px; font-family: Microsoft YaHei, Verdana, Arial;">
<div id="barone" style="width: 100%; height: 240px; float: left; font-family: Microsoft YaHei, Verdana, Arial;"></div>
</div>
<div style="height: 240px; font-family: Microsoft YaHei, Verdana, Arial;">
<div id="barthree" class="chart-container" style="width: 100%; height: 240px; float: left; font-family: Microsoft YaHei, Verdana, Arial;"></div>
</div>
二、需要用js从后台获取json数据（可以从cs页面获取，也可以通过一般处理程序，这里用的一般处理程序）
<%--单个柱状图--%>
<script type="text/javascript">
//初始化
var dom = document.getElementById("barone");
var myChart = echarts.init(dom);
var app = {};
option = null;
markPoint = null;
//图表使用
var option = {
title: {
text: '成绩图'
},
tooltip: {
trigger: 'axis'
},
toolbox: {
show: true,
feature: {
mark: { show: true },
dataView: { show: true, readOnly: false },
magicType: { show: true, type: ['line', 'bar'] },
restore: { show: true },
saveAsImage: { show: true }
}
},
calculable: true,
xAxis: [
{
type: 'category',
data: [""]
}
],
yAxis: [
{
type: 'value'
}
],
series: [
{
type: 'bar',
data: [""], //数据显示的地方，ajax
markPoint: {
data: [
{ type: 'max', name: '最大值' },
{ type: 'min', name: '最小值' }
]
},
markLine: {
data: [
{ type: 'average', name: '平均值' }
]
},
},
],
dataZoom: [
{
show: false,
start: 0,
end: 100
}
]
};
if (option && typeof option === "object") {
myChart.setOption(option, true);
}
//获取数据
$.ajax({
url: "echartsData/barone.ashx", //数据来源
data: { type: "bar" },
cache: false,
async: false,
dataType: 'json',
success: function (data) {
if (data) {
myChart.setOption({
xAxis: [{ data: data.xAxis }],
series: [
{
data: data.series,
itemStyle: { //显示柱状图顶部的数字
normal: {
color: '#2d9fd8',
label: {
show: true,
position: 'top',
textStyle: {
baseline: "bottom"
}
}
}
},
barWidth: 20
}
]
});
}
},
error: function (msg) {
alert("系统发生错误1");
}
});
</script>
<%-- 多个柱状图 --%>
<script type="text/javascript">
var dom = document.getElementById("barthree");
var myChart2 = echarts.init(dom);
var app = {};
option = null;
var option = {
title: {
text: '成绩表'
},
tooltip: {
trigger: 'axis'
},
legend: {
data: ['数学', '语文', '英语']
},
toolbox: {
show: true,
feature: {
mark: { show: true },
dataView: { show: true, readOnly: false },
magicType: { show: true, type: ['line', 'bar'] },
restore: { show: true },
saveAsImage: { show: true }
}
},
calculable: true,
xAxis: [
{
type: 'category',
data: [""]
}
],
yAxis: [
{
type: 'value'
}
],
series: [
{
name: '访问来源',
type: 'bar',
data: [""],
itemStyle: {
normal: {
color: '#2d9fd8',
label: {
show: true,
position: 'top',
textStyle: {
baseline: "bottom"
}
}
}
},
markPoint: {
data: [
{ type: 'max', name: '最大值' },
{ type: 'min', name: '最小值' }
]
},
markLine: {
data: [
{ type: 'average', name: '平均值' }
]
},
}
],
dataZoom: [
{
show: false,
start: 0,
end: 100
}
]
};
if (option && typeof option === "object") {
myChart2.setOption(option, true);
}
$.ajax({
url: "echartsData/barthree.ashx",
data: { type: "bar" },
cache: false,
async: false,
dataType: 'json',
success: function (data) {
if (data) {
myChart2.setOption({
legend: [{ data: data.legend }],
xAxis: [{ data: data.xAxis }],
series: data.series
});
}
},
error: function (msg) {
alert("系统发生错误");
}
});
</script>
三、在后台，从数据库读取数据
static string conStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
JavaScriptSerializer jsS = new JavaScriptSerializer();
List<object> seriesList = new List<object>();
List<string> xAxisList = new List<string>();
string result = "";
public void ProcessRequest(HttpContext context)
{
string command = context.Request["type"];
switch (command)
{
case "bar":
GetOverView(context);
break;
};
}
public void GetOverView(HttpContext context)
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = conStr;
conn.Open();
string sql = "select * from Achievement";
SqlDataAdapter myda = new SqlDataAdapter(sql, conStr);
DataTable dt = new DataTable(); // 实例化数据表
myda.Fill(dt); // 保存数据
foreach (DataRow dr in dt.Rows)
{
xAxisList.Add(dr["Name"].ToString());
seriesList.Add(dr["Math"].ToString());
}
var newObj = new
{
xAxis = xAxisList,
series = seriesList
};
jsS = new JavaScriptSerializer();
result = jsS.Serialize(newObj);
context.Response.Write(result);
conn.Close(); // 关闭数据库连接
}
}
static string conStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
JavaScriptSerializer jsS = new JavaScriptSerializer();
List<object> seriesList = new List<object>();
List<string> xAxisList = new List<string>();
List<string> legendList = new List<string>();
string result = "";
public void ProcessRequest(HttpContext context)
{
string command = context.Request["type"];
switch (command)
{
case "bar":
GetOverView(context);
break;
};
}
public void GetOverView(HttpContext context)
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = conStr;
conn.Open();
string sql = "select * from Achievement";
SqlDataAdapter myda = new SqlDataAdapter(sql, conStr);
DataTable dt = new DataTable(); // 实例化数据表
myda.Fill(dt); // 保存数据
legendList.Add("数学");
legendList.Add("语文");
legendList.Add("英语");
//设置对应的Series信息
Series UVSeriesObj = new Series();
UVSeriesObj.name = "数学";
UVSeriesObj.type = "bar"; //图呈现
UVSeriesObj.data = new List<object>();
Series UIPSeriesObj = new Series();
UIPSeriesObj.name = "语文";
UIPSeriesObj.type = "bar"; //图呈现
UIPSeriesObj.data = new List<object>();
Series PVSeriesObj = new Series();
PVSeriesObj.name = "英语";
PVSeriesObj.type = "bar"; //图呈现
PVSeriesObj.data = new List<object>();
foreach (DataRow dr in dt.Rows)
{
xAxisList.Add(dr["Name"].ToString());
UVSeriesObj.data.Add(dr["Math"]);
UIPSeriesObj.data.Add(dr["Chinese"]);
PVSeriesObj.data.Add(dr["English"]);
}
seriesList.Add(UVSeriesObj);
seriesList.Add(UIPSeriesObj);
seriesList.Add(PVSeriesObj);
var newObj = new
{
legend = legendList, //三门学科
xAxis = xAxisList,
series = seriesList
};
jsS = new JavaScriptSerializer();
result = jsS.Serialize(newObj);
context.Response.Write(result);
}
}
public bool IsReusable
{
get
{
return false;
}
}
class Series
{
/// <summary>
/// series序列组名称
/// </summary>
public string name
{
get;
set;
}
/// <summary>
/// series序列组呈现图表类型(line、column、bar等)
/// </summary>
public string type
{
get;
set;
}
/// <summary>
/// series序列组的数据为数据类型数组
/// </summary>
public List<object> data
{
get;
set;
}
}
echarts官方api文档：
上一篇： 惠普发布通信行业版大数据及分析方案