Όνομα φόρμας :: dior8osh

ΦΟΡΜΑ ::

Διόρθωση λίστας παραγγελίας

if(DBEdit1->Text!="") {

ADOCommand1->CommandText="";

ADOCommand1->CommandText="DELETE paragelia.id, paragelia.kodpara, paragelia.kvdikos, paragelia.eidos, paragelia.temaxia, paragelia.id_pelath, paragelia.hmnia FROM paragelia WHERE paragelia.id="+DBEdit1->Text+"";

ADOCommand1->Execute();

ADOCommand2->CommandText="";

ADOCommand2->CommandText="UPDATE apo8hkh1 SET apo8hkh1.temaxia = apo8hkh1.temaxia + '"+DBEdit2->Text+"' WHERE apo8hkh1.kvdikos='"+DBEdit3->Text+"'";

ADOCommand2->Execute();

db->ADOTable2->Active=false;

db->ADOTable2->Active=true;

paragelies->Edit6->Text=FloatToStr(StrToFloat(paragelies->Edit6->Text)- StrToFloat(DBEdit4->Text)*StrToFloat(DBEdit2->Text));

//paragelia.id, paragelia.kodpara, paragelia.kvdikos, paragelia.eidos, paragelia.temaxia, paragelia.id_pelath, paragelia.hmnia FROM paragelia db->ADOQuery4->Close();

db->ADOQuery4->SQL->Clear();

db->ADOQuery4->SQL->Add("SELECT paragelia.id,paragelia.kodpara, paragelia.kvdikos, paragelia.eidos, paragelia.temaxia, paragelia.id_pelath, paragelia.hmnia");

db->ADOQuery4->SQL->Add("FROM paragelia");

db->ADOQuery4->SQL->Add("WHERE paragelia.kodpara='"+paragelies-

>Edit4->Text+"'");

db->ADOQuery4->Open();

} }

//--- void __fastcall Tdior8osh::Button2Click(TObject *Sender) {

ADOCommand1->CommandText="";

ADOCommand1->CommandText="DELETE * FROM paragelia WHERE paragelia.kodpara='"+paragelies->Edit4->Text+"'";

ADOCommand1->Execute();

//paragelia.id, paragelia.kodpara, paragelia.kvdikos, paragelia.eidos, paragelia.temaxia, paragelia.id_pelath, paragelia.hmnia

db->ADOQuery4->Close();

db->ADOQuery4->SQL->Add("SELECT paragelia.id,paragelia.kodpara, paragelia.kvdikos, paragelia.eidos, paragelia.temaxia, paragelia.id_pelath, paragelia.hmnia");

db->ADOQuery4->SQL->Add("FROM paragelia");

db->ADOQuery4->SQL->Add("WHERE paragelia.kodpara='"+paragelies-

>Edit4->Text+"'");

db->ADOQuery4->Open();

paragelies->Edit6->Text="0,0";

//db->ADOQuery6->Close();

//db->ADOQuery6->SQL->Clear();

//db->ADOQuery6->SQL->Add("SELECT distinct

paragelia.kodpara,paragelia.hmnia,paragelia.hmnialh3hs");

//db->ADOQuery6->SQL->Add("FROM paragelia");

//db->ADOQuery6->SQL->Add("WHERE paragelia.id_pelath="+DBEdit1-

>Text+"");

//paragelies->Edit4->Text="";

paragelies->ListBox1->Clear();

paragelies->ListBox2->Clear();

paragelies->ListBox3->Clear();

paragelies->ListBox4->Clear();

}

//--- void __fastcall Tdior8osh::DBGrid1CellClick(TColumn *Column) {

db->ADOQuery15->Close();

db->ADOQuery15->SQL->Clear();

db->ADOQuery15->SQL->Add("SELECT apo8hkh1.price");

db->ADOQuery15->SQL->Add("FROM apo8hkh1");

db->ADOQuery15->SQL->Add("WHERE apo8hkh1.kvdikos='"+DBEdit3-

>Text+"'");

db->ADOQuery15->Open();

}

//---

void __fastcall Tdior8osh::FormCreate(TObject *Sender) {

}

Πλήκτρο ::

Διαγραφή επιλεγμένου υλικού

Όνομα πλήκτρου ::

^Button1

