devbox
盐析白兔
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

WPF柱状图（支持数据库动态更新）

作者：盐析白兔 | 2024-03-20 04:38:35

赞

踩

columnseries在wpf中的意识

  之前我们讲到wpf组件基类以及组件开发，现在我们围绕之前的内容去开发一个组件。

效果图请加群查看，在群共享里面。

 

 做出这个呢  是比较繁琐的。

首先要使用我们的基类

继承基类的模板自动生成如下几个文件：HrvColumnSeries这四个文件   HrvColumnSeries.cs是去设置组件的名称和组件在列表上显示的图片，我们所做的组件不是在vs上使用，而是在我们自己开发的设计器上，所以需要这些。

代码如下：

  1.  public class HrvColumnSeries : ComponentBase
  2.     {
  3.         public HrvColumnSeries()
  4.         {
  5.             Content = new HrvColumnSeriesShape();
  6.         }
  7.  
  8.         public override string TextName
  9.         {
  10.             get { return "HrvColumnSeries"; }
  11.         }
  12.  
  13.         public override string IconName
  14.         {
  15.             get { return "HrvColumnSeries.png"; }
  16.         }
  17.     }

　　HrvColumnSeriesEvent.cs 文件    组件在使用时有相应的事件  比如一个button也有click事件 这是我们的事件  一下为例子：

  1. public class HrvColumnSeriesEvent : ComponentEventBase
  2.     {
  3.         private string _Click;
  4.  
  5.         [Category("基础事件")]
  6.         [Description("单击事件.")]
  7.         [EventInfo("Click")]
  8.         public string Click
  9.         {
  10.             get { return _Click; }
  11.             set
  12.             {
  13.                 if (_Click == value) return;
  14.                 _Click = value;
  15.                 OnPropertyChanged("Click");
  16.             }
  17.         }
  18.  
  19.         public void OnClick(object sender, RoutedEventArgs e)
  20.         {
  21.             if (Click != null)
  22.             {
  23.             }
  24.         }
  25.     }

　　毫无疑问HrvColumnSeriesProperty.cs 这个就是我们的组件属性了

因为这一章不只是组件  还有数据库数据更新   前台动态更新。

