DevExpress TreeList加載大批量數(shù)據(jù)的時(shí)候綁定數(shù)據(jù)源 dataTable.
注意事項(xiàng)1： 由于一旦綁定了數(shù)據(jù)源dataTable的些許變化便在TreeList中有所體現(xiàn), 所以等dataTable完全填充好了之后再綁定數(shù)據(jù)源.
注意事項(xiàng)2：dataTable每行的父節(jié)點(diǎn)ID當(dāng)加載到目前為止,還沒(méi)有找到那么可能就當(dāng)成空了, 所以最后treelist呈現(xiàn)就有問(wèn)題, 所以解決辦法有3個(gè), 1： 大范圍數(shù)據(jù),也就是父節(jié)點(diǎn)的數(shù)據(jù)一定要先于子節(jié)點(diǎn)在表中排列.(這個(gè)不好控制). 2： 等完全填充完datatable時(shí)再重新設(shè)置每行的父節(jié)點(diǎn)ID. 3：可以邊填充邊設(shè)置, 最后再綁定數(shù)據(jù)源, 在填充dataTable之前先解綁數(shù)據(jù)源, 即先把數(shù)據(jù)源設(shè)為空,完全填充好再重新綁定(經(jīng)過(guò)測(cè)試這種方法的加載速度最快了)
參看代碼如下:
public void ShowData(ForecastService.TrafficResult[] result, int iscrop, bool AllType)
{
//填充數(shù)據(jù)
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")//全省的數(shù)據(jù)
{
DataRow dr = dataTable.NewRow();
dr["keyFieldName"] = "湖南";//設(shè)置當(dāng)前行ID
dr["parentFieldName"] = DBNull.Value; //設(shè)置父節(jié)點(diǎn)ID
dr["維度"] = "湖南";
dr["去年基準(zhǔn)日話(huà)務(wù)量"] = result[i].lastFir.Trim();
dr["去年預(yù)測(cè)日話(huà)務(wù)量"] = result[i].lastSec.Trim();
dr["增長(zhǎng)幅度"] = result[i].add.Trim();
dr["今年基準(zhǔn)日話(huà)務(wù)量"] = result[i].nowFir.Trim();
dr["今年預(yù)測(cè)日話(huà)務(wù)量"] = result[i].nowSec.Trim();
dr["目前電路數(shù)"] = result[i].count.Trim();
dr["預(yù)測(cè)2M電路數(shù)"] = result[i].fcastcount.Trim();
dr["需要新增的電路數(shù)"] = result[i].addcount.Trim();
dataTable.Rows.Add(dr);
}
else if (result[i].trafficType != "ALL" && result[i].city == "ALL" && result[i].nename == "ALL")//匯總到類(lèi)型的數(shù)據(jù)
{
DataRow dr = dataTable.NewRow();
dr["keyFieldName"] = result[i].trafficType;
dr["parentFieldName"] = "湖南";
dr["維度"] = result[i].trafficType;
dr["去年基準(zhǔn)日話(huà)務(wù)量"] = result[i].lastFir.Trim();
dr["去年預(yù)測(cè)日話(huà)務(wù)量"] = result[i].lastSec.Trim();
dr["增長(zhǎng)幅度"] = result[i].add.Trim();
dr["今年基準(zhǔn)日話(huà)務(wù)量"] = result[i].nowFir.Trim();
dr["今年預(yù)測(cè)日話(huà)務(wù)量"] = result[i].nowSec.Trim();
dr["目前電路數(shù)"] = result[i].count.Trim();
dr["預(yù)測(cè)2M電路數(shù)"] = result[i].fcastcount.Trim();
dr["需要新增的電路數(shù)"] = result[i].addcount.Trim();
dataTable.Rows.Add(dr);
}
else if (result[i].trafficType != "ALL" && result[i].city != "ALL" && result[i].nename == "ALL")//匯總到地市的數(shù)據(jù)
{
DataRow dr = dataTable.NewRow();
dr["keyFieldName"] = result[i].trafficType + "_" + result[i].city;
dr["parentFieldName"] = result[i].trafficType;
dr["維度"] = result[i].city;
dr["去年基準(zhǔn)日話(huà)務(wù)量"] = result[i].lastFir.Trim();
dr["去年預(yù)測(cè)日話(huà)務(wù)量"] = result[i].lastSec.Trim();
dr["增長(zhǎng)幅度"] = result[i].add.Trim();
dr["今年基準(zhǔn)日話(huà)務(wù)量"] = result[i].nowFir.Trim();
dr["今年預(yù)測(cè)日話(huà)務(wù)量"] = result[i].nowSec.Trim();
dr["目前電路數(shù)"] = result[i].count.Trim();
dr["預(yù)測(cè)2M電路數(shù)"] = result[i].fcastcount.Trim();
dr["需要新增的電路數(shù)"] = 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")//匯總到網(wǎng)元的數(shù)據(jù)
{
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["去年基準(zhǔn)日話(huà)務(wù)量"] = result[i].lastFir.Trim();
dr["去年預(yù)測(cè)日話(huà)務(wù)量"] = result[i].lastSec.Trim();
dr["增長(zhǎng)幅度"] = result[i].add.Trim();
dr["今年基準(zhǔn)日話(huà)務(wù)量"] = result[i].nowFir.Trim();
dr["今年預(yù)測(cè)日話(huà)務(wù)量"] = result[i].nowSec.Trim();
dr["目前電路數(shù)"] = result[i].count.Trim();
dr["預(yù)測(cè)2M電路數(shù)"] = result[i].fcastcount.Trim();
dr["需要新增的電路數(shù)"] = 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")//到中繼的數(shù)據(jù)
{
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["去年基準(zhǔn)日話(huà)務(wù)量"] = result[i].lastFir.Trim();
dr["去年預(yù)測(cè)日話(huà)務(wù)量"] = result[i].lastSec.Trim();
dr["增長(zhǎng)幅度"] = result[i].add.Trim();
dr["今年基準(zhǔn)日話(huà)務(wù)量"] = result[i].nowFir.Trim();
dr["今年預(yù)測(cè)日話(huà)務(wù)量"] = result[i].nowSec.Trim();
dr["目前電路數(shù)"] = result[i].count.Trim();
dr["預(yù)測(cè)2M電路數(shù)"] = result[i].fcastcount.Trim();
dr["需要新增的電路數(shù)"] = 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"; //設(shè)置樹(shù)的ParentFieldName 屬性
treeListResult.KeyFieldName = "keyFieldName"; //設(shè)置樹(shù)的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["定義電路數(shù)"] = resultRelay.Total.CIRCUITS;
drRelay["來(lái)話(huà)試呼次數(shù)"] = resultRelay.Total.in_att;
drRelay["去話(huà)試呼次數(shù)"] = resultRelay.Total.out_att;
drRelay["來(lái)話(huà)應(yīng)答次數(shù)"] = resultRelay.Total.in_ans;
drRelay["去話(huà)應(yīng)答次數(shù)"] = resultRelay.Total.out_ans;
drRelay["來(lái)話(huà)話(huà)務(wù)量"] = resultRelay.Total.in_traf;
drRelay["去話(huà)話(huà)務(wù)量"] = resultRelay.Total.out_traf;
drRelay["總話(huà)務(wù)量"] = resultRelay.Total.traf;
drRelay["來(lái)話(huà)市話(huà)話(huà)務(wù)量"] = resultRelay.Total.in_local_traf;
drRelay["去話(huà)市話(huà)話(huà)務(wù)量"] = resultRelay.Total.out_local_traf;
drRelay["來(lái)話(huà)長(zhǎng)話(huà)話(huà)務(wù)量"] = resultRelay.Total.in_long_traf;
drRelay["去話(huà)長(zhǎng)話(huà)話(huà)務(wù)量"] = resultRelay.Total.out_long_traf;
drRelay["市話(huà)話(huà)務(wù)量"] = resultRelay.Total.local_traf;
drRelay["長(zhǎng)話(huà)話(huà)務(wù)量"] = 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);
}
}
posted on 2010-08-18 10:56
天書(shū) 閱讀(6790)
評(píng)論(0) 編輯 收藏 引用