unit6.pas

一个很简单的人事管理系统

unit Unit6;

interface

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

type
  TchaxunForm = class(TForm)
    GroupBox1: TGroupBox;
    Edit1: TEdit;
    Label1: TLabel;
    Button1: TButton;
    Button2: TButton;
    DBGrid1: TDBGrid;
    DBNavigator1: TDBNavigator;
    DataSource1: TDataSource;
    ADOQuery1: TADOQuery;
    ADOConnection1: TADOConnection;
    Button3: TButton;
    GroupBox2: TGroupBox;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    Label13: TLabel;
    Label14: TLabel;
    Label15: TLabel;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    Edit6: TEdit;
    Edit7: TEdit;
    Edit8: TEdit;
    Edit9: TEdit;
    Edit10: TEdit;
    Edit11: TEdit;
    Edit12: TEdit;
    Edit13: TEdit;
    Edit14: TEdit;
    Edit15: TEdit;
    Button4: TButton;
    Timer1: TTimer;
    procedure FormCreate(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure FormActivate(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Edit1KeyPress(Sender: TObject; var Key: Char);
    procedure DBNavigator1Click(Sender: TObject; Button: TNavigateBtn);
    procedure Timer1Timer(Sender: TObject);
    procedure Button4Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  chaxunForm: TchaxunForm;

implementation

uses Unit5;

{$R *.dfm}

procedure TchaxunForm.FormCreate(Sender: TObject);
begin
  BorderIcons:=[];
  
end;

procedure TchaxunForm.Button3Click(Sender: TObject);
begin
edit1.Text:='';
edit2.Text:='';
edit3.Text:='';
edit4.Text:='';
edit5.Text:='';
edit6.Text:='';
edit7.Text:='';
edit8.Text:='';
edit9.Text:='';
edit10.Text:='';
edit11.Text:='';
edit12.Text:='';
edit13.Text:='';
edit14.Text:='';
edit15.Text:='';
 adoquery1.Close;


close;
end;

procedure TchaxunForm.FormActivate(Sender: TObject);
begin
edit1.SetFocus;
button2.OnClick(self);
end;

procedure TchaxunForm.Button2Click(Sender: TObject);
begin
edit1.Text:='';
adoquery1.SQL.Text:='select * from Info';
adoquery1.Active:=true;
if adoquery1.Recordset.RecordCount=0 then//
begin
Application.MessageBox('数据库中无数据!','提示信息',mb_defbutton1+mb_iconexclamation+mb_ok);

end
else
begin
Edit2.text:=adoquery1.fieldbyname('zhigongnum').asstring;
Edit3.text:=adoquery1.fieldbyname('Name').asstring;
Edit4.text:=adoquery1.fieldbyname('Sex').asstring;
Edit5.text:=adoquery1.fieldbyname('Birthday').asstring;
Edit6.text:=adoquery1.fieldbyname('ID').asstring;
Edit7.text:=adoquery1.fieldbyname('Phone').asstring;
Edit8.text:=adoquery1.fieldbyname('Address').asstring;
Edit9.text:=adoquery1.fieldbyname('Salary').asstring;
Edit10.text:=adoquery1.fieldbyname('Unit').asstring;
Edit11.text:=adoquery1.fieldbyname('Duty').asstring;
Edit12.text:=adoquery1.fieldbyname('Speciality').asstring;
Edit13.text:=adoquery1.fieldbyname('Notee').asstring;
Edit14.text:=adoquery1.fieldbyname('Operator').asstring;
Edit15.text:=adoquery1.fieldbyname('Stamp').asstring;
end;

end;

procedure TchaxunForm.Button1Click(Sender: TObject);
begin
       adoquery1.SQL.Text:='select * from Info where zhigongnum=:aa';
       adoquery1.Parameters.ParamByName('aa').Value:=edit1.Text;
       adoquery1.Active:=true;
      if adoquery1.Recordset.RecordCount=0 then//
       begin
       Application.MessageBox('数据库中无此数据!','提示信息',mb_defbutton1+mb_iconexclamation+mb_ok);
       edit1.Text:='';
       Edit1.SetFocus;
       edit2.Text:='';
edit3.Text:='';
edit4.Text:='';
edit5.Text:='';
edit6.Text:='';
edit7.Text:='';
edit8.Text:='';
edit9.Text:='';
edit10.Text:='';
edit11.Text:='';
edit12.Text:='';
edit13.Text:='';
edit14.Text:='';
edit15.Text:='';
       exit;
       end
       else
       begin
Edit2.text:=adoquery1.fieldbyname('zhigongnum').asstring;
Edit3.text:=adoquery1.fieldbyname('Name').asstring;
Edit4.text:=adoquery1.fieldbyname('Sex').asstring;
Edit5.text:=adoquery1.fieldbyname('Birthday').asstring;
Edit6.text:=adoquery1.fieldbyname('ID').asstring;
Edit7.text:=adoquery1.fieldbyname('Phone').asstring;
Edit8.text:=adoquery1.fieldbyname('Address').asstring;
Edit9.text:=adoquery1.fieldbyname('Salary').asstring;
Edit10.text:=adoquery1.fieldbyname('Unit').asstring;
Edit11.text:=adoquery1.fieldbyname('Duty').asstring;
Edit12.text:=adoquery1.fieldbyname('Speciality').asstring;
Edit13.text:=adoquery1.fieldbyname('Notee').asstring;
Edit14.text:=adoquery1.fieldbyname('Operator').asstring;
Edit15.text:=adoquery1.fieldbyname('Stamp').asstring;

       
       end;

end;

procedure TchaxunForm.Edit1KeyPress(Sender: TObject; var Key: Char);
begin
  if key=#13 then button1Click(self);

  if length(edit1.Text)>5 then
     begin
      key:=chr(0);
       Application.MessageBox('您输入的员工号大于了6个字符','提示错误',mb_ok);
      edit1.Text:='';
     end


end;

procedure TchaxunForm.DBNavigator1Click(Sender: TObject;
  Button: TNavigateBtn);
begin
Edit2.text:=adoquery1.fieldbyname('zhigongnum').asstring;
Edit3.text:=adoquery1.fieldbyname('Name').asstring;
Edit4.text:=adoquery1.fieldbyname('Sex').asstring;
Edit5.text:=adoquery1.fieldbyname('Birthday').asstring;
Edit6.text:=adoquery1.fieldbyname('ID').asstring;
Edit7.text:=adoquery1.fieldbyname('Phone').asstring;
Edit8.text:=adoquery1.fieldbyname('Address').asstring;
Edit9.text:=adoquery1.fieldbyname('Salary').asstring;
Edit10.text:=adoquery1.fieldbyname('Unit').asstring;
Edit11.text:=adoquery1.fieldbyname('Duty').asstring;
Edit12.text:=adoquery1.fieldbyname('Speciality').asstring;
Edit13.text:=adoquery1.fieldbyname('Notee').asstring;
Edit14.text:=adoquery1.fieldbyname('Operator').asstring;
Edit15.text:=adoquery1.fieldbyname('Stamp').asstring;
end;

procedure TchaxunForm.Timer1Timer(Sender: TObject);
begin
if edit2.Text='' then
 button4.Enabled:=false
 else
 button4.Enabled:=true;

end;

procedure TchaxunForm.Button4Click(Sender: TObject);
begin

renshiform.Edit1.Text:=edit2.Text;

renshiform.ShowModal();
end;

end.