aplicatia 6 - functii de consultare si functii text (2)

31
Cod client 105 Adresa Localitate Judeţ 107 Client1 Str. Florilor nr.36 bl.8 Pitesti Arges 104Client2 Str. Sincai nr.45, sc. Bc r esti Bc re!ti 102 Client7 Str. A "eresc Braso" Bra!o" 101 Client4 Str. 1 #ai nr.36, bl A8Ploiesti Pra$o"a 105 Client3 Str. % #ai Bcresti Bcre!ti 100 Client7 Str. Plo&ilor nr.1 B'rlad ( asli 108 Client8 Str. )teran* nr. 3 +e"a nedoara Cod Fiscal 23187%46 Cod Client Nume Client S* se rec&ere-e codul fscal  al cli ent li a l c*r i cod a os

Upload: nicolae-nistor

Post on 25-Feb-2018

252 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Aplicatia 6 - Functii de Consultare Si Functii Text (2)

7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)

http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 1/31

Cod client 105

Adresa Localitate Judeţ

107Client1 Str. Florilor nr.36 bl.8 Pitesti Arges104Client2 Str. Sincai nr.45, sc. Bcresti Bcre!ti

102Client7 Str. A"eresc Braso" Bra!o"

101Client4 Str. 1 #ai nr.36, bl A8Ploiesti Pra$o"a

105Client3 Str. % #ai Bcresti Bcre!ti

100 Client7 Str. Plo&ilor nr.1 B'rlad (asli

108Client8 Str. )teran* nr. 3 +e"a nedoara

Cod Fiscal 23187%46

CodClient

NumeClient

S* se rec&ere-e codul fscal  al clientli al c*ri cod a os

Page 2: Aplicatia 6 - Functii de Consultare Si Functii Text (2)

7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)

http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 2/31

Cod Fiscal

3465564513246873

%6325814

75315%46

23187%46

64821%73

57351%84

selectat dintr/o list* derlant* locali-at* la adresa 2.

Page 3: Aplicatia 6 - Functii de Consultare Si Functii Text (2)

7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)

http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 3/31

Cod ISBN Titlu carte

2C+ SB S Co&ania de libr*Bcre!ti

73/6842/67/4 +esign eb Co&ania de libr* Bcre!ti

73/6842/67/3(isal Basic or A&&licatio)ibr*ria 9Central9 Sibi

73/6842/67/5 Ba-e de +ate (o: 2000 Bcre!ti

73/6842/67/6;ce 2010 / A&lica<ii Co&ania de libr*Bra!o"

73/6842/67/6 ;ce 2010 / A&lica<ii )ibr*ria 9Central9 Cl=

73/6842/67/5 Ba-e de +ate olCris Sibi

73/6842/67/4 +esign eb olCris Bcre!ti

73/6842/67/6 ;ce 2010 / A&lica<ii olCris Bcre!ti