void __fastcall Tdior8osh::Button1Click(TObject *Sender) {

if(DBEdit1->Text!="") {

ADOCommand1->CommandText="";

ADOCommand1->CommandText="DELETE paragelia.id, paragelia.kodpara, paragelia.kvdikos, paragelia.eidos, paragelia.temaxia, paragelia.id_pelath, paragelia.hmnia FROM paragelia WHERE paragelia.id="+DBEdit1->Text+"";

ADOCommand1->Execute();

ADOCommand2->CommandText="";

ADOCommand2->CommandText="UPDATE apo8hkh1 SET

apo8hkh1.temaxia = apo8hkh1.temaxia + '"+DBEdit2->Text+"' WHERE apo8hkh1.kvdikos='"+DBEdit3->Text+"'";

ADOCommand2->Execute();

db->ADOTable2->Active=false;

db->ADOTable2->Active=true;

paragelies->Edit6->Text=FloatToStr(StrToFloat(paragelies->Edit6->Text)- StrToFloat(DBEdit4->Text)*StrToFloat(DBEdit2->Text));

//paragelia.id, paragelia.kodpara, paragelia.kvdikos, paragelia.eidos, paragelia.temaxia, paragelia.id_pelath, paragelia.hmnia FROM paragelia db->ADOQuery4->Close();

db->ADOQuery4->SQL->Clear();

db->ADOQuery4->SQL->Add("SELECT paragelia.id,paragelia.kodpara, paragelia.kvdikos, paragelia.eidos, paragelia.temaxia, paragelia.id_pelath, paragelia.hmnia");

db->ADOQuery4->SQL->Add("FROM paragelia");

db->ADOQuery4->SQL->Add("WHERE paragelia.kodpara='"+paragelies-

>Edit4->Text+"'");

db->ADOQuery4->Open();

} }

Πλήκτρο ::

Διαγραφή όλης της λίστας

Όνομα πλήκτρου ::

^Button2

void __fastcall Tdior8osh::Button2Click(TObject *Sender) {

ADOCommand1->CommandText="";

ADOCommand1->CommandText="DELETE * FROM paragelia WHERE paragelia.kodpara='"+paragelies->Edit4->Text+"'";

ADOCommand1->Execute();

//paragelia.id, paragelia.kodpara, paragelia.kvdikos, paragelia.eidos, paragelia.temaxia, paragelia.id_pelath, paragelia.hmnia

db->ADOQuery4->Close();

db->ADOQuery4->SQL->Clear();

db->ADOQuery4->SQL->Add("SELECT paragelia.id,paragelia.kodpara, paragelia.kvdikos, paragelia.eidos, paragelia.temaxia, paragelia.id_pelath, paragelia.hmnia");

db->ADOQuery4->SQL->Add("FROM paragelia");

db->ADOQuery4->SQL->Add("WHERE paragelia.kodpara='"+paragelies-

>Edit4->Text+"'");

db->ADOQuery4->Open();

db->ADOQuery6->Close();

db->ADOQuery6->SQL->Clear();

db->ADOQuery6->SQL->Add("SELECT distinct paragelia.kodpara,paragelia.hmnia");

db->ADOQuery6->SQL->Add("FROM paragelia");

paragelies->Edit6->Text="0,0";

paragelies->ListBox1->Clear();

paragelies->ListBox2->Clear();

paragelies->ListBox3->Clear();

paragelies->ListBox4->Clear();

}

ΦΟΡΜΑ ::

ΜΗΤΡΩΟ ΚΑΤΕΣΤΡΑΜΜΕΝΩΝ ΠΥΡΟΣΒΕΣΤΗΡΩΝ

Όνομα φόρμας ::

katestramenoi

Εδώ βρισκόμαστε στο

ΜΗΤΡΩΟ ΚΑΤΕΣΤΡΑΜΜΕΝΩΝ ΠΥΡΟΣΒΕΣΤΗΡΩΝ

.

Μέσα από το παρόν Μητρώο μπορούμε να κάνουμε εισαγωγή του κωδικού φιάλης ενός κατεστραμμένου πυροσβεστήρα ώστε να το αναζητήσουμε αργότερα.

Πλήκτρο ::

^{ΠΡΟΣΘΗΚΗ}

Όνομα πλήκτρου ::

nbInsert

#include <vcl.h>

#pragma hdrstop

#include "katestramenoiForm.h"

#include "anazhthshForm.h"

#include "dbForm.h"

#include "dior8oshForm.h"

#include "Unit1.h"

#include "Unit3.h"

#include "Unit7.h"

//---

