dtszcx.pas

我自己写的一个有关酒店管理系统的代码 大家

unit dtszcx;

interface

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

type
  TDtszcxForm = class(TForm)
    DBGrid1: TDBGrid;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    Query1: TQuery;
    procedure BitBtn2Click(Sender: TObject);
    procedure FormActivate(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure showlabel;
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  DtszcxForm: TDtszcxForm;
  AdoTable1:TAdoTable;
implementation
  uses dtszcxrpt,main;
{$R *.dfm}

procedure TDtszcxForm.BitBtn2Click(Sender: TObject);
begin
    query1.Close;
    close;
end;

procedure TDtszcxForm.FormActivate(Sender: TObject);
var
      datasource1:TDatasource;
begin
      datasource1:=TDataSource.Create(self);
      dbgrid1.DataSource:=datasource1;
      dbgrid1.ReadOnly:=true;
      datasource1.DataSet:=query1;
      query1.Close;
      query1.SQL.Clear;
      query1.SQL.add('select * from dtsztable');
      query1.open;
      showlabel;
end;

procedure TDtszcxForm.BitBtn1Click(Sender: TObject);
begin
      dtszcxrptform.qrlabel13.Caption:=username;
      dtszcxrptform.QRLabel15.Caption:=datetimetostr(now);
      dtszcxrptform.QuickRep1.Preview;
      dtszcxrptform.query1.close;
end;
procedure TDtszcxForm.showlabel;
begin
    dbgrid1.Fields[0].DisplayLabel:='订房编号';
    dbgrid1.Fields[1].DisplayLabel:='客房编号';
    dbgrid1.Fields[2].DisplayLabel:='客人名称';
    dbgrid1.Fields[3].DisplayLabel:='押金数';
    dbgrid1.Fields[4].DisplayLabel:='实收金额';
    dbgrid1.Fields[5].DisplayLabel:='说明';
    dbgrid1.Fields[6].DisplayLabel:='操作日期';
    dbgrid1.Fields[7].DisplayLabel:='操作员';
end;
end.