public static void BindDropFatherItem( DropDownList DropDownList )
{
DropDownList.Items.Clear();
string strSql &＃61; "select * from Department";
DataTable dt &＃61; DB.GetTable( strSql );//获取所有节点
//判断跟节点数量
string strSql1 &＃61; "select count(*) from Department where ParentID &＃61; 0";
int ParentCount &＃61; Convert.ToInt32( DB.ExecuteScalar( strSql1 ) );
if( dt.Rows.Count > 0 )
{
foreach( DataRow dr in dt.Rows )
{
if( ParentCount &＃61;&＃61; 0 )
{
if( dr[ "ParentID" ].ToString().Trim() &＃61;&＃61; "0" )//绑定根节点
{
DropDownList.Items.Insert( 0, "请选择" );
DropDownList.Items.Add( new ListItem( dr[ "DepName" ].ToString(), dr[ "DepID" ].ToString() ) );
BindDropChildItem( DropDownList, dt, dr[ "DepID" ].ToString(), 1 );
}
}
else
{
if( dr[ "ParentID" ].ToString().Trim() &＃61;&＃61; "0" )//绑定根节点
{
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 )
{
DataRow[] rows &＃61; dt.Select( "ParentID&＃61;&＃39;" &＃43; id &＃43; "&＃39;", "DepID ASC" );//取出id子节点进行绑定
for( int i &＃61; 0; i < rows.Length; i&＃43;&＃43; )
{
DropDownList.Items.Add( new ListItem( Department.SpaceLength( length ) &＃43; rows[ i ][ "DepName" ].ToString(), rows[ i ][ "DepID" ].ToString() ) );
BindDropChildItem( DropDownList, dt, rows[ i ][ "DepID" ].ToString(), length &＃43; 1 );//空白数目加1
}
}
// 子节点前面的空白数
public static string SpaceLength( int i )
{
string space &＃61; "";
for( int j &＃61; 0; j < i; j&＃43;&＃43; )
{
space &＃43;&＃61; "------";//分层显示字符&＃xff1b;
}
return space;
} 转:https://www.cnblogs.com/Magicam/archive/2008/06/07/1215616.html
京公网安备 11010802041100号