blocks|key|1117589|text|只需将其更改为|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1117590|var+appointmentNoShow+=+from+a+in+appointments
++++++++++++++++++++++++from+p+in+properties
++++++++++++++++++++++++from+c+in+clients
++++++++++++++++++++++++where+a.Id+==+p.OID+&&+
+++++++++++++++++++++++(a.Start.Date+>=+startDate.Date+&&+a.Start.Date+<=+endDate)|code-block|syntax|javascript|1117591|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Just change it to

<pre><code>var appointmentNoShow = from a in appointments
 from p in properties
 from c in clients
 where a.Id == p.OID &amp;&amp; 
 (a.Start.Date &gt;= startDate.Date &amp;&amp; a.Start.Date &lt;= endDate)
</code></pre>

blocks|key|1332698|text|var+appointmentNoShow+=+from+a+in+appointments
++++++++++++++++++++++++from+p+in+properties
++++++++++++++++++++++++from+c+in+clients
++++++++++++++++++++++++where+a.Id+==+p.OID
++++++++++++++++++++++++where+a.Start.Date+>=+startDate.Date
++++++++++++++++++++++++where+a.Start.Date+<=+endDate.Date|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1332699|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>var appointmentNoShow = from a in appointments
 from p in properties
 from c in clients
 where a.Id == p.OID
 where a.Start.Date &gt;= startDate.Date
 where a.Start.Date &lt;= endDate.Date
</code></pre>

blocks|key|1332716|text|var+QueryNew+=+_context.Appointments.Include(x+=>+x.Employee).Include(x+=>+x.city).Where(x+=>+x.CreatedOn+>=+FromDate).Where(x+=>+x.CreatedOn+<=+ToDate).Where(x+=>+x.IsActive+==+true).ToList();|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1332717|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>var QueryNew = _context.Appointments.Include(x =&gt; x.Employee).Include(x =&gt; x.city).Where(x =&gt; x.CreatedOn &gt;= FromDate).Where(x =&gt; x.CreatedOn &lt;= ToDate).Where(x =&gt; x.IsActive == true).ToList();
</code></pre>

blocks|key|1117657|text|​|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1117658|+public+List<tbltask>+gettaskssdata(int?+c,+int?+userid,+string+a,+string+StartDate,+string+EndDate,+int?+ProjectID,+int?+statusid)
++++++++{
++++++++++++List<tbltask>+tbtask+=+new+List<tbltask>();
++++++++++++DateTime+sdate+=+(StartDate+!=+"")+?+Convert.ToDateTime(StartDate).Date+:+new+DateTime();
++++++++++++DateTime+edate+=+(EndDate+!=+"")+?+Convert.ToDateTime(EndDate).Date+:+new+DateTime();
++++++++++++tbtask+=+entity.tbltasks.Include(x+=>+x.tblproject).Include(x+=>+x.tbUser).
++++++++++++++++Where(x+=>+x.tblproject.company_id+==+c
++++++++++++++++++++&&+(ProjectID+==+0+%7C%7C+ProjectID+==+x.tblproject.ProjectId)
++++++++++++++++++++&&+(statusid+==+0+%7C%7C+statusid+==+x.tblstatu.StatusId)
++++++++++++++++++++&&+(a+==+""+%7C%7C+(x.TaskName.Contains(a)+%7C%7C+x.tbUser.User_name.Contains(a)))
++++++++++++++++++++&&+((StartDate+==+""+&&+EndDate+==+"")+%7C%7C+((x.StartDate+>=+sdate+&&+x.EndDate+<=+edate)))).ToList();



++++++++++++return+tbtask;


++++++++}|code-block|syntax|javascript|1117659|1117660|这是我基于搜索数据和开始到结束日期之间的搜索记录的查询|1117661|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|M|8|@]|9|@]|A|$E|F]]|$1|G|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|O|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|P|8|@]|9|@]|A|$]]]|K|$]]

<div class="snippet" data-lang="js" data-hide="false">
<div class="snippet-code">
<pre class="snippet-code-js lang-js prettyprint-override"><code> public List&lt;tbltask&gt; gettaskssdata(int? c, int? userid, string a, string StartDate, string EndDate, int? ProjectID, int? statusid)
 {
 List&lt;tbltask&gt; tbtask = new List&lt;tbltask&gt;();
 DateTime sdate = (StartDate != "") ? Convert.ToDateTime(StartDate).Date : new DateTime();
 DateTime edate = (EndDate != "") ? Convert.ToDateTime(EndDate).Date : new DateTime();
 tbtask = entity.tbltasks.Include(x =&gt; x.tblproject).Include(x =&gt; x.tbUser).
 Where(x =&gt; x.tblproject.company_id == c
 &amp;&amp; (ProjectID == 0 || ProjectID == x.tblproject.ProjectId)
 &amp;&amp; (statusid == 0 || statusid == x.tblstatu.StatusId)
 &amp;&amp; (a == "" || (x.TaskName.Contains(a) || x.tbUser.User_name.Contains(a)))
 &amp;&amp; ((StartDate == "" &amp;&amp; EndDate == "") || ((x.StartDate &gt;= sdate &amp;&amp; x.EndDate &lt;= edate)))).ToList();



 return tbtask;


 }</code></pre>
