你可以用自定已脚本实现。我们默认没有这个函数:
https://www.grapecity.com.cn/sol ... ings/user-functions
脚本参考这个:
- /// <function name="ConvertToCNYText">
- /// <culture>
- /// <label>ConvertToCNYText</label>
- /// <syntax>ConvertToCNYText(string inputString)</syntax>
- /// <description>自动转换中文单位</description>
- /// <example>ConvertToCNYText("100") = 壹佰元整
- /// </example>
- /// </culture>
- /// </function>
- ///
- public string ConvertToCNYText(string inputString)
- {
- try
- {
- string numList = "零壹贰叁肆伍陆柒捌玖";
- string rmbList = "分角元拾佰仟万拾佰仟亿拾佰仟万";
- double number = 0;
- string tempOutString = "";
- number = double.Parse(inputString);
- string tempNumberString = Convert.ToInt64(number * 100).ToString();
- int tempNmberLength = tempNumberString.Length;
- int i = 0;
- while (i < tempNmberLength)
- {
- int oneNumber = Int32.Parse(tempNumberString.Substring(i, 1));
- string oneNumberChar = numList.Substring(oneNumber, 1);
- string oneNumberUnit = rmbList.Substring(tempNmberLength - i - 1, 1);
- if (!(oneNumberChar == "零"))
- tempOutString += oneNumberChar + oneNumberUnit;
- else
- {
- if (oneNumberUnit == "亿" || oneNumberUnit == "万" || oneNumberUnit == "元" || oneNumberUnit == "零")
- {
- while (tempOutString.EndsWith("零"))
- tempOutString = tempOutString.Substring(0, tempOutString.Length - 1);
- }
- if (oneNumberUnit == "亿" || (oneNumberUnit == "万" && !tempOutString.EndsWith("亿")) || oneNumberUnit == "元")
- tempOutString += oneNumberUnit;
- else if (tempOutString != null)
- {
- bool tempEnd = tempOutString.EndsWith("亿");
- bool zeroEnd = tempOutString.EndsWith("零");
- if (tempOutString.Length > 1)
- {
- bool zeroStart = tempOutString.Substring(tempOutString.Length - 2, 2).StartsWith("零");
- if (!zeroEnd && (zeroStart || !tempEnd))
- tempOutString += oneNumberChar;
- }
- else if (!zeroEnd && !tempEnd)
- tempOutString += oneNumberChar;
- }
- }
- i += 1;
- }
- if (tempOutString != null)
- {
- while (tempOutString.EndsWith("零"))
- tempOutString = tempOutString.Substring(0, tempOutString.Length - 1);
- while (tempOutString.EndsWith("元"))
- tempOutString = tempOutString + "整";
- return tempOutString;
- }
- }
- catch (Exception ex)
- {
- return "#数值转换错误" + ex.Message;
- }
- return String.Empty;
- }
|
陕公网安备：61019002000258 |
隐私政策 |
网站地图