unit13.pas

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

unit Unit13;

interface

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

type
  TForm13 = class(TForm)
    DBGrid1: TDBGrid;
    ADOConnection1: TADOConnection;
    ADOTable1: TADOTable;
    ADOTable1DSDesigner: TStringField;
    ADOTable1Field: TStringField;
    ADOTable1DSDesigner2: TStringField;
    ADOTable1DSDesigner3: TIntegerField;
    ADOTable1DSDesigner4: TIntegerField;
    ADOTable1Field2: TIntegerField;
    ADOTable1DSDesigner5: TIntegerField;
    ADOTable1DSDesigner6: TIntegerField;
    ADOTable1DSDesigner7: TIntegerField;
    ADOTable1DSDesigner8: TIntegerField;
    ADOTable1DSDesigner9: TIntegerField;
    DataSource1: TDataSource;
    MainMenu1: TMainMenu;
    N1: TMenuItem;
    N2: TMenuItem;
    N3: TMenuItem;
    N4: TMenuItem;
    N6: TMenuItem;
    N5: TMenuItem;
    ADOTable2: TADOTable;
    ADOTable2DSDesigner: TStringField;
    ADOTable2DSDesigner2: TStringField;
    ADOTable2DSDesigner3: TStringField;
    ADOTable2DSDesigner4: TStringField;
    ADOTable2DSDesigner5: TStringField;
    ADOTable2DSDesigner6: TStringField;
    ADOTable2DSDesigner7: TStringField;
    ADOTable2DSDesigner8: 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;
    DataSource2: TDataSource;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    ADOTable3: TADOTable;
    ADOTable3DSDesigner: TStringField;
    ADOTable3DSDesigner2: TStringField;
    ADOTable3DSDesigner3: TIntegerField;
    ADOTable3DSDesigner4: TIntegerField;
    ADOTable3DSDesigner5: TIntegerField;
    ADOTable3DSDesigner6: TIntegerField;
    ADOTable3DSDesigner7: TIntegerField;
    ADOTable3DSDesigner8: TIntegerField;
    DataSource3: TDataSource;
    DBEdit8: TDBEdit;
    DBEdit9: TDBEdit;
    DBEdit7: TDBEdit;
    DBEdit6: TDBEdit;
    GroupBox3: TGroupBox;
    Label10: TLabel;
    Label3: TLabel;
    Label1: TLabel;
    Edit1: TEdit;
    Edit3: TEdit;
    Edit2: TEdit;
    GroupBox1: TGroupBox;
    Label2: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit5: TDBEdit;
    procedure FormActivate(Sender: TObject);
    procedure N1Click(Sender: TObject);
    procedure N2Click(Sender: TObject);
    procedure N4Click(Sender: TObject);
    procedure N3Click(Sender: TObject);
    procedure N6Click(Sender: TObject);
    procedure N5Click(Sender: TObject);
  private
    procedure setstate(s:integer);
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form13: TForm13;

implementation

{$R *.dfm}

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

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

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

procedure TForm13.N2Click(Sender: TObject);
var s:integer;
begin
   dbedit6.Text:=inttostr(strtoint(dbedit3.Text)+ strtoint(dbedit1.Text)+strtoint(dbedit2.Text));
   s:=strtoint(dbedit6.Text )-1600;
   if s<=0 then dbedit7.Text:=floattostr(0.0);
   if (s>0) and (s<=500) then  dbedit7.Text:=inttostr(trunc(s*0.05));
   if (s>500) and  (s<=2000) then  dbedit7.Text:=inttostr(trunc(s*0.1-25));
   if (s>2000) and (s<=5000) then  dbedit7.Text:=inttostr(trunc(s*0.15-125));
   if (s>5000) and (s<=20000) then  dbedit7.Text:=inttostr(trunc(s*0.2-375));
   if (s>20000) and (s<=40000) then dbedit7.Text:=inttostr(trunc(s*0.25-1375));
   if (s>40000) and (s<=60000) then dbedit7.Text:=inttostr(trunc(s*0.3-3375));
   if (s>60000) and (s<=80000) then dbedit7.Text:=inttostr(trunc(s*0.35-6375));
   if (s>80000) and (s<=100000) then dbedit7.Text:=inttostr(trunc(s*0.4-10375));
   if s>100000 then dbedit7.Text:=inttostr(trunc(s*0.45-15375));
   if strtoint(dbedit4.Text)>=60 then dbedit8.Text:=inttostr(-trunc(s*0.1));
   if (strtoint(dbedit4.Text)<60) and (strtoint(dbedit4.Text)>=50) then dbedit8.Text:='0';
   if (strtoint(dbedit4.Text)<50) and (strtoint(dbedit4.Text)>=30) then dbedit8.Text:=inttostr(trunc(s*0.1));
   if (strtoint(dbedit4.Text)<30) and (strtoint(dbedit4.Text)>=10) then dbedit8.Text:=inttostr(trunc(s*0.3));
   if strtoint(dbedit4.Text)<10 then dbedit8.Text:=inttostr(trunc(s*0.5));
   dbedit9.Text:=inttostr(strtoint(dbedit6.Text)- strtoint(dbedit7.Text)-strtoint(dbedit8.Text));
   adotable1.Post;
   setstate(0);
end;

procedure TForm13.N4Click(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 ';
   if edit3.Text<>'' then a:=a+'实发<'+edit3.Text+' and ';
   a:=copy(a,1,length(a)-5);
   adotable1.Filtered:=false;
   adotable1.Filter:=a;
   adotable1.Filtered:=true;
   edit1.Text:='';
   edit2.Text:='';
   edit3.Text:='';
end;

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

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

procedure TForm13.N5Click(Sender: TObject);
begin
   adotable1.Close;
   adotable2.Close;
   adotable3.Close;
   form13.Close;
end;

end.