73/6842/67/7 e$nologia a&lica<iilor ;(o: 2000 Cl=

73/6842/67/7e$nologia a&lica<iilor ;Co&ania de libr*Bcre!ti

73/6842/67/6;ce 2010 / A&lica<ii Co&ania de libr*Bcre!ti

73/6842/67/7e$nologia a&lica<iilor ;Co&ania de libr*Bra!o"

73/6842/67/8Prograarea calclatoareolCris Bcre!ti

73/6842/67/7e$nologia a&lica<iilor ;olCris Bcre!ti

73/6842/67/3(isal Basic or A&&licatio)ibr*ria 9Central9 Sibi73/6842/67/3(isal Basic or A&&licatioCo&ania de libr*Bcre!ti

73/6842/67/8 Prograarea calclatoare(o: 2000 Bcre!ti

73/6842/67/4 +esign eb (o: 2000 Sibi

73/6842/67/7e$nologia a&lica<iilor ;Co&ania de libr*Bra!o"

73/6842/67/4 +esign eb )ibr*ria 9Central9 Sibi

73/6842/67/7e$nologia a&lica<iilor ;olCris Sibi

73/6842/67/8Prograarea calclatoareolCris Cl=

73/6842/67/5 Ba-e de +ate olCris Bcre!ti

73/6842/67/% SA+ olCris Bcre!ti

73/6842/67/3(isal Basic or A&&licatioCo&ania de libr*Bra!o"

73/6842/67/7e$nologia a&lica<iilor ;Co&ania de libr*Bcre!ti

73/6842/67/5Ba-e de +ate Co&ania de libr*Bcre!ti

73/6842/67/7e$nologia a&lica<iilor ;)ibr*ria 9Central9 Sibi

73/6842/67/% SA+ )ibr*ria 9Central9 Cl=

73/6842/67/5 Ba-e de +ate (o: 2000 Bra!o"

Compania dedistribuţie

Oraş dedistribuţie

Page 4: Aplicatia 6 - Functii de Consultare Si Functii Text (2)

7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)

http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 4/31

73/6842/67/6 ;ce 2010 / A&lica<ii (o: 2000 Bra!o"

73/6842/67/% SA+ (o: 2000 Bra!o"

73/6842/67/7e$nologia a&lica<iilor ;olCris Bcre!ti

73/6842/67/5Ba-e de +ate Co&ania de libr*Bra!o"73/6842/67/7e$nologia a&lica<iilor ;Co&ania de libr*Bcre!ti

73/6842/67/5 Ba-e de +ate (o: 2000 Sibi

73/6842/67/7e$nologia a&lica<iilor ;)ibr*ria 9Central9 Bra!o"

73/6842/67/5Ba-e de +ate )ibr*ria 9Central9 Bra!o"

73/6842/67/5 Ba-e de +ate olCris Sibi

73/6842/67/6 ;ce 2010 / A&lica<ii (o: 2000 Sibi

73/6842/67/6 ;ce 2010 / A&lica<ii (o: 2000 Bra!o"

73/6842/67/6 ;ce 2010 / A&lica<ii (o: 2000 Bra!o"

73/6842/67/5 Ba-e de +ate Co&ania de libr* Cl=

73/6842/67/7e$nologia a&lica<iilor ;olCris Bcre!ti

73/6842/67/7e$nologia a&lica<iilor ;olCris Bcre!ti

73/6842/67/5Ba-e de +ate )ibraria 9PlaCedo9Bra!o"

73/6842/67/4 +esign eb (o: 2000 Cl=

73/6842/67/4 +esign eb (o: 2000 Bra!o"

73/6842/67/8 Prograarea calclatoare(o: 2000 Bra!o"73/6842/67/5 Ba-e de +ate (o: 2000 Bcre!ti

73/6842/67/% SA+ )ibraria 9PlaCedo9 Cl=

73/6842/67/8Prograarea calclatoareCo&ania de libr*Bcre!ti

73/6842/67/5 Ba-e de +ate )ibr*ria 9Central9 Sibi

73/6842/67/7e$nologia a&lica<iilor ;)ibr*ria 9Central9 Cl=

73/6842/67/8Prograarea calclatoareolCris Bcre!ti

73/6842/67/5 Ba-e de +ate )ibr*ria 9Central9 Cl=

>n ca-l ?n care codl SB n se reg*se!te ?n tabell de conS* se rec&ere-e titlul cărţii  B3B5% ?n nc<ie de codl

Page 5: Aplicatia 6 - Functii de Consultare Si Functii Text (2)

7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)

http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 5/31

Cod ISBN

adlesc Sori 40 bc DDD DDD %73/6842/67/

adlesc Sori 80 bc DDD DDD %73/6842/67/

adlesc Sori 800 bc DDD DDD %73/6842/67/

Po&esc #i$ne 400 bc DDD DDD %73/6842/67/

onesc )ara %00 bc DDD DDD %73/6842/67/

#oisesc Adria 850 bc DDD DDD %73/6842/67/

Sa"a Sebastian1300 bc DDD DDD %73/6842/67/

Sa"a Sebastian1000 bc DDD DDD

Sa"a Sebastian 30 bc DDD %30 lei

#oisesc Adria 1400 bc DDD DDD

adlesc Sori 16 bc DDD 640 lei

adlesc Sori 600 bc DDD DDD

onesc )ara 650 bc DDD DDD

Po&esc #i$ne 1050 bc DDD DDD

Po&esc #i$ne 800 bc DDD DDD

#oisesc Adria 1300 bc DDD DDDAlb #aris 1000 bc DDD DDD

onesc )ara 750 bc DDD DDD

