C#根据时间范围获取每月每周的分组
简介：C#根据时间范围获取每月每周的分组，这个时间范围可以是多年(2012.01.01-2015.12.31)，
也可以是一年中的几个月(2015.01.01-2015.12.31)，也可以是月个月中的几个星期
(2015.01.01-2015.01.21)，根据起始日期和结束日期，生成一个以起始日期和结束日期为
键值对的字典(Dictionary<string, string> )，时间仓促，初步写的算法，以后再优化，目前
唯一的一点小遗憾就是，月中每周键值对的排序问题。详细代码如下：
-------------------------------------------------------------------------------------------------------------------------
根据时间范围获取每月每周的分组：
/// <summary>
/// 根据时间范围获取每月每周的分组
/// </summary>
/// <param name="strStartDate">起始时间</param>
/// <param name="strEndDate">结束时间</param>
/// <returns>返回每周起始结束键值对</returns>
/// <remarks>创建人员(日期):★彭振★(150106 11:12)</remarks>
public static Dictionary<string, string> GetGroupWeekByDateRange(string strStartDate, string strEndDate)
{
Dictionary<string, string> dict = new Dictionary<string, string>();
DateTime dtStartDate = DateTime.Parse(strStartDate);
DateTime dtEndDate = DateTime.Parse(strEndDate);
//同年
if (dtStartDate.Year == dtEndDate.Year)
{
GetGroupWeekByYear(dict, dtStartDate, dtEndDate);
}
//不同年
else
{
int WhileCount = dtEndDate.Year - dtStartDate.Year;
//某年一共有多少天
int YearDay = DateTime.IsLeapYear(dtStartDate.Year) ? 366 : 365;
DateTime dtTempStartDate = dtStartDate;
DateTime dtTempEndDate = dtTempStartDate.AddDays(YearDay - dtTempStartDate.DayOfYear);
//根据时间范围获取每月每周的分组
GetGroupWeekByYear(dict, dtTempStartDate, dtTempEndDate);
for (int i = 1; i < (WhileCount + 1); i++)
{
//某年某月一共有多少天
YearDay = DateTime.IsLeapYear(dtTempStartDate.Year + 1) ? 366 : 365;
dtTempStartDate = DateTime.Parse(DateTime.Parse((dtTempStartDate.Year + 1) + "." + dtTempStartDate.Month + "." + "01").ToString("yyyy.MM.dd"));
dtTempEndDate = dtTempStartDate.AddDays(YearDay - dtTempStartDate.DayOfYear);
//根据时间范围获取每月每周的分组
GetGroupWeekByYear(dict, dtTempStartDate, dtTempEndDate);
}
}
return dict;
}
-------------------------------------------------------------------------------------------------------------------------
根据时间范围(年)获取每月每周的分组：
/// <summary>
/// 根据时间范围(年)获取每月每周的分组
/// </summary>
/// <param name="dict">每周起始结束键值对</param>
/// <param name="strStartDate">起始时间</param>
/// <param name="strEndDate">结束时间</param>
/// <remarks>创建人员(日期):★彭振★(150106 13:58)</remarks>
public static void GetGroupWeekByYear(Dictionary<string, string> dict, DateTime dtStartDate, DateTime dtEndDate)
{
//不同月
if ((dtEndDate.Month - dtStartDate.Month) >= 1)
{
int WhileCount = dtEndDate.Month - dtStartDate.Month;
//某年某月一共有多少天
int MonthDay = DateTime.DaysInMonth(dtStartDate.Year, dtStartDate.Month);
DateTime dtTempStartDate = dtStartDate;
DateTime dtTempEndDate = dtTempStartDate.AddDays(MonthDay - 1);
//根据时间范围获取每月每周的分组
GetGroupWeekByMonth(dict, dtTempStartDate, dtTempEndDate);
for (int i = 1; i < (WhileCount + 1); i++)
{
//某年某月一共有多少天
MonthDay = DateTime.DaysInMonth(dtTempStartDate.Year, dtTempStartDate.Month + 1);
dtTempStartDate = DateTime.Parse(DateTime.Parse(dtTempStartDate.Year + "." + (dtTempStartDate.Month + 1) + "." + "01").ToString("yyyy.MM.dd"));
dtTempEndDate = dtTempStartDate.AddDays(MonthDay - 1);
//根据时间范围获取每月每周的分组
GetGroupWeekByMonth(dict, dtTempStartDate, dtTempEndDate);
}
}
//同月
else
{
//根据时间范围获取每月每周的分组
GetGroupWeekByMonth(dict, dtStartDate, dtEndDate);
}
}
-------------------------------------------------------------------------------------------------------------------------
根据时间范围(月)获取每月每周的分组
/// <summary>
/// 根据时间范围(月)获取每月每周的分组
/// </summary>
/// <param name="dict">每周起始结束键值对</param>
/// <param name="strStartDate">起始时间</param>
/// <param name="strEndDate">结束时间</param>
/// <remarks>创建人员(日期):★彭振★(150106 11:13)</remarks>
public static void GetGroupWeekByMonth(Dictionary<string, string> dict, DateTime dtStartDate, DateTime dtEndDate)
{
//一周
if ((dtEndDate.Day - dtStartDate.Day) < 7)
{
DayOfWeek day = dtStartDate.DayOfWeek;
string dayString = day.ToString();
DateTime dtTempStartDate = dtStartDate;
DateTime dtTempEndDate = dtEndDate;
DateTime dtTempDate = DateTime.Now;
switch (dayString)
{
case "Monday":
dict.Add(dtTempStartDate.ToString(), dtTempEndDate.ToString());
break;
case "Tuesday":
dtTempDate = dtTempStartDate.Date.AddDays(+5);
break;
case "Wednesday":
dtTempDate = dtTempStartDate.Date.AddDays(+4);
break;
case "Thursday":
dtTempDate = dtTempStartDate.Date.AddDays(+3);
break;
case "Friday":
dtTempDate = dtTempStartDate.Date.AddDays(+2);
break;
case "Saturday":
dtTempDate = dtTempStartDate.Date.AddDays(+1);
break;
case "Sunday":
dtTempDate = dtTempStartDate;
break;
}
if (!dayString.Equals("Monday"))
{
dict.Add(dtTempStartDate.ToString(), dtTempDate.ToString());
dtTempDate = dtTempDate.Date.AddDays(+1);
if (DateTime.Compare(dtTempDate, dtEndDate) <= 0)
{
dict.Add(dtTempDate.ToString(), dtTempEndDate.ToString());
}
}
}
//多周
else
{
DayOfWeek day = dtStartDate.DayOfWeek;
string dayString = day.ToString();
DateTime dtTempStartDate = dtStartDate;
DateTime dtTempEndDate = dtEndDate;
DateTime dtTempDate = DateTime.Now;
#region 起始
switch (dayString)
{
case "Monday":
dtTempDate = dtTempStartDate.Date.AddDays(+6);
break;
case "Tuesday":
dtTempDate = dtTempStartDate.Date.AddDays(+5);
break;
case "Wednesday":
dtTempDate = dtTempStartDate.Date.AddDays(+4);
break;
case "Thursday":
dtTempDate = dtTempStartDate.Date.AddDays(+3);
break;
case "Friday":
dtTempDate = dtTempStartDate.Date.AddDays(+2);
break;
case "Saturday":
dtTempDate = dtTempStartDate.Date.AddDays(+1);
break;
case "Sunday":
dtTempDate = dtTempStartDate;
break;
}
dict.Add(dtTempStartDate.ToString(), dtTempDate.ToString());
dtTempStartDate = dtTempDate.Date.AddDays(+1);
#endregion
#region 结束
day = dtEndDate.DayOfWeek;
dayString = day.ToString();
switch (dayString)
{
case "Monday":
dtTempDate = dtEndDate;
break;
case "Tuesday":
dtTempDate = dtEndDate.Date.AddDays(-1);
break;
case "Wednesday":
dtTempDate = dtEndDate.Date.AddDays(-2);
break;
case "Thursday":
dtTempDate = dtEndDate.Date.AddDays(-3);
break;
case "Friday":
dtTempDate = dtEndDate.Date.AddDays(-4);
break;
case "Saturday":
dtTempDate = dtEndDate.Date.AddDays(-5);
break;
case "Sunday":
dtTempDate = dtEndDate.Date.AddDays(-6);
break;
}
dict.Add(dtTempDate.ToString(), dtEndDate.ToString());
dtTempEndDate = dtTempDate.Date.AddDays(-1);
#endregion
int WhileCount = ((dtTempEndDate.Day - dtTempStartDate.Day) / 7);
if (WhileCount == 0)
{
dict.Add(dtTempStartDate.ToString(), dtTempEndDate.ToString());
}
else
{
for (int i = 0; i < (WhileCount + 1); i++)
{
dtTempDate = dtTempStartDate.Date.AddDays(+6);
dict.Add(dtTempStartDate.ToString(), dtTempDate.ToString());
dtTempStartDate = dtTempDate.Date.AddDays(+1); ;
}
}
}
}
-------------------------------------------------------------------------------------------------------------------------
运用：
//根据时间范围获取每月每周的分组
Dictionary<string, string> dict = GetGroupWeekByDateRange("2012.01.01", "2015.12.31");
Dictionary<string, string> dict = GetGroupWeekByDateRange("2015.01.01", "2015.12.31");
Dictionary<string, string> dict = GetGroupWeekByDateRange("2015.01.01", "2015.01.21");