G
grj1
Unregistered / Unconfirmed
GUEST, unregistred user!
[gold][/gold][black][/black][red][/red][][][]用SQL实现Treeview的先根递归排序
例如:
ID PARENTID 排序后ID PARENTID
0 -1 0 -1
1 -1 2 0
2 0 3 0
3 0 7 3
4 1 1 -1
5 1 4 1
6 -1 5 1
7 3 6 -1
例如:
ID PARENTID 排序后ID PARENTID
0 -1 0 -1
1 -1 2 0
2 0 3 0
3 0 7 3
4 1 1 -1
5 1 4 1
6 -1 5 1
7 3 6 -1