onesc )ara 60 bc DDD DDD

#oisesc Adria 125 bc DDD DDD

#oisesc Adria 600 bc DDD DDD

#oisesc Adria 100 bc DDD DDD

#oisesc Adria 250 bc DDD DDD

onesc )ara %0 bc DDD DDD

onesc )ara 100 bc DDD DDD

#oisesc Adria 100 bc DDD DDD

Po&esc #i$ne 360 bc DDD DDD

onesc )ara 2000 bc DDD DDD

Alb #aris 20 bc DDD 800 lei

Alb #aris 30 bc DDD 870 lei

#oisesc Adria 40 bc DDD DDD

Agentvn!are

edistribui

#reţcarte

$aloarevn!are

Page 6: Aplicatia 6 - Functii de Consultare Si Functii Text (2)

7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)

http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 6/31

#oisesc Adria 400 bc DDD DDD

#oisesc Adria 200 bc DDD DDD

#oisesc Adria 280 bc DDD DDD

#oisesc Adria 300 bc DDD DDDPo&esc #i$ne 1200 bc DDD DDD

adlesc Sori 450 bc DDD DDD

Alb #aris 50 bc DDD DDD

Alb #aris 60 bc DDD DDD

adlesc Sori 4%0 bc DDD DDD

adlesc Sori %00 bc DDD DDD

Sa"a Sebastian 350 bc DDD DDD

Sa"a Sebastian 250 bc DDD DDD

Alb #aris 360 bc DDD DDD

adlesc Sori 750 bc DDD DDD

adlesc Sori 45 bc DDD DDD

#oisesc Adria 75 bc DDD DDD

Alb #aris 20 bc DDD 680 lei

#oisesc Adria 10 bc DDD 340 lei

#oisesc Adria 40 bc DDD DDDPo&esc #i$ne 500 bc DDD DDD

Alb #aris 240 bc DDD DDD

onesc )ara 800 bc DDD DDD

onesc )ara 365 bc DDD DDD

Alb #aris 120 bc DDD DDD

Alb #aris 180 bc DDD DDD

#oisesc Adria 320 bc DDD DDD

sltare, se "a a@!a n esa= de eroare.  B &relat din tabell de consltare din cmpul

Page 7: Aplicatia 6 - Functii de Consultare Si Functii Text (2)

7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)

http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 7/31

Titlu carte

(isal Basic or A&&lication

+esign eb

Ba-e de +ate

;ce 2010 / A&lica<ii

 e$nologia a&lica<iilor ;ce

Prograarea calclatoarelor

SA+

Page 8: Aplicatia 6 - Functii de Consultare Si Functii Text (2)

7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)

http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 8/31

  %&'(.

Page 9: Aplicatia 6 - Functii de Consultare Si Functii Text (2)

7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)

http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 9/31

Curs Eur  )*)+, lei

Destinaţ Bucureşti

Prods1 1.2 t -.*,/) lei

Prods2 1.4 t -.*,/) lei

Prods3 2.% t -.*,/) lei

Bra!o" Bcre!ti Ploie!ti Predeal Sinaia  20.00 E 13.75 E 13.50 E 15.00 E 12.50 E

+enir

e &rods

Cantitate

li"rat*

C$eltieli

trans&ort lei

S* se calcle-e Cheltuielile de transp  

Page 10: Aplicatia 6 - Functii de Consultare Si Functii Text (2)

7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)

http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 10/31

rt  ?n nc<ie de ora!l de destina<ie !i de crsl .

Page 11: Aplicatia 6 - Functii de Consultare Si Functii Text (2)

7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)

http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 11/31

ata actur  000 1001Prods1 36.25 E

