思享工具箱

ztree树应用

摘要：
˂linkhref=“ztree/demo.css”rel=“stylesheet”type=“
<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="ZtreeListView.ascx.cs" Inherits="SplendidCRM.Administration.CompanyOrganization.ZtreeListView" %>
<link href="ztree/demo.css" rel="stylesheet" type="text/css" />
<link href="ztree/zTreeStyle/zTreeStyle.css" rel="stylesheet" type="text/css" />
<script src="ztree/jquery-1.4.4.min.js" type="text/javascript"></script>
<script src="ztree/jquery.ztree.core-3.5.js" type="text/javascript"></script>
<script src="ztree/jquery.ztree.excheck-3.5.js" type="text/javascript"></script>
<script src="ztree/jquery.ztree.exedit.js" type="text/javascript"></script>

<script type="text/javascript">
var setting ={
async: {
enable: true,
url: "ztreehandler.ashx",
autoParam: ["id", "name=n", "level=lv"],
otherParam: { "otherParam": "zTreeAsyncTest"},
dataFilter: filter
},
view: { expandSpeed: "",
addHoverDom: addHoverDom,
removeHoverDom: removeHoverDom,
selectedMulti: false},
edit: {
enable: true},
data: {
simpleData: {
enable: true}
},
callback: {
beforeRemove: beforeRemove,
beforeRename: beforeRename
}
};

function filter(treeId, parentNode, childNodes) {
if (!childNodes) return null;
for (var i = 0, l = childNodes.length; i < l; i++) {
childNodes[i].name = childNodes[i].name.replace(/.n/g, '.');
}
returnchildNodes;
}
function beforeRemove(treeId, treeNode) {    
var zTree = $.fn.zTree.getZTreeObj("treeDemo");
zTree.selectNode(treeNode);
if (confirm("Confirm delete node '" + treeNode.name + "' it?")) {
$.ajax({
type: "POST",
cache: false,
async: false,
url: "ztreehandler.ashx",
data: "id=" +treeNode.id,
success: function (result) {

}
});
}
else{
return false;
}
}
function beforeRename(treeId, treeNode, newName) {
if (newName.length == 0) {
alert("Node name can not be empty.");
return false;
}

$.ajax({
type: "POST",
cache: false,
async: false,
url: "ztreehandler.ashx",
data: "id=" + treeNode.id + "&lv=" + newName + "",
success: function (result) {

}
});

return true;
}

var newCount = 1;
function addHoverDom(treeId, treeNode) {    
var sObj = $("#" + treeNode.tId + "_span");
if (treeNode.editNameFlag || $("#addBtn_" + treeNode.tId).length > 0) return;
var addStr = "<span   id='addBtn_" +treeNode.tId
+ "' title='add node' onfocus='this.blur();'></span>";
sObj.after(addStr);
var btn = $("#addBtn_" +treeNode.tId);
if (btn) btn.bind("click", function () {
var zTree = $.fn.zTree.getZTreeObj("treeDemo");
var newid =newGuid();
var treeName = "newNode " + (addCount++);
var level = parseInt(treeNode.level) + 2;
var parentid =treeNode.id;

var newNode ={ id: newid, pId: parentid, name: treeName };
zTree.addNodes(treeNode, newNode);

var childNodes =zTree.transformToArray(treeNode);
varnodes;
for (i = 0; i < childNodes.length; i++) {
if (i == childNodes.length - 1) {
nodes =childNodes[i].tId;
}
}

$("#" + nodes + "_a").click();
$("#" + nodes + "_edit").click();

$.ajax({
type: "POST",
cache: false,
async: false,
url: "ztreehandler.ashx",
data: "id=" + newid + "&lv=" + treeName + "&n=" + level + "&fid=" + parentid + "",
success: function (result) {

}
});

return false;
});
};
function removeHoverDom(treeId, treeNode) {    
$("#addBtn_" +treeNode.tId).unbind().remove();
};

var addCount = 1;
function addTreeNode() {
var treeName="newNode " + (addCount++);
var newid=newGuid();
var newNode ={ id:newid,name: treeName };
var zTree = $.fn.zTree.getZTreeObj("treeDemo");
zTree.addNodes(null, newNode);

//获取根节点的集合
var node = zTree.getNodesByFilter(function (node) { return node.level == 0})
varnodes;
for (i = 0; i < node.length; i++) {
if (i == node.length - 1) {
nodes =node[i].tId;
}
}
$("#" + nodes + "_a").click();
$("#" + nodes + "_edit").click();

$.ajax({
type: "POST",
cache: false,
async: false,
url: "ztreehandler.ashx",
data: "id=" + newid + "&lv=" + treeName + "&n=1",
success: function (result) {

}
});
}

