ΦΟΡΜΑ :: ΑΝΑΖΗΤΗΣΗ ΠΕΛΑΤΗ Όνομα φόρμας :: pelatologio

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

private: // User declarations

public: // User declarations

__fastcall Tpelatologio(TComponent* Owner);

};

//--- extern PACKAGE Tpelatologio *pelatologio;

//---

#endif

ΦΟΡΜΑ :: ΑΝΑΖΗΤΗΣΗ ΠΕΛΑΤΗ

#include "reportForm.h"

//---

#pragma package(smart_init)

#pragma resource "*.dfm"

Tanazhthsh *anazhthsh;

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

{ }

//--- void __fastcall Tanazhthsh::Edit1Change(TObject *Sender) {

db->ADOQuery1->Close();

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

db->ADOQuery1->SQL->Add("SELECT pelaths.id_pelath, pelaths.epwnymo, pelaths.onoma, pelaths.patwnymo, pelaths.afm, pelaths.adt, pelaths.job, pelaths.kwdikos_perioxhs, pelaths.polh, pelaths.odos, pelaths.tk, pelaths.thlefwno, pelaths.kinhto_1");

void __fastcall N2Click(TObject *Sender);

void __fastcall N5Click(TObject *Sender);

void __fastcall DBEdit1Change(TObject *Sender);

void __fastcall DBNavigator1Click(TObject *Sender, db->ADOQuery1->SQL->Add("FROM pelaths");

db->ADOQuery1->SQL->Add("WHERE pelaths.epwnymo like '%"+Edit1-

>Text+"%'");

db->ADOQuery1->Open();

}

//--- void __fastcall Tanazhthsh::FormCreate(TObject *Sender) {

db->ADOQuery1->Close();

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

db->ADOQuery1->SQL->Add("SELECT pelaths.id_pelath, pelaths.epwnymo, pelaths.onoma, pelaths.patwnymo, pelaths.afm, pelaths.adt, pelaths.job, pelaths.kwdikos_perioxhs, pelaths.polh, pelaths.odos, pelaths.tk,

pelaths.thlefwno, pelaths.kinhto_1");

db->ADOQuery1->SQL->Add("FROM pelaths");

db->ADOQuery1->SQL->Add("WHERE pelaths.epwnymo like 'makhspateda'");

db->ADOQuery1->Open();

}

//---

Close();

}

//--- void __fastcall Tanazhthsh::Edit2Change(TObject *Sender) {

db->ADOQuery1->Close();

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

db->ADOQuery1->SQL->Add("SELECT pelaths.id_pelath, pelaths.epwnymo, pelaths.onoma, pelaths.patwnymo, pelaths.afm, pelaths.adt, pelaths.job, pelaths.kwdikos_perioxhs, pelaths.polh, pelaths.odos, pelaths.tk, pelaths.thlefwno, pelaths.kinhto_1");

db->ADOQuery1->SQL->Add("FROM pelaths");

db->ADOQuery1->SQL->Add("WHERE pelaths.id_pelath like '%"+Edit2-

>Text+"%'");

db->ADOQuery1->Open();

}

//--- void __fastcall Tanazhthsh::DBGrid1DblClick(TObject *Sender) {

paragelies->ListBox1->Clear();

paragelies->ListBox2->Clear();

paragelies->ListBox3->Clear();

paragelies->ListBox4->Clear();

paragelies->Edit2->Text=DBEdit1->Text;

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="";

db->ADOQuery6->Open();

paragelies->Edit1->Text="";

paragelies->ShowModal();

}

//--- void __fastcall Tanazhthsh::Button1Click(TObject *Sender) {

katestramenoi->DBEdit1->Text=DBEdit1->Text;

katestramenoi->DBEdit2->Text=DBEdit2->Text;

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();

katestramenoi->ShowModal();

}

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

db->ADOQuery1->Close();

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

db->ADOQuery1->SQL->Add("SELECT pelaths.id_pelath, pelaths.epwnymo, pelaths.onoma, pelaths.patwnymo, pelaths.afm, pelaths.adt, pelaths.job, pelaths.kwdikos_perioxhs, pelaths.polh, pelaths.odos, pelaths.tk, pelaths.thlefwno, pelaths.kinhto_1");

db->ADOQuery1->SQL->Add("FROM pelaths");

db->ADOQuery1->SQL->Add("WHERE pelaths.polh like '%"+Edit3-

>Text+"%'");

db->ADOQuery1->Open();

}

//--- void __fastcall Tanazhthsh::N4Click(TObject *Sender) {

report->QuickRep1->Preview();

}

//--- void __fastcall Tanazhthsh::Image1Click(TObject *Sender)

}

#ifndef anazhthshFormH

#define anazhthshFormH

//---

#include <Classes.hpp>

#include <Controls.hpp>

