groupsql.~pas

完成酒店管理系统

unit GroupSql;

interface

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

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

var
  GroupSqlFrm: TGroupSqlFrm;

implementation

{$R *.dfm}

procedure TGroupSqlFrm.Button1Click(Sender: TObject);
begin
Close;
end;

procedure TGroupSqlFrm.Button3Click(Sender: TObject);
begin
ComboBox1.Text:= '';
ComboBox2.Text:= '';
Edit1.Text:= '';
comboBox1.SetFocus;
ADOQuery1.Close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add(' Select *  From Tourist  ');
ADOQuery1.Open;
end;

procedure TGroupSqlFrm.Button2Click(Sender: TObject);
begin
if (Edit1.Text = '')  or (ComboBox2.Text = '' )  or (ComboBox1.Text = '' ) then
begin
ShowMessage('查询信息不能为空，请重新输入！');
Edit1.Text:= '';
ComboBox2.Text:= '';
ComboBox1.Text:= '';
ComboBox1.SetFocus;
end
else begin
ADOQuery1.Close;
ADOQuery1.SQL.Clear;
if (ComboBox1.Text = '房间号') or  (ComboBox1.Text = '人数') then
ADOQuery1.SQL.Add(' Select *  From GroupTourist Where '+ ComboBox1.Text +
  ComboBox2.Text + Edit1.Text )
  else
  ADOQuery1.SQL.Add(' Select *  From GroupTourist Where '+ ComboBox1.Text +
  ComboBox2.Text + '''' + Edit1.Text + '''');
ADOQuery1.Open;
end;
end;

end.