C# 判斷時間段是否相交的實現方法
1. 判斷兩個起止時間是否相交：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
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查詢：
|
1
2
3
4
5
6
7
8
9
10
11
|
public IMongoQuery GetMongoQueryIntersectWith<TCollection>( Expression<Func<TCollection, DateTime>> fromExp, Expression<Func<TCollection, DateTime>> toExp) { var rangeTo = Query.And(Query<TCollection>.GTE(toExp, To), Query<TCollection>.LTE(fromExp, To)); var rangeFrom = Query.And(Query<TCollection>.GTE(toExp, From), Query<TCollection>.LTE(fromExp, From)); var rangeQuery = Query.Or(rangeTo, rangeFrom, Query.And(Query<TCollection>.GTE(fromExp, From),Query<TCollection>.LTE(toExp, To))); return rangeQuery; } |
其中From和To為兩個時間屬性
如有疑問請留言或者到本站社區交流討論，感謝閱讀，希望能幫助到大家，謝謝大家對本站的支持！
原文鏈接：http://blog.csdn.net/lan_liang/article/details/44134425
