bxprint.pas

小区物业管理(delphi+sql server)源代码

unit BXprint;

interface

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

type
  TBXrptPrint = class(TQuickRep)
    Query1: TADOQuery;
    PageHeaderBand1: TQRBand;
    TitleBand1: TQRBand;
    QRLabel1: TQRLabel;
    QRLabel2: TQRLabel;
    QRLabel11: TQRLabel;
    QRLabel12: TQRLabel;
    QRLabel10: TQRLabel;
    Query1DSDesigner: TWideStringField;
    Query1DSDesigner2: TWideStringField;
    Query1DSDesigner3: TDateTimeField;
    Query1DSDesigner4: TBCDField;
    Query1DSDesigner5: TBCDField;
    Query1DSDesigner6: TWideStringField;
    Query1DSDesigner7: TWideStringField;
    Query1DSDesigner8: TDateTimeField;
    Query1DSDesigner9: TBCDField;
    Query1DSDesigner10: TWideStringField;
    DetailBand1: TQRBand;
    QRDBText1: TQRDBText;
    QRDBText2: TQRDBText;
    QRDBText3: TQRDBText;
    QRDBText4: TQRDBText;
    QRDBText5: TQRDBText;
    QRDBText6: TQRDBText;
    QRDBText7: TQRDBText;
    QRDBText8: TQRDBText;
    QRDBText9: TQRDBText;
    QRLabel3: TQRLabel;
    QRLabel4: TQRLabel;
    QRLabel5: TQRLabel;
    QRLabel6: TQRLabel;
    QRLabel7: TQRLabel;
    QRLabel8: TQRLabel;
    QRLabel9: TQRLabel;
    QRLabel13: TQRLabel;
    QRLabel14: TQRLabel;
    procedure QuickRepBeforePrint(Sender: TCustomQuickRep;
      var PrintReport: Boolean);
    procedure QuickRepStartPage(Sender: TCustomQuickRep);
  private

  public

  end;

var
  BXrptPrint: TBXrptPrint;

implementation
uses udm, TsrptPreUnit;
{$R *.DFM}

procedure TBXrptPrint.QuickRepBeforePrint(Sender: TCustomQuickRep;
  var PrintReport: Boolean);
begin
  Query1.Close;
  Query1.SQL.Add('select * from YHBXTable');
  Query1.Open;
  Query1.First;
  QRLabel10.Caption := '制表人员：' + adodm.Tuser.FieldByName('用户名称').AsString;
  QRLabel2.Caption := '报修次数: ' + IntToStr(Query1.RecordCount);
  QRLabel12.Caption := '制表日期：' + DateToStr(Now);

end;

procedure TBXrptPrint.QuickRepStartPage(Sender: TCustomQuickRep);
begin
  BXrptPrint.Prepare;
  BXrptPrint.CleanupInstance; //必须加上这一句
  BXrptPrint.QRLabel11.Caption := '第 ' + TRIMLEFT(INTTOSTR(BXrptPrint.Printer.PageNumber)) + ' 页，' + '共 ' + TRIMLEFT(INTTOSTR(BXrptPrint.Printer.PageCount)) + ' 页'; //得到当前页码和总的页码

end;

end.