将数字转换成大写金额(整数)

    private string ChineseMoney(int num)
    {
        string retVal = string.Empty;


        string money = num.ToString();


        char[] chrM = money.ToCharArray();


        string[] NumChineseCharacter = new string[] { "零", "壹", "贰", "叁", "肆", "伍", "陆", "柒", "捌", "玖" };
        string[] NumCharacter = new string[] { "", "拾", "佰", "仟", "万" };


        int x = 0;


        for (int i = chrM.Length - 1; i >= 0; i--)
        {


            if (chrM[i] == '0' && string.IsNullOrEmpty(retVal) == false)
            {
                retVal = NumChineseCharacter[0] + retVal;
            }
            else if (chrM[i] != '0')
            {
                retVal = NumChineseCharacter[int.Parse(chrM[i].ToString())] + NumCharacter[x] + retVal;
            }
            x++;
        }


        retVal = retVal.Replace("零零零", "");


        retVal = retVal.Replace("零零", "零");


        if (string.IsNullOrEmpty(retVal) == true)
        {
            retVal = "零";
        }
        //else
        //{
        //    retVal += "";
        //}


        if (retVal.Length > 3)
        {
            retVal = retVal.Replace("零", "");


        }


        return retVal;
    }
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
在 SQL 中将数字转换大写金额可以通过自定义函数来实现。以下是一个示例: ```sql CREATE FUNCTION dbo.NumToCny (@Num DECIMAL(18,2)) RETURNS VARCHAR(1024) AS BEGIN -- 数字对应的大写汉字 DECLARE @CnyTable TABLE (Num INT, Cny VARCHAR(16)) INSERT INTO @CnyTable (Num, Cny) VALUES (0, '零'), (1, '壹'), (2, '贰'), (3, '叁'), (4, '肆'), (5, '伍'), (6, '陆'), (7, '柒'), (8, '捌'), (9, '玖') -- 金额单位对应的汉字 DECLARE @UnitTable TABLE (Unit INT, Cny VARCHAR(8)) INSERT INTO @UnitTable (Unit, Cny) VALUES (0, ''), (1, '拾'), (2, '佰'), (3, '仟'), (4, '万'), (5, '拾'), (6, '佰'), (7, '仟'), (8, '亿'), (9, '拾'), (10, '佰'), (11, '仟') DECLARE @Cny VARCHAR(1024) = '' DECLARE @IntPart BIGINT = CAST(@Num AS BIGINT) DECLARE @DecPart DECIMAL(18,2) = @Num - @IntPart IF @IntPart = 0 SET @Cny = '零元' ELSE BEGIN -- 整数部分转换 DECLARE @IntCny VARCHAR(1024) = '' DECLARE @Unit INT = 0 WHILE @IntPart > 0 BEGIN DECLARE @Num INT = @IntPart % 10 DECLARE @UnitCny VARCHAR(8) = (SELECT Cny FROM @UnitTable WHERE Unit = @Unit) DECLARE @NumCny VARCHAR(16) = (SELECT Cny FROM @CnyTable WHERE Num = @Num) IF @Num = 0 AND (@Unit = 4 OR @Unit = 8) SET @IntCny = @NumCny + @UnitCny + @IntCny ELSE SET @IntCny = @NumCny + @UnitCny + @IntCny SET @IntPart = @IntPart / 10 SET @Unit = @Unit + 1 END SET @Cny = @IntCny + '元' END -- 小数部分转换 IF @DecPart > 0 BEGIN DECLARE @DecCny VARCHAR(1024) = '' DECLARE @DecString VARCHAR(18) = REPLACE(CAST(@DecPart AS VARCHAR(18)), '0.', '') DECLARE @Len INT = LEN(@DecString) DECLARE @i INT = 1 WHILE @i <= @Len BEGIN DECLARE @Num INT = CAST(SUBSTRING(@DecString, @i, 1) AS INT) DECLARE @NumCny VARCHAR(16) = (SELECT Cny FROM @CnyTable WHERE Num = @Num) DECLARE @UnitCny VARCHAR(8) = (SELECT Cny FROM @UnitTable WHERE Unit = -@i) SET @DecCny = @DecCny + @NumCny + @UnitCny SET @i = @i + 1 END SET @Cny = @Cny + @DecCny + '分' END RETURN @Cny END ``` 使用方法: ```sql SELECT dbo.NumToCny(1234567.89) AS CnyAmount -- 输出:壹佰贰拾叁万肆仟伍佰陆拾柒元捌角玖分 ```

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

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

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值