dl260report.pas

来自「零售行业进销存源码.delphi7 BDE sql server.功能全面,运行」· PAS 代码 · 共 70 行

unit DL260Report;

interface

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

type
  TqrDL260 = class(TQuickReport)
    brGroupHeader: TQRGroup;
    QRLabel6: TQRLabel;
    QRDBText1: TQRDBText;
    QRLabel7: TQRLabel;
    QRDBText2: TQRDBText;
    QRLabel8: TQRLabel;
    QRLabel9: TQRLabel;
    QRDBText3: TQRDBText;
    QRDBText4: TQRDBText;
    QRLabel10: TQRLabel;
    QRLabel11: TQRLabel;
    QRLabel12: TQRLabel;
    QRLabel13: TQRLabel;
    QRDBText5: TQRDBText;
    QRDBText6: TQRDBText;
    QRDBText7: TQRDBText;
    QRDBText8: TQRDBText;
    qyReportCustomerAttribName: TStringField;
    qyReportCustomerID: TStringField;
    qyReportSalesYear: TStringField;
    qyReportSalesMonth: TStringField;
    qyReportProductID: TStringField;
    qyReportSalesQuantity: TBCDField;
    qyReportSalesAmount: TBCDField;
    qyReportSalesReturnQuantity: TBCDField;
    qyReportSalesReturnAmount: TBCDField;
    qyReportProductName: TStringField;
    procedure qyReportBeforeOpen(DataSet: TDataSet);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  qrDL260: TqrDL260;

implementation

uses DataModule, Main;

{$R *.dfm}

procedure TqrDL260.qyReportBeforeOpen(DataSet: TDataSet);
begin
  inherited;
  with qyReport do
  begin
    ParamByName('CompanyID').AsString := sCompanyID;
    ParamByName('BeginCustomerID').AsString := DM.tbInput.FieldByName('BeginCustomerID').AsString;
    ParamByName('EndCustomerID').AsString := DM.tbInput.FieldByName('EndCustomerID').AsString;
    ParamByName('BeginYearMonth').AsString := DM.tbInput.FieldByName('BeginYear').AsString +
                                              DM.tbInput.FieldByName('BeginMonth').AsString;
    ParamByName('EndYearMonth').AsString := DM.tbInput.FieldByName('EndYear').AsString +
                                              DM.tbInput.FieldByName('EndMonth').AsString;
  end;  
end;

end.