1002Prods2 1%.00 E

Curs Euro )*)./- lei 1003Prods3 37.50 E1004Prods4 75.00 E

1006Prods6 22.50 E

1002 1.7 t 000 1007Prods7 55.00 E

1018 1.2 t (1*+% lei 1008Prods8 15.00 E

1007 2.5 t 000 100%Prods% 41.00 E

1020 1.% t 000 1010 Prods10 33.75 E

1011 Prods11 12.50 E1012 Prods12 16.00 E1013 Prods13 2%.25 E1014 Prods14 30.00 E1015 Prods15 55.00 E1016 Prods16 1%.50 E1017 Prods17 32.50 E1018 Prods18 18.00 E101% Prods1% 20.25 E

1020 Prods20 17.33 E

Codprodus

2enumireprodus

#reţunitar

345

Codprodus

Cantitatelivrat"

$aloare6actur"

3lei5

Page 12: Aplicatia 6 - Functii de Consultare Si Functii Text (2)

7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)

http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 12/31

2ata debut promoţie

/ /

1.0 t 7G SatrdaH, o"eber 01, 2014

/ // /

1.3 t 15G $rsdaH, #aH 01, 2014

2.0 t 3G SatrdaH, IanarH 25, 2014

1.7 t 10G $rsdaH, #aH 01, 2014

/ /

/ /

/ /2.5 t 15G ednesdaH, ctober 15, 2014

/ // // // /

1.3 t 18G SatrdaH, #arc$ 15, 20142.0 t 10G $rsdaH, #arc$ 20, 20141.0 t 6G #ondaH, +eceber 01, 2014

/ /

Cantitate2iscount

2iscount375

Page 13: Aplicatia 6 - Functii de Consultare Si Functii Text (2)

7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)

http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 13/31

2ata s6rşit promoţie

SndaH, o"eber 30, 2014

ednesdaH, #aH 21, 2014

 $rsdaH, FebrarH 06, 2014

SndaH, Ine 01, 2014

DDD

#ondaH, #arc$ 31, 2014 $rsdaH, #arc$ 27, 2014

DDD

Page 14: Aplicatia 6 - Functii de Consultare Si Functii Text (2)

7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)

http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 14/31

2ata scadenţei

101 Client1 Constanta Str. A 456,865 DDD 20 -ile Fri, 24 ct 2014

101 Client1 Constanta Str. A 456,854 DDD / ed, 8 ct 2014

101 Client1 Constanta Str. A 456,86% DDD 20 -ile $, 20 o" 2014

101 Client1 Constanta Str. A 456,858 DDD 10 -ile Fri, 28 o" 2014

101 Client1 Constanta Str. A 456,85% DDD 20 -ile Fri, 1% +ec 2014

102 Client2 Bcresti Str. B 456,855 e, 2 +ec 2014 30 -ile e, 13 Ian 2015

102 Client2 Bcresti Str. B 456,861 DDD 15 -ile $, 8 Ian 2015

103 Client3 Braso" Str. C 456,860 DDD 15 -ile Fri, 3 A&r 2015

103 Client3 Braso" Str. C )1-891, DDD / T:u8 +- Apr %.+1

104 Client4 Cl= Str. + 456,852 Fri, 24 A&r 2015 / Fri, 24 A&r 2015

104 Client4 Cl= Str. + 456,862 DDD 8 -ile #on, 18 #aH 2015

104 Client4 Cl= Str. + 456,864 DDD 3 -ile ed, 24 In 2015105 Client5 Arad Str. 456,853 DDD 17 -ile $, 3 Se& 2015

105 Client5 Arad Str. 456,866 e, 6 Ian 2015 5 -ile e, 13 Ian 2015

105 Client5 Arad Str. 456,867 DDD 7 -ile e, 20 Ian 2015

106 Client6 iisoara Str. F 456,868 DDD / ed, 4 Feb 2015

106 Client6 iisoara Str. F 456,856 DDD % -ile ed, 18 #ar 2015

107 Client7 B-a Str. 456,870 DDD 14 -ile e, 21 A&r 2015

