-
Notifications
You must be signed in to change notification settings - Fork 0
/
ulogin.pas
81 lines (64 loc) · 1.57 KB
/
ulogin.pas
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
unit ulogin;
{$mode objfpc}{$H+}
interface
uses
Classes, SysUtils, Forms, Controls, Graphics, Dialogs, StdCtrls, ZDataset;
type
{ TfrmTelalogin }
TfrmTelalogin = class(TForm)
btnLogin: TButton;
edtUSUARIO: TEdit;
edtSENHA: TEdit;
Label1: TLabel;
Label2: TLabel;
procedure btnLoginClick(Sender: TObject);
private
public
end;
var
frmTelalogin: TfrmTelalogin;
implementation
uses uprincipal;
{$R *.lfm}
{ TfrmTelalogin }
procedure TfrmTelalogin.btnLoginClick(Sender: TObject);
var
qrUSER : TZQuery;
begin
qrUSER:= TZQuery.create(self);
qrUSER.Connection:= frmPrincipal.conexao;
try
qrUSER.sql.add('SELECT * FROM ctrl_usuario');
qrUSER.sql.add('WHERE ctrl_usuario.nome = :cNOME');
qrUSER.ParamByName('cNOME').AsString:=trim(edtUSUARIO.Text);
qrUSER.Open;
Except
on e: Exception do
ShowMessage('Erro ao abrir tabela de usuario'+#13+
e.Message+#13+e.ClassName);
end;
if qrUSER.Active then
begin
if qrUSER.RecordCount > 0 then
begin
if qrUSER.FieldByName('senha').Value = trim(edtSENHA.Text) then
begin
frmPrincipal.protegemenu(qrUSER.FieldByName('nivel').Value);
ModalResult:=mrYes;
end
else
begin
ShowMessage('Senha INvalida');
ModalResult:=mrNo;
end;
end
else
begin
ShowMessage('Usuario ou senha invalido');
ModalResult:=mrNo;
end;
end
else
ModalResult:=mrNo;
end;
end.