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

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

本文为大家分享了如何利用AOP实现SqlSugar自动事务，供大家参考。先看一下效果,带接口层的三层架构:BL层：public class StudentBL : IStudentService { ...