【C#】DataGridViewのフィルタ機能にユーザ設定フィルタを追加

	/// <summary>
	/// 検索データ
	/// </summary>
	public class SearchInfo
	{
		public string search1;      //検索文字列1
		public string search2;      //検索文字列2
		public int filter1;         //検索フィルタ1
		public int filter2;         //検索フィルタ2
		public int sel;             //And Or選択

		/// <summary>
		/// コンストラクタ
		/// </summary>
		public SearchInfo()
		{
			filter1 = 1;
			filter2 = 0;
			sel = 0;
		}
	}

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace DataGridViewAutoFilter
{
	public partial class formUserFilter : Form
	{
		/// <summary>
		/// フィルタ条件
		/// </summary>
		private string[] filterCategory = new string[13] {
			"",
			"と等しい",
			"と等しくない",
			"より大きい",
			"以上",
			"より小さい",
			"以下",
			"で始まる",
			"で始まらない",
			"で終わる",
			"で終わらない",
			"を含む",
			"を含まない"
		};

		// コントロール配列(AND・OR ラジオボタン)
		private const int RAD_ZERO = 0;
		private const int RAD_ONE = 1;
		private const int RAD_BUTTON_NUM = 2;
		private RadioButton[] radSelect = new RadioButton[RAD_BUTTON_NUM];

		// 対象データ
		private System.Collections.Specialized.OrderedDictionary filters = new System.Collections.Specialized.OrderedDictionary();

		// 検索条件
		private SearchInfo sInfo;		// 検索条件
		private string column;			// 検索カラム名
		private string searchStr;		// 検索文字列

		/// <summary>
		/// コンストラクタ
		/// </summary>
		/// <param name="Filters">対象データ</param>
		/// <param name="SearcInfo">検索条件</param>
		/// <param name="Column">対象カラム</param>
		public formUserFilter(System.Collections.Specialized.OrderedDictionary Filters,
								SearchInfo SInfo,
								string Column)
		{
			InitializeComponent();

			filters = Filters;
			sInfo = SInfo;
			column = Column;
			searchStr = "";
		}

		/// <summary>
		/// フォームロード
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void formUserFilter_Load(object sender, EventArgs e)
		{
			SetCmbFilter();

			SetCmbSelect();

			SetControlArray();

			SetSearchInfo();
		}

		/// <summary>
		/// 前回検索情報設定
		/// </summary>
		private void SetSearchInfo()
		{
			try
			{
				cmbSelect1.Text = sInfo.search1;
				cmbSelect2.Text = sInfo.search2;

				cmbFilter1.SelectedIndex = sInfo.filter1;
				cmbFilter2.SelectedIndex = sInfo.filter2;

				radSelect[sInfo.sel].Checked = true;
			}
			catch (Exception e)
			{
			}
		}

		/// <summary>
		/// コントロール配列設定
		/// </summary>
		private void SetControlArray()
		{
			radSelect[RAD_ZERO] = radAnd;
			radSelect[RAD_ONE] = radOr;

			radSelect[RAD_ZERO].Checked = true;
		}

		/// <summary>
		/// コンボボックス(条件)設定
		/// </summary>
		private void SetCmbFilter()
		{
			cmbSelect1.BeginUpdate();
			cmbSelect2.BeginUpdate();

			cmbSelect1.Items.Add("");
			cmbSelect2.Items.Add("");

			foreach (string val in filters.Values)
			{
				if (val != null)
				{
					cmbSelect1.Items.Add(val);
					cmbSelect2.Items.Add(val);
				}
			}

			cmbSelect1.EndUpdate();
			cmbSelect2.EndUpdate();
		}

		/// <summary>
		/// コンボボックス(フィルタ)設定
		/// </summary>
		private void SetCmbSelect()
		{
			cmbFilter1.Items.AddRange(filterCategory);
			cmbFilter1.SelectedIndex = 1;

			cmbFilter2.Items.AddRange(filterCategory);
		}

		/// <summary>
		/// 検索文字列設定処理
		/// </summary>
		/// <param name="str"></param>
		/// <param name="indx"></param>
		/// <returns></returns>
		private string SetFilterCondition(string str, int indx)
		{
			string target = "";
			StringBuilder sb = new StringBuilder();
			sb.Append("[");
			sb.Append(column);
			sb.Append("]");

			target = str.Replace("'", "''");

			switch (indx)
			{
				case 1:     // と等しい
					sb.Append("=");
					sb.Append("'");
					sb.Append(target);
					sb.Append("'");
					break;
				case 2:     // と等しくない
					sb.Append("<>");
					sb.Append("'");
					sb.Append(target);
					sb.Append("'");
					break;
				case 3:     // より大きい
					sb.Append(">");
					sb.Append("'");
					sb.Append(target);
					sb.Append("'");
					break;
				case 4:     // 以上
					sb.Append(">=");
					sb.Append("'");
					sb.Append(target);
					sb.Append("'");
					break;
				case 5:     // より小さい
					sb.Append("<");
					sb.Append("'");
					sb.Append(target);
					sb.Append("'");
					break;
				case 6:     // 以下
					sb.Append("<=");
					sb.Append("'");
					sb.Append(target);
					sb.Append("'");
					break;
				case 7:     // で始まる
					sb.Append("LIKE '");
					sb.Append(target);
					sb.Append("%'");
					break;
				case 8:     // で始まらない
					sb.Append("NOT LIKE '");
					sb.Append(target);
					sb.Append("%'");
					break;
				case 9:     // で終わる
					sb.Append("LIKE ");
					sb.Append("'");
					sb.Append(target);
					sb.Append("%'");
					break;
				case 10:     // で終わらない
					sb.Append("NOT LIKE ");
					sb.Append("'%");
					sb.Append(target);
					sb.Append("'");
					break;
				case 11:    // を含む
					sb.Append("LIKE '%");
					sb.Append(target);
					sb.Append("%'");
					break;
				case 12:    // を含まない
					sb.Append("NOT LIKE '%");
					sb.Append(target);
					sb.Append("%'");
					break;
				default:
					break;
			}

			// 今回検索情報の設定
			sInfo.search1 = cmbSelect1.Text;
			sInfo.search2 = cmbSelect2.Text;
			sInfo.filter1 = cmbFilter1.SelectedIndex;
			sInfo.filter2 = cmbFilter2.SelectedIndex;
			
			for(int i = 0; i < radSelect.Length; i++)
			{
				if (radSelect[i].Checked)
				{
					sInfo.sel = i;
				}
			}

			return sb.ToString();
		}

		/// <summary>
		/// OKボタン押下処理
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void btnOk_Click(object sender, EventArgs e)
		{
			this.DialogResult = DialogResult.OK;

			if (cmbFilter1.Text != "")
			{
				searchStr = SetFilterCondition(cmbSelect1.Text, cmbFilter1.SelectedIndex);
			}

			if (cmbFilter2.Text != "")
			{
				// 条件が2つ以上の場合は、カッコ( )で囲む
				searchStr = "(" + searchStr;
				if (radSelect[RAD_ZERO].Checked)
				{
					searchStr += " AND ";
				}
				else if (radSelect[RAD_ONE].Checked)
				{
					searchStr += " OR ";
				}
				searchStr += SetFilterCondition(cmbSelect2.Text, cmbFilter2.SelectedIndex);
				searchStr += ")";
			}

			Close();
		}

		/// <summary>
		/// キャンセルボタン押下処理
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void btnCancel_Click(object sender, EventArgs e)
		{
			Close();
		}

		/// <summary>
		/// 検索文字列取得処理
		/// </summary>
		/// <returns></returns>
		public string GetSearchString()
		{
			return searchStr;
		}

		/// <summary>
		/// 検索情報
		/// </summary>
		/// <returns></returns>
		public SearchInfo GetSearchInfo()
		{
			return sInfo;
		}
	}
}

