谁能帮我修改一下这个拼接代码
/// <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.Append("\"attributes\":{},");
sb.Append("\"checked\":true,");
sb.AppendFormat("\"id\":\"{0}\",", dr[kField].ToString());
sb.Append("\"state\":\"open\",");
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();
}
想要的json格式是这样:
[{
"id":1,
"text":"Folder1",
"iconCls":"icon-ok",
"children":[{
"id":2,
"text":"File1",
"checked":true
},{
"id":3,
"text":"Folder2",
"state":"open",
"children":[{
"id":4,
"text":"File2",
"attributes":{
"p1":"value1",
"p2":"value2"
},
"checked":true,
"iconCls":"icon-reload"
},{
"id": 8,
"text":"Folder3",
"state":"closed",
"children":[{
"id":9,
"text":"File31"
},{
"id":10,
"text":"File32"
}]
}]
}]
},{
"text":"Languages",
"state":"closed",
"children":[{
"id":"j1",
"text":"Java"
},{
"id":"j2",
"text":"C#"
}]
}]