|
La BD: "Lista Vinuri" sa se realizeze un program in care cu ajutorul
unui meniu numit "M1", sa se faca operatiile: 1. Adaugare;
2. Modificare;
3. Cautare;
4. Iesire.
Pentru fiecare operatie se va activa cate o fereastra, definita
anterior, colorate, prima fereastra avand butoanele: Incarcare, Anulare si
Iesire. Programul va fi numit " Lista_vin.prg" :
Public M.Nume,M.An_recolta,M.Tip,;
M.Culoare,M.Origine,M.Recomandat,M.Servire_gr,;
M.Pret_unit,M.Cant_com,M.Total
DO inceput
DO actualizare
DO modificare
DO cautare
*======*
Proc inceput
Clear
set talk off
use Lista_vinuri exclusive
set safety off
use Lista_vinuri index iAn_recolta
define wind W1 from 0,0,4,79 to 23,75;
title "Fereastra Adaugare";
colo RGB(0,0,0,0,200,0)
define wind W2 from 0,0,4,79 to 23,75 fill chr(179);
title "Fereastra Modificare" Shadow;
colo RGB(0,0,0,0,210)
define wind W3 from 0,0,4,79 to 23,75;
title "Fereastra Cautare" ;
colo RGB(0,0,0,0,100,0)
@20,1 Say "F1 = Vizualizare BD"
On key label F1 brow nomodi nodel;
noappe norm timeout 2
Return
*=======*
Proc Actualizare
@0,0,4,79 box
define Menu M1;
mess"Selectati o optiune"
define pad ADAUGARE of M1;
prompt "\";
mess"Adaugati articole noi"
define pad MODIFICARE of M1;
prompt "\";
mess"Faceti modificari"
define pad CAUTARE of M1;
prompt "\";
mess"Cautati articole"
define pad IESIRE of M1;
prompt "\";
mess"Iesire din meniu"
on selection pad "ADAUGARE" of M1 do ADAUGARE
define wind W1 from 0,0,4,79 to 23,75;
title "Fereastra Adaugare";
colo RGB(0,0,0,0,200,0)
acti wind W1
on selection pad "MODIFICARE" of M1 do MODIFICARE
define wind W2 from 0,0,4,79 to 23,75;
title "Fereastra Modificare" Shadow;
colo RGB(0,0,0,0,210)
acti wind W2
on selection pad "CAUTARE" of M1 do CAUTARE
define wind W3 from 0,0,4,79 to 23,75;
title "Fereastra Cautare";
colo RGB(0,0,0,0,100,0)
acti wind W3
on selection pad "IESIRE" of M1 do IESIRE
deactivate menu M1
activate menu M1
READ
DEACTIVATE MENU M1
Proc paduri
do case
case pad()="ADAUGARE"
do ADAUGARE
append
case pad()="MODIFICARE"
do MODIFICARE
brow
case pad()="CAUTARE"
do CAUTARE
case pad()="IESIRE"
deactivate menu M1
endcase
return
*======*
Proc ADAUGARE
on key label F1 brow noappe nomodi;
nodele norma timeout 3
define wind W1 from 0,0,4,79 to 26,75;
title "Fereastra Adaugare";
colo RGB(0,0,0,0,200,0)
acti wind W1
scatter memvar blank
@1,1 say "Nume:" get M.Nume
@3,3 say "An_recolta:" get M.An_recolta
@5,3 say "Tip:" get M.Tip
@7,3 say "Culoare:" get M.Culoare
@9,3 say "Origine:" get M.Origine
@11,3 say "Recomandat:" get M.Re |