107 Client7 B-a Str. 456,871 DDD 6 -ile #on, 6 A&r 2015

107 Client7 B-a Str. 456,863 DDD 30 -ile Fri, 1 #aH 2015

DJA

Codclien

t

Numeclient

Localitate client

Adresaclient

Num"r6actur"

2ata6acturii

Nr* !ilegraţie

Care este luna ?n care a de"enit scadent* actra c nr.

Obs re-ltatl orlei "a @ oratat &ersonali-at, astel ?nc't, ?n celllna scaden<ei tili-'nd oratl abre"iat &entr acest eleent a

Page 15: Aplicatia 6 - Functii de Consultare Si Functii Text (2)

7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)

http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 15/31

#l"tit ;a<or"ri T$A

12,520 lei 2A 0 lei 2,37% lei 14,8%% lei

15,600 lei N= 63,648 lei 15,057 lei %4,305 lei

8,360 lei 2A 0 lei 1,588 lei %,%48 lei

13,000 lei N= 46,410 lei 11,288 lei 70,6%8 lei

38,060 lei N= 127,882 lei 31,52% lei 1%7,471 lei

46,766 lei N= 145,442 lei 36,520 lei 228,728 lei

3,%00 lei N= 12,324 lei 3,083 lei 1%,307 lei

14,005 lei 2A 0 lei 2,661 lei 16,666 lei

87,056 lei N= 18%,782 lei 52,5%% lei 32%,437 lei

1%,500 lei 2A 0 lei 3,705 lei 23,205 lei

12,505 lei 2A 0 lei 2,376 lei 14,881 lei

8,706 lei 2A 0 lei 1,654 lei 10,360 lei45,000 lei 2A 0 lei 8,550 lei 53,550 lei

2,284 lei 2A 0 lei 434 lei 2,718 lei

3,600 lei N= 10,%44 lei 2,763 lei 17,307 lei

18,732 lei N= 54,135 lei 13,845 lei 86,712 lei

12,200 lei N= 30,134 lei 8,043 lei 50,377 lei

14,780 lei 2A 0 lei 2,808 lei 17,588 lei

81,000 lei N= 184,680 lei 50,47% lei 316,15% lei

56,100 lei N= 113,883 lei 32,2%7 lei 202,280 lei

 Apr 

)1-891,

$aloare6actur"

$aloareatotal"

a destina<ie 25 se "a a@!aum r

6actur"  datei de exemplu an.

Page 16: Aplicatia 6 - Functii de Consultare Si Functii Text (2)

7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)

http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 16/31

2ata cotaţiei Curs >=?O

ednesdaH 01 ct 2014 4.4127

1  $rsdaH 02 ct 2014 4.4106

2 FridaH 03 ct 2014 4.4114

3 #ondaH 06 ct 2014 4.41364  esdaH 07 ct 2014 4.4067

5 ednesdaH 08 ct 2014 4.408%

6  $rsdaH 0% ct 2014 4.4061

7 FridaH 10 ct 2014 )*)./-

8 #ondaH 13 ct 2014 4.4030

9  esdaH 14 ct 2014 4.410%

10 ednesdaH 15 ct 2014 4.4137

11  $rsdaH 16 ct 2014 4.4300

12 FridaH 17 ct 2014 4.420%13 #ondaH 20 ct 2014 4.4176

14  esdaH 21 ct 2014 4.4170

15 ednesdaH 22 ct 2014 4.4166

16  $rsdaH 23 ct 2014 4.4236

17 FridaH 24 ct 2014 4.420%

18 #ondaH 27 ct 2014 4.4255

19  esdaH 28 ct 2014 4.4200

ednesdaH 2% ct 2014 4.4226

 $rsdaH 30 ct 2014 4.41%7

 deco

Page 17: Aplicatia 6 - Functii de Consultare Si Functii Text (2)

7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)

http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 17/31

Cod #rodus

12312341233212

23456573578%0321341234568%50

S* se calcle-e preţul mediu, &res&n'nd c* acesta este editat ?nce&'nd d

