-
时间段划分
网上找过很多给一个时间段划分的功能，但是都感觉不是特别全也不是特别好用，索性自己根据网上的资料参考自己写了一个。
可以根据星期、月份、季度、年划分时间段（是严格按照起止时间划分的，例如：开始时间 2020-12-31 结束时间 2021-3-5，按月份划分就是 2020年12月份、2021年1月份、2021年2月份、2021年3月份；季度和年也是如此，后续可以根据自己需要改动代码）。
废话少说，直接上代码
public static class DateSplitHelper { #region 根据周期类型获取时间段分组 杨福良 2021-4-15 10:25:12 /// <summary> /// 根据周期类型获取时间段分组 /// </summary> /// <param name="startDate"></param> /// <param name="endDate"></param> /// <param name="caredCycle"></param> /// <returns></returns> public static Dictionary<string, string> GetDates(DateTime startDate, DateTime endDate, int caredCycle) { Dictionary<string, string> dates = new Dictionary<string, string>(); if (caredCycle == 0) { dates = DateSplitHelper.GetGroupWeek(startDate.ToShortDateString(), endDate.ToShortDateString()); return dates; } if (caredCycle == 1) { dates = DateSplitHelper.GetGroupMonth(startDate.ToShortDateString(), endDate.ToShortDateString()); return dates; } if (caredCycle == 2) { dates = DateSplitHelper.GetGroupSeason(startDate.ToShortDateString(), endDate.ToShortDateString()); return dates; } if (caredCycle == 3) { dates = DateSplitHelper.GetGroupYear(startDate.ToShortDateString(), endDate.ToShortDateString()); return dates; } return dates; } #endregion #region 根据时间范围获取每周分组 杨福良 2021-4-14 21:49:46 /// <summary> /// 根据时间范围获取每周分组 /// </summary> /// <param name="strStartDate">起始时间</param> /// <param name="strEndDate">结束时间</param> /// <returns>返回每周起始结束键值对</returns> static DateTime LastDayOfMonth(DateTime datetime) { return datetime.AddDays(1 - datetime.Day).AddMonths(1).AddDays(-1); } #endregion #region 获取当前季度 杨福良 2021-4-25 18:02:44 /// <summary> /// 获取当前季度 /// </summary> /// <param name="date"></param> /// <returns></returns> public static string GetMonthSeason(this string date) { DateTime dt = Convert.ToDateTime(date); int month = dt.Month; if (month <= 3) { return $"{dt.Year}年1季度"; } if (month <= 6 && month >= 4) { return $"{dt.Year}年2季度"; } if (month <= 9 && month >= 7) { return $"{dt.Year}年3季度"; } return $"{dt.Year}年4季度"; } #endregion /// <summary> /// 日期转换 /// </summary> /// <param name="date"></param> /// <param name="caredCycle">统计周期 0 按周 1 按月 2 按季度 3 按年</param> /// <returns></returns> public static string DateTransform(string startDate, string endDate, int caredCycle) { StringBuilder strSql = new StringBuilder(); if (caredCycle == 0) { strSql.Append($@" '{startDate}-{endDate}'AS AreaSection, "); } if (caredCycle == 1) { strSql.Append($@" '{Convert.ToDateTime(startDate).GetDateTimeFormats('y')[0].ToString()}'AS AreaSection,"); } if (caredCycle == 2) { strSql.Append($@" '{startDate.GetMonthSeason()}'AS AreaSection,"); } if (caredCycle == 3) { strSql.Append($@" '{Convert.ToDateTime(startDate).Year}年'AS AreaSection,"); } return strSql.ToString(); } static Dictionary<string, string> GetGroupWeek(string strStartDate, string strEndDate) { DateTime dtStartDate = DateTime.Parse(strStartDate); DateTime dtEndDate = DateTime.Parse(strEndDate); Dictionary<string, string> dict = new Dictionary<string, string>(); bool ok = true; while (ok) { DayOfWeek day = dtStartDate.DayOfWeek; string dayString = day.ToString(); DateTime dtTempStartDate = dtStartDate; DateTime dtTempDate = DateTime.Now; 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; } if (dtTempDate > dtEndDate) { dict.Add(dtTempStartDate.ToString(), dtEndDate.ToString()); ok = false; continue; } dict.Add(dtTempStartDate.ToString(), dtTempDate.ToString()); dtStartDate = dtTempDate.Date.AddDays(+1); if (dtStartDate > dtEndDate) { ok = false; } } return dict; } static Dictionary<string, string> GetGroupMonth(string strStartDate, string strEndDate) { DateTime dtStartDate = DateTime.Parse(strStartDate); DateTime dtEndDate = DateTime.Parse(strEndDate); Dictionary<string, string> dict = new Dictionary<string, string>(); bool ok = true; while (ok) { DateTime dtTempStartDate = dtStartDate; DateTime dtTempDate = LastDayOfMonth(dtStartDate); if (dtTempDate > dtEndDate) { dtTempDate = dtEndDate; ok = false; } dict.Add(dtTempStartDate.ToString(), dtTempDate.ToString()); dtStartDate = dtTempDate.Date.AddDays(+1); if (dtStartDate > dtEndDate) ok = false; //if (dtTempDate > dtEndDate) //{ // dict.Add(dtTempStartDate.ToString(), dtEndDate.ToString()); // ok = false; // continue; //} //dict.Add(dtTempStartDate.ToString(), dtTempDate.ToString()); //dtStartDate = dtTempDate.Date.AddDays(+1); } return dict; } static Dictionary<string, string> GetGroupSeason(string strStartDate, string strEndDate) { DateTime dtStartDate = DateTime.Parse(strStartDate); DateTime dtEndDate = DateTime.Parse(strEndDate); DateTime dtTempStartDate = dtStartDate; DateTime dtTempDate = DateTime.Now; Dictionary<string, string> dict = new Dictionary<string, string>(); bool ok = true; while (ok) { int currentMonth = dtStartDate.Month; int currentSeason = currentMonth / 3 + (currentMonth % 3 > 0 ? 1 : 0); dtTempDate = DateTime.Parse(DateTime.Parse(dtStartDate.Year + "." + (currentSeason * 3) + "." + "01").ToString("yyyy.MM.dd")); dtTempDate = LastDayOfMonth(dtTempDate); if (dtTempDate > dtEndDate) { dtTempDate = dtEndDate; ok = false; } dict.Add(dtTempStartDate.ToString(), dtTempDate.ToString()); dtStartDate = dtTempDate.Date.AddDays(+1); if (dtStartDate > dtEndDate) { dtTempDate = dtEndDate; ok = false; } dtTempStartDate = dtTempDate.Date.AddDays(+1); } return dict; } static Dictionary<string, string> GetGroupYear(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) { dict.Add(dtStartDate.ToShortDateString(), new DateTime(dtStartDate.Year + 1, 1, 1).AddDays(-1).ToShortDateString()); return dict; } bool ok = true; while (ok) { DateTime dtTempStartDate = dtStartDate; DateTime dtTempDate = DateTime.Parse(DateTime.Parse(dtStartDate.Year + ".12." + "31").ToString("yyyy.MM.dd")); if (dtTempDate > dtEndDate) { dtTempDate = dtEndDate; ok = false; } dict.Add(dtTempStartDate.ToString(), dtTempDate.ToString()); dtStartDate = dtTempDate.Date.AddDays(+1); if (dtStartDate > dtEndDate) { dtTempDate = dtEndDate; ok = false; } } return dict; } }
大家有疑问的地方可以随时沟通，非常乐意哦~~~
出处：https://www.cnblogs.com/LittleCuteFive/p/15123024.html
栏目列表
最新更新
nodejs爬虫
Python正则表达式完全指南
爬取豆瓣Top250图书数据
shp 地图文件批量添加字段
爬虫小试牛刀（爬取学校通知公告）
【python基础】函数-初识函数
【python基础】函数-返回值
HTTP请求：requests模块基础使用必知必会
Python初学者友好丨详解参数传递类型
如何有效管理爬虫流量？
2个场景实例讲解GaussDB(DWS)基表统计信息估
常用的 SQL Server 关键字及其含义
动手分析SQL Server中的事务中使用的锁
openGauss内核分析：SQL by pass & 经典执行
一招教你如何高效批量导入与更新数据
天天写SQL，这些神奇的特性你知道吗？
openGauss内核分析：执行计划生成
[IM002]Navicat ODBC驱动器管理器 未发现数据
初入Sql Server 之 存储过程的简单使用
SQL Server -- 解决存储过程传入参数作为s
关于JS定时器的整理
JS中使用Promise.all控制所有的异步请求都完
js中字符串的方法
import-local执行流程与node模块路径解析流程
检测数据类型的四种方法
js中数组的方法,32种方法
前端操作方法
数据类型
window.localStorage.setItem 和 localStorage.setIte
如何完美解决前端数字计算精度丢失与数
