| | |
| | | || u.PlanNo.Contains(input.SearchKey.Trim()) |
| | | || u.OrderId.Contains(input.SearchKey.Trim()) |
| | | || u.PackageCode.Contains(input.SearchKey.Trim()) |
| | | || u.LineRunModeName.Contains(input.SearchKey.Trim()) |
| | | || u.CreateUserName.Contains(input.SearchKey.Trim()) |
| | | || u.UpdateUserName.Contains(input.SearchKey.Trim()) |
| | | || u.PalletizingUPI.Contains(input.SearchKey.Trim()) |
| | | ) |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.UPI), u => u.UPI.Contains(input.UPI.Trim())) |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.PlanNo), u => u.PlanNo.Contains(input.PlanNo.Trim())) |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.OrderId), u => u.OrderId.Contains(input.OrderId.Trim())) |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.PackageCode), u => u.PackageCode.Contains(input.PackageCode.Trim())) |
| | | .WhereIF(input.LineRunMode.HasValue, u => u.LineRunMode == input.LineRunMode) |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.LineRunModeName), u => u.LineRunModeName.Contains(input.LineRunModeName.Trim())) |
| | | .WhereIF(!string.IsNullOrWhiteSpace(input.PalletizingUPI), u => u.PalletizingUPI.Contains(input.PalletizingUPI.Trim())) |
| | | .WhereIF(input.PalletizingStation>0, u => u.PalletizingStation == input.PalletizingStation) |
| | | .Select<WmsRbLineRunModeOutput>(); |
| | | return query; |
| | | } |