📄 unit1.pas
字号:
unit Unit1;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, DB, ADODB, ComCtrls, DBtreeView, StdCtrls, ExtCtrls, DBCtrls,
Grids, DBGrids, Mask;
type
TForm1 = class(TForm)
ADOQuery1: TADOQuery;
DataSource1: TDataSource;
Button1: TButton;
Button2: TButton;
Edit2: TEdit;
Label1: TLabel;
DBtreeView1: TDBtreeView;
cb: TCheckBox;
Button3: TButton;
Button4: TButton;
Button5: TButton;
DBGrid1: TDBGrid;
DBEdit1: TDBEdit;
procedure FormCreate(Sender: TObject);
procedure Button1Click(Sender: TObject);
procedure Button2Click(Sender: TObject);
procedure Button3Click(Sender: TObject);
procedure Button5Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;
var
Form1: TForm1;
implementation
{$R *.dfm}
procedure TForm1.FormCreate(Sender: TObject);
begin
adoquery1.Active:=true;
dbtreeview1.loadData;
end;
procedure TForm1.Button1Click(Sender: TObject);
begin
cb.Checked:=dbtreeview1.IsNodeChecked(dbtreeview1.Selected)
end;
procedure TForm1.Button2Click(Sender: TObject);
begin
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('insert into s_menu(dm,mc,userdm) values(:dm,:mc,99)');
adoquery1.Parameters.ParamValues['dm']:=inttostr(strtoint(dbtreeview1.GetTreeDM(dbtreeview1.Selected))+1) ;
adoquery1.Parameters.ParamValues['mc']:=edit2.Text;
adoquery1.ExecSQL;
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select * from s_menu order by dm ');
adoquery1.Open ;
dbtreeview1.loadData;
end;
procedure TForm1.Button3Click(Sender: TObject);
begin
dbtreeview1.SetNodeChecked(dbtreeview1.Selected,true);
end;
procedure TForm1.Button5Click(Sender: TObject);
begin
//adoquery1.Open ;
showmessage(ADOQuery1.FieldValues['mc']);
end;
end.
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -