{"id":222,"date":"2008-02-27T16:34:00","date_gmt":"2008-02-27T16:34:00","guid":{"rendered":"http:\/\/www.sincebirth.cn\/?p=222"},"modified":"2008-02-27T16:34:00","modified_gmt":"2008-02-27T16:34:00","slug":"%e7%94%a8linq%e7%94%9f%e6%88%90%e6%97%a0%e9%99%90%e7%ba%a7%e5%88%86%e7%b1%bb%e8%8f%9c%e5%8d%95treeview","status":"publish","type":"post","link":"https:\/\/niuduer.sincebirth.space\/?p=222","title":{"rendered":"\u7528Linq\u751f\u6210\u65e0\u9650\u7ea7\u5206\u7c7b\u83dc\u5355TreeView"},"content":{"rendered":"
\n

\u6570\u636e\u6a21\u578b\uff1aNewsCategory<\/p>\n

\n\n\n\n\n\n\n
\n

Cateid<\/p>\n<\/td>\n

\n

uniqueidentifier<\/p>\n<\/td>\n

\n

ID<\/p>\n<\/td>\n<\/tr>\n

\n

CateName<\/p>\n<\/td>\n

\n

Nvarchar(256)<\/p>\n<\/td>\n

\n

\u5206\u7c7b\u540d<\/p>\n<\/td>\n<\/tr>\n

\n

PreCate<\/p>\n<\/td>\n

\n

uniqueidentifier<\/p>\n<\/td>\n

\n

\u7236\u7c7b<\/p>\n<\/td>\n<\/tr>\n

\n

IsLeaf<\/p>\n<\/td>\n

\n

bit<\/p>\n<\/td>\n

\n

\u662f\u5426\u4e3a\u53f6\u5b50<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\u9996\u5148\u521b\u5efaLinq to sql classes\u6587\u4ef6DB.dbml\uff0c\u628a\u8be5\u8868\u62d6\u8fdb\u53bb<\/p>\n

\u4e0b\u9762\u662f\u4ee3\u7801\uff1a<\/p>\n

\u5728\u9875\u9762\u4e0a\u653e\uff1a<\/p>\n

<asp:TreeView ID="TreeView1" runat="server" ShowLines="True">
\n    <\/asp:TreeView><\/p>\n

.cs\u4e2d\u4e3a\uff1a<\/p>\n

    DBDataContext ctx = new DBDataContext();<\/p>\n

    protected void Page_Load(object sender, EventArgs e)
\n    {             
\n        IQueryable<NewsCategory> cates = from cate in ctx.NewsCategories
\n                                         where cate.PreCate.ToString().Equals("root")
\n                                         select cate;
\n        foreach (var cate in cates)
\n        {
\n            TreeNode node = new TreeNode();
\n            node.Text = cate.CateName;
\n            node.Value = cate.CateId.ToString();
\n            TreeView1.Nodes.Add(node);
\n            if (cate.IsLeaf==false)
\n            {
\n                node.Expanded = true;
\n                AddReplies(node);
\n            }
\n        }
\n    }<\/p>\n

    private void AddReplies(TreeNode node)
\n    {
\n        IQueryable<NewsCategory> cs = from c in ctx.NewsCategories
\n                                      where c.PreCate.ToString().Equals(node.Value)
\n                                      select c;
\n        foreach (var c in cs)
\n        {
\n            TreeNode replyNode = new TreeNode();
\n            replyNode.Text = c.CateName;
\n            replyNode.Value = c.CateId.ToString();
\n            node.ChildNodes.Add(replyNode);
\n            if (c.IsLeaf==false)
\n            {
\n                replyNode.Expanded = true;
\n                AddReplies(replyNode);
\n            }
\n           
\n        }
\n    }<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\u6570\u636e\u6a21\u578b\uff1aNewsCategory Cateid uniqueidentifier ID CateName N […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-222","post","type-post","status-publish","format-standard","hentry","category-all"],"views":1155,"_links":{"self":[{"href":"https:\/\/niuduer.sincebirth.space\/index.php?rest_route=\/wp\/v2\/posts\/222","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/niuduer.sincebirth.space\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/niuduer.sincebirth.space\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/niuduer.sincebirth.space\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/niuduer.sincebirth.space\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=222"}],"version-history":[{"count":0,"href":"https:\/\/niuduer.sincebirth.space\/index.php?rest_route=\/wp\/v2\/posts\/222\/revisions"}],"wp:attachment":[{"href":"https:\/\/niuduer.sincebirth.space\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=222"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/niuduer.sincebirth.space\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=222"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/niuduer.sincebirth.space\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=222"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}