如何使用jquery在asp.net中使用高图表插入和检索来自多维数组的数据 [英] how to insert and retrive data from multidimentional array using high charts in asp.net using jquery

问题描述

</script>
    <script type="text/javascript">
        $(document).ready(function () {
            $.ajax({
                type: "POST",
                contentType: "application/json; charset=utf-8",
                url: "Services/HighchartService.asmx/FruitAnalysis2",
                data: "{}",
                totaldata: "{}",
                dataType: "json",
                success: function (Result) {
                    Result = Result.d;
                    var data = [];

                    var totaldata = [{}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}]; //this declaration is correct for multi dimensional array i want 12 rows and 5 columns
                    var datesofh = [];
                    var m = 0;

                    var hours = Result[0].Name;
                    var dateex = Result[0].date;
                    var datesArray = new Array();
                    datesArray.push(dateex);

                    for (var r in Result) {
                        if (dateex != Result[r].date) {
                            dateex = Result[r].date;
                            datesArray.push(dateex);
                        }
                    }
                    for (var j in datesArray) {
                        for (var i in Result) {

                            if (i == 0) {

                            }
                            else {
                                m++;

                            }

                            var ser1 = new Array(Result[i].date);
                            if (datesArray[j] == Result[i].date) {
                                var serie = new Array(Result[i].Name, Result[i].Value, Result[i].date);
                                totaldata[j][m] = serie;  //here i didnt get multiple columns
                            }
                        }
                        m = 0;

                    }


                    DreawChart2(totaldata, datesArray);
                },
                error: function (Result) {
                    alert("Error");
                }
            });
        });


        function DreawChart2(series, data1) {
            var seriesk = [];
            var dataarray = [{}, {}, {}, {}, {}, {}, {}, {}];
            var r = 0;
            for (var i in data1) {
                for (var j = 0; j < 17; j++) {
                     dataarray[i][j] = series[i][j];  //here also i got  first row data how can i retrieve second and third rows 
                }
                seriesk.push({ name: data1[i],
                    data:dataarray[i][j] // here how to run a loop for j value
                });
            }

            $('#container2').highcharts({
                chart: {
                    type: 'column'
                },
                title: {
                    text: 'Day Print _ Hourly _ Sales'
                },

                plotOptions: {
                    column: {
                        dataLabels: {
                            enabled: false
                        }
                    }
                },
                credits: {
                    enabled: false
                },
                series: seriesk
            });
        }

推荐答案

（document）.ready（function（）{

(document).ready(function () {

.ajax（{
type： POST，
contentType： application / json; charset = utf-8，
url： Services / HighchartService.asmx / FruitAnalysis2，
data： {}，
totaldata： {}，
dataType： json，
success：function（Result）{
Result = Result.d;
var data = [];

var totaldata = [{}，{}，{}，{}，{}，{}，{}，{}，{}，{ }，{}，{}]; // 此声明适用于我想要12行和5列的多维数组
< span class =code-keyword> var datesofh = [];
var m = 0 ;

var hours =结果[ 0 ]。名称;
var dateex =结果[ 0 ]。date;
var datesArray = new Array（）;
datesArray.push（dateex）;

for （ var r in 结果）{
if （dateex！= Result [r] .date）{
dateex = Result [r]。日期;
datesArray.push（dateex）;
}
}
for （ var j datesArray）{
for （ var i in 结果）{

if （i == 0 ）{

}
else {
m ++;

}

var ser1 = new 数组（结果[I] .date）;
if （datesArray [j] == Result [i] .date）{
var serie = new 数组（Result [i] .Name，Result [i] .Value，Result [i] .date）;
totaldata [j] [m] =系列; // 这里我没有得到多列
}
}
m = 0 ;

}


DreawChart2（totaldata，datesArray）;
}，
错误：函数（结果）{
alert（ 错误 ）;
}
}）;
}）;


函数DreawChart2（系列，数据1）{
var seriesk = [];
var dataarray = [{}，{}，{}，{}，{}，{}，{}，{}];
var r = 0 ;
for （ var i in data1）{
for （ var j = 0 ; j < 17 ; j ++）{
dataarray [i ] [j] =系列[i] [j]; // 这里我还得到第一行数据如何检索第二行和第三行
}
seriesk.push（{name：data1 [i]，
data：dataarray [i] [j] // 这里如何为j值运行循环
}）;
}

.ajax({ type: "POST", contentType: "application/json; charset=utf-8", url: "Services/HighchartService.asmx/FruitAnalysis2", data: "{}", totaldata: "{}", dataType: "json", success: function (Result) { Result = Result.d; var data = []; var totaldata = [{}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}, {}]; //this declaration is correct for multi dimensional array i want 12 rows and 5 columns var datesofh = []; var m = 0; var hours = Result[0].Name; var dateex = Result[0].date; var datesArray = new Array(); datesArray.push(dateex); for (var r in Result) { if (dateex != Result[r].date) { dateex = Result[r].date; datesArray.push(dateex); } } for (var j in datesArray) { for (var i in Result) { if (i == 0) { } else { m++; } var ser1 = new Array(Result[i].date); if (datesArray[j] == Result[i].date) { var serie = new Array(Result[i].Name, Result[i].Value, Result[i].date); totaldata[j][m] = serie; //here i didnt get multiple columns } } m = 0; } DreawChart2(totaldata, datesArray); }, error: function (Result) { alert("Error"); } }); }); function DreawChart2(series, data1) { var seriesk = []; var dataarray = [{}, {}, {}, {}, {}, {}, {}, {}]; var r = 0; for (var i in data1) { for (var j = 0; j < 17; j++) { dataarray[i][j] = series[i][j]; //here also i got first row data how can i retrieve second and third rows } seriesk.push({ name: data1[i], data:dataarray[i][j] // here how to run a loop for j value }); }

（' ＃container2'） .highcharts（{
chart：{
type：' column'
}，
title：{
text：' Day Print _ Hourly _ Sales'
}，

plotOptions：{
column：{
dataLabels：{
enabled： false
}
}
}，
点数：{
enabled： false
}，
系列：seriesk
}）;
}

('#container2').highcharts({ chart: { type: 'column' }, title: { text: 'Day Print _ Hourly _ Sales' }, plotOptions: { column: { dataLabels: { enabled: false } } }, credits: { enabled: false }, series: seriesk }); }

这篇关于如何使用jquery在asp.net中使用高图表插入和检索来自多维数组的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！