unit upass;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, InvokeRegistry, StdCtrls, DB, DBClient, ExtCtrls, Grids,
  DBGrids, ADODB, main, kxiancommon;

type
  TPassEditDlg = class(TForm)
    Label1: TLabel;
    Label2: TLabel;
    edtPassword: TEdit;
    edtAccount: TEdit;
    Panel1: TPanel;
    btnOK: TButton;
    btnCancel: TButton;
    adoqUser: TADOQuery;
    procedure btnOKClick(Sender: TObject);
    procedure FormCreate(Sender: TObject);

  private
  public
    function VerifyAccount: Boolean;
    class function Execute(var AUserID: string; var AUserName: string): Boolean;
  end;

implementation

{$R *.dfm}
{ TPassDlg }
class function TPassEditDlg.Execute(var AUserID: string; var AUserName: string): Boolean;
begin
  RESULT := FALSE;
  with TPassEditDlg.Create(nil) do
  try
    Result := ShowModal = mrOk;
    AUserID := adoqUser.FieldByName('UserID').Asstring;
    AUserName := adoqUser.FieldByName('UserName').Asstring;
    sTrueName := adoqUser.FieldByName('TrueName').Asstring;

  finally
    Free;
  end;
end;

function TPassEditDlg.VerifyAccount: Boolean;
begin
  Result := False;
  with adoqUser do
  begin
    Parameters.ParamByName('userName').Value := edtAccount.Text;
    Parameters.ParamByName('Password').Value := edtPassword.Text;
    if Active then Close;
    Open;
    if RecordCount > 0 then ModalResult := mrOk;
  end;
  Result := ModalResult = mrOk;
end;

procedure TPassEditDlg.btnOKClick(Sender: TObject);
begin
  if not VerifyAccount then ShowMessage('用戶或密碼錯(cuò)誤,請(qǐng)重新輸入!');
end;

procedure TPassEditDlg.FormCreate(Sender: TObject);
begin
        adoquser.Connection := adocwdkz;
end;

end.