</div>
</div>


this my query for search records based on searchdata and between start to end date

blocks|key|1332842|text|所以你向下滚动是因为答案不起作用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1332843|这就像魔术一样工作(但他们说它对大数据有效率问题，而你并不像我一样关心)|1332844|1-在我的例子中，数据库中的数据类型是"datetime“和"nullable”。|1332845|DB中的数据格式示例如下：|1332846|2018-11-06+15:33:43.640|code-block|syntax|javascript|1332847|在C#中转换为字符串时如下所示：|1332848|2019-01-03+4:45:16+PM|1332849|所以格式是：|1332850|yyyy/MM/dd+hh:mm:ss+tt|1332851|2-所以你需要先准备好datetime变量的正确格式：|1332852|示例1|1332853|yourDate.ToString("yyyy/MM/dd+hh:mm:ss+tt")|1332854|示例2-过去30天的日期时间范围|1332855|++++DateTime+dateStart+=+DateTime.Now.AddDays(-30);
++++DateTime+dateEnd+=+DateTime.Now.AddDays(1).AddTicks(-1);|1332856|3-+-终于找到了你一天都没找到的linq查询(需要EF+6)|1332857|using+System.Data.Entity;

_dbContext.Shipments.Where(s+=>+(DbFunctions.TruncateTime(s.Created_at.Value)+>=+dateStart+&&+DbFunctions.TruncateTime(s.Created_at.Value)+<=+dateEnd)).Count();|1332858|要考虑时间比较，请执行以下操作：|1332859|(DbFunctions.CreateDateTime(s.Created_at.Value.Year,+s.Created_at.Value.Month,+s.Created_at.Value.Day,+s.Created_at.Value.Hour,+s.Created_at.Value.Minute,+s.Created_at.Value.Second)+>=+dateStart+&&+DbFunctions.CreateDateTime(s.Created_at.Value.Year,+s.Created_at.Value.Month,+s.Created_at.Value.Day,+s.Created_at.Value.Hour,+s.Created_at.Value.Minute,+s.Created_at.Value.Second)+<=+dateEnd)|1332860|注意:在其他堆栈溢出问题和答案中提到的以下方法将无法正常工作：|1332861|....
&&
(
++++s.Created_at.Value.Day+>=+dateStart.Day+&&+s.Created_at.Value.Day+<=+dateEnd.Day+&&
++++s.Created_at.Value.Month+>=+dateStart.Month+&&+s.Created_at.Value.Month+<=+dateEnd.Month+&&
++++s.Created_at.Value.Year+>=+dateStart.Year+&&+s.Created_at.Value.Year+<=+dateEnd.Year
)).count();|1332862|例如，如果开始日期在本月，结束日期在下个月，则查询将返回false且没有结果，例如：|1332863|DatabaseCreatedAtItemThatWeWant+=+2018/12/05|1332864|startDate+=+2018/12/01|1332865|EndDate+=+2019/01/04|1332866|查询将始终搜索01和04之间的天数，而不考虑“月”，因此"s.Created_at.Value.Day+<=+dateEnd.Day“将失败|1332867|如果您有真正的大数据，您将执行Native+SQL查询，而不是linq|1332868|...
++++...+where+Shipments.Created_at+BETWEEN+CAST(@Created_at_from+as+datetime)+AND+CAST(@Created_at_to+as+datetime))
++++....|1332869|谢谢|1332870|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1Z|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|20|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|21|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|22|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|23|8|@]|9|@]|A|$]]|$1|O|3|P|5|J|7|24|8|@]|9|@]|A|$K|L]]|$1|Q|3|R|5|6|7|25|8|@]|9|@]|A|$]]|$1|S|3|T|5|J|7|26|8|@]|9|@]|A|$K|L]]|$1|U|3|V|5|6|7|27|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|28|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|J|7|29|8|@]|9|@]|A|$K|L]]|$1|10|3|11|5|6|7|2A|8|@]|9|@]|A|$]]|$1|12|3|13|5|J|7|2B|8|@]|9|@]|A|$K|L]]|$1|14|3|15|5|6|7|2C|8|@]|9|@]|A|$]]|$1|16|3|17|5|J|7|2D|8|@]|9|@]|A|$K|L]]|$1|18|3|19|5|6|7|2E|8|@]|9|@]|A|$]]|$1|1A|3|1B|5|J|7|2F|8|@]|9|@]|A|$K|L]]|$1|1C|3|1D|5|6|7|2G|8|@]|9|@]|A|$]]|$1|1E|3|1F|5|J|7|2H|8|@]|9|@]|A|$K|L]]|$1|1G|3|1H|5|6|7|2I|8|@]|9|@]|A|$]]|$1|1I|3|1J|5|6|7|2J|8|@]|9|@]|A|$]]|$1|1K|3|1L|5|6|7|2K|8|@]|9|@]|A|$]]|$1|1M|3|1N|5|6|7|2L|8|@]|9|@]|A|$]]|$1|1O|3|1P|5|6|7|2M|8|@]|9|@]|A|$]]|$1|1Q|3|1R|5|6|7|2N|8|@]|9|@]|A|$]]|$1|1S|3|1T|5|J|7|2O|8|@]|9|@]|A|$K|L]]|$1|1U|3|1V|5|6|7|2P|8|@]|9|@]|A|$]]|$1|1W|3|-4|5|6|7|2Q|8|@]|9|@]|A|$]]]|1X|$]]

