grademanager.~pas

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

unit GradeManager;

interface

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

type
  TForm11 = class(TForm)
    DBGrid1: TDBGrid;
    Label1: TLabel;
    Edit1: TEdit;
    Label2: TLabel;
    Edit2: TEdit;
    Label3: TLabel;
    Edit3: TEdit;
    Label4: TLabel;
    MaskEdit1: TMaskEdit;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    Button5: TButton;
    Label5: TLabel;
    Edit4: TEdit;
    Label6: TLabel;
    Edit5: TEdit;
    Label7: TLabel;
    Edit6: TEdit;
    Label8: TLabel;
    Edit7: TEdit;
    Label9: TLabel;
    procedure Button1Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button2Click(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
  Form11: TForm11;

implementation

uses WelcomePicture, MainMenu;

{$R *.dfm}

procedure TForm11.Button1Click(Sender: TObject);
begin
with Form1.adoquery1 do
begin
   close;
   sql.Clear;
   sql.add('insert into Evaluation(员工编号,部门名称,总体考评,考评日期,奖励事由,奖励金额,处罚事由,处罚金额) values (:员工编号,:部门名称,:总体考评,:考评日期,:奖励事由,:奖励金额 ,:处罚事由,:处罚金额)');
   parameters[0].Value:=edit1.Text;
   parameters[1].Value:=edit2.Text;
   parameters[2].Value:=edit3.Text;
   parameters[3].Value:=maskedit1.Text;
   parameters[4].Value:=edit4.Text;
   parameters[5].Value:=edit5.Text;
   parameters[6].Value:=edit6.Text;
   parameters[7].Value:=edit7.Text;
   execsql;
   close;
   sql.Clear;
   sql.Add('select * from Evaluation');
   if form1.ADOQuery1.Active=false  then
       form1.ADOQuery1.Active:=true;
   open;
   messageBeep(0);
   end;
end;

procedure TForm11.Button3Click(Sender: TObject);
var
inputString:String;
begin
inputString:=inputbox('删除数据','请输入员工的编号','');
with Form1.adoquery1 do
begin
   close;
   sql.Clear;
   sql.add('delete from Evaluation where 员工编号=:员工编号');
    parameters[0].Value:=inputString;
   execsql;
   close;
   sql.Clear;
   sql.Add('select * from Evaluation');
   open;
   messageBeep(0);
   end;
   end;

procedure TForm11.Button2Click(Sender: TObject);
begin
showmessage('请在列表上修改');
dbgrid1.ReadOnly:=false;
end;

procedure TForm11.Button4Click(Sender: TObject);
begin
dbgrid1.ReadOnly:=true;
with Form1.adoquery1 do
begin
   close;
   sql.Clear;
   sql.Add('select * from Evaluation');
   open;
   messageBeep(0);
   end;
end;

procedure TForm11.Button5Click(Sender: TObject);
begin
form11.close;
end;

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

procedure TForm11.FormShow(Sender: TObject);
begin
form1.ADOQuery1.SQL.Clear;
dbgrid1.ReadOnly:=true;
with Form1.adoquery1 do
begin
   close;
   sql.Clear;
   sql.Add('select * from Evaluation');
   open;
   messageBeep(0);
   end;
end;

end.