unit RealtyH12A;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, dbcgrids, Grids, DBGrids, DB, ADODB, StdCtrls, Buttons, ExtCtrls,
  StrUtils, ExtDlgs, ComCtrls, math, ToolWin, ImgList, Menus;

type
    Tf_RealtyH12A = class(TForm)
    Button5: TButton;
    Button7: TButton;
    Label1: TLabel;
    ComboBox1: TComboBox;
    procedure FormKeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormCreate(Sender: TObject);
    procedure ToolButton10Click(Sender: TObject);
    procedure Button7Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);

  private
    { Private declarations }
  public
    { Public declarations }
     bMod:bool;
     sTable:string;
     cols:integer;
  end;


var
  f_RealtyH12A: Tf_RealtyH12A;
implementation
uses data, main,RealtyH12,RealtyA14,RealtyC42;
{$R *.dfm}
//Initial******************************
procedure Tf_RealtyH12A.FormCreate(Sender: TObject);
Var
    query:TADOQuery;
    s1:string;
begin
    Query:=TADOQuery.Create(nil);
    Query.Connection:=DataModuleADO.ADOConnection1;

    query.SQL.Add('select * from 綠化項目');
    query.Open;
    while not query.Eof do
    begin
        combobox1.Items.Add(query.fieldbyname('名稱').Value);
        query.next;
    end;
    if f_RealtyH12.bNew=false then
    begin
        with f_RealtyH12.ListView1.Selected do
        begin
            combobox1.ItemIndex:=combobox1.Items.IndexOf(caption);
        end;
    end;
end;


//Tab****************************************
procedure Tf_RealtyH12A.FormKeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
    if key=13 then
        Begin
            key:=0;
            perform(WM_NEXTDLGCTL,0,0);
        end
    else if key=VK_ESCAPE then close;
end;

//FreeForm**********************************
procedure Tf_RealtyH12A.FormClose(Sender: TObject; var Action: TCloseAction);
begin
    Action := caFree;
end;

//Close*************************************
procedure Tf_RealtyH12A.ToolButton10Click(Sender: TObject);
begin
     close;
end;

procedure Tf_RealtyH12A.Button7Click(Sender: TObject);
Var
    query,query1:TADOQuery;
    s,s1:string;
    i,j:integer;
begin
    if combobox1.Text='' then
    begin
        showmessage('項目不能為空!');
        combobox1.SetFocus;
        exit;
    end;

    if f_RealtyH12.bNew=false then
    begin
        with f_RealtyH12.ListView1.selected do
        begin
            Caption:=combobox1.Text;
        end;
        close;
    end
    else
    begin
        with f_RealtyH12.ListView1.Items.Add do
        begin
            Caption:=combobox1.Text;
        end;
        if  f_RealtyH12.ListView1.Items.Count>0 then f_RealtyH12.ListView1.Items.Item[0].Selected:=true;
        combobox1.ItemIndex:=combobox1.Items.IndexOf('');;

    end;

end;

procedure Tf_RealtyH12A.Button5Click(Sender: TObject);
begin
    close;
end;

end.