最近做項(xiàng)目的合同部分時(shí)用到需要能把數(shù)字轉(zhuǎn)英文的程序,找過(guò)很多網(wǎng)站都沒(méi)用,只能安下心來(lái)自己做,程序作的不太精簡(jiǎn),但功能可以實(shí)現(xiàn),也許同僚們會(huì)用得著。(vbscript) function zr4(y)'準(zhǔn)備數(shù)據(jù) dim z(10) z(1)="ONE" z(2)="TWO" z(3)="THREE" z(4)="FOUR" z(5)="FIVE" z(6)="SIX" z(7)="SEVEN" z(8)="EIGHT" z(9)="NINE" zr4=z(MID(y,1,1)) end function
function zr3(y)'準(zhǔn)備數(shù)據(jù) dim z(10) z(1)="ONE" z(2)="TWO" z(3)="THREE" z(4)="FOUR" z(5)="FIVE" z(6)="SIX" z(7)="SEVEN" z(8)="EIGHT" z(9)="NINE" zr3=z(MID(y,3,1)) end function
function zr2(y)'準(zhǔn)備數(shù)據(jù)
dim z(20) z(10)="TEN" z(11)="ELEVEN" z(12)="TWELVE" z(13)="THIRTEEN" z(14)="FOURTEEN" z(15)="FIFTEEN" z(16)="SIXTEEN" z(17)="SEVENTEEN" z(18)="EIGHTEEN" z(19)="NINETEEN" zr2=z(MID(y,2,2))
end function
function zr1(y)'準(zhǔn)備數(shù)據(jù)
dim z(10) z(1)="TEN" z(2)="TWENTY" z(3)="THIRTY" z(4)="FORTY" z(5)="FIFTY" z(6)="SIXTY" z(7)="SEVENTY" z(8)="EIGHTY" z(9)="NINETY" zr1=z(MID(y,2,1))
end function
function dw(y)'準(zhǔn)備數(shù)據(jù)
dim z(5) z(0)="" z(1)="THOUSAND" z(2)="MILLION" z(3)="BILLION" dw=z(y)
end function
function w2(y)'用來(lái)制作2位數(shù)字轉(zhuǎn)英文 if MID(y,2,1)="0" then'判斷是否小于十 value=zr3(y) elseif MID(y,2,1)="1" then'判斷是否在十到二十之間 value=zr2(y) elseif MID(y,3,1)="0" then'判斷是否為大于二十小于一百的能被十整除的數(shù)(為了去掉尾空格) value=zr1(y) else value=zr1(y)+" "+zr3(y)'加上十位到個(gè)位的空格 end if w2=value end function
function w3(y)'用來(lái)制作3位數(shù)字轉(zhuǎn)英文 if MID(y,1,1)="0" then'判斷是否小于一百 value=w2(y) elseif MID(y,2,2)="00" then'判斷是否能被一百整除 value=zr4(y)+" "+"HUNDRED" else value=zr4(y)+" "+"HUNDRED"+" "+"AND"+" "+w2(y)'不能整除的要后面加“AND” end if w3=value end function
function make(x) z=instr(1,x,".",1)'取小數(shù)點(diǎn)位置 if z<>0 then'判斷有沒(méi)有小數(shù) lstr=mid(x,1,z-1)'取小數(shù)點(diǎn)左邊的字串 rstr=mid(x,z+1,2)'取小數(shù)點(diǎn)右邊的字串 else lstr=x'沒(méi)有小數(shù)的情況 end if lstrev=StrReverse(lstr)'對(duì)左邊的字串取反字串 dim a(5)'定義5個(gè)字串變量用來(lái)存放解析出的三位一組的字串 select case len(lstrev) mod 3'字串長(zhǎng)度不能被整除,需補(bǔ)齊 case "1" lstrev=lstrev+"00" case "2" lstrev=lstrev+"0" end select lm=""'用來(lái)存放轉(zhuǎn)換后的整數(shù)部分 for i=0 to len(lstrev)/3-1'計(jì)算有多少個(gè)三位 a(i)=StrReverse(mid(lstrev,3*i+1,3))'截取第1個(gè)三位 if a(i)<>"000" then'用來(lái)避免這種情況“1000000=ONE MILLION THOUSAND ONLY” if i<>0 then lm=w3(a(i))+" "+dw(i)+" "+lm'用來(lái)加上“THOUSAND OR MILLION OR BILLION” else lm=w3(a(i))'防止i=0時(shí)“l(fā)m=w3(a(i))+" "+dw(i)+" "+lm”多加兩個(gè)尾空格 end if else lm=w3(a(i))+lm end if NEXT xs=""'用來(lái)存放轉(zhuǎn)換后的小數(shù)部分 if z<>0 then xs="AND CENTS"+" "+w2("$"+rstr)+" "'小數(shù)部分存在時(shí)轉(zhuǎn)換小數(shù)部分 end if make=lm+" "+xs+"ONLY"'最后結(jié)果,加上ONLY end function
|