function refreshTreeNode() {
$.fn.zTree.init($("#treeDemo"), setting);
}

function newGuid() {
var guid = "";
for (var i = 1; i <= 32; i++) {
var n = Math.floor(Math.random() * 16.0).toString(16);
guid +=n;
if ((i == 8) || (i == 12) || (i == 16) || (i == 20))
guid += "-";
}
returnguid;
}

$(document).ready(function () {
$.fn.zTree.init($("#treeDemo"), setting);
});
</script>
<style type="text/css">.ztree li span.button.add {margin-left:2px; margin-right: -1px; background-position:-144px 0; vertical-align:top; *vertical-align:middle}
</style>

<input type="button" value="Add" id="Add" onclick="addTreeNode();"/>
<input type="button" value="Refresh" id="Refresh" onclick="refreshTreeNode();"/>
<div class="content_wrap">
<div class="zTreeDemoBackground left">
<ul id="treeDemo" class="ztree"></ul>
</div>
<div class="right">

</div>
</div>
usingSystem;
usingSystem.Collections.Generic;
usingSystem.Linq;
usingSystem.Web;
usingSystem.Text;
usingSystem.Data;
usingSystem.Data.Common;
usingSystem.Data.SqlClient;
usingNewtonsoft.Json;
usingSystem.Diagnostics;
usingSplendidCRM.TGSAP;

namespaceSplendidCRM.Administration.CompanyOrganization
{
    /// <summary>
    ///Summary description for ztreehandler
    /// </summary>
    public classztreehandler : IHttpHandler
    {

        public voidProcessRequest(HttpContext context)
        {
            context.Response.ContentType = "text/plain";

            string pId = context.Request["id"] ?? "";
            string pName = context.Request["lv"] ?? "";
            string pLevel = context.Request["n"] ?? "";
            string pCheck = context.Request["chk"] ?? "";
            string fId = context.Request["fid"] ?? "";

            StringBuilder sb = newStringBuilder();
            if (pName != "")
            {
                Guid pID =Guid.Empty;
                Guid gID =Guid.Empty;

                DbProviderFactory dbf =DbProviderFactories.GetFactory();
                using (IDbConnection con =dbf.CreateConnection())
                {
                    con.Open();
                    using (IDbTransaction trn =con.BeginTransaction())
                    {
                        try{
                            if (pId != "")
                            {
                                if (fId != "")
                                {
                                    gID =Guid.Parse(fId);
                                }
                                
                                pID =Guid.Parse(pId);
                                
                                if (pLevel != "")
                                {
                                    if (pLevel == "1")
                                    {
                                        APSqlProcs.spCOMPANYORGANIZATION_Update(ref pID, pName, Guid.Empty, "1", trn);
                                    }
                                    else{
                                        APSqlProcs.spCOMPANYORGANIZATION_Update(refpID, pName, gID, pLevel, trn);
                                    }
                                }
                                else{
                                    APSqlProcs.spCOMPANYORGANIZATION_Update(ref pID, pName, Guid.Empty, "", trn);
                                }
                            }
                            trn.Commit();
                        }
                        catch(Exception ex)
                        {
                            trn.Rollback();
                            SplendidError.SystemError(new StackTrace(true).GetFrame(0), ex);
                            return;
                        }
                    }
                }
                
            }
            else{
                if (pId != "")
                {
                    APSqlProcs.spCOMPANYORGANIZATION_Delete(Guid.Parse(pId));
                }
                else{
                    bingTree(sb);
                }
            }
            context.Response.Write(sb.ToString());
        }

        public voidbingTree(StringBuilder sb)
        {
            DbProviderFactory dbf =DbProviderFactories.GetFactory();
            using (IDbConnection con =dbf.CreateConnection())
            {
                stringsSQL;
                sSQL = "select *               " +ControlChars.CrLf
                     + "from COMPANYORGANIZATION" +ControlChars.CrLf
                     + "where 1 = 1 AND DELETED=0 ORDER BY DATE_ENTERED ASC" +ControlChars.CrLf;
                using (IDbCommand cmd =con.CreateCommand())
                {
                    cmd.CommandText =sSQL;
                    using (DbDataAdapter da =dbf.CreateDataAdapter())
                    {
                        ((IDbDataAdapter)da).SelectCommand =cmd;
                        using (DataTable dt = newDataTable())
                        {
                            da.Fill(dt);
                            if (dt.Rows.Count > 0)
                            {
                                sb.Append(getList(dt));
                            }
                        }
                    }
                }
            }
        }

        /// <summary>
        ///把数据形式转换成zTree的json数据格式
        /// </summary>
        /// <param name="table"></param>
        /// <returns></returns>
        public stringgetList(DataTable table)
        {
            try{
                List<object> lsNode = new List<object>();
                bool isParent = true;
                foreach (DataRow row intable.Rows)
                {
                    var ParentId = string.IsNullOrEmpty(row["PARENTID"].ToString()) ? 0 : row["PARENTID"];
                    if (isParentTrue(Guid.Parse(row["ID"].ToString())))
                        isParent = true;
                    elseisParent = false;
                    var zTreeData = new{
                        id = row["ID"],
                        pId =ParentId,
                        name = row["NAME"],
                        isParent =isParent
                    };
                    lsNode.Add(zTreeData);
                }
                returnJsonConvert.SerializeObject(lsNode);
            }
            catch(Exception)
            {

                throw;
            }
        }


        /// <summary>
        ///判断当前节点是否还有子节点
        /// </summary>
        /// <param name="ParentId">父节点Id</param>
        /// <returns>bool类型</returns>
        public boolisParentTrue(Guid ParentId)
        {
            try{
                DbProviderFactory dbf =DbProviderFactories.GetFactory();
                using (IDbConnection con =dbf.CreateConnection())
                {
                    stringsSQL;
                    sSQL = "select *               " +ControlChars.CrLf
                         + "from COMPANYORGANIZATION" +ControlChars.CrLf
                         + "where PARENTID='" + ParentId.ToString() + "' AND DELETED=0";
                    using (IDbCommand cmd =con.CreateCommand())
                    {
                        cmd.CommandText =sSQL;
                        using (DbDataAdapter da =dbf.CreateDataAdapter())
                        {
                            ((IDbDataAdapter)da).SelectCommand =cmd;
                            using (DataTable dt = newDataTable())
                            {
                                da.Fill(dt);
                                return dt.Rows.Count >= 1 ? true : false;
                            }
                        }
                    }
                }

            }
            catch(Exception)
            {

                throw;
            }
        }

        public boolIsReusable
        {
            get{
                return false;
            }
        }
    }
}
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[COMPANYORGANIZATION]') AND type IN (N'U'))
DROP TABLE [dbo].[COMPANYORGANIZATION]
GO

