| | |
| | | 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))); |
| | | } |
| | | } |
| | | |
| | | } |
| | | |
| | |
| | | { |
| | | 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 ?? ""; |