/// <summary> /// 查找数据 /// </summary> public void FilterGridData() { string keyWord = CommonFun.FormatKeyword(formView.FilterKeyWord); string filterString = ""; bool setFilterField = false; foreach (Control ctrl in this.propertyPanel.Controls) { if (ctrl.Tag == null) { continue; } FieldConfig config = (FieldConfig)ctrl.Tag; if (config.FIELD_MARK_TYPE == FIELD_MARK_TYPE.拼音码 || config.FIELD_MARK_TYPE == FIELD_MARK_TYPE.五笔码 || config.FIELD_MARK_TYPE == FIELD_MARK_TYPE.称) { filterString = " " + filterString + config.FIELD_DB_NAME + " LIKE '%" + keyWord + "%' OR "; setFilterField = true; } } if (setFilterField == false) { throw new Exception("没有正确配置名称、拼音码、五笔码字段!"); } filterString = filterString.Trim().Remove(filterString.Trim().Length - 2, 2); ((DataView)(dataGridViewEx.DataSource)).RowFilter = filterString; }
private void txtSearch_TextChanged(object sender, EventArgs e) { string strKey = CommonFun.FormatKeyword(txtSearch.Text); ((DataView)dgvServiceItem.DataSource).RowFilter = "PY_CODE LIKE '%" + strKey + "%' OR WB_CODE LIKE '%" + strKey + "%' OR ITEM_NAME LIKE '%" + strKey + "%' "; }