unit AP220Report;

interface

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

type
  TqrAP220 = class(TQuickReport)
    bdGroupHeader: TQRGroup;
    bdGroupFooter: TQRBand;
    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;
    qyReportUnAccountPayable: TFloatField;
    QRLabel16: TQRLabel;
    QRLabel17: TQRLabel;
    QRDBText8: TQRDBText;
    QRDBText9: TQRDBText;
    qyReportPurchasePropertyDescription: TStringField;
    QRDBText10: TQRDBText;
    QRDBText11: TQRDBText;
    QRDBText12: TQRDBText;
    QRDBText13: TQRDBText;
    QRLabel18: TQRLabel;
    QRDBText14: TQRDBText;
    dsReport: TDataSource;
    Query1: TQuery;
    FloatField1: TFloatField;
    qyReportBeginPurchaseDate: TStringField;
    qyReportEndPurchaseDate: TStringField;
    QRDBText15: TQRDBText;
    QRDBText16: TQRDBText;
    QRDBText17: TQRDBText;
    QRLabel19: TQRLabel;
    QRLabel20: TQRLabel;
    qyReportSupplierName: TStringField;
    qyReportPurchaseID: TStringField;
    qyReportPurchaseDate: TStringField;
    qyReportInvoiceNo: TStringField;
    qyReportAccountPayable: TBCDField;
    qyReportPaid: TBCDField;
    qyReportSubTotal: TBCDField;
    qyReportValueAddTax: TBCDField;
    qyReportSupplierID: TStringField;
    qyReportCompanyID: TStringField;
    qyReportPurchaseProperty: TStringField;
    qyReportAmount: TBCDField;
    qyReportSupplierInvoiceNo: TStringField;
    qyReportContactName1: TStringField;
    qyReportCompanyAddress: TStringField;
    QRDBText18: TQRDBText;
    Query1AccountPayable: TBCDField;
    Query1Paid: TBCDField;
    procedure qyReportBeforeOpen(DataSet: TDataSet);
    procedure qyReportCalcFields(DataSet: TDataSet);
    procedure Query1CalcFields(DataSet: TDataSet);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  qrAP220: TqrAP220;

implementation

uses DataModule, Main;

{$R *.dfm}

procedure TqrAP220.qyReportBeforeOpen(DataSet: TDataSet);
begin
  inherited;
  with qyReport do
  begin
    ParamByName('CompanyID').AsString := sCompanyID;
    ParamByName('BeginPurchaseDate').AsString := DM.tbInput.FieldByName('BeginDate').AsString;
    ParamByName('EndPurchaseDate').AsString := DM.tbInput.FieldByName('EndDate').AsString;
    ParamByName('BeginSupplierID').AsString := DM.tbInput.FieldByName('BeginSupplierID').AsString;
    ParamByName('EndSupplierID').AsString := DM.tbInput.FieldByName('EndSupplierID').AsString;
  end;
end;

procedure TqrAP220.qyReportCalcFields(DataSet: TDataSet);
begin
  inherited;
  if qyReport.FieldByName('PurchaseProperty').AsString = '5' then
    qyReport.FieldByName('PurchasePropertyDescription').AsString := '進(jìn)貨'
  else
    qyReport.FieldByName('PurchasePropertyDescription').AsString := '進(jìn)貨退出';
  qyReport.FieldByName('UnAccountPayable').AsFloat :=
           qyReport.FieldByName('AccountPayable').AsFloat -
           qyReport.FieldByName('Paid').AsFloat;
  qyReport.FieldByName('BeginPurchaseDate').AsString :=
                       DM.tbInput.FieldByName('BeginDate').AsString;
  qyReport.FieldByName('EndPurchaseDate').AsString :=
                       DM.tbInput.FieldByName('EndDate').AsString;
end;

procedure TqrAP220.Query1CalcFields(DataSet: TDataSet);
begin
  inherited;
  Query1.FieldByName('UnAccountPayable').AsFloat :=
         Query1.FieldByName('AccountPayable').AsFloat -
         Query1.FieldByName('Paid').AsFloat;
end;

end.