datasearch.~pa

一套融入了系统营销管理思想的管理软件产品

unit DataSearch;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  BaseDialog, Db, StdCtrls, Buttons, Grids, DBGrids, DBTables;

type
  TfmDataSearch = class(TfmBaseDialog)
    EDA: TEdit;
    Label1: TLabel;
    EDB: TComboBox;
    Label2: TLabel;
    dsTemp: TDataSource;
    cbFieldName: TComboBox;
    EDC: TCheckBox;
    procedure gdBrowseDblClick(Sender: TObject);
    procedure FormActivate(Sender: TObject);
    procedure EDAChange(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;
var
  fmDataSearch: TfmDataSearch;

implementation

uses Loading, PublicFunction;

{$R *.DFM}

procedure TfmDataSearch.gdBrowseDblClick(Sender: TObject);
begin
  inherited;
  ModalResult:= mrOK;
end;

procedure TfmDataSearch.FormActivate(Sender: TObject);
var
  i : Integer;
begin
  for i := 0 to dsTemp.DataSet.FieldCount - 1 do
  begin
    if dsTemp.DataSet.Fields[i].Tag = 1 then
      Continue;
    EDB.Items.Add(dsTemp.DataSet.Fields[i].DisplayLabel);
    cbFieldName.Items.Add(IntToStr(i));
  end;
  EDB.DropDownCount := dsTemp.DataSet.FieldCount;
  EDB.ItemIndex := 0;
end;

procedure TfmDataSearch.EDAChange(Sender: TObject);
var
  iLocation : Integer;
begin
  inherited;
  iLocation := StrToInt(cbFieldName.Items[EDB.ItemIndex]);
  if VarType(dsTemp.DataSet.Fields[iLocation].Value) <> varDouble then
      dsTemp.DataSet.Locate(dsTemp.DataSet.Fields[iLocation].FieldName,
                            StrToFloat(EDA.Text), [])
  else
  begin
    if EDC.Checked then
      dsTemp.DataSet.Locate(dsTemp.DataSet.Fields[iLocation].FieldName,
                            LeftStr(EDA.Text, dsTemp.DataSet.Fields[iLocation].Size),
                            [loCaseInsensitive])
    else
      dsTemp.DataSet.Locate(dsTemp.DataSet.Fields[iLocation].FieldName,
                            LeftStr(EDA.Text, dsTemp.DataSet.Fields[iLocation].Size),
                            [loCaseInsensitive, loPartialKey]);
  end;
end;

end.