unit14.pas

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

unit Unit14;

interface

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

type
  TForm14 = 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;
    N4: 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;
    ADOTable3: TADOTable;
    ADOTable3DSDesigner: TStringField;
    ADOTable3DSDesigner2: TStringField;
    ADOTable3DSDesigner3: TIntegerField;
    ADOTable3DSDesigner4: TIntegerField;
    ADOTable3DSDesigner5: TIntegerField;
    ADOTable3DSDesigner6: TIntegerField;
    ADOTable3DSDesigner7: TIntegerField;
    ADOTable3DSDesigner8: TIntegerField;
    DataSource3: TDataSource;
    ADOTable4: TADOTable;
    DataSource4: TDataSource;
    ADOTable4DSDesigner: TStringField;
    ADOTable4DSDesigner2: TStringField;
    ADOTable4DSDesigner3: TStringField;
    ADOTable4DSDesigner4: TStringField;
    ADOTable4DSDesigner5: TStringField;
    ADOTable4DSDesigner6: TIntegerField;
    ADOTable4DSDesigner7: TIntegerField;
    ADOTable4DSDesigner8: TIntegerField;
    ADOTable4DSDesigner9: TIntegerField;
    ADOTable1Field3: TStringField;
    ADOTable1Field4: TStringField;
    DBEdit1: TDBEdit;
    procedure FormActivate(Sender: TObject);
    procedure N5Click(Sender: TObject);
    procedure N4Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form14: TForm14;

implementation

{$R *.dfm}

procedure TForm14.FormActivate(Sender: TObject);
begin
   adotable1.Open;
   adotable2.Open;
   adotable3.Open;
   adotable4.Open;
end;

procedure TForm14.N5Click(Sender: TObject);
begin
   adotable1.Close;
   adotable2.Close;
   adotable3.Close;
   adotable4.Close;
   form14.Close;
end;

procedure TForm14.N4Click(Sender: TObject);
var m:integer;
    i:integer;
begin
   adotable1.First;
   m:=0;
   m:=m+strtoint(dbedit1.Text);
end;

end.