Όνομα φόρμας :: print_pelatwn - Ανάπτυξη εφαρμογής βάσεως δεδομένων για βιοτεχνία αναγόμωσης κα

extern PACKAGE Tkatestramenoi *katestramenoi;

//---

#endif

ΦΟΡΜΑ ::

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

#include <Controls.hpp>

#include <StdCtrls.hpp>

#include <Forms.hpp>

#include <DBGrids.hpp>

#include <Grids.hpp>

#include <Menus.hpp>

#include <ExtCtrls.hpp>

#include <jpeg.hpp>

#include <DBCtrls.hpp>

#include <Mask.hpp>

//--- class Tparaprint : public TForm

{

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

TMainMenu *MainMenu1;

TMenuItem *N1;

TMenuItem *N2;

TMenuItem *N3;

TMenuItem *N4;

TEdit *Edit2;

TLabel *Label2;

TImage *Image1;

TDBEdit *DBEdit1;

TDBEdit *DBEdit2;

TDBEdit *DBEdit3;

TDBEdit *DBEdit4;

TLabel *Label1;

TLabel *Label2;

TLabel *Label3;

TLabel *Label4;

TMainMenu *MainMenu1;

void __fastcall N2Click(TObject *Sender);

void __fastcall Edit2Change(TObject *Sender);

void __fastcall N4Click(TObject *Sender);

private: // User declarations

public: // User declarations

__fastcall Tparaprint(TComponent* Owner);

};

//--- extern PACKAGE Tparaprint *paraprint;

//---

#endif

ΦΟΡΜΑ ::

ΑΠΟΘΗΚΗ

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

Το μενού της Αποθήκης.

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

#ifndef Unit3H

#define Unit3H

//---

#include <Classes.hpp>

#include <Controls.hpp>

#include <StdCtrls.hpp>

#include <DB.hpp>

#include <DBCtrls.hpp>

#include <DBGrids.hpp>

#include <ExtCtrls.hpp>

#include <Grids.hpp>

#include <Menus.hpp>

#include <jpeg.hpp>

//--- class Tapothikh : public TForm

{

__published: // IDE-managed Components TDBNavigator *DBNavigator2;

TDBNavigator *DBNavigator1;

TButton *Button2;

TDBGrid *DBGrid1;

TLabel *Label2;

TLabel *Label3;

TDBNavigator *DBNavigator3;

TDBNavigator *DBNavigator4;

TLabel *Label4;

TLabel *Label5;

TMainMenu *MainMenu1;

TMenuItem *N1;

TMenuItem *N2;

TDBGrid *DBGrid2;

TMenuItem *N3;

TMenuItem *N4;

TImage *Image1;

TMenuItem *N5;

TMenuItem *N6;

TLabel *Label1;

void __fastcall N2Click(TObject *Sender);

void __fastcall Button2Click(TObject *Sender);

void __fastcall N4Click(TObject *Sender);

void __fastcall FormShow(TObject *Sender);

void __fastcall N6Click(TObject *Sender);

private: // User declarations

public: // User declarations

__fastcall Tapothikh(TComponent* Owner);

};

//--- extern PACKAGE Tapothikh *apothikh;

//---

#endif

#include "Unit3.h"

#include "Unit1.h"

#include "Unit2.h"

#include "Unit5.h"

#include "Unit4.h"

#include "anazhthshForm.h"

#include "dbForm.h"

#include "Unit6.h"

#include "Unit7.h"

#include "orioForm.h"

#include "ekremeisForm.h"

#include "paraprintForm.h"

#include "reportForm.h"

//---

#pragma package(smart_init)

#pragma resource "*.dfm"

Tapothikh *apothikh;

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

{ }

//---

void __fastcall Tapothikh::N2Click(TObject *Sender) {

Close();

}

//---

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

epe3->ShowModal();

}

//---

void __fastcall Tapothikh::N4Click(TObject *Sender) {

orio->ShowModal();

}

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

db->ADOQuery2->Close();

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

