using System.Data; 
using System.Web.UI.WebControls; 
/// <summary> 
/// 根據(jù)DataTable生成下拉列表樹(shù) 
/// </summary> 
public class DropDownListHelp 
{ 
private string gridline; 
private DataTable dt; 
public DropDownListHelp() 
{ 
// 
//TODO: 在此處添加構(gòu)造函數(shù)邏輯 
// 
} 
/// <summary> 
/// 根據(jù)Datatable生成樹(shù)形下拉菜單 
/// </summary> 
/// <param name="datatable"></param> 
/// <param name="parentKeyField">上級(jí)節(jié)點(diǎn)關(guān)鍵字段</param> 
/// <param name="parentKey">上級(jí)節(jié)點(diǎn)值</param> 
/// <param name="keyField">本節(jié)點(diǎn)關(guān)鍵字段</param> 
/// <param name="sortString">排序字符串</param> 
/// <param name="ddl">DownList</param> 
public void createDropDownTree(DataTable datatable, string parentKeyField, string parentKey, string keyField, string textField, string sortString, DropDownList ddl) 
{ 
dt = datatable; 
ddl.Items.Add(new ListItem("", "")); 
addChildItems(parentKeyField, parentKey, keyField, textField, sortString, ddl); 
} 
/// <summary> 
/// 遞歸生成樹(shù)節(jié)點(diǎn) 
/// </summary> 
/// <param name="parentKeyField">上級(jí)節(jié)點(diǎn)關(guān)鍵字段</param> 
/// <param name="parentKey">上級(jí)節(jié)點(diǎn)值</param> 
/// <param name="keyField">本節(jié)點(diǎn)關(guān)鍵字段</param> 
/// <param name="sortString">排序字符串</param> 
/// <param name="ddl">DownList控件</param> 
/// <returns></returns> 
private void addChildItems(string parentKeyField, string parentKey, string keyField, string textField, string sortString, DropDownList ddl) 
{ 
DataView dv = new DataView(dt, parentKeyField + "='" + parentKey + "'", sortString, DataViewRowState.CurrentRows); 
int a = dv.Count; 
if (dv.Count == 0) 
{ 
return; 
} 
for (int i = 0; i < a; i++) 
{ 
gridline = ""; 
dv.RowFilter = parentKeyField + "='" + parentKey + "'"; 
dv.Sort = sortString; 
getTreeLine(parentKeyField, dv[i][parentKeyField].ToString(), keyField, dv[i][keyField].ToString(), sortString); 
dv.RowFilter = parentKeyField + "='" + parentKey + "'"; 
dv.Sort = sortString; 
ddl.Items.Add(new ListItem(gridline + (i == a - 1 ? "┗" : "┣") + dv[i][textField].ToString(), dv[i][keyField].ToString())); 
addChildItems(parentKeyField, dv[i][keyField].ToString(), keyField, textField, sortString, ddl); 
} 
dv.Dispose(); 
} 
/// <summary> 
/// 回溯生成樹(shù)的連接線(xiàn) 
/// </summary> 
/// <param name="parentKeyField">上級(jí)節(jié)點(diǎn)關(guān)鍵字段</param> 
/// <param name="parentKey">上級(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 parentKeyField, string parentKey, string keyField, string nodeKey, string sortString) 
{ 
//選擇父層節(jié)點(diǎn) 
DataView dv = new DataView(dt, keyField + "='" + parentKey + "'", sortString, DataViewRowState.CurrentRows); 
if (dv.Count > 0) 
{ 
//選擇父節(jié)點(diǎn)同級(jí)節(jié)點(diǎn) 
dv.RowFilter = parentKeyField + "='" + dv[0][parentKeyField].ToString() + "'"; 
dv.Sort = sortString; 
for (int j = 0; j < dv.Count; j++) 
{ 
if (dv[j][keyField].ToString() == parentKey) 
{ 
if (j == dv.Count - 1) 
{ 
gridline = "　" + gridline; 
} 
else 
{ 
gridline = "┃" + gridline; 
} 
} 
} 
getTreeLine(parentKeyField, dv[0][parentKeyField].ToString(), keyField, dv[0][keyField].ToString(), sortString); 
} 
dv.Dispose(); 
} 
} 
 
調(diào)用: 
 代碼如下:

DropDownListHelp ddlHelper = new DropDownListHelp(); 
ddlHelper.createDropDownTree(dt, "parentID", "1", "ID","Text", "Text asc", DropDownList1); 

 
 




聲明：本網(wǎng)頁(yè)內(nèi)容旨在傳播知識(shí)，若有侵權(quán)等問(wèn)題請(qǐng)及時(shí)與本網(wǎng)聯(lián)系，我們將在第一時(shí)間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com