unit RealtyE411A;

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_RealtyE411A = class(TForm)
    L1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label9: TLabel;
    Edit2: TEdit;
    Edit1: TEdit;
    Edit6: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    Label5: TLabel;
    Button1: TButton;
    Button2: TButton;
    Button7: TButton;
    Button5: TButton;
    Label1: TLabel;
    procedure FormKeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure FormCreate(Sender: TObject);
    procedure ToolButton2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Edit4Exit(Sender: TObject);
    procedure Button7Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);


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

var
  f_RealtyE411A: Tf_RealtyE411A;
  sNum:string;

implementation

uses data, main,RealtyE41A,realtyC21,RealtyE11;

{$R *.dfm}

//Initial**************************************
procedure Tf_RealtyE411A.FormCreate(Sender: TObject);
var
    query:TADOQuery;
    s1:string;
begin
    if f_RealtyE41A.bMod then
    begin
         with f_realtyE41A.ListView1.Selected do
         begin
              edit1.Text:=Caption+'--'+mainform.getName('房間',caption);

              edit2.Text:=subitems[0];
              edit4.Text:=subitems[1];
              edit5.Text:=subitems[2];
              edit6.Text:=subitems[3];
         end;
    end;
end;

//Tab******************************************
procedure Tf_RealtyE411A.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_RealtyE411A.ToolButton2Click(Sender: TObject);
begin
    Close;
end;

procedure Tf_RealtyE411A.Button1Click(Sender: TObject);
begin
    f_realtyC21:=Tf_realtyC21.Create(self);
    f_realtyC21.ToolButton1.Visible:=true;
    f_realtyC21.ShowModal;

    if  f_realtyC21.bOk=true then
    begin
        edit2.text:=f_realtyC21.snum;
    end;
end;

procedure Tf_RealtyE411A.Button2Click(Sender: TObject);
var
    query,query1:TADOQuery;
    s,s1,s2,s3:string;
begin
    Query:=TADOQuery.Create(nil);
    Query.Connection:=DataModuleADO.ADOConnection1;
    Query1:=TADOQuery.Create(nil);
    Query1.Connection:=DataModuleADO.ADOConnection1;

    f_RealtyE11:=Tf_RealtyE11.Create(self);
    f_RealtyE11.Button10.Visible:=true;
    f_RealtyE11.Button5.Enabled:=false;
    f_RealtyE11.Button2.Enabled:=false;
    f_RealtyE11.Button7.Enabled:=false;

    f_RealtyE11.listview1.items.clear;

    s:='select * from 房間 where 可租='''+'Y'+''' and 是否已租='''+'N'+'''';
    query.SQL.Add(s);
    query.Open;
    while not query.Eof do
    begin
        query1.SQL.Clear;
        query1.SQL.Add('select * from 管理區 where 編號='''+query.fieldbyname('管理區').Value+'''');
        query1.Open;
        if query1.RecordCount>0 then  s1:=query.fieldbyname('名稱').Value;

        query1.SQL.Clear;
        query1.SQL.Add('select * from 樓宇 where 編號='''+query.fieldbyname('樓宇').Value+'''');
        query1.Open;
        if query1.RecordCount>0 then s2:=query.fieldbyname('名稱').Value;
        with f_RealtyE11.listview1.Items.Add do
        begin
            Caption:=Query.FieldByName('編號').Value;
            SubItems.Add(s1);
            SubItems.Add(s2);
            SubItems.Add(Query.FieldByName('單元號').Value);
            SubItems.Add(Query.FieldByName('樓層號').Value);
            SubItems.Add(Query.FieldByName('名稱').Value);
            SubItems.Add(Query.FieldByName('房型').Value);
            SubItems.Add(Query.FieldByName('朝向').Value);
            SubItems.Add(Query.FieldByName('建筑面積').Value);
            SubItems.Add(Query.FieldByName('使用面積').Value);
            SubItems.Add(Query.FieldByName('裝修情況').Value);
            SubItems.Add(Query.FieldByName('配套設施').Value);
            SubItems.Add(Query.FieldByName('權屬類型').Value);

            SubItems.Add(Query.FieldByName('租賃單價').Value);
            SubItems.Add(Query.FieldByName('租賃金額').Value);
            SubItems.Add(Query.FieldByName('是否已租').Value);
            SubItems.Add(Query.FieldByName('可租').Value);
        end;
        query.next;
    end;
    if f_RealtyE11.listview1.Items.Count > 0 then f_RealtyE11.ListView1.Items.Item[0].Selected := True;

    f_RealtyE11.ShowModal;

    if  f_RealtyE11.bOk=true then
    begin
        edit1.Text:=f_RealtyE11.sNum+'--'+f_RealtyE11.sName;
        edit6.Text:=mainform.StdDou2(f_RealtyE11.ListView1.Selected.SubItems[7])
    end;      

    query.Close;
    query.Free;
    query1.Close;
    query1.Free;

end;

procedure Tf_RealtyE411A.Edit4Exit(Sender: TObject);
begin
    edit4.Text:=mainform.StdDou2(edit4.text);
    edit6.Text:=mainform.StdDou2(edit6.text);
    edit5.Text:=floattostr(strtofloat(edit4.Text)*strtofloat(edit6.Text));
end;

procedure Tf_RealtyE411A.Button7Click(Sender: TObject);
var
   s,s1:string;
   i:integer;
   bExist:bool;
begin
    s1:=mainform.getnum(edit1.Text);
   if Edit1.Text='' then
   begin
      showMessage('請輸入房間!');
      Edit1.SetFocus;
      exit;
   end;

   if Edit2.Text='' then
   begin
       showMessage('請輸入收費項目!');
       Edit2.SetFocus;
       exit;
   end;

   if Edit4.Text='' then Edit4.Text:='0';

   if f_RealtyE41A.bmod then
   begin
       with f_RealtyE41A.ListView1.Selected do
       begin
            Caption:=s1;
            subitems[0]:=edit2.Text;
            subitems[1]:=mainform.StdDou2(edit4.Text);
            subitems[2]:=mainform.StdDou2(edit5.Text);
            subitems[3]:=mainform.StdDou2(edit6.Text);
       end;
   end
   else
   begin
       with f_RealtyE41A.ListView1.Items.Add do
       begin
            Caption:=s1;
            subitems.Add(edit2.Text);
            subitems.Add(mainform.StdDou2(edit4.Text));
            subitems.Add(mainform.StdDou2(edit5.Text));
            subitems.Add(mainform.StdDou2(edit6.Text));
       end;
   end;
   if f_RealtyE41A.ListView1.Items.Count>0 then f_RealtyE41A.ListView1.Items.Item[0].Selected:=true;

   edit1.Text:='';
   edit2.Text:='';
   edit4.Text:='';
   edit5.Text:='';
   edit6.Text:='';
end;

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

end.