DevExpress TreeList加载大批量数据的时候绑定数据源 dataTable.
注意事项1: 由于一旦绑定了数据源dataTable的些许变化便在TreeList中有所体现, 所以等dataTable完全填充好了之后再绑定数据源.
注意事项2:dataTable每行的父节点ID当加载到目前为止,还没有找到那么可能就当成空了, 所以最后treelist呈现就有问题, 所以解决办法有3个, 1: 大范围数据,也就是父节点的数据一定要先于子节点在表中排列.(这个不好控制). 2: 等完全填充完datatable时再重新设置每行的父节点ID.
3:可以边填充边设置, 最后再绑定数据源, 在填充dataTable之前先解绑数据源, 即先把数据源设为空,完全填充好再重新绑定(经过测试这种方法的加载速度最快了)
参看代码如下:
public void ShowData(ForecastService.TrafficResult[] result, int iscrop, bool AllType)
{
//填充数据
try
{
ResetCtrl(AllType);
this.result = result;
treeListResult.Nodes.Clear();
treeListResult.DataSource = null; //一定要先解绑
FillTypeFirstData(result, this.dtResult);
treeListResult.DataSource = dtResult;
if (treeListResult.Nodes.Count > 0)
{
for (int i = 0; i < treeListResult.Nodes.Count; i++)
{
treeListResult.Nodes[i].HasChildren = true;
treeListResult.Nodes[i].Expanded = true;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + ex.StackTrace);
}
}
private void FillTypeFirstData(Inspur.Forecast.ForecastService.TrafficResult[] result, DataTable dataTable)
{
try
{
dataTable.Rows.Clear();
for (int i = 0; i < result.Length; i++)
{
if (result[i].trafficType == "ALL" && result[i].city == "ALL")//全省的数据
{
DataRow dr = dataTable.NewRow();
dr["keyFieldName"] = "湖南";//设置当前行ID
dr["parentFieldName"] = DBNull.Value; //设置父节点ID
dr["维度"] = "湖南";
dr["去年基准日话务量"] = result[i].lastFir.Trim();
dr["去年预测日话务量"] = result[i].lastSec.Trim();
dr["增长幅度"] = result[i].add.Trim();
dr["今年基准日话务量"] = result[i].nowFir.Trim();
dr["今年预测日话务量"] = result[i].nowSec.Trim();
dr["目前电路数"] = result[i].count.Trim();
dr["预测2M电路数"] = result[i].fcastcount.Trim();
dr["需要新增的电路数"] = result[i].addcount.Trim();
dataTable.Rows.Add(dr);
}
else if (result[i].trafficType != "ALL" && result[i].city == "ALL" && result[i].nename == "ALL")//汇总到类型的数据
{
DataRow dr = dataTable.NewRow();
dr["keyFieldName"] = result[i].trafficType;
dr["parentFieldName"] = "湖南";
dr["维度"] = result[i].trafficType;
dr["去年基准日话务量"] = result[i].lastFir.Trim();
dr["去年预测日话务量"] = result[i].lastSec.Trim();
dr["增长幅度"] = result[i].add.Trim();
dr["今年基准日话务量"] = result[i].nowFir.Trim();
dr["今年预测日话务量"] = result[i].nowSec.Trim();
dr["目前电路数"] = result[i].count.Trim();
dr["预测2M电路数"] = result[i].fcastcount.Trim();
dr["需要新增的电路数"] = result[i].addcount.Trim();
dataTable.Rows.Add(dr);
}
else if (result[i].trafficType != "ALL" && result[i].city != "ALL" && result[i].nename == "ALL")//汇总到地市的数据
{
DataRow dr = dataTable.NewRow();
dr["keyFieldName"] = result[i].trafficType + "_" + result[i].city;
dr["parentFieldName"] = result[i].trafficType;
dr["维度"] = result[i].city;
dr["去年基准日话务量"] = result[i].lastFir.Trim();
dr["去年预测日话务量"] = result[i].lastSec.Trim();
dr["增长幅度"] = result[i].add.Trim();
dr["今年基准日话务量"] = result[i].nowFir.Trim();
dr["今年预测日话务量"] = result[i].nowSec.Trim();
dr["目前电路数"] = result[i].count.Trim();
dr["预测2M电路数"] = result[i].fcastcount.Trim();
dr["需要新增的电路数"] = result[i].addcount.Trim();
dataTable.Rows.Add(dr);
}
else if (result[i].trafficType != "ALL" && result[i].city != "ALL" && result[i].nename != "ALL" && result[i].middle == "ALL")//汇总到网元的数据
{
DataRow dr = dataTable.NewRow();
dr["keyFieldName"] = result[i].trafficType + "_" + result[i].city + "_" + result[i].nename;
dr["parentFieldName"] = result[i].trafficType + "_" + result[i].city;
dr["维度"] = result[i].nename;
dr["去年基准日话务量"] = result[i].lastFir.Trim();
dr["去年预测日话务量"] = result[i].lastSec.Trim();
dr["增长幅度"] = result[i].add.Trim();
dr["今年基准日话务量"] = result[i].nowFir.Trim();
dr["今年预测日话务量"] = result[i].nowSec.Trim();
dr["目前电路数"] = result[i].count.Trim();
dr["预测2M电路数"] = result[i].fcastcount.Trim();
dr["需要新增的电路数"] = result[i].addcount.Trim();
dataTable.Rows.Add(dr);
}
else if (result[i].trafficType != "ALL" && result[i].city != "ALL" && result[i].nename != "ALL" && result[i].middle != "ALL")//到中继的数据
{
DataRow dr = dataTable.NewRow();
dr["keyFieldName"] = result[i].trafficType + "_" + result[i].city + "_" + result[i].nename + "_" + result[i].middle;
dr["parentFieldName"] = result[i].trafficType + "_" + result[i].city + "_" + result[i].nename;
dr["维度"] = result[i].middle;
dr["去年基准日话务量"] = result[i].lastFir.Trim();
dr["去年预测日话务量"] = result[i].lastSec.Trim();
dr["增长幅度"] = result[i].add.Trim();
dr["今年基准日话务量"] = result[i].nowFir.Trim();
dr["今年预测日话务量"] = result[i].nowSec.Trim();
dr["目前电路数"] = result[i].count.Trim();
dr["预测2M电路数"] = result[i].fcastcount.Trim();
dr["需要新增的电路数"] = result[i].addcount.Trim();
dataTable.Rows.Add(dr);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + ex.StackTrace);
}
}
public TrafficResultTree(IApplication application)
{
InitializeComponent();
this.application = application;
SetTreeListColumn("Config\\Forecast\\TrafficForecastResultTree.xml", "/Head", treeListResult);
//Test
PublicFunction.SetDataTableColumn(treeListResult, dtResult);
treeListResult.ParentFieldName = "parentFieldName"; //设置树的ParentFieldName 属性
treeListResult.KeyFieldName = "keyFieldName"; //设置树的KeyFieldName 属性
//
}
public static void SetDataTableColumn(DevExpress.XtraTreeList.TreeList treeListResult, DataTable dtResult)
{
try
{
dtResult.Columns.Clear();
DataColumn dcid = new DataColumn("keyFieldName", Type.GetType("System.String"));
DataColumn dcparentId = new DataColumn("parentFieldName", Type.GetType("System.String"));
dtResult.Columns.Add(dcid);
dtResult.Columns.Add(dcparentId);
for (int i = 0; i < treeListResult.Columns.Count; i++)
{
DataColumn dc = new DataColumn(treeListResult.Columns[i].FieldName);
dtResult.Columns.Add(dc);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + ex.StackTrace);
}
}
private void InsertRelayData(string time, string type, string cityName, string equipeName, string burName, Inspur.Analysis.AnalysisService.Relay resultRelay)
{
try
{
DataRow drRelay = dtResult.NewRow();
drRelay["keyFieldName"] = time + "_" + type + "_" + cityName + "_" + equipeName + "_" + burName + "_" + resultRelay.RelayName + "_" + DateTime.Now.ToString();
drRelay["parentFieldName"] = time + "_" + type + "_" + cityName + "_" + equipeName + "_" + burName;
drRelay["维度"] = resultRelay.RelayName;
drRelay["定义电路数"] = resultRelay.Total.CIRCUITS;
drRelay["来话试呼次数"] = resultRelay.Total.in_att;
drRelay["去话试呼次数"] = resultRelay.Total.out_att;
drRelay["来话应答次数"] = resultRelay.Total.in_ans;
drRelay["去话应答次数"] = resultRelay.Total.out_ans;
drRelay["来话话务量"] = resultRelay.Total.in_traf;
drRelay["去话话务量"] = resultRelay.Total.out_traf;
drRelay["总话务量"] = resultRelay.Total.traf;
drRelay["来话市话话务量"] = resultRelay.Total.in_local_traf;
drRelay["去话市话话务量"] = resultRelay.Total.out_local_traf;
drRelay["来话长话话务量"] = resultRelay.Total.in_long_traf;
drRelay["去话长话话务量"] = resultRelay.Total.out_long_traf;
drRelay["市话话务量"] = resultRelay.Total.local_traf;
drRelay["长话话务量"] = resultRelay.Total.long_traf;
dtResult.Rows.Add(drRelay);
//DevExpress.XtraTreeList.Nodes.TreeListNode noderelay = null;
//for (int i = 0; i < nodebureauD.Nodes.Count; i++)
//{
// if (nodebureauD.Nodes[i]["维度"].ToString() == relay.RelayName)
// {
// noderelay = nodebureauD.Nodes[i];
// break;
// }
//}
//if (noderelay == null)
//{
// List<string> relayList = new List<string>();
// relayList.Add(relay.RelayName);
// noderelay = treeList.AppendNode(relayList.ToArray(), nodebureauD);
//}
//if (noderelay != null)
//{
// InsertTargetData(noderelay, relay.RelayName, relay.Total);
//}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + ex.StackTrace);
}
}
分享到:
相关推荐
在DevExpress TreeList中,数据绑定是指将数据源(如数据库表、对象集合或XML文件)与TreeList控件关联的过程。这使得TreeList可以自动加载、显示和更新数据源中的信息。数据绑定的基本步骤包括: 1. 创建数据源:...
7. **性能优化**:对于大数据量的树形结构,DevExpress TreeList 提供了虚拟化技术,只加载视窗内的数据,提高性能。这个示例可能会介绍如何实现和配置虚拟化。 8. **扩展功能**:DevExpress TreeList 还提供了一些...
支持VS 2012-2022扩展DevExpress_Patch_Keygen工具。。。
关于_DevExpress_破解_注册机_安装码_良好解决办法_大总结_注意珍藏.txt 说来惭愧,自己也是个学电脑不短的人了。开始搞这个东西,确实让我没琢磨透。 从装机修电脑,到假设调试网络,再到做网站,做管理软件到工控...
DevExpress.Universal.Patch.v2.4.0
DevExpress_VCL_v21.1.7_for_Delphi_11_Alexandria,强大的VCL套件,一旦拥有别无他求
DevExpress_VCL_16.2.5_Full_Source.part1 DevExpress_VCL_16.2.5_Full_Source.part2 DEVELOPER EXPRESS INC Delphi/C++Builder Controls Copyright (C) 1998-2017 Developer Express Inc. Embarcadero Delphi & ...
patch
TreeList支持通过数据提供者(如Entity Framework、LINQ to SQL等)或自定义数据源进行深层绑定。它会根据数据源中的属性或导航属性来构建树结构,每个节点代表一个对象实例,子节点则表示该对象的关联集合或嵌套...
在.NET开发环境中,DevExpress TreeList控件是一种常用的用于展示数据的树形结构组件,尤其在Windows Forms应用程序中。本文将详细讲解如何从JSON格式的数据读取并转换为DevExpress TreeList的树形结构,以实现数据...
DevExpress_13.1.7_Registration_Patch.rar
DevExpress_VCL_18.1.4_Full_Source_with_DxAutoInstaller_for_Delphi_7-Delphi_10.3_Rio_Downloadly.ir.rar
DevExpress_Runtime_Libraries_21.1.6
所包含的控件有:数据录入,图表,数据分析,导航,布局,网格,日程管理,样式,打印和工作流等,让您快速开发出完美、强大的VCL应用程序! 文件太大,分包压缩,下载其中一个压缩包无法解压文件。 压缩包资源名称...
DevExpress是一款知名的软件开发工具提供商,主要为.NET Framework、ASP.NET、Windows Forms以及Xamarin等平台提供组件和控件。在给定的压缩包文件"DevExpress_Patch_7_Reg_Downloadly.ir.rar"中,我们可以推测这...
这个控件提供了一种高效的方式来显示、编辑和管理大量数据,它支持多种数据源,包括数据库、XML、数组和集合。在"DevExpress简单的数据绑定"主题中,我们将探讨如何将数据轻松地绑定到GridControl,以便在用户界面中...
DevExpress_VCL_18.1.6_Full_Sources_Downloadly.ir.rar`
例如,其数据网格控件(GridControl)支持复杂的数据绑定、排序、过滤、分组和汇总功能,同时还提供了丰富的数据编辑和查看选项,使得数据管理变得更加便捷。 在ASP.NET方面,DevExpress提供了Web应用开发所需的...
DevExpress_VCL_18.1.2_Full_Source_with_DxAutoInstaller_2.1.10.part1 DevExpress_VCL_18.1.2_Full_Source_with_DxAutoInstaller_2.1.10.part2 说明:必须2个包下全并在同一目录下才能正常解压缩包,包中包含安装...
DevExpress的组件通常包括各种用户界面元素,如数据网格、图表、报表、菜单、工具栏等,这些控件具有高度可定制性,支持多种数据绑定,可以极大地提升应用程序的用户体验。16.1.2版本可能包含了一些新特性、性能优化...