db->ADOQuery2->SQL->Add("SELECT apo8hkh1.id, apo8hkh1.eidos, apo8hkh1.temaxia");

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

db->ADOQuery2->SQL->Add("WHERE apo8hkh1.temaxia<"+orio-

>DBEdit1->Text+"");

db->ADOQuery2->Open();

}

//--- void __fastcall Tapothikh::N6Click(TObject *Sender)

{

db->ADOQuery13->Close();

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

db->ADOQuery13->SQL->Add("SELECT apo8hkh1.id, apo8hkh1.kvdikos, apo8hkh1.eidos, apo8hkh1.temaxia, apo8hkh1.loipa_sxolia, apo8hkh1.price");

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

//db->ADOQuery13->SQL->Add("WHERE apo8hkh1.temaxia<"+orio-

>DBEdit1->Text+"");

db->ADOQuery13->Open();

report->QuickRep4->Preview();

}

//--- void __fastcall Tapothikh::Image1Click(TObject *Sender) {

}

Πλήκτρο ::

ΕΠΕΞΕΡΓΑΣΙΑ ΥΛΙΚΩΝ ΑΠΟΘΗΚΗΣ

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

epe3

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

epe3->ShowModal();

}

#ifndef Unit5H

#define Unit5H

//---

#include <Classes.hpp>

#include <Controls.hpp>

#include <StdCtrls.hpp>

#include <Forms.hpp>

#include <DBCtrls.hpp>

#include <Mask.hpp>

#include <ExtCtrls.hpp>

#include <Menus.hpp>

#include <jpeg.hpp>

//--- class Tepe3 : public TForm

{

__published: // IDE-managed Components TLabel *Label1;

TLabel *Label2;

TLabel *Label3;

TLabel *Label4;

TDBEdit *DBEdit1;

TDBEdit *DBEdit2;

TDBEdit *DBEdit3;

TDBEdit *DBEdit4;

TDBNavigator *DBNavigator1;

TDBNavigator *DBNavigator2;

TDBNavigator *DBNavigator3;

TDBNavigator *DBNavigator4;

TDBNavigator *DBNavigator5;

TLabel *Label5;

TLabel *Label6;

TLabel *Label7;

TLabel *Label8;

TLabel *Label9;

TMainMenu *MainMenu1;

TMenuItem *N1;

TMenuItem *N2;

TLabel *Label10;

TDBEdit *DBEdit6;

TImage *Image1;

void __fastcall N2Click(TObject *Sender);

void __fastcall FormClose(TObject *Sender, TCloseAction &Action);

private: // User declarations

public: // User declarations

__fastcall Tepe3(TComponent* Owner);

};

//--- extern PACKAGE Tepe3 *epe3;

//---

#endif

Πλήκτρο ::

ΛΙΣΤΑ ΥΛΙΚΩΝ

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

print_list

void __fastcall Tapothikh::N6Click(TObject *Sender) {

db->ADOQuery13->Close();

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

TDBEdit *DBEdit4;

TLabel *Label1;

TLabel *Label2;

TLabel *Label3;

TLabel *Label4;

TMainMenu *MainMenu1;

db->ADOQuery13->SQL->Add("SELECT apo8hkh1.id, apo8hkh1.kvdikos, apo8hkh1.eidos, apo8hkh1.temaxia, apo8hkh1.loipa_sxolia, apo8hkh1.price");

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

//db->ADOQuery13->SQL->Add("WHERE apo8hkh1.temaxia<"+orio-

>DBEdit1->Text+"");

db->ADOQuery13->Open();

report->QuickRep4->Preview();

}

Πλήκτρο ::

ΌΡΙΟ ΑΣΦΑΛΕΙΑΣ

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

orio

void __fastcall Tapothikh::N4Click(TObject *Sender)

}

ΦΟΡΜΑ ::

ΕΚΚΡΕΜΟΥΣΕΣ ΠΑΡΑΓΓΕΛΙΕΣ

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

^ekremeis

Εδώ βρισκόμαστε στο μενού των Εκκρεμών παραγγελιών.

