ydbbut.pas

宾馆客房管理系统,功能强大,界面美观,全部delphi源代码

unit ydbbut;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, QuickRpt, ExtCtrls, QRCtrls, DB, ADODB;

type
  Tydbbdyfm = class(TForm)
    dy: TQuickRep;
    DetailBand1: TQRBand;
    PageFooterBand1: TQRBand;
    PageHeaderBand1: TQRBand;
    QRLabel1: TQRLabel;
    QRLabel2: TQRLabel;
    QRSysData1: TQRSysData;
    QRLabel3: TQRLabel;
    QRLabel4: TQRLabel;
    QRLabel5: TQRLabel;
    QRLabel6: TQRLabel;
    QRLabel7: TQRLabel;
    QRLabel8: TQRLabel;
    QRLabel9: TQRLabel;
    QRShape1: TQRShape;
    fjh: TQRMemo;
    fjlx: TQRMemo;
    xm: TQRMemo;
    bh: TQRMemo;
    ddsj: TQRMemo;
    ldsj: TQRMemo;
    lxdh: TQRMemo;
    dyado: TADOQuery;
    QRLabel10: TQRLabel;
    QRSysData2: TQRSysData;
    zrs: TQRLabel;
    zrs1: TQRLabel;
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  ydbbdyfm: Tydbbdyfm;

implementation

{$R *.dfm}

procedure Tydbbdyfm.FormCreate(Sender: TObject);
begin
 with dyado do
   begin
     close;
     sql.Clear;
     sql.Add('select 客房编号,客房类型,预定人,会员编号,抵店时间,离店时间,联系电话 from 预定单表');
     open;
     first;
     while not eof do
      begin
        fjh.Lines.Add(fieldbyname('客房编号').AsString);
        fjlx.Lines.Add(fieldbyname('客房类型').AsString);
        xm.Lines.Add(fieldbyname('预定人').AsString);
        bh.Lines.Add(fieldbyname('会员编号').AsString);
        ddsj.Lines.Add(fieldbyname('抵店时间').AsString);
        ldsj.Lines.Add(fieldbyname('离店时间').AsString);
        lxdh.Lines.Add(fieldbyname('联系电话').AsString);
        next;
      end;
   end;
     with dyado do
   begin
     close;
     sql.Clear;
     sql.Add('select count(*) as zje from 预定单表');
     open;
     zrs1.Caption:=floattostr(fieldbyname('zje').AsFloat);
     end;
end;

end.