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

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

1. 判断两个起止时间是否相交：

public static bool istimebetween(timespan input, timespan start, timespan end, bool frominclusice, bool toinclusive) 
    { 
      //http://*.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为两个时间属性

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