arinvoicesreport.pas

功能全面的商业财会系统源码,清晰,很有参考价值.扩展性强.

unit ARInvoicesReport;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  StdCtrls, ExtCtrls, DBTables, DB, quickrpt, Qrctrls, qrprntr;

type
  TrptARInvoices = class(TForm)
    QuickReport: TQuickRep;
    Title: TQRBand;
    PageHeader: TQRBand;
    Detail: TQRBand;
    PageFooter: TQRBand;
    QRSysData1: TQRSysData;
    QRLabel1: TQRLabel;
    txtBillToNo: TQRDBText;
    txtBillToName: TQRDBText;
    txtInvoiceNo: TQRDBText;
    QRLabel2: TQRLabel;
    QRLabel4: TQRLabel;
    PageNumber: TQRSysData;
    QRShape1: TQRShape;
    QRShape2: TQRShape;
    QRShape3: TQRShape;
    qryARInv: TQuery;
    QRLabel3: TQRLabel;
    QRDateTime: TQRSysData;
    qryARInvInvoiceNo: TStringField;
    qryARInvInvoiceDate: TDateField;
    qryARInvInvoiceAmount: TCurrencyField;
    qryARInvOwing: TCurrencyField;
    qryARInvGLPeriod: TSmallintField;
    qryARInvGLYear: TSmallintField;
    qryARInvPosted: TBooleanField;
    QRLabel5: TQRLabel;
    QRLabel6: TQRLabel;
    QRLabel7: TQRLabel;
    QRLabel8: TQRLabel;
    QRLabel9: TQRLabel;
    txtInvoiceDate: TQRDBText;
    txtInvoiceAmount: TQRDBText;
    txtOwing: TQRDBText;
    txtPrinted: TQRDBText;
    txtPosted: TQRDBText;
    qryARInvPeriodppyyyy: TStringField;
    txtPeriodppyyyy: TQRDBText;
    qryARInvBillToNo: TStringField;
    qryARInvBillToName: TStringField;
    qryARInvPrinted: TBooleanField;
    qryARInvAge: TIntegerField;
    QRLabel10: TQRLabel;
    txtAge: TQRDBText;
    Summary: TQRBand;
    QRLabel13: TQRLabel;
    lblTotRInvoiceAmount: TQRLabel;
    lblTotROwing: TQRLabel;
    QRShape5: TQRShape;
    QRShape4: TQRShape;
    totROwing: TQRExpr;
    totRInvoiceAmount: TQRExpr;
    procedure FormCreate(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure qryARInvCalcFields(DataSet: TDataSet);
    procedure SummaryBeforePrint(Sender: TQRCustomBand;
      var PrintBand: Boolean);
    procedure QuickReportPreview(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  rptARInvoices: TrptARInvoices;

implementation

uses BS1Form, PreviewForm;

{$R *.DFM}

procedure TrptARInvoices.FormCreate(Sender: TObject);
begin
  qryARInv.DatabaseName := strDatabaseName;
  //qryARInv.Active := true;
end;

procedure TrptARInvoices.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
  Action := caFree;
end;

procedure TrptARInvoices.qryARInvCalcFields(DataSet: TDataSet);
begin
  qryARInvPeriodppyyyy.value := qryARInvGLPeriod.AsString + '/' + qryARInvGLYear.AsString;
  qryARInvAge.value := Round(Date() - qryARInvInvoiceDate.value);
end;

procedure TrptARInvoices.SummaryBeforePrint(Sender: TQRCustomBand;
  var PrintBand: Boolean);
begin
  if qryARInv.RecordCount = 0 then PrintBand := false;
  lblTotRInvoiceAmount.caption := FloatToStrF(totRInvoiceAmount.value.dblResult,ffCurrency,18,2);
  lblTotROwing.caption := FloatToStrF(totROwing.value.dblResult,ffCurrency,18,2);
end;

procedure TrptARInvoices.QuickReportPreview(Sender: TObject);
begin
  frmPreview := TfrmPreview.Create(Application);
  frmPreview.QRPreview1.QRPrinter := TQRPrinter(sender);
  frmPreview.QuickReport := QuickReport;   //Set dummy quickreport so as to be able to apply selected printer and from/to page.
  frmPreview.show;
end;

end.