#include <StdCtrls.hpp>

#include <Forms.hpp>

#include <DBGrids.hpp>

#include <Grids.hpp>

#include <Menus.hpp>

#include <DBCtrls.hpp>

#include <Mask.hpp>

#include <ExtCtrls.hpp>

#include <jpeg.hpp>

//--- class Tanazhthsh : public TForm

{

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

TEdit *Edit1;

TMainMenu *MainMenu1;

TMenuItem *N1;

TMenuItem *N2;

TLabel *Label1;

TEdit *Edit2;

TLabel *Label2;

TDBEdit *DBEdit1;

TButton *Button1;

TDBEdit *DBEdit2;

TImage *Image1;

TEdit *Edit3;

TLabel *Label3;

TMenuItem *N3;

TMenuItem *N4;

void __fastcall Edit1Change(TObject *Sender);

void __fastcall FormCreate(TObject *Sender);

void __fastcall N2Click(TObject *Sender);

void __fastcall Edit3Change(TObject *Sender);

void __fastcall N4Click(TObject *Sender);

void __fastcall Image1Click(TObject *Sender);

private: // User declarations

public: // User declarations

//--- extern PACKAGE Tanazhthsh *anazhthsh;

//---

#endif

Πλήκτρο ::

Σύμφωνα με το επώνυμο

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

Edit1Change

void __fastcall Tanazhthsh::Edit1Change(TObject *Sender) {

db->ADOQuery1->Close();

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

db->ADOQuery1->SQL->Add("SELECT pelaths.id_pelath, pelaths.epwnymo, void __fastcall Edit2Change(TObject *Sender);

void __fastcall DBGrid1DblClick(TObject *Sender);

void __fastcall Button1Click(TObject *Sender);

pelaths.onoma, pelaths.patwnymo, pelaths.afm, pelaths.adt, pelaths.job, pelaths.kwdikos_perioxhs, pelaths.polh, pelaths.odos, pelaths.tk,

pelaths.thlefwno, pelaths.kinhto_1");

db->ADOQuery1->SQL->Add("FROM pelaths");

db->ADOQuery1->SQL->Add("WHERE pelaths.epwnymo like '%"+Edit1-

>Text+"%'");

db->ADOQuery1->Open();

}

Πλήκτρο ::

Σύμφωνα με κωδικό

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

Edit2Change

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

db->ADOQuery1->Close();

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

db->ADOQuery1->SQL->Add("SELECT pelaths.id_pelath, pelaths.epwnymo, void __fastcall Edit2Change(TObject *Sender);

void __fastcall DBGrid1DblClick(TObject *Sender);

pelaths.onoma, pelaths.patwnymo, pelaths.afm, pelaths.adt, pelaths.job, pelaths.kwdikos_perioxhs, pelaths.polh, pelaths.odos, pelaths.tk,

pelaths.thlefwno, pelaths.kinhto_1");

db->ADOQuery1->SQL->Add("FROM pelaths");

db->ADOQuery1->SQL->Add("WHERE pelaths.epwnymo like 'makhspateda'");

db->ADOQuery1->Open();

}

Πλήκτρο ::

Σύμφωνα με Πόλη

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

Edit2Change

void __fastcall Tanazhthsh::Edit3Change(TObject *Sender) {

db->ADOQuery1->Close();

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

db->ADOQuery1->SQL->Add("SELECT pelaths.id_pelath, pelaths.epwnymo, pelaths.onoma, pelaths.patwnymo, pelaths.afm, pelaths.adt, pelaths.job, pelaths.kwdikos_perioxhs, pelaths.polh, pelaths.odos, pelaths.tk,

pelaths.thlefwno, pelaths.kinhto_1");

db->ADOQuery1->SQL->Add("FROM pelaths");

db->ADOQuery1->SQL->Add("WHERE pelaths.polh like '%"+Edit3-

>Text+"%'");

db->ADOQuery1->Open();

Πλήκτρο ::

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

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

katestramenoi

#include <vcl.h>

#pragma hdrstop

#include "katestramenoiForm.h"

#include "anazhthshForm.h"

#include "dbForm.h"

#include "dior8oshForm.h"

#include "Unit1.h"

#include "Unit3.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");

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 *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);

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

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

TDBNavigator *DBNavigator1;

TDBEdit *DBEdit1;

TDBEdit *DBEdit2;

TDBEdit *DBEdit3;

TDBEdit *DBEdit4;

paragelies->Edit4->Text="";

*/

DBEdit5->Text=DBEdit1->Text;

}

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

DBEdit6->Text=DBEdit2->Text;

}

//--- private: // User declarations

public: // User declarations

__fastcall Tkatestramenoi(TComponent* Owner);

};

//---

#endif

ΦΟΡΜΑ ::

ΠΑΡΑΓΓΕΛΙΕΣ

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