unit5.~pas

报名系统

unit Unit5;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DB, ADODB, Grids, DBGrids, ExtCtrls, StdCtrls;

type
  TForm5 = class(TForm)
    Edit1: TEdit;
    Button1: TButton;
    Label1: TLabel;
    Bevel1: TBevel;
    DBGrid1: TDBGrid;
    DataSource1: TDataSource;
    ADOTable1: TADOTable;
    Button2: TButton;
    Button3: TButton;
    Bevel2: TBevel;
    Button4: TButton;
    ADOConnection1: TADOConnection;
    procedure Button1Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure Button2Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure FormActivate(Sender: TObject);
    procedure Edit1KeyPress(Sender: TObject; var Key: Char);
    procedure Button4Click(Sender: TObject);
    procedure Edit1Change(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form5: TForm5;

implementation

uses Unit6;

{$R *.dfm}

procedure TForm5.Button1Click(Sender: TObject);
begin
if trim(edit1.text)='' then
begin
showmessage('请输入要查询学员的姓名！');
edit1.SetFocus;
end
else
begin
adotable1.Active:=false;
adotable1.Filter:='姓名='''+trim(edit1.Text)+'''';
adotable1.Filtered:=true;
adotable1.Active :=true;
if adotable1.RecordCount=0 then
begin
showmessage('没有找到相关记录,请确认输入的正确性！');
button2.Enabled:=false;
button4.Enabled:=false;
edit1.SetFocus;
end
else
begin
button1.Enabled:=false;
button2.Enabled:=true;
button4.Enabled:=true;
end;
end;
end;

procedure TForm5.Button3Click(Sender: TObject);
begin
adotable1.Filtered:=false;
adotable1.Active :=false;
edit1.Text:='';
button2.enabled:=true;
button4.enabled:=true;
form5.Close;
end;

procedure TForm5.FormClose(Sender: TObject; var Action: TCloseAction);
begin
adotable1.Filtered:=false;
end;

procedure TForm5.Button2Click(Sender: TObject);
begin
form6.show;
end;

procedure TForm5.FormShow(Sender: TObject);
begin
button1.Enabled:=true;
button2.Enabled:=false;
button4.Enabled:=false;
end;

procedure TForm5.FormActivate(Sender: TObject);
begin
edit1.SetFocus;
button1.Enabled:=true;
if adotable1.active=false then
begin
button2.Enabled:=false;
button4.Enabled:=false;
end;
end;

procedure TForm5.Edit1KeyPress(Sender: TObject; var Key: Char);
begin
if key=#13 then button1.Click;
end;

procedure TForm5.Button4Click(Sender: TObject);
begin
if (messagedlg('真的要删除此记录吗？',mtconfirmation,[mbyes,mbno],0)=mryes) then
begin
if (messagedlg('请再次确认要删除此记录？如果将不能恢复!',mtconfirmation,[mbyes,mbno],0)=mryes) then
adotable1.Delete;
button1.Enabled:=true;
end;
end;

procedure TForm5.Edit1Change(Sender: TObject);
begin
button1.Enabled:=true;
end;

end.