我有一段时间(例如,2014年4月6日11:30至2014年4月8日10:15),我有办公时间(例如星期一至星期五上午9:00至5:00)。
我需要计算受事故影响的开放时间(小数点)。
我可以想出一种方法,我可以做到这一点,但它似乎非常冗长和混乱,所以想看看是否有人能想出一些优雅的东西?
谢谢凯夫
发布于 2014-04-08 14:00:59
下面是一种使用LINQ的简短和可读的方法。请注意,它没有经过充分的测试,也没有效率。但也许这是有帮助的:
DateTime incidentStart = new DateTime(2014, 04, 06, 11, 30, 0, 0, 0);
DateTime incidentEnd = new DateTime(2014, 04, 08, 10, 15, 0, 0, 0);
int minutes = (int)(incidentEnd - incidentStart).TotalMinutes;
TimeSpan officeOpen = TimeSpan.FromHours(9);
TimeSpan officeClosed = TimeSpan.FromHours(17);
decimal numHours = Enumerable.Range(0, minutes)
.Select(min => incidentStart.AddMinutes(min))
.Where(dt => dt.DayOfWeek != DayOfWeek.Saturday && dt.DayOfWeek != DayOfWeek.Sunday
&& dt.TimeOfDay >= officeOpen && dt.TimeOfDay < officeClosed)
.GroupBy(dt => new DateTime(dt.Year, dt.Month, dt.Day, dt.Hour, 0, 0, 0)) // round to hour
.Count();结果是11,这似乎是正确的,不是吗?
发布于 2014-04-08 14:30:42
这个答案精确到最近的一秒钟。
DateTime startDate = new DateTime(2014, 04, 06, 11, 30, 0, 0, 0);
DateTime endDate = new DateTime(2014, 04, 08, 10, 15, 0, 0, 0);
TimeSpan StartOfDay = new TimeSpan(9, 0, 0);
TimeSpan EndOfDay = new TimeSpan(17, 0, 0);
int secondCount= 0;
while ((endDate - startDate).Minutes >= 0)
{
if (startDate.DayOfWeek >= DayOfWeek.Monday && startDate.DayOfWeek <= DayOfWeek.Friday)
if (startDate.TimeOfDay > StartOfDay && startDate.TimeOfDay <= EndOfDay)
secondCount++;
startDate = startDate.AddSeconds(1);
}
Console.WriteLine("Total Hours and Minutes: " + new TimeSpan(0, 0, secondCount));发布于 2014-04-08 14:09:50
非LINQ方法,也作为Tims的答案,没有测试.自担风险使用
var startDate = new DateTime(2014, 04, 06, 11, 30, 0, 0, 0);
var endDate = new DateTime(2014, 04, 08, 10, 15, 0, 0, 0);
var openStart = new DateTime(2014, 04, 08, 9, 0, 0);
var openEnd = new DateTime(2014, 04, 08, 17, 0, 0);;
var totalAffected = TimeSpan.Zero;
var checkDate = startDate;
while (checkDate < endDate)
{
if (IsWorkDay(checkDate))
{
totalAffected = totalAffected.Add(openEnd.TimeOfDay - openStart.TimeOfDay);
}
checkDate = checkDate.AddDays(1);
}
if (IsWorkDay(checkDate))
{
if (endDate.TimeOfDay > openEnd.TimeOfDay)
{
totalAffected = totalAffected.Add(openEnd.TimeOfDay - openStart.TimeOfDay);
}
else
{
totalAffected = totalAffected.Add(endDate.TimeOfDay - openStart.TimeOfDay);
}
}
double numberOfAffectedHours = totalAffected.TotalHours;
private bool IsWorkDay(DateTime day)
{
return !(day.DayOfWeek == DayOfWeek.Saturday || day.DayOfWeek == DayOfWeek.Sunday);
}https://stackoverflow.com/questions/22939055
复制相似问题