Dev控件GridControl实现CheckBox列和ComBox列

1、在sql语句中添加空白行，如select c1,c2 null c3 from xxx;

2、将sql语句查询结果与gdc绑定CmmFrm.BestFitGridViewColumnsWidth(gdc_lines, sql,2);

3、将上述空白列绑定为RepositoryItemCheckEdit控件，并添加事件

　　RepositoryItemCheckEdit re = new RepositoryItemCheckEdit();            

　　re.QueryCheckStateByValue += new DevExpress.XtraEditors.Controls.QueryCheckStateByValueEventHandler(Re_QueryCheckStateByValue);//定义这个事件是关键,因为就靠它了　　

　　gdv_lines.Columns[2].ColumnEdit = re;

4、事件实现：

　　   void Re_QueryCheckStateByValue(object sender, DevExpress.XtraEditors.Controls.QueryCheckStateByValueEventArgs e)
        {
            string val = "";
            if (e.Value != null)
            {
                val = e.Value.ToString();
            }
            else
            {
                val = "";//默认为不选中
            }
           switch (val)
            {
                case"True":
                    e.CheckState = CheckState.Checked;
                    break;
                case"False":
                    e.CheckState = CheckState.Unchecked;
                    break;
                case"Yes":
                    goto case"True";
                case"No":
                    goto case"False";
                case"1":
                    goto case"True";
                case"0":
                    goto case"False";
                default:
                    e.CheckState = CheckState.Unchecked; //默认状态，如果默认选择，则改为Checked
                    break;
            }
            e.Handled = true;
        }

5、整个gdv控件要设为可编辑，但除了chekbox列外，其它列要禁止出现编辑，这要靠gdc控件的ShowingEditor事件实现

private void gdv_lines_ShowingEditor(object sender, CancelEventArgs e)        

{

            if (gdv_lines.FocusedColumn.AbsoluteIndex != 2)

                e.Cancel = true;

}

6、遍历、检索

for (int i = 0; i < gdv_lines.DataRowCount; i++)
            {
                DataRow dr=gdv_lines.GetDataRow(i);
                string ck = dr[2].ToString();
                if (ck == "True")
                {

　　　　　　　　...

　　　　　　}

7、程序设置选择状态

bool res = true;            

if (gdv_lines.GetDataRow(0)[2].ToString() == "True") res = false; 

for (int i = 0; i < gdv_lines.DataRowCount; i++)  gdv_lines.GetDataRow(i)[2] = res;

///////////////////////////////////////////////////   

另外，添加CombBox的方法，还不完善            

                //  gdvLevel.BeginUpdate(); //开始视图的编辑，防止触发其他事件

                //  gdvLevel.BeginDataUpdate(); //开始数据的编辑

                CmmFrm.BestFitGridViewColumnsWidth(gdcLevel, lvels, 1, false, false);

                gdcLevel.DataSource = lvels;

                gdvLevel.Columns[0].Visible = false;

                RepositoryItemComboBox riCombo = new RepositoryItemComboBox();

                riCombo.Items.AddRange(new string[] { "夏", "目视", "目视以下", "(含)以下" });

                gdcLevel.RepositoryItems.Add(riCombo);

                gdvLevel.Columns["其它"].ColumnEdit = riCombo;

　　　　 //目前这种添加combbox的方法有缺陷，主要表现在1、不能设置为DorpDownList样式。2、选择后要敲回车，选择才能现在Cell中，否则焦点移走，选择就消失。

　　　　 //有两篇文章解决这个问题，有时间梳理下

　　　　//https://yq.aliyun.com/articles/55052
　　　　//https://www.cnblogs.com/lonelyxmas/p/3906496.html

                RepositoryItemCheckEdit riCkbox = new RepositoryItemCheckEdit();

                riCkbox.ValueChecked = false;

                gdcLevel.RepositoryItems.Add(riCkbox);

                gdvLevel.Columns["选择"].ColumnEdit = riCkbox;

                gdvLevel.EndDataUpdate();//结束数据的编辑

                gdvLevel.EndUpdate();   //结束视图的编辑