unit1.~pas

《delphi 7.0_8.0课程设计与系统开发案例》随书代码

unit Unit1;

interface

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

type
  TForm1 = class(TForm)
    Panel1: TPanel;
    Splitter1: TSplitter;
    Panel2: TPanel;
    Splitter2: TSplitter;
    Panel3: TPanel;
    Label1: TLabel;
    Label2: TLabel;
    Table1: TTable;
    Table2: TTable;
    DataSource1: TDataSource;
    DataSource2: TDataSource;
    DBGrid2: TDBGrid;
    DBNavigator1: TDBNavigator;
    DBNavigator2: TDBNavigator;
    Table1BDEDesigner: TStringField;
    Table1BDEDesigner2: TStringField;
    Table1BDEDesigner3: TStringField;
    Table1BDEDesigner4: TStringField;
    Table1BDEDesigner5: TStringField;
    Table1BDEDesigner6: TStringField;
    Table1BDEDesigner7: TStringField;
    Table1BDEDesigner8: TFloatField;
    Table1BDEDesigner9: TStringField;
    Table1BDEDesigner10: TCurrencyField;
    Label3: TLabel;
    Label4: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Label5: TLabel;
    Edit3: TEdit;
    SpeedButton1: TSpeedButton;
    DBGrid1: TDBGrid;
    procedure DBNavigator1BeforeAction(Sender: TObject;
      Button: TNavigateBtn);
    procedure SpeedButton1Click(Sender: TObject);
    procedure DBNavigator2BeforeAction(Sender: TObject;
      Button: TNavigateBtn);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.DBNavigator1BeforeAction(Sender: TObject;
  Button: TNavigateBtn);
var
i:integer;
s:string;
begin
i:=table1.fieldbyname('可用座位').value-table1.recordcount;
if table1.recordcount<>0 then begin
str(i,s);
edit1.text:=s;
edit2.Text:=s;
end else begin
showmessage('对不起，目前还无记录！');
end;
end;
procedure TForm1.SpeedButton1Click(Sender: TObject);
var
sum1:real;
s:string;
bookmark1:tbookmark;
begin
sum1:=0.00;
bookmark1:=table1.getbookmark;
table1.disablecontrols;
table1.first;
while not table1.eof do
begin
sum1:=sum1+table1.fieldbyname('票价').value;
table1.Next;
end;
table1.gotobookmark(bookmark1);
table1.FreeBookmark(bookmark1);
table1.EnableControls;
if table1.recordcount<>0 then begin
str(sum1:8:2,s);
edit3.text:=s;
end else begin
showmessage('目前还无记录，收入为0');
end;
END;
procedure TForm1.DBNavigator2BeforeAction(Sender: TObject;
  Button: TNavigateBtn);
 var
i:integer;
s:string;
begin
i:=table1.fieldbyname('可用座位').value-table1.recordcount;
if table1.recordcount<>0 then begin
str(i,s);
edit1.text:=s;
edit2.Text:=s;
end else begin
showmessage('对不起，目前还无记录！');
end;

end;

end.