Expression<Func<Operator, bool>> wh = c => c.DimissionId != null;
DateTime dtValueStart = DateTime.MinValue;
DateTime dtValueEnd = DateTime.MinValue;
if (!string.IsNullOrEmpty(startdate) && DateTime.TryParse(startdate, out dtValueStart))
{
//重置为当月第一天
dtValueStart = new DateTime(dtValueStart.Year, dtValueStart.Month, 1);
wh = wh.And(c => DbFunctions.TruncateTime(c.DimissionDate) >= DbFunctions.TruncateTime(dtValueStart));
}
if (!string.IsNullOrEmpty(enddate) && DateTime.TryParse(enddate, out dtValueEnd))
{
//重置为当月最后一天
dtValueEnd = new DateTime(dtValueEnd.Year, dtValueEnd.Month, 1).AddMonths(1).AddDays(-1);
wh = wh.And(c => DbFunctions.TruncateTime(c.DimissionDate) <= DbFuncti
EntityFramework Linq 按年月统计查询
最新推荐文章于 2024-04-13 21:02:41 发布