16,748
社区成员
发帖
与我相关
我的任务
分享
public
strIDs:string;//全局变量
function TForm1.GetAllID(intRootID:integer):string;
var
qyTemp: TADOQuery;
strSql:string;
intID:integer;
strtmp:string;
begin
if strIDs='' then
begin
strIDs:=IntToStr(intRootID);
end
else
begin
strIDs:=strIDs+','+IntToStr(intRootID);
end;
qyTemp := TADOQuery.Create(nil);
qyTemp.Connection := Con1;
strsql:='select id from tablex where parentid='+inttostr(intRootID);
qyTemp.Close;
qyTemp.SQL.Text:=strSql;
qyTemp.Open;
if qyTemp.RecordCount=0 then
begin
strtmp:=''
end
else
begin
qyTemp.First;
while not qyTemp.Eof do
begin
intId:=qyTemp.Fieldbyname('id').AsInteger;
GetAllID(intID);
qyTemp.Next;
end;
end;
Result:=strtmp;
end;
function TForm1.GetAllID(intParentID:integer):string;
var
qyTemp: TADOQuery;
strSql:string;
intID:integer;
begin
qyTemp := TADOQuery.Create(nil);
qyTemp.Connection := Con1;
strsql:='select id from tablex where parentid='+inttostr(intParentID);
qyTemp.Close;
qyTemp.SQL.Text:=strSql;
qyTemp.Open;
result:=IntToStr(intParentID);
qyTemp.First;
while not qyTemp.Eof do
begin
intId:=qyTemp.Fieldbyname('id').AsInteger;
result:=result+','+GetAllID(intID);
qyTemp.Next;
end;
end;
function TForm1.GetAllID(intParentID:integer):string;
var
qyTemp: TADOQuery;
strSql:string;
intID:integer;
strtmp:string;
begin
qyTemp := TADOQuery.Create(nil);
qyTemp.Connection := Con1;
strsql:='select id from tablex where parentid='+inttostr(intParentID);
qyTemp.Close;
qyTemp.SQL.Text:=strSql;
qyTemp.Open;
strtmp:=IntToStr(intParentID);
qyTemp.First;
while not qyTemp.Eof do
begin
intId:=qyTemp.Fieldbyname('id').AsInteger;
strtmp:=strtmp+','+GetAllID(intID);
qyTemp.Next;
end;
result:=strtmp;
end;
result:=result+','+GetAllID(intID);