日期转化为大写

时　间:2007-11-10 16:02:58
作　者:accsoft   ID：280  城市：武汉
摘　要:'函数功能:专门用于将日期转化为大写的字符
'调用方法:abc(date,string) date为要转化的日期，string为要转化的部分
'         string参数为"y","m","d"
正　文:

'函数功能:专门用于将日期转化为大写的字符
'调用方法:abc(date,string) date为要转化的日期，string为要转化的部分
'         string参数为"y","m","d"
'开发人员：彭海涛
'开发时间:2006年12月30日

'大小写转换
Function aqq(pht As String) As String
Select Case pht
       Case "0"
       aqq = "零"
       Case "1"
       aqq = "壹"
       Case "2"
       aqq = "贰"
       Case "3"
       aqq = "叁"
       Case "4"
       aqq = "肆"
       Case "5"
       aqq = "伍"
       Case "6"
       aqq = "陆"
       Case "7"
       aqq = "柒"
       Case "8"
       aqq = "捌"
       Case Else
       aqq = "玖"
End Select
End Function
'通用日期数据大小写转换模块
Function abc(XYZ As Date, aa As String) As String
Dim j As String
Dim a As String '用于存储大写数字
Dim b As String '用于存储大写数字
Dim c As String '用于存储大写数字
Dim d As String '用于存储大写数字
Select Case aa
       Case "y"
        j = CStr(Format(XYZ, "yyyy"))
        a = aqq(Mid(j, 1, 1))
        b = aqq(Mid(j, 2, 1))
        c = aqq(Mid(j, 3, 1))
        d = aqq(Mid(j, 4, 1))
        abc = a & b & c & d
       Case "m"
        j = CStr(Format(XYZ, "mm"))
        a = aqq(Left(j, 1))
        b = aqq(Right(j, 1))
        abc = a & b
        If Right(abc, 1) = "零" Then
        abc = "零" & Left(abc, 1) & "拾"
        End If
        If Left(abc, 1) <> "零" Then
        abc = Left(abc, 1) & "拾" & Right(abc, 1)
        End If
       Case Else
        j = CStr(Format(XYZ, "dd"))
        a = aqq(Left(j, 1))
        b = aqq(Right(j, 1))
        abc = a & b
        If Right(abc, 1) = "零" Then
        abc = "零" & Left(abc, 1) & "拾"
        End If
        If Left(abc, 1) <> "零" Then
   

Access软件网QQ交流群 (群号:54525238) 　　　　　　Access源码网店