unit aaa;interfaceuses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, DB, DBTables, Grids, DBGrids, StdCtrls, ComCtrls;type
TForm1 = class(TForm)
TreeView1: TTreeView;
Button1: TButton;
Button2: TButton;
DBGrid1: TDBGrid;
DataSource1: TDataSource;
Query1: TQuery;
Table1: TTable;
Edit1: TEdit;
procedure Button1Click(Sender: TObject);
procedure Button2Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;var
Form1: TForm1;implementationuses main;{$R *.dfm}procedure TForm1.Button1Click(Sender: TObject);
vari,j:integer;mynode:ttreenode;beginwith treeview1 dofor I:= 0 to form1.treeview1.Items.Count-1 dobeginmynode:=items.Add(nil,form1.treeview1.Items[i].text);for j:=0 to form1.treeview1.Items[i].count-1 dobeginItems.AddChild(mynode,form1.treeview1.Items[j].text);end;end;end;
procedure TForm1.Button2Click(Sender: TObject);
vari,j,a1:integer;begintable1.First;table1.Active:=true;a1:= treeview1.Items.count-1;//Treeview1中的总结点数for i:=0 to a1 dobeginif i=0 then //如果是第一个结点begintable1.Insert;table1.FieldByName('cd').asstring:=edit1.text+treeview1.Items[i].Text;endelseif treeview1.Items[i].Index =0 then //如果是某个结点中的第一个子结点beginj:=i-1;table1.insert;table1.FieldByName('cd').asstring:=edit1.text+treeview1.Items[j].Text+'-'+treeview1.Items[i].Text;endelseif copy(treeview1.Items[i].Text,1,1)<>'&' then //如果不是父结点beginj:=i-treeview1.Items[i].Index-1;table1.insert;table1.FieldByName('cd').asstring:=edit1.text+treeview1.Items[j].Text+'-'+treeview1.Items[i].Text;endelseif copy(treeview1.Items[i].Text,1,1)='&' then//如果是父结点begintable1.insert;table1.FieldByName('cd').asstring:=edit1.text+treeview1.Items[i].Text;end;end;end; procedure TForm1.TreeView1click(Sender: TObject); //查找或修改某人在某项的//操作权限vars1:string;begin s1:=treeview1.Selected.Text; //选中结点with query1 dobeginclose;sql.clear;sql.Add('select * from qx where cd like:v_cd');parambyname('v_cd').asstring:=edit2.text+'%'+s1;prepare;open;end;end;end.
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, DB, DBTables, Grids, DBGrids, StdCtrls, ComCtrls;type
TForm1 = class(TForm)
TreeView1: TTreeView;
Button1: TButton;
Button2: TButton;
DBGrid1: TDBGrid;
DataSource1: TDataSource;
Query1: TQuery;
Table1: TTable;
Edit1: TEdit;
procedure Button1Click(Sender: TObject);
procedure Button2Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;var
Form1: TForm1;implementationuses main;{$R *.dfm}procedure TForm1.Button1Click(Sender: TObject);
vari,j:integer;mynode:ttreenode;beginwith treeview1 dofor I:= 0 to form1.treeview1.Items.Count-1 dobeginmynode:=items.Add(nil,form1.treeview1.Items[i].text);for j:=0 to form1.treeview1.Items[i].count-1 dobeginItems.AddChild(mynode,form1.treeview1.Items[j].text);end;end;end;
procedure TForm1.Button2Click(Sender: TObject);
vari,j,a1:integer;begintable1.First;table1.Active:=true;a1:= treeview1.Items.count-1;//Treeview1中的总结点数for i:=0 to a1 dobeginif i=0 then //如果是第一个结点begintable1.Insert;table1.FieldByName('cd').asstring:=edit1.text+treeview1.Items[i].Text;endelseif treeview1.Items[i].Index =0 then //如果是某个结点中的第一个子结点beginj:=i-1;table1.insert;table1.FieldByName('cd').asstring:=edit1.text+treeview1.Items[j].Text+'-'+treeview1.Items[i].Text;endelseif copy(treeview1.Items[i].Text,1,1)<>'&' then //如果不是父结点beginj:=i-treeview1.Items[i].Index-1;table1.insert;table1.FieldByName('cd').asstring:=edit1.text+treeview1.Items[j].Text+'-'+treeview1.Items[i].Text;endelseif copy(treeview1.Items[i].Text,1,1)='&' then//如果是父结点begintable1.insert;table1.FieldByName('cd').asstring:=edit1.text+treeview1.Items[i].Text;end;end;end; procedure TForm1.TreeView1click(Sender: TObject); //查找或修改某人在某项的//操作权限vars1:string;begin s1:=treeview1.Selected.Text; //选中结点with query1 dobeginclose;sql.clear;sql.Add('select * from qx where cd like:v_cd');parambyname('v_cd').asstring:=edit2.text+'%'+s1;prepare;open;end;end;end.
解决方案 »
- 请教汉邦监控软件自带的TCNVC.ocx使用方法
- 请教如何隐藏form的滚动条并且仍然保持其作用?
- indy初级问题
- 如何将SHOWMESSAGE()等对话框中的YES,NO等英语改成汉语文字?
- 急求:如何用TidHttp打开一个本地网页。
- 请教:为什么我装的Delphi7中没有QuickRep与FastReport控件?
- 如何打开word文档?老问题,我这用csdn搜索打不开文件?谢了
- 怎么使一个按钮具有闪烁效果????
- 请问高手们是怎样取服务器时间的?我都是用select GatDate()
- delphi的web数据库问题。help me!!!
- 一个关于临时表的储存过程的问题
- 哪位能告诉我 delphi 中的各种函数?最好比较全一些,特别是关于字符串的函数
procedure TreeView1click(Sender: TObject);
还有就是
你的SQL处错了sql.Add('select * from qx where cd like:v_cd');
应该在LIKE后加上一个空格,这样就行了