Chart控件中数据点与Grid列表交互

Chart控件中数据点与Grid列表交互分为：

1、点击Chart控件中数据点时，选中Grid列表中相应行；

2、选中Grid列表汇总相应行，选中Chart控件中相应数据点

3、控制相应数据线的显示

 <asp:Chart ID="chAnalysis" Width="1025px" runat="server" BackGradientStyle="TopBottom"
            BackSecondaryColor="White" BackColor="WhiteSmoke" ImageLocation="~/TempImages/ChartPic_#SEQ(300,3)"
            Visible="False" OnClick="chAnalysis_Click">
            <Legends>
                <asp:Legend IsTextAutoFit="false" LegendStyle="Row" Alignment="Center" Docking="Bottom"
                    Name="Default" BackColor="Transparent" Font="Arial, 6pt">
                </asp:Legend>
            </Legends>
            <Series>
                <asp:Series Name="UpperLimit" ChartType="Line" Color="Red" BorderWidth="1">
                </asp:Series>
                <asp:Series Name="LowerLimit" ChartType="Line" Color="Red" BorderWidth="1">
                </asp:Series>
            </Series>
            <ChartAreas>
                <asp:ChartArea Name="ChartArea1" BorderColor="64,64,64,64" BackSecondaryColor="White"
                    BackColor="Gainsboro" ShadowColor="Transparent" BackGradientStyle="TopBottom">
                    <Area3DStyle Rotation="0" Perspective="10" Inclination="15" IsRightAngleAxes="false"
                        WallWidth="0" IsClustered="false" />
                    <AxisY LineColor="64,64,64,64">
                        <LabelStyle IntervalType="Number" />
                        <MajorGrid LineColor="64,64,64,64" />
                    </AxisY>
                    <AxisX LineColor="64,64,64,64">
                        <MajorGrid LineColor="64,64,64,64" />
                    </AxisX>
                </asp:ChartArea>
            </ChartAreas>
        </asp:Chart>

