lookupprocus.pas

产品信息系统!关于产品基础信息的系统!功能强大!

unit LookupProCus;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DailogBase, DB, ADODB, StdCtrls, Buttons, dxdbtrel;

type
  TfrmLookupProCus = class(TfrmDailogBase)
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    lblNO: TLabel;
    Label4: TLabel;
    edtCode: TEdit;
    edtName: TEdit;
    lktvArea: TdxDBLookupTreeView;
    btClear: TBitBtn;
    btOk: TBitBtn;
    btCancel: TBitBtn;
    QArea: TADOQuery;
    QAreafID: TAutoIncField;
    QAreafCode: TWideStringField;
    QAreafName: TWideStringField;
    QAreafParentID: TIntegerField;
    dsArea: TDataSource;
    procedure btClearClick(Sender: TObject);
    procedure btCancelClick(Sender: TObject);
    procedure btOkClick(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    sFilter: string;
    { Public declarations }
  end;

var
  frmLookupProCus   : TfrmLookupProCus;

implementation

{$R *.dfm}

procedure TfrmLookupProCus.btClearClick(Sender: TObject);
begin
  inherited;
  lktvArea.text := '';
  edtCode.text := '';
  edtName.text := '';
end;

procedure TfrmLookupProCus.btCancelClick(Sender: TObject);
begin
  inherited;
  //ModalResult:=mrCancel;
end;

procedure TfrmLookupProCus.btOkClick(Sender: TObject);
begin
  inherited;
  sFilter := ' Where';
  if Trim(lktvArea.text) <> '' then
  begin
    sFilter := sFilter + ' fAreaCode like ''' + QArea.FieldbyName('fCode').asString + '%''';
  end;
  if Trim(edtCode.text) <> '' then
  begin
    if sFilter <> ' Where' then sFilter := sFilter + ' and';
    if pos('%', edtCode.text) > 0 then
      sFilter := sFilter + ' fCode like ''' + Trim(edtCode.text) + ''''
    else
      sFilter := sFilter + ' fCode=''' + Trim(edtCode.text) + '''';
  end;
  if Trim(edtName.text) <> '' then
  begin
    if sFilter <> ' Where' then sFilter := sFilter + ' and';
    if pos('%', edtName.text) > 0 then
      sFilter := sFilter + ' fName like ''' + Trim(edtName.text) + ''''
    else
      sFilter := sFilter + ' fName=''' + Trim(edtName.text) + '''';
  end;

  if sFilter = ' Where' then sFilter := '';
  //ModalResult:=mrOk;
end;

procedure TfrmLookupProCus.FormCreate(Sender: TObject);
begin
  inherited;
  if not QArea.Active then QArea.Open;
end;

procedure TfrmLookupProCus.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
  //inherited;

end;

end.