首页 > 编程 > C# > 正文

C# 判断时间段是否相交的实现方法

2020-01-24 00:26:38
字体:
来源:转载
供稿:网友

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<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为两个时间属性

如有疑问请留言或者到本站社区交流讨论,感谢阅读,希望能帮助到大家,谢谢大家对本站的支持!

发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表