So you are scrolling down because the Answers do not work:

This works like magic (but they say it has efficiency issues for big data, And you do not care just like me)

1- Data Type in Database is "datetime" and "nullable" in my case.

Example data format in DB is like:

<pre><code>2018-11-06 15:33:43.640
</code></pre>

An in C# when converted to string is like:

<pre><code>2019-01-03 4:45:16 PM
</code></pre>

So the format is :

<pre><code>yyyy/MM/dd hh:mm:ss tt
</code></pre>

2- So you need to prepare your datetime variables in the proper format first:

Example 1

<pre><code>yourDate.ToString("yyyy/MM/dd hh:mm:ss tt")
</code></pre>

Example 2 - Datetime range for the last 30 days

<pre><code> DateTime dateStart = DateTime.Now.AddDays(-30);
 DateTime dateEnd = DateTime.Now.AddDays(1).AddTicks(-1);
</code></pre>

3- Finally the linq query you lost your day trying to find (Requires EF 6)

<pre><code>using System.Data.Entity;

_dbContext.Shipments.Where(s =&gt; (DbFunctions.TruncateTime(s.Created_at.Value) &gt;= dateStart &amp;&amp; DbFunctions.TruncateTime(s.Created_at.Value) &lt;= dateEnd)).Count();
</code></pre>

To take time comparison into account as well :

<pre><code>(DbFunctions.CreateDateTime(s.Created_at.Value.Year, s.Created_at.Value.Month, s.Created_at.Value.Day, s.Created_at.Value.Hour, s.Created_at.Value.Minute, s.Created_at.Value.Second) &gt;= dateStart &amp;&amp; DbFunctions.CreateDateTime(s.Created_at.Value.Year, s.Created_at.Value.Month, s.Created_at.Value.Day, s.Created_at.Value.Hour, s.Created_at.Value.Minute, s.Created_at.Value.Second) &lt;= dateEnd)
</code></pre>

Note the following method mentioned on other stackoverflow questions and answers will not work correctly:

<pre><code>....
&amp;&amp;
(
 s.Created_at.Value.Day &gt;= dateStart.Day &amp;&amp; s.Created_at.Value.Day &lt;= dateEnd.Day &amp;&amp;
 s.Created_at.Value.Month &gt;= dateStart.Month &amp;&amp; s.Created_at.Value.Month &lt;= dateEnd.Month &amp;&amp;
 s.Created_at.Value.Year &gt;= dateStart.Year &amp;&amp; s.Created_at.Value.Year &lt;= dateEnd.Year
)).count();
</code></pre>

if the start day was in this month for example and the end day is on the next month, the query will return false and no results, for example:

DatabaseCreatedAtItemThatWeWant = 2018/12/05

startDate = 2018/12/01

EndDate = 2019/01/04

the query will always search for days between 01 and 04 without taking the "month" into account, so "s.Created_at.Value.Day &lt;= dateEnd.Day" will fail 

And in case you have really big data you would execute Native SQL Query rather than linq

<pre><code>...
 ... where Shipments.Created_at BETWEEN CAST(@Created_at_from as datetime) AND CAST(@Created_at_to as datetime))
 ....
</code></pre>

Thanks

