-
Notifications
You must be signed in to change notification settings - Fork 0
/
UDesbloqueio.pas
64 lines (53 loc) · 1.78 KB
/
UDesbloqueio.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
unit UDesbloqueio;
interface
uses
Winapi.Windows, Winapi.Messages, System.SysUtils, System.Variants, System.Classes, Vcl.Graphics,
Vcl.Controls, Vcl.Forms, Vcl.Dialogs, Data.DB, Vcl.StdCtrls, Vcl.Grids,
Vcl.DBGrids;
type
TfrmDesbloquear = class(TForm)
grdBloquados: TDBGrid;
lblIntroducao: TLabel;
lblDescricao: TLabel;
dsBloqueados: TDataSource;
procedure FormShow(Sender: TObject);
procedure FormClose(Sender: TObject; var Action: TCloseAction);
procedure grdBloquadosDblClick(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;
var
frmDesbloquear: TfrmDesbloquear;
implementation
{$R *.dfm}
uses UDM;
procedure TfrmDesbloquear.FormClose(Sender: TObject; var Action: TCloseAction);
begin
dm.qryconsfuncionarios.close;
end;
procedure TfrmDesbloquear.FormShow(Sender: TObject);
begin
dm.qryConsFuncionarios.Close;
dm.qryConsFuncionarios.SQL.Clear;
dm.qryConsFuncionarios.SQL.Add('select funCodigo, funTipo, funNome, funRG, funCPF, funEndereco, funCidade, '
+'funEstado, funSituacao, funPagamentoBruto, funDataNascimento, '
+'funCTPS, funCRECI, funObservacoes, funDataAdmissao, funDataDemissao, '
+'funBairro, funLogin, funSenha, funCargo, funBloqueio from FUNCIONARIOS '
+'Where funbloqueio >= 5 ');
dm.qryConsFuncionarios.Open;
end;
procedure TfrmDesbloquear.grdBloquadosDblClick(Sender: TObject);
begin
if(grdBloquados.SelectedRows.Count -1 = 0 ) then
begin
dsBloqueados.DataSet.Edit;
DM.qryConsFuncionarios.FieldByName('funbloqueio').value:= 0;
dsBloqueados.DataSet.Post;
ShowMessage('Usuário Desbloqueado.');
dm.qryConsFuncionarios.Close;
dm.qryConsFuncionarios.Open;
end;
end;
end.