unit delCustomer;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ComCtrls, StdCtrls{, IdGlobal};

type
  TfrmDelCustomer = class(TForm)
    GroupBox1: TGroupBox;
    Label1: TLabel;
    UserID: TEdit;
    GroupBox2: TGroupBox;
    BtnLocation: TButton;
    Label2: TLabel;
    Label3: TLabel;
    sex: TEdit;
    Label4: TLabel;
    birthday: TDateTimePicker;
    Label6: TLabel;
    joinTime: TDateTimePicker;
    Label5: TLabel;
    CardNum: TEdit;
    Label11: TLabel;
    arrearage: TEdit;
    Label7: TLabel;
    tel: TEdit;
    Label8: TLabel;
    address: TEdit;
    btnDelete: TButton;
    BtnClose: TButton;
    Username: TEdit;
    procedure BtnLocationClick(Sender: TObject);
    procedure btnDeleteClick(Sender: TObject);
    procedure BtnCloseClick(Sender: TObject);
    procedure UserIDChange(Sender: TObject);
  private
    { Private declarations }

  public
    { Public declarations }
    function isInteger(s:string):boolean;
  end;

var
  frmDelCustomer: TfrmDelCustomer;

implementation

uses dataModule;

{$R *.dfm}
function TfrmDelCustomer.isInteger(s: string): boolean;
var
   i:integer;
begin
   i:=1;
   if length(s)=0 then
   begin
      result:=false;
      exit;
   end;
   while i<=length(s) do
   begin
      if (isNumeric(s[i])=false) then
      begin
         result:=false;
         exit;
      end;
      i:=i+1;
   end;
   result:=true;
end;

procedure TfrmDelCustomer.BtnLocationClick(Sender: TObject);
var
    flag : boolean;
begin

    //按照編號查找用戶
    if ( isInteger(UserId.Text)=false ) then
    begin
        messageDlg('輸入編號不合法',mtWarning,[mbOk],0);
        exit;
    end;

    //
    flag:=false;
    with dm.TLeader do
    begin
        open;
        first;
        while not eof do
        begin
            if fieldByName('編號').AsString=UserId.Text then
            begin
                flag:=true;
                break;
            end;
            next;
        end;
        if flag=false then//會員不存在
        begin
            messageDlg('輸入編號不存在',mtWarning,[mbOk],0);
            btnDelete.Enabled:=false;
            exit;
        end;
    end;
    btnDelete.Enabled:=true;

    with dm.TLeader do
    begin

        sex.Text:= fieldByName('性別').asString;
        Username.Text:=fieldByName('姓名').asString;
        birthDay.Date:=fieldByName('生日').AsDateTime;
        CardNum.Text := fieldByName('身份證號碼').asString;
        joinTime.Date:=fieldByName('任職時間').AsDateTime;
        tel.Text:=fieldByName('電話').asString;
        address.Text:=fieldByName('地址').asString;
        arrearage.Text := fieldByName('每小時收費').asString;

    end;


end;

procedure TfrmDelCustomer.btnDeleteClick(Sender: TObject);
var
    i:  integer;
    id: integer;
begin
    //刪除用戶
   i:=messageDlg('確定要刪除用戶記錄?',mtWarning,[mbYes,mbNo],0);
   if i=6 then
   begin
      {記錄要刪除記錄的關鍵字}
      id:=strtoint(UserId.Text);
      {刪除這一條記錄}
      dm.TLeader.Delete;
      {清屏并且刪除按鈕不可用}
      UserId.Text:='';
      UserName.Text:='';
      sex.Text:='';
      birthDay.Date:=now;
      joinTime.Date:=now;
      CardNum.Text := '';
      tel.Text:='';
      address.Text:='';
      arrearage.Text := '';
      activeControl:=UserId;
   end;
end;

procedure TfrmDelCustomer.BtnCloseClick(Sender: TObject);
begin
    //關閉窗體
    dm.TLeader.close;
    close;
end;

procedure TfrmDelCustomer.UserIDChange(Sender: TObject);
begin
    btnDelete.Enabled := false;
end;

end.