动态生成树型结构方法

最新推荐文章于 2025-03-27 16:42:40 发布

转载最新推荐文章于 2025-03-27 16:42:40 发布 · 757 阅读

文章标签：

#tree #string #dataset #javascript #database #数据库

WebTree 专栏收录该内容

3 篇文章

订阅专栏

动态生成树型结构方法

一个分类体系，比如将所有列车第一分类，车厢作为第二级别分类，车厢里面的排作为第三级分类……等等，这样就可以统一在一个表里面实现，比如：
0001列车一
00010001列车一车厢一
000100010001列车一车厢一排一
000100010002列车一车厢一排二
00010002列车一车厢二
000100020001列车一车厢二排一
0002列车二
00020001列车二车厢一
.....

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindDataBase(); //调用BindDataBase方法
tb.ShowLines = true;//显示连接父节点与子节点间的线条
tb.ExpandDepth = 1;//控件显示时所展开的层数

}
l1.Text = "层次" + tb.SelectedValue;

}

#region 计算id编码的节点的层次 001 为一层 001001为二层

private int levelCount(string str)
{
//string delimStr = "_";
//char[] delimiter = delimStr.ToCharArray();
//string[] split = null;
//split = str.Split(delimiter);
//return split.Length;
int deepth = str.Length / 3;
return deepth;
}
#endregion

#region 将数据库的数据存入DataSet

private DataSet GetFuncAll()
{
SqlConnection sqlCon = new SqlConnection();
//实例化SqlConnection对象连接数据库的字符串
sqlCon.ConnectionString = @"server=JONKIKY/SQLEXPRESS;uid=sa;pwd=123456;database=treetext;Trusted_Connection=True";
//实例化SqlDataAdapter对象

SqlDataAdapter da = new SqlDataAdapter("select * from Func order by FuncID asc", sqlCon);

DataSet ds = new DataSet();
da.Fill(ds, "Func");
return ds;
}

#endregion

#region 生成树tewwview

public void BindDataBase()
{
DataSet ds = GetFuncAll(); //得到数据库的数据

TreeNode tree2 = null;
TreeNode tree3 = null;
// TreeNode NodeLast= null;
int LevelLast = 0; //当前节点所在的层次
int nLevel; //得到的节点的层次
string sTitle; //节点的内容
TreeNode tree1 = new TreeNode("技能交换"); //Root根节点
this.tb.Nodes.Add(tree1);

for (int i = 0; i < ds.Tables["Func"].Rows.Count; i++)
{

nLevel = levelCount(ds.Tables["Func"].Rows[i]["FuncID"].ToString());
sTitle = Convert.ToString(ds.Tables["Func"].Rows[i]["FuncTitle"]) + ds.Tables["Func"].Rows[i]["FuncID"].ToString() + "*" + nLevel + "*" + LevelLast;

//写入节点的级别与上一个节点级别相同加入兄弟节点
if (nLevel == LevelLast)
{
tree3 = new TreeNode(sTitle);
tree3.Text = ds.Tables["Func"].Rows[i]["FuncTitle"].ToString();
tree3.Value = ds.Tables["Func"].Rows[i]["FuncID"].ToString();
tree2.Parent.ChildNodes.Add(tree3);
tree2 = tree3;

}
//写入节点的级别大于上一个节点级别大一个级别
else if (nLevel > LevelLast)
{
//写入节点是根节点
if ((tree1.Value == "技能交换") && (tree2 == null))
{
tree2 = new TreeNode(sTitle);
tree2.Text = ds.Tables["Func"].Rows[i]["FuncTitle"].ToString();
tree2.Value = ds.Tables["Func"].Rows[i]["FuncID"].ToString();
tree1.ChildNodes.Add(tree2);

}
else//写入节点不是是根节点
{

tree3 = new TreeNode(sTitle);
tree3.Text = ds.Tables["Func"].Rows[i]["FuncTitle"].ToString();
tree3.Value = ds.Tables["Func"].Rows[i]["FuncID"].ToString();
tree2.ChildNodes.Add(tree3);

tree2 = tree3;//定位到该节点！！！！！！！！！！！！

}

}
else
{ //写入节点的级别小于上一个节点级别小一个或多个级别
while (nLevel < LevelLast)
{
tree2 = tree2.Parent;//寻找其父节点
LevelLast = LevelLast - 1;
}
//写入节点是根节点
if (tree2.Parent.Value == "技能交换")
{
tree2 = new TreeNode(sTitle);
tree2.Text = ds.Tables["Func"].Rows[i]["FuncTitle"].ToString();
tree2.Value = ds.Tables["Func"].Rows[i]["FuncID"].ToString();
tree1.ChildNodes.Add(tree2);
}
else
//写入节点不是根节点
{
tree3 = new TreeNode(sTitle);
tree3.Text = ds.Tables["Func"].Rows[i]["FuncTitle"].ToString();
tree3.Value = ds.Tables["Func"].Rows[i]["FuncID"].ToString();
tree2.Parent.ChildNodes.Add(tree3);
tree2 = tree3;
}

}
LevelLast = nLevel; //获取当前的节点层次

}

}
#endregion

