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

//---

#endif

ΦΟΡΜΑ ::

ΠΑΡΑΓΓΕΛΙΕΣ

#include "orioForm.h"

#include "Unit5.h"

//#include "Unit8.h"

#include "dior8oshForm.h"

#include "paraprintForm.h"

#include "reportForm.h"

//---

#pragma package(smart_init)

#pragma resource "*.dfm"

Tparagelies *paragelies;

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

{ }

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

Close();

}

//---

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

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

ListBox1->Items->Add(DBEdit4->Text);

ListBox2->Items->Add(DBEdit1->Text);

ListBox4->Items->Add(Edit1->Text);

ListBox3->Items->Add(FloatToStr(StrToFloat(Edit1-

>Text)*StrToFloat(DBEdit5->Text)));

/*

float a;

a=StrToFloat(FloatToStr(StrToFloat(Edit1->Text)*StrToFloat(DBEdit5-

>Text)));

Edit6->Text=FloatToStr(StrToFloat(Edit6->Text)+a);

*/

double a;

Edit6->Text=FloatToStr(StrToFloat(Edit6->Text)+a);

ADOCommand1->CommandText="";

ADOCommand1->CommandText="INSERT INTO paragelia

(kodpara,kvdikos,eidos,temaxia,id_pelath,hmnia,hmnialh3hs)

VALUES('"+Edit4->Text+"','"+DBEdit4->Text+"','"+DBEdit1->Text+"','"+Edit1-

>Text+"',"+Edit2->Text+",'"+Edit3->Text+"','"+Edit5->Text+"')";

ADOCommand1->Execute();

ADOCommand2->CommandText="";

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

ADOCommand2->Execute();

db->ADOTable2->Active=false;

db->ADOTable2->Active=true;

ADOCommand2->CommandText="";

ADOCommand2->CommandText="UPDATE paragelia SET paragelia.sum = '"+Edit6->Text+"' WHERE paragelia.kodpara='"+Edit4->Text+"'";

ADOCommand2->Execute();

} else

MessageDlg("", mtInformation,TMsgDlgButtons() << mbOK, 0);

}

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

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

Edit5->Text=DateToStr(Date()+365);

//DateTimePicker1->Date+365;

}

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

db->ADOQuery3->Close();

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

db->ADOQuery3->SQL->Add("SELECT pelaths.id_pelath, pelaths.epwnymo,

db->ADOQuery3->SQL->Add("WHERE pelaths.id_pelath="+Edit2->Text+"");

db->ADOQuery3->Open();

}

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

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='"+Edit4-

>Text+"'");

db->ADOQuery4->Open();

dior8osh->ShowModal();

}

//--- void __fastcall Tparagelies::Edit4Change(TObject *Sender) {

paragelies->ListBox1->Clear();

paragelies->ListBox2->Clear();

paragelies->ListBox3->Clear();

paragelies->ListBox4->Clear();

Edit6->Text="0,0";

db->ADOQuery5->Close();

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

db->ADOQuery5->SQL->Add("SELECT paragelia.id, paragelia.kodpara");

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

db->ADOQuery5->SQL->Add("WHERE paragelia.kodpara='"+Edit4-

>Text+"'");

db->ADOQuery5->Open();

if(DBEdit6->Text!="") Label11->Caption="ÕðÜñ÷åé êáôá÷ùñçìÝíïò";

else Label11->Caption="Äåí õðÜñ÷åé êáôá÷ùñçìÝíïò";

}

//---

void __fastcall Tparagelies::DBLookupListBox4Click(TObject *Sender)

{

paraprint->Edit2->Text=DBEdit7->Text;

paraprint->ShowModal();

} }

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

}

#ifndef Unit7H

#define Unit7H

//---

#include <Classes.hpp>

#include <Controls.hpp>

#include <StdCtrls.hpp>

#include <Forms.hpp>

#include <ADODB.hpp>

#include <DB.hpp>

#include <DBCtrls.hpp>