CREATE TABLE COMPANYORGANIZATION
(
    ID UNIQUEIDENTIFIER PRIMARY KEY,
    DELETED BIT DEFAULT(0) NOT NULL,
    CREATED_BY UNIQUEIDENTIFIER NULL,
    DATE_ENTERED DATETIME DEFAULT(GETDATE()) NOT NULL,
    MODIFIED_USER_ID UNIQUEIDENTIFIER NULL,
    DATE_MODIFIED DATETIME DEFAULT(GETDATE()) NOT NULL,
    NAME NVARCHAR(500) NULL,
    PARENTID UNIQUEIDENTIFIER NULL,
    LEVEL NVARCHAR(200) NULL
)
if exists (select * from sysobjects where id = object_id('dbo.spCOMPANYORGANIZATION_Update') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
    Drop Procedure [dbo].[spCOMPANYORGANIZATION_Update];
GO

Create Procedure [dbo].[spCOMPANYORGANIZATION_Update]
(
    @ID uniqueidentifier output,
    @MODIFIED_USER_ID uniqueidentifier =NULL,
    @NAME nvarchar(500) =NULL,
    @PARENTID uniqueidentifier =NULL,
    @LEVEL nvarchar(200) =NULL
)
AS

    if not exists(select * from COMPANYORGANIZATION where ID = @ID) begin --then
        IF @LEVEL<>''AND @LEVEL IS NOT NULL
        BEGIN            
            insert
            into [COMPANYORGANIZATION]
            (
                [ID],
                [CREATED_BY],
                [MODIFIED_USER_ID],
                [NAME],
                [PARENTID],
                [LEVEL]
            )
            values
            (
                @ID,
                @MODIFIED_USER_ID,
                @MODIFIED_USER_ID,
                @NAME,
                @PARENTID,
                @LEVEL
            )
        END
        ELSE
        BEGIN
            if dbo.fnIsEmptyGuid(@ID) = 1 begin --then
                set @ID =newid();
            end -- if;
        
            insert
            into [COMPANYORGANIZATION]
            (
                [ID],
                [CREATED_BY],
                [MODIFIED_USER_ID],
                [NAME],
                [PARENTID],
                [LEVEL]
            )
            values
            (
                @ID,
                @MODIFIED_USER_ID,
                @MODIFIED_USER_ID,
                @NAME,
                @PARENTID,
                @LEVEL
            )            
        END            
    end elseBEGIN            
        update [COMPANYORGANIZATION]
            set[MODIFIED_USER_ID] =@MODIFIED_USER_ID,
                [DATE_MODIFIED] =getdate(),
                [NAME] =@NAME
        where[ID] =@ID                    
    end -- if;
    
GO



Grant Execute on dbo.spCOMPANYORGANIZATION_Update to public;
GO
----------------------------------------------------------------------------------------------------



if exists (select * from sysobjects where id = object_id('dbo.spCOMPANYORGANIZATION_Delete') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
    Drop Procedure [dbo].[spCOMPANYORGANIZATION_Delete];
GO

Create Procedure [dbo].[spCOMPANYORGANIZATION_Delete]
    ( @ID               uniqueidentifier
    , @MODIFIED_USER_ID uniqueidentifier
    )
asbegin
    setnocount on

        update [COMPANYORGANIZATION]
           set DELETED          = 1, DATE_MODIFIED    =getdate()
             , MODIFIED_USER_ID =@MODIFIED_USER_ID
         where ID               =@ID
           and DELETED          = 0;
  end
GO

Grant Execute on dbo.spCOMPANYORGANIZATION_Delete to public;
GO
----------------------------------------------------------------------------------------------------

标签：#ztree | 浏览：122 | 发布日期：

免责声明：文章转载自《ztree树应用》仅用于学习参考。如对内容有疑问，请及时联系本站处理。

上篇（转载）SQL2008无法连接到.\SQLEXPRESS，用户'sa'登录失败（错误18456）图文解决方法博客园—2D小人物下篇

宿迁高防，2C2G15M，22元/月；香港BGP，2C5G5M，25元/月 雨云优惠码：MjYwNzM=

相关文章

正式开工

       经过两天的项目讨论会和团队成员间的相互沟通，对当前进行的项目和公司的主体框架有了进一步了解，目前优先级较高的是解决b/s架构项目的浏览器兼容性问题。最新的源代码已经统一签入代码管理，今天将依赖的第三方控件都安装完成，具备开发调试基础，以后将统一在此基础上进行开发。       项目是一个webform的网站，具有一定时代背景，除了分离了一个控...

转：zTree树控件扩展篇：巧用zTree控件实现文本框输入关键词自动模糊查找zTree树节点实现模糊匹配下拉选择效果

是否可以借助于zTree实现文本框输入关键词自动模糊匹配zTree下拉树，然后选择下拉树内节点显示在文本框内且隐藏下拉树。 看到这个需求脑子里头大致已经想到了要如何实现这样一个需求，当时是限于时间问题所以没有动手处理。今天闲来无事琢磨了一下这个需求。我的解决思路如下所示： 1、监听文本框的onkeyup事件；实时传递其值到某个函数； 2、编写某个函数接收...

Bootstrap风格zTree树形菜单插件

这是一款bootstrap风格jQuery zTree树形菜单插件，支持自定义编辑、添加列表菜单、删除列表等功能的jQuery树形菜单代码。在线演示 具体代码实现： <!DOCTYPE html> <HTML> <HEAD> <TITLE>ZTREE DEMO</TITLE>...

ztree插件的使用

上面是ztree官方API引入ztree的相关介绍，地址：http://www.treejs.cn/v3/api.php 注：必须先引入jQuery，然后再引入ztree相关js,因为ztree是在jQuery的基础上使用的。 //引入W3C声明 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transi...

zTree API中刷新树没效果

想刷新树，但是根据API来的refresh无效 ---------------------------------------------------------------------------------------------------------- https://bbs.csdn.net/topics/391881528 这个博客的作者的三个...

转：zTree高级入门：如何通过扩展节点的属性来达到是否显示节点的删除编辑等图标（按钮）

当我们在使用ztree树组件的节点编辑功能时，只要我们引入了ztree相关节点编辑的js脚本文件： <script type="text/javascript" src=”/js/jquery.ztree.exedit-3.5.js"></script> 接着配置setting内的edit节点： var setting = {...

最新文章

随机推荐

思享工具箱导航