///筛选，使用DataTable的Select方法筛选
private void linklblSift_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
if (Items == null)
{
Items = new SiftItem[_dtSource.Columns.Count];
for (int i = 0; i < _dtSource.Columns.Count; i++)
{
Items[i] = new SiftItem();
Items[i].Display = _dtSource.Columns[i].ColumnName;
Items[i].Value = _dtSource.Columns[i].ColumnName;
Items[i].SiftType = SiftTypeEnum.Text;
}
}
FrmSift frm = new FrmSift(Items);
frm.Text = "筛选";
frm.ShowDialog();
if (frm.DialogResult != DialogResult.OK)
{
return;
}
_filter = frm.StrWhere;
BindData();
}
public FrmMain()
{
InitializeComponent();
dgvBLL = new DataGridViewBll(dataGridView1);
btnSearch.Click += delegate
{
_strWhere = GetWhere();
BindData();
};
btnFilter.Click += delegate
{
FrmSift frm = new FrmSift(this.dataGridView1, 1);
DialogResult result = frm.ShowDialog();
if (result != DialogResult.OK)
{
return;
}
_strWhere = frm.StrWhere;
BindData();
};
chbxList.Click += delegate
{
FrmFilter frm = new FrmFilter();
frm.Data = SqlHelper.GetData(string.Empty);
DialogResult result = frm.ShowDialog();
chbxList.Checked = false;
if (result == DialogResult.OK)
{
BindData();
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
if (frm.CheckList.Contains(dataGridView1.Rows[i].Cells["GUID"].Value.ToString()))
{
dataGridView1.Rows[i].Selected = true;
}
}
}
};
}
///筛选，使用DataTable的Select方法筛选
private void linklblSift_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
if (Items == null)
{
Items = new SiftItem[_dtSource.Columns.Count];
for (int i = 0; i < _dtSource.Columns.Count; i++)
{
Items[i] = new SiftItem();
Items[i].Display = _dtSource.Columns[i].ColumnName;
Items[i].Value = _dtSource.Columns[i].ColumnName;
Items[i].SiftType = SiftTypeEnum.Text;
}
}
FrmSift frm = new FrmSift(Items);
frm.Text = "筛选";
frm.ShowDialog();
if (frm.DialogResult != DialogResult.OK) return;
_filter = frm.StrWhere;
BindData();
}