unit1.pas

关于delphi的相关源码

unit Unit1;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Buttons, ComCtrls, DB, ADODB;

type
  TForm1 = class(TForm)
    Label1: TLabel;
    Edit1: TEdit;
    Label2: TLabel;
    Edit2: TEdit;
    Label3: TLabel;
    DateTimePicker1: TDateTimePicker;
    Label4: TLabel;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    BitBtn3: TBitBtn;
    memo1: TMemo;
    ADOQuery1: TADOQuery;
    BitBtn4: TBitBtn;
    BitBtn5: TBitBtn;
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
    procedure Edit1KeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure BitBtn2Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure BitBtn4Click(Sender: TObject);
    procedure BitBtn5Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
    procedure clear();
  end;

var
  Form1: TForm1;

implementation

uses Unit2, Unit3, Unit5;

{$R *.dfm}

procedure TForm1.BitBtn1Click(Sender: TObject);
begin
  if edit1.Text='' then
  begin
    showmessage('工号不能为空,请输入工号!');
    clear;
    exit;
  end;
  adoquery1.Close;
  adoquery1.SQL.Clear;
  adoquery1.SQL.Add('select * from yonghu where cardno='''+trim(edit1.Text)+'''');
  adoquery1.Open;
  if adoquery1.IsEmpty then
  begin
   showmessage('无此工号的用户,请重新输入!');
   clear;
   exit;
  end
  else
  begin
    adoquery1.Open;
    adoquery1.Close;
    adoquery1.SQL.Clear;
    adoquery1.SQL.Text:='insert into beiwang(cardno,riqi,backup) values('''+edit1.Text+''','''+datetostr(DateTimePicker1.date)+''','''+memo1.text+''')';
    adoquery1.ExecSQL;
    showmessage('添加记录成功!');
    clear;
  end;
end;

procedure TForm1.clear;
begin
  edit2.Clear;
  edit1.Clear;
  memo1.Clear;
  edit1.SetFocus;
end;

procedure TForm1.BitBtn3Click(Sender: TObject);
begin
  Form2:=TForm2.Create(application);
  Form2.Show;
  hide;
end;

procedure TForm1.Edit1KeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  if key=13 then
  begin
     adoquery1.Close;
     adoquery1.SQL.Clear;
     adoquery1.SQL.Add('select * from yonghu where cardno='''+trim(edit1.Text)+'''');
     adoquery1.Open;
     if adoquery1.IsEmpty then
     begin
       showmessage('无此工号的用户,请重新输入!');
       clear;
       exit;
     end
     else
     begin
       edit2.Text:=adoquery1.fieldbyname('name').AsString;
     end;
  end;
end;

procedure TForm1.BitBtn2Click(Sender: TObject);
begin
  close;
end;

procedure TForm1.FormCreate(Sender: TObject);
begin
  DateTimePicker1.Date:=now();
end;

procedure TForm1.BitBtn4Click(Sender: TObject);
begin
  Form3:=TForm3.Create(application);
  Form3.Show;
  Hide;
end;

procedure TForm1.BitBtn5Click(Sender: TObject);
begin
  frm_money:=Tfrm_money.Create(application);
  frm_money.Show;
  hide;
end;

end.