c#图标、显示图表、图形、json echarts实例 数据封装【c#】

page:

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="ViewxxxxChartsInfo.ascx.cs" Inherits="DotNetNuke.Modules.HRAddUser.ViewxxxxChartsInfo" %>
  

    
    <script type="text/javascript" src="http://www.shicishu.com/down/echarts.min.js"></script>
    <script type="text/javascript" src="http://www.shicishu.com/down/echarts-gl.min.js"></script>
    <script type="text/javascript">
        var span1 = document.getElementById('<%=Type1.ClientID%>').innerHTML;
        var sp1 = JSON.parse(span1);
        var span2 = document.getElementById('<%=Type2.ClientID%>').innerHTML;
        var sp2 = JSON.parse(span2);
        var span3 = document.getElementById('<%=Type3.ClientID%>').innerHTML;
        var sp3 = JSON.parse(span3);
        var span4 = document.getElementById('<%=Type4.ClientID%>').innerHTML;
        var sp4 = JSON.parse(span4);
        var span5 = document.getElementById('<%=Type5.ClientID%>').innerHTML;
        var sp5 = JSON.parse(span5);
        
       
        let maxValue2 = Math.max.apply(null, sp2);
        let maxValue3 = Math.max.apply(null, sp3);
        let maxValue4 = Math.max.apply(null, sp4);
        let maxValue5 = Math.max.apply(null, sp5);
        var arr = [maxValue2, maxValue3, maxValue4,maxValue5];
        let maxval = Math.max.apply(null, arr);
        
        var dom = document.getElementById("container");
        var myChart = echarts.init(dom);
        var app = {};
        option = null;
        option = {
            tooltip: {
                trigger: 'axis',
                axisPointer: {
                    type: 'cross',
                    crossStyle: {
                        color: '#999'
                    }
                }
            },
            toolbox: {
                feature: {
                    dataView: { show: true, readOnly: false },
                    magicType: { show: true, type: ['line', 'bar'] },
                    restore: { show: true },
                    saveAsImage: { show: true }
                }
            },
            legend: {
                data: ['营业收入', '应缴管理费', '实缴管理费','尚欠管理费']
            },
            xAxis: [
                {
                    type: 'category',
                    data: sp1,
                    axisPointer: {
                        type: 'shadow'
                    }
                }
            ],
            yAxis: [
                {
                    type: 'value',
                    name: '金额(元)',
                    min: 0,
                    max: maxval,
                    interval: maxval/10, 
                    axisLabel: {
                        formatter: '{value}'
                    }
                }

            ],
            series: [
                {
                    name: '营业收入',
                    type: 'bar',
                    data: sp2
                },
                {
                    name: '应缴管理费',
                    type: 'bar',
                    data: sp3
                },
                {
                    name: '实缴管理费',
                    type: 'bar',
                    data: sp4
                },
                {
                    name: '尚欠管理费',
                    type: 'bar',
                    data: sp5
                }
            ]
        };

        if (option && typeof option === "object") {
            myChart.setOption(option, true);
        }
    </script>

controller:

using System;
using System.Data;
using System.Web.UI.WebControls;
using DotNetNuke.Modules.ControllerData;
using DotNetNuke.Security;
using DotNetNuke.Services.Localization;

namespace DotNetNuke.Modules.ControllerData
{
    public partial class ViewxxxxChartsInfo : DotNetNuke.Entities.Modules.PortalModuleBase, DotNetNuke.Entities.Modules.IActionable
    {
        private ControllerData CD = new ControllerData();
        private DataTable dtTosxxxInfo = new DataTable();

        protected void Page_Load(object sender, EventArgs e)
        {
           
            FillDG();

            if (!IsPostBack)
            {
                FillUI();
            }
        }

        private void FillDG()
        {

            string swhere = " where xxxxName like '%" + tbxInfoxxxxxName.Text + "%' ";
            bool OnlyExpire;
            if (ddlDateArray.Text == "全部")
                OnlyExpire = false;
            else
                OnlyExpire = true;

            dtTosxxxInfo = CD.GetTosxxxxChartsInfo(swhere, ddlDateArray.Text);
        }

        private void FillUI()
        {
            Type1.Text = Convert.ToString(dtTosxxxInfo.Rows[0]["jsons"]);
            Type2.Text = Convert.ToString(dtTosxxxInfo.Rows[1]["jsons"]);
            Type3.Text = Convert.ToString(dtTosxxxInfo.Rows[2]["jsons"]);
            Type4.Text = Convert.ToString(dtTosxxxInfo.Rows[3]["jsons"]);
            Type5.Text = Convert.ToString(dtTosxxxInfo.Rows[4]["jsons"]);
        }
		//页面响应移动代码
        #region IActionable 成员

        DotNetNuke.Entities.Modules.Actions.ModuleActionCollection DotNetNuke.Entities.Modules.IActionable.ModuleActions
        {
            get
            {
                Entities.Modules.Actions.ModuleActionCollection Actions = new
                Entities.Modules.Actions.ModuleActionCollection();
                Actions.Add(GetNextActionID(),
                Localization.GetString(Entities.Modules.Actions.ModuleActionType.AddContent,
                LocalResourceFile), Entities.Modules.Actions.ModuleActionType.AddContent, "", "",
                EditUrl(), false, SecurityAccessLevel.Edit, true, false);
                return Actions;
            }
        }

        #endregion
        protected void btnselect_Click(object sender, EventArgs e)
        {
            FillDG();
            FillUI();
        }
    }
}

data:

     /// 

        /// 获取xxxxxx收入、应缴、实缴、尚欠金额统计json.
        /// 
        /// 
        /// 
        /// 
        public DataTable GetTosxxxChartsInfo(string where, string DateA)
        {
            DataTable dtchart = new DataTable();
            dtchart.Columns.Add("jsons");

            List list1 = new List();
            List list2 = new List();
            List list3 = new List();
            List list4 = new List();
            List list5 = new List();

            DataTable dtbc = GetTosxxxViewInfo(where, DateA);//数据层-统计计算封装表
            if (dtbc.Rows.Count > 0)
            {
                string Tosxxxname = "";
                decimal  Total2 = 0, Total3 = 0, Total4 = 0, Total5 = 0;
                for (int t = 0; t < dtbc.Rows.Count; t++)
                {
                    Tosxxxname = Convert.ToString(dtbc.Rows[t]["OAxxxxName"]);
                    Total2 = Convert.ToDecimal(dtbc.Rows[t]["xxxxIngahter"]);
                    Total3 = Convert.ToDecimal(dtbc.Rows[t]["xxxxAdminFee"]);
                    Total4 = Convert.ToDecimal(dtbc.Rows[t]["xxxAdminFee"]);
                    Total5 = Convert.ToDecimal(dtbc.Rows[t]["xxxxAdminFee"]);
                    list1.Add(Tosxxxname);
                    list2.Add(Total2);
                    list3.Add(Total3);
                    list4.Add(Total4);
                    list5.Add(Total5);
                }
            }
            dtchart.Rows.Add(new object[] { Newtonsoft.Json.JsonConvert.SerializeObject(list1) });
            dtchart.Rows.Add(new object[] { Newtonsoft.Json.JsonConvert.SerializeObject(list2) });
            dtchart.Rows.Add(new object[] { Newtonsoft.Json.JsonConvert.SerializeObject(list3) });
            dtchart.Rows.Add(new object[] { Newtonsoft.Json.JsonConvert.SerializeObject(list4) });
            dtchart.Rows.Add(new object[] { Newtonsoft.Json.JsonConvert.SerializeObject(list5) });
            return dtchart;
        }