模糊查询

   //省份查询，条件过滤省份
        public List<m_province> GetProvinceByConditions(string ProvicneNo, string provinceNameCn, string provinceNameEn)
        {
            using (var _DataEntities = new ntasystemEntities())
            {
                var q = from c in _DataEntities.m_province
                        select c;
                if (ProvicneNo != "")
                {
                    q = q.Where(c => c.No.Contains(ProvicneNo));
                }
                if (provinceNameCn != "")
                {
                    q = q.Where(c => c.Name_cn.Contains(provinceNameCn));
                }
                if (provinceNameEn != "")
                {
                    q = q.Where(c => c.Name_en.Contains(provinceNameEn));
                }
                q = q.OrderByDescending(c => c.No);
                return q.Take(100).ToList<m_province>();
            }

        }

 this.dgvProvinceInfo.DataSource = wcf.GetProvinceByConditions(no, nameCn, nameEn);