public IQueryable <V_BomMaterial> GetBomMaterial(string key, string valid) { var list = _BomRepository.GetBomMaterial(); if (!string.IsNullOrEmpty(key)) { list = list.Where(p => p.version.Contains(key) || p.materialNo.Contains(key) || p.materialName.Contains(key) || p.materialModel.Contains(key) || p.tunumber.Contains(key)); } if (!string.IsNullOrEmpty(valid)) { if (valid == "0") { list = list.Where(p => p.status == 0); } else { list = list.Where(p => p.status == 1); } } return(list); }