DevExpress GridControl使用整理

  • A+
所属分类:.NET技术
摘要

1)去除 gridView 头上的 “Drag a column header here to group by that column”    gridView.OptionsView.ShowGroupPanel = false;


一、常用属性

1)去除 gridView 头上的 "Drag a column header here to group by that column"

    gridView.OptionsView.ShowGroupPanel = false;

2)显示出 gridView 自带的 搜索功能 

    gridView.OptionsFind.AlwaysVisible = true;

3)让各列头禁止移动

    gridView.OptionsCustomization.AllowColumnMoving = false;

4)让各列头禁止排序

    gridView.OptionsCustomization.AllowSort = false;

5)禁止各列头改变列宽

    gridView.OptionsCustomization.AllowColumnResizing = false;

6)设置gridView不可编辑

    gridView.OptionsBehavior.Editable = false;

7)设置GridColumn(列)不可编辑

    gridColumn.OptionsColumn.AllowEdit = false;

8)不显示View的详细信息。(不显示每行前面的”+“)

    gridView.OptionsDetail.EnableMasterViewMode = false;

9)判断gridView是否选中了数据

    int index= this.gridData.gridView.GetFocusedDataSourceRowIndex() ;

    如果index小于0,证明没有选中行,否则就选中了行数据

10)选中某一行

    gridView.FocusedRowHandle =i;

    gridView.SelectRow(i);

11)根据内容自适应列宽

    gridView.BestFitColumns();

12)获取选中行的数据

    DataRow row = gridView.GetRow(i);

    DataRow row =gridView.GetFocusedRow();

13)新增一行

    gridView.AddNewRow()

14)删除选中的行

    gridView.DeleteSelectedRows();

15)设置某一列不可编辑

    GridColumn.OptionsColumn.AllowEdit = false;

16)设置gridControl列宽自使用

    gridView.OptionsView.ColumnAutoWidth = True;//为false宽度不够时出现水平滚动条

17)绑定数据

    //绑定DataSet

    gridControl.DataSource = DataSet;

    gridControl.DataMember = "表名";

    //绑定List集合

    gcGumRecord.DataSource = new BindingList<类名>(集合);

二、常用设置

1)设置成一次选择一行,并且不能被编辑

    this.gridView.FocusRectStyle = DevExpress.XtraGrid.Views.Grid.DrawFocusRectStyle.RowFocus;

    this.gridView.OptionsBehavior.Editable = false;

    this.gridView.OptionsSelection.EnableAppearanceFocusedCell = false;

2)设置gridView为多选模式

    gridView.OptionsSelection.MultiSelect = true;

    gridView.OptionsSelection.CheckBoxSelectorColumnWidth = 30;

    gridView.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CheckBoxRowSelect;

    效果:

    DevExpress GridControl使用整理

    ps:不设置多选模式时:gridView.OptionsSelection.MultiSelect = false;

3)gridView为多选模式时设置单选(不能同时勾选多个),使用SelectionChanged事件

DevExpress GridControl使用整理DevExpress GridControl使用整理

private void GridView1_SelectionChanged(object sender, DevExpress.Data.SelectionChangedEventArgs e) {     var a = e.Action;     if (gridView1.SelectedRowsCount > 1)     {         foreach (int rowHandle in gridView1.GetSelectedRows())         {             if (rowHandle != e.ControllerRow)             {                 gridView1.UnselectRow(rowHandle);             }         }     } }

View Code

4)设置显示gridView新增一行

    gridView.OptionsView.NewItemRowPosition = DevExpress.XtraGrid.Views.Grid.NewItemRowPosition.Top;

    gridView.NewItemRowText = "点击此处增加一行";

    效果:

    DevExpress GridControl使用整理

    ps:仅设置显示效果,实际能新增行要先给GridControl绑定数据源。

    不设置新增一行时: gridView.OptionsView.NewItemRowPosition = DevExpress.XtraGrid.Views.Grid.NewItemRowPosition.None;

21)显示行号

DevExpress GridControl使用整理DevExpress GridControl使用整理

