unit20.pas

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

unit Unit20;

interface

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

type
  TForm20 = class(TForm)
    ADOConnection1: TADOConnection;
    ADOQuery1: TADOQuery;
    Label1: TLabel;
    Edit1: TEdit;
    Label2: TLabel;
    Memo1: TMemo;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    Edit2: TEdit;
    Label3: TLabel;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form20: TForm20;

implementation

{$R *.dfm}

procedure TForm20.Button1Click(Sender: TObject);
begin
with ADOQuery1 do
  begin
  SQL.Clear;
  SQL.Add('select 员工号 as a1, 具体奖惩情况 as a2, 姓名 as a3 from 奖惩情况 where 员工号 =:s0 ');
  Parameters.ParamByName('s0').value := Edit1.Text;    //根据员工号查询信息
  Open;
  if ADOQuery1.Eof then
     begin
       showmessage('不存在该员工简历,请核对信息!');
       Edit1.Text:='';
       Exit;
     end
     else
     begin
     if FieldByName('a1').Value <>null then
     Edit1.Text :=fieldbyname('a1').Value;
     if FieldByName('a3').Value <>null then
     Edit2.Text :=fieldbyname('a3').Value;
     if FieldByName('a2').Value <>null then
     Memo1.Text :=fieldbyname('a2').Value;
end;
end;
end;

procedure TForm20.Button2Click(Sender: TObject);
begin
with ADOquery1 do
begin
   SQL.Clear;
   SQL.Add('delete from 奖惩情况 where 员工号='''+Edit1.Text+'''');
   ADOquery1.ExecSQL;
   Close;
   SQL.Clear;
   SQL.Add('select * from 奖惩情况');
   Open;
   Insert;
   FieldByName('员工号').AsString:=Edit1.Text;
   FieldByName('姓名').AsString:=Edit2.Text;
   FieldByName('具体奖惩情况').AsString:=Memo1.Text;
   Post;
   showmessage('成功修改！');
end;
end;

procedure TForm20.Button3Click(Sender: TObject);
begin
if messagedlg('要删除该奖惩情况吗？',mtconfirmation,[mbYes,mbNo],0)=mryes then
begin
with ADOquery1 do
begin
SQL.Clear;
SQL.Add('delete from 奖惩情况 where 员工号='''+Edit1.Text+'''');
ADOquery1.ExecSQL;
showmessage('成功删除!');
Edit1.Text:='';
Memo1.Text:='';
edit2.Text:='';
SQL.Clear;
end;
end;
end;

procedure TForm20.Button4Click(Sender: TObject);
begin
close;
end;

end.