C# codeprivate void BindProductClassData()
{
BindProductJgData();BindProductHdData();BindProductBbData();
DataTable dt = SQL.DT("select * from vProductClass order by RootID,Orders");
P_Id.Items.Clear();
DataRow[] drs = dt.Select("ParentId=0");
foreach (DataRow dr in drs)
{
string classid = dr["classid"].ToString();
string classname = dr["classname"].ToString();
classname = "├─" + classname;
P_Id.Items.Add(new ListItem(classname, classid));
int sonparentid = int.Parse(classid);
string blank = "│ ";
BindDrpNode(sonparentid, dt, blank);
}
P_Id.DataBind();
}
private void BindDrpNode(int parentid, DataTable dt, string blank)
{
DataRow[] drs = dt.Select("ParentID= " + parentid);
foreach (DataRow dr in drs)
{
string classid = dr["classid"].ToString();
string classname = dr["classname"].ToString();
classname = blank + "├─" + classname;
P_Id.Items.Add(new ListItem(classname, classid));
int sonparentid = int.Parse(classid);
string blank2 = blank + "├─";
BindDrpNode(sonparentid, dt, blank2);
}
}