public string GetFilter()
{
string strFilter = "";
if (this.txtColumnName.SelectedItem != null && this.txtSearchText.Text.TrimEnd() != "")
{
DataRowView drItem = this.txtColumnName.SelectedItem as DataRowView;
string strColumnName = drItem["ColumnName"].ToString().TrimEnd();
DataGridViewColumn dgvc = this.mgrdMain.Columns[strColumnName];
if (dgvc is DataGridViewCheckBoxColumn)
{
strFilter = strColumnName + "=" + (this.chkIsCheck.Checked ? "1" : "0");
}
else if (dgvc is LBDataGridViewComboBoxColumn)
{
LBDataGridViewComboBoxColumn lbColumn = dgvc as LBDataGridViewComboBoxColumn;
this.txtSearchDropDown.Visible = true;
if (lbColumn.DataSource != null)
{
if (drItem.DataView.Table.Columns[strColumnName].DataType == typeof(int) ||
drItem.DataView.Table.Columns[strColumnName].DataType == typeof(long)
)
{
if (this.txtSearchDropDown.SelectedValue != null)
{
strFilter = strColumnName + " = " + this.txtSearchDropDown.SelectedValue;
}
}
else
{
if (this.txtSearchDropDown.SelectedText != null)
{
strFilter = strColumnName + " like '%" + this.txtSearchDropDown.SelectedText + "%'";
}
}
}
}
else
{
strFilter = strColumnName + " like '%" + this.txtSearchText.Text + "%'";
}
}
return(strFilter);
}
private void TxtColumnName_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (this.txtColumnName.SelectedItem != null)
{
this.txtSearchDropDown.Visible = false;
this.txtSearchText.Visible = false;
DataRowView drItem = this.txtColumnName.SelectedItem as DataRowView;
string strColumnName = drItem["ColumnName"].ToString().TrimEnd();
DataGridViewColumn dgvc = this.mgrdMain.Columns[strColumnName];
if (dgvc is DataGridViewCheckBoxColumn)
{
this.chkIsCheck.Visible = true;
this.chkIsCheck.Location = new Point(this.lblSearch.Right + 10, this.chkIsCheck.Top);
}
else if (dgvc is LBDataGridViewComboBoxColumn)
{
LBDataGridViewComboBoxColumn lbColumn = dgvc as LBDataGridViewComboBoxColumn;
this.txtSearchDropDown.Visible = true;
if (lbColumn.DataSource != null)
{
this.txtSearchDropDown.DataSource = lbColumn.DataSource;
this.txtSearchDropDown.DisplayMember = lbColumn.DisplayMember;
this.txtSearchDropDown.ValueMember = lbColumn.ValueMember;
this.txtSearchDropDown.Location = new Point(this.lblSearch.Right + 10, this.txtSearchDropDown.Top);
}
}
else
{
this.txtSearchText.Visible = true;
this.txtSearchText.Location = new Point(this.lblSearch.Right + 10, this.txtSearchText.Top);
}
}
}
catch (Exception ex)
{
LB.WinFunction.LBCommonHelper.DealWithErrorMessage(ex);
}
}
