unit9.pas

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

unit Unit9;

interface

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

type
  TForm9 = class(TForm)
    DBGrid3: TDBGrid;
    ADOConnection1: TADOConnection;
    ADOTable1: TADOTable;
    ADOTable1DSDesigner: TIntegerField;
    ADOTable1DSDesigner2: TIntegerField;
    ADOTable1DSDesigner3: TStringField;
    ADOTable1DSDesigner4: TIntegerField;
    MainMenu1: TMainMenu;
    N1: TMenuItem;
    N4: TMenuItem;
    N5: TMenuItem;
    N2: TMenuItem;
    N6: TMenuItem;
    N3: TMenuItem;
    DataSource1: TDataSource;
    ADOTable2: TADOTable;
    DataSource2: TDataSource;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    GroupBox3: TGroupBox;
    Label10: TLabel;
    Label1: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    GroupBox1: TGroupBox;
    Label2: TLabel;
    DBEdit3: TDBEdit;
    procedure FormActivate(Sender: TObject);
    procedure N3Click(Sender: TObject);
    procedure N1Click(Sender: TObject);
    procedure N4Click(Sender: TObject);
    procedure N2Click(Sender: TObject);
    procedure N5Click(Sender: TObject);
    procedure N6Click(Sender: TObject);
  private
    procedure setstate(s:integer);
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form9: TForm9;

implementation

{$R *.dfm}

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

procedure TForm9.N3Click(Sender: TObject);
begin
   adotable1.Close;
   adotable2.Close;
   form9.Close;
end;

procedure TForm9.N1Click(Sender: TObject);
begin
   adotable1.Edit;
   setstate(1);
end;

procedure TForm9.N4Click(Sender: TObject);
begin
   adotable1.Post;
   adotable2.Filtered:=false;
   adotable2.Filter:='员工号='''+dbedit2.Text+'''';
   adotable1.Filtered:=true;
   adotable2.Edit;
   if strtoint(dbedit3.Text)>=85 then dbedit1.Text:=inttostr(strtoint(dbedit1.Text)+10);
   if (strtoint(dbedit3.Text)>=70) and (strtoint(dbedit3.Text)<85)  then dbedit1.Text:=inttostr(strtoint(dbedit1.Text)+5);
   if strtoint(dbedit3.Text)<55 then dbedit1.Text:=inttostr(strtoint(dbedit1.Text)-5);
   adotable2.Post;
   adotable2.Close;
   adotable2.Open;
   setstate(0);
end;

procedure TForm9.N2Click(Sender: TObject);
var a:string;
begin
   a:='';
   if edit1.Text<>'' then a:=a+'培训编号='''+edit1.Text+''' and ';
   if edit2.Text<>'' then a:=a+'员工号='''+edit2.Text+''' and ';
   a:=copy(a,1,length(a)-5);
   adotable1.Filtered:=false;
   adotable1.Filter:=a;
   adotable1.Filtered:=true;
end;

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

procedure TForm9.N5Click(Sender: TObject);
begin
   adotable1.Cancel;
end;

procedure TForm9.N6Click(Sender: TObject);
begin
   adotable1.Filtered:=false;
end;

end.