?? frmroommoneyform.~pas
字號:
unit frmRoomMoneyForm;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, ExtCtrls, ComCtrls, StdCtrls, DB, DBTables, Grids, DBGrids;
type
TRoomMoneyForm = class(TForm)
Panel1: TPanel;
Edit1: TEdit;
DataSource1: TDataSource;
Query1: TQuery;
Button2: TButton;
Label1: TLabel;
Panel2: TPanel;
DateTimePicker1: TDateTimePicker;
DateTimePicker2: TDateTimePicker;
Label2: TLabel;
Label3: TLabel;
Panel3: TPanel;
Panel4: TPanel;
DBGrid1: TDBGrid;
Button3: TButton;
DBGrid2: TDBGrid;
DataSource2: TDataSource;
Query2: TQuery;
DataSource3: TDataSource;
Query3: TQuery;
DBGrid3: TDBGrid;
Button1: TButton;
procedure Button2Click(Sender: TObject);
procedure Button1Click(Sender: TObject);
procedure Button3Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;
var
RoomMoneyForm: TRoomMoneyForm;
implementation
{$R *.dfm}
procedure TRoomMoneyForm.Button2Click(Sender: TObject);
begin
edit1.Text := '';
end;
procedure TRoomMoneyForm.Button1Click(Sender: TObject);
begin
RoomMoneyForm.Close;
end;
procedure TRoomMoneyForm.Button3Click(Sender: TObject);
begin
if (edit1.Text <> '') then
begin
Query1.Close;
Query1.SQL.Clear;
Query1.SQL.Add('select * from RoomInfo where 房間號='+edit1.Text);
Query1.Open;
Query2.Close;
Query2.SQL.Clear;
Query2.SQL.Add('select * from TouristInfo where 房間號='+edit1.Text);
Query2.Open;
Query3.Close;
Query3.SQL.Clear;
Query3.SQL.Add('select sum(房價) from roominfo where 房間號='+edit1.Text);
Query3.Open;
end
else showmessage('請輸入信息');
end;
end.
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -