专家坐堂-[求助]求助有点色老师关于WORD模板急！Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

以文本方式查看主题

-  Foxtable(狐表)  (http://foxtable.net/bbs/index.asp)
--  专家坐堂  (http://foxtable.net/bbs/list.asp?boardid=2)
----  [求助]求助有点色老师关于WORD模板急！  (http://foxtable.net/bbs/dispbbs.asp?boardid=2&id=100466)

--  作者：biaoai2011
--  发布时间：2017/5/11 19:35:00
--  [求助]求助有点色老师关于WORD模板急！
请问老师，我在TAble表里有序号一列，我在WORLD报表模板里设计报表，我想将序号一列的数字转换为汉字，为此我用的代码是

<Clnum(format([序号],"0"))>，可是我发现1到9都能转换为一二三四一直到九，但是到了10及以上就不行了，10转换的一〇，11转换成了一一，12转换成了一二，我想问老师的是要怎么才能把10转换成十，11转换成十一。谢谢。

[此贴子已经被作者于2017/5/11 20:05:19编辑过]

--  作者：有点色
--  发布时间：2017/5/11 20:27:00
--

用下面的代码测试

dim str = Replace(Replace(Replace(Replace(CUNumber(21),"壹","一"), "拾", "十"), "贰", "二"), "叁", "三")
msgbox(str)

--  作者：biaoai2011
--  发布时间：2017/5/11 21:41:00
--

以下是引用有点色在2017/5/11 20:27:00的发言：

用下面的代码测试

dim str = Replace(Replace(Replace(Replace(CUNumber(21),"壹","一"), "拾", "十"), "贰", "二"), "叁", "三")
msgbox(str)
不是呀老师，我说的是写在WORLD里的

--  作者：biaoai2011
--  发布时间：2017/5/11 21:44:00
--
像这样
[此贴子已经被作者于2017/5/11 21:43:57编辑过]

--  作者：有点色
--  发布时间：2017/5/11 22:08:00
--

请灵活变通，比如

<Replace(Replace(Replace(Replace(CUNumber([序号]),"壹","一"), "拾", "十"), "贰", "二"), "叁", "三")>

--  作者：biaoai2011
--  发布时间：2017/5/11 23:03:00
--

此主题相关图片如下：0001.png

此主题相关图片如下：0002.png

老师，现在成这样了。
我想的是一二三四五六七八九十十一十二十三这样

--  作者：有点色
--  发布时间：2017/5/11 23:38:00
--

看懂下面代码

dim i as integer = 54
Dim str = iif(i=10, "十", iif(i>10 and i<20, right(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(CUNumber(i),"壹","一"), "拾", "十"), "贰", "二"), "叁", "三"), "肆", "四"), "伍", "五"), "陆", "六"), "柒", "七"), "捌", "八"), "玖", "九"),2), Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(CUNumber(i),"壹","一"), "拾", "十"), "贰", "二"), "叁", "三"), "肆", "四"), "伍", "五"), "陆", "六"), "柒", "七"), "捌", "八"), "玖", "九")))
msgbox(str)

--  作者：biaoai2011
--  发布时间：2017/5/12 8:55:00
--

以下是引用有点色在2017/5/11 23:38:00的发言：

看懂下面代码

dim i as integer = 54
Dim str = iif(i=10, "十", iif(i>10 and i<20, right(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(CUNumber(i),"壹","一"), "拾", "十"), "贰", "二"), "叁", "三"), "肆", "四"), "伍", "五"), "陆", "六"), "柒", "七"), "捌", "八"), "玖", "九"),2), Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(CUNumber(i),"壹","一"), "拾", "十"), "贰", "二"), "叁", "三"), "肆", "四"), "伍", "五"), "陆", "六"), "柒", "七"), "捌", "八"), "玖", "九")))
msgbox(str)

这个代码要写在哪哦

--  作者：有点色
--  发布时间：2017/5/12 9:02:00
--
<iif([序号]=10, "十", iif([序号]>10 And [序号]<20, right(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(CUNumber([序号]),"壹","一"), "拾", "十"), "贰", "二"), "叁", "三"), "肆", "四"), "伍", "五"), "陆", "六"), "柒", "七"), "捌", "八"), "玖", "九"),2), Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(CUNumber([序号]),"壹","一"), "拾", "十"), "贰", "二"), "叁", "三"), "肆", "四"), "伍", "五"), "陆", "六"), "柒", "七"), "捌", "八"), "玖", "九")))>

--  作者：biaoai2011
--  发布时间：2017/5/13 9:12:00
--

以下是引用有点色在2017/5/12 9:02:00的发言：
<iif([序号]=10, "十", iif([序号]>10 And [序号]<20, right(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(CUNumber([序号]),"壹","一"), "拾", "十"), "贰", "二"), "叁", "三"), "肆", "四"), "伍", "五"), "陆", "六"), "柒", "七"), "捌", "八"), "玖", "九"),2), Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(CUNumber([序号]),"壹","一"), "拾", "十"), "贰", "二"), "叁", "三"), "肆", "四"), "伍", "五"), "陆", "六"), "柒", "七"), "捌", "八"), "玖", "九")))>

粘贴进去后没用。我直接发项目来吧
下载信息  [文件大小：   下载次数： ]
点击浏览该文件:管理项目1.rar