String strFlag = radioGroupTime.EditValue.ToString(); //获取标识
switch (strFlag)
{
case "LastWeek":
dtStart = DateTime.Now.AddDays(1 - 7 - ((int)DateTime.Now.DayOfWeek == 0/*此处因为周末在我的系统内作为周的第一天,所以做了特殊处理*/ ? 7 : (int)DateTime.Now.DayOfWeek)).Date;
dtEnd = dtStart.AddDays(7).AddMilliseconds(-1);
break;
case "ThisWeek":
dtStart = DateTime.Now.AddDays(1 - ((int)DateTime.Now.DayOfWeek == 0 ? 7 : (int)DateTime.Now.DayOfWeek)).Date;
dtEnd = dtStart.AddDays(7).AddMilliseconds(-1);
break;
case "NextWeek":
dtStart = DateTime.Now.AddDays(1 + 7 - ((int)DateTime.Now.DayOfWeek == 0 ? 7 : (int)DateTime.Now.DayOfWeek)).Date;
dtEnd = dtStart.AddDays(7).AddMilliseconds(-1);
break;
case "LastMonth":
dtStart = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).AddMonths(-1);
dtEnd = dtStart.AddMonths(1).AddMilliseconds(-1);
break;
case "ThisMonth":
dtStart = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
dtEnd = dtStart.AddMonths(1).AddMilliseconds(-1);
break;
case "NextMonth":
dtStart = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).AddMonths(1);
dtEnd = dtStart.AddMonths(1).AddMilliseconds(-1);
break;
case "Custom":
dtStart = dateEditStart.DateTime.Date;
dtEnd = dateEditEnd.DateTime.Date.AddDays(1).AddMilliseconds(-1);
break;
default: break;
}
时间范围筛选与日期计算逻辑
本文详细介绍了如何通过选择不同时间范围(如上周、本周、下周一等)来获取相应的开始和结束日期,适用于系统中进行数据筛选或报告生成场景。

被折叠的 条评论
为什么被折叠?