Με την παραπάνω φόρμα μπορούμε να προγραμματίσουμε τις παραγγελίες που είναι πιθανόν να γίνούν.

Πλήκτρο ::

ΗΜΕΡΟΛΟΓΙΟ

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

monthcalendar1

#include <vcl.h>

#pragma hdrstop

#include "ekremeisForm.h"

#include "anazhthshForm.h"

#include "dbForm.h"

#include "dior8oshForm.h"

#include "katestramenoiForm.h"

#include "Unit1.h"

#include "Unit7.h"

#include "paraprintForm.h"

#include "reportForm.h"

//---

#pragma package(smart_init)

#pragma resource "*.dfm"

Tekremeis *ekremeis;

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

{ }

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

{

Close();

}

//---

void __fastcall Tekremeis::MonthCalendar1Click(TObject *Sender) {

db->ADOQuery8->Close();

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

db->ADOQuery8->SQL->Add("SELECT distinct

paragelia.kodpara,paragelia.id_pelath,paragelia.hmnia,paragelia.hmnialh3hs, pelaths.epwnymo, pelaths.onoma");

db->ADOQuery8->SQL->Add("FROM paragelia INNER JOIN pelaths ON paragelia.id_pelath = pelaths.id_pelath");

db->ADOQuery8->SQL->Add("WHERE

paragelia.hmnialh3hs='"+MonthCalendar1->Date+"'");

db->ADOQuery8->Open();

Edit1->Text=MonthCalendar1->Date;

//SELECT pelaths.epwnymo, pelaths.onoma

//FROM paragelia INNER JOIN pelaths ON paragelia.id_pelath = pelaths.id_pelath;

}

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

MonthCalendar1->Date=DateToStr(Date());

db->ADOQuery8->Close();

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

paragelia.kodpara,paragelia.id_pelath");

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

db->ADOQuery8->SQL->Add("WHERE paragelia.hmnialh3hs='makhs'");

db->ADOQuery8->Open();

}

//---

void __fastcall Tekremeis::DBLookupListBox2Click(TObject *Sender) {

paragelies->ListBox1->Clear();

paragelies->ListBox2->Clear();

paragelies->ListBox3->Clear();

paragelies->ListBox4->Clear();

paragelies->Edit4->Text=DBEdit1->Text;

paragelies->Edit2->Text=DBEdit2->Text;

paragelies->ShowModal();

}

//--- void __fastcall Tekremeis::N4Click(TObject *Sender)

{

report->QRLabel32->Caption=Edit1->Text;

report->QuickRep3->Preview();

}

//---

#ifndef ekremeisFormH

#define ekremeisFormH

//---

#include <Classes.hpp>

#include <Controls.hpp>

#include <StdCtrls.hpp>

#include <Forms.hpp>

#include <ComCtrls.hpp>

#include <DBCtrls.hpp>

#include <Menus.hpp>

#include <Mask.hpp>

#include <ExtCtrls.hpp>

#include <jpeg.hpp>

//--- class Tekremeis : public TForm

{

__published: // IDE-managed Components

TMainMenu *MainMenu1;

TMenuItem *N1;

TMenuItem *N2;

TDBLookupListBox *DBLookupListBox2;

TLabel *Label1;

TLabel *Label2;

TDBEdit *DBEdit1;

TLabel *Label3;

TImage *Image1;

TMenuItem *N3;

TMenuItem *N4;

TEdit *Edit1;

TDBEdit *DBEdit2;

void __fastcall N2Click(TObject *Sender);

void __fastcall DBLookupListBox2Click(TObject *Sender);

void __fastcall N4Click(TObject *Sender);

private: // User declarations

public: // User declarations

__fastcall Tekremeis(TComponent* Owner);

};

//--- extern PACKAGE Tekremeis *ekremeis;

//---

#endif

Πλήκτρο ::

Κωδικός Παραγγελίας

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

DbLookupListBox2

void __fastcall Tekremeis::DBLookupListBox2Click(TObject *Sender) {

paragelies->ListBox1->Clear();

paragelies->ListBox2->Clear();

paragelies->ListBox3->Clear();

paragelies->ListBox4->Clear();

paragelies->Edit4->Text=DBEdit1->Text;

paragelies->Edit2->Text=DBEdit2->Text;

paragelies->ShowModal();

}

Πλήκτρο ::

Εκτύπωση Εκκρεμών Παραγγελιών

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

ekkremeisprint

{

report->QRLabel32->Caption=Edit1->Text;

report->QuickRep3->Preview();

}

ΦΟΡΜΑ ::

ΗΜΕΡΟΛΟΓΙΟ

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

^notes

Εδώ βρισκόμαστε στο ημερολόγιο του προγράμματος.

Η παρακάτω φόρμα έχει την χρήση μίας αντζέντας όπου μπορεί ο χρήστης να καταχωρίσει διάφορες προγραμματισμένες εργασίες.

#ifndef notesFormH

#define notesFormH

//---

#include <Classes.hpp>

#include <Controls.hpp>

#include <StdCtrls.hpp>

#include <Forms.hpp>

#include <ComCtrls.hpp>

#include <ADODB.hpp>

#include <Menus.hpp>

#include <DBCtrls.hpp>

#include <ExtCtrls.hpp>

#include <jpeg.hpp>

//--- class Tnotes : public TForm

{

TButton *Button1;

TADOCommand *ADOCommand1;

TEdit *Edit1;

TEdit *Edit2;

TLabel *Label1;

TMainMenu *MainMenu1;

TMenuItem *N1;

TMenuItem *N2;

TDBLookupListBox *DBLookupListBox1;

TLabel *Label2;

TButton *Button2;

TImage *Image1;

TMenuItem *N3;

TMenuItem *N4;

void __fastcall FormShow(TObject *Sender);

void __fastcall Button1Click(TObject *Sender);

void __fastcall MonthCalendar1Click(TObject *Sender);

void __fastcall N2Click(TObject *Sender);

void __fastcall Button2Click(TObject *Sender);

void __fastcall N4Click(TObject *Sender);

private: // User declarations

public: // User declarations

__fastcall Tnotes(TComponent* Owner);

};

//--- extern PACKAGE Tnotes *notes;

//---

#endif

Πλήκτρο ::

Καταχώριση

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

Button1

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

ADOCommand1->CommandText="";

ADOCommand1->CommandText="INSERT INTO notes (hmnia,sxolia) VALUES('"+Edit2->Text+"','"+Edit1->Text+"')";

ADOCommand1->Execute();

}

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

