private void setBarTitle() { int RP_Code = int.Parse(Request.QueryString["MF_FL_FB_Code"].ToString()); BL_HighCharts HC = new BL_HighCharts(); DataTable dt = HC.getBarTitle(RP_Code); if (dt != null || dt.Rows.Count != 0) { BarTitle = dt.Rows[0]["FB_TITLE"].ToString(); X1 = dt.Rows[0]["FB_X1_LABEL"].ToString(); Y1 = dt.Rows[0]["FB_Y1_LABEL"].ToString(); Font = dt.Rows[0]["FB_X1_Font"].ToString(); string[] _Param = { "0" }; if (dt.Rows[0]["FB_Parameters"] != null) { dt.Rows[0]["FB_Parameters"].ToString().Split(new string[] { "||" }, StringSplitOptions.None); } if (_Param.Length > 0) { if (_Param[0] == "0") //No Legend { Legend = "enabled: false,"; } else if (_Param[0] == "1") //Top Right Legend { Legend = "layout:'horizontal', align: 'right', verticalAlign: 'top', x: -25, y: -10,"; } else if (_Param[0] == "2") //Left Legend { Legend = "layout: 'vertical', align: 'left', verticalAlign: 'top', x: 0, y: 0,"; } else //default Parameters { Legend = "layout:'horizontal', align: 'right', verticalAlign: 'top', x: -25, y: -10,"; } } if (string.IsNullOrEmpty(dt.Rows[0]["FB_X1_Font"].ToString())) { Font = "8"; } if (string.IsNullOrEmpty(dt.Rows[0]["FB_X1_Format"].ToString())) { Format = "¥"; } else if (dt.Rows[0]["FB_X1_Format"].ToString() == "1") { Format = "$"; } else { Format = ""; } } string _title = HttpUtility.UrlDecode(RequestClass.GetString("Title"), Encoding.UTF8); if (!string.IsNullOrEmpty(_title)) { BarTitle = _title; } }
private void setPieData() { int MF_FL_FB_Code = int.Parse(Request.QueryString["MF_FL_FB_Code"].ToString()); BL_HighCharts HC = new BL_HighCharts(); DataTable dt = HC.getPieData(MF_FL_FB_Code, out RP_Code, 0); StringBuilder SB = new StringBuilder(); SB.Append("[{type: 'pie',"); SB.Append("name: '',"); SB.Append("data: ["); for (int i = 0; i < dt.Rows.Count; i++) { if (i == dt.Rows.Count - 1) { SB.Append("{ "); SB.Append("name: '" + dt.Rows[i][0] + "', "); SB.Append(" y: " + dt.Rows[i][1] + ", "); SB.Append(" sliced: true, "); SB.Append(" selected: true "); SB.Append(" } "); } else { SB.Append("['" + dt.Rows[i][0] + "', " + dt.Rows[i][1] + "],"); } } SB.Append("]"); SB.Append("}]"); PieData = SB.ToString(); }
private void setPieTitle() { int RP_Code = int.Parse(Request.QueryString["MF_FL_FB_Code"].ToString()); BL_HighCharts HC = new BL_HighCharts(); DataTable dt = HC.getPieTitleII(RP_Code); if (dt != null) { if (dt.Rows.Count != 0) { string _title = HttpUtility.UrlDecode(RequestClass.GetString("Title"), Encoding.UTF8); if (!string.IsNullOrEmpty(_title)) { PieTitle = _title; } string[] _Param = dt.Rows[0]["FP_Parameters"].ToString().Split(new string[] { "||" }, StringSplitOptions.None); if (_Param.Length > 0) { if (_Param[0] == "0") //No Legend { Legend = "enabled: false,"; } else if (_Param[0] == "1") //Top Right Legend { Legend = "layout:'horizontal', align: 'right', verticalAlign: 'top', x: -25, y: -10,"; } else if (_Param[0] == "2") //Left Legend { Legend = "layout: 'vertical', align: 'left', verticalAlign: 'top', x: 0, y: 0,"; } else //default Parameters { Legend = "layout:'horizontal', align: 'right', verticalAlign: 'top', x: -25, y: -10,"; } } if (_Param.Length > 1) { if (_Param[1] == "0") //No Title { PieTitle = ""; } else if (_Param[1] == "1") //Use the FP_Title field { PieTitle = dt.Rows[0]["FP_Title_CN"].ToString(); } } } } }
private void GetData() { if (string.IsNullOrEmpty(Request.QueryString["MF_FL_FB_Code"].ToString())) { return; } int Code = int.Parse(Request.QueryString["MF_FL_FB_Code"]); int PR = 0; if (null != Request.QueryString["PR"]) { PR = int.Parse(Request.QueryString["PR"].ToString()); } BL_HighCharts HC = new BL_HighCharts(); DataTable dt_param = HC.getDGaugParam(Code); if (dt_param == null || dt_param.Rows.Count == 0) { return; } string Lng = Interna ? "_EN" : "_CN"; string[] Xp1 = dt_param.Rows[0]["FG_TITLE" + Lng].ToString().Split(new string[] { "||" }, StringSplitOptions.None); _title1 = Xp1[0]; _title2 = Xp1[1]; Xp1 = dt_param.Rows[0]["FG_Text" + Lng].ToString().Split(new string[] { "||" }, StringSplitOptions.None); _label1 = Xp1[0]; _label2 = Xp1[1]; //int RP_Code = int.Parse(dt_param.Rows[0]["FG_RP_Code"].ToString()); //DataTable dt_Data = HC.getMultiData(RP_Code, PR); //if (dt_Data == null || dt_Data.Rows.Count == 0) { return; } //for (int j = 0; j < dt_Data.Rows.Count; j++) //{ // if (k > 0) { YDATA = YDATA + ","; } // if (!string.IsNullOrEmpty(dt_Data.Rows[j][Col].ToString())) // { // k++; // YDATA = YDATA + "[Date.UTC(" + ConvS_UTC(dt_Data.Rows[j][0].ToString()) + ")," + dt_Data.Rows[j][Col].ToString() + "]"; // } // else { k = 0; } //} }
private void setSchTitle() { int RP_Code = int.Parse(Request.QueryString["MF_FL_FB_Code"].ToString()); BL_HighCharts HC = new BL_HighCharts(); DataTable dt = HC.getSchTitle(RP_Code); if (dt != null || dt.Rows.Count != 0) { SchTitle = dt.Rows[0]["FS_TITLE"].ToString(); X1 = dt.Rows[0]["FS_X1_LABEL"].ToString(); Y1 = dt.Rows[0]["FS_Y1_LABEL"].ToString(); Font = dt.Rows[0]["FS_X1_Font"].ToString(); if (string.IsNullOrEmpty(dt.Rows[0]["FS_X1_Font"].ToString())) { Font = "8"; } } }
private void setBarData() { string Code = Request.QueryString["MF_FL_FB_Code"].ToString(); int PR = 0; if (null != Request.QueryString["PR"]) { PR = int.Parse(Request.QueryString["PR"].ToString()); } if (!string.IsNullOrEmpty(Code)) { int RP_Code = int.Parse(Code); BL_HighCharts Hichart = new BL_HighCharts(); DataTable dt_Bar = Hichart.getColumnData(RP_Code, PR); if (dt_Bar != null && dt_Bar.Rows.Count != 0) { YDATA = Fill_Data(dt_Bar, 0); xAxis = Fill_Data(dt_Bar); } } }
private void setSchData() { string Code = Request.QueryString["MF_FL_FB_Code"].ToString(); int PR = 0; if (null != Request.QueryString["PR"]) { PR = int.Parse(Request.QueryString["PR"].ToString()); } if (!string.IsNullOrEmpty(Code)) { int RP_Code = int.Parse(Code); BL_HighCharts Hichart = new BL_HighCharts(); DataTable dt_Sch = Hichart.getSchData(RP_Code, PR); if (dt_Sch != null && dt_Sch.Rows.Count != 0) { YBand = Fill_Data(dt_Sch, 0); xAxis = Fill_Data(dt_Sch); xNow = "[{ from: Date.UTC(" + ConvUTC(DateTime.Today.AddDays(-1)) + "), to:Date.UTC( " + ConvUTC(DateTime.Today) + "), color: 'rgba(185,8,37,0.5)', label: { text: '" + Resources.CRMTREEResource.SchedNow + "', style: { color: 'black' }}}]"; } } }
private void setBarTitle() { int RP_Code = int.Parse(Request.QueryString["MF_FL_FB_Code"].ToString()); BL_HighCharts HC = new BL_HighCharts(); DataTable dt = HC.getBarTitle(RP_Code); if (dt != null || dt.Rows.Count != 0) { BarTitle = dt.Rows[0]["FB_TITLE"].ToString(); X1 = dt.Rows[0]["FB_X1_LABEL"].ToString(); Y1 = dt.Rows[0]["FB_Y1_LABEL"].ToString(); Font = dt.Rows[0]["FB_X1_Font"].ToString(); if (string.IsNullOrEmpty(dt.Rows[0]["FB_X1_Font"].ToString())) { Font = "8"; } if (string.IsNullOrEmpty(dt.Rows[0]["FB_X1_Format"].ToString())) { Format = "¥"; } else if (dt.Rows[0]["FB_X1_Format"].ToString() == "1") { Format = "$"; } else { Format = ""; } } string _title = HttpUtility.UrlDecode(RequestClass.GetString("Title"), Encoding.UTF8); if (!string.IsNullOrEmpty(_title)) { BarTitle = _title; } }
private void GetData() { if (string.IsNullOrEmpty(Request.QueryString["MF_FL_FB_Code"].ToString())) { return; } int Code = int.Parse(Request.QueryString["MF_FL_FB_Code"]); int PR = 0; if (null != Request.QueryString["PR"]) { PR = int.Parse(Request.QueryString["PR"].ToString()); } string Lng = Interna ? "_EN" : "_CN"; DataTable dt_Data; BL_HighCharts HC = new BL_HighCharts(); DataTable dt_param = HC.getDrillParam(Code); if (dt_param == null || dt_param.Rows.Count == 0) { return; } int RP_Code = 0; for (int r = 0; r < dt_param.Rows.Count; r++) { int RP_Code1 = int.Parse(dt_param.Rows[r]["FD_RP_Code"].ToString()); if (RP_Code != RP_Code1) { RP_Code = RP_Code1; } dt_Data = HC.getDrillData(RP_Code, PR); if (dt_Data == null || dt_Data.Rows.Count == 0) { return; } string _title = HttpUtility.UrlDecode(RequestClass.GetString("Title"), Encoding.UTF8); if (!string.IsNullOrEmpty(_title)) { ChartTit = _title; } else { ChartTit = "" + dt_param.Rows[0]["FD_TITLE" + Lng].ToString() + ""; } int Level = int.Parse(dt_param.Rows[r]["FD_Level"].ToString()); string[] Xp1 = dt_param.Rows[r]["FD_X" + Lng].ToString().Split(new string[] { "||" }, StringSplitOptions.None); XTit = ",xAxis: ["; for (int i = 0; i < Xp1.Length; i++) { if (i > 0) { XTit = XTit + ","; } string[] Xp2 = Xp1[i].Split(','); XTit = XTit + " {"; XTit = XTit + " title:{text:'" + Xp2[0].ToString() + "'}"; XTit = XTit + ", type: 'datetime', dateTimeLabelFormats: {month: '%e. %b',year: '%b' }"; XTit = XTit + " ,labels:{"; XTit = XTit + " style: {fontSize: '" + Xp2[1].ToString() + "px' , fontFamily: 'Verdana, sans-serif'}"; XTit = XTit + "}"; XTit = XTit + "}]"; } string[] Yp1 = dt_param.Rows[r]["FD_Y" + Lng].ToString().Split(new string[] { "||" }, StringSplitOptions.None); YTit = ",yAxis: ["; for (int i = 0; i < Yp1.Length; i++) { if (i > 0) { YTit = YTit + ","; } string[] Yp2 = Yp1[i].Split(','); YTit = YTit + " {"; YTit = YTit + " title:{text:'" + Yp2[0].ToString() + "'}"; YTit = YTit + " ,labels:{"; YTit = YTit + " style: {fontSize: '" + Yp2[1].ToString() + "px' , fontFamily: 'Verdana, sans-serif'}"; YTit = YTit + ",formatter: function () {return " + Yp2[2].ToString() + " + this.value;}"; YTit = YTit + "}"; if (i > 0) { YTit = YTit + ",opposite: true"; } YTit = YTit + "}"; } YTit = YTit + "]"; string[] Dp1 = dt_param.Rows[r]["FD_Data"].ToString().Split(new string[] { "||" }, StringSplitOptions.None); for (int i = 0; i < Dp1.Length; i++) { string Cur_X = ""; if (Level == 1) { YDATA = YDATA + " series: ["; } else { YDATA = YDATA + " drilldown: { series: ["; } // string[] Xp2 = Xp1[i].Split(','); string[] Yp2 = Yp1[i].Split(','); if (i > 0) { YDATA = YDATA + "},"; } string[] Dp2 = Dp1[i].Split(','); // string[] Yp2 = Yp1[int.Parse(Xp2[4])].Split(',');//this needs to be fixed int XCol = int.Parse(Dp2[0]); int YCol = int.Parse(Dp2[1]); int IDCol = int.Parse(Dp2[2]); int DCol = int.Parse(Dp2[3]); int k = 0; if (Level == 1) { YDATA = YDATA + "{type:'" + Dp2[4] + "'"; YDATA = YDATA + ", borderWidth: 0 "; // YDATA = YDATA + ", tooltip: {valueSuffix: "+Yp2[2]+"}"; YDATA = YDATA + ", title: {text:'My Title1" + Dp2[5] + "'}"; YDATA = YDATA + ", subtitle: {text:'My SubTitle1" + Dp2[5] + "'}"; YDATA = YDATA + ", xAxis:" + Dp2[5]; YDATA = YDATA + ", yAxis:" + Dp2[6]; YDATA = YDATA + ", name:'" + dt_Data.Columns[YCol].ColumnName.ToString() + "'"; if (Dp2[7].Trim() != "") { YDATA = YDATA + ", pointPadding:" + Dp2[7]; } if (Dp2[8].Trim() != "") { YDATA = YDATA + ", pointPlacement:" + Dp2[8]; } if (Dp2[9].Trim() != "") { YDATA = YDATA + ", color:'" + Dp2[9] + "'"; } YDATA = YDATA + ", data: ["; } for (int j = 0; j < dt_Data.Rows.Count; j++) { if (k > 0) { YDATA = YDATA + ","; } if (!string.IsNullOrEmpty(dt_Data.Rows[j][XCol].ToString())) { k++; if (Level > 1 && Cur_X != dt_Data.Rows[j][IDCol].ToString()) { if (Cur_X != "") { YDATA = YDATA + "]},"; } Cur_X = dt_Data.Rows[j][IDCol].ToString(); YDATA = YDATA + "{type:'" + Dp2[4] + "'"; YDATA = YDATA + ", borderWidth: 0 "; YDATA = YDATA + ", title: {text:'My Title1" + Dp2[5] + "'}"; YDATA = YDATA + ", subtitle: {text:'My SubTitle1" + Dp2[5] + "'}"; // YDATA = YDATA + ", tooltip: {valueSuffix: "+Yp2[2]+"}"; //YDATA = YDATA + ", xAxis:" + Dp2[5]; //YDATA = YDATA + ", yAxis:" + Dp2[6]; //YDATA = YDATA + ", name:'" + dt_Data.Columns[YCol].ColumnName.ToString() + "'"; if (Dp2[7].Trim() != "") { YDATA = YDATA + ", pointPadding:" + Dp2[7]; } if (Dp2[8].Trim() != "") { YDATA = YDATA + ", pointPlacement:" + Dp2[8]; } if (Dp2[9].Trim() != "") { YDATA = YDATA + ", color:'" + Dp2[9] + "'"; } YDATA = YDATA + ", name:'" + dt_Data.Columns[YCol].ColumnName.ToString() + "'"; YDATA = YDATA + ", id:'" + dt_Data.Rows[j][IDCol].ToString() + "'"; YDATA = YDATA + ", data: ["; } YDATA = YDATA + "{y:" + dt_Data.Rows[j][YCol].ToString() + ""; YDATA = YDATA + ", name:'" + dt_Data.Rows[j][XCol].ToString() + "'"; YDATA = YDATA + ", drilldown:'" + dt_Data.Rows[j][DCol].ToString() + "'}"; } else { k = 0; } } YDATA = YDATA + "]"; } if (Level == 1) { YDATA = YDATA + "},],"; } else { YDATA = YDATA + "},] },"; } } }
private void GetData() { if (string.IsNullOrEmpty(Request.QueryString["MF_FL_FB_Code"].ToString())) { return; } int Code = int.Parse(Request.QueryString["MF_FL_FB_Code"]); int PR = 0; if (null != Request.QueryString["PR"]) { PR = int.Parse(Request.QueryString["PR"].ToString()); } BL_HighCharts HC = new BL_HighCharts(); DataTable dt_param = HC.getDGaugParam(Code); if (dt_param == null || dt_param.Rows.Count == 0) { return; } int RP_Code = int.Parse(dt_param.Rows[0]["FG_RP_Code"].ToString()); DataTable dt_Data = HC.getGaugeData(RP_Code, PR); if (dt_Data == null || dt_Data.Rows.Count == 0) { return; } string Lng = Interna ? "_EN" : "_CN"; string[] _titles = dt_param.Rows[0]["FG_TITLE" + Lng].ToString().Split(new string[] { "||" }, StringSplitOptions.None); string[] _labels = dt_param.Rows[0]["FG_Text" + Lng].ToString().Split(new string[] { "||" }, StringSplitOptions.None); string[] _Data = dt_param.Rows[0]["FG_Attributes"].ToString().Split(new string[] { "||" }, StringSplitOptions.None); string _goal = ""; string _max = ""; string _val = ""; int Row = 0; int _Width = (Convert.ToInt32(MaxWidth) / _Data.Length); int _Height = Convert.ToInt32(Maxheigth);// Convert.ToInt32((2.25 * _Width) / 3); for (int i = 0; i < _Data.Length; i++) { _Div = _Div + "<div id=\"cont_" + i + "\" style=\"width: " + _Width.ToString() + "px; height: " + _Height.ToString() + "px; float: left\"></div>"; //Get the KPI Data _goal = "10"; _val = "12"; if (_Data[i] != null && _Data[i] != "") { Row = Convert.ToInt32(_Data[i]); } if (!string.IsNullOrEmpty(dt_Data.Rows[Row][0].ToString())) { _goal = dt_Data.Rows[Row][0].ToString(); } if (!string.IsNullOrEmpty(dt_Data.Rows[Row][1].ToString())) { _val = dt_Data.Rows[Row][1].ToString(); } else { _val = "0"; } _max = (float.Parse(_goal) * 1.5).ToString(); _YAxis = _YAxis + "$('#cont_" + i.ToString() + "').highcharts(Highcharts.merge(gaugeOptions, {" + " yAxis: {" + " min: 0," + " max: " + _max + "," + " plotBands: [{" + " from: 0," + " to: " + _goal + "," + " color: '#DDDF0D'" + // yellow " }, {" + " from: " + _goal + "," + " to: " + _max + "," + " color: '#55BF3B'" + // green " }]," + " title: {" + // " text: '" + _titles[i] + " text: '[" + dt_Data.Rows[Row][4] + "] " + dt_Data.Rows[Row][5] + "' }" + " }," + " series: [{" + // " name: '"+_titles[i]+"',"+ " name: '" + dt_Data.Rows[Row][4] + " " + dt_Data.Rows[Row][5] + "'," + " data: [" + _max + "]," + " dataLabels: {" + " format: '<div style=\"text-align:center\"><span style=\"font-size:25px;color:' +" + " ((Highcharts.theme && Highcharts.theme.contrastTextColor) || 'black') + '\">{y}</span><br/>' +" + " '<span style=\"font-size:12px;color:silver\"> " + _labels[i] + " </span></div>'" + " }," + " tooltip: {" + " valueSuffix: ' '" + " }" + " }]" + " }));"; _Life = _Life + " $('#cont_" + i.ToString() + "').highcharts().series[0].points[0].update(eval(" + _val + "));"; } _Life = _Life + " clearInterval(MyTimer);}, 1000);"; //for (int j = 0; j < dt_Data.Rows.Count; j++) //{ // if (k > 0) { YDATA = YDATA + ","; } // if (!string.IsNullOrEmpty(dt_Data.Rows[j][Col].ToString())) // { // k++; // YDATA = YDATA + "[Date.UTC(" + ConvS_UTC(dt_Data.Rows[j][0].ToString()) + ")," + dt_Data.Rows[j][Col].ToString() + "]"; // } // else { k = 0; } //} }
private void GetData() { if (string.IsNullOrEmpty(Request.QueryString["MF_FL_FB_Code"].ToString())) { return; } int Code = int.Parse(Request.QueryString["MF_FL_FB_Code"]); int PR = 0; if (null != Request.QueryString["PR"]) { PR = int.Parse(Request.QueryString["PR"].ToString()); } BL_HighCharts HC = new BL_HighCharts(); DataTable dt_param = HC.getMultiParam(Code); if (dt_param == null || dt_param.Rows.Count == 0) { return; } string Lng = Interna ? "_EN" : "_CN"; int RP_Code = int.Parse(dt_param.Rows[0]["FM_RP_Code"].ToString()); DataTable dt_Data = HC.getMultiData(RP_Code, PR); if (dt_Data == null || dt_Data.Rows.Count == 0) { return; } string _title = HttpUtility.UrlDecode(RequestClass.GetString("Title"), Encoding.UTF8); if (!string.IsNullOrEmpty(_title)) { ChartTit = _title; } else { ChartTit = "" + dt_param.Rows[0]["FM_TITLE" + Lng].ToString() + ""; } string[] Xp1 = dt_param.Rows[0]["FM_X" + Lng].ToString().Split(new string[] { "||" }, StringSplitOptions.None); XTit = "["; for (int i = 0; i < Xp1.Length; i++) { if (i > 0) { XTit = XTit + ","; } string[] Xp2 = Xp1[i].Split(','); XTit = XTit + "{"; XTit = XTit + " title:{text:'" + Xp2[0].ToString() + "'}"; XTit = XTit + ", type: 'datetime', dateTimeLabelFormats: {month: '%e. %b',year: '%b' }"; XTit = XTit + " ,labels:{"; XTit = XTit + " style: {fontSize: '" + Xp2[1].ToString() + "px' , fontFamily: 'Verdana, sans-serif'}"; XTit = XTit + "}"; XTit = XTit + "}]"; } string[] Yp1 = dt_param.Rows[0]["FM_Y" + Lng].ToString().Split(new string[] { "||" }, StringSplitOptions.None); YTit = "["; for (int i = 0; i < Yp1.Length; i++) { if (i > 0) { YTit = YTit + ","; } string[] Yp2 = Yp1[i].Split(','); YTit = YTit + "{"; YTit = YTit + " title:{text:'" + Yp2[0].ToString() + "'}"; YTit = YTit + " ,labels:{"; YTit = YTit + " style: {fontSize: '" + Yp2[1].ToString() + "px' , fontFamily: 'Verdana, sans-serif'}"; YTit = YTit + ",formatter: function () {return " + Yp2[2].ToString() + " + this.value;}"; YTit = YTit + "}"; if (i > 0) { YTit = YTit + ",opposite: true"; } YTit = YTit + "}"; } YTit = YTit + "]"; string[] Dp1 = dt_param.Rows[0]["FM_Data"].ToString().Split(new string[] { "||" }, StringSplitOptions.None); YDATA = "["; for (int i = 0; i < Dp1.Length; i++) { if (i > 0) { YDATA = YDATA + "},"; } string[] Xp2 = Dp1[i].Split(','); string[] Yp2 = Yp1[int.Parse(Xp2[2])].Split(','); int Col = int.Parse(Xp2[0]); int k = 0; YDATA = YDATA + "{type:'" + Xp2[1] + "'"; YDATA = YDATA + ", borderWidth: 0 "; YDATA = YDATA + ", tooltip: {valueSuffix: " + Yp2[2] + "}"; YDATA = YDATA + ", yAxis:" + Xp2[2]; YDATA = YDATA + ", name:'" + dt_Data.Columns[Col].ColumnName.ToString() + "'"; if (Xp2[3].Trim() != "") { YDATA = YDATA + ", pointPadding:" + Xp2[3]; } if (Xp2[4].Trim() != "") { YDATA = YDATA + ", pointPlacement:" + Xp2[4]; } if (Xp2[5].Trim() != "") { YDATA = YDATA + ", color:'" + Xp2[5] + "'"; } YDATA = YDATA + ", data: ["; for (int j = 0; j < dt_Data.Rows.Count; j++) { if (k > 0) { YDATA = YDATA + ","; } if (!string.IsNullOrEmpty(dt_Data.Rows[j][Col].ToString())) { k++; YDATA = YDATA + "[Date.UTC(" + ConvS_UTC(dt_Data.Rows[j][0].ToString()) + ")," + dt_Data.Rows[j][Col].ToString() + "]"; } else { k = 0; } } YDATA = YDATA + "]"; } YDATA = YDATA + "},]"; }