.NET中C#实现CS架构下的TREEVIEW只需要输入表名,父ID,节点ID,节点名就可以得到树型结构.- NET center C# realizes under CS overhead construction TREEVIEW
only to need to input table, father ID, pitch point ID, the festival
mentions by name may obtain the tree structure
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001377s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.081666s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001100s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001396s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001957s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003622s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000993s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.004042s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015174s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001225s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 92904 [ RunTime:0.015444s ]