#pragma package(smart_init)

#pragma resource "*.dfm"

Tkatestramenoi *katestramenoi;

//--- __fastcall Tkatestramenoi::Tkatestramenoi(TComponent* Owner) : TForm(Owner)

//--- void __fastcall Tkatestramenoi::N2Click(TObject *Sender) {

Close();

}

//--- void __fastcall Tkatestramenoi::DBEdit1Change(TObject *Sender) {

/*

db->ADOQuery6->Close();

db->ADOQuery6->SQL->Clear();

db->ADOQuery6->SQL->Add("SELECT distinct paragelia.kodpara,paragelia.hmnia");

db->ADOQuery6->SQL->Add("FROM paragelia");

db->ADOQuery6->SQL->Add("WHERE paragelia.id_pelath="+DBEdit1-

>Text+"");

paragelies->Edit4->Text="";

*/

DBEdit5->Text=DBEdit1->Text;

}

//--- void __fastcall Tkatestramenoi::DBEdit2Change(TObject *Sender) {

DBEdit6->Text=DBEdit2->Text;

}

//--- void __fastcall Tkatestramenoi::FormShow(TObject *Sender) {

Edit3->Text=DateToStr(Date());

}

//--- void __fastcall Tkatestramenoi::Edit3Change(TObject *Sender) {

DBEdit7->Text=Edit3->Text;

}

//---

void __fastcall Tkatestramenoi::DBNavigator1Click(TObject *Sender, TNavigateBtn Button)

{

db->ADOQuery7->Close();

db->ADOQuery7->SQL->Clear();

db->ADOQuery7->SQL->Add("SELECT katestramena.kwdikos, katestramena.idpelath, katestramena.pelaths, katestramena.sxolia, katestramena.hmnia");

>Text+"'");

db->ADOQuery7->Open();

DBEdit5->Text=DBEdit1->Text;

DBEdit6->Text=DBEdit2->Text;

DBEdit7->Text=Edit3->Text;

//

#ifndef katestramenoiFormH

#define katestramenoiFormH

//---

#include <Classes.hpp>

#include <Controls.hpp>

#include <StdCtrls.hpp>

#include <Forms.hpp>

#include <DBCtrls.hpp>

#include <DBGrids.hpp>

#include <ExtCtrls.hpp>

#include <Grids.hpp>

#include <Mask.hpp>

#include <Menus.hpp>

#include <jpeg.hpp>

//--- class Tkatestramenoi : public TForm

{

__published: // IDE-managed Components TDBGrid *DBGrid1;

TDBNavigator *DBNavigator1;

TDBEdit *DBEdit1;

TDBEdit *DBEdit2;

TDBEdit *DBEdit3;

TDBEdit *DBEdit4;

TLabel *Label1;

TLabel *Label2;

TLabel *Label3;

TLabel *Label4;

TMainMenu *MainMenu1;

TMenuItem *N1;

TMenuItem *N2;

TDBEdit *DBEdit5;

TDBEdit *DBEdit6;

TEdit *Edit3;

TLabel *Label8;

TLabel *Label9;

TLabel *Label5;

TLabel *Label6;

void __fastcall N2Click(TObject *Sender);

void __fastcall DBEdit1Change(TObject *Sender);

void __fastcall DBEdit2Change(TObject *Sender);

void __fastcall FormShow(TObject *Sender);

void __fastcall Edit3Change(TObject *Sender);

void __fastcall DBNavigator1Click(TObject *Sender, TNavigateBtn Button);

private: // User declarations

public: // User declarations

__fastcall Tkatestramenoi(TComponent* Owner);

};

//--- extern PACKAGE Tkatestramenoi *katestramenoi;

//---

#endif

Πλήκτρο ::

ΔΙΑΓΡΑΦΗ

Όνομα πλήκτρου ::

nbDelete

#include <vcl.h>

#pragma hdrstop

#include "katestramenoiForm.h"

#include "anazhthshForm.h"

#include "dbForm.h"

#include "dior8oshForm.h"

#include "Unit1.h"

#include "Unit3.h"

#include "Unit7.h"

//---

#pragma package(smart_init)

#pragma resource "*.dfm"

Tkatestramenoi *katestramenoi;

//--- __fastcall Tkatestramenoi::Tkatestramenoi(TComponent* Owner) : TForm(Owner)

{ }

//--- void __fastcall Tkatestramenoi::N2Click(TObject *Sender)

}

