请高手帮忙翻译下
mCurDate = dt
lblTitle.Caption = Format(dt, "yyyy-MM-dd") & "生日提醒"
Dim strsql As String
Dim rs As ADODB.Recordset
Dim strThisAlertText As String
Dim strNextAlertText As String
Dim i As Long
Dim strDate As String
Dim strThisDay As String
Dim strNextDay As String
strThisDay = Month(dt) & "-" & Day(dt)
strNextDay = Month(DateAdd("d", 1, dt)) & "-" & Day(DateAdd("d", 1, dt))
strsql = "SELECT * FROM CUSTOMER " & _
"WHERE (NOT [Birthday] IS NULL) AND ((CStr(Month([Birthday]))+""-""+CStr(Day([Birthday]))) = '" & strThisDay & "'" & _
" OR (CStr(Month([Birthday]))+""-""+CStr(Day([Birthday]))) = '" & strNextDay & "') " & _
"ORDER BY [Birthday]"
Set rs = m_oConn.Execute(strsql)
If rs.RecordCount = 0 Then Exit Function
For i = 1 To rs.RecordCount
strDate = Month(rs("Birthday")) & "-" & Day(rs("Birthday"))
Select Case strDate
Case strThisDay
strThisAlertText = strThisAlertText & vbCrLf & vbTab & Field2Str(rs("Name")) & "," & Field2Str(rs("Tel"))
Case strNextDay
strNextAlertText = strNextAlertText & vbCrLf & vbTab & Field2Str(rs("Name")) & "," & Field2Str(rs("Tel"))
End Select
rs.MoveNext
Next
If Len(strThisAlertText) > 0 Then strThisAlertText = Format(dt, "yyyy-MM-dd") & "生日:" & strThisAlertText
If Len(strNextAlertText) > 0 Then strNextAlertText = Format(DateAdd("d", 1, dt), "yyyy-MM-dd") & "生日:" & strNextAlertText
GetBirthdayInfo = strThisAlertText
If Len(strThisAlertText) > 0 Then
GetBirthdayInfo = GetBirthdayInfo & vbCrLf & strNextAlertText
Else
GetBirthdayInfo = strNextAlertText
End If
End Function
请帮忙翻译下称c#的,看得累啊,谢谢了
lblTitle.Caption = Format(dt, "yyyy-MM-dd") & "生日提醒"
Dim strsql As String
Dim rs As ADODB.Recordset
Dim strThisAlertText As String
Dim strNextAlertText As String
Dim i As Long
Dim strDate As String
Dim strThisDay As String
Dim strNextDay As String
strThisDay = Month(dt) & "-" & Day(dt)
strNextDay = Month(DateAdd("d", 1, dt)) & "-" & Day(DateAdd("d", 1, dt))
strsql = "SELECT * FROM CUSTOMER " & _
"WHERE (NOT [Birthday] IS NULL) AND ((CStr(Month([Birthday]))+""-""+CStr(Day([Birthday]))) = '" & strThisDay & "'" & _
" OR (CStr(Month([Birthday]))+""-""+CStr(Day([Birthday]))) = '" & strNextDay & "') " & _
"ORDER BY [Birthday]"
Set rs = m_oConn.Execute(strsql)
If rs.RecordCount = 0 Then Exit Function
For i = 1 To rs.RecordCount
strDate = Month(rs("Birthday")) & "-" & Day(rs("Birthday"))
Select Case strDate
Case strThisDay
strThisAlertText = strThisAlertText & vbCrLf & vbTab & Field2Str(rs("Name")) & "," & Field2Str(rs("Tel"))
Case strNextDay
strNextAlertText = strNextAlertText & vbCrLf & vbTab & Field2Str(rs("Name")) & "," & Field2Str(rs("Tel"))
End Select
rs.MoveNext
Next
If Len(strThisAlertText) > 0 Then strThisAlertText = Format(dt, "yyyy-MM-dd") & "生日:" & strThisAlertText
If Len(strNextAlertText) > 0 Then strNextAlertText = Format(DateAdd("d", 1, dt), "yyyy-MM-dd") & "生日:" & strNextAlertText
GetBirthdayInfo = strThisAlertText
If Len(strThisAlertText) > 0 Then
GetBirthdayInfo = GetBirthdayInfo & vbCrLf & strNextAlertText
Else
GetBirthdayInfo = strNextAlertText
End If
End Function
请帮忙翻译下称c#的,看得累啊,谢谢了
...全文
相关推荐
音视频-直播技术-法国喜剧电影请你闭嘴中文配音版与字幕版翻译的对比分析.pdf
总的来说,本文通过对《请你闭嘴》的实例分析,揭示了音视频翻译中面临的挑战和解决方案,为电影翻译实践提供了理论指导。
unity英文说明文档,请使用浏览器自己翻译
unity英文说明文档,请使用浏览器自己翻译
translator-api:简单的Spring Boot Web API示例。 项目用例,一个简单的“翻译器应用程序”,用户可以在其中存储配对翻译(请参见下面的示例)并检索它们
项目用例,一个简单的“翻译器应用程序”,用户可以在其中存储配对翻译(请参见下面的示例)并检索它们。 作为用户,我希望能够存储多种语言组合的翻译。 S
cockpit-ostree-weblate:用于同步Weblate翻译的存储库。 如果您不是机器人,请忽略此存储库
用于驾驶舱ostree的Weblate帮助器存储库用于同步Weblate翻译的存储库。 如果您不是机器人,请忽略此存储库。我想翻译cockpit-ostree插件伟大的! 请在这样做我发现翻译错误您可
cockpit-composer-weblate:用于同步Weblate翻译的存储库。 如果您不是机器人,请忽略此存储库
Weblate辅助驾驶舱的帮助器存储库用于同步Weblate翻译的存储库。 如果您不是机器人,请忽略此存储库。我想翻译cockpit-composer插件伟大的! 请在这样做我发现翻译错误您可以直接在


