unit password;

interface

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

type
  Tpassword_Form = class(TForm)
    omm_LEdit: TLabeledEdit;
    nmm_LEdit: TLabeledEdit;
    qmm_LEdit: TLabeledEdit;
    cmdok: TButton;
    cmdclose: TButton;
    procedure omm_LEditKeyPress(Sender: TObject; var Key: Char);
    procedure nmm_LEditKeyPress(Sender: TObject; var Key: Char);
    procedure qmm_LEditKeyPress(Sender: TObject; var Key: Char);
    procedure cmdokClick(Sender: TObject);
    procedure cmdcloseClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  password_Form: Tpassword_Form;

implementation

uses main;

{$R *.dfm}

procedure Tpassword_Form.omm_LEditKeyPress(Sender: TObject;
  var Key: Char);
begin
    if key = #13 then
        nmm_ledit.SetFocus;
end;

procedure Tpassword_Form.nmm_LEditKeyPress(Sender: TObject;
  var Key: Char);
begin
    if key = #13 then
        qmm_ledit.SetFocus;
end;

procedure Tpassword_Form.qmm_LEditKeyPress(Sender: TObject;
  var Key: Char);
begin
    if key = #13 then
        cmdok.Click;
end;

procedure Tpassword_Form.cmdokClick(Sender: TObject);
var
    yhm,oldpass,newpass,qrpass,sqlstr:string;
begin
    yhm:=trim(mainform.StatusBar1.Panels[0].Text);
    oldpass:=trim(omm_ledit.Text);
    newpass:=trim(nmm_ledit.Text);
    if length(newpass)<3 then
    begin
        showmessage('密碼由3--20個字符組成！！');
        exit;
    end;
    qrpass:=trim(qmm_ledit.Text);
    if length(qrpass)<3 then
    begin
        showmessage('密碼由3--20個字符組成！！');
        exit;
    end;
    if (newpass <> qrpass) then
    begin
        showmessage('確認密碼不相同，請確認！！');
        exit;
    end;
    sqlstr:='select * from t_user where (name='''+yhm+''') and (passwd='''+oldpass+''')';
    with tquery.Create(nil) do
    begin
        try
        SQL.Clear;
        SQL.Add(sqlstr);
        Open;
        if  recordcount < 1 then
        begin
            showmessage('原密碼錯誤，你不能修改--'+yhm+'--用戶的密碼！！！');
            exit;
        end;
        sqlstr:='update t_user set passwd='''+newpass+''' where (name='''+yhm+''')';
        SQL.Clear;
        SQL.Add(sqlstr);
        ExecSQL;
        finally
        Free;
        end;
    end;
    showmessage('密碼修改成功！');
    Close;
end;

procedure Tpassword_Form.cmdcloseClick(Sender: TObject);
begin
    Close;
    mainForm.N12.Enabled:=true;
end;

end.