//Code CreateBy abandonship 2007.03.12
function FormatAfterDotNumber( ValueString, nAfterDotNum )
{
var ValueString,nAfterDotNum
var resultStr,nTen
ValueString = ""+ValueString+""
strLen = ValueString.length
dotPos = ValueString.indexOf(".",0)
if (dotPos == -1)
{
resultStr = ValueString+"."
for (i=0i<nAfterDotNum i++)
{
resultStr = resultStr+"0"
}
return resultStr
}
else
{
if ((strLen - dotPos - 1) >= nAfterDotNum ){
nAfter = dotPos + nAfterDotNum + 1
nTen =1
for(j=0j<nAfterDotNum j++){
nTen = nTen*10
}
resultStr = Math.round(parseFloat(ValueString)*nTen)/nTen
return resultStr
}
else{
resultStr = ValueString
for (i=0i<(nAfterDotNum - strLen + dotPos + 1)i++){
resultStr = resultStr+"0"
}
return resultStr
}
}
}
应用时只需要FormatAfterDotNumber( ’数字字符串’, 保留小数位数 )
for example:
<html>
<head>
<SCRIPT LANGUAGE="JAVAscript">
<!--调用上面的函数 -->
</script>
</head>
<body>
<input type="text" name="strTemp">
<input type="button" onclick="alert( FormatAfterDotNumber( document.all. strTemp.value), 保留小数位)" >
</body>
</html>
简单点，用CAST来转换，看一下以下的结果。SELECT 0.15 AS 转换前0,CAST(0.15 AS nvarchar) AS 转换后0,1.15 AS 转换前,CAST(1.15 AS nvarchar) AS 转换后
运行结果为：
.15 0.15 1.15 1.15
欢迎分享，转载请注明来源：内存溢出
微信扫一扫
支付宝扫一扫
评论列表（0条）