Пример #1
0
    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;
        }
    }
Пример #2
0
    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();
    }
Пример #3
0
    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();
                    }
                }
            }
        }
    }
Пример #4
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.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; }
        //}
    }
Пример #5
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";
            }
        }
    }
Пример #6
0
    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);
            }
        }
    }
Пример #7
0
    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' }}}]";
            }
        }
    }
Пример #8
0
    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;
        }
    }
Пример #9
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());
        }
        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 + "},] },";
            }
        }
    }
Пример #10
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.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; }
        //}
    }
Пример #11
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 + "},]";
    }