TimeHelper.cs 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612
  1. using DocumentFormat.OpenXml.Bibliography;
  2. using Microsoft.Azure.Amqp.Framing;
  3. using System;
  4. using System.Collections.Generic;
  5. using System.Linq;
  6. using System.Text;
  7. using System.Threading.Tasks;
  8. using TEAMModelOS.SDK.Models.Cosmos.BI;
  9. namespace TEAMModelOS.SDK.Models.Service.BI
  10. {
  11. public static class TimeHelper
  12. {
  13. /// <summary>
  14. /// 平年
  15. /// </summary>
  16. public static List<int> flatY = new() { 31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31 };
  17. /// <summary>
  18. /// 闰年
  19. /// </summary>
  20. public static List<int> leapY = new() { 31, 29, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31 };
  21. /// <summary>
  22. /// 将时间戳转换成时间
  23. /// </summary>
  24. /// <param name="dateS"></param>
  25. /// <param name="dateE"></param>
  26. /// <returns></returns>
  27. public static (DateTimeOffset timeS, DateTimeOffset timeE) GetLongToTime(long dateS,long dateE)
  28. {
  29. DateTimeOffset timeS = new(), timeE = new();
  30. if (dateS > 1000000000000)
  31. timeS = DateTimeOffset.FromUnixTimeMilliseconds(dateS);
  32. else
  33. timeS = DateTimeOffset.FromUnixTimeSeconds(dateS);
  34. if (dateE > 1000000000000)
  35. timeE = DateTimeOffset.FromUnixTimeMilliseconds(dateE);
  36. else
  37. timeE = DateTimeOffset.FromUnixTimeSeconds(dateE);
  38. return (timeS, timeE);
  39. }
  40. /// <summary>
  41. /// 通过时间戳转换为时间
  42. /// </summary>
  43. /// <param name="timeStamp"></param>
  44. /// <returns></returns>
  45. public static DateTimeOffset GetDateTime(long timeStamp)
  46. {
  47. long begtime = timeStamp * 10000;
  48. DateTimeOffset dt_1970 = new(1970, 1, 1, 0, 0, 0, TimeSpan.Zero);
  49. long tricks_1970 = dt_1970.Ticks;//1970年1月1日刻度
  50. long time_tricks = tricks_1970 + begtime;//日志日期刻度
  51. DateTimeOffset dt = new DateTime(time_tricks);//转化为DateTime
  52. return dt;
  53. }
  54. /// <summary>
  55. /// 通过string装换为时间并获取时间的年、月、日、一年第几天、小时
  56. /// </summary>
  57. /// <param name="time">时间,例如:2022060706</param>
  58. /// <param name="timeStrType">时间类型: 例如:yyyyMMddHH </param>
  59. /// <returns></returns>
  60. public static (int year, int month, int day, int days, int hour) GetDateTime(string time, string timeStrType = null)
  61. {
  62. string type = "yyyyMMddHH";
  63. if (!string.IsNullOrEmpty(timeStrType))
  64. {
  65. type = timeStrType;
  66. }
  67. int year = 0, month = 0, day = 0, days = 0, hour = 0;
  68. DateTimeOffset dateTime = new();
  69. dateTime = DateTime.ParseExact(time, type, System.Globalization.CultureInfo.CurrentCulture);
  70. year = dateTime.Year;
  71. month = dateTime.Month;
  72. day = dateTime.Day;
  73. DateTimeOffset dt1 = new DateTime(year, 1, 1);
  74. days = (dateTime.Date - dt1.Date).Days + 1;
  75. hour = dateTime.Hour;
  76. return (year, month, day, days, hour);
  77. }
  78. /// <summary>
  79. /// 获取月份的开始和结束时间戳 13位
  80. /// </summary>
  81. /// <param name="year"></param>
  82. /// <param name="month"></param>
  83. /// <returns></returns>
  84. public static (long start, long end) GetMonthStartEnd(int year, int month, bool dateLenth = true)
  85. {
  86. DateTimeOffset dtNew = new(year, month, 1, 0, 0, 0, TimeSpan.Zero);
  87. long start = DateTimeOffset.Parse($"{dtNew}").ToUnixTimeMilliseconds();
  88. if (dateLenth == false) start = DateTimeOffset.Parse($"{dtNew}").ToUnixTimeSeconds();
  89. var ste = dtNew.AddMonths(1).AddDays(-1).Day;
  90. long end = new DateTimeOffset(dtNew.Year, dtNew.Month, ste, 23, 59, 59, TimeSpan.Zero).ToUnixTimeMilliseconds();
  91. // DateTimeOffset.Parse($"{dt.Year}-{dt.Month}-{ste} 23:59:59").ToUnixTimeMilliseconds();
  92. if (dateLenth == false) end = new DateTimeOffset(dtNew.Year, dtNew.Month, dtNew.Day, 23, 59, 59, TimeSpan.Zero).ToUnixTimeSeconds();
  93. //DateTimeOffset.Parse($"{dt.Year}-{dt.Month}-{ste} 23:59:59").ToUnixTimeSeconds();
  94. return (start, end);
  95. }
  96. /// <summary>
  97. /// 通过时间获取当前年开始月份到现在月的开始时间到结束时间 现在月是当前天的结束时间
  98. /// </summary>
  99. /// <param name="date"></param>
  100. /// <param name="dateLenth"></param>
  101. /// <returns></returns>
  102. public static async Task<List<StartEndTime>> GetYearSataMthCtMth(DateTimeOffset date, bool dateLenth = true)
  103. {
  104. int year = date.Year;
  105. int mth = date.Month;
  106. int day = date.Day;
  107. List<StartEndTime> monthStartEnds = new();
  108. for (int i = 1; i <= mth; i++)
  109. {
  110. StartEndTime monthStartEnd = new() { date = $"{year}-{i}" };
  111. //DateTime dt = DateTime.Parse($"{year}-{i}");
  112. DateTimeOffset dtNew = new(year, i, 1, 0, 0, 0, TimeSpan.Zero);
  113. long start = dtNew.ToUnixTimeMilliseconds();
  114. if (dateLenth == false)
  115. start = DateTimeOffset.Parse($"{dtNew}").ToUnixTimeSeconds();
  116. monthStartEnd.start = start;
  117. long end = 0;
  118. if (i == mth)
  119. {
  120. end = DateTimeOffset.Parse($"{year}-{mth}-{day} 23:59:59").ToUnixTimeMilliseconds();
  121. if (dateLenth == false)
  122. end = DateTimeOffset.Parse($"{year}-{mth}-{day} 23:59:59").ToUnixTimeSeconds();
  123. }
  124. else
  125. {
  126. var ste = dtNew.AddMonths(1).AddDays(-1).Day;
  127. end = DateTimeOffset.Parse($"{dtNew.Year}-{dtNew.Month}-{ste} 23:59:59").ToUnixTimeMilliseconds();
  128. if (dateLenth == false)
  129. end = DateTimeOffset.Parse($"{dtNew.Year}-{dtNew.Month}-{ste} 23:59:59").ToUnixTimeSeconds();
  130. }
  131. monthStartEnd.end = end;
  132. monthStartEnds.Add(monthStartEnd);
  133. }
  134. return monthStartEnds;
  135. }
  136. /// <summary>
  137. /// 获取今年12个月的月份开始和结束时间戳 13位 10位
  138. /// </summary>
  139. /// <param name="year">年份</param>
  140. /// <param name="dateLenth">true :13位时间戳 false:10位时间戳</param>
  141. /// <returns></returns>
  142. public static List<StartEndTime> GetYearMonthlyStartEnd(int year, bool dateLenth = true)
  143. {
  144. List<StartEndTime> monthStartEnds = new();
  145. for (int i = 1; i <= 12; i++)
  146. {
  147. StartEndTime monthStartEnd = new() { date = $"{year}-{i}" };
  148. //DateTime dt = DateTime.Parse($"{year}-{i}");
  149. DateTimeOffset dtNew = new(year, i, 1, 0, 0, 0, TimeSpan.Zero);
  150. long start = dtNew.ToUnixTimeMilliseconds();
  151. if (dateLenth == false)
  152. start = dtNew.ToUnixTimeSeconds();
  153. monthStartEnd.start = start;
  154. var ste = dtNew.AddMonths(1).AddDays(-1).Day;
  155. long end = DateTimeOffset.Parse($"{dtNew.Year}-{dtNew.Month}-{ste} 23:59:59").ToUnixTimeMilliseconds();
  156. if (dateLenth == false)
  157. end = DateTimeOffset.Parse($"{dtNew.Year}-{dtNew.Month}-{ste} 23:59:59").ToUnixTimeSeconds();
  158. monthStartEnd.end = end;
  159. monthStartEnds.Add(monthStartEnd);
  160. }
  161. return monthStartEnds;
  162. }
  163. /// <summary>
  164. /// 获取过去12个月的每月开始和结束的时间戳
  165. /// </summary>
  166. /// <param name="yearMonth">日期</param>
  167. /// <param name="dateLenth">true :13位时间戳 false:10位时间戳</param>
  168. /// <returns></returns>
  169. public static List<StartEndTime> monthsOfYear(string yearMonth, bool dateLenth = true)
  170. {
  171. List<StartEndTime> monthStartEnds = new();
  172. DateTime dateTime = DateTime.Parse(yearMonth);
  173. int year = dateTime.Year;
  174. int month = dateTime.Month;
  175. List<string> months = new();
  176. while (year > dateTime.Year - 1 || month > dateTime.Month)
  177. {
  178. StartEndTime monthStartEnd = new() { date = $"{year}-{month}" };
  179. DateTimeOffset dtNew = new(year, month, 1, 0, 0, 0, TimeSpan.Zero);
  180. long start = dateLenth ? dtNew.ToUnixTimeMilliseconds() : dtNew.ToUnixTimeSeconds();
  181. monthStartEnd.start = start;
  182. var ste = dtNew.AddMonths(1).AddDays(-1).Day;
  183. long end = dateLenth ? DateTimeOffset.Parse($"{dateTime.Year}-{dateTime.Month}-{ste} 23:59:59").ToUnixTimeMilliseconds() : DateTimeOffset.Parse($"{dateTime.Year}-{dateTime.Month}-{ste} 23:59:59").ToUnixTimeSeconds();
  184. monthStartEnd.end = end;
  185. monthStartEnds.Add(monthStartEnd);
  186. months.Add($"{year}-{(month < 10 ? "0" : "") + month}");
  187. month -= 1;
  188. if (month <= 0)
  189. {
  190. year -= 1;
  191. month = 12;
  192. }
  193. }
  194. return monthStartEnds;
  195. }
  196. /// <summary>
  197. /// 获取传过来的时间学期的开始时间戳和结束时间
  198. /// </summary>
  199. /// <param name="dateTime">日期</param>
  200. /// <param name="dateLenth">true :13位时间戳 false:10位时间戳 </param>
  201. /// <returns></returns>
  202. public static (long start, long end) GetTermStartOrEnd(DateTimeOffset dateTime, bool dateLenth = true)
  203. {
  204. long start = 0;
  205. long end = 0;
  206. //DateTime dateTime = tempDateTime;
  207. int year = dateTime.Year;
  208. int month = dateTime.Month;
  209. if (month <= 8 && month >= 3)
  210. {
  211. DateTimeOffset newStart = new(year, 3, 1, 0, 0, 0, TimeSpan.Zero);
  212. start = dateLenth ? DateTimeOffset.Parse($"{newStart}").ToUnixTimeMilliseconds() : DateTimeOffset.Parse($"{newStart}").ToUnixTimeSeconds();
  213. DateTimeOffset newEnd = new(year, 8, 31, 23, 59, 59, TimeSpan.Zero);
  214. end = dateLenth ? DateTimeOffset.Parse($"{newEnd}").ToUnixTimeMilliseconds() : DateTimeOffset.Parse($"{newEnd}").ToUnixTimeSeconds();
  215. }
  216. else
  217. {
  218. //计算当前月份
  219. int days = 0;
  220. if (month >= 9)
  221. {
  222. DateTimeOffset newStart = new(dateTime.Year, 9, 1, 0, 0, 0, TimeSpan.Zero);
  223. start = dateLenth ? newStart.ToUnixTimeMilliseconds() : newStart.ToUnixTimeSeconds();
  224. DateTimeOffset newEnd = new(dateTime.Year + 1, 2, (year % 4 == 0 && year % 100 != 0 || year % 400 == 0) ? days = 29 : days = 28, 23, 59, 59, TimeSpan.Zero);
  225. end = dateLenth ? newEnd.ToUnixTimeMilliseconds() : newEnd.ToUnixTimeSeconds();
  226. }
  227. else
  228. {
  229. DateTimeOffset newStart = new(dateTime.Year - 1, 9, 1, 0, 0, 0, TimeSpan.Zero);
  230. start = dateLenth ? newStart.ToUnixTimeMilliseconds() : newStart.ToUnixTimeSeconds();
  231. DateTimeOffset newEnd = new(dateTime.Year, 2, (year % 4 == 0 && year % 100 != 0 || year % 400 == 0) ? days = 29 : days = 28, 23, 59, 59, TimeSpan.Zero);
  232. end = dateLenth ? newEnd.ToUnixTimeMilliseconds() : newEnd.ToUnixTimeSeconds();
  233. }
  234. }
  235. return (start, end);
  236. }
  237. /// <summary>
  238. /// 开始时间和结束时间戳
  239. /// </summary>
  240. /// <param name="dateTime"></param>
  241. /// <param name="type"></param>
  242. /// <param name="dateLenth"></param>
  243. /// <returns></returns>
  244. public static (long start, long end) GetStartOrEnd(DateTimeOffset dateTime, string type = "", bool dateLenth = true)
  245. {
  246. try
  247. {
  248. long start = 0;
  249. long end = 0;
  250. int year = dateTime.Year;
  251. int month = dateTime.Month;
  252. int day = dateTime.Day;
  253. int hour = dateTime.Hour;
  254. DateTimeOffset tempStrart = new();
  255. DateTimeOffset tempEnd = new();
  256. switch (type)
  257. {
  258. //今年开始、结束
  259. case "yearMonth":
  260. tempStrart = new DateTimeOffset(year, 1, 1, 0, 0, 0, TimeSpan.Zero);
  261. tempEnd = new DateTimeOffset(year, month, DateTime.DaysInMonth(year, month), 23, 59, 59, TimeSpan.Zero);
  262. break;
  263. //今年开始、结束
  264. case "year":
  265. tempStrart = new DateTimeOffset(year, 1, 1, 0, 0, 0, TimeSpan.Zero);
  266. tempEnd = new DateTimeOffset(year, 12, DateTime.DaysInMonth(year, 12), 23, 59, 59, TimeSpan.Zero);
  267. break;
  268. //去年开始、结束
  269. case "lastYear":
  270. tempStrart = new DateTimeOffset(year - 1, 1, 1, 0, 0, 0, TimeSpan.Zero);
  271. tempEnd = new DateTimeOffset(year - 1, 12, DateTime.DaysInMonth(year, 12), 23, 59, 59, TimeSpan.Zero);
  272. break;
  273. //本学期
  274. case "term":
  275. if (month <= 8 && month >= 3)
  276. {
  277. tempStrart = new DateTimeOffset(year, 3, 1, 0, 0, 0, TimeSpan.Zero);
  278. tempEnd = new DateTimeOffset(year, 8, 31, 23, 59, 59, TimeSpan.Zero);
  279. }
  280. else
  281. {
  282. //计算当前月份
  283. int days = 0;
  284. if (month >= 9)
  285. {
  286. tempStrart = new DateTimeOffset(year, 9, 1, 0, 0, 0, TimeSpan.Zero);
  287. tempEnd = new DateTimeOffset(year + 1, 2, (year % 4 == 0 && year % 100 != 0 || year % 400 == 0) ? days = 29 : days = 28, 23, 59, 59, TimeSpan.Zero);
  288. }
  289. else
  290. {
  291. tempStrart = new DateTimeOffset(year - 1, 9, 1, 0, 0, 0, TimeSpan.Zero);
  292. tempEnd = new DateTimeOffset(year, 2, (year % 4 == 0 && year % 100 != 0 || year % 400 == 0) ? days = 29 : days = 28, 23, 59, 59, TimeSpan.Zero);
  293. }
  294. }
  295. break;
  296. //上学期
  297. case "lastterm":
  298. DateTimeOffset tempDate = new();
  299. if (dateTime.Month > 9)
  300. tempDate = new DateTimeOffset(year, dateTime.Month - 4, 1, 0, 0, 0, TimeSpan.Zero);
  301. else tempDate = new DateTimeOffset(year - 1, 9, 1, 0, 0, 0, TimeSpan.Zero);
  302. if (!string.IsNullOrEmpty($"{tempDate}"))
  303. {
  304. year = tempDate.Year;
  305. month = tempDate.Month;
  306. if (month <= 8 && month >= 3)
  307. {
  308. tempStrart = new DateTimeOffset(year, 3, 1, 0, 0, 0, TimeSpan.Zero);
  309. tempEnd = new DateTimeOffset(year, 8, 31, 23, 59, 59, TimeSpan.Zero);
  310. }
  311. else
  312. {
  313. //计算当前月份
  314. int days = 0;
  315. if (month >= 9)
  316. {
  317. tempStrart = new DateTimeOffset(year, 9, 1, 0, 0, 0, TimeSpan.Zero);
  318. tempEnd = new DateTimeOffset(year + 1, 2, (year % 4 == 0 && year % 100 != 0 || year % 400 == 0) ? days = 29 : days = 28, 23, 59, 59, TimeSpan.Zero);
  319. }
  320. else
  321. {
  322. tempStrart = new DateTimeOffset(year - 1, 9, 1, 0, 0, 0, TimeSpan.Zero);
  323. tempEnd = new DateTimeOffset(year, 2, (year % 4 == 0 && year % 100 != 0 || year % 400 == 0) ? days = 29 : days = 28, 23, 59, 59, TimeSpan.Zero);
  324. }
  325. }
  326. }
  327. break;
  328. //上个月
  329. case "lastMonth":
  330. if (month == 1)
  331. {
  332. year--;
  333. month = 12;
  334. }
  335. else
  336. {
  337. month--;
  338. }
  339. tempStrart = new DateTimeOffset(year, month, 1, 0, 0, 0, TimeSpan.Zero);
  340. tempEnd = new DateTimeOffset(year, month, DateTime.DaysInMonth(year, month), 23, 59, 59, TimeSpan.Zero);
  341. break;
  342. //本月1号至当天
  343. case "monthDay":
  344. tempStrart = new DateTimeOffset(year, month, 1, 0, 0, 0, TimeSpan.Zero);
  345. tempEnd = new DateTimeOffset(year, month, day, 23, 59, 59, TimeSpan.Zero);
  346. break;
  347. //本月
  348. case "month":
  349. tempStrart = new DateTimeOffset(year, month, 1, 0, 0, 0, TimeSpan.Zero);
  350. tempEnd = new DateTimeOffset(year, month, DateTime.DaysInMonth(year, month), 23, 59, 59, TimeSpan.Zero);
  351. break;
  352. //上周
  353. case "week":
  354. DateTimeOffset weekStrart = dateTime.AddDays(-(int)(dateTime.DayOfWeek) + 1);
  355. DateTimeOffset weekEnd = dateTime.AddDays(7 - (int)(dateTime.DayOfWeek));
  356. tempStrart = new DateTimeOffset(weekStrart.Year, weekStrart.Month, weekStrart.Day, 0, 0, 0, TimeSpan.Zero);
  357. tempEnd = new DateTimeOffset(weekEnd.Year, weekEnd.Month, weekEnd.Day, 23, 59, 59, TimeSpan.Zero);
  358. break;
  359. //上周
  360. case "lastweek":
  361. var m = (dateTime.DayOfWeek == DayOfWeek.Sunday ? (DayOfWeek)7 : dateTime.DayOfWeek) - DayOfWeek.Monday;
  362. var s = (dateTime.DayOfWeek == DayOfWeek.Sunday ? (DayOfWeek)7 : dateTime.DayOfWeek) - (DayOfWeek)7;
  363. var Mon = dateTime.AddDays((-7 - m));//星期一
  364. var Sun = dateTime.AddDays((-7 - s)); //星期日
  365. tempStrart = new DateTimeOffset(Mon.Year, Mon.Month, Mon.Day, 0, 0, 0, TimeSpan.Zero);
  366. tempEnd = new DateTimeOffset(Sun.Year, Sun.Month, Sun.Day, 23, 59, 59, TimeSpan.Zero);
  367. break;
  368. //当前小时
  369. case "hour":
  370. tempStrart = new DateTimeOffset(year, month, day, hour, 0, 0, TimeSpan.Zero);
  371. tempEnd = new DateTimeOffset(year, month, day, hour, 59, 59, TimeSpan.Zero);
  372. break;
  373. //当天
  374. default:
  375. tempStrart = new DateTimeOffset(year, month, day, 0, 0, 0, TimeSpan.Zero);
  376. tempEnd = new DateTimeOffset(year, month, day, 23, 59, 59, TimeSpan.Zero);
  377. //start = dateLenth ? DateTimeOffset.Parse($"{dayStart}").ToUnixTimeMilliseconds() : DateTimeOffset.Parse($"{dayStart}").ToUnixTimeSeconds();
  378. //end = dateLenth ? DateTimeOffset.Parse($"{dayEnd}").ToUnixTimeMilliseconds() : DateTimeOffset.Parse($"{dayEnd}").ToUnixTimeSeconds();
  379. break;
  380. }
  381. start = dateLenth ? tempStrart.ToUnixTimeMilliseconds() : tempStrart.ToUnixTimeSeconds();
  382. end = dateLenth ? tempEnd.ToUnixTimeMilliseconds() : tempEnd.ToUnixTimeSeconds();
  383. return (start, end);
  384. }
  385. catch (Exception ex)
  386. {
  387. throw;
  388. }
  389. }
  390. /// <summary>
  391. /// 计算每年获取开始时间
  392. /// </summary>
  393. /// <param name="dateTime"></param>
  394. /// <param name="dateLenth"></param>
  395. /// <returns></returns>
  396. public static List<StartEndTime> GetYearEveryDay(DateTimeOffset dateTime, bool dateLenth = true,bool isCurrDay = false)
  397. {
  398. List<StartEndTime> dayStartEen = new();
  399. int year = dateTime.Year;
  400. int curry = dateTime.DayOfYear;
  401. List<int> isLeapYear = (year % 4 == 0 && year % 100 != 0 || year % 400 == 0) ? isLeapYear = leapY : isLeapYear = flatY;
  402. for (int m = 1; m <= 12; m++)
  403. {
  404. for (int d = 1; d <= isLeapYear[m - 1]; d++)
  405. {
  406. if (isCurrDay == true && (curry <= dayStartEen.Count))
  407. break;
  408. DateTimeOffset tempStrart = new(year, m, d, 0, 0, 0, TimeSpan.Zero);
  409. DateTimeOffset tempEnd = new(year, m, d, 23, 59, 59, TimeSpan.Zero);
  410. long longStart = dateLenth ? tempStrart.ToUnixTimeMilliseconds() : tempStrart.ToUnixTimeSeconds();
  411. long longEnd = dateLenth ? tempEnd.ToUnixTimeMilliseconds() : tempEnd.ToUnixTimeSeconds();
  412. dayStartEen.Add(new StartEndTime() { date = $"{year}-{m}-{d}", start = longStart, end = longEnd });
  413. }
  414. ////DateTime 有方法
  415. //DateTime monthStart = new DateTime(year, i, 01);
  416. //DateTime monthEnd = dateTime.AddMonths(1);
  417. //DateTimeOffset tempStrart = new DateTimeOffset(year, i, days, 0, 0, 0, TimeSpan.Zero);
  418. //DateTimeOffset tempEnd = new DateTimeOffset(year, i, days, 23, 59, 59, TimeSpan.Zero);
  419. }
  420. return dayStartEen;
  421. }
  422. /// <summary>
  423. /// 将时间戳格式 转换成string类型
  424. /// 例:yyyyMMdd,等string类型
  425. /// </summary>
  426. /// <param name="unixTime"></param>
  427. /// <returns></returns>
  428. public static (string timeStart, string timeEnd) GetUnixToDate(long start, long end = 0, string types = "yyyyMMdd")
  429. {
  430. string tStart = "";
  431. string tEnd = "";
  432. DateTimeOffset time = System.TimeZone.CurrentTimeZone.ToLocalTime(new DateTime(1970, 1, 1, 0, 0, 0, 0));
  433. tStart = time.AddMilliseconds(start).ToString($"{types}");
  434. if (end > 0)
  435. {
  436. tEnd = time.AddMilliseconds(end).ToString($"{types}");
  437. }
  438. return (tStart, tEnd);
  439. }
  440. /// <summary>
  441. /// 获取每天的时间
  442. /// </summary>
  443. /// <param name="dateTime">时间</param>
  444. /// <param name="dayNumber">最近几天</param>
  445. /// <returns></returns>
  446. public static List<string> GetNearDay(DateTimeOffset dateTime, int dayNumber)
  447. {
  448. List<string> days = new();
  449. days = Enumerable.Range(1, dayNumber).Select(i => dateTime.Date.AddDays(-i).ToString("yyyyMMdd")).ToList();
  450. return days;
  451. }
  452. /// <summary>
  453. /// 12个月 单个list<double>
  454. /// </summary>
  455. /// <param name="doubles"></param>
  456. /// <param name="year"></param>
  457. /// <param name="month"></param>
  458. /// <returns></returns>
  459. public static List<YearMonth> GetYearMonth(List<double> doubles, int year = 0, int month = 0)
  460. {
  461. List<YearMonth> months = new();
  462. if (doubles.Count > 0)
  463. {
  464. DateTimeOffset dateTime = DateTimeOffset.Now;
  465. if (year == 0)
  466. year = dateTime.Year;
  467. if (month == 0)
  468. month = dateTime.Month;
  469. List<int> isLeapYear = (year % 4 == 0 && year % 100 != 0 || year % 400 == 0) ? isLeapYear = leapY : isLeapYear = flatY;
  470. double[] array = doubles.ToArray();
  471. double ser = doubles.Sum();
  472. int moth = 1;
  473. int primaryD = 0;
  474. for (int i = 0; i < isLeapYear.Count; i++)
  475. {
  476. if (month < moth)
  477. break;
  478. double[] temp = new double[isLeapYear[i]];
  479. Array.ConstrainedCopy(array, primaryD, temp, 0, isLeapYear[i]);
  480. months.Add(new YearMonth() { id = $"{year}-{moth}", cnt = temp.Sum() });
  481. moth += 1;
  482. primaryD += isLeapYear[i];
  483. }
  484. }
  485. return months;
  486. }
  487. /// <summary>
  488. /// 12个月 多个list<double>
  489. /// </summary>
  490. /// <param name="listDoubles"></param>
  491. /// <param name="year"></param>
  492. /// <param name="month"></param>
  493. /// <returns></returns>
  494. public static List<YearMonth> GetYearMonths(List<List<double>> listDoubles, int year = 0, int month = 0)
  495. {
  496. List<YearMonth> months = new();
  497. foreach (var doubles in listDoubles)
  498. {
  499. if (doubles.Count > 0)
  500. {
  501. DateTimeOffset dateTime = DateTimeOffset.Now;
  502. if (year == 0)
  503. year = dateTime.Year;
  504. if (month == 0)
  505. month = dateTime.Month;
  506. List<int> isLeapYear = (year % 4 == 0 && year % 100 != 0 || year % 400 == 0) ? isLeapYear = leapY : isLeapYear = flatY;
  507. double[] array = doubles.ToArray();
  508. double ser = doubles.Sum();
  509. int moth = 1;
  510. int primaryD = 0;
  511. for (int i = 0; i < isLeapYear.Count; i++)
  512. {
  513. if (month < moth)
  514. break;
  515. double[] temp = new double[isLeapYear[i]];
  516. Array.ConstrainedCopy(array, primaryD, temp, 0, isLeapYear[i]);
  517. months.Add(new YearMonth() { id = $"{year}-{moth}", cnt = temp.Sum() });
  518. moth += 1;
  519. primaryD += isLeapYear[i];
  520. }
  521. }
  522. }
  523. return months;
  524. }
  525. /// <summary>
  526. /// 依据时间判定当月多少天
  527. /// </summary>
  528. /// <param name="dateTime"></param>
  529. /// <returns></returns>
  530. public static int GetDateDay(DateTimeOffset dateTime)
  531. {
  532. int day = 0;
  533. int month = dateTime.Month;
  534. int year = dateTime.Year;
  535. switch (month)
  536. {
  537. case 1:
  538. case 3:
  539. case 5:
  540. case 7:
  541. case 8:
  542. case 10:
  543. case 12:
  544. day = 31;
  545. break;
  546. case 4:
  547. case 6:
  548. case 9:
  549. case 11:
  550. day = 30;
  551. break;
  552. case 2:
  553. if (year % 400 == 0 || (year % 100 != 0 && year % 4 == 0))
  554. day = 29;
  555. else
  556. day = 28;
  557. break;
  558. }
  559. return day;
  560. }
  561. }
  562. }