ztree的数据绑定


首先应用JS文件和样式文件

    <script src="../JavaScript/ZTree/jquery-ztree-2.2.min.js" type="text/javascript"></script>

   <link href="../JavaScript/ZTree/zTreeStyle/zTreeIcons.css" rel="stylesheet" type="text/css" />
    <link href="../JavaScript/ZTree/zTreeStyle/zTreeStyle.css" rel="stylesheet" type="text/css" />

 其次:json值绑定

var treeData;
$.ajax({
type: "Get", //请求的方法
url: '',//要传递参数使用Ajax进行处理的类名称
dataType: "text", //返回的数据类型
global: false, //Ajax的范围
async: false, //异步执行
//成功情况下的处理
success: function (strReult) {

treeData=eval(strReult);
}, //失败情况下的处理
error: function () {
alert("Ajax请求数据失败!");
}
});

var setting = {

showLine: true,
checkable: false,
};

zTree = $("#ulUserTree").zTree(setting, treeData);

后台处理json处理;数据库中查出的数据集放在DataTable 中传入如下方法返回json数据

        //json处理
#region
/// <summary>
/// 表格数据生成指定格式的json数据
/// </summary>
/// <param name="dt">生成json数据的报表</param>
/// <returns></returns>
public static string DtToJson(DataTable dt)
{
string result = string.Empty;

foreach (DataRow dr in dt.Select("parentid=0"))
{
result += "," + AppendJson(dr, dt);

}
if (result.Length > 0)
result = "[\r\n" + result.Substring(1) + "\r\n]";
return result;
}
/// <summary>
/// 生成指定的Json数据
/// </summary>
/// <param name="dr">报表行对象</param>
/// <param name="dtAll">报表对象</param>
/// <returns></returns>
private static string AppendJson(DataRow dr, DataTable dtAll)
{
string parentNode = string.Empty;
string isTrue = "false";
DataRow[] rows = dtAll.Select("parentid='" + dr["VALUE"].ToString().Trim() + "'");
if (rows.Length == 0)
{

parentNode = "\r\n{name:{name},icon:\"{icon}\",open:" + isTrue + ", checked:false, id:\"{id}\"" + "\r\n}";
parentNode = parentNode.Replace("{name}", dr["name"].ToString())
.Replace("{id}", dr["VALUE"].ToString()).Replace("{icon}", dr["icon"].ToString());
}
else
{
string result = string.Empty;

foreach (DataRow row in rows)
{
result += "," + AppendJson(row, dtAll);

}


if (result.Length > 0)
result = "[\r\n" + result.Substring(1) + "\r\n]";
parentNode = "\r\n{name:{name},icon:\"{icon}\",open:" + isTrue + ", checked:false, id:\"{id}\",nodes:" + result + "\r\n}";
parentNode = parentNode.Replace("{name}", dr["name"].ToString())
.Replace("{id}", dr["VALUE"].ToString()).Replace("{icon}", dr["icon"].ToString());
}
return parentNode;
}
#endregion
原文地址:https://www.cnblogs.com/zgaspnet/p/2321281.html