protected void tb_SelectedNodeChanged(object sender, EventArgs e)
{

}

private bool check()
{
if ((content.Text == null) || (tb.SelectedValue == null))
{
return false;
}
else
{
return true;
}
}

protected void add_Click(object sender, EventArgs e)
{
string skillname = content.Text.ToString();
string rootid = tb.SelectedValue;

SqlConnection sqlCon = new SqlConnection();
//实例化SqlConnection对象连接数据库的字符串
sqlCon.ConnectionString = @"server=JONKIKY/SQLEXPRESS;uid=sa;pwd=123456;database=treetext;Trusted_Connection=True";
sqlCon.Open();

if (check())
{

string cmdtxt2 = "select * from func where funcid like '" + rootid + "'+'___'";

SqlCommand com = new SqlCommand(cmdtxt2, sqlCon);

SqlDataReader read = com.ExecuteReader();
int i = 0;
while (read.Read())
{
i++;
}

i = i + 1;
string t = string.Format("{0:D3}", i);
string addid = rootid + t;
read.Close();
string cmdtxt = "insert into func (FuncID,FuncTitle)";
cmdtxt += "values('" + addid + "','" + skillname + "')";
SqlCommand com2 = new SqlCommand(cmdtxt, sqlCon);
int read2 = com2.ExecuteNonQuery();
Response.Write(i);
sqlCon.Close();
if (read2 == -1)
{
Response.Write("<script language=javascript>alert('添加失败2');location='javascript:history.go(-1)'</script>");
}
else
{

Response.Write("<script language=javascript>alert('添加成功');location='Default.aspx'</script>");
}

}
else
{
Response.Write("<script language=javascript>alert('添加失败没');location='javascript:history.go(-1)'</script>");
}

}
protected void delete_Click(object sender, EventArgs e)
{
string skillname = content.Text.ToString();
string rootid = tb.SelectedValue;
SqlConnection sqlCon = new SqlConnection();
//实例化SqlConnection对象连接数据库的字符串
sqlCon.ConnectionString = @"server=JONKIKY/SQLEXPRESS;uid=sa;pwd=123456;database=treetext;Trusted_Connection=True";
sqlCon.Open();

if (check())
{

string cmdtxt2 = "delete from func where funcid ='" + rootid + "'";

SqlCommand com = new SqlCommand(cmdtxt2, sqlCon);
int result = com.ExecuteNonQuery();

if (result == -1)
{
Response.Write("<script language=javascript>alert('删除失败2');location='javascript:history.go(-1)'</script>");
}
else
{

Response.Write("<script language=javascript>alert('删除成功');location='Default.aspx'</script>");
}

}

else
{
Response.Write("<script language=javascript>alert('删除失败没');location='javascript:history.go(-1)'</script>");
}

}
protected void alter_Click(object sender, EventArgs e)
{
string skillname = content.Text.ToString();
string rootid = tb.SelectedValue;
SqlConnection sqlCon = new SqlConnection();
//实例化SqlConnection对象连接数据库的字符串
sqlCon.ConnectionString = @"server=JONKIKY/SQLEXPRESS;uid=sa;pwd=123456;database=treetext;Trusted_Connection=True";
sqlCon.Open();

if (check())
{

string cmdtxt2 = "update func";
cmdtxt2 += " set FuncTitle= '" + skillname + "'";
cmdtxt2 += " where funcid ='" + rootid + "'";

SqlCommand com = new SqlCommand(cmdtxt2, sqlCon);
int result = com.ExecuteNonQuery();

if (result == -1)
{
Response.Write("<script language=javascript>alert('修改失败2');location='javascript:history.go(-1)'</script>");
}
else
{

Response.Write("<script language=javascript>alert('修改成功');location='Default.aspx'</script>");
}

}

else
{
Response.Write("<script language=javascript>alert('修改失败没');location='javascript:history.go(-1)'</script>");
}

}