ASP.NET中基于JQUERY的高性能的TreeView补充
下面贴上完整的代码,我走了很多弯路,原因就是看了回复中朋友们的代码,现在想起来其实不用那么费事吧。
后台
最后数据库 大家看着建就行了 再次 感谢 不正经哥哥
代码如下:
<script src="js/jquery-1.4.2.min.js" type="text/javascript"></script> <script src="js/jquery.mytree.js" type="text/javascript"></script> <link href="second.css" rel="stylesheet" type="text/css" /> <script type="text/javascript"> $(function(){ var o = { showcheck: true}; o.data =<%=treeNodes %>; $("#tree").treeview(o); }) </script>
后台
代码如下:
public string GetFirJson() { string mystr = "["; DataTable dt = DBUtility.db.ExecuteTable("select * from class where parientid=0"); int a = dt.Rows.Count; for (int i = 0; i <= dt.Rows.Count - 1; i++) { mystr += GetOtherJson(Convert.ToInt32(dt.Rows[i]["classid"].ToString())) + ","; } mystr = mystr.Substring(0, mystr.Length - 1); mystr += "]"; mystr = mystr.Replace("'", "\""); return mystr; } //递归 private string GetOtherJson(int pid) { DataTable dt = DBUtility.db.ExecuteTable("select * from class where classid=" + pid); string strjson = ""; bool haschild = IsHasChild(pid); strjson = "{"; strjson += "'id':'" + pid + "',"; strjson += "'text':'" + dt.Rows[0]["classname"].ToString() + "',"; strjson += "'value':'" + dt.Rows[0]["classid"].ToString() + "',"; strjson += " 'showcheck':true,"; strjson += " 'complete':true,"; strjson += "'checktate':0,"; strjson += "'hasChildren':" + haschild.ToString().ToLower() + ","; strjson += "'ChildNodes':"; if (!IsHasChild(pid)) { strjson += "null}"; } else { strjson += "["; DataTable mydt = DBUtility.db.ExecuteTable("select * from class where parientid=" + pid); for (int i = 0; i <= mydt.Rows.Count - 1; i++) { strjson += GetOtherJson(Convert.ToInt32(mydt.Rows[i]["classid"].ToString())) + ","; } strjson = strjson.Substring(0, strjson.Length - 1); strjson += "]}"; } return strjson; } private bool IsHasChild(int pid) { DataTable dt = DBUtility.db.ExecuteTable("select * from class where parientid=" + pid); if (dt.Rows.Count == 0) { return false; } else { return true; } }
最后数据库 大家看着建就行了 再次 感谢 不正经哥哥
相关推荐
lanmantech 2020-07-04
lfjjia 2013-07-04
suwu0 2018-05-07
bighandsky 2018-07-09
梦回forever 2012-01-09
IA视频监控 2018-07-09
Mrlinjw 2018-05-07
我的电子世界 2018-01-15
singlow 2019-06-28
zsh 2017-11-06
图流量监控 2019-06-27
87493063 2015-02-09
theRoom 2019-06-27
zhaoyum 2019-06-27
谷歌架构师 2019-06-26
YOKOELEMENT 2014-01-06
勤能补拙孰能生巧 2019-06-25
bertZuo 2019-06-25