unit MC_CNFCSH;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  Grids, DBGrids, Db, StdCtrls, Mask, DBCtrls, DBTables, Buttons;

type
  TCNFCSH = class(TForm)
    Table1: TTable;
    Table1BDEDesigner: TStringField;
    Table1BDEDesigner2: TFloatField;
    Label1: TLabel;
    DBEdit1: TDBEdit;
    DataSource1: TDataSource;
    Label2: TLabel;
    DBEdit2: TDBEdit;
    DBGrid1: TDBGrid;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    BitBtn3: TBitBtn;
    Query1: TQuery;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure DBEdit1Enter(Sender: TObject);
    procedure DBEdit1Exit(Sender: TObject);
    procedure DBEdit1KeyPress(Sender: TObject; var Key: Char);
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  CNFCSH: TCNFCSH;

implementation

{$R *.DFM}

procedure TCNFCSH.FormClose(Sender: TObject; var Action: TCloseAction);
begin
     CNFCSH.Release;
     CNFCSH:=Nil;
end;

procedure TCNFCSH.DBEdit1Enter(Sender: TObject);
begin
     TDBEdit(Sender).Color:=ClAqua;
end;

procedure TCNFCSH.DBEdit1Exit(Sender: TObject);
begin
     TDBEdit(Sender).Color:=CLwindow;
end;

procedure TCNFCSH.DBEdit1KeyPress(Sender: TObject; var Key: Char);
begin
     if key=#13 then PerForm(WM_NEXTDLGCTL,0,0);
end;

procedure TCNFCSH.BitBtn1Click(Sender: TObject);
begin
     if BitBtn1.Caption='添加[&I]' then
        begin
             Bitbtn1.Caption:='保存[&S]';
             BitBtn2.Caption:='取消[&U]';
             DBGrid1.Enabled:=False;
             Table1.Append;
             DBEdit1.SEtFocus;
        end
     else
        begin
             BitBtn1.Caption:='添加[&I]';
             BitBtn2.Caption:='刪除[&D]';
             DBGrid1.Enabled:=True;
             Table1.Post;
        end;
end;

procedure TCNFCSH.BitBtn2Click(Sender: TObject);
begin
     if BitBtn1.Caption='刪除[&D]' then
        begin
             if Table1.RecordCount<>0 then
                Table1.Delete;
        end
     else
        begin
             BitBtn1.Caption:='添加[&I]';
             BitBtn2.Caption:='刪除[&D]';
             DBGrid1.Enabled:=True;
             Table1.Cancel;
        end;
end;

procedure TCNFCSH.BitBtn3Click(Sender: TObject);
begin
     Query1.Close;
     Query1.SQL.Clear;
     Query1.SQL.Add('update 采暖費 set 采暖費標準=:A,應收金額=:B * 建筑面積');
     Query1.ParamByName('A').AsFloat:=Table1.FieldByName('金額').AsFloat;
     Query1.ParambyName('B').AsFloat:=Table1.FieldByName('金額').AsFloat;
     Query1.ExecSQL;
     ShowMessage('更新完畢');
end;

end.