blocks|key|1332908|text|我有一个问题，使这个工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1332909|我在数据库行中有两个日期，我需要将它们添加到昨天、今天和明天的列表中。|1332910|这是我的解决方案：|1332911|++++++++var+yesterday+=+DateTime.Today.AddDays(-1);
++++++++var+today+=+DateTime.Today;
++++++++var+tomorrow+=+DateTime.Today.AddDays(1);++++++++++++
++++++++var+vm+=+new+Model()
++++++++{
++++++++++++Yesterday+=+_context.Table.Where(x+=>+x.From+<=+yesterday+&&+x.To+>=+yesterday).ToList(),
++++++++++++Today+=+_context.Table.Where(x+=>+x.From+<=+today+&+x.To+>=+today).ToList(),
++++++++++++Tomorrow+=+_context.Table.Where(x+=>+x.From+<=+tomorrow+&+x.To+>=+tomorrow).ToList()
++++++++};|code-block|syntax|javascript|1332912|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|O|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|P|8|@]|9|@]|A|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

I had a problem getting this to work.

I had two dates in a db line and I need to add them to a list for yesterday, today and tomorrow.

this is my solution:

<pre><code> var yesterday = DateTime.Today.AddDays(-1);
 var today = DateTime.Today;
 var tomorrow = DateTime.Today.AddDays(1); 
 var vm = new Model()
 {
 Yesterday = _context.Table.Where(x =&gt; x.From &lt;= yesterday &amp;&amp; x.To &gt;= yesterday).ToList(),
 Today = _context.Table.Where(x =&gt; x.From &lt;= today &amp; x.To &gt;= today).ToList(),
 Tomorrow = _context.Table.Where(x =&gt; x.From &lt;= tomorrow &amp; x.To &gt;= tomorrow).ToList()
 };
</code></pre>

blocks|key|1117856|text|如果有人想知道如何处理2个列表和两个日期之间|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1117857|var+newList+=+firstList.Where(s+=>+secondList.Any(secL+=>+s.Start+>+secL.RangeFrom+&&+s.End+<+secL.RangeTo))|code-block|syntax|javascript|1117858|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

If someone interested to know how to work with 2 list and between dates

<pre><code>var newList = firstList.Where(s =&gt; secondList.Any(secL =&gt; s.Start &gt; secL.RangeFrom &amp;&amp; s.End &lt; secL.RangeTo))
</code></pre>

blocks|key|1117912|text|如果您有日期间隔过滤条件，需要选择部分属于此过滤范围的所有记录。假设:记录具有ValidFrom和ValidTo属性。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1117913|DateTime+intervalDateFrom+=+new+DateTime(1990,+01,+01);
DateTime+intervalDateTo+=+new+DateTime(2000,+01,+01);

var+itemsFiltered+=+allItems.Where(x=>+
++++(x.ValidFrom+>=+intervalDateFrom+&&+x.ValidFrom+<=+intervalDateTo)+%7C%7C
++++(x.ValidTo+>=+intervalDateFrom+&&+x.ValidTo+<=+intervalDateTo)+%7C%7C
++++(intervalDateFrom+>=+x.ValidFrom+&&+intervalDateFrom+<=+x.ValidTo)+%7C%7C
++++(intervalDateTo+>=+x.ValidFrom+&&+intervalDateTo+<=+x.ValidTo)
);|code-block|syntax|javascript|1117914|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

If you have date interval filter condition and you need to select all records which falls partly into this filter range. Assumption: records has ValidFrom and ValidTo property.

<pre><code>DateTime intervalDateFrom = new DateTime(1990, 01, 01);
DateTime intervalDateTo = new DateTime(2000, 01, 01);

var itemsFiltered = allItems.Where(x=&gt; 
 (x.ValidFrom &gt;= intervalDateFrom &amp;&amp; x.ValidFrom &lt;= intervalDateTo) ||
 (x.ValidTo &gt;= intervalDateFrom &amp;&amp; x.ValidTo &lt;= intervalDateTo) ||
 (intervalDateFrom &gt;= x.ValidFrom &amp;&amp; intervalDateFrom &lt;= x.ValidTo) ||
 (intervalDateTo &gt;= x.ValidFrom &amp;&amp; intervalDateTo &lt;= x.ValidTo)
);
</code></pre>

I'm trying to get my linq statement to get me all records between two dates, and I'm not quite sure what I need to change to get it to work: <code>(a.Start &gt;= startDate &amp;&amp; endDate)</code>

<pre><code>var appointmentNoShow =
 from a in appointments
 from p in properties
 from c in clients
 where a.Id == p.OID &amp;&amp; (a.Start.Date &gt;= startDate.Date &amp;&amp; endDate)
</code></pre>

C# Linq Where Date Between 2 Dates

数据库

大数据

我试图让我的linq语句获得两个日期之间的所有记录，但我不太确定需要做哪些更改才能使其正常工作：(a.Start >= startDate && endDate)var appointmentNoShow =    from a in appointments    from p in properties    fr...

问C# Linq，其中日期在2个日期之间
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问C# Linq，其中日期在2个日期之间EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问C# Linq，其中日期在2个日期之间
EN