快捷導(dǎo)航

ASP.NET生成樹(shù)形顯示的GridView實(shí)現(xiàn)思路

更新時(shí)間：2013年02月06日 17:58:23 作者：

生成樹(shù)形結(jié)構(gòu)的表格數(shù)據(jù)（EasyUI也有TreeGrid，此處只是提供一個(gè)思路），可以擴(kuò)展單擊展開(kāi)/收縮節(jié)點(diǎn),喜歡的朋友可以了解下啊，或許本文對(duì)你學(xué)習(xí)GridView有所幫助

目的：生成樹(shù)形結(jié)構(gòu)的表格數(shù)據(jù)（EasyUI也有TreeGrid，此處只是提供一個(gè)思路），可以擴(kuò)展單擊展開(kāi)/收縮節(jié)點(diǎn)
圖例：

類(lèi)代碼：

復(fù)制代碼代碼如下:

 
using System; 
using System.Data; 
/// <summary> 
///GridViewHelper 的摘要說(shuō)明 
/// </summary> 
public class GridViewHelper 
{ 
private string gridline; //連接線 
private DataTable dt; //傳入的DataTable 
private DataTable dtOut; //輸出的DataTable 
private DataRow row; //用于從DataView取數(shù)據(jù)并增加到dtOut 
public GridViewHelper() 
{ 
// 
//TODO: 在此處添加構(gòu)造函數(shù)邏輯 
// 
} 
/// <summary> 
/// 生成樹(shù)形結(jié)構(gòu)的DataTable 
/// </summary> 
/// <param name="datatable">原始數(shù)據(jù)表</param> 
/// <param name="parentField">上級(jí)節(jié)點(diǎn)關(guān)鍵字段</param> 
/// <param name="parentValue">上級(jí)節(jié)點(diǎn)值</param> 
/// <param name="keyField">本節(jié)點(diǎn)關(guān)鍵字段</param> 
/// <param name="textField">顯示的文本字段</param> 
/// <param name="sortString">排序字符串</param> 
/// <returns>處理后的DataTable</returns> 
public DataTable GetGridViewTreeData(DataTable datatable, string parentField, string parentValue, string keyField, string textField, string sortString) 
{ 
datatable.Columns.Add("level", Type.GetType("System.Int32")); 
dt = datatable; 
dtOut = datatable.Clone(); 
resetTextField(parentField, parentValue, keyField, textField, sortString, 0); 
return dtOut; 
} 
/// <summary> 
/// 遞歸生成新的節(jié)點(diǎn)名稱(chēng)(帶連接線) 
/// </summary> 
/// <param name="parentValueField">上級(jí)節(jié)點(diǎn)關(guān)鍵字段</param> 
/// <param name="parentValue">上級(jí)節(jié)點(diǎn)值</param> 
/// <param name="keyField">本節(jié)點(diǎn)關(guān)鍵字段</param> 
/// <param name="textField">顯示出來(lái)的文本字段</param> 
/// <param name="sortString">排序字符串</param> 
/// <param name="level">樹(shù)深度</param> 
/// <returns></returns> 
private void resetTextField(string parentValueField, string parentValue, string keyField, string textField, string sortString,int level) 
{ 
DataView dv = new DataView(dt, parentValueField + "='" + parentValue + "'", sortString, DataViewRowState.CurrentRows); 
int a = dv.Count; 
if (dv.Count == 0) 
{ 
return; 
} 
for (int i = 0; i < a; i++) 
{ 
gridline = ""; 
dv.RowFilter = parentValueField + "='" + parentValue + "'"; 
dv.Sort = sortString; 
getTreeLine(parentValueField, dv[i][parentValueField].ToString(), keyField, dv[i][keyField].ToString(), sortString); 
dv.RowFilter = parentValueField + "='" + parentValue + "'"; 
dv.Sort = sortString; 
row = dtOut.NewRow(); 
for (int c = 0; c < dv[i].Row.ItemArray.Length; c++) 
{ 
row[c] = dv[i][c]; 
} 
dtOut.Rows.Add(row); 
dtOut.Rows[dtOut.Rows.Count - 1][textField] = gridline + (i == a - 1 ? "┗" : "┣") + dv[i][textField].ToString(); 
dtOut.Rows[dtOut.Rows.Count - 1]["level"] = level; 
resetTextField(parentValueField, dv[i][keyField].ToString(), keyField, textField, sortString,level+1); 
} 
dv.Dispose(); 
} 
/// <summary> 
/// 回溯生成樹(shù)的連接線 
/// </summary> 
/// <param name="parentValueField">上級(jí)節(jié)點(diǎn)關(guān)鍵字段</param> 
/// <param name="parentValue">上級(jí)節(jié)點(diǎn)值</param> 
/// <param name="keyField">本節(jié)點(diǎn)關(guān)鍵字段</param> 
/// <param name="nodeKey">本節(jié)點(diǎn)值</param> 
/// <param name="sortString">排序字符串</param> 
/// <returns></returns> 
private void getTreeLine(string parentValueField, string parentValue, string keyField, string nodeKey, string sortString) 
{ 
//選擇父層節(jié)點(diǎn) 
DataView dv = new DataView(dt, keyField + "='" + parentValue + "'", sortString, DataViewRowState.CurrentRows); 
if (dv.Count > 0) 
{ 
//選擇父節(jié)點(diǎn)同級(jí)節(jié)點(diǎn) 
dv.RowFilter = parentValueField + "='" + dv[0][parentValueField].ToString() + "'"; 
dv.Sort = sortString; 
for (int j = 0; j < dv.Count; j++) 
{ 
if (dv[j][keyField].ToString() == parentValue) 
{ 
if (j == dv.Count - 1) 
{ 
gridline = "　" + gridline; 
} 
else 
{ 
gridline = "┃" + gridline; 
} 
} 
} 
getTreeLine(parentValueField, dv[0][parentValueField].ToString(), keyField, dv[0][keyField].ToString(), sortString); 
} 
dv.Dispose(); 
} 
} 

