uzyhzb.pas

行业应急系统 包括: 应急系统（待遇核发） 发放系统 开发环境:Delphi5 (sp1)+ Oracle 8.05 MultiExport是一个可以将数据按指定字段倒出

unit uZYHZB;

interface

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

type
  TfrmZYHZB = class(TfrmPrintTemp)
    lblZYBH: TLabel;
    edtZYBH: TEdit;
    procedure btnPreviewClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmZYHZB: TfrmZYHZB;

implementation

uses uZYHZB_1, uCommon;

{$R *.DFM}

procedure TfrmZYHZB.btnPreviewClick(Sender: TObject);
begin
  inherited;
  if Assigned(frmZYHZB_1) then
    frmZYHZB_1 := nil;

  frmZYHZB_1 := TfrmZYHZB_1.Create(Self);
  try
    frmZYHZB_1.qryReport.SQL.Clear;
    frmZYHZB_1.qryReport.SQL.Add('SELECT * FROM tsbgxzyhz_rep');
    frmZYHZB_1.qryReport.SQL.Add('WHERE ZYBH=''' + Trim(edtZYBH.Text) + '''');
    frmZYHZB_1.qryReport.Open;
    if frmZYHZB_1.qryReport.RecordCount <> 0 then
      frmZYHZB_1.QuickRep1.Preview
    else
    begin
      gfShowError('没有找到指定编号的转移数据');
    end;
  finally
    frmZYHZB_1.Free;
  end;

end;

end.