unit21.pas

该源码采用DELPHI语言,主要实现了对员工信息管理的功能.

unit Unit21;

interface

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

type
  TForm21 = class(TForm)
    Label1: TLabel;
    Edit1: TEdit;
    Button1: TButton;
    RadioGroup1: TRadioGroup;
    RadioButton1: TRadioButton;
    RadioButton2: TRadioButton;
    RadioButton3: TRadioButton;
    DBGrid1: TDBGrid;
    ADOConnection1: TADOConnection;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    ADOTable1: TADOTable;
    Button2: TButton;
    RadioButton4: TRadioButton;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form21: TForm21;

implementation

{$R *.dfm}

procedure TForm21.Button1Click(Sender: TObject);
var
a:boolean;
begin
a:=adotable1.Locate('员工号',trim(edit1.Text),[]);

 if  a  then
  begin
        adoquery1.Active:=false;
        adoquery1.Close;
        if radiobutton1.Checked then
        begin
        adoquery1.SQL.Text:='select * from 学习简历 where 员工号='+adotable1.FieldByName('员工号').AsString;
        end;
        if radiobutton2.Checked then
        begin
        adoquery1.SQL.Text:='select * from 工作简历 where 员工号='+adotable1.FieldByName('员工号').AsString;
        end;

       if radiobutton3.Checked then
        begin
        adoquery1.SQL.Text:='select * from 奖惩情况 where 员工号='+adotable1.FieldByName('员工号').AsString;
        end;
         if radiobutton4.Checked then
        begin
        adoquery1.SQL.Text:='select * from 培训情况 where 员工号='+adotable1.FieldByName('员工号').AsString;
        end;
        adoquery1.Open;
        adoquery1.Active:=true;
 end
 else
 adoquery1.Active:=false;

end;

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

end.