unit RealtyC25AA;

interface

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

type
    Tf_RealtyC25AA = class(TForm)
    L1: TLabel;
    Label2: TLabel;
    Label1: TLabel;
    Button7: TButton;
    Button5: TButton;
    CheckBox1: TCheckBox;
    ComboBox1: TComboBox;
    DateTimePicker1: TDateTimePicker;
    procedure FormKeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure FormCreate(Sender: TObject);
    procedure Button7Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure CheckBox1Click(Sender: TObject);

  private
    { Private declarations }
  public
    { Public declarations }
       bOK:bool;
       T:string;
  end;

var
  f_RealtyC25AA: Tf_RealtyC25AA;
  sNum:string;

implementation

uses data, main,RealtyC25A,RealtyC25;

{$R *.dfm}


procedure Tf_RealtyC25AA.FormCreate(Sender: TObject);
var
    i:integer;
    s,s1,s2:string;
    query:TADOQuery;
begin
    query:=TADOQuery.Create(nil);
    query.Connection:=datamoduleado.ADOConnection1;

    query.SQL.Add('select * from 收費項目 where 名稱='''+f_RealtyC25A.ListView1.Selected.subitems[1]+'''');
    query.Open;
    if query.RecordCount>0 then
    begin
        s1:=query.fieldbyname('編號').Value;

        query.SQL.clear;
        query.SQL.Add('select * from 管理區 where 名稱='''+f_RealtyC25.TreeView1.Selected.Text+'''');
        query.open;
        if query.RecordCount>0 then s2:=query.fieldbyname('編號').value;


        query.SQL.clear;
        query.SQL.Add('select * from 樓宇 where 名稱='''+f_RealtyC25.TreeView1.Selected.Text+'''');
        query.open;
        if query.RecordCount>0 then s2:=query.fieldbyname('管理區').value;

        query.SQL.Clear;
        query.SQL.Add('select * from 收費標準 where 收費項目='''+s1+''' and 管理區='''+s2+'''');
        query.Open;
        while not query.Eof do
        begin
            combobox1.Items.Add(query.fieldbyname('編號').Value+'--'+query.fieldbyname('名稱').Value);
            query.Next;
        end;
    end;

    query.close;
    query.free;


    if f_RealtyC25A.bNew=false then
    begin
        if f_RealtyC25A.ListView1.Selected.subitems[2]='Y' then   checkbox1.Checked:=true
        else checkbox1.Checked:=false;
        combobox1.ItemIndex:=combobox1.Items.IndexOf(f_RealtyC25A.ListView1.Selected.subitems[3]);
        datetimepicker1.Date:=strtodate(f_RealtyC25A.ListView1.Selected.subitems[4]);
    end;
end;

//Tab
procedure Tf_RealtyC25AA.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;

procedure Tf_RealtyC25AA.Button7Click(Sender: TObject);
var
    s,s1:string;
begin
    if checkbox1.Checked=false  then exit;
    if f_RealtyC25A.bNew=true then
    begin
        f_RealtyC25A.ListView1.Selected.SubItems[2]:='Y';
        f_RealtyC25A.ListView1.Selected.SubItems[3]:=combobox1.Text;
        f_RealtyC25A.ListView1.Selected.SubItems[4]:=datetostr(datetimepicker1.Date);
        close;
    end;

    if f_RealtyC25A.bNew=false then
    begin
        f_RealtyC25A.ListView1.Selected.SubItems[2]:=s1;
        f_RealtyC25A.ListView1.Selected.SubItems[3]:=combobox1.Text;
        f_RealtyC25A.ListView1.Selected.SubItems[4]:=datetostr(datetimepicker1.Date);
        close;
    end;

end;

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

procedure Tf_RealtyC25AA.CheckBox1Click(Sender: TObject);
begin
    if checkbox1.Checked=true then
    begin
        combobox1.Enabled:=true;
        datetimepicker1.Enabled:=true;
    end
    else
    begin
        combobox1.Items.clear;
        combobox1.Enabled:=false;
        datetimepicker1.Enabled:=false;
    end;
end;

end.