|
VFP ·R¥ÎªÌªÀ°Ï ¥»°Q½×°Ï¬° Visual Foxpro ·R¥ÎªÌ¸gÅç¥æ¬yªº¦a¤è, ½Ð¦h¦h§Q¥Î"·j´M"ªº¥\¯à, ¥ý¬d¬Ý¬Ý¦³µL«e¨Ò¥i´`, ¦pªGÁÙ¦³¤£À´ªº¦Aµo°Ý. ³¡¥÷¥DÃD¦³ªþ¥[ÀÉ®×, ¶·¥ýµù¥U¦¨¬°ªÀ°Ï©~¥Á¤~¥i¥H¤U¸ü.
|
¤W¤@½g¥DÃD :: ¤U¤@½g¥DÃD |
µoªí¤H |
¤º®e |
zzbdyx
µù¥U®É¶¡: 2004-02-04 ¤å³¹: 37
²Ä 1 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤T¤ë 03, 2009 8:45 am ¤å³¹¥DÃD: BOM®i¶}¥N½X¨D§U |
|
|
¦³¤@BOMªí¡Aªíµ²ºc¦p¤U¡G
par_lpbh ¤÷¥ó®Æ¸¹
com_lpbh ¤l¥ó®Æ¸¹
qty ³æ¦ì¥Î¶q
hsbl ·l¯Ó¤ñ²v
¦³¤@®w¦sªí
lpbh ®Æ¸¹
kcsl ®w¦s¼Æ¶q
¦³¤@²£«~A¡A²£«~BOMµ²ºc¦p¹Ï¡A¦bBOMªí¤¤°O¿ý¦p¤U
A B 2 1%
A C 1 2%
B D 1 2%
B E 1 1%
D I 2 2%
D J 1 1%
C F 1 1%
C G 1 2%
C H 2 1%
²{¦bn¥Í²£A ¤@©w¼Æ¶q¡A¦P®Én¦Ò¼{¥b¦¨«~®w¦s¼Æ¶q¡A¤À§O±o¥XªöÁÊ«Øijªí©M¥Í²£«Øij¨âÓªí _scb ;_cgb ¤Z¬O¬°§À¶¥ªº³£¬Oì§÷®Æ¡A¦³¤U¼hª«®Æªº¬O¥b¦¨«~¡A¦p¤Wªí¡A¥b¦¨«~´N¬OB;C;D ì§÷®Æ´N¬OE;F;G;H;I;J
¤ñ¤è¥Í²£100ÓA¡A«öBOMªí·|»Ýn¥Í²£200ÓB¡A°²³]®w¦s¦³200ÓB«h¤£»Ýn®i¶}BªºBOMµ²ºc¡A¦pªG®w¦s¦³100ÓB¡A«h¥u»Ýn¥Í²£100ÓB¡A¨º¤\¦b®i¶}Bªº®ÉÔ«ö100¼Æ¶qÄ~Äò®i¶}ºâ¤U¯Åª«®Æ¡A¨Ì¦¸Ãþ±À¡I¦P®Én¦Ò¼{·l¯Ó¡I¡I
½Ð°Ý¥N½X¦p¦ó¼g¡A§Ú¤w¸g¥Î»¼Âkºâªk¹ê²{¤FBOMªº®i¶}¦p¤U¡G
®i¶}¦Z¼Æ¾Ú¦s©ñÁ{®Éªí¬°zkbom,µ²ºc¦p¤U
jc ¶¥¦¸
lpbh ®Æ¸¹
qty ³æ¦ì¥Î¶q
¥N½X: |
PARA flpbh
PRIV mlpbh
mlpbh=flpbh
DIMENSION renu(40)
dimension qty(40)
dimension chil(40)
for i = 1 to 40
store 1 to qty(i)
endfor
sele bom
loca for alltrim(par_lpbh)==mlpbh
i=1
do while .t.
if found()
renu(i) = recno()
if i = 1
qty(i) = qty*(1+hsbl/100)
else
qty(i) = qty(i-1)*(qty*(1+hsbl/100))
endif
chil(i)=com_lpbh
pleve=repl('.',i)+alltrim(str(i))
insert into zkbom &&zkbom¬°¦s©ñBOM®i¶}¦Z¦s©ñ¼Æ¾Ú(jc,lpbh,qty) ;
values (pleve,bom.com_lpbh,qty(i))
i=i+1
loca for alltrim(par_lpbh)==alltrim(chil(i-1))
else
if i>1
i=i-1
go renu(i)
ff=.f.
if i=1
ff=.t.
chil(1)=mlpbh
i=i+1
endif
continu
if ff
i=i-1
endif
else
exit
endif
endif
enddo
RETURN
|
¥H¤W¬O¤£¦Ò¼{®w¦s¡A½Ð°Ý¦p¦Ò¼{¥b¦¨«~®w¦sªº¸Ü¦p¦ó§ï¶i¥N½X¡I¡I½Ð°ª¤â«ü±Ð°Ú¡I¡I |
|
¦^³»ºÝ |
|
|
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4212 ¨Ó¦Û: Taipei,Taiwan
²Ä 2 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤T¤ë 03, 2009 9:25 am ¤å³¹¥DÃD: |
|
|
³oÓ¬O§Ú±Mªùªº,
¦ý¬O¤£¯à¬ªº|¤½¥q¾÷±K.
§Ṳ́½¥qªº°µªk©ú½T¦Ó¥B¦³®Ä²v. _________________ ¦pªG¤½¥q¦³¤U¦C§xÂZ:
1. §ä¤£¨ì«K©y,§Ö³t,²©öªº ¥Í²£±Æµ{³nÅé
2. ¤£ª¾¹D¦p¦ó§Ö³t±Æ©w ±ÄÁÊp¹º
3. ¦¨¥»§ì¤£·Ç,¦Û¤vºâ¤ñ³nÅéºâ¦³¥Î
4. ·Q¾Ç²ß¨t²Î³W¹º,·Q§ä¨t²Î¬[ºcªºÅU°Ý
½ÐÁpµ¸§ÚÌ,¤]³\§ÚÌÀ°±o¤W¦£ |
|
¦^³»ºÝ |
|
|
nelsonchuang
µù¥U®É¶¡: 2003-09-04 ¤å³¹: 563 ¨Ó¦Û: »OÆW
²Ä 3 ¼Ó
|
µoªí©ó: ¬P´Á¤G ¤T¤ë 03, 2009 2:23 pm ¤å³¹¥DÃD: |
|
|
¦pªGn¦Ò¼{®w¦s,¨º§A¬O¤£¬O¤]n¦Ò¼{¤w¹w¬ù¼Æ(¨ä¥Lªº²£«~®i¶}bom®É,¤w¦©°£ªº¼Æ¶q?)
§@ªk«Ü¦hºØ,¤£¨£±o¨CÓ¤H»¡ªº³£¾A¥Î.
¦Û¤v¥ý§@§@¬Ý,¤]³\«Ü¨¯W,°_½X·|¦³¨Ç¤ß±o. _________________ ¤j®a¦n,½Ð¦h«ü±Ð |
|
¦^³»ºÝ |
|
|
zzbdyx
µù¥U®É¶¡: 2004-02-04 ¤å³¹: 37
²Ä 4 ¼Ó
|
µoªí©ó: ¬P´Á¤T ¤T¤ë 04, 2009 3:06 pm ¤å³¹¥DÃD: |
|
|
¥Ø«e¤£¦Ò¼{¨ä¥L¤w°µMRP¹Bºâªº¤w¤À°t¼Æ¡A¶È¦b®i¶}®É¦Ò¼{®w¦s¹ê»Ú¦s¶q§Y¥i¡I |
|
¦^³»ºÝ |
|
|
ckp6250
µù¥U®É¶¡: 2004-07-30 ¤å³¹: 1644
²Ä 5 ¼Ó
|
µoªí©ó: ¬P´Á¤» ¤T¤ë 07, 2009 12:13 am ¤å³¹¥DÃD: |
|
|
Eì®Æ»Ý¨D¶q=MAX(((((A²£¶q*B¯Ó¥Î²v-B¦s¶q)*C¯Ó¥Î²v-C¦s¶q)*D¯Ó¥Î²v)-D¦s¶q)*E¯Ó¥Î²v,0)
¨Ì¦¹Ãþ±À , ¦h¤Ö¶¥³£¥i¥H®M¥Î |
|
¦^³»ºÝ |
|
|
garfield Site Admin
µù¥U®É¶¡: 2003-01-30 ¤å³¹: 2157
²Ä 6 ¼Ó
|
µoªí©ó: ¬P´Á¤é ¤T¤ë 08, 2009 10:09 pm ¤å³¹¥DÃD: |
|
|
create ªÅ¥Õ¼È¦sÀÉ
openbom(²£«~½s¸¹, ¥Í²£¼Æ¶q)
return
func openbom( ®Æ¸¹,¥Í²£¼Æ¶q )
* »¼°j§ì¥X¸ê®Æ, ¤£§t§PÂ_¦ºµ²ªºª¬ªp.
local itemcount[1,3],i
select ¤l¥ó½s¸¹,³æ¦ì¥Î¶q,·l¯Ó¤ñ²v where ¥À¥ó®Æ¸¹=®Æ¸¹ into array itemcount
if _tally = 0
return
else
for i=1 to alen( itemcount,1)
insert into ¼È¦sÀÉ , ±N ¥À¥ó®Æ¸¹,¤l¥ó½s¸¹,³æ¦ì¥Î¶q,·l¯Ó¤ñ²v, ¥Í²£¼Æ¶q*³æ¦ì¥Î¶q*·l¯Ó¤ñ²v=»Ý¨D¶q
openbom(¤l¥ó½s¸¹, ¥Í²£¼Æ¶q)
next
endif
return
****
¸Õ¬Ý¬Ý¤j·§¬O³o¼Ë¼g§a. _________________ §Q¥Î>>·j´M<<ªº¥\¯à·|¤ñ°ÝªºÁÙn§Ö±o¨ìµª®×. |
|
¦^³»ºÝ |
|
|
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4212 ¨Ó¦Û: Taipei,Taiwan
²Ä 7 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤T¤ë 09, 2009 9:03 am ¤å³¹¥DÃD: |
|
|
"¥Ø«e¤£¦Ò¼{¨ä¥L¤w°µMRP¹Bºâªº¤w¤À°t¼Æ¡A¶È¦b®i¶}®É¦Ò¼{®w¦s¹ê»Ú¦s¶q§Y¥i¡I"
¨º´N¬O¤@©w·|¤Ö¶R§a.
¦P¤@§å®Æ«ç»ò¥i¥H«½Æ¤À°t?
¥t¥~,
§Aı±o§Aªº"®w¦s¹ê»Ú¦s¶q",¤£ºÞ¦b¤°»ò±¡ªp¤U,
³£·|·Ç½T¶Ü?
(¤£¦Ò¼{¤Hû¥´³æ¤£»ôªº±¡ªp)
§Aªº"®w¦s¹ê»Ú¦s¶q"¦bÀÉ®×·´·lªº±¡ªp¤U¦³¯à¤O««Ø¶Ü? _________________ ¦pªG¤½¥q¦³¤U¦C§xÂZ:
1. §ä¤£¨ì«K©y,§Ö³t,²©öªº ¥Í²£±Æµ{³nÅé
2. ¤£ª¾¹D¦p¦ó§Ö³t±Æ©w ±ÄÁÊp¹º
3. ¦¨¥»§ì¤£·Ç,¦Û¤vºâ¤ñ³nÅéºâ¦³¥Î
4. ·Q¾Ç²ß¨t²Î³W¹º,·Q§ä¨t²Î¬[ºcªºÅU°Ý
½ÐÁpµ¸§ÚÌ,¤]³\§ÚÌÀ°±o¤W¦£ |
|
¦^³»ºÝ |
|
|
zzbdyx
µù¥U®É¶¡: 2004-02-04 ¤å³¹: 37
²Ä 8 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤T¤ë 09, 2009 9:14 am ¤å³¹¥DÃD: °ÝÃD¤w¸Ñ¨M |
|
|
ÁÂÁÂgarfield
¡A°ÝÃD¤w¸Ñ¨M¡A¦}¥B¦b§Aªº°ò¦¤W§Ú§¹µ½¤F¥N½X¡A´N¬O¦Û°Ê®Ú¾Ú¬Y¶¥¼h¬O§_¦³¤U¶¥ª«®Æ¨Ó°Ï¤À¥b¦¨«~¤Îì§÷®Æ±q¦Ó±o¥X«Øij¥Í²£¤Î«ØijªöÁʪº¨âÓ¤ÀªRªí!!
¸U¤À·PÁ |
|
¦^³»ºÝ |
|
|
zzbdyx
µù¥U®É¶¡: 2004-02-04 ¤å³¹: 37
²Ä 9 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤T¤ë 16, 2009 2:53 pm ¤å³¹¥DÃD: |
|
|
½Ð±Ðgarfield ¡G
¦p¦ó±NBOMµ²ºc¥ÎTREEVIEW¨ÓÅã¥Ü©O¡H
¦pªG¤£¦s¦b¤£¦Pª«®Æ¤Þ¥Î¦P¤@ºØì§÷®Æ«hºâªk¬Û¹ï²³æ¡A¦ý¬O¦pªG¦s¦b¦b¦P¤@Ó²£«~ªºBOM¤¤¦s¦b¤£¦P¥b¦¨«~¤Þ¥Î¤F¦P¤@ºØì§÷®Æ®Éºâªk¦p¦ó©O¡A¤ñ¤è¦³¦p¹Ï©Ò¥Ü²£«~A¡A¬d¸ß¥XBOMªºªíµ²ºc¤Î°O¿ý¦p¤U¡G
¶¥¼h ¤÷¥ó®Æ¸¹ ¤l¥ó®Æ¸¹
.1 A B
..2 B D
...3 D H
..2 B E
.1 A C
..2 C D
...3 D H
½Ð±Ð¦p¦ó¥ÎTREEVIEW¨Ó®i¥Ü¸ÓBOM |
|
¦^³»ºÝ |
|
|
garfield Site Admin
µù¥U®É¶¡: 2003-01-30 ¤å³¹: 2157
²Ä 10 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤T¤ë 16, 2009 3:06 pm ¤å³¹¥DÃD: |
|
|
§ï¦b treeview Åã¥Ü´N¥Îtreeview³oÓ¤¸¥ó,
¥Îªk½Ð ·j´M ´Nª¾¹D.
¤Þ¥Î¦P¤@ì®Æ,
¥i¥H¥Î select ²£«~½s¸¹,sum(¼Æ¶q) ... from ... ³oÃþªº«ü¥O§Y¥iºâ¥X¼Æ¶q.
¥t¥~¤pÁnªº§i¶D§A......
§Ú¨S¦³¼g¹L»s³y·~µ{¦¡ªº¸gÅç...
¤£n§i¶D§O¤H®@. _________________ §Q¥Î>>·j´M<<ªº¥\¯à·|¤ñ°ÝªºÁÙn§Ö±o¨ìµª®×. |
|
¦^³»ºÝ |
|
|
syntech
µù¥U®É¶¡: 2003-05-16 ¤å³¹: 4212 ¨Ó¦Û: Taipei,Taiwan
²Ä 11 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤T¤ë 16, 2009 3:27 pm ¤å³¹¥DÃD: |
|
|
ÁÙ¦n°Õ.
¦³¤ã¹êªº°ò¦,´N«Ü®e©öÅܤÆ.
garfield ¥Sªº°ò¦«D±`¤ã¹ê,
¤£¹³§Ú. ^_^|||
¹³§Ṳ́½¥q¼Ð·Çªº¬O "«D»¼°j"¦¡bom®i¶}¼Ò²Õ,
¤£¹L§Ú¨ì¤½¥qªº²Ä¤@¦~´N¥i¥Hvfp°µ¦¨"»¼°j"¦¡bom®i¶}¼Ò²Õ,
¤p®ÉÔ¦h¤Ö¦³¯AÂy¤@ÂI.
¥Ø«e¦bbcb¶}µoªº¨t²Î´N¬O¨Ï¥Î"»¼°j"¦¡bom®i¶}¼Ò²Õ,
¦]¬°bcb¾Þ§@¥»¦acursorªº¯à¤O«ÜÁV.
¤£±o¤£¨Ï¥Î"»¼°j"¦¡bom®i¶}¼Ò²Õ,
§Ṳ́½¥q¼Ð·Çªº"«D»¼°j"¦¡bom®i¶}¼Ò²Õ,
¬O±qclipper ¨t²Î¯d¤Uªº,
¦b20¦~«e´N¥i¥H°µ¨ìµL¶¥¦¸ªº®i¶}.
bom®i¶}®É,
¦pªG©³¤UÁÙ¦³¤l¥ó,
¥L´N¬O¤@Ónode,
¤Ï¤§,´N¬O¤@Óleaf.
¤@¶}©lªºªFªF´N¬Oroot,
Ãä®i¶}Ãä°µtreeview·|²³æ¤@ÂI,
¦pªG¬O®i§¹¦A§@treeview,
´Nn°µÂI¤p¤â¸}¥h§PÂ_.
key word "stack"
§ÚÁÙ¦³§Q¥Î³oÓidea,§@¦¨¥Ñ®i¶}µ²ªG¤Ï©î¦¨¤÷¤l¥óµ²ºcªºµ{¦¡.
¦ý¬O³o»P§A¦p¦óÀx¦sbom®i¶}µ²ªG¦³Ãö,
³]pªº¤£¦n,
¤]·|¤£®e©ö©î. _________________ ¦pªG¤½¥q¦³¤U¦C§xÂZ:
1. §ä¤£¨ì«K©y,§Ö³t,²©öªº ¥Í²£±Æµ{³nÅé
2. ¤£ª¾¹D¦p¦ó§Ö³t±Æ©w ±ÄÁÊp¹º
3. ¦¨¥»§ì¤£·Ç,¦Û¤vºâ¤ñ³nÅéºâ¦³¥Î
4. ·Q¾Ç²ß¨t²Î³W¹º,·Q§ä¨t²Î¬[ºcªºÅU°Ý
½ÐÁpµ¸§ÚÌ,¤]³\§ÚÌÀ°±o¤W¦£ |
|
¦^³»ºÝ |
|
|
goto-dream
µù¥U®É¶¡: 2004-05-11 ¤å³¹: 909
²Ä 12 ¼Ó
|
|
¦^³»ºÝ |
|
|
|
|
±z µLªk ¦b³oÓª©±µoªí¤å³¹ ±z µLªk ¦b³oÓª©±¦^ÂФ峹 ±z µLªk ¦b³oÓª©±½s¿è¤å³¹ ±z µLªk ¦b³oÓª©±§R°£¤å³¹ ±z µLªk ¦b³oÓª©±¶i¦æ§ë²¼ ±z µLªk ¦b³oÓª©±ªþ¥[ÀÉ®× ±z µLªk ¦b³oÓª©±¤U¸üÀÉ®×
|
Powered by phpBB © 2001, 2005 phpBB Group ¥¿Å餤¤å»y¨t¥Ñ phpbb-tw ºûÅ@»s§@
|