unit3.pas

软件课程设计

unit Unit3;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls;

type
  TForm3 = class(TForm)
    Edit1: TEdit;
    Label1: TLabel;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    procedure Button2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form3: TForm3;

implementation

uses Unit4, Unit5, Unit1;

{$R *.dfm}

procedure TForm3.Button2Click(Sender: TObject);
begin
close;
end;

procedure TForm3.Button1Click(Sender: TObject);
begin
Form1.ADOQuery1.Close;
Form1.ADOQuery1.SQL.Clear;
Form1.ADOQuery1.SQL.Add('select * from 会员信息 where id='''+Edit1.Text+''' ');
Form1.ADOQuery1.Open;
form4.Edit1.Text:=Form1.ADOQuery1.FieldValues['姓名'];
form4.Edit3.Text:=Form1.ADOQuery1.FieldValues['生日'];
form4.Edit2.Text:=Form1.ADOQuery1.FieldValues['id'];
form4.Edit6.Text:=Form1.ADOQuery1.FieldValues['性别'];
form4.Edit5.Text:=Form1.ADOQuery1.FieldValues['单位'];
form4.Edit4.Text:=Form1.ADOQuery1.FieldValues['证件号'];
form4.Edit7.Text:=Form1.ADOQuery1.FieldValues['电话'];
form4.Edit8.Text:=Form1.ADOQuery1.FieldValues['注册时间'];
form4.Edit9.Text:=Form1.ADOQuery1.FieldValues['光临次数'];
if Form1.ADOQuery1.FieldValues['是否vip']=0 then
begin
   form4.checkbox1.Checked:=false;
   end
   else if  Form1.ADOQuery1.FieldValues['是否vip']=1 then
   begin
   form4.checkbox1.Checked:=true;
   end ;
if  Form1.ADOQuery1.FieldValues['是否服务中']=0 then
begin
   form4.checkbox2.Checked:=false;
   end
   else if  Form1.ADOQuery1.FieldValues['是否服务中']=1 then
   begin
   form4.checkbox2.Checked:=true;
   end ;


edit1.Text:='';
form4.showmodal;
end;

procedure TForm3.Button3Click(Sender: TObject);
begin
form5.showmodal;
form5.DBGrid1.Visible:=false;
end;

end.