TreeView增删改

最新推荐文章于 2023-09-18 09:59:05 发布

置顶 fanzijie112

最新推荐文章于 2023-09-18 09:59:05 发布

阅读量438

点赞数

CC 4.0 BY-SA版权

分类专栏： TreeView 文章标签： asp ASP

本文链接：https://blog.youkuaiyun.com/fanzijie112/article/details/8228593

TreeView 专栏收录该内容

1 篇文章

订阅专栏

本文展示了如何使用ASP.NET的TreeView控件实现类型数据的增删改功能。通过后台C#代码，当用户点击按钮时，可以进行添加、修改和删除操作，并与数据库交互更新数据。页面加载时初始化TreeView，根据数据库中的数据动态生成节点。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

前台代码和效果图：

后台代码：

HHE_SubjectTypeBLL tbll = new HHE_SubjectTypeBLL();
HHE_ListenTaskMainBLL bll = new HHE_ListenTaskMainBLL();

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                txtcodename.Enabled = false;
                InitTree(tv_type.Nodes, 0);
            }
        }

        //绑定类型
        private void InitTree(TreeNodeCollection Nds, int parentid)
        {

            TreeNode tmpNd = null;
            DataTable dt = bll.Select("select id,codename from HHE_SubjectType where fid=" + parentid);
            foreach (DataRow drv in dt.Rows)
            {
                tmpNd = new TreeNode();
                tmpNd.Text = drv["codename"].ToString(); ;//节点名称
                tmpNd.Value = drv["id"].ToString();
                if (parentid == 0)
                    tmpNd.Expanded = true;
                else
                    tmpNd.Expanded = false;
                Nds.Add(tmpNd);
                InitTree(Nds[Nds.Count - 1].ChildNodes, (int)drv["id"]);
            }
        }

        //添加
        protected void BtnAdd_Click(object sender, EventArgs e)
        {
            Btnupdate.Enabled = false;
            Btndelete.Enabled = false;
            txtcodename.Enabled = true;
            Btncancel.Enabled = true;
            BtnAdd.Enabled = false;
            txtcodename.Text = "";
            Btnsave.Enabled = true;
            lbltype.Text = "add";
            //Response.Write("<script>alert('" + tv_type.SelectedNode.Value + "')</script>");
        }

        //修改
        protected void Btnupdate_Click(object sender, EventArgs e)
        {
            if (lblvalue.Text == "")
            {
                Response.Write("<script>alert('请选择一个类型进行修改！')</script>");
                return;
            }
            lbltype.Text = "update";
            txtcodename.Enabled = true;
            txtcodename.Text = tv_type.SelectedNode.Text;
            BtnAdd.Enabled = false;
            Btndelete.Enabled = false;
            Btnsave.Enabled = true;
            Btnupdate.Enabled = false;
            Btncancel.Enabled = true;
        }

        //选中类型
        protected void tv_type_SelectedNodeChanged(object sender, EventArgs e)
        {
            txtcodename.Enabled = false;
            BtnAdd.Enabled = true;
            Btnupdate.Enabled = true;
            Btndelete.Enabled = true;
            Btncancel.Enabled = true;
            lblvalue.Text = tv_type.SelectedNode.Value;
        }

        //保存
        protected void Btnsave_Click(object sender, EventArgs e)
        {
            if (lbltype.Text == "")
            {
                Response.Write("<script>alert('操作不正确，请确定添加还是修改！')</script>");
                return;
            }
            if(txtcodename.Text.Trim()=="")
            {
                Response.Write("<script>alert('请填写类型名称！')</script>");
                txtcodename.Focus();
                return;
            }
            //添加
            if (lbltype.Text == "add")
            {
                string fid = "";
                if (lblvalue.Text == "")
                {
                    fid = "0";
                }
                else
                {
                    fid = lblvalue.Text;
                }
                if (tbll.AddSubjectType(fid, txtcodename.Text))
                {
                    Response.Write("<script>alert('添加成功！')</script>");
                    tv_type.Nodes.Clear();
                    InitTree(tv_type.Nodes, 0);
                    Btncancel_Click(sender, e);
                }
                else
                {
                    Response.Write("<script>alert('添加失败！')</script>");
                }
            }

            //修改
            if (lbltype.Text == "update")
            {
                if (tbll.UpdateSubjectType(lblvalue.Text, txtcodename.Text))
                {
                    Response.Write("<script>alert('数据修改成功！')</script>");
                    tv_type.Nodes.Clear();
                    InitTree(tv_type.Nodes, 0);
                    Btncancel_Click(sender, e);
                }
                else
                {
                    Response.Write("<script>alert('数据修改失败！')</script>");
                }
            }
        }

        //删除
        protected void Btndelete_Click(object sender, EventArgs e)
        {
            if (lblvalue.Text == "")
            {
                Response.Write("<script>alert('请选择一个类型进行删除！')</script>");
                return;
            }
            if (tbll.DeleteSubjectType(lblvalue.Text))
            {
                Response.Write("<script>alert('数据删除成功！')</script>");
                tv_type.Nodes.Clear();
                InitTree(tv_type.Nodes, 0);
                Btncancel_Click(sender, e);
            }
            else
            {
                Response.Write("<script>alert('数据删除失败！')</script>");
            }
        }

        //撤销
        protected void Btncancel_Click(object sender, EventArgs e)
        {
            lbltype.Text = "";
            lblvalue.Text = "";
            tv_type.Nodes.Clear();
            InitTree(tv_type.Nodes, 0);
            txtcodename.Enabled = false;
            BtnAdd.Enabled = true;
            Btnupdate.Enabled = false;
            Btndelete.Enabled = false;
            Btnsave.Enabled = false;
            Btncancel.Enabled = false;
            txtcodename.Text = "";
        }

数据库表字段：