historysql.pas

完成酒店管理系统

unit HistorySql;

interface

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

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

var
  HistorySqlFrm: THistorySqlFrm;

implementation

{$R *.dfm}

procedure THistorySqlFrm.Button1Click(Sender: TObject);
begin
if (ComboBox1.Text = '') or (ComboBox2.Text = '') or (Edit1.Text = '') then
begin
ShowMessage('数据不能为空，请重新输入！');
Edit1.Text:= '';
ComboBox1.Text:= '';
Combobox2.Text:= '';
ComboBox1.SetFocus;
end
else
begin
ADOQuery1.Close;
ADOQuery1.SQL.Clear;
if (ComboBox1.Text = '客房等级') or  (ComboBox1.Text = '登记员') or
  (ComboBox1.Text = '旅客类别')  then
ADOQuery1.SQL.Add('Select * From Room Where ' +ComboBox1.Text+ComboBox2.Text
  +'"'+Edit1.Text+'"')
  else
  ADOQuery1.SQL.Add('Select * From Room Where ' + ComboBox1.Text + ComboBox2.Text
 +Edit1.Text);

ADOQuery1.Open;
end;


end;

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

end.