unit RealtyC6211;

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_RealtyC6211 = class(TForm)
    Label1: TLabel;
    Edit2: TEdit;
    Label4: TLabel;
    Button5: TButton;
    Button7: TButton;
    edit1: 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);
    procedure edit1Select(Sender: TObject);

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

var
  f_RealtyC6211: Tf_RealtyC6211;
implementation
uses data, main,RealtyC621,Car4s931;
{$R *.dfm}

//Initial******************************
procedure Tf_RealtyC6211.FormCreate(Sender: TObject);
var
    query:TADOQuery;
begin
    query:=TADOQuery.Create(nil);
    query.Connection:=DataModuleADO.ADOConnection1;

    edit1.Items.add('新增保證金項目');
    query.SQL.add('select * from 輔助資料 where 類別='''+'保證金項目'+'''');
    query.Open;
    while not query.eof do
    begin
        edit1.Items.Add(query.fieldbyname('名稱').value);
        query.next;
    end;
    query.close;
    query.Free;
    
    if f_RealtyC621.bMod then
    begin
        with f_RealtyC621.ListView1.Selected do
        begin
            edit1.ItemIndex:=edit1.Items.IndexOf(caption);
            edit2.Text:=subitems[0];
        end;
    end;
end;



//Tab****************************************
procedure Tf_RealtyC6211.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_RealtyC6211.FormClose(Sender: TObject; var Action: TCloseAction);
begin
    Action := caFree;
end;

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

procedure Tf_RealtyC6211.Button7Click(Sender: TObject);
begin
    if edit1.Text='' then
    begin
        showmessage('保證金項目不能為空!');
        edit1.SetFocus;
        exit;
    end;
    if edit2.Text='' then
    begin
        showmessage('金額不能為空!');
        edit2.SetFocus;
        exit;
    end;

    if f_RealtyC621.bMod then
    begin
        f_RealtyC621.Edit5.Text:=mainform.StdDou2(edit2.text);

        with f_RealtyC621.ListView1.selected do
        begin
            Caption:=edit1.Text;
            SubItems[0]:=mainform.StdDou2(edit2.text);

        end;
        close;
    end
    else
    begin
        f_RealtyC621.Edit5.Text:=mainform.StdDou2(edit2.text);

        with f_RealtyC621.ListView1.Items.Add do
        begin
            Caption:=edit1.Text;
            SubItems.Add(mainform.StdDou2(edit2.text));

        end;
        if  f_RealtyC621.ListView1.Items.Count>0 then f_RealtyC621.ListView1.Items.Item[0].Selected:=true;
        edit1.ItemIndex:=edit1.Items.IndexOf('');
        edit2.text:='';

    end;
end;

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

procedure Tf_RealtyC6211.edit1Select(Sender: TObject);
begin
    if edit1.Text='新增保證金項目' then
    begin
        mainform.t1:='保證金項目';
        f_Car4s931:=Tf_Car4s931.Create(self);
        f_Car4s931.showmodal;

        if f_Car4s931.bOK=true then
        begin
            edit1.Items.Add(mainform.t1);
            edit1.ItemIndex:=edit1.Items.IndexOf(mainform.t1);
        end
        else edit1.ItemIndex:=edit1.Items.IndexOf('');
    end;
end;

end.