复制代码 代码如下:
''' <summary>
''' 将数据转换为Double数字
''' </summary>
''' <param name="Obj"></param>
''' <returns></returns>
''' <remarks></remarks>
Public Shared Function todbl(ByVal Obj As Object) As Double
If Obj Is DBNull.Value Then
Return 0
ElseIf IsNumeric(Obj) = False Then
Return 0
Else
Return Obj
End If
End Function
复制代码 代码如下:
''' <summary>
''' 将金额转换成大写
''' </summary>
''' <param name="Money">金额</param>
''' <returns></returns>
''' <remarks></remarks>
Public Shared Function UpperMoney(ByVal Money As String) As String
Money = todbl(Money).ToString("0.00")
Dim strFuShu As String = IIf(Money.StartsWith("-"), "负", "")
Money = Money.Replace("-", "").Replace(".", "")
Dim Number As String = "零壹贰叁肆伍陆柒捌玖"
Dim Unit As String = "分角元拾佰仟万拾佰仟亿拾佰仟万"
Dim str As String
For i As Integer = 0 To Money.Length - 1
Dim c As String = Money.Chars(i)
Dim Index As Integer = Money.Length - 1 - i
str &= Number(c) & Unit(Index)
Next
str = strFuShu & str & "整"
Return str
End Function