NewCount.cshtml

﻿@{
    Layout = "~/_xuejiLayout.cshtml";

    var id = Request["classes_id"];
    var db = Database.Open("ctXueji");
    int normal = 0;
    int tardy = 0;
    int cut = 0;

    var name = db.QuerySingle("select * from View_classes_one where id=" + id);

    //var coursesArranging = "select * from coursesArranging";
    var classes = "select * from rollcall where classes_id=" + id;
    foreach (var row in db.Query(classes))
    {
        Dictionary<int, int> str = new Dictionary<int, int>();
        str = Functions.StringToDictionary(row.sid_state);
        foreach (var i in str)
        {
            switch (i.Value)
            {
                case 1:
                    normal++;
                    break;
                case 2:
                    cut++;
                    break;
                case 5:
                    cut++;
                    break;
                case 4:
                    tardy++;
                    break;
                default:
                    cut++;
                    break;
            }
        }
    }
            }
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Document</title>
    <script src="~/Scripts/highcharts.js"></script>
    <script src="~/Scripts/exporting.js"></script>
    <script src="~/Scripts/export-data.js"></script>

</head>
<body>

<div id="container" style="min-width: 310px; height: 400px; max-width: 600px; margin: 0 auto"></div>
<script>

    Highcharts.chart('container', {
        chart: {
            plotBackgroundColor: null,
            plotBorderWidth: null,
            plotShadow: false,
            type: 'pie'
        },
        title: {
            text: '@name.classes_year@name.majors_name'
        },
        tooltip: {
            pointFormat: '{series.name}: <b>{point.percentage:.1f}%</b>'
        },
        plotOptions: {
            pie: {
                allowPointSelect: true,
                cursor: 'pointer',
                dataLabels: {
                    enabled: true,
                    format: '<b>{point.name}</b>: {point.percentage:.1f} %',
                    style: {
                        color: (Highcharts.theme && Highcharts.theme.contrastTextColor) || 'black'
                    }
                }
            }
        },
        series: [{
            name: 'Brands',
            colorByPoint: true,

            data: [{
                name: '正常出勤',
                y: @normal,
                sliced: true,
                selected: true
            }, {
                name: '旷课',
                y: @cut
            }, {
                name: '迟到',
                y: @tardy
            }]
        }]
    });
</script>	
</body>
</html>