HANSYS/UfrmConfig.pas at master · marcusdelphi/HANSYS · GitHub

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
81
82
83
84
unit UfrmConfig;

interface

uses
  Winapi.Windows, Winapi.Messages, System.SysUtils, System.Variants, System.Classes, Vcl.Graphics,
  Vcl.Controls, Vcl.Forms, Vcl.Dialogs, Vcl.StdCtrls, Vcl.Buttons, Vcl.ComCtrls,
  Vcl.ExtCtrls, Vcl.ImgList, Vcl.Grids, Vcl.DBGrids, Vcl.DBCtrls, Vcl.Mask,
  Data.DB, Datasnap.DBClient, Vcl.Imaging.pngimage, Vcl.Imaging.jpeg;


type
  TFrmConfig = class(TForm)
    Button1: TButton;
    GroupBox1: TGroupBox;
     function getCodTeste: integer;
     function getCodTeste2: integer;
    procedure Button1Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure FormDestroy(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  FrmConfig: TFrmConfig;
  CodigoTeste:integer;

implementation

{$R *.dfm}

uses UdmFicha, Data.DBXCommon;

{ TForm1 }

procedure TFrmConfig.Button1Click(Sender: TObject);
begin
  ShowMessage('Codigo = '+IntToStr(getCodTeste));
end;

procedure TFrmConfig.FormCreate(Sender: TObject);
begin
 if not assigned(dmFicha) then
    begin
      dmFicha:=TdmFicha.Create(Self);
      dmFicha.cdsCadPessoal.Open;
    end;
end;

procedure TFrmConfig.FormDestroy(Sender: TObject);
begin
 dmFicha.Free;
  dmFicha:=nil;
end;

function TFrmConfig.getCodTeste: integer;
begin
  dmFicha.SQLQueryPessoal.Open;
  Result:=dmFicha.SQLQueryPessoalCODIGO.Value;
end;

function TFrmConfig.getCodTeste2: integer;
var
 DBXConn: TDBXConnection;
 DBXCmd: TDBXCommand;
 DBXReader: TDBXReader;
begin
  begin
   DBXConn:=TDBXConnectionFactory.GetConnectionFactory.GetConnection('FBCONNECTION','SYSDBA','masterkey');
   DBXCmd:=DBXConn.CreateCommand;
   DBXCmd.Text:='select gen_id(gen_pessoal_id,0)as Codigo from RDB$DATABASE';
   DBXReader:=DBXCmd.ExecuteQuery;
   if DBXReader.Next then
     Result:=DBXReader.Value['Codigo'].AsInt32
   else
     Result:=0;
  end;
end;


end.