public static void BindDropFatherItem( DropDownList DropDownList )
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
DropDownList.Items.Clear();
string strSql = "select * from Department";
DataTable dt = DB.GetTable( strSql );//获取所有节点
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
//判断跟节点数量
string strSql1 = "select count(*) from Department where ParentID = 0";
int ParentCount = Convert.ToInt32( DB.ExecuteScalar( strSql1 ) );
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
if( dt.Rows.Count > 0 )
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
foreach( DataRow dr in dt.Rows )
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
if( ParentCount == 0 )
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
if( dr[ "ParentID" ].ToString().Trim() == "0" )//绑定根节点
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
DropDownList.Items.Insert( 0, "请选择" );
DropDownList.Items.Add( new ListItem( dr[ "DepName" ].ToString(), dr[ "DepID" ].ToString() ) );
BindDropChildItem( DropDownList, dt, dr[ "DepID" ].ToString(), 1 );
}
}
else
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
if( dr[ "ParentID" ].ToString().Trim() == "0" )//绑定根节点
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
DropDownList.Items.Add( new ListItem( dr[ "DepName" ].ToString(), dr[ "DepID" ].ToString() ) );
BindDropChildItem( DropDownList, dt, dr[ "DepID" ].ToString(), 1 );
}
}
}
}
}
public static void BindDropChildItem( DropDownList DropDownList, DataTable dt, string id, int length )
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
DataRow[] rows = dt.Select( "ParentID='" + id + "'", "DepID ASC" );//取出id子节点进行绑定
for( int i = 0; i < rows.Length; i++ )
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
DropDownList.Items.Add( new ListItem( Department.SpaceLength( length ) + rows[ i ][ "DepName" ].ToString(), rows[ i ][ "DepID" ].ToString() ) );
BindDropChildItem( DropDownList, dt, rows[ i ][ "DepID" ].ToString(), length + 1 );//空白数目加1
}
}
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
// 子节点前面的空白数
public static string SpaceLength( int i )
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
string space = "";
for( int j = 0; j < i; j++ )
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
space += "------";//分层显示字符;
}
return space;
}
posted @
2008-06-07 15:28
Magicam
阅读(
603)
评论()
编辑
收藏
举报