EF Core与Highcharts集成-优快云博客

EFDbContext类：

public class EFDbContext : DbContext
    {
        public DbSet<A> Aa { set; get; }
    }

Models类：

public class A
    {
        [Key]
        public int Id { set; get; }
        public string ipAddress { set; get; }
        public int Port { set; get; }
        public DateTime Time { set; get; }
        public string madAddr { set; get; }

}

Highchasts类：

        EFDbContext db = new EFDbContext();
        public string Highchartsdata1()
        {
            List<A> list = db.Aa.ToList();
            List<Person> listA = new List<Person>();
            foreach (var item in list)
            {
                Person p = new Person();
                p.Name = item.Id.ToString();//横坐标
                p.Score = item.Port;//折线
                listA.Add(p);

            }
            string xdata = "[";
            string ydata = "[";
            for (int i = 0; i < listA.Count; i++)
            {
                if (!string.IsNullOrEmpty(listA[i].Name))
                {
                    xdata += listA[i].Name == "" ? "0," : "'" + listA[i].Name + "'" + ",";//横坐标
                    ydata += listA[i].Score == -1 ? "0," : listA[i].Score + ",";//折线
                }

}

            xdata = xdata.Length > 1 ? xdata.Substring(0, xdata.Length - 1) + "]" : "";//横坐标集合
            ydata = ydata.Length > 1 ? ydata.Substring(0, ydata.Length - 1) + "]" : "";//折线集合
            if (xdata == "" && ydata == "")
            {
                return "";
            }
            else
            {
                return "[" + xdata + "," + ydata + "]";
            }
        }

index：

@{
ViewBag.Title = "Index";
}

<h2>
    Index</h2>
<script src="~/jquery.min.js"></script>
<script src="~/highcharts.js"></script>
<script src="~/JavaScript2.js"></script>
<div id="panel12" title="Twins" class="paneltitle">
    <div style="width: 75.5%; height: 550px;" id="GraveContainer">
    </div>
</div>

            }
        })
    }

    function showFaultRankLineChart(xdata, ydata, tipName, tipUnit) {
        $("#GraveContainer").highcharts({
            chart: {
                type: 'spline'
            },
            title: {
                text: "Twins",
                x: -20 //center
            },
            subtitle: {
                text: "Twins分析",
                x: -20
            },
            xAxis: {
                type: "string",
                categories: eval(xdata),
                gridLineWidth: 0,
                labels: {
                    rotation: 0, //旋转度数，显示
                    align: 'center',
                    style: {
                        fontSize: '13px'
                        //fontFamily: 'Verdana, sans-serif'
                    }
                }

            },
            yAxis: {
                title: {
                    text: tipName + " (" + tipUnit + ")"
                },
                gridLineWidth: 0,
                allowDecimals: false,
                plotLines: [{
                    value: 0,
                    width: 1,
                    color: '#808080'
                }],
                min: 0
            },
            plotOptions: {
                spline: {
                    marker: {
                        radius: 1,
                        lineColor: '#666666',
                        lineWidth: 1
                    }
                }
            },
            credits: {
                href: '',
                text: ''
            },
            tooltip: {
                formatter: function () {
                    var s = 'Twins: <b>' + this.x + '</b><br>';
                    s += 'love: <b>' + this.y + ' 次</b><br>';
                    return s;
                }
            },
            legend: {
                layout: 'vertical',
                align: 'right',
                verticalAlign: 'middle',
                borderWidth: 0
            },
            exporting: {
                // 是否允许导出
                enabled: true,
                // 按钮配置
                buttons: {
                    // 导出按钮配置
                    exportButton: {
                        menuItems: null,
                        onclick: function () {
                            this.exportChart();
                        }
                    },
                    // 打印按钮配置
                    printButton: {
                        enabled: false
                    }
                },
                // 文件名
                filename: "StationAnalysisChart"
                // 导出文件默认类型
                //type: 'application/pdf'
            },

            series: [{
                name: "次数",
                data: eval(ydata)
            }]
        });
    }

</script>

链接数据库：

HomeController控制器：

[HttpPost]
        public JsonResult FaultRankInit()
        {
            Highchasts cm = new Highchasts();
            string str = cm.Highchartsdata1();
            return Json(str, JsonRequestBehavior.AllowGet);
        }

转载于:https://www.cnblogs.com/pengshuai/p/5421819.html