| | |
| | | .Where(x => x.LocationCode == param.Value.ToString()); |
| | | } |
| | | break; |
| | | case var name when name == nameof(Dt_StockInfo.PalletCode).FirstLetterToLower(): |
| | | if (!string.IsNullOrEmpty(param.Value?.ToString())) |
| | | { |
| | | sugarQueryable1 = sugarQueryable1 |
| | | .Where(x => x.PalletCode == param.Value.ToString()); |
| | | } |
| | | break; |
| | | |
| | | case var name when name == nameof(Dt_StockInfo.CreateDate).FirstLetterToLower(): |
| | | if (DateTime.TryParse(param.Value?.ToString(), out DateTime minDate)) |
| | |
| | | } |
| | | } |
| | | break; |
| | | case "inventoryage": |
| | | int inventoryage = param.Value.ObjToInt(); |
| | | if (inventoryage > 0) |
| | | { |
| | | DateTime dateTime = DateTime.Now.AddDays(-inventoryage); |
| | | sugarQueryable1 = sugarQueryable1.Where(x => x.CreateDate >= dateTime); |
| | | } |
| | | break; |
| | | case "inventoryage1": |
| | | int inventoryage1 = param.Value.ObjToInt(); |
| | | if (inventoryage1 > 0) |
| | | { |
| | | DateTime dateTime = DateTime.Now.AddDays(-inventoryage1); |
| | | sugarQueryable1 = sugarQueryable1.Where(x => x.CreateDate <= dateTime); |
| | | } |
| | | break; |
| | | } |
| | | } |
| | | } |