report1.~pas

来自「OPC 源程序示例」· ~PAS 代码 · 共 61 行

unit report1;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, DB, PrnDbgeh, DBSumLst, ADODB, GridsEh, DBGridEh,
  ComCtrls, Mask, DBCtrlsEh;

type
  Tfrmreprt1 = class(TForm)
    DBGridEh1: TDBGridEh;
    ADOT_OneTimeDataValues: TADOTable;
    ADOT_TagName: TADOTable;
    ADOConnection1: TADOConnection;
    PrintDBGridEh1: TPrintDBGridEh;
    DataSource1: TDataSource;
    Label1: TLabel;
    DateTimePicker1: TDateTimePicker;
    Label2: TLabel;
    DBGridEh2: TDBGridEh;
    procedure DateTimePicker1Change(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure FormShow(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmreprt1: Tfrmreprt1;

implementation

{$R *.dfm}

procedure Tfrmreprt1.DateTimePicker1Change(Sender: TObject);
begin

    ADOT_OneTimeDataValues.Close;
    ADOT_OneTimeDataValues.Open;
    ADOT_OneTimeDataValues.Filtered :=false;
    ADOT_OneTimeDataValues.Filter :='';
    ADOT_OneTimeDataValues.Filter :='sj>='+'#'+datetimetoStr(DateTimePicker1.Date )+'#'+' and sj<='+'#'+datetimetoStr(DateTimePicker1.Date+1)+'#';
    ADOT_OneTimeDataValues.Filtered :=true;
end;

procedure Tfrmreprt1.FormCreate(Sender: TObject);
begin
   DateTimePicker1.Date :=date;
   DateTimePicker1Change(Sender);
end;

procedure Tfrmreprt1.FormShow(Sender: TObject);
begin
   DateTimePicker1Change(Sender);
end;

end.