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 Unit4;
interface
uses
Winapi.Windows, Winapi.Messages, System.SysUtils, System.Variants, System.Classes, Vcl.Graphics,
Vcl.Controls, Vcl.Forms, Vcl.Dialogs, Vcl.StdCtrls, Vcl.ExtCtrls,
Data.Bind.EngExt, Vcl.Bind.DBEngExt, Data.Bind.Components,
Data.Bind.ObjectScope, System.Rtti, System.Bindings.Outputs, Data.Bind.GenData,
Vcl.ExtDlgs, Data.DB, Data.Win.ADODB;
type
TForm4 = class(TForm)
Button1: TButton;
OpenDialog1: TOpenDialog;
Image1: TImage;
OpenPictureDialog1: TOpenPictureDialog;
Image2: TImage;
Image3: TImage;
Image4: TImage;
ADOTable1: TADOTable;
Query1: TADOQuery;
DataSource1: TDataSource;
ADOConnection1: TADOConnection;
Edit1: TEdit;
procedure Button1Click(Sender: TObject);
procedure afficherimages;
procedure FormCreate(Sender: TObject);
procedure Image1Click(Sender: TObject);
private
{ Déclarations privées }
public
{ Déclarations publiques }
end;
var
Form4: TForm4;
implementation
{$R *.dfm}
procedure TForm4.FormCreate(Sender: TObject);
begin
afficherimages;
end;
procedure TForm4.Image1Click(Sender: TObject);
begin
if Opendialog1.Execute then
begin
TImage(Sender).Picture.LoadFromFile(OpenDialog1.FileName);
Query1.SQL.Text:='UPDATE IMAGES SET IMAGE=:N WHERE NUMERO=:T';
Query1.Parameters.ParamByName('N').Value.asString:=Opendialog1.FileName;
Query1.Parameters.ParamByName('T').Value.asInteger:=TImage(Sender).Tag;
Query1.ExecSQL;
end;
end;
procedure TForm4.afficherimages;
var nomimage : String;
begin
Query1.SQL.Text:='SELECT numero,image from IMAGES order by numero';
Query1.Open;
nomImage:=Query1.FieldByName('Image').asString;
if FileExists(nomImage) then Image1.Picture.LoadFromFile(nomimage) else Image1.Picture:=nil;
Query1.Next;
nomImage:=Query1.FieldByName('Image').asString;
if FileExists(nomImage) then Image2.Picture.LoadFromFile(nomimage) else Image2.Picture:=nil;
Query1.Next;
nomImage:=Query1.FieldByName('Image').asString;
if FileExists(nomImage) then Image3.Picture.LoadFromFile(nomimage) else Image3.Picture:=nil;
Query1.Next;
nomImage:=Query1.FieldByName('Image').asString;
if FileExists(nomImage) then Image4.Picture.LoadFromFile(nomimage) else Image4.Picture:=nil;
Query1.Close;
end;
end. |
Partager