llygzzxx.pas

用delphi开发的 人事管理系统

unit llygzzxx;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  StdCtrls, ComCtrls, ExtCtrls, DBCtrls, Mask, Db, DBTables, Grids, DBGrids;

type
  TFrm_llygzbxx = class(TForm)
    Panel1: TPanel;
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Bevel1: TBevel;
    Shape1: TShape;
    Shape2: TShape;
    GroupBox1: TGroupBox;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    Label13: TLabel;
    Label14: TLabel;
    Bevel2: TBevel;
    Bevel3: TBevel;
    Bevel4: TBevel;
    Bevel5: TBevel;
    Bevel6: TBevel;
    Bevel7: TBevel;
    Bevel8: TBevel;
    Bevel9: TBevel;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit1: TDBEdit;
    DBEdit8: TDBEdit;
    DBEdit9: TDBEdit;
    DBEdit10: TDBEdit;
    DBEdit11: TDBEdit;
    DBEdit12: TDBEdit;
    DBEdit13: TDBEdit;
    DBEdit14: TDBEdit;
    DBEdit15: TDBEdit;
    DataSource1: TDataSource;
    Query1: TQuery;
    GroupBox2: TGroupBox;
    Label15: TLabel;
    Label16: TLabel;
    Label17: TLabel;
    Label18: TLabel;
    Bevel10: TBevel;
    Bevel11: TBevel;
    Bevel12: TBevel;
    Bevel13: TBevel;
    Bevel14: TBevel;
    Bevel15: TBevel;
    DBEdit4: TDBEdit;
    DBEdit5: TDBEdit;
    DBEdit6: TDBEdit;
    DBEdit7: TDBEdit;
    Label19: TLabel;
    Label20: TLabel;
    Bevel16: TBevel;
    Shape3: TShape;
    Shape4: TShape;
    DBGrid1: TDBGrid;
    DataSource2: TDataSource;
    Query2: TQuery;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    Button5: TButton;
    Button6: TButton;
    Button7: TButton;
    Button8: TButton;
    Button9: TButton;
    Button10: TButton;
    procedure TabSheet1Show(Sender: TObject);
    procedure TabSheet2Show(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure Button10Click(Sender: TObject);
    procedure Button7Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
    procedure Button9Click(Sender: TObject);
    procedure Button8Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Frm_llygzbxx: TFrm_llygzbxx;

implementation

{$R *.DFM}

procedure TFrm_llygzbxx.TabSheet1Show(Sender: TObject);
begin
if  query1.active  then
query1.close;
query1.open;
query1.first;
end;

procedure TFrm_llygzbxx.TabSheet2Show(Sender: TObject);
begin
if query2.Active then query2.close;
query2.open;
query2.first;
end;

procedure TFrm_llygzbxx.Button1Click(Sender: TObject);
begin
query1.first;
end;

procedure TFrm_llygzbxx.Button4Click(Sender: TObject);
begin
query1.Last;
end;

procedure TFrm_llygzbxx.Button5Click(Sender: TObject);
begin
close;
end;

procedure TFrm_llygzbxx.Button10Click(Sender: TObject);
begin
close;
end;

procedure TFrm_llygzbxx.Button7Click(Sender: TObject);
begin
query2.Prior;
if query2.Bof then showmessage('已到达最后一条记录');
end;

procedure TFrm_llygzbxx.Button6Click(Sender: TObject);
begin
query2.first;
end;

procedure TFrm_llygzbxx.Button9Click(Sender: TObject);
begin
query2.last;
end;

procedure TFrm_llygzbxx.Button8Click(Sender: TObject);
begin
query2.Next;
if query2.Eof then showmessage('已到达最后一条记录');
end;

procedure TFrm_llygzbxx.Button2Click(Sender: TObject);
begin
query1.Prior;
if query1.bof then showmessage('已到达第一条记录');
end;

procedure TFrm_llygzbxx.Button3Click(Sender: TObject);
begin
query1.next;
if query1.Eof then showmessage('已到达最后一条记录');
end;

procedure TFrm_llygzbxx.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
action:=cafree;
end;

end.