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

public class HrvColumnSeries : ComponentBase
{
public HrvColumnSeries()
{
Content = new HrvColumnSeriesShape();
} public override string TextName
{
get { return "HrvColumnSeries"; }
} public override string IconName
{
get { return "HrvColumnSeries.png"; }
}
}

public class HrvColumnSeriesEvent : ComponentEventBase
{
private string _Click; [Category("基础事件")]
[Description("单击事件.")]
[EventInfo("Click")]
public string Click
{
get { return _Click; }
set
{
if (_Click == value) return;
_Click = value;
OnPropertyChanged("Click");
}
} public void OnClick(object sender, RoutedEventArgs e)
{
if (Click != null)
{
}
}
}

public class HrvColumnSeriesProperty : ComponentPropertyBase
{
private static string _ComputerName = ".\\sqlexpress"; [Category("数据源")]
[Description("计算机名称")]
public string ComputerName
{
get { return _ComputerName; }
set
{
_ComputerName = value;
OnPropertyChanged("ComputerName");
}
} private string _DataBaseName = "ColumnSeriesDB"; [Category("数据源")]
[Description("数据库名称")]
public string DataBaseName
{
get { return _DataBaseName; }
set
{
_DataBaseName = value;
OnPropertyChanged("DataBaseName");
}
} private string _UID = "sa"; [Category("数据源")]
[Description("用户名")]
public string UID
{
get { return _UID; }
set
{
_UID = value;
OnPropertyChanged("UID");
}
} private string _PWD = "sa"; [Category("数据源")]
[Description("密码")]
public string PWD
{
get { return _PWD; }
set
{
_PWD = value;
OnPropertyChanged("PWD");
}
} private bool _IsWindowLogin = true; [Category("数据源")]
[Description("是否为Window身份验证")]
public bool IsWindowLogin
{
get { return _IsWindowLogin; }
set
{
_IsWindowLogin = value;
OnPropertyChanged("IsWindowLogin");
}
} private string _XTableName = "ColumnSeriesTable"; [Category("数据源")]
[Description("X轴表名")]
public string XTableName
{
get { return _XTableName; }
set
{
_XTableName = value;
OnPropertyChanged("XTableName");
}
} private string _YTableName = "ColumnSeriesData"; [Category("数据源")]
[Description("Y轴表名")]
public string YTableName
{
get { return _YTableName; }
set
{
_YTableName = value;
OnPropertyChanged("YTableName");
}
} private string _XTableID = "ColumnSData"; [Category("数据源")]
[Description("X轴表ID")]
public string XTableID
{
get { return _XTableID; }
set
{
_XTableID = value;
OnPropertyChanged("XTableID");
}
} private string _YTableID = "ID"; [Category("数据源")]
[Description("Y轴表ID")]
public string YTableID
{
get { return _YTableID; }
set
{
_YTableID = value;
OnPropertyChanged("YTableID");
}
} private string _Title = "柱状图"; [Category("基本")]
[Description("标题")]
public string Title
{
get { return _Title; }
set
{
_Title = value;
OnPropertyChanged("Title");
}
} private string _DataColumnName = "MinData;MaxData"; [Category("数据源")]
[Description("数据源列名，多数据源名称用分号隔开")]
public string DataColumnName
{
get { return _DataColumnName; }
set
{
_DataColumnName = value;
OnPropertyChanged("DataColumnName");
}
} private string _XAxisName = "sad ada"; [Category("数据源")]
[Description("轴线名称")]
public string XAxisName
{
get { return _XAxisName; }
set
{
_XAxisName = value;
OnPropertyChanged("XAxisName");
}
} private string _ToolTipName = "asdsa($):"; [Category("数据源")]
[Description("轴线提示文本")]
public string ToolTipName
{
get { return _ToolTipName + "{field}"; }
set
{
_ToolTipName = value;
OnPropertyChanged("ToolTipName");
}
} private bool _ShowValueOnBar=true ; [Category("数据源")]
[Description("是否显示数据源标注")]
public bool ShowValueOnBar
{
get { return _ShowValueOnBar; }
set
{
_ShowValueOnBar = value;
OnPropertyChanged("ShowValueOnBar");
}
} //读取保存的数据
public override void ReadXml(System.Xml.Linq.XElement element)
{
base.ReadXml(element);
ShowValueOnBar = element.ReadBool("ShowValueOnBar", ShowValueOnBar);
ToolTipName = element.ReadString("ToolTipName");
XAxisName = element.ReadString("XAxisName");
DataColumnName = element.ReadString("DataColumnName");
Title = element.ReadString("Title");
YTableID = element.ReadString("YTableID");
XTableID = element.ReadString("XTableID");
YTableName = element.ReadString("YTableName");
XTableName = element.ReadString("XTableName");
IsWindowLogin = element.ReadBool("IsWindowLogin", IsWindowLogin);
PWD = element.ReadString("PWD");
UID = element.ReadString("UID");
DataBaseName = element.ReadString("DataBaseName");
ComputerName = element.ReadString("ComputerName");
}
//保存属性
public override void WriteXml(System.Xml.XmlWriter writer)
{
base.WriteXml(writer);
writer.WriteAttributeString("ShowValueOnBar", ShowValueOnBar.ToString());
writer.WriteAttributeString("ToolTipName", ToolTipName);
writer.WriteAttributeString("XAxisName", XAxisName);
writer.WriteAttributeString("DataColumnName", DataColumnName);
writer.WriteAttributeString("Title", Title);
writer.WriteAttributeString("YTableID", YTableID);
writer.WriteAttributeString("XTableID", XTableID);
writer.WriteAttributeString("YTableName", YTableName);
writer.WriteAttributeString("XTableName", XTableName);
writer.WriteAttributeString("IsWindowLogin", IsWindowLogin.ToString());
writer.WriteAttributeString("PWD", PWD);
writer.WriteAttributeString("UID", UID);
writer.WriteAttributeString("DataBaseName", DataBaseName);
writer.WriteAttributeString("ComputerName", ComputerName);
}
}

