unit LoginUnit;

interface

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

type
  TLoginForm = class(TForm)
    PanelBkGnd: TPanel;
    Label2: TLabel;
    Label1: TLabel;
    Label3: TLabel;
    L_name: TLabel;
    Panel_button: TPanel;
    Bevel_button: TBevel;
    OKBtn: TButton;
    CancelBtn: TButton;
    E_ID: TEdit;
    E_PassWord: TEdit;
    query_pass: TQuery;
    procedure FormCloseQuery(Sender: TObject; var CanClose: Boolean);
    procedure OKBtnClick(Sender: TObject);
    procedure E_IDChange(Sender: TObject);
    procedure E_IDKeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure CancelBtnClick(Sender: TObject);
    procedure FormCreate(Sender: TObject);
  private
    B_halt: bool;
    I_logo: integer;
    { Private declarations }
  public

    { Public declarations }
  end;

var
  LoginForm: TLoginForm;

implementation

uses MainUnit, LogoUnit;

{$R *.dfm}

procedure TLoginForm.FormCloseQuery(Sender: TObject;
  var CanClose: Boolean);
var
  S_temppass: string;
begin
  inherited;
  if b_halt then
  begin
    query_pass.Close;
    query_pass.Free;
    application.Terminate;
    exit;
  end
  else b_halt := true;
  S_temppass := E_password.text;
  USERNAME := L_name.Caption;
  if (E_id.Text = '') or (L_name.Caption = '未知用戶') then //用戶名為空
  begin
    messagedlg('用戶錯誤', mterror, [mbok], 0);
    E_id.SetFocus;
    canclose := false;
    exit;
  end //end if
  else //用戶名非空
  begin
    with query_pass do
    begin
      first;
      while not eof do //檢查用戶名與密碼
      begin
        if (USERNAME = fieldbyname('USERname').asstring) and
          (S_tempPass = fieldbyname('Psd').asstring) then
        begin
          USERRIGHTSNAME := fieldbyname('rightsname').AsString;
          USERRIGHTS := fieldbyname('rights').AsString;
          break;
        end;
        next;
      end; //end while
      if eof then //用戶名與密碼不符
      begin
        inc(I_logo);
        if I_logo >= 3 then
        begin
          messagedlg('您已嘗試超過 3 次，系統(tǒng)將停止運行！', mterror, [mbok], 0);
          query_pass.Close;
          query_pass.Free;
          application.Terminate;
        end
        else
        begin
          messagedlg('用戶名與密碼不符，請檢查后重新輸入。' + #13 + #13
            + '你還有 ' + inttostr(3 - I_logo) + ' 次機會！', mterror, [mbok], 0);
          e_password.SetFocus;
          e_password.SelectAll;
          canclose := false;
          exit;
        end;
      end; //end if
    end; //end with
  end; //end else if;
  MainForm.StatusBar_main.Panels.Items[3].Text := '操作員：【' + USERNAME + '】 權限：〖' + USERRIGHTSNAME + '〗';
  query_pass.Free;
  canclose := true;
end;


procedure TLoginForm.OKBtnClick(Sender: TObject);
begin
  b_halt := false;
  self.Close;
end;

procedure TLoginForm.E_IDChange(Sender: TObject);
begin
  with query_pass do
  begin
    first;
    while not eof do
    begin
      if E_id.Text = fieldbyname('ID').AsString then
      begin
        L_name.Caption := fieldbyname('USERName').AsString;
        exit;
      end
      else
        L_name.Caption := '未知用戶';
      next;
    end;
  end;
end;

procedure TLoginForm.E_IDKeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  if key = 27 then
  begin
    cancelbtn.Click;
    exit;
  end;
  if (key = 13) or (key = 40) then { 判斷是按執(zhí)行鍵}
  begin
    key := 0;
    perform(WM_NEXTDLGCTL, 0, 0); {移動到下一個控件}
  end;
end;

procedure TLoginForm.CancelBtnClick(Sender: TObject);
begin
  halt;
end;

procedure TLoginForm.FormCreate(Sender: TObject);
var
  reg: TRegistry;
begin
  self.Caption := application.Title + ' - ';
  self.Caption := self.Caption + '用戶登錄';
  I_logo := 0;
  query_pass.DatabaseName := 'CPXSGL';
  B_halt := true;
  reg := TRegistry.Create;
  Reg.RootKey := HKEY_CURRENT_USER;
  with query_pass do
  begin
    sql.text := 'SELECT Sysuser.ID, Sysuser.NAME USERNAME, Sysuser.PASS Psd,'
      + ' SysUserRights.NAME RIGHTSNAME, SysUserRights.RIGHTS RIGHTS FROM Sysuser '
      + ' INNER JOIN SysUserRights ON  (Sysuser.RIGHTS = SysUserRights.NAME)'
      + ' ORDER BY Sysuser.ID';
    try
      open;
    except
      if LogoForm.Showing then
        LogoForm.Destroy;
      messagedlg('數(shù)據(jù)庫打開錯誤，可能指定的系統(tǒng)數(shù)據(jù)庫文件不存在！' + #13 + #13
        + '系統(tǒng)將終止運行，請重新嘗試打開本程序。'
        + #13 + #13 + '如果依然出現(xiàn)本信息，請與程序供應商聯(lián)系。', mtError, [mbok], 0);
      close;
      try
        reg.DeleteKey(S_RegTree);
      finally
        reg.CloseKey;
        reg.free;
      end;
      application.Terminate;
    end;
  end;
end;


end.