with main_form.print_list.Items.Add do begin caption:=self.spdm.Caption; SubItems.add(self.spmc.caption); //添加后面数据 subItems.Add(self.spdj.Text); SubItems.add(self.spsl.text); Data:= Pointer(spdm.caption); end;
procedure TfrmDemoTree.InitListView; //初始化ListView var name,strSQL:string; lvItem:TListItem; Tempqry:TQuery; begin Tempqry := TQuery.Create(self); try lvDemoTree.Items.Clear; //清空 name := tvDemoTree.Selected.Text; strSQL := ' select id ' + ' from Tcity ' + ' where name='''+name+''''; ExecQry(strSQL,dmDemoTree.qryLV,true); if not dmDemoTree.qryLV.Eof then begin strSQL := ' select * ' + ' from Tcity where parentid=' + inttostr(dmDemoTree.qryLV.fieldbyname('id').asinteger); ExecQry(strSQL,dmDemoTree.qryLV,true); while not dmDemoTree.qryLV.Eof do begin lvItem := lvDemoTree.Items.Add; lvItem.Caption := inttostr(dmDemoTree.qryLV.fieldbyname('id').AsInteger); lvItem.SubItems.Add(dmDemoTree.qryLV.fieldbyname('name').AsString); strSQL := ' select name ' + ' from Tcity ' + ' where id=' + inttostr(dmDemoTree.qryLV.fieldbyname('parentid').AsInteger); ExecQry(strSQL,Tempqry,true); lvItem.SubItems.Add(Tempqry.fieldbyname('name').AsString); dmDemoTree.qryLV.Next; end; end; finally Tempqry.Free; end; end;
ListItem->Caption='一级'
ListView->Items->Item[0]->SubItems->Strings[0]='10';
ListView->Items->Item[0]->SubItems->Strings[1]= '';
.....
begin
caption:=self.spdm.Caption;
SubItems.add(self.spmc.caption); //添加后面数据
subItems.Add(self.spdj.Text);
SubItems.add(self.spsl.text);
Data:= Pointer(spdm.caption);
end;
//初始化ListView
var
name,strSQL:string;
lvItem:TListItem;
Tempqry:TQuery;
begin
Tempqry := TQuery.Create(self);
try
lvDemoTree.Items.Clear; //清空
name := tvDemoTree.Selected.Text;
strSQL := ' select id '
+ ' from Tcity '
+ ' where name='''+name+'''';
ExecQry(strSQL,dmDemoTree.qryLV,true);
if not dmDemoTree.qryLV.Eof then
begin
strSQL := ' select * '
+ ' from Tcity where parentid='
+ inttostr(dmDemoTree.qryLV.fieldbyname('id').asinteger);
ExecQry(strSQL,dmDemoTree.qryLV,true);
while not dmDemoTree.qryLV.Eof do
begin
lvItem := lvDemoTree.Items.Add;
lvItem.Caption := inttostr(dmDemoTree.qryLV.fieldbyname('id').AsInteger);
lvItem.SubItems.Add(dmDemoTree.qryLV.fieldbyname('name').AsString);
strSQL := ' select name '
+ ' from Tcity '
+ ' where id='
+ inttostr(dmDemoTree.qryLV.fieldbyname('parentid').AsInteger);
ExecQry(strSQL,Tempqry,true);
lvItem.SubItems.Add(Tempqry.fieldbyname('name').AsString);
dmDemoTree.qryLV.Next;
end;
end;
finally
Tempqry.Free;
end;
end;