Public Shared Sub ConvertDateToWeek(ByVal date As DateTime, ByRef firstdate As DateTime, ByRef lastdate As DateTime)
Dim first As DateTime = System.DateTime.Now
Dim last As DateTime = System.DateTime.Now
Select date.DayOfWeek
Case System.DayOfWeek.Monday
first = date
last = date.AddDays(6)
' break
Case System.DayOfWeek.Tuesday
first = date.AddDays(-1)
last = date.AddDays(5)
' break
Case System.DayOfWeek.Wednesday
first = date.AddDays(-2)
last = date.AddDays(4)
' break
Case System.DayOfWeek.Thursday
first = date.AddDays(-3)
last = date.AddDays(3)
' break
Case System.DayOfWeek.Friday
first = date.AddDays(-4)
last = date.AddDays(2)
' break
Case System.DayOfWeek.Saturday
first = date.AddDays(-5)
last = date.AddDays(1)
' break
Case System.DayOfWeek.Sunday
first = date.AddDays(-6)
last = date.AddDays(0)
' break
End Select
firstdate = first
lastdate = last
End Sub
'调用
Dim firstdate As DateTime = System.DateTime.Now
Dim lastdate As DateTime = System.DateTime.Now
Dim date As DateTime = System.DateTime.Now
ConvertDateToWeek(date, firstdate, lastdate)