Page 18: Aplicatia 6 - Functii de Consultare Si Functii Text (2)

7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)

http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 18/31

  la "aloarea &o-i<ional* 3 &'n* la 5 ?n codl co&o-it din c'&l A/&A9.

Page 19: Aplicatia 6 - Functii de Consultare Si Functii Text (2)

7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)

http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 19/31

Nume #renume 2epartament 2ata naşterii

A)B ana 24%1107345633 Creditare ++@,@+(.,

A)B Constanta 2770%044448%0Creditare (@)@%..)

B)AA #*d*lina 2611123546%67Cor&ora<ii ++@%/@%.%/

C Bogdan 1560817341871 Creditare 9@+,@%.+,

C#A Ara 2800304227773 @cil =ridic /@)@%..)

CSA Ana 25012074725%0@cil =ridic +%@,@%..,

++ atalia 2610722114674 Creditare ,@%%@%.%%

AA Pa"el 170110155588% ela<ii clien<i ++@+@%..+

#ASC Andreea 2811010510053 Cor&ora<ii +.@+.@%.+.

#A Caren 2600227503812 Creditare %@%,@%.%,

#A +in 1550602422877 Asigrari -@%@%..%

#+A )ara 2600615100121Asigrari -@+1@%.+1

+)C #i$ai 1810130333655 Asigrari +@/.@+(/.

PAA Cornel 15%05016738%5 Cor&ora<ii 1@+@%..+

P Cristina 266080%31034%@cil =ridic 9@(@%..(

PPA Florin 1501001701%02 Cor&ora<ii +.@+@%..+

PPSC (iorel +an 1621212345345 Creditare +%@+%@%.+%

SA( C*t*lin 1700404222888 Creditare )@)@%..)

SSC )iana 2680312508405ela<ii clien<i /@+%@%.+%

(SA Ale:andra 2721225557812@cil =ridic +%@%1@%.%1

()A+ Petr 1600205667445 Cor&oratii %@1@%..1

Cod numericpersonal

S* se calcle-e Data naşterii &lec'nd de la codl neric &e

Page 20: Aplicatia 6 - Functii de Consultare Si Functii Text (2)

7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)

http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 20/31

A&r/2006 % ani 1,000 lei

Se&/1%80 35 ani 2,%00 lei

 In/1%%% 16 ani 1,180 lei

Feb/1%70 45 ani 2,%00 lei

 In/1%85 30 ani 2,7%0 lei

+ec/1%7% 36 ani 3,200 lei

ct/1%83 32 ani 2,%00 lei

Ag/2001 14 ani 1,180 lei

#aH/2004 11 ani 1,050 lei

A&r/2006 % ani 1,000 lei

#ar/1%78 37 ani 2,%00 lei

ct/1%84 31 ani 2,500 lei

+ec/2006 % ani 1,000 lei

Ag/1%81 34 ani 2,800 lei

 Il/1%7% 36 ani 3,200 lei

Feb/2006 10 ani 1,050 lei

o"/2002 13 ani 1,200 lei

A&r/2006 % ani 1,000 lei

A&r/1%80 35 ani 3,350 leiA&r/2006 % ani 1,050 lei

o"/1%75 40 ani 3,200 lei

2ataanga<"rii

$ec:ime3ani5

Salariu ncadrare

  sonal.

Page 21: Aplicatia 6 - Functii de Consultare Si Functii Text (2)

7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)

http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 21/31

Nume #renume Cod salariat

A)B Constan<a A)B 400P Cristina P S221

PPA Florin PPA 400++ atalia ++ S337C#A Ara C#A B222+)C #i$ai +)C B222#A +in #A 400

orat din 2 eleente nele salariatli !i indicatiS* se calcle-e codul salariatului !tiind c* acesta r

Exemplu ALB= T)..

Page 22: Aplicatia 6 - Functii de Consultare Si Functii Text (2)

7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)

http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 22/31

Nume #renume

PPSC (iorel +an S221#A Caren A117

PPA Florin 400A)B Constan<a 400+)C #i$ai B222C Bogdan A117A)B ana S337()A+ Petr 400

