unit khzlcz;

interface

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

type
  Tfrm_khzlcz = 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
  frm_khzlcz: Tfrm_khzlcz;

implementation
uses data, khzl;                 // Variants #null

{$R *.dfm}

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

procedure Tfrm_khzlcz.Edit1KeyUp(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  dblk_dq.OnChange:=nil;
  dblk_dq.KeyValue:=null;
  dblk_dq.OnChange:=frm_khzlcz.dblk_dqChange;
  dm.zlads_khzl.Filtered:=false;
  if trim(edit1.Text)<>'' then
  begin
    dm.zlads_khzl.Filter:='客戶id LIKE '+''''+trim(edit1.Text)+'%'+'''';
    dm.zlads_khzl.Filtered:=TRUE;
  end;
end;

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

procedure Tfrm_khzlcz.FormCreate(Sender: TObject);
begin
dm.zlcxads_dq.Close;
dm.zlcxads_dq.CommandText:=' select  地區 from 客戶 group by 地區';
dm.zlcxads_dq.Open;
end;

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

procedure Tfrm_khzlcz.Button1Click(Sender: TObject);
begin
if not Assigned(frm_khzl) then
  frm_khzl := tfrm_khzl.Create(Self);
  dm.zlads_khzl.Edit;
  frm_khzl.ShowModal;
end;

procedure Tfrm_khzlcz.Button2Click(Sender: TObject);
begin
if not Assigned(frm_khzl) then
  frm_khzl := tfrm_khzl.Create(Self);
  dm.zlads_khzl.insert;
  frm_khzl.ShowModal;
end;

end.