dl110report.~pas

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

unit DL110Report;

interface

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

type
  TqrDL110 = class(TQuickReport)
    qyReportDeliveryID: TStringField;
    qyReportDeliveryDate: TStringField;
    qyReportCustomerID: TStringField;
    qyReportCustomerAttribName: TStringField;
    qyReportCompanyID: TStringField;
    qyReportDeliveryItem: TStringField;
    qyReportProductID: TStringField;
    qyReportSalesQuantity: TBCDField;
    qyReportSalesUnitPrice: TBCDField;
    qyReportSalesAmount: TBCDField;
    qyReportChineseName: TStringField;
    qyReportDeliveryProperty: TStringField;
    qyReportWarehouseID: TStringField;
    qyReportWarehouseName: TStringField;
    qyReportDeliveryAddressID: TStringField;
    qyReportInvoiceType: TStringField;
    qyReportInvoiceNo: TStringField;
    qyReportCustomerOrderNo: TStringField;
    qyReportSubTotal: TBCDField;
    qyReportValueAddTax: TBCDField;
    qyReportAmount: TBCDField;
    qyReportSalesManID: TStringField;
    qyReportAddressDescription: TStringField;
    qyReportPostalCode: TStringField;
    qyReportLine1: TStringField;
    qyReportLine2: TStringField;
    qyReportLine3: TStringField;
    qyReportProductName: TStringField;
    bdGroupHeader: TQRGroup;
    QRDBText13: TQRDBText;
    QRLabel6: TQRLabel;
    QRDBText1: TQRDBText;
    QRLabel7: TQRLabel;
    QRDBText2: TQRDBText;
    QRLabel8: TQRLabel;
    QRDBText3: TQRDBText;
    QRDBText5: TQRDBText;
    QRDBText6: TQRDBText;
    QRDBText4: TQRDBText;
    QRLabel9: TQRLabel;
    QRDBText12: TQRDBText;
    QRDBText9: TQRDBText;
    QRDBText10: TQRDBText;
    QRDBText11: TQRDBText;
    QRLabel12: TQRLabel;
    QRLabel11: TQRLabel;
    QRDBText8: TQRDBText;
    QRDBText7: TQRDBText;
    QRLabel10: TQRLabel;
    QRShape1: TQRShape;
    QRLabel13: TQRLabel;
    QRLabel14: TQRLabel;
    QRLabel15: TQRLabel;
    QRLabel16: TQRLabel;
    QRLabel17: TQRLabel;
    QRLabel18: TQRLabel;
    QRDBText14: TQRDBText;
    QRShape2: TQRShape;
    QRDBText15: TQRDBText;
    QRDBText16: TQRDBText;
    QRDBText17: TQRDBText;
    QRDBText18: TQRDBText;
    QRDBText19: TQRDBText;
    bdGroupFooter: TQRBand;
    QRLabel19: TQRLabel;
    QRLabel20: TQRLabel;
    QRLabel21: TQRLabel;
    QRDBText20: TQRDBText;
    QRDBText21: TQRDBText;
    QRDBText22: TQRDBText;
    QRLabel22: TQRLabel;
    QRDBText23: TQRDBText;
    QRDBText24: TQRDBText;
    QRDBText25: TQRDBText;
    QRLabel23: TQRLabel;
    QRDBText26: TQRDBText;
    qyReportDeliveryPropertyDescription: TStringField;
    QRLabel24: TQRLabel;
    QRDBText27: TQRDBText;
    procedure qyReportCalcFields(DataSet: TDataSet);
    procedure qyReportBeforeOpen(DataSet: TDataSet);
  private
    { Private declarations }
  public
    { Public declarations }
  end;
  procedure DL110Print(DeliveryID: String);

var
  qrDL110: TqrDL110;

implementation

uses Main;

var
  sDeliveryID : String;

{$R *.dfm}

procedure DL110Print(DeliveryID: String);
begin
  sDeliveryID := DeliveryID;
  qrDL110.Preview;
end;

procedure TqrDL110.qyReportCalcFields(DataSet: TDataSet);
begin
  inherited;
  if qyReport.FieldByName('DeliveryProperty').AsString = '1' then
    qyReport.FieldByName('DeliveryPropertyDescription').AsString := '