综å项ç®2ï¼å¦ç±ç®¡çç³»ç»ï¼
项ç®10ï¼vf å¦ç±ç®¡çç³»ç»çå¼åå®ä¾
ä¸ãéæ±åæ
éçå¦æ ¡è§æ¨¡ä¸ææ©å¤§ï¼å¦ççæ°éæ¥å§å¢å ï¼æå
³å¦ççåç§ä¿¡æ¯éä¹æåå¢å ãé¢å¯¹åºå¤§çä¿¡æ¯éï¼éè¦æå¦ç管çç³»ç»æ¥æé«å¦æ ¡ç®¡ç人åçå·¥ä½æçãéè¿è¿æ ·çç³»ç»ï¼å¯ä»¥åå°ä¿¡æ¯çè§è管çï¼ç§å¦ç»è®¡åå¿«éçæ¥è¯¢ï¼ä»èåå°ç®¡çæ¹é¢çå·¥ä½éï¼ç±äºå¤§å¦çç±»å«åä¸ä¸ç设置çå¤æ ·åï¼å¤§å¦ççå¦ç±ç®¡çåæ¥æ¯é常ç¹çåå¤æçå·¥ä½ï¼ä¸ä»
éè¦å¤é
置管ç人åï¼èä¸å¨æ°æ®å¤ççåç¡®æ§ãæ¶ææ§ãå®å
¨æ§çæ¹é¢ååå¨è®¸å¤é®é¢ï¼ä½¿å¾äººå·¥ç®¡çå ä¹æ æ³å®ç°ãè¿ç§æ
åµä¸ï¼ç¨è®¡ç®æºè¿è¡ç®¡çåå¾å°¤ä¸ºçå¿
è¦ï¼è¿å¯ä»¥åæ¥è®¡ç®æºçä¼å¿ï¼å©ç¨è®¡ç®æºæ¥è¿è¡å¦ç±ç®¡çï¼æ ç大大åè½»äºå·¥ä½äººåçå·¥ä½éååå°äººä¸ºçé误ã å æ¤æ们éç¨äºå¾®è½¯å
¬å¸çVisual FoxPro 6.0 ä½ä¸ºè½¯ä»¶å¹³å°ï¼å¹¶ç¨å®æ¥å®ç°å¦ç±ç®¡çç³»ç»ä¸çå项åè½ã
äºãæ°æ®æ¥æº
æ们以æå¦æ ¡ä¸ºä¾ã
å¦çæ
åµç»è®°è¡¨ï¼
å¦å·ãå§åãæ§å«ãåºçæ¥æãæ¯å¦å¢åãçµè¯ãæ»æ绩
0001ãè°å½¦ã女ã1983.5.21ãæ¯ã58253761 ã453
0002ãåºåã女ã1983.10.12ãæ¯ã58263537 ã425
0003ãå´ç«ã女ã1980.2.22ãæ¯ã58354321ã 490
0004ãå£å¹³ãç·ã1981.3.19ã.æ¯ã58134217 ã510
èå¸æ
åµç»è®°è¡¨
ç¼å·ãå§åãæ§å«ãå¦åãè称ãèç³»æ¹å¼ã
20040001ãå¼ åãç·ã大å¦ã58330330
20040002ãç¨åã女ã大å¦ã58266238
20040003ã马ä¸ãç·ã大å¦ã58288368
课ç¨æ
åµç»è®°è¡¨
课ç¨å·ã课ç¨åãå¦æãå¦åãæå¸æå¨ç³»
2004ã0010ã计ç®æºåºç¡ç¥è¯ä¸5
2004ã0012ãé«æ°äºã6
2004ã0052ãè±è¯ä¸ã5
2004ã1200ãæ°æ®åºåºç¨åã3
ä¸ãç³»ç»çå
·ä½åè½
ï¼1ï¼è®¾è®¡è¦æ±
ç³»ç»å¼åçæ»ä½ä»»å¡æ¯å®ç°å¦çä¿¡æ¯å
³ç³»çç³»ç»åãè§èååèªå¨åã设计è¦æ±åææ¾ç¤ºå¨ç³»ç»å¼åçæ»ä½ä»»å¡çåºç¡ä¸å®æçã
æ¬ä¾ä¸çå¦çå¦ç±ç®¡çç³»ç»ç设计è¦æ±ä¸»è¦æï¼
æå
³å¦ç±çä¿¡æ¯çè¾å
¥ï¼å
æ¬è¾å
¥å¦çåºæ¬ä¿¡æ¯ãæå¨ç级ãæå¦è¯¾ç¨åæ绩çã
å¦çä¿¡æ¯çæ¥è¯¢ï¼å
æ¬æ¥è¯¢å¦ççåºæ¬ä¿¡æ¯ãæå¨ç级ãå·²å¦è¯¾ç¨åæ绩çã
å¦çä¿¡æ¯çä¿®æ¹ã
å¦æ ¡åºæ¬è¯¾ç¨ä¿¡æ¯çè¾å
¥
åºæ¬è¯¾ç¨ä¿¡æ¯çä¿®æ¹ã
å¦ç课ç¨ç设置åä¿®æ¹ã
å¦çæ绩信æ¯çè¾å
¥ãä¿®æ¹ãæ¥è¯¢ã
å¦çæ绩信æ¯çç»è®¡ã
æ¬ä¾æ ¹æ®å¦çä¿¡æ¯è¡¨å课ç¨åºæ¬ä¿¡æ¯è¡¨ãæå¸ä¿¡æ¯è¡¨çè¾å
¥åæ®ä¸å½çº³åºå
æ¬2个表çæ°æ®åºï¼ç°å°è¿äºååºå¦ä¸ï¼
ï¼1ï¼å¦ç表ï¼xs ï¼å¦å·ï¼å§åï¼æ§å«ï¼åºçæ¥æï¼æ¯å¦å¢åï¼çµè¯ï¼éä¿¡å°åï¼é®ç¼ï¼æ»æ绩ï¼å¤æ³¨ï¼
ï¼2ï¼è¯¾ç¨è¡¨ï¼kc ï¼è¯¾ç¨å·ï¼è¯¾ç¨åï¼å¦æï¼å¦åï¼æå¸ï¼æå¨ç³»ï¼
ï¼3ï¼æå¸è¡¨ï¼js ï¼ç¼å·ï¼å§åï¼æ§å«ï¼å¦åï¼è称ï¼ææ课ç¨ï¼èç³»æ¹å¼ï¼å¤æ³¨ï¼
å
ãåºç¨ç¨åºç设计
该系ç»çæç»ç¨æ·åºè¯¥æ¯å¦æ ¡çå¦ç±ç®¡çå·¥ä½äººåï¼è¿æ¯ä¸ç¾¤å
·æç¸å½è®¡ç®æºåºç¨ç¥è¯çç¨æ·ï¼ä»ä»¬åºè¯¥å¯ä»¥å¾çç»ç使ç¨æ¬ç³»ç»ï¼èä¸è¯¥ç³»ç»ç使ç¨çä¹ä¼æé«ï¼å®å°å®æå¦çä¿¡æ¯çå½å
¥ãåå¨ãä¿®æ¹çç¸å
³æ¥è¯¢ãæ±æ»å·¥ä½ãä»èå°å¤§å¤§æé«å¦çå·¥ä½ä¿¡æ¯ç®¡ççæçã
å¦çå¦ç±ç®¡çç³»ç»çå
·ä½è®¾è®¡å¦ä¸ï¼
1ãå¦çå¦ç±ç®¡çç³»ç»ä¸»ç¨åº(A:\main.prg)
åè½ï¼æä¾ç¨åºç主çé¢åè¿å
¥ç³»ç»ååè½æ¨¡åçæ¥å£ï¼å
æ¬ä¸ä¸ªèªå³åå·¦æ»å¨çé£åç¨åºã
æºç¨åºï¼
set talk off &&å
³é人æºå¯¹è¯
set escape off &&设置ESCè±ç¦»é®ä¸èµ·ä½ç¨ï¼å³è¯¯æ该é®ä¸ä¼ç»æ¢ç¨åºçæ§è¡
clear all &&æ¸
å±
set colo to 0/7,7/0 &&设置VFPç³»ç»çé»è®¤é¢è²
clear &&æ¸
å±
@4,42 clear to 30,92
set colo to 7+/0+ &&ä»ç¬¬4è¡ç¬¬42åå°ç¬¬30è¡ç¬¬92å产çç½åé»åºçè²å
@4,42 clear to 30,92 &&æ¾ç¤ºè²å
@3,40 clear to 29,90
set colo to 7+/4 &&ä»ç¬¬3è¡ç¬¬40åå°ç¬¬29è¡ç¬¬90å产çç½åé»åºçè²å
@3,40 clear to 29,90 &&æ¾ç¤ºè²å
@4,42,28,88 box space(9) &&ä»å·¦ä¸è§ç¬¬4è¡ç¬¬42åå°å³ä¸è§ç¬¬28è¡88å产ç线æ¡
@7,52 say'==å¦çå¦ç±ç®¡çç³»ç»==' &&å¨ç¬¬7è¡ç¬¬52åæ¾ç¤ºå¦çå¦ç±ç®¡çç³»ç»çåæ ·
@8,50 say'-------------------------------' &&å¨ç¬¬8è¡ç¬¬50åæ¾ç¤ºåé线æ¡
@9,57 say'==1.å½å
¥æ°æ®==' &&å¨ç¬¬9è¡ç¬¬57åæ¾ç¤º1.å½å
¥æ°æ®åæ ·
@11,57 say'==2.ä¿®æ¹æ°æ®==' &&å¨ç¬¬11è¡ç¬¬57åæ¾ç¤º2.ä¿®æ¹æ°æ®åæ ·
@13,57 say'==3.æ¥è¯¢æ°æ®==' &&å¨ç¬¬13è¡ç¬¬57åæ¾ç¤º3.æ¥è¯¢æ°æ®åæ ·
@15,57 say'==4.ç»è®¡æ°æ®==' &&å¨ç¬¬15è¡ç¬¬57åæ¾ç¤º4.ç»è®¡æ°æ®åæ ·
@17,57 say'==5.æ¾ç¤ºæ°æ®==' &&å¨ç¬¬17è¡ç¬¬57åæ¾ç¤º5.æå°æ°æ®åæ ·
@19,57 say'==6.å é¤æ°æ®==' & &å¨ç¬¬19è¡ç¬¬57åæ¾ç¤º6.éåºæ°æ®åæ ·
@21,57 say'==7.é åº==' &&å¨ç¬¬21è¡ç¬¬57åæ¾ç¤º7.éåºåæ ·
x=1 &&设åå¼x=1
b1="â欢è¿æ¨ä½¿ç¨å¦çå¦ç±ç®¡çç³»ç» &&å°å符串èµç»åéb1
do while.t. &&å½æ¡ä»¶æç«æ¶è®¡ç®æºåä¸é¢çè¯å¥
hz1=substr(b1,x,29) &&åå符串b1ä»ç¬¬1个å符å°ç¬¬29个å符èµç»å
éhz1
@25,51 say hz1 &&å¨ç¬¬25è¡ç¬¬51åæ¾ç¤ºå符串hz1
bb=inkey(0.6) &&å°çå¾
0.6ç§å»é®çinkey å½æ°èµç»bb
if bb<>0 &&åébbä¸çäº0ï¼å³æå»é®å¨ä½åç
exit &&é£ä¹ï¼ä¸æ¾ç¤ºå符串
endi &&ä¸ifæ¡ä»¶å¤æè¯å¥ç¸é
对
x=x+2 &&å°åéxçå¼å 2èµç»x
if x>83 &&å¦æåéx大äº83个å符
x=1 &&é£ä¹ï¼å°1èµç»åéxï¼å³ä»å¤´å¼å§æ¾ç¤ºå符串
endi &&ä¸ifæ¡ä»¶å¤æè¯å¥ç¸é
对
endd &&ä¸do while循ç¯è¯å¥ç¸é
对
@27,51 say'请éæ©1--7ï¼' &&å¨ç¬¬27è¡51åæ¾ç¤ºè¯·éæ©1-7ï¼çåæ ·
wait ' ' to k &&计ç®æºçå¾
ç¨æ·ä»é®çè¾å
¥ä¸ä¸ªå符ç»åék
do case &&åéæ©è¯å¥
case k='1' &&å½åékçå¼çäº1æ¶
do a:\input &&计ç®æºè·³è½¬å°a:\inputåç¨åº
case k='2' &&å½åékçå¼çäº2æ¶
do a:\modify &&计ç®æºè·³è½¬å°a:\modifyåç¨åº
case k='3' &&å½åékçå¼çäº3æ¶
do a:\search &&计ç®æºè·³è½¬å°a:\searchåç¨åº
case k='4' &&å½åékçå¼çäº4æ¶
do a:\total &&计ç®æºè·³è½¬å°a:\totalåç¨åº
case k='5' &&å½åékçå¼çäº5æ¶
do a:\dp &&计ç®æºè·³è½¬å°a:\dpåç¨åº
case k='6' &&å½åékçå¼çäº6æ¶
do a:\del &&计ç®æºè·³è½¬å°a:\delåç¨åº
case k='7' &&å½åékçå¼çäº7æ¶
set colo to 0/7,7/0 &&设置VFPç³»ç»çé»è®¤é¢è²
clear &&æ¸
å±
retu &&è¿åVFP主ç¨åº
endcase &&ä¸do caseéæ©è¯å¥ç¸é
对
set decimals to 2
set fdow to1
set fweek to 1
set mark to â.â
Set separator to â.â
Set point to â.â
2ãå½å
¥æ¨¡ååç¨åº(A:\input.prg)
åè½ï¼æä¾å¡çå¼çå½å
¥æ°æ®çé¢ã
æºç¨åºï¼set talk off
use a:\xj &&æå¼a:\xj.dbfæ°æ®åºæ件
go bott &&å°è®°å½æé移å°æ°æ®åºçæ«å°¾
skip &&è·³å°ä¸ä¸æ¡è®°å½
hk=recn() &&å°å½åè®°å½å·èµç»åéhk
hk1=str(hk,3) &&å°åéhkå¼çåä¸ä½ï¼ç±æ°å¼è½¬æ¢ä¸ºå符串èµç»c1=.t. &&å°é»è¾ååéâçâèµç»åéc1
do while c1 &&å½æ¡ä»¶æç«æ¶è®¡ç®æºåä¸é¢çè¯å¥
a1=spac(2) &&å°2ä¸ªç©ºæ ¼èµç»åéa1
a2=spac(6) &&å°6ä¸ªç©ºæ ¼èµç»åéa2
a3=spac(2) &&å°2ä¸ªç©ºæ ¼èµç»åéa3
a4=spac(8) &&å°8ä¸ªç©ºæ ¼èµç»åéa4
a5=spac(2) &&å°2ä¸ªç©ºæ ¼èµç»a5
a6=spac(8) &&å°8ä¸ªç©ºæ ¼èµç»a6
a7=spac(30) &&å°30ä¸ªç©ºæ ¼èµç»a7
a8=spac(6) &&å°6ä¸ªç©ºæ ¼èµç»a8
a9=spac(6) &&å°6ä¸ªç©ºæ ¼èµç»a9
a10=spac(50) &&å°50ä¸ªç©ºæ ¼èµç»a10
kk=.t. &&å°é»è¾ååéâçâèµç»åékk
do while kk &&å½æ¡ä»¶æç«æ¶è®¡ç®æºåä¸é¢çè¯å¥
clea &&æ¸
å±
@1,5 say"è¾å
¥ç¬¬"+hk1+"å¼ å¡ç" &&å¨ç¬¬1è¡ç¬¬5åæ¾ç¤ºè¾å
¥ç¬¬"+hk1+"å¼ å¡ççåæ ·ï¼å
¶ä¸ï¼hk1为å®æ¿æ¢
hk=hk+1 &&åéhkçå¼å¢1
hk1=str(hk,3) &&å°åéhkçå¼å3ä½èµç»hk1
@row()+1,5 say"å¦å·ï¼"get a1 &&å¨å½åè¡çä¸ä¸è¡ç¬¬5åæ¾ç¤ºå¦å·åæ ·
@row(),40 say"å§åï¼"get a2 &&å¨å½åè¡ç¬¬40åæ¾ç¤ºå§ååæ ·
@row()+1,5 say"æ§å«ï¼"get a3 &&å¨å½åè¡çä¸ä¸è¡ç¬¬5åæ¾ç¤ºæ§å«åæ ·
@row()+1,5 say"åºçå¹´æï¼MM/DD/YYï¼ï¼"get a4 &&å¨å½åè¡çä¸ä¸è¡ç¬¬5åæ¾ç¤ºåºçå¹´æåæ ·
@row()+1,40 say"æ¯å¦å¢åï¼"get a5 &&å¨å½åè¡çä¸ä¸è¡ç¬¬5åæ¾ç¤ºæ¯å¦å¢ååæ ·
@row()+1,5 say"çµè¯ï¼"get a6 &&å¨å½åè¡çä¸ä¸è¡ç¬¬5åæ¾ç¤ºçµè¯åæ ·
@row()+1,40 say"éä¿¡å°åï¼"get a7 &&å¨å½åè¡çä¸ä¸è¡ç¬¬5åæ¾ç¤ºéä¿¡å°ååæ ·
@row()+1,5 say"é®ç¼ ï¼"get a8 &&å¨å½åè¡çä¸ä¸è¡ç¬¬5åæ¾ç¤ºé®ç¼åæ ·
@row()+1,5 say"æ»æ绩ï¼"get a9 &&å¨å½åè¡ç¬¬40åæ¾ç¤ºæ¯å¦æ»æ绩åæ ·
@row()+1,5 say"å¤æ³¨ï¼"get a10 &&å¨å½åè¡çä¸ä¸è¡ç¬¬5åæ¾ç¤ºå¤æ³¨åæ ·
read &&å°é®çæè¾å
容读å
¥å
å
y="y" &&å°å符yèµç»åéy
@12,5 say"è¾å
¥æ£ç¡®åï¼ï¼Y/Nï¼"get y &&å¨ç¬¬12è¡ç¬¬5åæ¾ç¤ºè¾å
¥æ£ç¡®ååæ ·
read &&并å°è¾å
¥çyæn读å
¥å
å
if y="Y".or.y="y" &&å¦æåéyå¼ä¸ºå¤§åçYæå°åçy
kk=.f. &&é£ä¹ï¼å°é»è¾å¦èµç»åékk
endif &&ä¸if ç¸é
对
enddo &&ä¸do whileç¸é
对
appe blan &&æ·»å æ°è®°å½å°ç©ºç½è®°å½
replace å¦å· with a1,å§å with a2,æ§å« with a3,åºçå¹´æ with ctod(a4),æ¯å¦å¢å with a5
replace çµè¯ with val(a6),éä¿¡å°å with val(a7),é®ç¼ with val(a8),æ»æ绩 with a9,å¤æ³¨with a10 &&æ¿æ¢é®çè¾å
¥çå
容å°ç¸åºçå段ä¸
y=" " &&å°ä¸ç©ºæ ¼èµç»åéy
clea
@14,5 say"继ç»è¾å
¥åï¼ï¼y/nï¼"get y &&å¨ç¬¬14è¡ç¬¬5åæ¾ç¤ºç»§ç»è¾å
¥ååæ ·
read &&并å°è¾å
¥çyæn读å
¥å
å
if y="N".or.y="n" &&å¦æåéyå¼ä¸ºå¤§åçNæå°åçn
kk=.f. &&é£ä¹ï¼å°é»è¾å¦èµç»åékk
exit &&éåºè¾å
¥çé¢
endif &&ä¸ifç¸é
对
enddo &&ä¸do whileç¸é
对
clear &&æ¸
å±
do a:\main &&è¿è¡A:\main.prg主ç¨åº
ï¼2ï¼ãä¿®æ¹æ¨¡ååç¨åº(A:\modify.prg)
åè½ï¼æä¾å¡çå¼çä¿®æ¹æ°æ®çåè½ã
æºç¨åºï¼set talk off
set delimiter off
use a:\xj &&æå¼æ°æ®åºæ件A:\xj.dbf
kk=.t.
do while kk
clear
go top
yy=space(2)
@4,20 say"请è¾å
¥å¦å·" get yy
read
loca all for å¦å·=yy
if eof()
@5,5 say" "
wait"该记å½ä¸åå¨ï¼è¯·æä»»æé®è¿åï¼"
y="y"
clea
@6,5 say"继ç»ä¿®æ¹åï¼ï¼Y/Nï¼" get y
read
if y="Y".or.y="y"
loop
endi
clea
do a:\main
retu
endi
clea
kk=.t.
do while kk
clear
@row()+1,1 say"å¦å·ï¼" get å¦å·
@row(),40 say"å§åï¼" get å§å
@row()+1,1 say"æ§å«ï¼" get æ§å«
@row()+1,1 say "åºçå¹´æï¼" get åºçå¹´æ
@row(),60 say"æ¯å¦å¢åï¼" get æ¯å¦å¢å
@row()+1,1 say"çµè¯ï¼" get çµè¯
@row()+1,25 say"éä¿¡å°åï¼" get éä¿¡å°å
@row(),25 say""é®ç¼ï¼" get é®ç¼
@row()+1,1 say"æ»æ绩ï¼" get æ»æ绩
@row(),60 say"å¤æ³¨ï¼åå»ææ¬æ¡è¾å
¥å
容ï¼ï¼" get å¤æ³¨
read
y=" "
@9,15 say"ä¿®æ¹æ£ç¡®åï¼ï¼Y/Nï¼" get y
read
if y="y".or.y="Y"
kk=.f.
else
loop
endi
enddo
clear
y=""
@5,15 say"继ç»ä¿®æ¹åï¼ï¼Y/Nï¼" get y
read
if y="n".or.y="N"
kk=.f.
endif
enddo
clea
do a:\main
ï¼3ï¼ãæ¥è¯¢æ¨¡ååç¨åº(A:\search.prg)
åè½ï¼æä¾æå¦å·æ£ç´¢ãæå§åæ£ç´¢ãæå¦å·åå§åæ£ç´¢åæå¦å·ãå§åãæ§å«æ£ç´¢ä¸ä¸ªå模åçæ¥è¯¢æ°æ®åè½ã
表åä¸çæé®åè½å
æ¬ï¼è¾å
¥æ¥è¯¢æ¡ä»¶ãæ¥è¯¢ãæ¾ç¤ºæ¥è¯¢æ¡ä»¶ãæ¸
é¤æ¥è¯¢æ¡ä»¶ãæå°é¢è§ãæå°åæ¾å¼ãèµ·åï¼é¤è¾å
¥æ¥è¯¢æ¡ä»¶ãæ¾ç¤ºæ¥è¯¢æ¡ä»¶åæ¾å¼å¤æé®åæ¯ä¸è½éæ©çãå½åå»âè¾å
¥æ¥è¯¢æ¡ä»¶âæé®æ¶ï¼è¡¨åå
ä¸çå段å为空ï¼ç¨æ·å¯ä»¥è¾å
¥ä»»æç¥éçæ¡ä»¶å为æ¥è¯¢æ¡ä»¶ï¼è¿äºæ¡ä»¶åæ¯âä¸âçå
³ç³»ãè¿æ¶ï¼æé®ä¹å¯ä»¥è¢«éæ©äºï¼è¥åå»æ¥è¯¢ï¼æ¥è¯¢ç»æå°±æ¾ç¤ºå¨è¡¨åçéæ¡æµè§é¡µä¸ï¼åæ¶ï¼å¨è¯¥é¡µä¸è¿æ¾ç¤ºäºå
±æ¥è¯¢å°å æ¡è®°å½åå¯ç¨ç§»å¨è®°å½æé®éæ¡æ¥çè®°å½ã
æ¾ç¤ºæ¥è¯¢æ¡ä»¶æé®å¯ä»¥æ¥çæ¬æ¬¡æ¥è¯¢è¾å
¥çæ¡ä»¶ï¼æ¸
é¤æ¥è¯¢æ¡ä»¶æé®å¯ä»¥æ¸
é¤æ¬æ¬¡æ¥è¯¢çæ¡ä»¶ä»¥å¤ä¸ä¸æ¬¡æ¥è¯¢ï¼æå°æé®å°æ¬æ¬¡æ¥è¯¢ç»æè¾åºå°æå°æºï¼æ¾å¼æé®åæ¾å¼æ¬æ¬¡æ¥è¯¢å¹¶éæ¾æ¬è¡¨åå
ã
为äºæ¹ä¾¿æ¥çï¼è¿å¯ä»¥å¨è¡¨åçæµè§ä½¤é¡µä¸ä¸æ¬¡æ¥çå°å
¨é¨æ¥è¯¢å°çè®°å½ï¼å¹¶è½å¨æµè§å段设å®é¡µä¸è®¾å®ä½¤æµè§æ¶è¯¥å段çæ¾ç¤ºä¸å¦ã
æºç¨åºï¼set talk off
set delimiter off
set safety off &&é建索å¼æ¶ä¸æ示è¦ç
use a:\xj
inde on å¦å· to a:\xh &&æå¦å·å»ºç«ç´¢å¼æ件xh.idx
inde on å¦å·+å§å to a:\xhxm &&æå¦å·åå§å建ç«ç´¢å¼æ件xhxm.idx
inde on å§å to a:\xm &&æå§å建ç«ç´¢å¼æ件xm.idx
stor.t.to c
do while c
clear
text
æ£ç´¢åè½è¡¨
0---éåºæ£ç´¢ç³»ç»
1---æå¦å·æ£ç´¢
2---æå§åæ£ç´¢
3---æå¦å·åå§åæ£ç´¢
4---æå¦å·ãå§åãæ§å«æ£ç´¢
endt
dd=1
@row()+1,17 say"请è¾å
¥åè½å·" get dd pict "9" rang 0,4
read
do case
case dd=0
clear
do a:\main
retu
case dd=1
clear
n1=spac(2)
@4,20 say"请è¾å
¥å¦å·" get n1
read
use a:\xj inde a:\xh &&æå¼æ°æ®åºæ件xj.dbf并æå¼æå¦å·å»ºç«çç´¢å¼æ件xh.idx
find &n1 &&æ¥æ¾å符串n1ï¼&为å®æ¿æ¢
case dd=2
Clear
n2=spac(6)
@4,10 say"请è¾å
¥å§å" get n2
read
use a:\xj inde a:\xm
find &n2
case dd=3
clear
n1=spac(2)
n2=spac(6)
@4,10 say"请è¾å
¥å¦å·" get n1
@5,10 say"请è¾å
¥å§å" get n2
read
use a:\xj inde a:\xhxm
n4=n1+n2
find &n4
case dd=4
clear
n1=spac(2)
n2=spac(6)
n3=spac(2)
@3,10 say"请è¾å
¥å¦å·ï¼" get n1
@4,10 say"å§åï¼" get n2
@5,10 say"æ§å«ï¼" get n3
read
loca for å¦å·=n1.and.å§å=n2.and.æ§å«=n3 &&æ¥æ¾æ¡ä»¶æ¯å¦å·ä¸ºn1并ä¸å§å为n2并ä¸æ§å«ä¸ºn3çè®°å½
other
retu
Endc
if eof() &&å¦æå·²å°æ件尾
clear
wait'对ä¸èµ·ï¼æ²¡æ¾å°ã请æä»»æé®è¿åï¼'
loop
endif
cc=.t.
y=" "
do while cc
set devi to scre &&设置å±å¹æ¾ç¤ºå符
clea
@row(),5 say"å¦å·ï¼"+å¦å·
@row(),40 say"å§åï¼"+å§å
@row()+1,5 say"æ§å«ï¼"+æ§å«
@row()+1,5 say"åºçå¹´æï¼"+dtoc(åºçå¹´æ)
@row()+1,40 say"æ¯å¦å¢åï¼"+æ¯å¦å¢å
@row()+1,5 say"çµè¯ï¼"+çµè¯
@row(),40 say"éä¿¡å°åï¼"+éä¿¡å°å
@row()+1,5 say"é®ç¼ï¼"+é®ç¼
@row()+1,5 say"æ»æ绩ï¼"+æ»æ绩
@row()+1,5 say"å¤æ³¨ï¼"+å¤æ³¨
@20,20 say"ä¸ç»§ç»æ¥æ¾æNï¼å¦åæä»»ä¸é®" get y
read
if y="N".or.y="n"
clear
stor.f.to cc
loop
else
Endif
if.not.eof()
loop
Endif
stor.f.to cc
Enddo
stor.f.to c
Enddo
use
do a:\main
ï¼4ï¼ãç»è®¡æ¨¡ååç¨åº(A:\total.prg)
åè½ï¼æä¾ç»è®¡äººæ°ãå¹³åæ绩åå
å人æ°çåè½ã
æºç¨åºï¼set talk off
use a:
dd=0
stor.t.to c
do while c
clear
text
ç»è®¡åè½è¡¨
0---éåºç»è®¡ç³»ç»
1---ç»è®¡äººæ°
2---ç»è®¡å¹³åæ绩
3---ç»è®¡å
å人æ°
endt
dd=1
@row()+1,17 say"请è¾å
¥åè½å·" get dd pict "9" rang 0,3
read
do case
case dd=0
clear
do a:
case dd=1
clear
coun to aa &&计ç®è®°å½æ°å¹¶æå¼èµç»aa
@4,20 say"æ»äººæ°ï¼"
??aa &&æ¾ç¤ºåéaaçå¼
a=' '
@7,20 say"æä»»æé®è¿åï¼"
read
if a=''
loop
endi
case dd=2
clear
aver æ»æ绩 to aa &&对æ»æ绩æ±å¹³å并æå¹³åå¼åå«èµç»åéaa
@4,20 say"æ±æ»æ绩平åæ绩为ï¼"
??aa
a=' '
@9,20 say"æä»»æé®è¿åï¼"
read
if a=''
loop
endi
case dd=3
clear
coun for æ¯å¦å¢å="æ¯" to aa &&ç»è®¡å
åæ°ï¼å¹¶æå¼èµç»aa
@4,20 say"å¢å人æ°ä¸ºï¼"
??aa
a=' '
@9,20 say"æä»»æé®è¿åï¼"
read
if a=''
loop
endi
endc
return
endd
5ãæ¾ç¤ºæ¨¡ååç¨åº(A:\dp.prg)
åè½ï¼æä¾å¡çå¼çæ¾ç¤ºè®°å½çåè½ã
æºç¨åºï¼set talk off
set devi to scre
use a:\xj
kk=.t.
do while kk
clea
hk=recn()
hk1=str(hk,3)
@row(),5 say"æ¨ç°å¨æµè§çæ¯ç¬¬"+hk1+"å¼ å¡ç"
@row()+1,5 say"å¦å·ï¼"+å¦å·
@row()+1,5 say"å§åï¼"+å§å
@row()+1,5 say"æ§å«ï¼"+æ§å«
@row()+1,5 say"åºçå¹´æï¼"+dtoc(åºçå¹´æ)
@row(),40 say"æ¯å¦å¢åï¼"+æ¯å¦å¢å
@row()+1,5 say"çµè¯ï¼"+çµè¯
@row()+1,40 say"éä¿¡å°åï¼"+éä¿¡å°å
@row()+1,5 say"é®ç¼ï¼"+é®ç¼
@row()+1,5 say"æ»æ绩ï¼"+æ»æ绩
@row()+1,5 say"å¤æ³¨ï¼"+å¤æ³¨
wait '请æné®æµè§ä¸ä¸æ¡è®°å½ï¼ælé®æµè§ä¸ä¸æ¡è®°å½ï¼æyé®è¿å主ç¨åºï¼' to k
do case
case k='n'
if eof() &&å¦æå·²å°æ件尾
go top &&å°æ件记å½æé移å°æ件记å½çé¦è®°å½
else
skip &&å¦åï¼è·³å°ä¸ä¸æ¡è®°å½
endi
hk=hk+1
case k='l'
if bof() &&å¦æå·²å°æ件å¼å¤´
go bott &&å°æ件记å½æé移å°æ件记å½çæåä¸æ¡è®°å½
else
skip -1 &&å¦åï¼è·³å°ä¸ä¸æ¡è®°å½
endi
hk=hk-1
case k='y'
clear
do a:\main
kk=.f.
endc
endd
6ãå é¤æ¨¡ååç¨åº(A:\del.prg)
åè½ï¼æä¾é»è¾ä¸ç©çå é¤çåè½ã
æºç¨åºï¼set talk off
set devi to scre
use a:\xj
yy=" "
yn=" "
de=spac(2)
clear
@4,20 say"请è¾å
¥è¦å é¤è®°å½çå¦å·" get de
read
loca all for å¦å·=de
if eof()
wait"æ¥æ æ¤å¡çï¼å»å车é®éåºï¼"
clear
do a:\xj
retu
endi
if.not.eof()
clea
hk=recn()
hk1=str(hk,3)
@row(),5 say"æ¨ç°å¨æµè§çæ¯ç¬¬"+hk1+"å¼ å¡ç"
@row()+1,5 say"å¦å·ï¼"+å¦å·
@row()+1,5 say"å§åï¼"+å§å
@row()+1,5 say"æ§å«ï¼"+æ§å«
@row()+1,5 say"åºçå¹´æï¼"+dtoc(åºçå¹´æ)
@row(),40 say"æ¯å¦å¢åï¼"+æ¯å¦å¢å
@row()+1,5 say"çµè¯ï¼"+çµè¯
@row(),40 say"éä¿¡å°åï¼"+éä¿¡å°å
@row()+1,5 say"é®ç¼ï¼"+é®ç¼
@row()+1,5 say"æ»æ绩ï¼"+æ»æ绩
@row()+1,5 say"å¤æ³¨ï¼"+å¤æ³¨
endif
@13,20 say"æ¯è¿ä¸ªè®°å½åï¼ï¼Y/Nï¼" get yn
read
if yn="n".or.yn="N"
clea
do a:\xj
retu
endi
if yn="y"
@14,20 say"çè¦å é¤åï¼ï¼Y/Nï¼" get yy
read
if yy="y".or.yy="Y"
delete &&å é¤å½åè®°å½ï¼é»è¾å é¤ï¼ä½ä¸æ¯çæ£å°å½åæ件记å½ä»VFPä¸å é¤ï¼
endif
endi
clear
stor " " to y
@15,15 say"å é¤çè®°å½ä»çä¸å½»åºæ¸
é¤åï¼ï¼Y/Nï¼" get y
read
if y="y".or.y="Y"
pack &&çæ£å é¤å½åè®°å½ï¼ç©çå é¤ï¼
endif
clea
do a:\xj
温馨提示:答案为网友推荐,仅供参考