unit registe;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, jpeg, ExtCtrls, StdCtrls;

type
  TRegForm = class(TForm)
    GroupBox1: TGroupBox;
    GroupBox2: TGroupBox;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    XHEdit: TEdit;
    XPComboBox: TComboBox;
    Button1: TButton;
    Button2: TButton;
    Image1: TImage;
    Label4: TLabel;
    PSEdit: TEdit;
    XNEdit: TEdit;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  RegForm: TRegForm;

implementation
uses md;

{$R *.dfm}
procedure IsEditEmpty(Sender:Tobject);
begin
if trim((sender as Tedit).Text)='' then
begin
showmessage('相應的選項不能為空!');
exit;
(sender as Tedit).SetFocus;
end;
end;

procedure TRegForm.Button1Click(Sender: TObject);
var
i:integer;
begin
with DataMd.ADOOrder do
begin
close;
sql.Clear;
iseditempty(xhedit);
iseditempty(xnedit);
iseditempty(psedit);
if trim(xhedit.Text)<>'' then
     if trim(xnedit.Text)<>'' then
        if trim(psedit.Text)<>'' then
           begin
           sql.Add('select * from tborder where 學號='''+trim(xhedit.Text)+'''');
           sql.Add(' and 姓名='''+trim(xnedit.text)+''''+' and 寢室號='''+trim(psedit.Text)+'''' );
           open;
           if recordcount>0 then
           begin
             with datamd.ADORegiste do
             begin
              close;
              sql.Clear;
              sql.Add('select * from registe where 學號='''+trim(xhedit.Text)+'''');
              sql.Add(' and 姓名='''+trim(xnedit.text)+''''+' and 寢室號='''+trim(psedit.Text)+'''' );
              open;
              if not eof then
              begin
                edit;
                for i:=0 to fields.Count-1 do
                begin
                   if trim(xpcombobox.Text)=fields[i].FieldName then
                   begin
                   fieldbyname(fields[i].FieldName).AsString:='已注冊';
                   post;
                   showmessage('注冊成功');
                   end;
                end;
              end
              else
                begin
                 append;
                 fieldbyname('學號').AsString:=xhedit.Text;
                 fieldbyname('姓名').AsString:=xnedit.Text;
                 fieldbyname('寢室號').AsString:=psedit.Text;
                 for i:=0 to fields.Count-1 do
                   begin
                   if trim(xpcombobox.Text)=fields[i].FieldName then
                   fieldbyname(fields[i].fieldname).AsString:='已注冊';
                   end;
                   if messagedlg('請確認是否要注冊？是的話請按OK',mtconfirmation,[mbYes,mbNO],0)=mryes then
                   post
                   else
                   cancel;
               end;
           end;
         end
         else
         showmessage('沒有該生記錄')
      end;
  end;
end;

procedure TRegForm.Button2Click(Sender: TObject);
begin
close;
end;

end.