unit yskhz1;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  ExtCtrls, Db, dxDBTLCl, dxGrClms, dxTL, dxDBCtrl, dxDBGrid, dxCntner,
  ADODB, StdCtrls, dxPSCore, dxPSdxTLLnk, dxPSdxDBCtrlLnk, dxPSdxDBGrLnk,
  ComCtrls;

type
  Tyskhz = class(TForm)
    Query1: TADOQuery;
    DataSource1: TDataSource;
    dxDBGrid1: TdxDBGrid;
    dxDBGrid1code: TdxDBGridMaskColumn;
    dxDBGrid1kdrq: TdxDBGridDateColumn;
    dxDBGrid1kdr: TdxDBGridMaskColumn;
    dxDBGrid1fplx: TdxDBGridMaskColumn;
    dxDBGrid1KH: TdxDBGridMaskColumn;
    dxDBGrid1khname: TdxDBGridMaskColumn;
    dxDBGrid1ck: TdxDBGridMaskColumn;
    dxDBGrid1zje: TdxDBGridMaskColumn;
    dxDBGrid1yfje: TdxDBGridMaskColumn;
    dxDBGrid1ce: TdxDBGridMaskColumn;
    dxDBGrid1ywy: TdxDBGridMaskColumn;
    dxDBGrid1ywyname: TdxDBGridMaskColumn;
    dxDBGrid1bz: TdxDBGridMaskColumn;
    Query1code: TStringField;
    Query1kdrq: TDateTimeField;
    Query1kdr: TStringField;
    Query1fplx: TStringField;
    Query1KH: TStringField;
    Query1khname: TStringField;
    Query1ck: TStringField;
    Query1zje: TBCDField;
    Query1yfje: TBCDField;
    Query1ce: TBCDField;
    Query1ywy: TStringField;
    Query1ywyname: TStringField;
    Query1bz: TStringField;
    Panel1: TPanel;
    Label1: TLabel;
    Edit1: TEdit;
    Label2: TLabel;
    DateTimePicker1: TDateTimePicker;
    Label3: TLabel;
    DateTimePicker2: TDateTimePicker;
    Button1: TButton;
    Button2: TButton;
    dxComponentPrinter1: TdxComponentPrinter;
    dxComponentPrinter1Link1: TdxDBGridReportLink;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormCreate(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  yskhz: Tyskhz;

implementation

uses MainForm1;

{$R *.DFM}

procedure Tyskhz.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  Action := cafree;
end;

procedure Tyskhz.FormCreate(Sender: TObject);
begin
  DateTimePicker1.DateTime := MainForm.DateTimePicker2.DateTime;
  DateTimePicker2.DateTime := MainForm.DateTimePicker1.DateTime;
end;

procedure Tyskhz.Button1Click(Sender: TObject);
var aa: string;
begin
  if Edit1.Text = '' then aa := '%' else aa := Edit1.Text;
  Query1.close;
  Query1.Parameters[0].Value := aa;
  Query1.Parameters[1].Value := DateTimePicker1.date;
  Query1.Parameters[2].Value := DateTimePicker2.date;
  Query1.open;
end;

procedure Tyskhz.Button2Click(Sender: TObject);
begin
  dxComponentPrinter1.Preview(true, nil);
end;

end.