| | |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.Info13), u => u.Info13.Contains(input.Info13.Trim())) |
| | | .WhereIF(input.UpiFlag.HasValue, u => u.UpiFlag == input.UpiFlag) |
| | | .Select<Mes_Package_GatherOutput>(); |
| | | if(input.CreateTimeRange != null && input.CreateTimeRange.Count >0) |
| | | { |
| | | DateTime? start= input.CreateTimeRange[0].Value; |
| | | query = query.WhereIF(start.HasValue, u => u.CreateTime >= start); |
| | | if (input.CreateTimeRange.Count >1 && input.CreateTimeRange[1].HasValue) |
| | | { |
| | | var end = input.CreateTimeRange[1].Value; |
| | | query = query.Where(u => u.CreateTime <= end); |
| | | } |
| | | } |
| | | if(input.UpdateTimeRange != null && input.UpdateTimeRange.Count >0) |
| | | { |
| | | DateTime? start= input.UpdateTimeRange[0].Value; |
| | | query = query.WhereIF(start.HasValue, u => u.UpdateTime >= start); |
| | | if (input.UpdateTimeRange.Count >1 && input.UpdateTimeRange[1].HasValue) |
| | | { |
| | | var end = input.UpdateTimeRange[1].Value; |
| | | query = query.Where(u => u.UpdateTime <= end); |
| | | } |
| | | } |
| | | return query; |
| | | } |
| | | |