unit24.pas

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

unit Unit24;

interface

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

type
  TForm24 = class(TForm)
    Label1: TLabel;
    Edit1: TEdit;
    Label2: TLabel;
    Edit2: TEdit;
    Button1: TButton;
    DateTimePicker1: TDateTimePicker;
    Label3: TLabel;
    Label4: TLabel;
    Edit3: TEdit;
    Label5: TLabel;
    Memo1: TMemo;
    ADOConnection1: TADOConnection;
    ADOQuery1: TADOQuery;
    Button2: TButton;
    Button3: TButton;
    procedure Button2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
  private
    { Private declarations }
    procedure VisibleChanging; override;
  public
    { Public declarations }
  end;

var
  Form24: TForm24;

implementation
uses Unit15;
procedure TForm24.VisibleChanging;
begin
end;


{$R *.dfm}
procedure TForm24.Button1Click(Sender: TObject);
begin
form15.setEdit(edit1,edit2);
form15.WindowState:=wsNormal;
form15.Visible:=true;

end;

procedure TForm24.Button3Click(Sender: TObject);
begin
close
end;



procedure TForm24.Button2Click(Sender: TObject);
var
date1 : string;

begin
date1 := Datetostr(Datetimepicker1.Date);    //将时间类型转化为字符型

with ADOquery1 do
begin
   if Edit1.Text = '' then showmessage('员工号不能为空!')
   else
   begin
   SQL.Clear;
   SQL.Add('select * from 离职情况 where 员工号 = '''+Edit1.Text+'''');
   Open;
   if not isempty then
   begin
      showmessage(' 该员工已离职,请核对后重新输入!');
      Edit1.Text := '';
      edit2.Text:='';
      edit3.Text:='';
      memo1.Text:='';
   end
   else
   begin

      SQL.Clear;
      SQL.Add('select * from 离职情况');
      Open;
      Insert;
      FieldByName('员工号').AsString:=Edit1.Text;
      FieldByName('姓名').AsString:=Edit2.Text;
      FieldByName('离职去向').AsString:=edit3.Text;
      FieldByName('离职原因').AsString:=memo1.Text;
      FieldByName('离职日期').AsString:=date1;
      Post;
      showmessage('成功！');
      end;
end;
end;
end;

end.