ar210report.pas

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

unit AR210Report;

interface

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

type
  TqrAR210 = class(TQuickReport)
    bdGroupHeader: TQRGroup;
    QRLabel6: TQRLabel;
    QRLabel7: TQRLabel;
    QRLabel8: TQRLabel;
    QRLabel9: TQRLabel;
    QRLabel10: TQRLabel;
    QRLabel11: TQRLabel;
    QRLabel12: TQRLabel;
    QRLabel13: TQRLabel;
    QRLabel14: TQRLabel;
    QRLabel15: TQRLabel;
    QRLabel16: TQRLabel;
    QRDBText1: TQRDBText;
    QRDBText2: TQRDBText;
    QRDBText3: TQRDBText;
    QRDBText4: TQRDBText;
    QRDBText5: TQRDBText;
    QRDBText6: TQRDBText;
    QRDBText7: TQRDBText;
    QRDBText8: TQRDBText;
    QRDBText9: TQRDBText;
    QRDBText10: TQRDBText;
    QRDBText11: TQRDBText;
    QRDBText12: TQRDBText;
    QRLabel17: TQRLabel;
    bdGroupFooter: TQRBand;
    dsReport: TDataSource;
    Query1: TQuery;
    qyReportCustomerAttribName: TStringField;
    qyReportCustomerID: TStringField;
    qyReportReceiveID: TStringField;
    qyReportReceiveDate: TStringField;
    qyReportReceiveCash: TBCDField;
    qyReportReceiveCheck: TBCDField;
    qyReportDiscount: TBCDField;
    qyReportRemittance: TBCDField;
    qyReportAdvance: TBCDField;
    qyReportOthers: TBCDField;
    qyReportReceiveAmount: TBCDField;
    qyReportTotalBalance: TBCDField;
    qyReportCompanyID: TStringField;
    QRDBText13: TQRDBText;
    QRDBText14: TQRDBText;
    QRDBText15: TQRDBText;
    QRDBText16: TQRDBText;
    Query1ReceiveCash: TBCDField;
    Query1ReceiveCheck: TBCDField;
    Query1Discount: TBCDField;
    Query1Remittance: TBCDField;
    Query1Advance: TBCDField;
    Query1Others: TBCDField;
    Query1ReceiveAmount: TBCDField;
    Query1TotalBalance: TBCDField;
    QRDBText17: TQRDBText;
    QRDBText18: TQRDBText;
    QRDBText19: TQRDBText;
    QRDBText20: TQRDBText;
    QRBand1: TQRBand;
    QRLabel18: TQRLabel;
    QRExpr1: TQRExpr;
    QRExpr2: TQRExpr;
    QRExpr3: TQRExpr;
    QRExpr4: TQRExpr;
    QRExpr5: TQRExpr;
    QRExpr6: TQRExpr;
    QRExpr7: TQRExpr;
    QRExpr8: TQRExpr;
    QRLabel19: TQRLabel;
    procedure qyReportBeforeOpen(DataSet: TDataSet);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  qrAR210: TqrAR210;

implementation

uses DataModule, Main;

{$R *.dfm}

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

end.