unit23.pas

以学习为目的,使用DIPH开发而成,功能强大,是我们的老师提供的!

unit Unit23;

interface

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

type
  TForm23 = class(TForm)
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    Label6: TLabel;
    Label7: TLabel;
    DBEdit5: TDBEdit;
    DBEdit6: TDBEdit;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    GroupBox1: TGroupBox;
    Label11: TLabel;
    Edit1: TEdit;
    Button1: TButton;
    Button2: TButton;
    Table1: TTable;
    DataSource1: TDataSource;
    Label12: TLabel;
    Label13: TLabel;
    Label14: TLabel;
    Label15: TLabel;
    Label16: TLabel;
    Label17: TLabel;
    Label18: TLabel;
    Label19: TLabel;
    DBEdit7: TDBEdit;
    DBEdit8: TDBEdit;
    DBEdit9: TDBEdit;
    DBEdit10: TDBEdit;
    DBEdit11: TDBEdit;
    DBEdit12: TDBEdit;
    Label20: TLabel;
    Label21: TLabel;
    GroupBox2: TGroupBox;
    Label22: TLabel;
    Edit2: TEdit;
    Button3: TButton;
    Button4: TButton;
    Table2: TTable;
    DataSource2: TDataSource;
    ComboBox1: TComboBox;
    ComboBox2: TComboBox;
    Table3: TTable;
    Table4: TTable;
    procedure DBComboBox1Change(Sender: TObject);
    procedure DBComboBox2Change(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form23: TForm23;

implementation
uses
unit10;
{$R *.DFM}

procedure TForm23.DBComboBox1Change(Sender: TObject);
begin
table1.First;
while not table1.Eof do
begin
if table1.FieldByName('zdz').asstring=combobox1.text then
break;
table1.Next;
end;
end;

procedure TForm23.DBComboBox2Change(Sender: TObject);
begin
table2.First;
while not table2.Eof do
begin
if table2.FieldByName('zdz').asstring=combobox2.text then
break;
table2.Next;
end;
end;
procedure TForm23.Button1Click(Sender: TObject);
begin
table3.Open;
table3.First;
while not table3.Eof do
begin
if table3.FieldByName('fh').asstring=edit1.Text then
break;
table3.Next;
end;
if table3.Eof then
begin
showmessage('房间号错误。');
exit;
end;
table3.Edit;
table3.FieldByName('fw').asfloat:=table3.FieldByName('fw').asfloat+abstractF(dbedit6.text);
table3.FieldByName('bz').asstring:=table3.FieldByName('bz').asstring+'定火车票：'+dbedit6.text;
table3.Post;
table4.Append;
table4.Edit;
table4.FieldByName('lb').asstring:='定票';
table4.FieldByName('rq').asdatetime:=now;
table4.FieldByName('sr').asfloat:=abstractF(dbedit6.text);
table4.Post;
end;

procedure TForm23.Button3Click(Sender: TObject);
begin
table3.Open;
table3.First;
while not table3.Eof do
begin
if table3.FieldByName('fh').asstring=edit2.Text then
break;
table3.Next;
end;
if table3.Eof then
begin
showmessage('房间号错误。');
exit;
end;
table3.Edit;
table3.FieldByName('fw').asfloat:=table3.FieldByName('fw').asfloat+abstractF(dbedit11.text);
table3.FieldByName('bz').asstring:=table3.FieldByName('bz').asstring+'定飞机票：'+dbedit11.text;
table3.Post;
table4.Append;
table4.Edit;
table4.FieldByName('lb').asstring:='定票';
table4.FieldByName('rq').asdatetime:=now;
table4.FieldByName('sr').asfloat:=abstractF(dbedit11.text);
table4.Post;
end;

procedure TForm23.Button4Click(Sender: TObject);
begin
close;
end;

procedure TForm23.Button2Click(Sender: TObject);
begin
  close;
end;

end.