unit2.pas

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

unit Unit2;

interface

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

type
  TForm2 = class(TForm)
    Table1StringField: TStringField;
    Table1StringField2: TStringField;
    Table1FloatField: TFloatField;
    Table1StringField3: TStringField;
    Table1StringField4: TStringField;
    Table1StringField5: TStringField;
    Table1StringField6: TStringField;
    Table1StringField7: TStringField;
    Table1StringField8: TStringField;
    Table1FloatField2: TFloatField;
    Table1FloatField3: TFloatField;
    Table1CurrencyField: TCurrencyField;
    Table1CurrencyField2: TCurrencyField;
    ScrollBox: TScrollBox;
    Label1: TLabel;
    EditDBEdit: TDBEdit;
    Label2: TLabel;
    EditDBEdit2: TDBEdit;
    Label3: TLabel;
    EditDBEdit3: TDBEdit;
    Label4: TLabel;
    EditDBEdit4: TDBEdit;
    Label5: TLabel;
    EditDBEdit5: TDBEdit;
    Label6: TLabel;
    EditDBEdit6: TDBEdit;
    Label7: TLabel;
    EditDBEdit7: TDBEdit;
    Label8: TLabel;
    EditDBEdit8: TDBEdit;
    Label9: TLabel;
    EditDBEdit9: TDBEdit;
    Label10: TLabel;
    EditDBEdit10: TDBEdit;
    Label11: TLabel;
    EditDBEdit11: TDBEdit;
    Label12: TLabel;
    EditDBEdit12: TDBEdit;
    Label13: TLabel;
    EditDBEdit13: TDBEdit;
    DBNavigator: TDBNavigator;
    Panel1: TPanel;
    DataSource1: TDataSource;
    Panel2: TPanel;
    Table1: TTable;
    Label14: TLabel;
    SpeedButton1: TSpeedButton;
    Table2: TTable;
    BatchMove1: TBatchMove;
    procedure FormCreate(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure DBNavigatorClick(Sender: TObject; Button: TNavigateBtn);
  private
    { private declarations }
  public
    { public declarations }
  end;

var
  Form2: TForm2;

implementation

{$R *.DFM}

procedure TForm2.FormCreate(Sender: TObject);
begin
  Table1.Open;
end;

procedure TForm2.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;
str(sum1:8:2,s);
editdbedit13.text:=s;
end;

procedure TForm2.DBNavigatorClick(Sender: TObject; Button: TNavigateBtn);
var
i:integer;
s:string;
begin
i:=table1.fieldbyname('座位总数').value-table1.recordcount;
str(i,s);
editdbedit11.text:=s;
end;

end.