unit closeTel;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DB, DBTables, StdCtrls, ExtCtrls, Buttons;

type
  TfrmCloseTel = class(TForm)
    ok: TBitBtn;
    Panel1: TPanel;
    Label1: TLabel;
    Label2: TLabel;
    no: TEdit;
    money: TEdit;
    cancel: TBitBtn;
    Table1: TTable;
    procedure okClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmCloseTel: TfrmCloseTel;

implementation

{$R *.dfm}

procedure TfrmCloseTel.okClick(Sender: TObject);
var
   canSend:boolean;
begin
   //檢查分機號的合理性
   canSend:=false;
   with table1 do
   begin
      open;
      while not eof do
      begin
         if fieldByName('分機號').AsString=no.Text then
         begin
            canSend:=true;
            break;
         end;
         next;
      end;
   end;
   if canSend=false then
   begin
      showMessage('輸入的分機號錯誤，請重新輸入！');
      table1.Close;
      exit;
   end;
   with table1 do
   begin
      money.Text:=fieldByName('話費限額').AsString;
      edit;
      fieldValues['開通標志']:='n';
      fieldValues['話費限額']:='0';
      post;
      close;
   end;
end;

end.