C# 判断时间段是否相交的实现方法
1. 判断两个起止时间是否相交:
public static bool IsTimeBetween(TimeSpan input, TimeSpan start, TimeSpan end, bool fromInclusice, bool toInclusive)
{
//http://stackoverflow.com/questions/592248/how-can-i-check-if-the-current-time-is-between-in-a-time-frame
// see if start comes before end
if (end < start)
{
return
((toInclusive && (input <= end)) || (!toInclusive && (input < end)))
||
((fromInclusice && (input >= start)) || (!fromInclusice && (input > start)));
}
else
{
return
((fromInclusice && (input >= start)) || (!fromInclusice && (input > start)))
&&
((toInclusive && (input <= end)) || (!toInclusive && (input < end)));
}
}
2. 传入起止时间的表达式,判断与已知时间段的交集,生成Mongo查询:
public IMongoQuery GetMongoQueryIntersectWith( expression > fromExp, expression > toExp) { var rangeTo = Query.And(Query .GTE(toExp, To), Query .LTE(fromExp, To)); var rangeFrom = Query.And(Query .GTE(toExp, From), Query .LTE(fromExp, From)); var rangeQuery = Query.Or(rangeTo, rangeFrom, Query.And(Query .GTE(fromExp, From),Query .LTE(toExp, To))); return rangeQuery; }
其中From和To为两个时间属性
如有疑问请留言或者到本站社区交流讨论,感谢阅读,希望能帮助到大家,谢谢大家对本站的支持!