#include <DBGrids.hpp>

#include <Grids.hpp>

#include <Mask.hpp>

#include <Menus.hpp>

#include <ComCtrls.hpp>

#include <ExtCtrls.hpp>

#include <jpeg.hpp>

//--- class Tparagelies : public TForm

{

__published: // IDE-managed Components TDBLookupListBox *DBLookupListBox1;

TDBEdit *DBEdit1;

TMainMenu *MainMenu1;

TMenuItem *N1;

TMenuItem *N2;

TListBox *ListBox1;

TEdit *Edit1;

TLabel *Label1;

TLabel *Label2;

TADOCommand *ADOCommand1;

TButton *Button1;

TEdit *Edit2;

TEdit *Edit3;

TLabel *Label3;

TLabel *Label4;

TLabel *Label5;

TLabel *Label6;

TListBox *ListBox2;

TListBox *ListBox3;

TDBLookupListBox *DBLookupListBox2;

TLabel *Label7;

TDBLookupListBox *DBLookupListBox3;

TDBEdit *DBEdit4;

TDBEdit *DBEdit5;

TListBox *ListBox4;

TLabel *Label8;

TLabel *Label9;

TButton *Button2;

TEdit *Edit4;

TLabel *Label10;

TLabel *Label11;

TDBEdit *DBEdit6;

TDBLookupListBox *DBLookupListBox4;

TDBLookupListBox *DBLookupListBox5;

TLabel *Label12;

TLabel *Label13;

TEdit *Edit5;

TLabel *Label14;

TDBLookupListBox *DBLookupListBox6;

TLabel *Label15;

TImage *Image1;

TDBEdit *DBEdit7;

TADOCommand *ADOCommand2;

TEdit *Edit6;

TLabel *Label16;

TLabel *Label17;

TLabel *Label18;

TLabel *Label19;

void __fastcall N2Click(TObject *Sender);

void __fastcall Button1Click(TObject *Sender);

void __fastcall FormShow(TObject *Sender);

void __fastcall Edit2Change(TObject *Sender);

void __fastcall Button2Click(TObject *Sender);

void __fastcall Edit4Change(TObject *Sender);

void __fastcall DBLookupListBox4Click(TObject *Sender);

void __fastcall FormCreate(TObject *Sender);

void __fastcall DBEdit3Change(TObject *Sender);

void __fastcall DBEdit4Change(TObject *Sender);

void __fastcall DBEdit5Change(TObject *Sender);

void __fastcall DBEdit6Change(TObject *Sender);

void __fastcall DBEdit7Change(TObject *Sender);

void __fastcall DBLookupListBox1Click(TObject *Sender);

void __fastcall DBLookupListBox2Click(TObject *Sender);

void __fastcall DBLookupListBox3Click(TObject *Sender);

void __fastcall DBLookupListBox5Click(TObject *Sender);

void __fastcall DBLookupListBox6Click(TObject *Sender);

void __fastcall Edit1Change(TObject *Sender);

void __fastcall Edit3Change(TObject *Sender);

void __fastcall Edit5Change(TObject *Sender);

void __fastcall Edit6Change(TObject *Sender);

void __fastcall Image1Click(TObject *Sender);

void __fastcall Label1Click(TObject *Sender);

void __fastcall Label10Click(TObject *Sender);

void __fastcall Label11Click(TObject *Sender);

void __fastcall Label12Click(TObject *Sender);

void __fastcall Label13Click(TObject *Sender);

void __fastcall Label14Click(TObject *Sender);

void __fastcall Label15Click(TObject *Sender);

void __fastcall Label16Click(TObject *Sender);

void __fastcall Label17Click(TObject *Sender);

void __fastcall Label18Click(TObject *Sender);

void __fastcall Label19Click(TObject *Sender);

void __fastcall Label2Click(TObject *Sender);

void __fastcall Label3Click(TObject *Sender);

void __fastcall Label4Click(TObject *Sender);

void __fastcall Label5Click(TObject *Sender);

void __fastcall Label6Click(TObject *Sender);

void __fastcall ListBox2Click(TObject *Sender);

void __fastcall ListBox1Click(TObject *Sender);

void __fastcall ListBox4Click(TObject *Sender);

private: // User declarations

public: // User declarations

__fastcall Tparagelies(TComponent* Owner);

};

