private void UserControl_Loaded(object sender, RoutedEventArgs e) { UCTreeCylinder3D uc = new UCTreeCylinder3D(); string sql = @"select t3.Name,t2.Name,SUM(electricity) energy,SUM(electriccharge)/SUM(electricity) price from RegionalElectricityStatistics t1 join Dic_District t2 on t1.RegionID=t2.ID join DIc_ElectricityType t3 on t1.ElectricTypeID=t2.ID where YEAR(time)=2012 group by t2.Name,t3.Name" ; uc.DataSource = DataLayer.DataProvider.getDataTableFromSQL(sql).DefaultView; uc.controlTitle = "本年营销收益情况"; uc.rootTitle = "营销收益"; uc.heightTitle = "电量"; uc.sectionTitle = "电价"; uc.volumeTitle = "电费"; grdmain.Children.Add(uc); // string sql = @"select t3.Name,t2.Name,cast(MONTH(time) as nvarchar(2))+'月' m,SUM(electricity) energy,SUM(electriccharge)/SUM(electricity) price // from RegionalElectricityStatistics t1 // join Dic_District t2 on t1.RegionID=t2.ID // join DIc_ElectricityType t3 on t1.ElectricTypeID=t2.ID // where YEAR(time)=2012 group by MONTH(time),t2.Name,t3.Name"; }
private static void OnDataSourceChanged(DependencyObject d, DependencyPropertyChangedEventArgs e) { UCTreeCylinder3D Sender = (UCTreeCylinder3D)d; Sender.updateData(); }