report.pas

delphi+sql server 我是delphi的初学者

unit report;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, frxClass, StdCtrls, ComCtrls, ExtCtrls;

type
  Tfrmreport = class(TForm)
    Panel1: TPanel;
    Panel2: TPanel;
    Button1: TButton;
    Button2: TButton;
    DateTimePicker1: TDateTimePicker;
    DateTimePicker2: TDateTimePicker;
    Cdd: TComboBox;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Czt: TComboBox;
    Label4: TLabel;
    procedure Button2Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmreport: Tfrmreport;

implementation
uses UDM,UnitXGCT;
{$R *.dfm}

procedure Tfrmreport.Button2Click(Sender: TObject);
begin
 close;
end;

procedure Tfrmreport.FormShow(Sender: TObject);
begin
  Cdd.Text:='';
  Czt.Text:='';
  with dm.qrytemp do
  begin
    close;
    sql.Clear;
    sql.Add('select * from ly_place');
    prepared;
    open;
  end;
  Cdd.Items.Clear;
  while not dm.qrytemp.Eof do
  begin
    Cdd.Items.Append(dm.qrytemp.Fields[2].asstring);
    dm.qrytemp.Next;
  end;

   with dm.qrytemp do
     begin
       Close;
       SQL.Clear;
       SQL.Add('select djzt from meun_zt');
       Prepared;
       Open;
     end;
    Czt.Items.Clear;
    while not dm.qrytemp.Eof do
      begin
        Czt.Items.Append(dm.qrytemp.Fields[0].AsString);
        DM.qrytemp.Next;
      end;

  DateTimePicker1.Date:=Date;
  DateTimePicker2.Date:=Date;
end;

procedure Tfrmreport.Button1Click(Sender: TObject);
begin
  FormXGCT:=TFormXGCT.Create(Self);
  with dm.ADObb do
   begin
     Close;
     SQL.Clear;
     SQL.Add('select * from libnumberls');
     SQL.Add('where rq between :krq and :jrq');
     Parameters.ParamByName('krq').Value:=DateTimePicker1.Date;
     Parameters.ParamByName('jrq').Value:=DateTimePicker2.Date;
    if Cdd.Text<>'' then
     begin
       SQL.Add('and libnumberplace like :place');
       Parameters.ParamByName('place').Value:='%'+cdd.Text+'%';
     end
     else
    if Czt.Text<>'' then
     begin
       SQL.Add('and zt like :type');
       Parameters.ParamByName('type').Value:='%'+czt.Text+'%';
     end;
     Prepared;
     Open;
   end;
   FormXGCT.QuickRep1.Preview;
   FreeAndNil(FormXGCT);
end;

end.