var p:Ttreenode; b,e,i:integer; s:string;p:=TV.selected; b:=p.AbsoluteIndex; if p.getNextSibling=nil then b:=TV.items.count-1 else b:=p.getNextSibling.AbsoluteIndex-1; s:='''-1''' for i:=b+1 to e do s:=s+','''+TV.items[i].text+''''; s即所有子节点的列表
修改一点: var p:Ttreenode; b,e,i:integer; s:string;p:=TV.selected; b:=p.AbsoluteIndex; if p.getNextSibling=nil then e:=TV.items.count-1 else e:=p.getNextSibling.AbsoluteIndex-1; s:='''-1''' for i:=b+1 to e do s:=s+','''+TV.items[i].text+''''; s即所有子节点的列表
2、select * from 人员表 where 部门 in (上面得到的id列表)
--------------------------------------------------------------------------------
a部门
b部门
b1部门
c部门
我查询时就只能查到a部门下边的c部门里信息,b部门下的b1部门对应人员信息我就查不到了
p:Ttreenode;
b,e,i:integer;
s:string;p:=TV.selected;
b:=p.AbsoluteIndex;
if p.getNextSibling=nil then
b:=TV.items.count-1
else
b:=p.getNextSibling.AbsoluteIndex-1;
s:='''-1'''
for i:=b+1 to e do
s:=s+','''+TV.items[i].text+'''';
s即所有子节点的列表
var
p:Ttreenode;
b,e,i:integer;
s:string;p:=TV.selected;
b:=p.AbsoluteIndex;
if p.getNextSibling=nil then
e:=TV.items.count-1
else
e:=p.getNextSibling.AbsoluteIndex-1;
s:='''-1'''
for i:=b+1 to e do
s:=s+','''+TV.items[i].text+'''';
s即所有子节点的列表