ar220report.pas

一套融入了系统营销管理思想的管理软件产品

unit AR220Report;

interface

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

type
  TqrAR220 = class(TQuickReport)
    qyReportDeliveryID: TStringField;
    qyReportDeliveryDate: TStringField;
    qyReportInvoiceNo: TStringField;
    qyReportAccountReceivable: TBCDField;
    qyReportReceived: TBCDField;
    qyReportSubTotal: TBCDField;
    qyReportValueAddTax: TBCDField;
    qyReportCustomerID: TStringField;
    qyReportCompanyID: TStringField;
    qyReportDeliveryProperty: TStringField;
    qyReportAmount: TBCDField;
    bdGroupHeader: TQRGroup;
    bdGroupFooter: TQRBand;
    qyReportCustomerName: TStringField;
    QRLabel7: TQRLabel;
    QRLabel8: TQRLabel;
    QRLabel9: TQRLabel;
    QRLabel10: TQRLabel;
    QRLabel11: TQRLabel;
    QRLabel12: TQRLabel;
    QRLabel13: TQRLabel;
    QRLabel14: TQRLabel;
    QRLabel15: TQRLabel;
    QRDBText3: TQRDBText;
    QRDBText4: TQRDBText;
    QRDBText5: TQRDBText;
    QRDBText6: TQRDBText;
    QRDBText7: TQRDBText;
    QRDBText2: TQRDBText;
    QRDBText1: TQRDBText;
    QRLabel6: TQRLabel;
    qyReportUnAccountReceivable: TFloatField;
    QRLabel16: TQRLabel;
    QRLabel17: TQRLabel;
    QRDBText8: TQRDBText;
    QRDBText9: TQRDBText;
    qyReportDeliveryPropertyDescription: TStringField;
    QRDBText10: TQRDBText;
    QRDBText11: TQRDBText;
    QRDBText12: TQRDBText;
    QRDBText13: TQRDBText;
    QRLabel18: TQRLabel;
    QRDBText14: TQRDBText;
    qyReportCustomerInvoiceNo: TStringField;
    qyReportOwner: TStringField;
    dsReport: TDataSource;
    Query1: TQuery;
    BCDField4: TBCDField;
    BCDField5: TBCDField;
    FloatField1: TFloatField;
    qyReportBeginDeliveryDate: TStringField;
    qyReportEndDeliveryDate: TStringField;
    QRDBText15: TQRDBText;
    QRDBText16: TQRDBText;
    QRDBText17: TQRDBText;
    QRLabel19: TQRLabel;
    procedure qyReportBeforeOpen(DataSet: TDataSet);
    procedure qyReportCalcFields(DataSet: TDataSet);
    procedure Query1CalcFields(DataSet: TDataSet);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  qrAR220: TqrAR220;

implementation

uses DataModule, Main;

{$R *.dfm}

procedure TqrAR220.qyReportBeforeOpen(DataSet: TDataSet);
begin
  inherited;
  with qyReport do
  begin
    ParamByName('CompanyID').AsString := sCompanyID;
    ParamByName('BeginDeliveryDate').AsString := DM.tbInput.FieldByName('BeginDate').AsString;
    ParamByName('EndDeliveryDate').AsString := DM.tbInput.FieldByName('EndDate').AsString;
    ParamByName('BeginCustomerID').AsString := DM.tbInput.FieldByName('BeginCustomerID').AsString;
    ParamByName('EndCustomerID').AsString := DM.tbInput.FieldByName('EndCustomerID').AsString;
  end;
end;

procedure TqrAR220.qyReportCalcFields(DataSet: TDataSet);
begin
  inherited;
  if qyReport.FieldByName('DeliveryProperty').AsString = '1' then
    qyReport.FieldByName('DeliveryPropertyDescription').AsString := '