pr270report.pas

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

unit PR270Report;

interface

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

type
  TqrPR270 = class(TQuickReport)
    qyReportSupplierAttribName: TStringField;
    qyReportSupplierID: TStringField;
    qyReportPurchaseQuantity: TBCDField;
    qyReportPurchaseAmount: TBCDField;
    QRLabel10: TQRLabel;
    QRLabel11: TQRLabel;
    QRDBText5: TQRDBText;
    QRDBText6: TQRDBText;
    QRLabel7: TQRLabel;
    QRLabel6: TQRLabel;
    QRDBText1: TQRDBText;
    QRDBText2: TQRDBText;
    QRLabel8: TQRLabel;
    qyReportSEQ: TIntegerField;
    QRDBText3: TQRDBText;
    UpdateSQL1: TUpdateSQL;
    procedure qyReportBeforeOpen(DataSet: TDataSet);
  private
    { Private declarations }
  public
    { Public declarations }
    procedure PrepareReport; override;
  end;

var
  qrPR270: TqrPR270;

implementation

uses DataModule, Main;

{$R *.dfm}

procedure TqrPR270.PrepareReport;
var
  iSEQ : Integer;
begin
  inherited;
  iSEQ := 0;
  qyReport.First;
  while not qyReport.Eof do
  begin
    Inc(iSEQ);
    qyReport.Edit;
    qyReport.FieldByName('SEQ').AsInteger := iSEQ;
    qyReport.Post;
    qyReport.Next;
  end;
end;

procedure TqrPR270.qyReportBeforeOpen(DataSet: TDataSet);
begin
  inherited;
  with qyReport do
  begin
    ParamByName('CompanyID').AsString := sCompanyID;
    ParamByName('BeginSupplierID').AsString := DM.tbInput.FieldByName('BeginSupplierID').AsString;
    ParamByName('EndSupplierID').AsString := DM.tbInput.FieldByName('EndSupplierID').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.