dl240report.~pas

利用delhpi 开发的一个关于零售业进销管理系统

unit DL240Report;

interface

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

type
  TqrDL240 = class(TQuickReport)
    QRLabel8: TQRLabel;
    QRLabel9: TQRLabel;
    QRLabel10: TQRLabel;
    QRLabel11: TQRLabel;
    QRLabel12: TQRLabel;
    bdGroupHeader1: TQRGroup;
    bdGroupHeader2: TQRGroup;
    QRDBText4: TQRDBText;
    QRDBText5: TQRDBText;
    QRDBText6: TQRDBText;
    QRDBText7: TQRDBText;
    QRDBText8: TQRDBText;
    QRLabel14: TQRLabel;
    QRDBText9: TQRDBText;
    QRLabel13: TQRLabel;
    QRDBText1: TQRDBText;
    QRLabel6: TQRLabel;
    QRLabel7: TQRLabel;
    QRDBText3: TQRDBText;
    QRDBText2: TQRDBText;
    QRBand1: TQRBand;
    QRExpr1: TQRExpr;
    QRExpr2: TQRExpr;
    qyReportDeliveryDate: TStringField;
    qyReportDeliveryID: TStringField;
    qyReportCustomerAttribName: TStringField;
    qyReportProductID: TStringField;
    qyReportSalesQuantity: TBCDField;
    qyReportProductName: TStringField;
    qyReportDeliveryProperty: TStringField;
    qyReportCustomerID: TStringField;
    qyReportUnitPrice: TFloatField;
    qyReportSalesAnalystAmount: TBCDField;
    procedure qyReportBeforeOpen(DataSet: TDataSet);
    procedure qyReportCalcFields(DataSet: TDataSet);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  qrDL240: TqrDL240;

implementation

uses DataModule, Main;

{$R *.dfm}

procedure TqrDL240.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;
    ParamByName('BeginProductID').AsString := DM.tbInput.FieldByNAme('BeginProductID').AsString;
    ParamByName('EndProductID').AsString := DM.tbInput.FieldByName('EndProductID').AsString;
    ParamByName('BeginWarehouseID').AsString := DM.tbInput.FieldByName('BeginWarehouseID').AsString;
    ParamByName('EndWarehouseID').AsString := DM.tbInput.FieldByName('EndWarehouseID').AsString;
  end;
end;

procedure TqrDL240.qyReportCalcFields(DataSet: TDataSet);
begin
  inherited;
  if qyReport.FieldByName('SalesQuantity').AsFloat = 0 then
    qyReport.FieldByName('UnitPrice').AsFloat := 0
  else
    qyReport.FieldByName('UnitPrice').AsFloat :=
             qyReport.FieldByName('SalesAnalystAmount').AsFloat /
             qyReport.FieldByName('SalesQuantity').AsFloat;
end;

end.