后台

 #region 绑定Chart
    /// <summary>
    /// 绑定Chart
    /// </summary>
    public void BindChart()
    {
        if (ViewState["dt"] == null) { return; }
        DataTable dtResult = (DataTable)ViewState["dt"];
        this.chAnalysis.Series["UpperLimit"].LegendText = "上限";
        this.chAnalysis.Series["UpperLimit"].ToolTip = "上限:#VALY";
        this.chAnalysis.Series["LowerLimit"].LegendText = "下限";
        this.chAnalysis.Series["LowerLimit"].ToolTip = "下限:#VALY";
        Dictionary<string, string> dict = (Dictionary<string, string>)ViewState["dict"];
        DataTable newdt = CreateWarnTable();
        decimal lowerLimit = decimal.Parse(dtResult.Rows[0]["MIN_LIMIT"].ToString());//下限
        decimal upperLimit = decimal.Parse(dtResult.Rows[0]["MAX_LIMIT"].ToString());//上限
        int k = 0;
        foreach (KeyValuePair<string, string> item in dict)
        {
            DataRow[] dr = dtResult.Select(" ct_smp_workshop='" + item.Value + "'");
            if (k == 0)
            {
                if (dr != null && dr.Length > 0)
                {
                    k = k + 1;
                    for (int i = 0; i < dr.Length; i++)
                    {
                        this.chAnalysis.Series["LowerLimit"].Points.AddXY(dr[i]["batch_name"].ToString(), dr[i]["MIN_LIMIT"].ToString());
                        this.chAnalysis.Series["UpperLimit"].Points.AddXY(dr[i]["batch_name"].ToString(), dr[i]["MAX_LIMIT"].ToString());
                    }
                }
            }
            if (dr != null && dr.Length > 0)
            {
                Series s = new Series();
                s.Name = item.Value;
                s.ChartType = SeriesChartType.Line;
                s.PostBackValue = "#AXISLABEL" + "," + item.Value;
                s.MarkerStyle = MarkerStyle.Square;
                s.ToolTip = string.Format("生产线:{0}\n批次:#VALX\n结果:#VALY", item.Value);
                for (int i = 0; i < dr.Length; i++)
                {
                    DataRow drr = newdt.NewRow();
                    s.Points.AddXY(dr[i]["batch_name"].ToString(), dr[i]["result_value"].ToString());
                    decimal resultData = decimal.Parse(dr[i]["result_value"].ToString());
                    drr["MIN_LIMIT"] = lowerLimit;
                    drr["MAX_LIMIT"] = upperLimit;
                    drr["result_value"] = resultData;
                    drr["batch_name"] = dr[i]["batch_name"].ToString();
                    drr["component_name"] = dr[i]["component_name"].ToString();
                    drr["ct_smp_workshop"] = item.Value;
                    if (resultData > upperLimit)
                    {
                        s.Points[i].MarkerColor = Color.Red;
                        newdt.Rows.Add(drr);
                    }
                    if (resultData < lowerLimit)
                    {
                        s.Points[i].MarkerColor = Color.Red;
                        newdt.Rows.Add(drr);
                    }
                }
                this.chAnalysis.Series.Add(s);
            }
        }
        chAnalysis.Titles.Add("检测项目质量回顾分析");
        //获得最大值，最小值
        DataView dv = dtResult.DefaultView;
        dv.Sort = "result_value desc";
        double max = double.Parse(dv[0]["result_value"].ToString());
        double min = double.Parse(dv[dv.Count - 1]["result_value"].ToString());
        double step = Math.Round((max - min) / 3, 0);
        double maxlimit = double.Parse(dtResult.Rows[0]["MAX_LIMIT"].ToString());
        double minlimit = double.Parse(dtResult.Rows[0]["MIN_LIMIT"].ToString());
        if (max < maxlimit)
        {
            max = maxlimit;
        }
        if (min > minlimit)
        {
            min = minlimit;
        }
        chAnalysis.ChartAreas[0].AxisY.Maximum = max + step;
        chAnalysis.ChartAreas[0].AxisY.Minimum = min - step;
        chAnalysis.ChartAreas[0].AxisY.Interval = step;
        chAnalysis.ChartAreas[0].AxisX.Interval = 1;
        this.chAnalysis.ChartAreas[0].AxisX.LabelStyle.Angle = 45;
       
        this.GridView1.DataSource = newdt;
        this.GridView1.DataBind();
    }
    #endregion

 #region mouseover,mouseout背景色
    /// <summary>
    /// mouseover,mouseout背景色
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void gv_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            e.Row.Attributes.Add("onclick", "this.style.backgroundColor='#ffffff'");
        }
    }
    #endregion

    #region Chart 控件事件
    /// <summary>
    /// Chart 控件事件
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void chAnalysis_Click(object sender, ImageMapEventArgs e)
    {
        string strValue = e.PostBackValue;
        string[] arr = strValue.Split(',');
        strValue = arr[0];
        string locationLine = arr[1];
        //int count = this.chAnalysis.Series.Count;
      
        for (int i = 0; i < gv.Rows.Count; i++)
        {
            HiddenField hidWorkshop = (HiddenField)this.gv.Rows[i].FindControl("hidWorkshop");
            this.gv.Rows[i].BackColor = Color.White;
            if (this.gv.DataKeys[i].Value.Equals(strValue) && hidWorkshop.Value == locationLine)
            {
                this.gv.Rows[i].BackColor = Color.Red;
            }
        }
        this.chAnalysis.Visible = true;
        this.panelch.Visible = true;
        this.itable.Visible = true;
        BindChart();
        for (int i = 0; i < this.chAnalysis.Series[locationLine].Points.Count; i++)
        {
            string xValue = this.chAnalysis.Series[locationLine].Points[i].AxisLabel.Trim();
            if (xValue == strValue)
            {
                this.chAnalysis.Series[locationLine].Points[i].MarkerColor = Color.Red;
                this.chAnalysis.Series[locationLine].Points[i].MarkerSize = 8;
                break;
            }
        }
        BindDotLine();
       
    }
    #endregion

    #region 删除线或者添加线
    /// <summary>
    /// 删除线或者添加线
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void btnCh_Click(object sender, EventArgs e)
    {
        BindChart();
        this.chAnalysis.Visible = true;
        Dictionary<string, string> dict = (Dictionary<string, string>)ViewState["dict"];
        if (dict.Count <= 0)
        {
            return;
        }
        if (!chbox.Items[0].Selected)
        {
            foreach (KeyValuePair<string, string> item in dict)
            {
                this.chAnalysis.Series.Remove(this.chAnalysis.Series[item.Value]);
            }
        }
        if (!chbox.Items[1].Selected)
        {
            for (int j = 0; j < this.chAnalysis.Series.Count; j++)
            {
                if (this.chAnalysis.Series[j].Name == "UpperLimit")
                {
                    this.chAnalysis.Series.Remove(this.chAnalysis.Series[j]);
                    break;
                }
            }
        }
        if (!chbox.Items[2].Selected)
        {
            for (int j = 0; j < this.chAnalysis.Series.Count; j++)
            {
                if (this.chAnalysis.Series[j].Name == "LowerLimit")
                {
                    this.chAnalysis.Series.Remove(this.chAnalysis.Series[j]);
                    break;
                }
            }
        }
        BindDotLine();

    }
    #endregion

    #region 绑定虚线
    /// <summary>
    /// 绑定虚线
    /// </summary>
    public void BindDotLine()
    {
        double d = 0.0;
        if (!string.IsNullOrEmpty(this.txtLine.Text.Trim()))
        {
            if (!double.TryParse(this.txtLine.Text.Trim(), out d))
            {
                return;
            }
            if (d > this.chAnalysis.ChartAreas[0].AxisY.Maximum)
            {
                return;
            }
            if (d < this.chAnalysis.ChartAreas[0].AxisY.Minimum)
            {
                return;
            }
            Series sline = new Series();
            sline.Name = "xuxian";
            sline.ChartType = SeriesChartType.Line;
            sline.BorderDashStyle = ChartDashStyle.Dot;
            if (ViewState["dt"] == null) { return; }
            DataTable dtResult = (DataTable)ViewState["dt"];
            for (int i = 0; i < dtResult.Rows.Count; i++)
            {
                sline.Points.AddXY(dtResult.Rows[i]["batch_name"].ToString(), d);
            }
            sline.LegendText = "虚线";
            this.chAnalysis.Series.Add(sline);
        }
    }
    #endregion

#region grid 引起chart数据点变化
    /// <summary>
    /// grid 引起chart数据点变化
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void gv_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
    {
        BindChart();
        HiddenField hidWorkshop = (HiddenField)this.gv.Rows[e.NewSelectedIndex].FindControl("hidWorkshop");
        HiddenField hidBatchname = (HiddenField)this.gv.Rows[e.NewSelectedIndex].FindControl("hidBatchname");
        int index = e.NewSelectedIndex;

        for (int i = 0; i < this.chAnalysis.Series[hidWorkshop.Value].Points.Count; i++)
        {
            this.gv.Rows[i].BackColor = Color.White;
            string yValue = this.chAnalysis.Series[hidWorkshop.Value].Points[i].AxisLabel.Trim();
            if (yValue == hidBatchname.Value)
            {
                this.gv.Rows[index].BackColor = Color.Red;
                this.chAnalysis.Series[hidWorkshop.Value].Points[i].MarkerSize = 8;
                this.chAnalysis.Series[hidWorkshop.Value].Points[i].MarkerColor = Color.Red;
            }
        }
        this.chAnalysis.Visible = true;
        this.panelch.Visible = true;
    }
    #endregion