/// <summary>
/// Populates the filters dictionary with formatted and unformatted string
/// representations of each unique value in the column, accounting for all 
/// filters except the current column's. Also adds special filter options. 
/// </summary>
private void PopulateFilters()
{
    // Continue only if there is a DataGridView.
    if (this.DataGridView == null)
    {
        return;
    }


	/// ～ 省略 ～ ///


    // Add special filter options to the filters dictionary
    // along with null values, since unformatted representations
    // are not needed. 
    filters.Insert(0, "(All)", null);
	filters.Insert(1, "(ﾕｰｻﾞｰ設定ﾌｨﾙﾀ)", null);
    if (containsBlanks && containsNonBlanks)
    {
        filters.Add("(Blanks)", null);
        filters.Add("(NonBlanks)", null);
    }
}

filters.Insert(1, "(ﾕｰｻﾞｰ設定ﾌｨﾙﾀ)", null);

/// <summary>
/// 検索情報テーブル
/// </summary>
private Dictionary<string, SearchInfo> sInfo = new Dictionary<string, SearchInfo>();

        /// <summary>
        /// Updates the BindingSource.Filter value based on a user selection
        /// from the drop-down filter list. 
        /// </summary>
        private void UpdateFilter()
        {
            // Continue only if the selection has changed.
            if (dropDownListBox.SelectedItem.ToString().Equals(selectedFilterValue) &&
				!dropDownListBox.SelectedItem.ToString().Equals("(ﾕｰｻﾞｰ設定ﾌｨﾙﾀ)"))
            {
                return;
            }

            // Store the new selection value. 
            selectedFilterValue = dropDownListBox.SelectedItem.ToString();

            // Cast the data source to an IBindingListView.
            IBindingListView data = 
                this.DataGridView.DataSource as IBindingListView;

            Debug.Assert(data != null && data.SupportsFiltering,
                "DataSource is not an IBindingListView or does not support filtering");

            // If the user selection is (All), remove any filter currently 
            // in effect for the column. 
            if (selectedFilterValue.Equals("(All)"))
			{
				data.Filter = FilterWithoutCurrentColumn(data.Filter);
                filtered = false;
                currentColumnFilter = String.Empty;
                return;
            }

            // Declare a variable to store the filter string for this column.
            String newColumnFilter = null;

            // Store the column name in a form acceptable to the Filter property, 
            // using a backslash to escape any closing square brackets. 
            String columnProperty = 
                OwningColumn.DataPropertyName.Replace("]", @"\]");

            // Determine the column filter string based on the user selection.
            // For (Blanks) and (NonBlanks), the filter string determines whether
            // the column value is null or an empty string. Otherwise, the filter
            // string determines whether the column value is the selected value. 
            switch (selectedFilterValue)
            {
                case "(Blanks)":
                    newColumnFilter = String.Format(
                        "LEN(ISNULL(CONVERT([{0}],'System.String'),''))=0",
                        columnProperty);
                    break;
                case "(NonBlanks)":
                    newColumnFilter = String.Format(
                        "LEN(ISNULL(CONVERT([{0}],'System.String'),''))>0",
                        columnProperty);
                    break;
				case "(ﾕｰｻﾞｰ設定ﾌｨﾙﾀ)":
					SearchInfo wkinfo = new SearchInfo();
					if (sInfo.ContainsKey(columnProperty))
					{
						wkinfo = sInfo[columnProperty];
					}
					formUserFilter fu = new formUserFilter(filters, wkinfo, columnProperty);
					if(fu.ShowDialog() == DialogResult.Cancel)
					{
						return;
					}
					newColumnFilter = fu.GetSearchString();
					SetLastSerchInfo(columnProperty, fu.GetSearchInfo());
					break;
				default:
                    newColumnFilter = String.Format("[{0}]='{1}'",
                        columnProperty,
                        ((String)filters[selectedFilterValue])
                        .Replace("'", "''"));  
                    break;
            }

            // Determine the new filter string by removing the previous column 
            // filter string from the BindingSource.Filter value, then appending 
            // the new column filter string, using " AND " as appropriate. 
            String newFilter = FilterWithoutCurrentColumn(data.Filter);
			String tempFilter = newFilter;
            if (String.IsNullOrEmpty(newFilter))
            {
                newFilter += newColumnFilter;
            }
            else
            {
                newFilter += " AND " + newColumnFilter;
            }


            // Set the filter to the new value.
            try
			{
				data.Filter = newFilter;
            }
            catch (InvalidExpressionException ex)
            {
				//throw new NotSupportedException(
				//    "Invalid expression: " + newFilter, ex);
			
				//フィルタ設定が不正の場合はすべて表示にする	
				MessageBox.Show("ﾕｰｻﾞｰ設定ﾌｨﾙﾀ 入力値エラー",
								"設定エラー",
								MessageBoxButtons.OK,
								MessageBoxIcon.Warning);

				data.Filter = tempFilter;
				newFilter = tempFilter;
				filtered = false;
				currentColumnFilter = String.Empty;

				dropDownListBox.SelectedIndex = 0;
				selectedFilterValue = dropDownListBox.SelectedItem.ToString();

				return;
			}

            // Indicate that the column is currently filtered
            // and store the new column filter for use by subsequent
            // calls to the FilterWithoutCurrentColumn method. 
            filtered = true;
            currentColumnFilter = newColumnFilter;
        }

		/// <summary>
		/// 検索情報設定
		/// </summary>
		/// <param name="key"></param>
		/// <param name="si"></param>
		private void SetLastSerchInfo(string key, SearchInfo si)
		{
			if (sInfo.ContainsKey(key))
			{
				sInfo[key] = si;
			}
			else
			{
				sInfo.Add(key, si);
			}
		}