使用 Rad Controls 实现 可拖动节点 Tree (源代码可以下载了)

1 VS2005和.NET 2.0
2 Telerik ASP.NET RAD CONTROLS系列控件，安装后会在VS的工具栏里添加一排RAD CONTROL的控件(AJAX版本也不错)
3 castle activerecord ，具体请看terrylee的贴  卢彦的activerecord as tree
4 MYSQL Connector/Net 5.1( MYSQL5.X版本 )
5 NAVICAT 或者 EMS SQL             或者其他MYSQL GUI管理工具

源代码里附带了程序源文件,MySQL Connector 5.1,Rad 控件和皮肤

最终实现效果如下

以下为MYSQL 的结构和数据文件

-- ----------------------------
-- Table structure for department_info
-- ----------------------------
DROP TABLE IF EXISTS `department_info`;
CREATE TABLE `department_info` (
  `Department_SN` int(11) NOT NULL auto_increment COMMENT '部门流水号',
  `Department_ID` varchar(50) default NULL COMMENT '部门编号',
  `Department_Name` varchar(50) default NULL COMMENT '部门名称',
  `Department_Level` int(11) default NULL COMMENT '部门层级',
  `Department_UpperSn` int(11) default NULL COMMENT '部门层级',
  `Department_BranchStorea` varchar(50) default NULL COMMENT '上级部门',
  `Department_Head` varchar(50) default NULL COMMENT '部门总店',
  `Department_Secretary` varchar(50) default NULL COMMENT '部门秘书',
  `Department_Contact` varchar(50) default NULL COMMENT '部门联系人',
  `Department_Address` varchar(50) default NULL COMMENT '部门地址',
  `Department_Tel` varchar(50) default NULL COMMENT '部门电话',
  `Department_Fax` varchar(50) default NULL COMMENT '部门传真',
  `Department_Status` int(11) default NULL COMMENT '部门状态',
  `Department_Memo` varchar(500) default NULL COMMENT '部门备注',
  `Department_WBS` varchar(20) default NULL COMMENT 'WBS',
  PRIMARY KEY  (`Department_SN`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `department_info` VALUES ('51', '00104', '管理部', '1', null, '1', '00002', '00002', '00002', '上海市龙漕路', '021-6565656', '021-6565656', '1', '', '1');
INSERT INTO `department_info` VALUES ('52', '123123', '财务部', '2', '51', null, null, null, null, null, null, null, null, null, '1.1');
INSERT INTO `department_info` VALUES ('53', '123123', '外场', '3', '52', null, null, null, null, null, null, null, null, null, '1.1.1');
INSERT INTO `department_info` VALUES ('54', '00107', '仓管', '2', '51', null, null, null, null, null, null, null, null, null, '1.3');
INSERT INTO `department_info` VALUES ('55', '00108', '厨房', '4', '53', null, null, null, null, null, null, null, null, null, '1.1.1.1');
INSERT INTO `department_info` VALUES ('56', '00109', '采购', '2', '51', null, null, null, null, null, null, null, null, null, '1.2');

命名空间wbsbom_mysql
VS2008 新建一个WEB站点。按照castle的配置，
需要一个Global.asax，一个实体类文件department_info.cs
web.config的关键设置 2段activerecord设置是重点

Code
   <!--activerecord设置-->
      <section name="activerecord" type="Castle.ActiveRecord.Framework.Config.ActiveRecordSectionHandler, Castle.ActiveRecord"/>
      <!--activerecord设置-->
   <sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
        <sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
          <section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
          <sectionGroup name="webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
            <section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="Everywhere" />
            <section name="profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication" />
            <section name="authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication" />
            <section name="roleService" type="System.Web.Configuration.ScriptingRoleServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication" />
          </sectionGroup>
        </sectionGroup>
      </sectionGroup>
 </configSections>  

  <connectionStrings>
    <add name="Material_DBConnectionString" connectionString="server=192.168.0.56;uid=sa;pwd=;database=Material_DB" providerName="System.Data.SqlClient"/>
  </connectionStrings>
 
    <appSettings/>
  
  
  <!--activerecord设置-->
  <activerecord isWeb="true">
    <config>

      <add key="hibernate.connection.driver_class" value="NHibernate.Driver.MySqlDataDriver" />

      <add key="hibernate.dialect" value="NHibernate.Dialect.MySQLDialect" />

      <add key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider" />

      <add key="hibernate.connection.connection_string" value="ConnectionString = ${Material_DBConnectionString}" />

    </config>
  </activerecord>

gloabax.asax

Code
<%@ Application Language="C#" %>
<%@ Import Namespace="Castle.ActiveRecord" %>
<%@ Import Namespace="Castle.ActiveRecord.Framework.Config" %>

<script runat="server">

    void Application_Start(object sender, EventArgs e) 
    {
        // Code that runs on application startup
   Castle.ActiveRecord.ActiveRecordStarter.Initialize
            (
            
            ActiveRecordSectionHandler.Instance,
                               new Type[] 
                          { 
                             typeof(wbsbom_mysql.department_info),
                        
                          }
                    );
                              
    }

activeRecord的CRUD

Code
private static void DeleteHaveNotChildren()
    {

        //删除 和 删除一个部门的名字
        department_info 博客园 = department_info.FindAllByProperty("Department_Name", "博客园_修改")[0];
        博客园.Children.Clear();
        //注意就不会把儿子也一起删除掉
        博客园.Delete();
    }

    private static department_info DeleteHaveChildren()
    {
        //删除 和 删除一个部门的名字
        department_info 博客园 = department_info.FindAllByProperty("Department_Name", "博客园_修改")[0];
        //注意会把儿子也一起删除掉,因为在model的定义里设置了级联操作 ManyRelationCascadeEnum
        博客园.Delete();
        return 博客园;
    }

    private static void Create()
    {


        //新建 和 新建一个部门的名字
        department_info 博客园 = new department_info();
        博客园.Department_Name = "博客园";

        department_info 书籍部门 = new department_info();
        书籍部门.Department_Name = "书籍部门";

        department_info 写书部门 = new department_info();
        写书部门.Department_Name = "写书部门";

        书籍部门.Children.Add(写书部门);

        博客园.Children.Add(书籍部门);

        博客园.Create();


        /**//*  数据库里的样子
            1        博客园                                                
            2        书籍部门        1    
            3       写书部门        2
        */
    }

    private static void Save()
    {

        //修改 和 修改一个部门的名字
        department_info 博客园_修改 = department_info.FindAllByProperty("Department_Name", "博客园")[0];
        博客园_修改.Department_Name = "博客园_修改";        //
        博客园_修改.Save();

        department_info 书籍部门 = (department_info)博客园_修改.Children[0];
        书籍部门.Department_Name = "书籍部门_修改";
        书籍部门.Save();

        department_info 写书部门 = department_info.FindAllByProperty("Department_Name", "写书部门")[0];
        写书部门.Department_Name = "写书部门_修改";
        写书部门.FatherDepartment_info = 博客园_修改;
        写书部门.Save();
      
        
        /**//*  数据库里的样子
             1        博客园_修改                                                
             2        书籍部门_修改        1                                        
             3      写书部门_修改       1
         */
    }

 //新建 和 新建一个部门的名字
        department_info new_department_info = new department_info();
        new_department_info.Department_Name = "博客园";

        department_info new_Childrendepartment_info = new department_info();
        new_Childrendepartment_info.Department_Name = "书籍翻译部门";

        department_info grand_Childrendepartment_info = new department_info();
        grand_Childrendepartment_info.Department_Name = "写书部门";

        new_Childrendepartment_info.Children.Add(grand_Childrendepartment_info);

        new_department_info.Children.Add(new_Childrendepartment_info);

        new_department_info.Create();


          /**//*  数据库里的样子
              73        博客园                                                
              74        书籍翻译部门        73                                        
          */

        //修改 和 修改一个部门的名字
        department_info update_department_info = department_info.FindAllByProperty("Department_Name", "博客园")[0];
        update_department_info.Department_Name = "博客园_修改";        //

        department_info update_Childrendepartment_info = (department_info)update_department_info.Children[0];
        update_Childrendepartment_info.Department_Name = "书籍翻译部门_修改";
        update_department_info.Save();


        /**//*  数据库里的样子
             73        博客园_修改                                                
             74        书籍翻译部门_修改        73                                        
                                    
         */

        /**/////删除 和 删除一个部门的名字
        //department_info del_department_info = department_info.FindAllByProperty("Department_Name", "博客园_修改")[0];
        /**/////注意会把儿子也一起删除掉
        //del_department_info.Delete();


        /**/////删除 和 删除一个部门的名字
        //department_info delHasntChildren_department_info = department_info.FindAllByProperty("Department_Name", "博客园_修改")[0];
        //delHasntChildren_department_info.Children.Clear();
        /**/////注意就不会把儿子也一起删除掉
        //delHasntChildren_department_info.Delete();

    //新建 和 新建一个部门的名字
        department_info new_department_info = new department_info();
        new_department_info.Department_Name = "博客园";

        department_info new_Childrendepartment_info = new department_info();
        new_Childrendepartment_info.Department_Name = "书籍翻译部门";
        new_department_info.Children.Add(new_Childrendepartment_info);

        new_department_info.Create();


          /**//*  数据库里的样子
              73        博客园                                                
              74        书籍翻译部门        73                                        
          */

        //修改 和 修改一个部门的名字
        department_info update_department_info = department_info.FindAllByProperty("Department_Name", "博客园")[0];
        update_department_info.Department_Name = "博客园_修改";        //

        department_info update_Childrendepartment_info = (department_info)update_department_info.Children[0];
        update_Childrendepartment_info.Department_Name = "书籍翻译部门_修改";
        update_department_info.Save();


        /**//*  数据库里的样子
             73        博客园_修改                                                
             74        书籍翻译部门_修改        73                                        
                                    
         */

        /**/////删除 和 删除一个部门的名字
        //department_info del_department_info = department_info.FindAllByProperty("Department_Name", "博客园_修改")[0];
        /**/////注意会把儿子也一起删除掉
        //del_department_info.Delete();


        /**/////删除 和 删除一个部门的名字
        //department_info delHasntChildren_department_info = department_info.FindAllByProperty("Department_Name", "博客园_修改")[0];
        //delHasntChildren_department_info.Children.Clear();
        /**/////注意就不会把儿子也一起删除掉
        //delHasntChildren_department_info.Delete();

源代码如下

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using Telerik.WebControls;
using System.Collections.Generic;
using System.Collections;
using System.Data.SqlClient;
using wbsbom_mysql;
using MySql.Data.MySqlClient;

public partial class WBSTree_Default2 : System.Web.UI.Page
{
 
    protected void Page_Load(object sender, EventArgs e)
    {
       
            if (!IsPostBack )
            {
             
                //根节点是树控件的第一个节点 没有任何意义 只是显示作用
                tree1.Nodes.Clear();
                RadTreeNode rootNode = new RadTreeNode();
                rootNode.Text = "";
                rootNode.Value = "根节点";
                rootNode.ImageUrl = "Img/mailfolder.gif";
                rootNode.Expanded = true;
                rootNode.ContextMenuName = "File";
                
                    
                //添加 顶层 的 “部门” 到 “根节点” 下
                department_info[] _department_info = department_info.FindAllByProperty("FatherDepartment_info", null);
     
                if (_department_info.Length == 0) {
                    RadAjaxManager1.Alert("暂时没有数据");    //跳出提示
                    return;
                  
                }

                // ”部门“ 添加到 “根节点” 下
                for (int i = 0; i < _department_info.Length; i++)
                {
                    AddChildToTree(rootNode, _department_info[i]);
                }


                //子部门 添加到 父部门下
                for (int i = 0; i < _department_info.Length; i++)
                {
                    AddChildToTreeRecursion(rootNode.Nodes[i], _department_info[i]);
                }

                //全部添加到控件上
                tree1.Nodes.Add(rootNode);
                tree1.ExpandAllNodes();

            }

    }

    节点添加到控件#region 节点添加到控件
    /**//// <summary>
    ///"部门" 添加到某节点
    /// </summary>
    /// <param name="treeNode">The tree node.</param>
    /// <param name="_department_info">The _department_info.</param>
    public void AddChildToTree(RadTreeNode treeNode, department_info _department_info)
    {
            RadTreeNode node = new RadTreeNode();
            node.Text = _department_info.Department_Name;
            node.Value = _department_info.Department_SN.ToString();
         
            node.ImageUrl = "Img/mailfolder.gif";
            node.Expanded = true;
            node.Category = _department_info.Department_ID.ToString();
            node.ContextMenuName = "File";//todo

            treeNode.Nodes.Add(node);
    }



    /**//// <summary>
    /// "部门" 下的部门 添加到某节点
    /// </summary>
    /// <param name="treeNode">The tree node.</param>
    /// <param name="_department_info">The _department_info.</param>
    public void AddChildToTreeRecursion(RadTreeNode treeNode, department_info _department_info)
    {
            foreach (department_info child in _department_info.Children)
            {
                RadTreeNode node = new RadTreeNode();
                node.Text = child.Department_Name;
                node.Value = child.Department_SN.ToString();
                node.ImageUrl = "Img/mailfolder.gif";
                node.Expanded = true;
                node.Category = _department_info.Department_ID.ToString();
                node.ContextMenuName = "File";

                treeNode.Nodes.Add(node);

                AddChildToTreeRecursion(node, child);
            }
        }
    protected void AddChilds(RadTreeNode dstNode, RadTreeNode srcNode)
    {
        foreach (RadTreeNode srcChildNode in srcNode.Nodes)
        {
            RadTreeNode destChildNode = new RadTreeNode(srcChildNode.Text, srcChildNode.Value);
            destChildNode.ImageUrl = "Img/mailfolder.gif";
            destChildNode.Expanded = true;


            dstNode.Nodes.Add(destChildNode);
            AddChilds(destChildNode, srcChildNode);
        }
    }


    #endregion

    /**//// <summary>
    /// 处理节点移动
    /// </summary>
    /// <param name="sender">The source of the event.</param>
    /// <param name="e">The <see cref="Telerik.WebControls.AjaxRequestEventArgs"/> instance containing the event data.</param>
    public void AjaxManager1_AjaxRequest(object sender, AjaxRequestEventArgs e)
    {
        /**//*
            客户端ajax request 代码
            window["<%= RadAjaxManager1.ClientID %>"].AjaxRequest(sourceNode.TreeView.ClientID + "\r\n" + sourceNode.Text + "\r\n" + destNode.Text);
    
         */

        string[] args = e.Argument.Replace("\r\n", "\n").Split('\n');
        RadTreeView srcTree = null;
        RadTreeView dstTree = null;
        if (tree1.ClientID.Equals(args[0]))     //这里tree1既是源也是目标
        {
            srcTree = tree1;
        }
      
        if (tree1.ClientID.Equals(args[0]))
        {
            dstTree = tree1;
        }


        RadTreeNode sourceNode = srcTree.FindNodeByText(args[1]);

        RadTreeNode destNode = dstTree.FindNodeByText(args[2]);


        RadTreeNode tempNode = destNode;
       
        while (tempNode != null)
        {
            if (!tempNode.Equals(sourceNode))
            {
                tempNode = tempNode.Parent;
  
            }
            else
             break;
        }
        if (tempNode != null)
        {
            RadAjaxManager1.Alert("父节点不可移动到子节点");
            return;
        }

        RadTreeNode newNode = new RadTreeNode(sourceNode.Text, sourceNode.Value);
        newNode.ImageUrl = "Img/mailfolder.gif";
        newNode.Expanded = true;
 
        AddChilds(newNode, sourceNode);

        destNode.Nodes.Add(newNode);

        destNode.ExpandChildNodes();

        if (!sourceNode.Equals(srcTree.Nodes[0]))
        {
            sourceNode.Remove();
        }

      
}


    protected void Button1_Click(object sender, EventArgs e)
    {
        Label1.Text = "";

        HiberarchyOrder(tree1.Nodes[0]);

    }

    /**//// <summary>
    /// 层次遍历该死的radcontrol,显示其节点信息给Label1,并保存结果至数据库
    /// </summary>
    /// <param name="rootNode"></param>
    public void HiberarchyOrder(RadTreeNode rootNode)
    {
        List<RadTreeNode> Nodes = new List<RadTreeNode>();

        //层次遍历
        int front = -1;
        int rear = -1;
        if (rootNode != null)
        {
            rear++;
            Nodes.Add(rootNode);
        }
        while (front != rear)
        {
            front++;
            if (Nodes[front].Value == "根节点")
            {
                Nodes[front].ToolTip = "0";
            }
            rootNode = Nodes[front];
            Label1.Text += "<p>" + rootNode.Value + "   " + rootNode.Text + "     节点编码： " + rootNode.ToolTip + "</p>";

            //节点编码
            for (int i = 0; i < rootNode.Nodes.Count; i++)
            {

                if (rootNode.Nodes[i] != null)
                {
                    rear++;
                    if (rootNode.Value == "根节点")//根节点不需要加" ."
                    {
                        rootNode.Nodes[i].ToolTip = (i + 1).ToString();
                    }
                    else
                    {
                        rootNode.Nodes[i].ToolTip = rootNode.ToolTip + "." + (i + 1).ToString();
                    }
                    Nodes.Add(rootNode.Nodes[i]);

                }

            }
  
            string nodeFrontFatherValue = "";
            //如果是根节点 或者  其层级为1层的 那么他们的上级就为null
            if (Nodes[front].ToolTip == "0" || Get_department_info_LevelByWbs(Nodes[front].ToolTip) == 1)
            {
                nodeFrontFatherValue = "";
            }
            else
            {
                nodeFrontFatherValue = Nodes[front].Parent.Value;
            }
          
         



            int _department_info_Sn = -1;
            if (Nodes[front].ToolTip != "0")
            {
                _department_info_Sn = Convert.ToInt32(Nodes[front].Value);
            }
            string WBS = Nodes[front].ToolTip;
            int _department_info_Level = Get_department_info_LevelByWbs(Nodes[front].ToolTip);
            string _Department_UpperSn = "";

            //如果是根节点 或者  其层级为1层的 那么他们的上级就为null
            if (Nodes[front].ToolTip == "0" || Get_department_info_LevelByWbs(Nodes[front].ToolTip) == 1)
            {
                _Department_UpperSn = "";
            }
            else
            {
                _Department_UpperSn = Nodes[front].Parent.Value;
            }


            //保存吧 
            if (_department_info_Sn != -1)
            {
                department_info _department_info = department_info.Find(_department_info_Sn);
                _department_info.Department_WBS = WBS;
                _department_info.Department_Level = _department_info_Level;
                if (!string.IsNullOrEmpty(_Department_UpperSn))
                {
                    _department_info.FatherDepartment_info = department_info.Find(Convert.ToInt32(_Department_UpperSn));
                }
                _department_info.Save();
            }
       

        }

    }


    /**//// <summary>
    /// 若输入2.1 则 level为2 ,输入3.2.2 ,则level为 3
    /// </summary>
    /// <param name="wbsCode">The WBS code.</param>
    /// <returns></returns>
    public int Get_department_info_LevelByWbs(string wbsCode)
    {
        if (wbsCode == "0")
        {
            return 0;
        }
        int level = 0;
        foreach (char c in wbsCode)
        {
            if (c == '.')
            {
                level++;
            }
        }
        return level+1;
    }

 

 }

Future Reading:Rails生成ExtTee