|  |  | 
 |  |  |                                     sugarQueryable1 = sugarQueryable1.Where(x => x.proStockInfoDetails.Any(v => v.ProductVersion.Contains(searchParameters.Value))); | 
 |  |  |                                 } | 
 |  |  |                             } | 
 |  |  |                             { | 
 |  |  |                                 SearchParameters? searchParameters = searchParametersList.FirstOrDefault(x => x.Name == nameof(Dt_ProStockInfoDetail.SpecifyVer).FirstLetterToLower()); | 
 |  |  |                                 if (searchParameters != null) | 
 |  |  |                                 { | 
 |  |  |                                     sugarQueryable1 = sugarQueryable1.Where(x => x.proStockInfoDetails.Any(v => v.SpecifyVer.Contains(searchParameters.Value))); | 
 |  |  |                                 } | 
 |  |  |                             } | 
 |  |  |                             { | 
 |  |  |                                 SearchParameters? searchParameters = searchParametersList.FirstOrDefault(x => x.Name == nameof(Dt_ProStockInfoDetail.LotNumber).FirstLetterToLower()); | 
 |  |  |                                 if (searchParameters != null) | 
 |  |  |                                 { | 
 |  |  |                                     sugarQueryable1 = sugarQueryable1.Where(x => x.proStockInfoDetails.Any(v => v.LotNumber.Contains(searchParameters.Value))); | 
 |  |  |                                 } | 
 |  |  |                             } | 
 |  |  |  | 
 |  |  |  | 
 |  |  |                         } | 
 |  |  |  | 
 |  |  | 
 |  |  |                     { | 
 |  |  |                         x.ProductCode = string.Join(",", x.Details.Select(x => x.ProductCode).Distinct()); | 
 |  |  |                         x.ProductVersion = string.Join(",", x.Details.Select(x => x.ProductVersion).Distinct()); | 
 |  |  |                         x.SpecifyVer = string.Join(",", x.Details.Select(x => x.SpecifyVer).Distinct()); | 
 |  |  |                         x.DateCode = x.Details.FirstOrDefault()?.DateCode ?? ""; | 
 |  |  |                         x.LotNumber = x.Details.FirstOrDefault()?.LotNumber ?? ""; | 
 |  |  |                         x.ERPOrder = x.Details.FirstOrDefault()?.ERPOrder ?? ""; | 
 |  |  | 
 |  |  |                 { | 
 |  |  |                     x.ProductCode = string.Join(",", x.Details.Select(x => x.ProductCode).Distinct()); | 
 |  |  |                     x.ProductVersion = string.Join(",", x.Details.Select(x => x.ProductVersion).Distinct()); | 
 |  |  |                     x.SpecifyVer = string.Join(",", x.Details.Select(x => x.SpecifyVer).Distinct()); | 
 |  |  |                     x.DateCode = x.Details.FirstOrDefault()?.DateCode ?? ""; | 
 |  |  |                     x.LotNumber = x.Details.FirstOrDefault()?.LotNumber ?? ""; | 
 |  |  |                     x.ERPOrder = x.Details.FirstOrDefault()?.ERPOrder ?? ""; | 
 |  |  | 
 |  |  |                     { | 
 |  |  |                         x.ProductCode = string.Join(",", x.Details.Select(x => x.ProductCode).Distinct()); | 
 |  |  |                         x.ProductVersion = string.Join(",", x.Details.Select(x => x.ProductVersion).Distinct()); | 
 |  |  |                         x.SpecifyVer = string.Join(",", x.Details.Select(x => x.SpecifyVer).Distinct()); | 
 |  |  |                         x.DateCode = x.Details.FirstOrDefault()?.DateCode ?? ""; | 
 |  |  |                         x.LotNumber = x.Details.FirstOrDefault()?.LotNumber ?? ""; | 
 |  |  |                         x.ERPOrder = x.Details.FirstOrDefault()?.ERPOrder ?? ""; |