GridView默认属性配置
获取已经勾选的行
//GridView默认属性配置
public static void SetDefaultGridViewOption(GridView gvDetail)
{
gvDetail.OptionsView.ColumnAutoWidth = false; //自动列宽,关闭
gvDetail.OptionsView.ShowGroupPanel = false; //分组,关闭
gvDetail.OptionsMenu.EnableColumnMenu = true; //显示列菜单: 可以开启分组, 排序, 过滤, 删除列, 添加列等功能
gvDetail.OptionsCustomization.AllowSort = true; //允许排序
gvDetail.OptionsView.ShowFooter = true; //显示表格尾
gvDetail.OptionsNavigation.EnterMoveNextColumn = true;
gvDetail.OptionsView.ShowAutoFilterRow = true;//显示自动过滤栏
gvDetail.OptionsCustomization.AllowFilter = true;//显示列右上角的过滤按钮
gvDetail.OptionsView.ShowFilterPanelMode = DevExpress.XtraGrid.Views.Base.ShowFilterPanelMode.Default; //过滤编辑栏自动隐藏
gvDetail.OptionsBehavior.Editable = true; //1,只有启用编辑才可以设置表格的只读
gvDetail.OptionsBehavior.ReadOnly = false; //2,设置表格默认非只读,单元格才可以选中复制
//3,设置所有单元格为只读, 需要编辑的单元格请单独去掉只读
foreach (GridColumn c in gvDetail.Columns)
{
c.OptionsColumn.ReadOnly = true; //单元格只读
//数量列,默认格式化为整型显示
if (c.Name.Contains("Qty"))
{
c.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
c.SummaryItem.DisplayFormat = "{0:n0}";
}
}
//表格尾默认显示记录数
if (gvDetail.Columns.Count >= 2)
{
//记录数汇总
gvDetail.Columns[0].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Custom;
gvDetail.Columns[0].SummaryItem.DisplayFormat = "记录数:";
gvDetail.Columns[1].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Count;
gvDetail.Columns[1].SummaryItem.DisplayFormat = "{0:n0}";
}
}
获取已经勾选的行
//结束表格编辑,过滤出选中的数据,用于读取
public static DataTable GetSelectDataForRead(GridView gvMaster, DataView dvMaster, string RowFilter)
{
if (null == gvMaster || null == dvMaster)
{
return null;
}
gvMaster.CloseEditor();
gvMaster.UpdateCurrentRow();
DataTable dtData = dvMaster.ToTable();
dtData.DefaultView.RowFilter = RowFilter; // "Flag = 1";
dtData = dtData.DefaultView.ToTable(); //只留下已经选中的单据
return dtData;
}