CSA Ana S221l locli de n #+A )ara A117

SA( C*t*lin S221PAA Cornel B222

C#A Ara B222B)AA #*d*lina A117#A +in 400++ atalia S337AA Pa"el S337SSC )iana 400P Cristina S221#ASC Andreea A117(LA Ale:andra A117

Indicativ locde munc"

  &re-int* n cod c

Page 23: Aplicatia 6 - Functii de Consultare Si Functii Text (2)

7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)

http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 23/31

ecodi@care

5478 2,523.70 0.13 315.4652016854%0 6,500.00 0.%4 6,116.505201605485 1%,46%.52 0.40 7,787.815201655481 21,547.80 0.17 3,620.03520161

din narl de in"entar "a @ inlocit c anl crent.

Optional- anul punerii in functiune

Recodificare

5478 2,523.70 0.13 315.46 519998

54%0 6,500.00 0.%4 6,116.50 520000

5485 1%,46%.52 0.40 7,787.81 520075

*r dein"entar

(aloare dein"entar

Coe@cientde

ree"alare

(aloareree"alat*

Se "a reali-a o recodifcare a i=loacelor @:e in ra careia c

Obs re-ltatl orlei de calcl re&re-inta o informatie de na

*r dein"entar

(aloare dein"entar

Coe@cientde

ree"alare

(aloareree"alat*

Page 24: Aplicatia 6 - Functii de Consultare Si Functii Text (2)

7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)

http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 24/31

5481 21,547.80 0.17 3,620.03 519991

Page 25: Aplicatia 6 - Functii de Consultare Si Functii Text (2)

7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)

http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 25/31

5478AAA 2J12J1%%% 2,523.70 lei

547%BBB 2J18J200% 12,547.83 lei

5480CCC %J3J2000 3,550.00 lei

5481+++ 1J25J1%%% 3,6%5.00 lei5482 6J6J2006 1,754.01 lei

5483FFF 11J8J2000 6,500.00 lei

5484 4J12J2000 2,765.82 lei

5485 6J14J2007 1%,46%.52 lei

5486 8J30J2001 4,785.00 lei

5487 III 2J4J2002 1,548.78 lei5488MMM 8J6J1%%8 21,547.80 lei

548%))) 3J17J2004 3,583.00 lei

54%0### 3J12J2000 6,500.00 lei

*rin"enta

r

+enirei=loc @:

+ata &nerii ?n nc<ine

(aloare dein"entar

  l de/al do

tura num

Page 26: Aplicatia 6 - Functii de Consultare Si Functii Text (2)

7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)

http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 26/31

Page 27: Aplicatia 6 - Functii de Consultare Si Functii Text (2)

7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)

http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 27/31

Nume #renume Sucursala

PPSC (iorel +an+octor Feli: Creditare .+#$-% #

#A Caren Ltean cel #ar Creditare .+;C-. F

PPA Florin Ltean cel #ar Cor&ora<ii .%#F1. #

A)B Constanta +octor Feli: Creditare .+AC,, F

+)C #i$ai Ltean cel #ar @cil =ridic ./N;9+ #

C Bogdan Ple"nei @cil =ridic ./CB1- #

A)B ana Ple"nei Creditare .+AO)( F

()A+ Petr Ltean cel #ar ela<ii clien<i .)$#-. #

CSA Ana +octor Feli: Cor&ora<ii .%CA1. F

#+A )ara Ltean cel #ar Creditare .+;L-. F

SA( C*t*lin Ltean cel #ar Asigrari .1SC,. #

PAA Cornel Ltean cel #ar Asigrari .1#C1( #

C#A Ara Ltean cel #ar Asigrari .1CA9. F

B)AA #*d*lina Ple"nei Cor&ora<ii .%B;-+ F

#A +in +octor Feli: @cil =ridic ./;211 #

++ atalia Ltean cel #ar Cor&ora<ii .%2N-+ F

AA Pa"el Ltean cel #ar Creditare .+#,. #SSC )iana Ple"nei Creditare .+SL-9 F

