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

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

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