//--- void __fastcall Tkatestramenoi::DBEdit1Change(TObject *Sender) {

/*

db->ADOQuery6->Close();

db->ADOQuery6->SQL->Clear();

db->ADOQuery6->SQL->Add("SELECT distinct paragelia.kodpara,paragelia.hmnia");

db->ADOQuery6->SQL->Add("FROM paragelia");

db->ADOQuery6->SQL->Add("WHERE paragelia.id_pelath="+DBEdit1-

>Text+"");

paragelies->Edit4->Text="";

*/

DBEdit5->Text=DBEdit1->Text;

}

//--- void __fastcall Tkatestramenoi::DBEdit2Change(TObject *Sender) {

DBEdit6->Text=DBEdit2->Text;

}

//--- void __fastcall Tkatestramenoi::FormShow(TObject *Sender) {

Edit3->Text=DateToStr(Date());

}

//--- void __fastcall Tkatestramenoi::Edit3Change(TObject *Sender) {

DBEdit7->Text=Edit3->Text;

}

//---

void __fastcall Tkatestramenoi::DBNavigator1Click(TObject *Sender, TNavigateBtn Button)

{

db->ADOQuery7->Close();

db->ADOQuery7->SQL->Clear();

db->ADOQuery7->SQL->Add("SELECT katestramena.kwdikos, katestramena.idpelath, katestramena.pelaths, katestramena.sxolia, katestramena.hmnia");

db->ADOQuery7->SQL->Add("FROM katestramena");

db->ADOQuery7->SQL->Add("WHERE katestramena.idpelath='"+DBEdit1-

DBEdit5->Text=DBEdit1->Text;

DBEdit6->Text=DBEdit2->Text;

DBEdit7->Text=Edit3->Text;

//

#ifndef katestramenoiFormH

#define katestramenoiFormH

//---

#include <Classes.hpp>

#include <Controls.hpp>

#include <StdCtrls.hpp>

#include <Forms.hpp>

#include <DBCtrls.hpp>

#include <DBGrids.hpp>

#include <ExtCtrls.hpp>

#include <Grids.hpp>

#include <Mask.hpp>

#include <Menus.hpp>

#include <jpeg.hpp>

//--- class Tkatestramenoi : public TForm

{

__published: // IDE-managed Components TDBGrid *DBGrid1;

TDBNavigator *DBNavigator1;

TDBEdit *DBEdit1;

TDBEdit *DBEdit2;

TDBEdit *DBEdit3;

TDBEdit *DBEdit4;

TLabel *Label1;

TLabel *Label2;

TLabel *Label3;

TLabel *Label4;

TMainMenu *MainMenu1;

TMenuItem *N1;

TMenuItem *N2;

TDBEdit *DBEdit5;

TDBEdit *DBEdit6;

TEdit *Edit3;

TDBEdit *DBEdit7;

TImage *Image1;

TLabel *Label8;

TLabel *Label9;

void __fastcall N2Click(TObject *Sender);

void __fastcall DBEdit1Change(TObject *Sender);

void __fastcall DBEdit2Change(TObject *Sender);

void __fastcall FormShow(TObject *Sender);

void __fastcall Edit3Change(TObject *Sender);

void __fastcall DBNavigator1Click(TObject *Sender, TNavigateBtn Button);

private: // User declarations

public: // User declarations

__fastcall Tkatestramenoi(TComponent* Owner);

};

//--- extern PACKAGE Tkatestramenoi *katestramenoi;

//---

#endif

Πλήκτρο ::

ΕΠΙΚΥΡΩΣΗ

Όνομα πλήκτρου ::

nbPost

#include <vcl.h>

#pragma hdrstop

#include "katestramenoiForm.h"

#include "anazhthshForm.h"

#include "dbForm.h"

#include "dior8oshForm.h"

#include "Unit1.h"

#include "Unit3.h"

#include "Unit7.h"

//---

#pragma package(smart_init)

#pragma resource "*.dfm"

Tkatestramenoi *katestramenoi;

//--- __fastcall Tkatestramenoi::Tkatestramenoi(TComponent* Owner) : TForm(Owner)

{ }

//--- void __fastcall Tkatestramenoi::N2Click(TObject *Sender) {

Close();

}

{ /*

db->ADOQuery6->Close();

db->ADOQuery6->SQL->Clear();

db->ADOQuery6->SQL->Add("SELECT distinct paragelia.kodpara,paragelia.hmnia");

db->ADOQuery6->SQL->Add("FROM paragelia");

db->ADOQuery6->SQL->Add("WHERE paragelia.id_pelath="+DBEdit1-

>Text+"");

paragelies->Edit4->Text="";

*/

DBEdit5->Text=DBEdit1->Text;

}

//--- void __fastcall Tkatestramenoi::DBEdit2Change(TObject *Sender) {

DBEdit6->Text=DBEdit2->Text;

}

