unit7.~pas

一个很简单的人事管理系统

unit Unit7;

interface

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

type
  TdengluForm = class(TForm)
    Edit1: TEdit;
    Edit2: TEdit;
    ADOConnection1: TADOConnection;
    ADOQuery1: TADOQuery;
    Image3: TImage;
    Image1: TImage;
    Image2: TImage;
    Edit3: TEdit;
    procedure FormCreate(Sender: TObject);
    procedure Image2Click(Sender: TObject);
    procedure Image1Click(Sender: TObject);
    procedure Edit1KeyPress(Sender: TObject; var Key: Char);
    procedure Edit2KeyPress(Sender: TObject; var Key: Char);
    procedure FormActivate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  dengluForm: TdengluForm;


implementation

uses Unit1;

{$R *.dfm}

procedure TdengluForm.FormCreate(Sender: TObject);
begin
BorderIcons:=[];

end;

procedure TdengluForm.Image2Click(Sender: TObject);
var
aa:integer;
begin
aa:=application.MessageBox('真的要退出？','提示信息',Mb_ICONQUESTION+MB_OKCANCEL);
    if aa=1 then
    begin
application.Terminate;
    end;
end;

procedure TdengluForm.Image1Click(Sender: TObject);
var
  ss:string;
  quanxian1,quanxian2:integer;
begin
 if edit1.Text='' then
    begin//>
     application.MessageBox('请输入用户名!','提示信息',Mb_ICONexclamaTION+MB_OK);
      edit1.SetFocus;
            exit;
    end; //>
if edit2.Text='' then
    begin//>
     application.MessageBox('请输入密码!','提示信息',Mb_ICONexclamaTION+MB_OK);
      edit2.SetFocus;
            exit;
    end; //>







  ss:='';
  quanxian1:=0;
  quanxian2:=0;
  
  adoquery1.SQL.Clear;
  adoquery1.SQL.add('select * from Operator where Name=:aname and Passnum=:mima') ;
  adoquery1.close;
  adoquery1.Parameters.Clear;
  adoquery1.Parameters.AddParameter;
  adoquery1.Parameters[0].name:='aname';
  adoquery1.Parameters[0].DataType:=ftstring;
  adoquery1.Parameters[0].Direction:=pdinput;
  adoquery1.Parameters[0].Value:=edit1.text;
  adoquery1.Parameters.AddParameter;
  adoquery1.Parameters[1].name:='mima';
  adoquery1.Parameters[1].DataType:=ftstring;
  adoquery1.Parameters[1].Direction:=pdinput;
  adoquery1.Parameters[1].Value:=edit2.text;

  adoquery1.active:=true;


  if adoquery1.Recordset.RecordCount=1 then
  begin

      quanxian1:=strtoint(adoquery1.fieldbyname('Right-1').asstring);
      quanxian2:=strtoint(adoquery1.fieldbyname('Right-2').asstring);

      mainform.Edit1.Text:=edit1.Text;//把登陆成功的用户返回给主窗体上的一个edit，以后备用！

      ss:='已登陆用户:'+edit1.Text;
      mainform.StatusBar1.Panels[0].Text:=ss;
      if quanxian1=1 then
      begin
       mainform.N5.Enabled:=true;
       mainform.N2.Enabled:=true;
       mainform.N3.Enabled:=true;
      end
      else
         if quanxian2=1 then
         begin
         mainform.N2.Enabled:=true;
         mainform.N3.Enabled:=true;
         mainform.N5.Enabled:=false;
         end
         else
         begin
         mainform.N3.Enabled:=true;
         mainform.N5.Enabled:=false;
         mainform.N2.Enabled:=false;
         end;
      adoquery1.active:=false;

      close;
  end
  else
  begin



      Application.MessageBox('您输入的用户名,密码,用户类型有误！','错误提示',mb_ok);
      edit1.text:='';
      edit2.text:='';
      edit1.SetFocus;










      //错误时候的结束
      adoquery1.active:=false;
     
  end;




end;

procedure TdengluForm.Edit1KeyPress(Sender: TObject; var Key: Char);
begin

  if key=#13 then Image1Click(self);

  if length(edit1.Text)>7 then
     begin
      key:=chr(0);
       Application.MessageBox('您输入的用户名大于了8个字符','提示错误',mb_ok);
      edit1.Text:='';
     end
end;

procedure TdengluForm.Edit2KeyPress(Sender: TObject; var Key: Char);
begin
if key=#13 then Image1.OnClick(self);


  if length(edit2.Text)>7 then
     begin
      key:=chr(0);
       Application.MessageBox('您输入的密码大于了8个字符','提示错误',mb_ok);
      edit2.Text:='';
     end
end;

procedure TdengluForm.FormActivate(Sender: TObject);
begin
Align:=alClient; 
edit1.SetFocus;

end;

end.