/// <summary>    /// 本类实现阿拉伯数字到大写中文的转换    /// 该类没有对非法数字进行判别,请事先自己判断数字是否合法    /// </summary>    public class ChineseNum    { //小写转大写        public static string GetChineseNum(string p_num)        {            ChineseNum cn = new ChineseNum(); r

自动将小写的金额数值转换为大写,方便记录 class project_parm(models.Model): def IIf(self, b, s1, s2): if b: return s1 else: return s2def num2chn(self,nin=None): cs =('零','壹','贰','叁','肆','伍','陆','柒','捌','玖','◇','分','角','圆','拾','佰','仟','万','拾','佰','仟','亿','拾','佰','仟','万')

=IF(ROUND(A6,2)<0,"无效数值",IF(ROUND(A6,2)=0,"零",IF(ROUND(A6,2)<1,"",TEXT(INT(ROUND(A6,2)),"[dbnum2]")&"元")&IF(INT(ROUND(A6,2)*10)-INT(ROUND(A6,2))*10=0,IF(INT(ROUND(A6,2))*(INT(ROUND(A6,2)*100)

Create Or Replace Function Money2Chinese(Money In Number) Return Varchar2 Is strYuan Varchar2(); strYuanFen Varchar2(); numLenYuan Number; numLenYuanFen Number; strRstYuan Varchar2(); strRstFen Varchar2(); strRst Varchar2(); Type typeTabMapping Is Ta

/********************************************************作者:版本:1.0创建时间:20020227修改时间:功能:小写金额转换成大写参数:n_LowerMoney 小写金额v_TransType 种类 -- 1: directly translate, 0: read it in words 输出:大写金额********************************************************/if exists

//num为小写金额,单位元 changeMoney(num) { if(isNaN(num))return ""; var strPrefix=""; if(num<0)strPrefix ="(负)"; num=Math.abs(num); if(num>=1000000000000)return ""; var strOutput = ""; var strUnit = '仟佰拾亿仟佰拾万

#region 小写金额转换为大写 public static string CurrToChnNum(double Currnum) { string sResult = ""; if (Math.Abs(Currnum) < 1e-20) return "零圆整"; if (Currnum < 1e-20) sResult = "负"; sResult = sResult + StringToChnNum(Math.Abs(Mat

/// <summary> /// 金额转为大写金额 /// </summary> public class MoneyConvertChinese { /// <summary> /// 金额转为大写金额 /// </summary> /// <param name="LowerMoney"></param> /// <returns></returns> public static st

早些年做CRM用到的一个金额转换函数,今天从旧项目中拿出来记录一下.金额转换的函数方法有很多,都很不错.不过这个是小崔刚工作的时候写的一个转换函数,多少还是有点纪念意义.如有问题请朋友们指出,小崔及时修正.谢谢啦! 废话不多说直接上代码: <?php /** * 数字金额转换大写数字 * $num 数字类型 */ function inttodaxie($num) { //判断$num是否数字 if(!is_numeric($num)) return -1; $dint = array('零',

我们日常开发业务系统中,作为统计报表中,特别是财务报表,显示中文金额经常遇到. 转换大小写的方法有很多,以下是从数据库函数方面解决这一问题. 效果如图: 调用:SELECT dbo.[Fn_ConvertRMB](192.4) 具体函数如下: -- ============================================= -- 调用:SELECT dbo.[Fn_ConvertRMB](192.4) -- Create date: 2015-01-06 -- Descripti

<script> function chineseNumber(num){ if (isNaN(num) || num > Math.pow(10, 12)) return "" var cn = "零壹贰叁肆伍陆柒捌玖" var unit = new Array("拾百千", "分角") var unit1 = new Array("万亿", "") var numA

假设 假设数据在A1单元格 任何一个个单元格输入公式=TEXT(INT(A1),"[dbnum2]")&"元"&IF(INT(A1*10)-INT(A1)*10=0,"",TEXT(INT(A1*10)-INT(A1)*10,"[dbnum2]")&"角")&IF(INT(A1*100)-INT(A1*10)*10=0,"整",TEXT(INT(A1*10

public static function amountInWords($num) {         if (!is_numeric($num) || empty($num))             return "";                  $return = "";         $unit = array("分", "角", "圆", "整");        

function smalltoBIG(n) { var fraction = ['角', '分']; var digit = ['零', '壹', '贰', '叁', '肆', '伍', '陆', '柒', '捌', '玖']; var unit = [ ['元', '万', '亿'], ['', '拾', '佰', '仟'] ]; var head = n < 0 ? '欠' : ''; n = Math.abs(n); var s = ''; for (var i = 0; i < fr

function smalltoBIG(n) { var fraction = ['角', '分']; var digit = ['零', '壹', '贰', '叁', '肆', '伍', '陆', '柒', '捌', '玖']; var unit = [ ['元', '万', '亿'], ['', '拾', '佰', '仟'] ]; var head = n < 0 ? '欠' : ''; n = Math.abs(n); var s = ''; for (var i = 0; i < fr

/** 数字金额大写转换(可以处理整数,小数,负数) */ function smalltoBIG(n) { var fraction = ['角', '分']; var digit = ['零', '壹', '贰', '叁', '肆', '伍', '陆', '柒', '捌', '玖']; var unit = [ ['元', '万', '亿'], ['', '拾', '佰', '仟'] ]; var head = n ? '欠': ''; n = Math.abs(n); var s = ''

public class Tool {             private static final String UNIT = "万千佰拾亿千佰拾万千佰拾元角分";         private static final String DIGIT = "零壹贰叁肆伍陆柒捌玖";         private static final double MAX_VALUE = 9999999999999.99D;         public static St

///<summery>小写金额转化大写金额</summery> function AmountLtoU(amount) { if (isNaN(amount) || amount >= 1000000000000) return "无效金额!"; //数值最大不超过1万亿 var sPrefix = amount < 0 ? "(负)" : ""; //将负号‘-’显示成汉字‘(负)’ var sAmount

<script> jQuery(document).ready(function () { //当金额文本框失去焦点时,自动将数字转化为大写填充到 大写的文本框中 $("#Amount").blur(function () { var amount = $("#Amount").val(); amount = AmountLtoU(amount); $("#CapitalAmount").val(amount); }); }); fu

在处理财务账款时,需要将转账金额写成大写的.也就是说,如果要转账123456.00元,则需要写成“壹拾贰万叁仟肆佰伍拾陆元整”.所以常常需要通过程序控制自动进行转换.本实例实现了小写金额到大写金额的转换. 具体代码如下: import java.text.DecimalFormat; import java.util.*; //@北冥道人骑鲲打代码 public class f2 { private static String[] numBig = { "零", "壹&quo