unit11.pas

用delphi和SQLServer开发的人力资源管理信息系统

unit Unit11;

interface

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

type
  TForm11 = class(TForm)
    ADOConnection1: TADOConnection;
    ADOTable1: TADOTable;
    ADOTable1DSDesigner: TIntegerField;
    ADOTable1DSDesigner2: TStringField;
    ADOTable1DSDesigner3: TStringField;
    ADOTable1DSDesigner4: TStringField;
    ADOTable1DSDesigner5: TStringField;
    ADOTable1DSDesigner6: TStringField;
    ADOTable1DSDesigner7: TStringField;
    ADOTable1DSDesigner8: TStringField;
    ADOTable1DSDesigner9: TStringField;
    ADOTable1Field: TStringField;
    DBGrid1: TDBGrid;
    DataSource1: TDataSource;
    MainMenu1: TMainMenu;
    N1: TMenuItem;
    N2: TMenuItem;
    N3: TMenuItem;
    N4: TMenuItem;
    N5: TMenuItem;
    N7: TMenuItem;
    ADOTable3: TADOTable;
    StringField1: TStringField;
    StringField2: TStringField;
    StringField3: TStringField;
    StringField4: TStringField;
    StringField5: TStringField;
    StringField6: TStringField;
    StringField7: TStringField;
    StringField8: TStringField;
    ADOTable2DSDesigner9: TStringField;
    ADOTable2DSDesigner10: TStringField;
    ADOTable2DSDesigner11: TStringField;
    ADOTable2DSDesigner12: TStringField;
    ADOTable2DSDesigner13: TStringField;
    ADOTable2DSDesigner14: TStringField;
    ADOTable2DSDesigner15: TStringField;
    ADOTable2DSDesigner16: TStringField;
    ADOTable2DSDesigner17: TStringField;
    ADOTable2DSDesigner18: TStringField;
    ADOTable2DSDesigner19: TStringField;
    ADOTable2DSDesigner20: TStringField;
    ADOTable2DSDesigner21: TStringField;
    ADOTable2DSDesigner22: TStringField;
    ADOTable2DSDesigner23: TStringField;
    ADOTable2DSDesigner24: TStringField;
    ADOTable2DSDesigner25: TStringField;
    ADOTable2: TADOTable;
    ADOTable2DSDesigner: TStringField;
    ADOTable2DSDesigner2: TStringField;
    ADOTable2DSDesigner3: TIntegerField;
    ADOTable2DSDesigner4: TIntegerField;
    ADOTable2DSDesigner5: TIntegerField;
    ADOTable2DSDesigner6: TIntegerField;
    ADOTable2DSDesigner7: TIntegerField;
    ADOTable2DSDesigner8: TIntegerField;
    DataSource3: TDataSource;
    DataSource2: TDataSource;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    procedure N1Click(Sender: TObject);
    procedure N2Click(Sender: TObject);
    procedure FormActivate(Sender: TObject);
    procedure N3Click(Sender: TObject);
    procedure N4Click(Sender: TObject);
    procedure N5Click(Sender: TObject);
    procedure N7Click(Sender: TObject);
  private
    procedure setstate(s:integer);
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form11: TForm11;

implementation

{$R *.dfm}

procedure TForm11.N1Click(Sender: TObject);
begin
   adotable1.Append;
   setstate(1);
end;

procedure TForm11.N2Click(Sender: TObject);
begin
   adotable1.Post;
   setstate(0);
   adotable2.Filtered:=false;
   adotable2.Filter:='员工号='''+dbedit1.Text+'''';
   adotable2.Filtered:=true;
   adotable2.Edit;
   if dbedit3.Text='奖励' then
      dbedit2.Text:=inttostr(strtoint(dbedit2.Text)+10);
   if dbedit3.Text='惩罚' then
      dbedit2.Text:=inttostr(strtoint(dbedit2.Text)-10);
   adotable2.Post;
   adotable2.Close;
   adotable2.Open;
end;

procedure TForm11.FormActivate(Sender: TObject);
begin
   adotable1.Open;
   adotable2.Open;
   setstate(0);
end;

procedure TForm11.N3Click(Sender: TObject);
begin
   adotable1.Cancel;
   setstate(0);
end;

procedure TForm11.N4Click(Sender: TObject);
begin
   adotable1.Delete;
   setstate(0);
end;

procedure TForm11.N5Click(Sender: TObject);
begin
   adotable1.Edit;
   setstate(1);
end;

procedure TForm11.N7Click(Sender: TObject);
begin
   adotable1.Close;
   adotable2.Close;
   form11.Close;
end;

procedure Tform11.setstate(s:integer);
begin
   if s=0 then
     begin
         N1.Enabled:=true;
         N2.Enabled:=false;
         N3.Enabled:=false;
         N4.Enabled:=true;
         N5.Enabled:=true;
         N7.Enabled:=true;
     end
   else
     begin
         N1.Enabled:=false;
         N2.Enabled:=true;
         N3.Enabled:=true;
         N4.Enabled:=false;
         N5.Enabled:=false;
         N7.Enabled:=false;
     end;
end;

end.