unit gyscz;

interface

uses Windows, SysUtils, Classes, Graphics, Forms, Controls, StdCtrls, 
  Buttons, ExtCtrls, Grids, DBGrids, Mask, DBCtrlsEh, DBLookupEh,Variants;

type
  Tcxgysfrm = class(TForm)
    Panel1: TPanel;
    OKBtn: TButton;
    CancelBtn: TButton;
    DBGrid1: TDBGrid;
    Label1: TLabel;
    dblk_dq: TDBLookupComboboxEh;
    Label2: TLabel;
    Edit1: TEdit;
    Panel2: TPanel;
    Button1: TButton;
    Button2: TButton;
    procedure dblk_dqChange(Sender: TObject);
    procedure Edit1KeyUp(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure DBGrid1DblClick(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  cxgysfrm: Tcxgysfrm;

implementation
uses data, khzl, gyswh;

{$R *.dfm}

procedure Tcxgysfrm.dblk_dqChange(Sender: TObject);
begin
dm.whgysdmads.Filtered:=false;
edit1.Text:='';
if dblk_dq.KeyValue <> null then
begin
dm.whgysdmads.Filter:='地區(qū)='+''''+dblk_dq.KeyValue+'''';
dm.whgysdmads.Filtered:=TRUE;
end;
end;

procedure Tcxgysfrm.Edit1KeyUp(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  dblk_dq.OnChange:=nil;
  dblk_dq.KeyValue:=null;
  dblk_dq.OnChange:=cxgysfrm.dblk_dqChange;
  dm.whgysdmads.Filtered:=false;
  if trim(edit1.Text)<>'' then
  begin
    dm.whgysdmads.Filter:='供應(yīng)商id LIKE '+''''+trim(edit1.Text)+'%'+'''';
    dm.whgysdmads.Filtered:=TRUE;
  end;
end;

procedure Tcxgysfrm.DBGrid1DblClick(Sender: TObject);
begin
  ModalResult := mrOK;
end;

procedure Tcxgysfrm.FormCreate(Sender: TObject);
begin
dm.zlcxads_dq.Close;
dm.zlcxads_dq.CommandText:=' select  地區(qū) from 供應(yīng)商 group by 地區(qū)';
dm.zlcxads_dq.Open;
end;

procedure Tcxgysfrm.FormClose(Sender: TObject; var Action: TCloseAction);
begin
action := cafree;
cxgysfrm:=nil;
end;

procedure Tcxgysfrm.Button1Click(Sender: TObject);
begin
if not Assigned(gyswhfrm) then
  gyswhfrm := tgyswhfrm.Create(Self);
  dm.whgysdmads.Edit;
  gyswhfrm.ShowModal;
end;

procedure Tcxgysfrm.Button2Click(Sender: TObject);
begin
if not Assigned(gyswhfrm) then
  gyswhfrm := tgyswhfrm.Create(Self);
  dm.whgysdmads.insert;
  gyswhfrm.ShowModal;
end;

end.