drcwbbut.~pas

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

unit drcwbbut;

interface

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

type
  Tdrcwbbdyfm = 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;
    QRShape1: TQRShape;
    fjh: TQRMemo;
    fjlx: TQRMemo;
    xm: TQRMemo;
    bh: TQRMemo;
    fkfs: TQRMemo;
    jzje: TQRMemo;
    jzrq: TQRMemo;
    dyado: TADOQuery;
    QRLabel10: TQRLabel;
    QRSysData2: TQRSysData;
    QRLabel9: TQRLabel;
    QRLabel11: TQRLabel;
    zje: TQRLabel;
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  drcwbbdyfm: Tdrcwbbdyfm;

implementation

{$R *.dfm}

procedure Tdrcwbbdyfm.FormCreate(Sender: TObject);
begin
 with dyado do
   begin
     close;
     sql.Clear;
     sql.Add('select 客房编号,客房类型,预定人,会员编号,付款方式,结帐金额,结帐日期 from 入住单历史表 where 离店时间=date()');
     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);
        fkfs.Lines.Add(fieldbyname('付款方式').AsString);
        jzje.Lines.Add(fieldbyname('结帐金额').AsString);
        jzrq.Lines.Add(fieldbyname('结帐日期').AsString);
        next;
      end;
   end;
   with dyado do
   begin
     close;
     sql.Clear;
     sql.Add('select sum(结帐金额) as zje from 入住单历史表 where 离店时间=date()');
     open;
     zje.Caption:=floattostr(fieldbyname('zje').AsFloat);
     end;
end;

end.