所以属性就比较多如下：

  1. public class HrvColumnSeriesProperty : ComponentPropertyBase
  2.     {
  3.         private static string _ComputerName = ".\\sqlexpress";
  4.  
  5.         [Category("数据源")]
  6.         [Description("计算机名称")]
  7.         public string ComputerName
  8.         {
  9.             get { return _ComputerName; }
  10.             set
  11.             {
  12.                 _ComputerName = value;
  13.                 OnPropertyChanged("ComputerName");
  14.             }
  15.         }
  16.  
  17.  
  18.         private string _DataBaseName = "ColumnSeriesDB";
  19.  
  20.         [Category("数据源")]
  21.         [Description("数据库名称")]
  22.         public string DataBaseName
  23.         {
  24.             get { return _DataBaseName; }
  25.             set
  26.             {
  27.                 _DataBaseName = value;
  28.                 OnPropertyChanged("DataBaseName");
  29.             }
  30.         }
  31.  
  32.  
  33.         private string _UID = "sa";
  34.  
  35.         [Category("数据源")]
  36.         [Description("用户名")]
  37.         public string UID
  38.         {
  39.             get { return _UID; }
  40.             set
  41.             {
  42.                 _UID = value;
  43.                 OnPropertyChanged("UID");
  44.             }
  45.         }
  46.  
  47.  
  48.         private string _PWD = "sa";
  49.  
  50.         [Category("数据源")]
  51.         [Description("密码")]
  52.         public string PWD
  53.         {
  54.             get { return _PWD; }
  55.             set
  56.             {
  57.                 _PWD = value;
  58.                 OnPropertyChanged("PWD");
  59.             }
  60.         }
  61.  
  62.  
  63.         private bool _IsWindowLogin = true;
  64.  
  65.         [Category("数据源")]
  66.         [Description("是否为Window身份验证")]
  67.         public bool IsWindowLogin
  68.         {
  69.             get { return _IsWindowLogin; }
  70.             set
  71.             {
  72.                 _IsWindowLogin = value;
  73.                 OnPropertyChanged("IsWindowLogin");
  74.             }
  75.         }
  76.  
  77.  
  78.         private string _XTableName = "ColumnSeriesTable";
  79.  
  80.         [Category("数据源")]
  81.         [Description("X轴表名")]
  82.         public string XTableName
  83.         {
  84.             get { return _XTableName; }
  85.             set
  86.             {
  87.                 _XTableName = value;
  88.                 OnPropertyChanged("XTableName");
  89.             }
  90.         }
  91.  
  92.  
  93.         private string _YTableName = "ColumnSeriesData";
  94.  
  95.         [Category("数据源")]
  96.         [Description("Y轴表名")]
  97.         public string YTableName
  98.         {
  99.             get { return _YTableName; }
  100.             set
  101.             {
  102.                 _YTableName = value;
  103.                 OnPropertyChanged("YTableName");
  104.             }
  105.         }
  106.  
  107.         private string _XTableID = "ColumnSData";
  108.  
  109.         [Category("数据源")]
  110.         [Description("X轴表ID")]
  111.         public string XTableID
  112.         {
  113.             get { return _XTableID; }
  114.             set
  115.             {
  116.                 _XTableID = value;
  117.                 OnPropertyChanged("XTableID");
  118.             }
  119.         }
  120.  
  121.         private string _YTableID = "ID";
  122.  
  123.         [Category("数据源")]
  124.         [Description("Y轴表ID")]
  125.         public string YTableID
  126.         {
  127.             get { return _YTableID; }
  128.             set
  129.             {
  130.                 _YTableID = value;
  131.                 OnPropertyChanged("YTableID");
  132.             }
  133.         }
  134.  
  135.         private string _Title = "柱状图";
  136.  
  137.         [Category("基本")]
  138.         [Description("标题")]
  139.         public string Title
  140.         {
  141.             get { return _Title; }
  142.             set
  143.             {
  144.                 _Title = value;
  145.                 OnPropertyChanged("Title");
  146.             }
  147.         }
  148.  
  149.  
  150.         private string _DataColumnName = "MinData;MaxData";
  151.  
  152.         [Category("数据源")]
  153.         [Description("数据源列名，多数据源名称用分号隔开")]
  154.         public string DataColumnName
  155.         {
  156.             get { return _DataColumnName; }
  157.             set
  158.             {
  159.                 _DataColumnName = value;
  160.                 OnPropertyChanged("DataColumnName");
  161.             }
  162.         }
  163.  
  164.  
  165.         private string _XAxisName = "sad   ada";
  166.  
  167.         [Category("数据源")]
  168.         [Description("轴线名称")]
  169.         public string XAxisName
  170.         {
  171.             get { return _XAxisName; }
  172.             set
  173.             {
  174.                 _XAxisName = value;
  175.                 OnPropertyChanged("XAxisName");
  176.             }
  177.         }
  178.  
  179.  
  180.         private string _ToolTipName = "asdsa($):";
  181.  
  182.         [Category("数据源")]
  183.         [Description("轴线提示文本")]
  184.         public string ToolTipName
  185.         {
  186.             get { return _ToolTipName + "{field}"; }
  187.             set
  188.             {
  189.                 _ToolTipName = value;
  190.                 OnPropertyChanged("ToolTipName");
  191.             }
  192.         }
  193.  
  194.  
  195.         private bool _ShowValueOnBar=true ;
  196.  
  197.         [Category("数据源")]
  198.         [Description("是否显示数据源标注")]
  199.         public bool ShowValueOnBar
  200.         {
  201.             get { return _ShowValueOnBar; }
  202.             set
  203.             {
  204.                 _ShowValueOnBar = value;
  205.                 OnPropertyChanged("ShowValueOnBar");
  206.             }
  207.         }
  208.  
  209.        //读取保存的数据
  210.         public override void ReadXml(System.Xml.Linq.XElement element)
  211.         {
  212.             base.ReadXml(element);
  213.             ShowValueOnBar = element.ReadBool("ShowValueOnBar", ShowValueOnBar);
  214.             ToolTipName = element.ReadString("ToolTipName");
  215.             XAxisName = element.ReadString("XAxisName");
  216.             DataColumnName = element.ReadString("DataColumnName");
  217.             Title = element.ReadString("Title");
  218.             YTableID = element.ReadString("YTableID");
  219.             XTableID = element.ReadString("XTableID");
  220.             YTableName = element.ReadString("YTableName");
  221.             XTableName = element.ReadString("XTableName");
  222.             IsWindowLogin = element.ReadBool("IsWindowLogin", IsWindowLogin);
  223.             PWD = element.ReadString("PWD");
  224.             UID = element.ReadString("UID");
  225.             DataBaseName = element.ReadString("DataBaseName");
  226.             ComputerName = element.ReadString("ComputerName");
  227.         }
  228.        //保存属性
  229.         public override void WriteXml(System.Xml.XmlWriter writer)
  230.         {
  231.             base.WriteXml(writer);
  232.             writer.WriteAttributeString("ShowValueOnBar", ShowValueOnBar.ToString());
  233.             writer.WriteAttributeString("ToolTipName", ToolTipName);
  234.             writer.WriteAttributeString("XAxisName", XAxisName);
  235.             writer.WriteAttributeString("DataColumnName", DataColumnName);
  236.             writer.WriteAttributeString("Title", Title);
  237.             writer.WriteAttributeString("YTableID", YTableID);
  238.             writer.WriteAttributeString("XTableID", XTableID);
  239.             writer.WriteAttributeString("YTableName", YTableName);
  240.             writer.WriteAttributeString("XTableName", XTableName);
  241.             writer.WriteAttributeString("IsWindowLogin", IsWindowLogin.ToString());
  242.             writer.WriteAttributeString("PWD", PWD);
  243.             writer.WriteAttributeString("UID", UID);
  244.             writer.WriteAttributeString("DataBaseName", DataBaseName);
  245.             writer.WriteAttributeString("ComputerName", ComputerName);
  246.         }
  247.     }

