f_frmsgrtjr.pas

一个非常好的桑拿浴管理系统

unit f_FrmSGRTJR;

interface

uses Windows, SysUtils, Messages, Classes, Graphics, Controls,
  StdCtrls, ExtCtrls, Forms, QuickRpt, QRCtrls;

type
  TFrmSGRTJR = class(TQuickRep)
    TitleBand1: TQRBand;
    QRLabel1: TQRLabel;
    QRLabel2: TQRLabel;
    QRLabel3: TQRLabel;
    QRLabel4: TQRLabel;
    QRLabel5: TQRLabel;
    ColumnHeaderBand1: TQRBand;
    QRLabel6: TQRLabel;
    QRLabel7: TQRLabel;
    QRLabel8: TQRLabel;
    QRLabel9: TQRLabel;
    DetailBand1: TQRBand;
    QRLabel11: TQRLabel;
    QRLabel12: TQRLabel;
    QRLabel13: TQRLabel;
    QRLabel14: TQRLabel;
    QRLabel10: TQRLabel;
    QRLabel15: TQRLabel;
    QRBand4: TQRBand;
    QRSysData1: TQRSysData;
    QRLabel20: TQRLabel;
    QRLabel21: TQRLabel;
    QRLabel22: TQRLabel;
    QRShape1: TQRShape;
    QRShape2: TQRShape;
    QRLabel16: TQRLabel;
    QRLabel17: TQRLabel;
    QRLabel18: TQRLabel;
    QRLabel19: TQRLabel;
    QRLabel23: TQRLabel;
    QRLabel24: TQRLabel;
    procedure QuickRepBeforePrint(Sender: TCustomQuickRep;
      var PrintReport: Boolean);
    procedure QuickRepNeedData(Sender: TObject; var MoreData: Boolean);
  private

  public

  end;

var
  FrmSGRTJR: TFrmSGRTJR;
  i : Integer ;
implementation

uses GlovProc, finace;
{$R *.DFM}
{----------------------------------procedure   END------------------------------------}


procedure TFrmSGRTJR.QuickRepBeforePrint(Sender: TCustomQuickRep;
  var PrintReport: Boolean);
begin
  i := 1 ;
end;

procedure TFrmSGRTJR.QuickRepNeedData(Sender: TObject;
  var MoreData: Boolean);
begin
  with fm_finace,fm_finace.SGRTJ,fm_finace.aqr_sys do
    begin
        {Close;
        SQL.Clear;
                      // 结算时间     洗浴总额      物品总额   服务总额
        SQL.Add(' Select reg_time_out,reg_real_price,cons_total,ser_total');
        SQL.Add(' From sny_reg,sny_consume,sny_serve ');

        Open;                }

        if i <= Rowcount-1 then
        begin
            QRLabel3.Caption:=formatDatetime('yyyy-mm-dd',DateTimePicker1.date);
            QRLabel5.Caption:=formatDatetime('yyyy-mm-dd',DateTimePicker2.date);
            QRLabel11.Caption:=Cells[0,i];
            QRLabel12.Caption:=Cells[1,i];
            QRLabel13.Caption:=Cells[2,i];
            QRLabel14.Caption:=Cells[3,i];
            QRLabel15.Caption:=Cells[4,i];
            QRLabel24.Caption:=Cells[5,i];

            inc(i);
            MoreData := i<=Rowcount ;
        end;
    end ;
end;

end.