unit xgxschdh1;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  StdCtrls, Buttons;

type
  Txgxschdh = class(TForm)
    Label1: TLabel;
    Edit1: TEdit;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    procedure BitBtn1Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  xgxschdh: Txgxschdh;

implementation

uses xschd1;

{$R *.DFM}

procedure Txgxschdh.BitBtn1Click(Sender: TObject);
begin
  if Trim(Edit1.Text) = '' then
  begin
    Application.MessageBox('單號不能為空.', '提示', MB_OK + MB_ICONERROR);
    exit;
  end;
  try
    xschd.ADOTable1.Edit;
    xschd.ADOTable1.FieldByName('code').asstring := Edit1.text;
    xschd.ADOTable1.post;
    xschd.ADOTable2.Close;
    xschd.ADOTable2.Open;
  except
    Application.MessageBox('您輸入的單號已經(jīng)存在，不能保存.', '提示', MB_OK + MB_ICONERROR);
    xschd.ADOTable1.Cancel;
    exit;
  end;
  close;
end;


procedure Txgxschdh.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  Action := cafree;
end;

end.