P Cristina +octor Feli: ela<ii clien<i .)#C-- F

#ASC Andreea Ltean cel #ar @cil =ridic ./;A9+ F

(SA Ale:andra Ple"nei Cor&ora<ii .%$A,% F

2epartament

Codulsalariatului

enu3;Dmasculi

nFD6eminin

Codul salariatului  re&re-int* n cod co&o-it care con<ine

:e&l salariatl (isan Ale:andra are codl .%$A,%

Page 28: Aplicatia 6 - Functii de Consultare Si Functii Text (2)

7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)

http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 28/31

Nume #renume

46 ani A&r/2006 2 ani 1,000 lei A)B ana DDD

4% ani Se&/1%80 28 ani 2,%00 lei A)B Constanta DDD

58 ani In/1%%% % ani 1,180 lei B)AA #*d*lina DDD

31 ani Feb/1%70 3% ani 2,%00 lei C Bogdan DDD

28 ani In/1%85 23 ani 2,7%0 lei C#A Ara DDD

52 ani +ec/1%7% 2% ani 3,200 lei CSA Ana DDD

5% ani ct/1%83 25 ani 2,%00 lei ++ atalia DDD

4% ani Ag/2001 7 ani 1,180 lei AA Pa"el DDD

58 ani #aH/2004 4 ani 1,050 lei #ASC Andreea DDD

48 ani A&r/2006 2 ani 1,000 lei #A Caren DDD

38 ani #ar/1%78 31 ani 2,%00 lei #A +in DDD

4% ani ct/1%84 24 ani 2,500 lei #+A )ara DDD

2% ani +ec/2006 2 ani 1,000 lei +)C #i$ai DDD

47 ani Ag/1%81 27 ani 2,800 lei PAA Cornel DDD

53 ani Il/1%7% 2% ani 3,200 lei P Cristina DDD

47 ani Feb/2006 3 ani 1,050 lei PPA Florin DDD

38 ani o"/2002 6 ani 1,200 lei PPSC (iorel +an DDD41 ani A&r/2006 2 ani 1,000 lei SA( C*t*lin DDD

42 ani A&r/1%80 28 ani 3,350 lei SSC )iana DDD

27 ani A&r/2006 2 ani 1,050 lei (SA Ale:andra DDD

36 ani o"/1%75 33 ani 3,200 lei ()A+ Petr DDD

$rsta

3ani5

2ataanga<"rii

$ec:imea 3ani5

Salariu ncadrar

e

Cod numericpersonal

cod de&artaent, &ria liter* a neli, &ria liter* a &re

Page 29: Aplicatia 6 - Functii de Consultare Si Functii Text (2)

7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)

http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 29/31

Creditare   01

Cor&ora<ii   02

@cil =ridic   03

ela<ii clien<i   04

Asigrari   05

2epartament

Coddepartament

eli !i anl na!terii ?n orat abre"iat.

Page 30: Aplicatia 6 - Functii de Consultare Si Functii Text (2)

7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)

http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 30/31

5 7 100001

3 5 1001

4 7 %001

ocompo!it npatru trepte

variabile

denti@carea"alorii &o-itionale

aerente primului SPATIU

 "alorii

&o-itionaleaerente celide/al doilea

"alorii&o-itionale

aerente celide/al treilea

:tragereaprimuluigrup decaractere

...+ A ;;

.+ A EEEE (

..+ AA E ((

Obs Alegerea sccesinii de a@!are a gr&rilor de caractere di

Page 31: Aplicatia 6 - Functii de Consultare Si Functii Text (2)

7/25/2019 Aplicatia 6 - Functii de Consultare Si Functii Text (2)

http://slidepdf.com/reader/full/aplicatia-6-functii-de-consultare-si-functii-text-2 31/31

 A

 A

 AA

:tragereaceli de/al

doilea grup de caractere

:tragereaceli de/al

treilea grup de caractere

:tragereaultimului grup decaractere

  n

alt" ordine3prin

codul compozit recompus r*'ne la latitdinea stdentli.