HTML示例代碼：

復(fù)制代碼代碼如下:

 
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="GridViewTree.aspx.cs" Inherits="GridViewTree" %> 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
<html xmlns="http://www.w3.org/1999/xhtml"> 
<head runat="server"> 
<title>生成樹(shù)形顯示的GridView</title> 
<style type="text/css"> 
body 
{ 
line-height: 16px; 
font-size: 14px; 
} 
td 
{ 
padding: 0 2px; 
} 
</style> 
</head> 
<body> 
<form id="form1" runat="server"> 
<table> 
<tr> 
<td valign="top"> 
<asp:DropDownList ID="DropDownList1" runat="server"> 
</asp:DropDownList> 
</td> 
<td> 
<asp:GridView ID="GridView1" runat="server" BorderWidth="1px" CellPadding="3" GridLines="Vertical" 
AutoGenerateColumns="False" BackColor="White" BorderColor="#E7E7FF" BorderStyle="None"> 
<AlternatingRowStyle BackColor="#F7F7F7" /> 
<Columns> 
<asp:BoundField DataField="ConText" HeaderText="文本" /> 
<asp:BoundField DataField="id" HeaderText="ID"> 
<ItemStyle HorizontalAlign="Right" Width="80px" /> 
</asp:BoundField> 
<asp:BoundField DataField="ParentID" HeaderText="父ID"> 
<ItemStyle HorizontalAlign="Right" Width="80px" /> 
</asp:BoundField> 
<asp:BoundField DataField="level" HeaderText="Level"> 
<ItemStyle HorizontalAlign="Right" Width="80px" /> 
</asp:BoundField> 
</Columns> 
<FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" /> 
<HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" /> 
<PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" /> 
<RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" /> 
<SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" /> 
<SortedAscendingCellStyle BackColor="#F4F4FD" /> 
<SortedAscendingHeaderStyle BackColor="#5A4C9D" /> 
<SortedDescendingCellStyle BackColor="#D8D8F0" /> 
<SortedDescendingHeaderStyle BackColor="#3E3277" /> 
</asp:GridView> 
</td> 
</tr> 
</table> 
</form> 
</body> 
</html> 

后臺(tái)代碼：

復(fù)制代碼代碼如下:

 
DataTable dt = gvHelper.GetGridViewTreeData(datatable, "ParentID", "1", "ID", "ConText", "ConText asc"); 
GridView1.DataSource = dt; 
GridView1.DataBind(); 
DropDownList1.Items.Add(""); 
DropDownList1.AppendDataBoundItems = true; 
DropDownList1.DataSource = dt; 
DropDownList1.DataTextField = "ConText"; 
DropDownList1.DataValueField = "ID"; 
DropDownList1.DataBind(); 

您可能感興趣的文章: