dataut.~pas

用delphi+access给单位做的实用,简单的.

unit dataut;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ComCtrls, DBCtrls, DB, ADODB, Grids, DBGrids, ExtCtrls,
  StdCtrls, Buttons;

type
  Tdatafm = class(TForm)
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    TabSheet3: TTabSheet;
    TabSheet4: TTabSheet;
    TabSheet5: TTabSheet;
    Panel1: TPanel;
    Panel2: TPanel;
    DBGrid1: TDBGrid;
    DataSource1: TDataSource;
    ADOQuery1: TADOQuery;
    DBNavigator1: TDBNavigator;
    Panel3: TPanel;
    DBNavigator2: TDBNavigator;
    Panel4: TPanel;
    DBGrid2: TDBGrid;
    Panel5: TPanel;
    DBNavigator3: TDBNavigator;
    Panel6: TPanel;
    DBGrid3: TDBGrid;
    Panel7: TPanel;
    DBNavigator4: TDBNavigator;
    Panel8: TPanel;
    DBGrid4: TDBGrid;
    Panel9: TPanel;
    DBNavigator5: TDBNavigator;
    Panel10: TPanel;
    DBGrid5: TDBGrid;
    ADOQuery2: TADOQuery;
    DataSource2: TDataSource;
    DataSource3: TDataSource;
    DataSource4: TDataSource;
    DataSource5: TDataSource;
    ADOQuery3: TADOQuery;
    ADOQuery4: TADOQuery;
    ADOQuery5: TADOQuery;
    TabSheet6: TTabSheet;
    GroupBox1: TGroupBox;
    CheckBox1: TCheckBox;
    CheckBox2: TCheckBox;
    CheckBox3: TCheckBox;
    CheckBox4: TCheckBox;
    CheckBox5: TCheckBox;
    CheckBox6: TCheckBox;
    CheckBox7: TCheckBox;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    BitBtn3: TBitBtn;
    ADOQuery6: TADOQuery;
    procedure FormCreate(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  datafm: Tdatafm;

implementation

{$R *.dfm}

procedure Tdatafm.FormCreate(Sender: TObject);
begin
with adoquery1 do
   begin
     close;
     sql.Clear;
     sql.Add('select * from 职务表');
     open;
   end;
   with adoquery2 do
   begin
     close;
     sql.Clear;
     sql.Add('select * from 级别表');
     open;
   end;
   with adoquery3 do
   begin
     close;
     sql.Clear;
     sql.Add('select * from 职称表');
     open;
   end;
   with adoquery4 do
   begin
     close;
     sql.Clear;
     sql.Add('select * from 等级表');
     open;
   end;
   with adoquery5 do
   begin
     close;
     sql.Clear;
     sql.Add('select * from 班组表');
     open;
   end;

  CheckBox1.Checked:=true;
  CheckBox2.Checked:=true;
  CheckBox3.Checked:=true;
  CheckBox4.checked:=true;
  CheckBox5.Checked:=true;
  CheckBox6.Checked:=true;
  CheckBox7.Checked:=true;

end;

procedure Tdatafm.BitBtn2Click(Sender: TObject);
begin
close;
end;

procedure Tdatafm.BitBtn3Click(Sender: TObject);
begin
  CheckBox1.Checked:=true;
  CheckBox2.Checked:=true;
  CheckBox3.Checked:=true;
  CheckBox4.checked:=true;
  CheckBox5.Checked:=true;
  CheckBox6.Checked:=true;
  CheckBox7.Checked:=true;
end;

procedure Tdatafm.BitBtn1Click(Sender: TObject);
begin
try
 with adoquery6 do
   begin
     close;
     sql.Clear;
     sql.Add('delete  from  职务表');
     if checkbox1.Checked then
      execsql;
     sql.Add('delete  from  级别表');
     if checkbox2.Checked then
     execsql;
     sql.Add('delete  from  职称表');
     if checkbox3.Checked then
     execsql;
     sql.Add('delete  from  等级表');
     if checkbox4.Checked then
     execsql;
     sql.Add('delete  from  班组表');
     if checkbox5.Checked then
     execsql;
     sql.Add('delete  from  用户表 where 姓名<>"admin"');
     if checkbox6.Checked then
     execsql;
     sql.Add('delete  from  职工信息表');
     if checkbox7.Checked then
     execsql;
   end;
   showmessage('初始化成功');
   except
   showmessage('初始化失败');
   end;
end;

end.