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