| | |
| | | string returnToMESStatus = returnToMESStatusParam.Value.ToString().Trim(); |
| | | sugarQueryable1 = sugarQueryable1.Where(x => x.ReturnToMESStatus.Equals(returnToMESStatus)); |
| | | } |
| | | |
| | | var createDateParams = searchParametersList |
| | | .Where(x => x.Name.Equals("createDate", StringComparison.OrdinalIgnoreCase) |
| | | && !string.IsNullOrEmpty(x.Value?.ToString())) |
| | | .ToList(); |
| | | |
| | | DateTime? minCreateDate = null; |
| | | DateTime? maxCreateDate = null; |
| | | |
| | | foreach (var dateParam in createDateParams) |
| | | { |
| | | if (DateTime.TryParse(dateParam.Value.ToString(), out DateTime dateValue)) |
| | | { |
| | | LinqExpressionType expressionType = dateParam.DisplayType.GetLinqCondition(); |
| | | switch (expressionType) |
| | | { |
| | | case LinqExpressionType.ThanOrEqual: |
| | | minCreateDate = dateValue; |
| | | break; |
| | | case LinqExpressionType.LessThanOrEqual: |
| | | maxCreateDate = dateValue; |
| | | break; |
| | | } |
| | | } |
| | | } |
| | | |
| | | if (minCreateDate.HasValue) |
| | | { |
| | | sugarQueryable1 = sugarQueryable1.Where(x => x.CreateDate >= minCreateDate.Value); |
| | | } |
| | | if (maxCreateDate.HasValue) |
| | | { |
| | | sugarQueryable1 = sugarQueryable1.Where(x => x.CreateDate <= maxCreateDate.Value); |
| | | } |
| | | } |
| | | } |
| | | catch { } |