C# 判断时间段是否相交

来源：互联网发布：usb协议分析软件编辑：程序博客网时间：2024/05/20 08:24

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

0 0