最近有个统计分布的需求,需要按统计本周,上周,本月,上月,本季度,上季度,本年度,上年度等时间统计分布趋势,所以这里就涉及到计算周,月,季度,年度等的起止时间了,下面总结一下C#中关于根据当前时间获取周,月,季度,年度等时间段的起止时间的方法,废话不多说,直接贴代码,如果你觉得有用,请多多推荐。
1 DateTime dt = DateTime.Now; //当前时间 2 DateTime startWeek = dt.AddDays(1 - Convert.ToInt32(dt.DayOfWeek.ToString("d"))); //本周周一 3 DateTime endWeek = startWeek.AddDays(6); //本周周日 4 5 DateTime startMonth = dt.AddDays(1 - dt.Day); //本月月初 6 DateTime endMonth = startMonth.AddMonths(1).AddDays(-1); //本月月末// 7 8 endMonth = startMonth.AddDays((dt.AddMonths(1) - dt).Days - 1); //本月月末 9 DateTime startQuarter = dt.AddMonths(0 - (dt.Month - 1) % 3).AddDays(1 - dt.Day); //本季度初 10 DateTime endQuarter = startQuarter.AddMonths(3).AddDays(-1); //本季度末 11 12 DateTime startYear = new DateTime(dt.Year, 1, 1); //本年年初 13 DateTime endYear = new DateTime(dt.Year, 12, 31); //本年年末至于昨天、明天、上周、上月、上季度、上年度等等, 14 15 var 上周一 = DateTime.Now.AddDays(Convert.ToInt32(1 - Convert.ToInt32(DateTime.Now.DayOfWeek)) - 7); //上周一 16 var 上周末 = DateTime.Now.AddDays(Convert.ToInt32(1 - Convert.ToInt32(DateTime.Now.DayOfWeek)) - 7).AddDays(6); //上周末(星期日)//下周 17 var 下周一 = DateTime.Now.AddDays(Convert.ToInt32(1 - Convert.ToInt32(DateTime.Now.DayOfWeek)) + 7); //下周一 18 var 下周末 = DateTime.Now.AddDays(Convert.ToInt32(1 - Convert.ToInt32(DateTime.Now.DayOfWeek)) + 7).AddDays(6); //下周末 19 20 DateTime.Parse(DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + "1").AddMonths(1).AddDays(-1).ToShortDateString();//最后一天 21 //巧用C#里ToString的字符格式化更简便 22 DateTime.Now.ToString("yyyy-MM-01");//本月初 23 DateTime.Parse(DateTime.Now.ToString("yyyy-MM-01")).AddMonths(1).AddDays(-1).ToShortDateString();//本月最后一天 24 DateTime.Parse(DateTime.Now.ToString("yyyy-MM-01")).AddMonths(-1).ToShortDateString();//上个月1号 25 DateTime.Parse(DateTime.Now.ToString("yyyy-MM-01")).AddDays(-1).ToShortDateString();//上个月最后一天 26 DateTime.Parse(DateTime.Now.ToString("yyyy-MM-01")).AddMonths(1).ToShortDateString();// 下个月1号 27 DateTime.Parse(DateTime.Now.ToString("yyyy-MM-01")).AddMonths(2).AddDays(-1).ToShortDateString();//下下月最后一天 28 DateTime.Now.AddDays(7).ToShortDateString();//7天后 29 DateTime.Now.AddDays(-7).ToShortDateString();//7天前 30 DateTime.Now.Date.ToShortDateString();//本年度,用ToString的字符格式化我们也很容易地算出本年度的第一天和最后一天 31 32 DateTime.Parse(DateTime.Now.ToString("yyyy-01-01")).ToShortDateString();//本年度第一天 33 DateTime.Parse(DateTime.Now.ToString("yyyy-01-01")).AddYears(1).AddDays(-1).ToShortDateString();//本年度最后一天 34 35 DateTime.Parse(DateTime.Now.ToString("yyyy-01-01")).AddYears(-1).ToShortDateString(); //上年度第一天, 36 DateTime.Parse(DateTime.Now.ToString("yyyy-01-01")).AddDays(-1).ToShortDateString();//上年度第最后一天, 37 38 DateTime.Parse(DateTime.Now.ToString("yyyy-01-01")).AddYears(1).ToShortDateString(); //下年度第一天 39 DateTime.Parse(DateTime.Now.ToString("yyyy-01-01")).AddYears(2).AddDays(-1).ToShortDateString();//下年度最后一天 40 //本季度, 41 DateTime.Now.AddMonths(0 - ((DateTime.Now.Month - 1) % 3)).AddDays(1 - DateTime.Now.Day);//本季度第一天; 42 DateTime.Parse(DateTime.Now.AddMonths(3 - ((DateTime.Now.Month - 1) % 3)).ToString("yyyy-MM-01")).AddDays(-1).ToShortDateString();//本季度的最后一天 43 DateTime.Now.AddMonths(3 - ((DateTime.Now.Month - 1) % 3)).ToString("yyyy-MM-01");//下季度的第一天 44 DateTime.Parse(DateTime.Now.AddMonths(6 - ((DateTime.Now.Month - 1) % 3)).ToString("yyyy-MM-01")).AddDays(-1).ToShortDateString();// 下季度最后一天 45 46 DateTime.Now.AddMonths(-3 - ((DateTime.Now.Month - 1) % 3)).AddDays(1 - DateTime.Now.Day);// 上季度第一天 47 DateTime.Now.AddMonths(0 - ((DateTime.Now.Month - 1) % 3)).AddDays(1 - DateTime.Now.Day).AddDays(-1).ToShortDateString();// 上季度最后一天
#region 获取 本周、本月、本季度、本年 的开始时间或结束时间 /// <summary> /// 获取结束时间 /// </summary> /// <param name="TimeType">Week、Month、Season、Year</param> /// <param name="now"></param> /// <returns></returns> public static DateTime? GetTimeStartByType(string TimeType, DateTime now) { switch (TimeType) { case "Week": return now.AddDays(-(int)now.DayOfWeek + 1); case "Month": return now.AddDays(-now.Day + 1); case "Season": var time = now.AddMonths(0 - ((now.Month - 1) % 3)); return time.AddDays(-time.Day + 1); case "Year": return now.AddDays(-now.DayOfYear + 1); default: return null; } } /// <summary> /// 获取结束时间 /// </summary> /// <param name="TimeType">Week、Month、Season、Year</param> /// <param name="now"></param> /// <returns></returns> public static DateTime? GetTimeEndByType(string TimeType, DateTime now) { switch (TimeType) { case "Week": return now.AddDays(7 - (int)now.DayOfWeek); case "Month": return now.AddMonths(1).AddDays(-now.AddMonths(1).Day + 1).AddDays(-1); case "Season": var time = now.AddMonths((3 - ((now.Month - 1) % 3) - 1)); return time.AddMonths(1).AddDays(-time.AddMonths(1).Day + 1).AddDays(-1); case "Year": var time2 = now.AddYears(1); return time2.AddDays(-time2.DayOfYear); default : return null; } } #endregion