//--- void __fastcall Tkatestramenoi::FormShow(TObject *Sender) {

Edit3->Text=DateToStr(Date());

}

//--- void __fastcall Tkatestramenoi::Edit3Change(TObject *Sender) {

DBEdit7->Text=Edit3->Text;

}

//---

void __fastcall Tkatestramenoi::DBNavigator1Click(TObject *Sender, TNavigateBtn Button)

{

db->ADOQuery7->Close();

db->ADOQuery7->SQL->Clear();

db->ADOQuery7->SQL->Add("SELECT katestramena.kwdikos, katestramena.idpelath, katestramena.pelaths, katestramena.sxolia, katestramena.hmnia");

db->ADOQuery7->SQL->Add("FROM katestramena");

db->ADOQuery7->SQL->Add("WHERE katestramena.idpelath='"+DBEdit1-

>Text+"'");

db->ADOQuery7->Open();

DBEdit5->Text=DBEdit1->Text;

DBEdit6->Text=DBEdit2->Text;

//

#ifndef katestramenoiFormH

#define katestramenoiFormH

//---

#include <Classes.hpp>

#include <Controls.hpp>

#include <StdCtrls.hpp>

#include <Forms.hpp>

#include <DBCtrls.hpp>

#include <DBGrids.hpp>

#include <ExtCtrls.hpp>

#include <Grids.hpp>

#include <Mask.hpp>

#include <Menus.hpp>

#include <jpeg.hpp>

//--- class Tkatestramenoi : public TForm

{

__published: // IDE-managed Components TDBGrid *DBGrid1;

TDBNavigator *DBNavigator1;

TDBEdit *DBEdit1;

TDBEdit *DBEdit2;

TDBEdit *DBEdit3;

TDBEdit *DBEdit4;

TLabel *Label1;

TLabel *Label2;

TLabel *Label3;

TLabel *Label4;

TMainMenu *MainMenu1;

TMenuItem *N1;

TMenuItem *N2;

TDBEdit *DBEdit5;

TDBEdit *DBEdit6;

TEdit *Edit3;

TDBEdit *DBEdit7;

TImage *Image1;

TLabel *Label8;

TLabel *Label9;

TLabel *Label5;

TLabel *Label6;

void __fastcall N2Click(TObject *Sender);

void __fastcall FormShow(TObject *Sender);

void __fastcall Edit3Change(TObject *Sender);

void __fastcall DBNavigator1Click(TObject *Sender, TNavigateBtn Button);

private: // User declarations

public: // User declarations

__fastcall Tkatestramenoi(TComponent* Owner);

};

//--- extern PACKAGE Tkatestramenoi *katestramenoi;

//---

#endif

Πλήκτρο ::

^ΑΚΥΡΟ

Όνομα πλήκτρου ::

nbCancel

#include <vcl.h>

#pragma hdrstop

#include "katestramenoiForm.h"

#include "anazhthshForm.h"

#include "dbForm.h"

#include "dior8oshForm.h"

#include "Unit1.h"

#include "Unit3.h"

#include "Unit7.h"

//---

#pragma package(smart_init)

#pragma resource "*.dfm"

Tkatestramenoi *katestramenoi;

//--- __fastcall Tkatestramenoi::Tkatestramenoi(TComponent* Owner) : TForm(Owner)

{ }

//--- void __fastcall Tkatestramenoi::N2Click(TObject *Sender) {

Close();

}

//--- void __fastcall Tkatestramenoi::DBEdit1Change(TObject *Sender) {

/*

db->ADOQuery6->SQL->Add("SELECT distinct paragelia.kodpara,paragelia.hmnia");

db->ADOQuery6->SQL->Add("FROM paragelia");

db->ADOQuery6->SQL->Add("WHERE paragelia.id_pelath="+DBEdit1-

>Text+"");

paragelies->Edit4->Text="";

*/

DBEdit5->Text=DBEdit1->Text;

}