//Helper.SetGridViewShowRowNumber(gridView1); 直接调用即可 public static class Helper {     /// <summary>     /// 设置GridView显示行号     /// </summary>     /// <param name="gv"></param>     public static void SetGridViewShowRowNumber(this DevExpress.XtraGrid.Views.Grid.GridView gv)     {         gv.OptionsView.ShowIndicator = true;         ResetIndicatorWidth(gv);          //设置行号         gv.CustomDrawRowIndicator += delegate (object sender, DevExpress.XtraGrid.Views.Grid.RowIndicatorCustomDrawEventArgs e)         {             DevExpress.Utils.Drawing.IndicatorObjectInfoArgs info = e.Info;             if (info == null || !info.IsRowIndicator || e.RowHandle < 0)                 return;             info.Appearance.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;             info.DisplayText = (e.RowHandle + 1).ToString();         };          //行数改变         gv.RowCountChanged += delegate (object sender, EventArgs e)         {             DevExpress.XtraGrid.Views.Grid.GridView selfView = sender as DevExpress.XtraGrid.Views.Grid.GridView;             if (selfView == null)                 return;             ResetIndicatorWidth(gv);         };          //gv有子表时,展开子表重置其行号宽度         gv.MasterRowExpanded += delegate (object sender, DevExpress.XtraGrid.Views.Grid.CustomMasterRowEventArgs e)         {             DevExpress.XtraGrid.Views.Grid.GridView View = sender as DevExpress.XtraGrid.Views.Grid.GridView;             if (View == null)                 return;             DevExpress.XtraGrid.Views.Grid.GridView dView = View.GetDetailView(e.RowHandle, e.RelationIndex) as DevExpress.XtraGrid.Views.Grid.GridView;             if (dView == null)                 return;             ResetIndicatorWidth(gv);         };     }      /// <summary>     /// 重置行号宽度     /// </summary>     /// <param name="gvw"></param>     /// <param name="rowCount"></param>     public static void ResetIndicatorWidth(this DevExpress.XtraGrid.Views.Grid.GridView gvw, int rowCount = -1)     {         gvw.IndicatorWidth = GetIndicatorWidth(rowCount == -1 ? gvw.RowCount : rowCount);     }      // 行号宽度     public static int GetIndicatorWidth(int p)     {         return 7 * p.ToString().Length + 20;     } }

View Code

    效果:

    DevExpress GridControl使用整理

23)行色变化事件(RowCellStyle)

        private void GridView1_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)         {             int hand = e.RowHandle;             if (hand < 0) return;             e.Appearance.BackColor = Color.Yellow;// 改变行背景颜色             e.Appearance.ForeColor = Color.Red;// 改变行字体颜色             //e.Appearance.BackColor2 = Color.Blue;// 添加渐变颜色         }

    效果:

    DevExpress GridControl使用整理

三、初始化列

gridView1.Columns.Clear(); //或者使用:gridView1.Columns.AddVisible("字段名","标题"); this.gridView1.Columns.Add(new DevExpress.XtraGrid.Columns.GridColumn() { FieldName = "A", Caption = "列一", VisibleIndex = 0}); //使用ColumnEdit属性给列绑定控件 DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit lue_IsYes = new DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit(); this.gridView1.Columns.Add(new DevExpress.XtraGrid.Columns.GridColumn() { FieldName = "B", Caption = "列二", VisibleIndex = 1, ColumnEdit = lue_IsYes });

    效果:

    DevExpress GridControl使用整理

四、数据验证

使用循环每一个单元格的思路进行数据验证。

例如设置必填:

 for (int i = 0; i < gridView1.RowCount; i++)   {      if (string.IsNullOrEmpty(gridView1.GetRowCellValue(i, "FieldName") as string))       {          gridView1.FocusedRowHandle = i;          var col = gridView1.Columns.Where(c => c.FieldName == "FieldName").FirstOrDefault();          gridView1.SetColumnError(col, "该字段不能为空,请重新填写!");       }   }

效果:

DevExpress GridControl使用整理