Beispiel #1
0
        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);
        }