unit8.pas

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

unit Unit8;

interface

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

type
  TForm8 = class(TForm)
    GroupBox1: TGroupBox;
    DBGrid1: TDBGrid;
    ADOConnection1: TADOConnection;
    ADOTable1: TADOTable;
    ADOTable1DSDesigner: TIntegerField;
    ADOTable1DSDesigner2: TStringField;
    ADOTable1DSDesigner3: TStringField;
    ADOTable1DSDesigner4: TStringField;
    ADOTable1DSDesigner5: TStringField;
    ADOTable1DSDesigner6: TStringField;
    ADOTable1DSDesigner7: TStringField;
    DataSource1: TDataSource;
    MainMenu1: TMainMenu;
    N1: TMenuItem;
    N2: TMenuItem;
    N3: TMenuItem;
    N4: TMenuItem;
    N5: TMenuItem;
    N6: TMenuItem;
    N7: TMenuItem;
    N8: TMenuItem;
    ADOTable2: TADOTable;
    ADOTable2DSDesigner: TStringField;
    ADOTable2DSDesigner2: TStringField;
    ADOTable2DSDesigner3: TStringField;
    ADOTable2DSDesigner4: TStringField;
    ADOTable2DSDesigner17: TStringField;
    ADOTable2DSDesigner19: TStringField;
    ADOTable2DSDesigner20: TStringField;
    ADOTable2DSDesigner21: TStringField;
    ADOTable2DSDesigner26: TStringField;
    DataSource2: TDataSource;
    ADOTable3: TADOTable;
    ADOTable3DSDesigner: TIntegerField;
    ADOTable3DSDesigner2: TIntegerField;
    ADOTable3DSDesigner3: TStringField;
    ADOTable3DSDesigner4: TIntegerField;
    DataSource3: TDataSource;
    GroupBox3: TGroupBox;
    Label10: TLabel;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    GroupBox4: TGroupBox;
    DBGrid3: TDBGrid;
    DBEdit9: TDBEdit;
    Button1: TButton;
    GroupBox2: TGroupBox;
    DBGrid2: TDBGrid;
    DBEdit10: TDBEdit;
    DBEdit7: TDBEdit;
    DBEdit8: TDBEdit;
    DBEdit6: TDBEdit;
    DBEdit5: TDBEdit;
    procedure FormActivate(Sender: TObject);
    procedure N1Click(Sender: TObject);
    procedure N2Click(Sender: TObject);
    procedure N3Click(Sender: TObject);
    procedure N4Click(Sender: TObject);
    procedure N5Click(Sender: TObject);
    procedure N6Click(Sender: TObject);
    procedure N8Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure DBGrid1CellClick(Column: TColumn);
    procedure N7Click(Sender: TObject);
  private
    procedure setstate(s:integer);
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form8: TForm8;

implementation

{$R *.dfm}

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

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

procedure TForm8.N2Click(Sender: TObject);
begin
   adotable1.Post;
   setstate(0);
end;

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

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

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

procedure Tform8.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;
         N7.Enabled:=true;
         N8.Enabled:=true;
     end
   else
   if s=1 then
     begin
         N1.Enabled:=false;
         N2.Enabled:=true;
         N3.Enabled:=true;
         N4.Enabled:=false;
         N5.Enabled:=false;
         N6.Enabled:=false;
         N7.Enabled:=false;
         N8.Enabled:=false;
     end;
end;

procedure TForm8.N6Click(Sender: TObject);
var a:string;
    b:string;
    c:string;
    d:integer;
    e:integer;
    f:integer;
    g:integer;
begin
   a:='';
   b:=dbedit3.Text;
   c:=dbedit4.Text;
   g:=pos('新人培训',b);
   d:=pos('部门负责人培训',c);
   e:=pos('主管培训',c);
   f:=pos('职员培训',c);
   if dbedit2.Text<>'' then a:=a+'部门号='''+dbedit2.Text+''' and ';
   if d=1 then a:=a+'职位=''部门负责人'''+' and ';
   if e=1 then a:=a+'职位=''主管'''+' and ';
   if f=1 then a:=a+'职位=''职员'''+' and ';
   if g=1 then
      a:=a+'新进人员标志=''是'''+' and '
   else
      a:=a+'新进人员标志=NULL'+' and ';
   a:=copy(a,1,length(a)-5);
   adotable2.Filtered:=false;
   adotable2.Filter:=a;
   adotable2.Filtered:=true;
end;

procedure TForm8.N8Click(Sender: TObject);
begin
   adotable1.Close;
   form8.Close;
end;

procedure TForm8.Button1Click(Sender: TObject);
var m:integer;
    c:string;
    d:integer;
begin
    adotable3.Filtered:=false;
   adotable3.Last;
   m:=strtoint(dbedit9.Text);
   adotable3.Filter:='培训编号='+dbedit1.Text;
   adotable3.Filtered:=true;
   adotable3.Append;
   dbedit9.Text:=inttostr(m+1);
   dbedit6.Text:=dbedit1.Text;
   dbedit7.Text:=dbedit5.Text;
   dbedit8.Text:='0';
   adotable3.Post;
   c:=dbedit3.Text;
   d:=pos('脱产培训',c);
   if d=1 then
   begin
      adotable2.Filtered:=false;
      adotable2.Filter:='员工号='''+dbedit7.Text+'''';
      adotable2.Filtered:=true;
      adotable2.Edit;
      dbedit10.Text:='脱产学习';
      adotable2.Post;
      adotable2.Close;
      adotable2.Open;
   end;
end;

procedure TForm8.DBGrid1CellClick(Column: TColumn);
begin
   adotable3.Filtered:=false;
   adotable3.Filter:='培训编号='+dbedit1.Text;
   adotable3.Filtered:=true;
end;

procedure TForm8.N7Click(Sender: TObject);
begin
   adotable2.Filtered:=false;
end;

end.