/// <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 + "%' ";
}