//--- void __fastcall Tkatestramenoi::DBEdit2Change(TObject *Sender) {

DBEdit6->Text=DBEdit2->Text;

}

//--- void __fastcall Tkatestramenoi::FormShow(TObject *Sender) {

Edit3->Text=DateToStr(Date());

}

//--- void __fastcall Tkatestramenoi::Edit3Change(TObject *Sender) {

DBEdit7->Text=Edit3->Text;

}

//---

void __fastcall Tkatestramenoi::DBNavigator1Click(TObject *Sender, TNavigateBtn Button)

{

db->ADOQuery7->Close();

db->ADOQuery7->SQL->Clear();

db->ADOQuery7->SQL->Add("SELECT katestramena.kwdikos, katestramena.idpelath, katestramena.pelaths, katestramena.sxolia, katestramena.hmnia");

db->ADOQuery7->SQL->Add("FROM katestramena");

db->ADOQuery7->SQL->Add("WHERE katestramena.idpelath='"+DBEdit1-

>Text+"'");

db->ADOQuery7->Open();

DBEdit5->Text=DBEdit1->Text;

DBEdit6->Text=DBEdit2->Text;

DBEdit7->Text=Edit3->Text;

#ifndef katestramenoiFormH

#define katestramenoiFormH

//---

#include <Classes.hpp>

#include <Controls.hpp>

#include <StdCtrls.hpp>

#include <Forms.hpp>

#include <DBCtrls.hpp>

#include <DBGrids.hpp>

#include <ExtCtrls.hpp>

#include <Grids.hpp>

#include <Mask.hpp>

#include <Menus.hpp>

#include <jpeg.hpp>

//--- class Tkatestramenoi : public TForm

{

__published: // IDE-managed Components TDBGrid *DBGrid1;

TDBNavigator *DBNavigator1;

TDBEdit *DBEdit1;

TDBEdit *DBEdit2;

TDBEdit *DBEdit3;

TDBEdit *DBEdit4;

TLabel *Label1;

TLabel *Label2;

TLabel *Label3;

TLabel *Label4;

TMainMenu *MainMenu1;

TMenuItem *N1;

TMenuItem *N2;

TDBEdit *DBEdit5;

TDBEdit *DBEdit6;

TEdit *Edit3;

TDBEdit *DBEdit7;

TImage *Image1;

TLabel *Label8;

TLabel *Label9;

TLabel *Label5;

TLabel *Label6;

void __fastcall N2Click(TObject *Sender);

void __fastcall DBEdit1Change(TObject *Sender);

void __fastcall DBEdit2Change(TObject *Sender);

void __fastcall FormShow(TObject *Sender);

void __fastcall Edit3Change(TObject *Sender);

private: // User declarations

public: // User declarations

__fastcall Tkatestramenoi(TComponent* Owner);

};

//--- extern PACKAGE Tkatestramenoi *katestramenoi;

//---

#endif

Πλήκτρο ::

^ΑΚΥΡΟ

Όνομα πλήκτρου ::

ΑΚΥΡΟ

#include <vcl.h>

#pragma hdrstop

#include "katestramenoiForm.h"

#include "anazhthshForm.h"

#include "dbForm.h"

#include "dior8oshForm.h"

#include "Unit1.h"

#include "Unit3.h"

#include "Unit7.h"

//---

#pragma package(smart_init)

#pragma resource "*.dfm"

Tkatestramenoi *katestramenoi;

//--- __fastcall Tkatestramenoi::Tkatestramenoi(TComponent* Owner) : TForm(Owner)

{ }

//--- void __fastcall Tkatestramenoi::N2Click(TObject *Sender) {

Close();

}

//--- void __fastcall Tkatestramenoi::DBEdit1Change(TObject *Sender) {

/*

db->ADOQuery6->Close();

db->ADOQuery6->SQL->Add("SELECT distinct paragelia.kodpara,paragelia.hmnia");

db->ADOQuery6->SQL->Add("FROM paragelia");

db->ADOQuery6->SQL->Add("WHERE paragelia.id_pelath="+DBEdit1-

>Text+"");

paragelies->Edit4->Text="";

*/

DBEdit5->Text=DBEdit1->Text;

}

//--- void __fastcall Tkatestramenoi::DBEdit2Change(TObject *Sender) {

DBEdit6->Text=DBEdit2->Text;

}

//--- void __fastcall Tkatestramenoi::FormShow(TObject *Sender) {