public class HrvColumnSeriesShape : HrvContent
{
public HrvColumnSeriesProperty _Property;
public HrvColumnSeriesEvent _Event; public HrvColumnSeriesShape()
{
this.Content = new ColumnSeries();
BindingOperations.SetBinding(this.Content as ColumnSeries, ColumnSeries.ComputerNameProperty, new Binding("ComputerName") { Source = this.Property, Mode = BindingMode.TwoWay });
BindingOperations.SetBinding(this.Content as ColumnSeries, ColumnSeries.DataBaseNameProperty, new Binding("DataBaseName") { Source = this.Property, Mode = BindingMode.TwoWay });
BindingOperations.SetBinding(this.Content as ColumnSeries, ColumnSeries.UIDProperty, new Binding("UID") { Source = this.Property, Mode = BindingMode.TwoWay });
BindingOperations.SetBinding(this.Content as ColumnSeries, ColumnSeries.PWDProperty, new Binding("PWD") { Source = this.Property, Mode = BindingMode.TwoWay });
BindingOperations.SetBinding(this.Content as ColumnSeries, ColumnSeries.IsWindowLoginProperty, new Binding("IsWindowLogin") { Source = this.Property, Mode = BindingMode.TwoWay });
BindingOperations.SetBinding(this.Content as ColumnSeries, ColumnSeries.XTableNameProperty, new Binding("XTableName") { Source = this.Property, Mode = BindingMode.TwoWay });
BindingOperations.SetBinding(this.Content as ColumnSeries, ColumnSeries.YTableNameProperty, new Binding("YTableName") { Source = this.Property, Mode = BindingMode.TwoWay });
BindingOperations.SetBinding(this.Content as ColumnSeries, ColumnSeries.TitleProperty, new Binding("Title") { Source = this.Property, Mode = BindingMode.TwoWay });
BindingOperations.SetBinding(this.Content as ColumnSeries, ColumnSeries.DataColumnNameProperty, new Binding("DataColumnName") { Source = this.Property, Mode = BindingMode.TwoWay });
BindingOperations.SetBinding(this.Content as ColumnSeries, ColumnSeries.XAxisNameProperty, new Binding("XAxisName") { Source = this.Property, Mode = BindingMode.TwoWay });
BindingOperations.SetBinding(this.Content as ColumnSeries, ColumnSeries.ToolTipNameProperty, new Binding("ToolTipName") { Source = this.Property, Mode = BindingMode.TwoWay });
BindingOperations.SetBinding(this.Content as ColumnSeries, ColumnSeries.ShowValueOnBarProperty, new Binding("ShowValueOnBar") { Source = this.Property, Mode = BindingMode.TwoWay });
BindingOperations.SetBinding(this.Content as ColumnSeries, ColumnSeries.XTableIDProperty, new Binding("XTableID") { Source = this.Property, Mode = BindingMode.TwoWay });
BindingOperations.SetBinding(this.Content as ColumnSeries, ColumnSeries.YTableIDProperty, new Binding("YTableID") { Source = this.Property, Mode = BindingMode.TwoWay });
} public override ComponentPropertyBase Property
{
get
{
if (_Property == null)
{
_Property = new HrvColumnSeriesProperty();
}
return _Property;
}
} public override ComponentEventBase Event
{
get
{
if (_Event == null)
{
_Event = new HrvColumnSeriesEvent();
}
return _Event;
}
}

#region 属性
public static DependencyProperty ComputerNameProperty = DependencyProperty.Register("ComputerName", typeof(string), typeof(ColumnSeries)); public string ComputerName
{
get { return (string)GetValue(ComputerNameProperty); }
set { SetValue(ComputerNameProperty, value); }
}
public static DependencyProperty DataBaseNameProperty = DependencyProperty.Register("DataBaseName", typeof(string), typeof(ColumnSeries)); public string DataBaseName
{
get { return (string)GetValue(DataBaseNameProperty); }
set { SetValue(DataBaseNameProperty, value); }
}
public static DependencyProperty UIDProperty = DependencyProperty.Register("UID", typeof(string), typeof(ColumnSeries)); public string UID
{
get { return (string)GetValue(UIDProperty); }
set { SetValue(UIDProperty, value); }
}
public static DependencyProperty PWDProperty = DependencyProperty.Register("PWD", typeof(string), typeof(ColumnSeries)); public string PWD
{
get { return (string)GetValue(PWDProperty); }
set { SetValue(PWDProperty, value); }
}
public static DependencyProperty IsWindowLoginProperty = DependencyProperty.Register("IsWindowLogin", typeof(bool), typeof(ColumnSeries)); public bool IsWindowLogin
{
get { return Convert.ToBoolean(GetValue(IsWindowLoginProperty)); }
set { SetValue(IsWindowLoginProperty, value); }
}
public static DependencyProperty XTableNameProperty = DependencyProperty.Register("XTableName", typeof(string), typeof(ColumnSeries)); public string XTableName
{
get { return (string)GetValue(XTableNameProperty); }
set { SetValue(XTableNameProperty, value); }
}
public static DependencyProperty YTableNameProperty = DependencyProperty.Register("YTableName", typeof(string), typeof(ColumnSeries)); public string YTableName
{
get { return (string)GetValue(YTableNameProperty); }
set { SetValue(YTableNameProperty, value); }
}
public static DependencyProperty XTableIDProperty = DependencyProperty.Register("XTableID", typeof(string), typeof(ColumnSeries)); public string XTableID
{
get { return (string)GetValue(XTableIDProperty); }
set { SetValue(XTableIDProperty, value); }
}
public static DependencyProperty YTableIDProperty = DependencyProperty.Register("YTableID", typeof(string), typeof(ColumnSeries)); public string YTableID
{
get { return (string)GetValue(YTableIDProperty); }
set { SetValue(YTableIDProperty, value); }
}
public static DependencyProperty TitleProperty = DependencyProperty.Register("Title", typeof(string), typeof(ColumnSeries)); public string Title
{
get { return (string)GetValue(TitleProperty); }
set { SetValue(TitleProperty, value); }
}
public static DependencyProperty DataColumnNameProperty = DependencyProperty.Register("DataColumnName", typeof(string), typeof(ColumnSeries)); public string DataColumnName
{
get { return (string)GetValue(DataColumnNameProperty); }
set { SetValue(DataColumnNameProperty, value); }
}
public static DependencyProperty XAxisNameProperty = DependencyProperty.Register("XAxisName", typeof(string), typeof(ColumnSeries)); public string XAxisName
{
get { return (string)GetValue(XAxisNameProperty); }
set { SetValue(XAxisNameProperty, value); }
}
public static DependencyProperty ToolTipNameProperty = DependencyProperty.Register("ToolTipName", typeof(string), typeof(ColumnSeries)); public string ToolTipName
{
get { return (string)GetValue(ToolTipNameProperty); }
set { SetValue(ToolTipNameProperty, value); }
}
public static DependencyProperty ShowValueOnBarProperty = DependencyProperty.Register("ShowValueOnBar", typeof(bool), typeof(ColumnSeries)); public bool ShowValueOnBar
{
get { return Convert.ToBoolean(GetValue(ShowValueOnBarProperty)); }
set { SetValue(ShowValueOnBarProperty, value); }
}
private DataSet _Data; public DataSet Data
{
get { return _Data; }
set { _Data = value; }
}
#endregion

private string con;
private string[] dataColumn;
private string sql;
#region 数据库连接
public void GetDataSet()
{ SqlConnection connection = new SqlConnection(con);
Data = new DataSet(); SqlCommand command = new SqlCommand(sql, connection);
command.CommandType = CommandType.Text;
connection.Open();
SqlDependency dependency = new SqlDependency(command);
dependency.OnChange += new OnChangeEventHandler(dependency_OnChange);
DataTable dt = new DataTable();
SqlDataReader sda = command.ExecuteReader();
foreach (string data in dataColumn)
{
DataColumn dc = new DataColumn(data);
dt.Columns.Add(dc);
} while (sda.Read())
{
DataRow row = dt.NewRow();
foreach (string data in dataColumn)
{
row[data] = sda[data].ToString();
}
dt.Rows.Add(row);
}
Data.Tables.Add(dt);
sda.Close();
//}
//catch (Exception ex)
//{ //}
} private void dependency_OnChange(object sender, SqlNotificationEventArgs e)
{
DrawChart();
} #endregion
string CName;
string DName;
string ID;
string PassWord;
bool windowLogin;
string XTName;
string YTName;
string DCName;
string XAName;
string XTID;
string YTID;
protected override void OnPropertyChanged(DependencyPropertyChangedEventArgs e)
{
base.OnPropertyChanged(e);
if (CName != null && DName != null && ID != null && PassWord != null && XTName != null && YTName != null && DCName != null && XAName != null && XTID != null && YTID != null)
if (CName != ComputerName || DName != DataBaseName || ID != UID || PassWord != PWD || windowLogin != IsWindowLogin || XTName != XTableName || YTName != YTableName || DCName != DataColumnName || XAName != XAxisName || XTID != XTableID || YTID != YTableID)
DrawChart();
CName = ComputerName;
DName = DataBaseName;
ID = UID;
PassWord = PWD;
windowLogin = IsWindowLogin;
XTName = XTableName;
YTName = YTableName;
DCName = DataColumnName;
XAName = XAxisName;
XTID = XTableID;
YTID = YTableID;
} #region 显示数据
private void DrawChart()
{
this.Dispatcher.Invoke(new System.Action(() =>
{
con = @"server=" + ComputerName + @";database=" + DataBaseName + ";uid=" + UID + ";pwd=" + PWD + ";Integrated Security=" + IsWindowLogin;
dataColumn = (DataColumnName + ";Name").Split(';'); sql = "SELECT ";
foreach (string data in dataColumn)
{
sql += data + ",";
}
sql = sql.Remove(sql.Length - 1);
sql += " FROM [dbo].[" + XTableName + "] INNER JOIN [dbo].[" + YTableName + "] ON " + YTableName + "." + YTableID + "=" + XTableName + "." + XTableID;
try
{
SqlDependency.Start(con);
GetDataSet(); }
catch(Exception ex)
{
MessageBox.Show(ex.Message.ToString(),"数据连接错误！");
}
chart2.Reset();
Binding titleBind = new Binding { Source = this, Path = new PropertyPath("Title") };
BindingOperations.SetBinding(this.chart2, BarChart.TitleProperty, titleBind);
string[] column = new string[dataColumn.Length - 1];
for (int i = 0; i < dataColumn.Length - 1; i++)
{
column[i] = dataColumn[i];
}
if (column == null)
return; foreach (string data in column)
{
chart2.ValueField.Add(data);
} Binding ToolTipNameBind = new Binding { Source = this, Path = new PropertyPath("ToolTipName") };
BindingOperations.SetBinding(this.chart2, BarChart.ToolTipTextProperty, ToolTipNameBind);
chart2.XAxisText = XAxisName;
chart2.XAxisField = "Name";
Binding showBarBind = new Binding { Source = this, Path = new PropertyPath("ShowValueOnBar") };
BindingOperations.SetBinding(this.chart2, BarChart.ShowValueOnBarsProperty, showBarBind);
if (Data == null)
return;
Binding DataSourceBind = new Binding { Source = this, Path = new PropertyPath("Data") };
BindingOperations.SetBinding(this.chart2, BarChart.DataSourceProperty, DataSourceBind); chart2.Generate();
}));
}
#endregion private void UserControl_Loaded(object sender, RoutedEventArgs e)
{
DrawChart();
} private void UserControl_SizeChanged(object sender, SizeChangedEventArgs e)
{
chart2.Width = 450;
chart2.Height = 300;
}