数字金额转化大写金额

 /**
    * 数字金额转化大写金额
    * @param val string/number(字符串可包含‘¥’和多余的0)
    * @returns {*}
    * 原生方法
    */

//代码如下所示:

function convertCurrency(money) {

    //汉字的数字
    var cnNums = new Array('零', '壹', '贰', '叁', '肆', '伍', '陆', '柒', '捌', '玖');
    //基本单位
    var cnIntRadice = new Array('', '拾', '佰', '仟');
    //对应整数部分扩展单位
    var cnIntUnits = new Array('', '万', '亿', '兆');
    //对应小数部分单位
    var cnDecUnits = new Array('角', '分', '毫', '厘');
    //整数金额时后面跟的字符
    var cnInteger = '整';
    //整型完以后的单位
    var cnIntLast = '元';
    //最大处理的数字
    var maxNum = 999999999999999.9999;
    //金额整数部分
    var integerNum;
    //金额小数部分
    var decimalNum;
    //输出的中文金额字符串
    var chineseStr = '';
    //分离金额后用的数组,预定义
    var parts;
    if (money == '') { return ''; }
    if(typeof(money) === "string" ){
        money = money.replace('¥','');
        money = money.split(',').join('');
        money = parseFloat(money);
    }
    if (money >= maxNum) {
        //超出最大处理金额
        return '';
    }
    if (money == 0) {
        chineseStr = cnNums[0] + cnIntLast + cnInteger;
        return chineseStr;
    }
    //转换为字符串
    money = money.toString();
    if (money.indexOf('.') == -1) {
        integerNum = money;
        decimalNum = '';
    } else {
        parts = money.split('.');
        integerNum = parts[0];
        decimalNum = parts[1].substr(0, 4);
    }
    //获取整型部分转换
    if (parseInt(integerNum, 10) > 0) {
        var zeroCount = 0;
        var IntLen = integerNum.length;
        for (var i = 0; i < IntLen; i++) {
            var n = integerNum.substr(i, 1);
            var p = IntLen - i - 1;
            var q = p / 4;
            var m = p % 4;
            if (n == '0') {
                zeroCount++;
            } else {
                if (zeroCount > 0) {
                    chineseStr += cnNums[0];
                }
                //归零
                zeroCount = 0;
                chineseStr += cnNums[parseInt(n)] + cnIntRadice[m];
            }
            if (m == 0 && zeroCount < 4) {
                chineseStr += cnIntUnits[q];
            }
        }
        chineseStr += cnIntLast;
    }
    //小数部分
    if (decimalNum != '') {
        var decLen = decimalNum.length;
        for (var i = 0; i < decLen; i++) {
            var n = decimalNum.substr(i, 1);
            if (n != '0') {
                chineseStr += cnNums[Number(n)] + cnDecUnits[i];
            }
        }
    }
    if (chineseStr == '') {
        chineseStr += cnNums[0] + cnIntLast + cnInteger;
    } else if (decimalNum == '') {
        chineseStr += cnInteger;
    }
    return chineseStr;
}
  • 1
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
<script type="text/javascript"> function CheckAlls(checked) { len = document.frmmain.elements.length; var i=0; for( i=0; i<len; i++) { if (document.frmmain.elements[i].name=='check_node_0') { if(document.frmmain.elements[i].disabled == false){ document.frmmain.elements[i].checked=(checked==true?true:false); } } } } </script><script> document.onpropertychange= function() { var a= document.getElementById('field6163').value;//取小写金额的值 var numberValue=new String(Math.round(a*100)); // 数字金额 var String1 = "零壹贰叁肆伍陆柒捌玖"; // 汉字数字 var String2 = "万仟佰拾亿仟佰拾万仟佰拾元角分"; // 对应单位 var len=numberValue.length; // numberValue 的字符串长度 //alert(len); var Ch1; // 数字的汉语读法 var Ch2; // 数字位的汉字读法 var nZero=0; // 用来计算连续的零值的个数 var String3; // 指定位置的数值 { if(len>15){ alert("超出计算范围"); return fase; } if (numberValue==0){ chineseValue = "零元整"; } else { chineseValue=""; } String2 = String2.substr(String2.length-len, len); // 取出对应位数的STRING2的值 for(var i=0; i<len; i++){ String3 = parseInt(numberValue.substr(i, 1),10); // 取出需转换的某一位的值 if ( i != (len - 3) && i != (len - 7) && i != (len - 11) && i !=(len - 15) ){ if ( String3 == 0 ){ Ch1 = ""; Ch2 = ""; nZero = nZero + 1; } else if ( String3 != 0 && nZero != 0 ){ Ch1 = "零" + String1.substr(String3, 1); Ch2 = String2.substr(i, 1); nZero = 0; } else{ Ch1 = String1.substr(String3, 1); Ch2 = String2.substr(i, 1); nZero = 0; } } else{ // 该位是万亿,亿,万,元位等关键位 if( String3 != 0 && nZero != 0 ){ Ch1 = "零" + String1.substr(String3, 1); Ch2 = String2.substr(i, 1); nZero = 0; } else if ( String3 != 0 && nZero == 0 ){ Ch1 = String1.substr(String3, 1); Ch2 = String2.substr(i, 1); nZero = 0; } else if( String3 == 0 && nZero >= 3 ){ Ch1 = ""; Ch2 = ""; nZero = nZero + 1; } else{ Ch1 = ""; Ch2 = String2.substr(i, 1); nZero = nZero + 1; } if( i == (len - 11) || i == (len - 3)){ // 如果该位是亿位或元位,则必须写上 Ch2 = String2.substr(i, 1); } } chineseValue =chineseValue +Ch1 + Ch2; } if ( String3 == 0 ){ // 最后一位(分)为0时,加上“整” chineseValue = chineseValue + "整"; } } //alert(chineseValue); document.getElementById('field6421').value=chineseValue; } </script>
你可以使用以下SQL函数将金额数字转换为大写: ```sql CREATE FUNCTION dbo.ConvertToWords (@NumValue DECIMAL(19, 2)) RETURNS NVARCHAR(4000) AS BEGIN DECLARE @WholePart BIGINT DECLARE @FractionalPart INT DECLARE @Words NVARCHAR(4000) SELECT @WholePart = CONVERT(BIGINT, FLOOR(@NumValue)) SELECT @FractionalPart = CONVERT(INT, (@NumValue - @WholePart) * 100) -- Whole part conversion SELECT @Words = dbo.ConvertNumber(@WholePart) + ' dollars ' -- Fractional part conversion IF @FractionalPart > 0 BEGIN SELECT @Words = @Words + 'and ' + dbo.ConvertNumber(@FractionalPart) + ' cents' END RETURN @Words END GO CREATE FUNCTION dbo.ConvertNumber (@Number BIGINT) RETURNS NVARCHAR(4000) AS BEGIN DECLARE @Units TABLE (UnitName NVARCHAR(10)) DECLARE @Tens TABLE (TenName NVARCHAR(10)) DECLARE @Teens TABLE (TeenName NVARCHAR(10)) INSERT INTO @Units VALUES ('Zero'), ('One'), ('Two'), ('Three'), ('Four'), ('Five'), ('Six'), ('Seven'), ('Eight'), ('Nine') INSERT INTO @Tens VALUES ('Ten'), ('Twenty'), ('Thirty'), ('Forty'), ('Fifty'), ('Sixty'), ('Seventy'), ('Eighty'), ('Ninety') INSERT INTO @Teens VALUES ('Eleven'), ('Twelve'), ('Thirteen'), ('Fourteen'), ('Fifteen'), ('Sixteen'), ('Seventeen'), ('Eighteen'), ('Nineteen') DECLARE @Words NVARCHAR(4000) IF @Number >= 1000000000 BEGIN SELECT @Words = dbo.ConvertNumber(@Number / 1000000000) + ' billion ' SELECT @Number = @Number % 1000000000 END IF @Number >= 1000000 BEGIN SELECT @Words = @Words + dbo.ConvertNumber(@Number / 1000000) + ' million ' SELECT @Number = @Number % 1000000 END IF @Number >= 1000 BEGIN SELECT @Words = @Words + dbo.ConvertNumber(@Number / 1000) + ' thousand ' SELECT @Number = @Number % 1000 END IF @Number >= 100 BEGIN SELECT @Words = @Words + dbo.ConvertNumber(@Number / 100) + ' hundred ' SELECT @Number = @Number % 100 END IF @Number >= 20 BEGIN SELECT @Words = @Words + (SELECT TenName FROM @Tens WHERE (ROW_NUMBER() OVER (ORDER BY (SELECT NULL))) = (@Number / 10)) + ' ' SELECT @Number = @Number % 10 END IF @Number > 10 AND @Number < 20 BEGIN SELECT @Words = @Words + (SELECT TeenName FROM @Teens WHERE (ROW_NUMBER() OVER (ORDER BY (SELECT NULL))) = (@Number - 10)) + ' ' SELECT @Number = 0 END IF @Number > 0 BEGIN SELECT @Words = @Words + (SELECT UnitName FROM @Units WHERE (ROW_NUMBER() OVER (ORDER BY (SELECT NULL))) = @Number) + ' ' END RETURN RTRIM(@Words) END GO ``` 要使用这个函数,你可以像这样调用它: ```sql SELECT dbo.ConvertToWords(12345.67) AS AmountInWords ``` 该函数将返回 "Twelve thousand three hundred forty-five dollars and sixty-seven cents"。 请注意,此示例仅处理最多十亿美元的金额。如果需要处理更大的金额,请根据需要进行修改。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值