jQuery+easyui树型导航问题
sb.Append(" {\"menus\":[");
if (ds.Tables[0].Rows.Count > 0)
{
DataView dv = new DataView(ds.Tables[0]);
dv.RowFilter = " ParentId=0";
dv.Sort = "Sort";
for (int i = 0; i < dv.Count; i++)
{
sb.Append("{\"menuid\":\"" + dv[i]["Id"] + "\",\"icon\":\"" + dv[i]["Icon"] + "\",\"menuname\":\"" + dv[i]["Pagelogo"] + "\",");
sb.Append("\"menus\":[");
//sb.Append("{" + dv[i]["Pagelogo"] + "," + dv[i]["Icon"] + ",");
//sb.Append("<ul>");
DataView dv2 = new DataView(ds.Tables[0]);
dv2.RowFilter = " ParentId=" + dv[i]["Id"];
dv2.Sort = " Sort";
for (int j = 0; j < dv2.Count; j++)
{
sb.Append("{\"menuid\":\"" + dv2[j]["Id"] + "\",\"menuname\":\"" + dv2[j]["Pagelogo"] + "\",\"icon\":\"" + dv2[j]["Icon"].ToString() + "\",\"url\":\"" + dv2[j]["LinkAddress"] + "\"},");
//sb.Append("<li><div><a ref=\"" + dv2[j]["Pagelogo"] + "\" href=\"javascript:void(0)\" rel=\"" + dv2[j]["LinkAddress"] + "\" ><span class=\"" + dv2[j]["Icon"].ToString() + "\" > </span><span class=\"nav\">" + dv2[j]["Pagelogo"] + "</span></a></div></li>");
}
sb.Remove(sb.Length - 1, 1);
sb.Append("]},");
// sb.Append("</ul>}");
}
//sb.Remove(0, 1);
sb.Remove(sb.Length - 1, 1);
sb.Append("]}");
}
context.Response.Write(sb.ToString());
从数据库加载数据后,可以显示。但是数据库的数据ID一改变就无法显示树型导航
如图,ID如果是1-9顺序就无法显示。
sb.Append(" {\"menus\":[");
if (ds.Tables[0].Rows.Count > 0)
{
DataView dv = new DataView(ds.Tables[0]);
dv.RowFilter = " ParentId=0";
dv.Sort = "Sort";
for (int i = 0; i < dv.Count; i++)
{
sb.Append("{\"menuid\":\"" + dv[i]["Id"] + "\",\"icon\":\"" + dv[i]["Icon"] + "\",\"menuname\":\"" + dv[i]["Pagelogo"] + "\",");
sb.Append("\"menus\":[");
//sb.Append("{" + dv[i]["Pagelogo"] + "," + dv[i]["Icon"] + ",");
//sb.Append("<ul>");
DataView dv2 = new DataView(ds.Tables[0]);
dv2.RowFilter = " ParentId=" + dv[i]["Id"];
dv2.Sort = " Sort";
for (int j = 0; j < dv2.Count; j++)
{
sb.Append("{\"menuid\":\"" + dv2[j]["Id"] + "\",\"menuname\":\"" + dv2[j]["Pagelogo"] + "\",\"icon\":\"" + dv2[j]["Icon"].ToString() + "\",\"url\":\"" + dv2[j]["LinkAddress"] + "\"},");
//sb.Append("<li><div><a ref=\"" + dv2[j]["Pagelogo"] + "\" href=\"javascript:void(0)\" rel=\"" + dv2[j]["LinkAddress"] + "\" ><span class=\"" + dv2[j]["Icon"].ToString() + "\" > </span><span class=\"nav\">" + dv2[j]["Pagelogo"] + "</span></a></div></li>");
}
sb.Remove(sb.Length - 1, 1);
sb.Append("]},");
// sb.Append("</ul>}");
}
//sb.Remove(0, 1);
sb.Remove(sb.Length - 1, 1);
sb.Append("]}");
}
context.Response.Write(sb.ToString());
从数据库加载数据后,可以显示。但是数据库的数据ID一改变就无法显示树型导航
如图,ID如果是1-9顺序就无法显示。
不懂你明白id与parentID之间的关系没?