发布一篇 DataTable 转化为适合 jquery easyui tree,combotree 的json 函数

显示效果如下:

        /// <summary>
        /// 递归将DataTable转化为适合jquery easy ui 控件tree ,combotree 的 json
        /// 该方法最后还要 将结果稍微处理下,将最前面的,"children" 字符去掉.
        /// </summary>
        /// <param name="dt">要转化的表</param>
        /// <param name="pField">表中的父节点字段</param>
        /// <param name="pValue">表中顶层节点的值,没有 可以输入为0</param>
        /// <param name="kField">关键字字段名称</param>
        /// <param name="TextField">要显示的文本 对应的字段</param>
        /// <returns></returns>
        public static string TableToEasyUITreeJson(DataTable dt,string pField,string pValue,string kField,string TextField)
        {
            StringBuilder sb = new StringBuilder();
            string filter = String.Format(" {0}='{1}' ", pField, pValue);//获取顶级目录.
            DataRow[] drs = dt.Select(filter);
            if (drs.Length < 1)
                return "";
                sb.Append(",\"children\":[");
            foreach (DataRow dr in drs)
            {
                string pcv = dr[kField].ToString();
                sb.Append("{");
                sb.AppendFormat("\"id\":\"{0}\",",dr[kField].ToString());
                sb.AppendFormat("\"text\":\"{0}\"",dr[TextField].ToString());
                sb.Append(TableToEasyUITreeJson(dt, pField, pcv,kField,TextField).TrimEnd(','));
                sb.Append("},");
            }
            if (sb.ToString().EndsWith(","))
            {
                sb.Remove(sb.Length - 1, 1);
            }
                sb.Append("]");
            return sb.ToString();

        }

调用方法:

            string result = "";
            BLL.UniversalTree BLLU = new BLL.UniversalTree();
            DataTable Dt = BLLU.GetAllList().Tables[0];
            result=TableToEasyUITreeJson(Dt, "parentsid", "0", "sid", "Name");
            if (result.Length > 12)
            {
                result = result.Substring(12);
            }
            return result;

html代码

<asp:TextBox id="txtUniverSalSid" runat="server" width="600px"></asp:TextBox>

            $(function() {
                      $("#<%=txtUniverSalSid.ClientID %>").combotree({
                          url: "/ajaxhander/json.ashx?param=getuniversaltree"
                      });
                  });