extract1rep.pas

专家抽取系统1.0 是用Delphi6.0 开发的一款用于招投标,评审过程中从专家库中抽取专家的软件。可以将抽取结果导入到Excel或Word文档中

unit Extract1Rep;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ExtCtrls, QuickRpt, QRCtrls, DB, ADODB;

type
  TfrmExtract1Rep = class(TForm)
    QuickRep1: TQuickRep;
    ADOTable1: TADOTable;
    ColumnHeaderBand1: TQRBand;
    DetailBand1: TQRBand;
    QRLabel1: TQRLabel;
    PageFooterBand1: TQRBand;
    QRLabel2: TQRLabel;
    ADOQuery1: TADOQuery;
    QRDBText1: TQRDBText;
    QRDBText2: TQRDBText;
    QRDBText3: TQRDBText;
    QRDBText4: TQRDBText;
    QRDBText5: TQRDBText;
    QRDBText6: TQRDBText;
    QRDBText7: TQRDBText;
    QRLabel3: TQRLabel;
    QRLabel4: TQRLabel;
    QRLabel5: TQRLabel;
    QRLabel6: TQRLabel;
    QRLabel7: TQRLabel;
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmExtract1Rep: TfrmExtract1Rep;

implementation

uses Main,Extract1;
{$R *.dfm}

procedure TfrmExtract1Rep.FormCreate(Sender: TObject);
begin
  {ExtractFilePath函数从一个完整的文件名中分离出路径，以'\'结束，
   Application.ExeName得到程序执行文件本身的文件名，}

  ADOTable1.Close;
//  ADOTable1.Connection:=frmExtract1.ADOConnection1;
  ADOTable1.Connection:=frmMain.ADOConnection1;
  ADOTable1.TableName:='Expert';  //数据表名称！
  ADOTable1.Filtered :=true;
  ADOTable1.Open;       //打开数据库表

end;

end.