roomquery.pas

完成酒店管理系统

unit RoomQuery;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DB, ADODB, Grids, DBGrids, StdCtrls;

type
  TRoomQueryFrm = class(TForm)
    GroupBox1: TGroupBox;
    ComboBox1: TComboBox;
    ComboBox2: TComboBox;
    Edit1: TEdit;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    DBGrid1: TDBGrid;
    DataSource1: TDataSource;
    ADOQuery1: TADOQuery;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  RoomQueryFrm: TRoomQueryFrm;

implementation

uses RoomChart;

{$R *.dfm}

procedure TRoomQueryFrm.Button1Click(Sender: TObject);
var
Str: String;
begin
if (ComboBox1.Text = '') or (ComboBox2.Text = '') or (Edit1.Text = '') then
begin
ShowMessage('条件不完整！请重新输入！');
ComboBox1.Text:= '';
ComboBox2.Text:= '';
Edit1.Text:= '';
ComboBox1.SetFocus;
end
else
begin
ADOQuery1.Close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('Select * From RoomInput Where ' + ComboBox1.Text +
  ComboBox2.Text + Edit1.Text);
ADOQuery1.Open; 

end;
end;

procedure TRoomQueryFrm.Button2Click(Sender: TObject);
begin
ComboBox1.Text:= '';
ComboBox2.Text:= '';
Edit1.Text:= '';
ComboBox1.SetFocus;
end;

procedure TRoomQueryFrm.Button3Click(Sender: TObject);
begin
RoomChartFrm.Show;
end;

procedure TRoomQueryFrm.FormShow(Sender: TObject);
begin
ADOQuery1.Refresh;
DBGrid1.Refresh;
end;

end.