date_report.~pas

结于初学者来说这对数据库是一个很好的例子

unit Date_report;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Buttons;

type
  TForm18 = class(TForm)
    Label1: TLabel;
    SpeedButton1: TSpeedButton;
    GroupBox1: TGroupBox;
    Button2: TButton;
    Button3: TButton;
    procedure SpeedButton1Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form18: TForm18;

implementation

uses data_accountprn, data_dinlistprn, mainmenu;

{$R *.dfm}

procedure TForm18.SpeedButton1Click(Sender: TObject);
begin
 close;
end;

procedure TForm18.Button3Click(Sender: TObject);
var aaa,bbb:tdatetime;
begin
   aaa:=strtodatetime(datetimetostr(date-1)+' '+'8:30:00');
   bbb:=strtodatetime(datetimetostr(date)+' '+'8:30:00');
//  label2.Caption:=datetimetostr(aaa);
//  label3.Caption:=datetimetostr(bbb);
  form19.QR_date.Caption:=datetimetostr(date);
  form19.QR_xm.Caption:='日';
// cdma:=datetimetostr(date);
 form19.Q_accountprn.Active:=false;
 form19.Q_accountprn.Params.ParamValues['aaa']:=aaa;
 form19.Q_accountprn.params.paramvalues['bbb']:=bbb;
 // form19.Q_accountprn.SQL.Clear;
// FORM19.Q_accountprn.Filter:='Endtime between '''+aaa+''' and '''+bbb+'''';
// form19.Q_accountprn.Filtered:=true;
// form19.Q_accountprn.SQL.Add('select * from H_sn_Account where Endtime between '''+#aaa#+'''  and #'+bbb+'# order by accountno');
 form19.Q_accountprn.Active:=true;
 form19.QuickRep1.Preview;
end;

procedure TForm18.Button2Click(Sender: TObject);
var aaa,bbb:tdatetime;
begin
   aaa:=strtodatetime(datetimetostr(date-1)+' '+'8:30:00');
   bbb:=strtodatetime(datetimetostr(date)+' '+'8:30:00');
  form20.QR_date.Caption:=datetimetostr(date);
  form20.QR_xm.Caption:='日';
//  form20.bbr.Caption:=form2.
// cdmb:=datetimetostr(date);
  form20.Q_h_sn_DinList.Active:=False;
  form20.Q_h_sn_DinList.Params.ParamValues['aaa']:=aaa;
  form20.Q_h_sn_DinList.Params.ParamValues['bbb']:=bbb;
//  form20.Q_h_sn_DinList.SQL.Clear;
//  form20.Q_h_sn_DinList.SQL.Add('select * from H_Sn_DinList where cstr(EndTime) between '''+aaa+''' and '''+bbb+''' order by accountno');
  form20.Q_h_sn_DinList.Active:=True;
  form20.QuickRep1.Preview;

  end;

end.