Edit3->Text=DateToStr(Date());

}

//--- void __fastcall Tkatestramenoi::Edit3Change(TObject *Sender) {

DBEdit7->Text=Edit3->Text;

db->ADOQuery6->SQL->Add("WHERE paragelia.id_pelath="+DBEdit1-

>Text+"");

paragelies->Edit4->Text="";

*/

DBEdit5->Text=DBEdit1->Text;

}

//--- void __fastcall Tkatestramenoi::DBEdit2Change(TObject *Sender) {

DBEdit6->Text=DBEdit2->Text;

}

//--- void __fastcall Tkatestramenoi::FormShow(TObject *Sender) {

Edit3->Text=DateToStr(Date());

}

//--- void __fastcall Tkatestramenoi::Edit3Change(TObject *Sender) {

//---

void __fastcall Tkatestramenoi::DBNavigator1Click(TObject *Sender, TNavigateBtn Button)

{

db->ADOQuery7->Close();

db->ADOQuery7->SQL->Clear();

db->ADOQuery7->SQL->Add("SELECT katestramena.kwdikos, katestramena.idpelath, katestramena.pelaths, katestramena.sxolia, katestramena.hmnia");

db->ADOQuery7->SQL->Add("FROM katestramena");

db->ADOQuery7->SQL->Add("WHERE katestramena.idpelath='"+DBEdit1-

>Text+"'");

db->ADOQuery7->Open();

DBEdit5->Text=DBEdit1->Text;

DBEdit6->Text=DBEdit2->Text;

DBEdit7->Text=Edit3->Text;

//

#ifndef katestramenoiFormH

#define katestramenoiFormH

//---

#include <Classes.hpp>

}

//---

void __fastcall Tkatestramenoi::DBNavigator1Click(TObject *Sender, TNavigateBtn Button)

{

db->ADOQuery7->Close();

db->ADOQuery7->SQL->Clear();

db->ADOQuery7->SQL->Add("SELECT katestramena.kwdikos, katestramena.idpelath, katestramena.pelaths, katestramena.sxolia, katestramena.hmnia");

db->ADOQuery7->SQL->Add("FROM katestramena");

db->ADOQuery7->SQL->Add("WHERE katestramena.idpelath='"+DBEdit1-

>Text+"'");

db->ADOQuery7->Open();

DBEdit5->Text=DBEdit1->Text;

DBEdit6->Text=DBEdit2->Text;

DBEdit7->Text=Edit3->Text;

#ifndef katestramenoiFormH

#define katestramenoiFormH

//---

#include <Classes.hpp>

#include <Controls.hpp>

#include <StdCtrls.hpp>

#include <Forms.hpp>

#include <DBCtrls.hpp>

#include <DBGrids.hpp>

#include <ExtCtrls.hpp>

#include <Grids.hpp>

#include <Mask.hpp>

#include <Menus.hpp>

#include <jpeg.hpp>

//--- class Tkatestramenoi : public TForm

{

__published: // IDE-managed Components TDBGrid *DBGrid1;

TDBNavigator *DBNavigator1;

TDBEdit *DBEdit1;

TDBEdit *DBEdit2;

TDBEdit *DBEdit3;

TMenuItem *N1;

TMenuItem *N2;

TDBEdit *DBEdit5;

TDBEdit *DBEdit6;

TEdit *Edit3;

TDBEdit *DBEdit7;

TImage *Image1;

TLabel *Label8;

TLabel *Label9;

TLabel *Label5;

TLabel *Label6;

void __fastcall N2Click(TObject *Sender);

void __fastcall DBEdit1Change(TObject *Sender);

void __fastcall DBEdit2Change(TObject *Sender);

void __fastcall FormShow(TObject *Sender);

void __fastcall Edit3Change(TObject *Sender);

void __fastcall DBNavigator1Click(TObject *Sender, TNavigateBtn Button);

private: // User declarations

public: // User declarations

__fastcall Tkatestramenoi(TComponent* Owner);

extern PACKAGE Tkatestramenoi *katestramenoi;

//---

#endif

ΦΟΡΜΑ ::

ΕΚΤΥΠΩΣΗ ΛΙΣΤΑΣ ΠΕΛΑΤΩΝ

No documento Ανάπτυξη εφαρμογής βάσεως δεδομένων για βιοτεχνία αναγόμωσης και συναρμολόγησης πυροσβεστήρων. (páginas 119-140)