unit3.pas

学校教职工工资管理系统可实现工资的增加、删除和修改。

unit Unit3;

interface

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

type
  TForm3 = class(TForm)
    Image1: TImage;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    Button5: TButton;
    Button6: TButton;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form3: TForm3;
  str0,str00:string;

implementation

uses Unit4,unit1;

{$R *.dfm}

procedure TForm3.Button1Click(Sender: TObject);
 var
 str:string;
begin
    str:='select * from Staffview1 where 工号='+quotedstr(unit1.str0);
    adoquery1.Close ;
    adoquery1.SQL.Clear ;
    adoquery1.SQL.Add(str);
    adoquery1.Open;
end;

procedure TForm3.Button2Click(Sender: TObject);
var
   str:string;
begin
    str:='select * from jibensalaryview1 where 工号='+quotedstr(unit1.str0);
    adoquery1.Close ;
    adoquery1.SQL.Clear ;
    adoquery1.sql.Add(str);
    adoquery1.Open ;
end;

procedure TForm3.Button3Click(Sender: TObject);
var
    str:string;
begin
   str:='select * from jintieview1 where 工号='+quotedstr(unit1.str0);
   adoquery1.Close ;
   adoquery1.SQL.Clear ;
   adoquery1.SQL.Add(str);
   adoquery1.Open ;
end;

procedure TForm3.Button4Click(Sender: TObject);
var
    str:string;
begin
    str:='select * from kktableview1 where 工号='+quotedstr(unit1.str0);
    adoquery1.Close ;
    adoquery1.SQL.Clear ;
    adoquery1.SQL.Add(str);
    adoquery1.Open ;
end;

procedure TForm3.Button5Click(Sender: TObject);
begin
    form3.Close;
end;

procedure TForm3.Button6Click(Sender: TObject);
begin
     form4.show
end;

end.