ADOCommand1->CommandText="";

ADOCommand1->CommandText="DELETE * FROM notes WHERE db->ADOQuery9->SQL->Clear();

TImage *Image1;

TMenuItem *N3;

TMenuItem *N4;

void __fastcall FormShow(TObject *Sender);

void __fastcall Button1Click(TObject *Sender);

void __fastcall MonthCalendar1Click(TObject *Sender);

void __fastcall N2Click(TObject *Sender);

void __fastcall Button2Click(TObject *Sender);

void __fastcall N4Click(TObject *Sender);

db->ADOQuery9->SQL->Add("SELECT notes.id, notes.hmnia, notes.sxolia");

db->ADOQuery9->SQL->Add("FROM notes");

TDBLookupListBox *DBLookupListBox1;

TLabel *Label2;

TButton *Button2;

TImage *Image1;

TMenuItem *N3;

TMenuItem *N4;

void __fastcall FormShow(TObject *Sender);

db->ADOQuery9->SQL->Add("WHERE notes.hmnia='"+Edit2->Text+"'");

db->ADOQuery9->Open();

}

Πλήκτρο ::

Εκτύπωση Σημειώσεων ημέρας

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

notesprint

void __fastcall Tnotes::N4Click(TObject *Sender) {

report->QRLabel47->Caption=Edit2->Text;

report->QuickRep5->Preview();

}

ΦΟΡΜΑ ::

ΟΔΗΓΙΕΣ ΧΡΗΣΗΣ

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