　　在这里我们使用的是固定的数据格式     包括数据库的表也是固定的。

至于这些属性呢    数据库名称什么的我们可以自己去设置  唯有格式是固定的，下面的保存和读取是当组件放在设计器上的时候有编辑完的东西需要保存，当保存了是设计器上的东西时  当然也需要保存组件的属性了，这个保存的方法在基类。

至于HrvColumnSeriesShape.cs  我们用作将组件的属性以及事件去绑定起来（双向绑定）    可以保证属性的动态变化

  1. public class HrvColumnSeriesShape : HrvContent
  2.     {
  3.         public HrvColumnSeriesProperty _Property;
  4.         public HrvColumnSeriesEvent _Event;
  5.  
  6.         public HrvColumnSeriesShape()
  7.         {
  8.             this.Content = new ColumnSeries();
  9.             BindingOperations.SetBinding(this.Content as ColumnSeries, ColumnSeries.ComputerNameProperty, new Binding("ComputerName") { Source = this.Property, Mode = BindingMode.TwoWay });
  10.             BindingOperations.SetBinding(this.Content as ColumnSeries, ColumnSeries.DataBaseNameProperty, new Binding("DataBaseName") { Source = this.Property, Mode = BindingMode.TwoWay });
  11.             BindingOperations.SetBinding(this.Content as ColumnSeries, ColumnSeries.UIDProperty, new Binding("UID") { Source = this.Property, Mode = BindingMode.TwoWay });
  12.             BindingOperations.SetBinding(this.Content as ColumnSeries, ColumnSeries.PWDProperty, new Binding("PWD") { Source = this.Property, Mode = BindingMode.TwoWay });
  13.             BindingOperations.SetBinding(this.Content as ColumnSeries, ColumnSeries.IsWindowLoginProperty, new Binding("IsWindowLogin") { Source = this.Property, Mode = BindingMode.TwoWay });
  14.             BindingOperations.SetBinding(this.Content as ColumnSeries, ColumnSeries.XTableNameProperty, new Binding("XTableName") { Source = this.Property, Mode = BindingMode.TwoWay });
  15.             BindingOperations.SetBinding(this.Content as ColumnSeries, ColumnSeries.YTableNameProperty, new Binding("YTableName") { Source = this.Property, Mode = BindingMode.TwoWay });
  16.             BindingOperations.SetBinding(this.Content as ColumnSeries, ColumnSeries.TitleProperty, new Binding("Title") { Source = this.Property, Mode = BindingMode.TwoWay });
  17.             BindingOperations.SetBinding(this.Content as ColumnSeries, ColumnSeries.DataColumnNameProperty, new Binding("DataColumnName") { Source = this.Property, Mode = BindingMode.TwoWay });
  18.             BindingOperations.SetBinding(this.Content as ColumnSeries, ColumnSeries.XAxisNameProperty, new Binding("XAxisName") { Source = this.Property, Mode = BindingMode.TwoWay });
  19.             BindingOperations.SetBinding(this.Content as ColumnSeries, ColumnSeries.ToolTipNameProperty, new Binding("ToolTipName") { Source = this.Property, Mode = BindingMode.TwoWay });
  20.             BindingOperations.SetBinding(this.Content as ColumnSeries, ColumnSeries.ShowValueOnBarProperty, new Binding("ShowValueOnBar") { Source = this.Property, Mode = BindingMode.TwoWay });
  21.             BindingOperations.SetBinding(this.Content as ColumnSeries, ColumnSeries.XTableIDProperty, new Binding("XTableID") { Source = this.Property, Mode = BindingMode.TwoWay });
  22.             BindingOperations.SetBinding(this.Content as ColumnSeries, ColumnSeries.YTableIDProperty, new Binding("YTableID") { Source = this.Property, Mode = BindingMode.TwoWay });  
  23.         }
  24.  
  25.         public override ComponentPropertyBase Property
  26.         {
  27.             get
  28.             {
  29.                 if (_Property == null)
  30.                 {
  31.                     _Property = new HrvColumnSeriesProperty();
  32.                 }
  33.                 return _Property;
  34.             }
  35.         }
  36.  
  37.         public override ComponentEventBase Event
  38.         {
  39.             get
  40.             {
  41.                 if (_Event == null)
  42.                 {
  43.                     _Event = new HrvColumnSeriesEvent();
  44.                 }
  45.                 return _Event;
  46.             }
  47.         }

　　如此我们的组件基本的构成就讲完了，接下来就是数据的读取以及前端的动态更新了！

ColumnSeries.xaml.cs属性如下：

  1. #region 属性
  2.         public static DependencyProperty ComputerNameProperty = DependencyProperty.Register("ComputerName", typeof(string), typeof(ColumnSeries));
  3.  
  4.         public string ComputerName
  5.         {
  6.             get { return (string)GetValue(ComputerNameProperty); }
  7.             set { SetValue(ComputerNameProperty, value); }
  8.         }
  9.         public static DependencyProperty DataBaseNameProperty = DependencyProperty.Register("DataBaseName", typeof(string), typeof(ColumnSeries));
  10.  
  11.         public string DataBaseName
  12.         {
  13.             get { return (string)GetValue(DataBaseNameProperty); }
  14.             set { SetValue(DataBaseNameProperty, value); }
  15.         }
  16.         public static DependencyProperty UIDProperty = DependencyProperty.Register("UID", typeof(string), typeof(ColumnSeries));
  17.  
  18.         public string UID
  19.         {
  20.             get { return (string)GetValue(UIDProperty); }
  21.             set { SetValue(UIDProperty, value); }
  22.         }
  23.         public static DependencyProperty PWDProperty = DependencyProperty.Register("PWD", typeof(string), typeof(ColumnSeries));
  24.  
  25.         public string PWD
  26.         {
  27.             get { return (string)GetValue(PWDProperty); }
  28.             set { SetValue(PWDProperty, value); }
  29.         }
  30.         public static DependencyProperty IsWindowLoginProperty = DependencyProperty.Register("IsWindowLogin", typeof(bool), typeof(ColumnSeries));
  31.  
  32.         public bool IsWindowLogin
  33.         {
  34.             get { return Convert.ToBoolean(GetValue(IsWindowLoginProperty)); }
  35.             set { SetValue(IsWindowLoginProperty, value); }
  36.         }
  37.         public static DependencyProperty XTableNameProperty = DependencyProperty.Register("XTableName", typeof(string), typeof(ColumnSeries));
  38.  
  39.         public string XTableName
  40.         {
  41.             get { return (string)GetValue(XTableNameProperty); }
  42.             set { SetValue(XTableNameProperty, value); }
  43.         }
  44.         public static DependencyProperty YTableNameProperty = DependencyProperty.Register("YTableName", typeof(string), typeof(ColumnSeries));
  45.  
  46.         public string YTableName
  47.         {
  48.             get { return (string)GetValue(YTableNameProperty); }
  49.             set { SetValue(YTableNameProperty, value); }
  50.         }
  51.         public static DependencyProperty XTableIDProperty = DependencyProperty.Register("XTableID", typeof(string), typeof(ColumnSeries));
  52.  
  53.         public string XTableID
  54.         {
  55.             get { return (string)GetValue(XTableIDProperty); }
  56.             set { SetValue(XTableIDProperty, value); }
  57.         }
  58.         public static DependencyProperty YTableIDProperty = DependencyProperty.Register("YTableID", typeof(string), typeof(ColumnSeries));
  59.  
  60.         public string YTableID
  61.         {
  62.             get { return (string)GetValue(YTableIDProperty); }
  63.             set { SetValue(YTableIDProperty, value); }
  64.         }
  65.         public static DependencyProperty TitleProperty = DependencyProperty.Register("Title", typeof(string), typeof(ColumnSeries));
  66.  
  67.         public string Title
  68.         {
  69.             get { return (string)GetValue(TitleProperty); }
  70.             set { SetValue(TitleProperty, value); }
  71.         }
  72.         public static DependencyProperty DataColumnNameProperty = DependencyProperty.Register("DataColumnName", typeof(string), typeof(ColumnSeries));
  73.  
  74.         public string DataColumnName
  75.         {
  76.             get { return (string)GetValue(DataColumnNameProperty); }
  77.             set { SetValue(DataColumnNameProperty, value); }
  78.         }
  79.         public static DependencyProperty XAxisNameProperty = DependencyProperty.Register("XAxisName", typeof(string), typeof(ColumnSeries));
  80.  
  81.         public string XAxisName
  82.         {
  83.             get { return (string)GetValue(XAxisNameProperty); }
  84.             set { SetValue(XAxisNameProperty, value); }
  85.         }
  86.         public static DependencyProperty ToolTipNameProperty = DependencyProperty.Register("ToolTipName", typeof(string), typeof(ColumnSeries));
  87.  
  88.         public string ToolTipName
  89.         {
  90.             get { return (string)GetValue(ToolTipNameProperty); }
  91.             set { SetValue(ToolTipNameProperty, value); }
  92.         }
  93.         public static DependencyProperty ShowValueOnBarProperty = DependencyProperty.Register("ShowValueOnBar", typeof(bool), typeof(ColumnSeries));
  94.  
  95.         public bool ShowValueOnBar
  96.         {
  97.             get { return Convert.ToBoolean(GetValue(ShowValueOnBarProperty)); }
  98.             set { SetValue(ShowValueOnBarProperty, value); }
  99.         }
  100.         private DataSet _Data;
  101.  
  102.         public DataSet Data
  103.         {
  104.             get { return _Data; }
  105.             set { _Data = value; }
  106.         }
  107.         #endregion

　　为什么定义这种呢？  这是为了将组件的属性和数据读取这一块绑定   为了保证在绑定之后属性的动态变化，所以我们使用了依赖项属性。

关于监听数据库值得改变去动态显示数据（SqlDependency）这部分内容在

WPF非轮询方式更新数据库变化SqlDependency（数据库修改前台自动更新）

这一章节会有详细的讲解，以下内容  看的懂看一下   觉得繁琐的   就不看了。

数据的读取：

  1.  private string con;
  2.         private string[] dataColumn;
  3.         private string sql;
  4.         #region 数据库连接
  5.         public void GetDataSet()
  6.         {
  7.  
  8.             SqlConnection connection = new SqlConnection(con);
  9.             Data = new DataSet();
  10.  
  11.             SqlCommand command = new SqlCommand(sql, connection);
  12.             command.CommandType = CommandType.Text;
  13.             connection.Open();
  14.             SqlDependency dependency = new SqlDependency(command);
  15.             dependency.OnChange += new OnChangeEventHandler(dependency_OnChange);
  16.             DataTable dt = new DataTable();
  17.             SqlDataReader sda = command.ExecuteReader();
  18.             foreach (string data in dataColumn)
  19.             {
  20.                 DataColumn dc = new DataColumn(data);
  21.                 dt.Columns.Add(dc);
  22.             }
  23.  
  24.             while (sda.Read())
  25.             {
  26.                 DataRow row = dt.NewRow();
  27.                 foreach (string data in dataColumn)
  28.                 {
  29.                     row[data] = sda[data].ToString();
  30.                 }
  31.                 dt.Rows.Add(row);
  32.             }
  33.             Data.Tables.Add(dt);
  34.             sda.Close();
  35.             //}
  36.             //catch (Exception ex)
  37.             //{
  38.  
  39.             //}
  40.         }
  41.  
  42.         private void dependency_OnChange(object sender, SqlNotificationEventArgs e)
  43.         {
  44.             DrawChart();
  45.         }
  46.  
  47.         #endregion
  48.         string CName;
  49.         string DName;
  50.         string ID;
  51.         string PassWord;
  52.         bool windowLogin;
  53.         string XTName;
  54.         string YTName;
  55.         string DCName;
  56.         string XAName;
  57.         string XTID;
  58.         string YTID;
  59.         protected override void OnPropertyChanged(DependencyPropertyChangedEventArgs e)
  60.         {
  61.             base.OnPropertyChanged(e);
  62.             if (CName != null && DName != null && ID != null && PassWord != null && XTName != null && YTName != null && DCName != null && XAName != null && XTID != null && YTID != null)
  63.                 if (CName != ComputerName || DName != DataBaseName || ID != UID || PassWord != PWD || windowLogin != IsWindowLogin || XTName != XTableName || YTName != YTableName || DCName != DataColumnName || XAName != XAxisName || XTID != XTableID || YTID != YTableID)
  64.                     DrawChart();
  65.             CName = ComputerName;
  66.             DName = DataBaseName;
  67.             ID = UID;
  68.             PassWord = PWD;
  69.             windowLogin = IsWindowLogin;
  70.             XTName = XTableName;
  71.             YTName = YTableName;
  72.             DCName = DataColumnName;
  73.             XAName = XAxisName;
  74.             XTID = XTableID;
  75.             YTID = YTableID;
  76.         }
  77.  
  78.         #region 显示数据
  79.         private void DrawChart()
  80.         {
  81.             this.Dispatcher.Invoke(new System.Action(() =>
  82.             {
  83.                 con = @"server=" + ComputerName + @";database=" + DataBaseName + ";uid=" + UID + ";pwd=" + PWD + ";Integrated Security=" + IsWindowLogin;
  84.                 dataColumn = (DataColumnName + ";Name").Split(';');
  85.  
  86.                 sql = "SELECT ";
  87.                 foreach (string data in dataColumn)
  88.                 {
  89.                     sql += data + ",";
  90.                 }
  91.                 sql = sql.Remove(sql.Length - 1);
  92.                 sql += " FROM [dbo].[" + XTableName + "] INNER JOIN [dbo].[" + YTableName + "] ON " + YTableName + "." + YTableID + "=" + XTableName + "." + XTableID;
  93.                 try
  94.                 {
  95.                     SqlDependency.Start(con);
  96.                     GetDataSet();
  97.  
  98.                 }
  99.                 catch(Exception ex)
  100.                 {
  101.                     MessageBox.Show(ex.Message.ToString(),"数据连接错误！");
  102.                 }
  103.                 chart2.Reset();
  104.                 Binding titleBind = new Binding { Source = this, Path = new PropertyPath("Title") };
  105.                 BindingOperations.SetBinding(this.chart2, BarChart.TitleProperty, titleBind);
  106.                 string[] column = new string[dataColumn.Length - 1];
  107.                 for (int i = 0; i < dataColumn.Length - 1; i++)
  108.                 {
  109.                     column[i] = dataColumn[i];
  110.                 }
  111.                 if (column == null)
  112.                     return;
  113.  
  114.                 foreach (string data in column)
  115.                 {
  116.                     chart2.ValueField.Add(data);
  117.                 }
  118.  
  119.                 Binding ToolTipNameBind = new Binding { Source = this, Path = new PropertyPath("ToolTipName") };
  120.                 BindingOperations.SetBinding(this.chart2, BarChart.ToolTipTextProperty, ToolTipNameBind);
  121.                 chart2.XAxisText = XAxisName;
  122.                 chart2.XAxisField = "Name";
  123.                 Binding showBarBind = new Binding { Source = this, Path = new PropertyPath("ShowValueOnBar") };
  124.                 BindingOperations.SetBinding(this.chart2, BarChart.ShowValueOnBarsProperty, showBarBind);
  125.                 if (Data == null)
  126.                     return;
  127.                 Binding DataSourceBind = new Binding { Source = this, Path = new PropertyPath("Data") };
  128.                 BindingOperations.SetBinding(this.chart2, BarChart.DataSourceProperty, DataSourceBind);
  129.  
  130.                 chart2.Generate();
  131.             }));
  132.         }
  133.         #endregion
  134.  
  135.         private void UserControl_Loaded(object sender, RoutedEventArgs e)
  136.         {
  137.             DrawChart();
  138.         }
  139.  
  140.  
  141.         private void UserControl_SizeChanged(object sender, SizeChangedEventArgs e)
  142.         {
  143.             chart2.Width = 450;
  144.             chart2.Height = 300;
  145.         }

　　

OnPropertyChanged解释下这个   这个是在属性更改的时候发生，因为数据库的连接字符串是无法做动态更新的   比如更改完数据库名称之后马上要自动去连接那个数据库之前的方法就无法实现了，所以我们使用了这个事件    当数据库名称、表名、列明等发生改变的时候去重新获取数据。目前就讲这些，至于柱状图下章继续，柱状图更加繁琐。需要组件基类模板的，想要柱状图源码的请加群：

WPF、AE技术交流群：94234450   

点击加入QQ群：

不管你遇到了什么问题，我们都不会让你独自去面对！

转载于:https://www.cnblogs.com/BeiJing-Net-DaiDai/p/3449359.html

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/盐析白兔/article/detail/270756
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号