C#实现工作日和休息日(包括法定节假日)的计算 | 您所在的位置:网站首页 › 法定工作日如何计算时间 › C#实现工作日和休息日(包括法定节假日)的计算 |
一、开发背景:
最近在公司开发的系统中,需要计算工作日,就是给出一个采购周期(n天),我需要计算出在n个工作日之后的日期。开始准备去调接口(ps:找了半天发现没有太合适的,还有吐槽下国家政府单位都没有官方接口的),但是负责这个项目的大佬说,万一别个的接口崩了,会影响我们自己的系统的正常运行,自己开发还是稳点,我就写了这个功能,特此记录下实现这个功能的思路。 二、定义:工作日想必大家都知道,就是除去周末和每年国务院颁布的节假日放假安排(例如:2017年部分节假日安排),其他就都是工作日(对了,差点忘记补班,这也算是工作日哦)。 三、实践:“废话”说的够多了,下面撸起袖子开干吧,代码都写了注释。 提供了两个公共方法,先给大家看下简单测试的运行结果: (1).根据传入的工作日天数,获得计算后的日期 (2).根据传入的时间,计算工作日天数; 具体代码: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 public class HolidayHelper { #region 字段属性 private static object _syncObj = new object (); private static HolidayHelper _instance { get ; set ; } private static List cacheDateList { get ; set ; } private HolidayHelper() { } /// /// 获得单例对象,使用懒汉式(双重锁定) /// /// public static HolidayHelper GetInstance() { if (_instance == null ) { lock (_syncObj) { if (_instance == null ) { _instance = new HolidayHelper(); } } } return _instance; } #endregion #region 私有方法 /// /// 读取文件 /// /// /// private string GetFileContent( string filePath) { string result = "" ; if (File.Exists(filePath)) { result = File.ReadAllText(filePath); } return result; } /// /// 获取配置的Json文件 /// /// 经过反序列化之后的对象集合 private List GetConfigList() { string path = string .Format( "{0}/../../Config/holidayConfig.json" , System.AppDomain.CurrentDomain.BaseDirectory); string fileContent = GetFileContent(path); if (! string .IsNullOrWhiteSpace(fileContent)) { cacheDateList = Newtonsoft.Json.JsonConvert.DeserializeObject(fileContent); } return cacheDateList; } /// /// 获取指定年份的数据 /// /// /// private DateModel GetConfigDataByYear( int year) { if (cacheDateList == null ) //取配置数据 GetConfigList(); DateModel result = cacheDateList.FirstOrDefault(m => m.Year == year); return result; } /// /// 判断是否为工作日 /// /// 要判断的时间 /// 当前的数据 /// private bool IsWorkDay(DateTime currDate, DateModel thisYearData) { if (currDate.Year != thisYearData.Year) //跨年重新读取数据 { thisYearData = GetConfigDataByYear(currDate.Year); } if (thisYearData.Year > 0) { string date = currDate.ToString( "MMdd" ); int week = ( int )currDate.DayOfWeek; if (thisYearData.Work.IndexOf(date) >= 0) { return true ; } if (thisYearData.Holiday.IndexOf(date) >= 0) { return false ; } if (week != 0 && week != 6) { return true ; } } return false ; } #endregion #region 公共方法 public void CleraCacheData() { if (cacheDateList != null ) { cacheDateList.Clear(); } } /// /// 根据传入的工作日天数,获得计算后的日期,可传负数 /// /// 天数 /// 当天是否算工作日(默认:true) /// public DateTime GetReckonDate( int day, bool isContainToday = true ) { DateTime currDate = DateTime.Now; int addDay = day >= 0 ? 1 : -1; if (isContainToday) currDate = currDate.AddDays(-addDay); DateModel thisYearData = GetConfigDataByYear(currDate.Year); if (thisYearData.Year > 0) { int sumDay = Math.Abs(day); int workDayNum = 0; while (workDayNum < sumDay) { currDate = currDate.AddDays(addDay); if (IsWorkDay(currDate, thisYearData)) workDayNum++; } } return currDate; } /// /// 根据传入的时间,计算工作日天数 /// /// 带计算的时间 /// 当天是否算工作日(默认:true) /// public int GetWorkDayNum(DateTime date, bool isContainToday = true ) { var currDate = DateTime.Now; int workDayNum = 0; int addDay = date.Date > currDate.Date ? 1 : -1; if (isContainToday) { currDate = currDate.AddDays(-addDay); } DateModel thisYearData = GetConfigDataByYear(currDate.Year); if (thisYearData.Year > 0) { bool isEnd = false ; do { currDate = currDate.AddDays(addDay); if (IsWorkDay(currDate, thisYearData)) workDayNum += addDay; isEnd = addDay > 0 ? (date.Date > currDate.Date) : (date.Date < currDate.Date); } while (isEnd); } return workDayNum; } #endregion } public struct DateModel { public int Year { get ; set ; } public List Work { get ; set ; } public List Holiday { get ; set ; } }说明下,法定节假日我是自己用json来配置的,大家可以自己维护,或者做成自己的接口。下面展示下json的格式,这是我自己配置的(2015-2017年),大家可以按照自己的需求来修改。 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 [ { "Year" : "2015" , "Work" : [ "0104" , "0215" , "0228" , "0906" , "1010" ], "Holiday" : [ "0101" , "0102" , "0103" , "0218" , "0219" , "0220" , "0221" , "0222" , "0223" , "0224" , "0404" , "0405" , "0406" , "0501" , "0502" , "0503" , "0620" , "0621" , "0622" , "0903" , "0904" , "0905" , "0927" , "1001" , "1002" , "1003" , "1004" , "1005" , "1006" , "1007" ] }, { "Year" : "2016" , "Work" : [ "0206" , "0214" , "0612" , "0918" , "1008" , "1009" ], "Holiday" : [ "0101" , "0207" , "0208" , "0209" , "0210" , "0211" , "0212" , "0213" , "0404" , "0501" , "0502" , "0609" , "0610" , "0611" , "0915" , "0916" , "0917" , "1001" , "1002" , "1003" , "1004" , "1005" , "1006" , "1007" ] }, { "Year" : "2017" , "Work" : [ "0122" , "0204" , "0401" , "0527" , "0930" ], "Holiday" : [ "0101" , "0102" , "0127" , "0128" , "0129" , "0130" , "0201" , "0202" , "0501" , "0529" , "0530" , "1001" , "1002" , "1003" , "1004" , "1005" , "1006" ] } ] holidayConfig.json |
CopyRight 2018-2019 实验室设备网 版权所有 |