employeestory.pas

本系统是一个基于delphi7环境开发的人事管理系统

unit EmployeeStory;

interface

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

type
  TForm7 = class(TForm)
    DBGrid1: TDBGrid;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    ComboBox1: TComboBox;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    Button5: TButton;
    Label5: TLabel;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormShow(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form7: TForm7;

implementation
   uses MainMenu, WelcomePicture;
{$R *.dfm}

procedure TForm7.Button1Click(Sender: TObject);
begin
with Form1.adoquery1 do
begin
   close;
   sql.Clear;
   sql.add('insert into experience(员工编号,职务,原单位名称,文化学历)values(:员工编号,:职务,:原单位名称,:文化学历) ');
   parameters[0].Value:=edit1.Text;
   parameters[1].Value:=edit2.Text;
   parameters[2].Value:=edit3.Text;
   parameters[3].Value:=combobox1.Text;
  // form1.ADOQuery1.Active:=true;
   execsql;
   close;
   sql.Clear;
   sql.Add('select * from experience');
   if form1.ADOQuery1.Active=false  then
       form1.ADOQuery1.Active:=true;
   open;
   end;
end;

procedure TForm7.Button2Click(Sender: TObject);
var
inputString:String;
begin
inputString:=inputbox('删除数据','请输入员工的编号','');
if inputString='' then exit;
with Form1.adoquery1 do
begin
   close;
   sql.Clear;
   sql.add('delete from Experience where 员工编号=:员工编号');
    parameters[0].Value:=inputString;
   execsql;
   close;
   sql.Clear;
   sql.Add('select * from experience');
   if form1.ADOQuery1.Active=false  then
       form1.ADOQuery1.Active:=true;
   open;
   end;
end;

procedure TForm7.Button3Click(Sender: TObject);
begin
with Form1.adoquery1 do
begin
   close;
   sql.Clear;
   sql.Add('select * from experience');
   if form1.ADOQuery1.Active=false  then
       form1.ADOQuery1.Active:=true;
   open;
   end;
showmessage('请在列表上修改');
dbgrid1.ReadOnly:=false;
end;

procedure TForm7.Button4Click(Sender: TObject);
begin
dbgrid1.ReadOnly:=true;
end;

procedure TForm7.Button5Click(Sender: TObject);
begin
form7.close;
end;

procedure TForm7.FormClose(Sender: TObject; var Action: TCloseAction);
begin
form1.ADOQuery1.SQL.Clear;
form3.Enabled:=true;
end;

procedure TForm7.FormShow(Sender: TObject);
begin
form1.ADOQuery1.SQL.Clear;
with Form1.adoquery1 do
begin
   close;
   sql.Clear;
   sql.Add('select * from experience');
   if form1.ADOQuery1.Active=false  then
       form1.ADOQuery1.Active:=true;
   open;
   end;
end;

end.