//--- extern PACKAGE Tparagelies *paragelies;

//---

#endif

Πλήκτρο ::

Εισαγωγή στην λίστα

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

^Button1

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

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

ListBox1->Items->Add(DBEdit4->Text);

ListBox2->Items->Add(DBEdit1->Text);

ListBox4->Items->Add(Edit1->Text);

ListBox3->Items->Add(FloatToStr(StrToFloat(Edit1-

>Text)*StrToFloat(DBEdit5->Text)));

double a;

a=StrToFloat(FloatToStr(StrToFloat(Edit1->Text)*StrToFloat(DBEdit5-

>Text)));

Edit6->Text=FloatToStr(StrToFloat(Edit6->Text)+a);

ADOCommand1->CommandText="";

ADOCommand1->CommandText="INSERT INTO paragelia (kodpara,kvdikos,eidos,temaxia,id_pelath,hmnia,hmnialh3hs)

VALUES('"+Edit4->Text+"','"+DBEdit4->Text+"','"+DBEdit1->Text+"','"+Edit1-

>Text+"',"+Edit2->Text+",'"+Edit3->Text+"','"+Edit5->Text+"')";

ADOCommand1->Execute();

ADOCommand2->CommandText="";

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

ADOCommand2->Execute();

db->ADOTable2->Active=false;

db->ADOTable2->Active=true;

ADOCommand2->CommandText="";

ADOCommand2->CommandText="UPDATE paragelia SET paragelia.sum = '"+Edit6->Text+"' WHERE paragelia.kodpara='"+Edit4->Text+"'";

ADOCommand2->Execute();

} else

MessageDlg("", mtInformation,TMsgDlgButtons() << mbOK, 0);

}

Πλήκτρο ::

Παραγγελίες

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

DBLookupListBox4

void __fastcall Tparagelies::DBLookupListBox4Click(TObject *Sender) {

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

paraprint->Edit2->Text=DBEdit7->Text;

paraprint->ShowModal();

}

Πλήκτρο ::

Κωδικός Πελάτη

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

Edit2

void __fastcall Tparagelies::Edit2Change(TObject *Sender) {

db->ADOQuery3->Close();

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

db->ADOQuery3->SQL->Add("SELECT pelaths.id_pelath, pelaths.epwnymo, pelaths.onoma");

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

db->ADOQuery3->SQL->Add("WHERE pelaths.id_pelath="+Edit2->Text+"");

db->ADOQuery3->Open();

}

Πλήκτρο ::

ΚΩΔΙΚΟΣ ΠΑΡΑΓΓΕΛΙΑΣ

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

Edit4

void __fastcall Tparagelies::Edit4Change(TObject *Sender) {

paragelies->ListBox1->Clear();

paragelies->ListBox2->Clear();

paragelies->ListBox3->Clear();

db->ADOQuery5->Close();

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

db->ADOQuery5->SQL->Add("SELECT paragelia.id, paragelia.kodpara");

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

db->ADOQuery5->SQL->Add("WHERE paragelia.kodpara='"+Edit4-

>Text+"'");

db->ADOQuery5->Open();

if(DBEdit6->Text!="") Label11->Caption=" ";

else Label11->Caption=" ";

}

Πλήκτρο ::

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

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

^Button2

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

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

paragelies->ListBox2->Clear();

paragelies->ListBox3->Clear();

paragelies->ListBox4->Clear();

db->ADOQuery3->Close();

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

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

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

>Text+"'");

db->ADOQuery4->Open();

dior8osh->ShowModal();

}

ΦΟΡΜΑ ::

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

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