private void Form14Result_Load(object sender, EventArgs e) { HideToolBarButton(); gridControl1.DataSource = GridDataTable; if (gridView1.Columns.Count > 0) { gridView1.Columns["Year"].Width = 40; gridView1.Columns["Year"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; gridView1.Columns["Year"].Caption = ""; gridView1.Columns["Year"].OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True; gridView1.Columns["Title"].Width = 120; gridView1.Columns["Title"].Caption = ""; for (int i = 0; i < gridView1.Columns.Count; i++) { GridColumn gridCol = gridView1.Columns[i]; gridCol.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; if (gridCol.FieldName.IndexOf("Col") == 0) { gridCol.Caption = gridDataTable.Columns[gridCol.FieldName].Caption; //gridCol.Width = 120; gridCol.BestFit(); gridCol.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False; } } } }
public void AddRowNumberColumn() { BeginUpdate(); RowNumberColumn.Caption = "#"; RowNumberColumn.FieldName = "Row"; RowNumberColumn.UnboundType = DevExpress.Data.UnboundColumnType.Integer; RowNumberColumn.Visible = true; Columns.Add(RowNumberColumn); RowNumberColumn.VisibleIndex = 0; RowNumberColumn.BestFit(); EndUpdate(); }
/// <summary> /// 그리드의 컬럼을 추가한다. /// </summary> /// <param name="column">XGridColumn</param> public void AddGridColumn(XGridColumn column) { //Caption if (string.IsNullOrEmpty(column.Caption)) { if (!string.IsNullOrEmpty(column.CaptionCode)) { column.Caption = DomainUtils.GetFieldName(column.CaptionCode); } else { column.Caption = DomainUtils.GetFieldName(column.FieldName); } } var gridColumn = new GridColumn() { Caption = column.Caption, FieldName = column.FieldName, UnboundType = column.ColumnType }; gridColumn.OptionsColumn.AllowMerge = DefaultBoolean.False; gridColumn.OptionsFilter.FilterPopupMode = FilterPopupMode.CheckedList; gridColumn.CustomizationCaption = gridColumn.Caption; gridColumn.AppearanceHeader.Options.UseTextOptions = true; gridColumn.AppearanceHeader.TextOptions.HAlignment = HorzAlignment.Center; if (column.IsMandatory) { gridColumn.AppearanceHeader.Options.UseForeColor = true; //if (SkinUtils.IsDarkSkin) // gridColumn.AppearanceHeader.ForeColor = Color.Yellow; //else gridColumn.AppearanceHeader.ForeColor = Color.Red; gridColumn.Tag = true; } else { gridColumn.AppearanceHeader.Options.UseForeColor = false; gridColumn.Tag = null; } gridColumn.AppearanceCell.Options.UseTextOptions = true; switch (column.FieldName) { case "ROW_NO": case "INS_TIME": case "INS_USER": case "INS_USER_NAME": case "UPD_TIME": case "UPD_USER": case "UPD_USER_NAME": gridColumn.AppearanceCell.TextOptions.HAlignment = HorzAlignment.Center; break; default: if (column.FieldName.EndsWith("_DATE")) { gridColumn.AppearanceCell.TextOptions.HAlignment = HorzAlignment.Center; } else { gridColumn.AppearanceCell.TextOptions.HAlignment = column.HorzAlignment; } break; } gridColumn.DisplayFormat.FormatType = gridColumn.GroupFormat.FormatType = column.FormatType; if (!string.IsNullOrEmpty(column.FormatString)) { gridColumn.DisplayFormat.FormatString = column.FormatString; gridColumn.GroupFormat.FormatString = column.FormatString; } if (column.RepositoryItem != null) { gridColumn.ColumnEdit = column.RepositoryItem; } if ((column.IsSummary) && (MainView.GetType() == typeof(GridView) || MainView.GetType() == typeof(BandedGridView) || MainView.GetType() == typeof(AdvBandedGridView))) { gridColumn.SummaryItem.SummaryType = column.SummaryItemType; gridColumn.SummaryItem.FieldName = column.FieldName; if (!string.IsNullOrEmpty(column.FormatString)) { gridColumn.SummaryItem.DisplayFormat = string.Format("{{0:{0}}}", column.FormatString); } if (column.IsSummaryGroup) { var item = new GridGroupSummaryItem() { FieldName = column.FieldName, ShowInGroupColumnFooter = gridColumn, ShowInGroupColumnFooterName = column.FieldName, SummaryType = column.SummaryItemType }; if (!string.IsNullOrEmpty(column.FormatString)) { item.DisplayFormat = string.Format("{{0:{0}}}", column.FormatString); } GroupSummaryAdd(item); gridColumn.OptionsColumn.AllowGroup = DefaultBoolean.True; } } if (column.ReadOnly || MainView.OptionsBehavior.Editable == false) { gridColumn.OptionsColumn.ReadOnly = true; gridColumn.OptionsColumn.AllowEdit = false; gridColumn.OptionsColumn.AllowFocus = false; } else { gridColumn.OptionsColumn.ReadOnly = false; gridColumn.OptionsColumn.AllowEdit = true; gridColumn.OptionsColumn.AllowFocus = true; } if (column.Width > 0) { gridColumn.Width = column.Width; gridColumn.MinWidth = column.Width; } else { switch (column.FieldName) { case "ROW_NO": gridColumn.Width = 50; gridColumn.MinWidth = 50; break; case "INS_TIME": case "UPD_TIME": gridColumn.Width = 150; gridColumn.MinWidth = 150; break; case "INS_USER": case "UPD_USER": gridColumn.Width = 100; gridColumn.MinWidth = 100; break; case "INS_USER_NAME": case "UPD_USER_NAME": gridColumn.Width = 100; gridColumn.MinWidth = 100; break; default: if (column.FieldName.EndsWith("_DATE")) { gridColumn.Width = 100; gridColumn.MinWidth = 100; } else { gridColumn.BestFit(); } break; } } gridColumn.Visible = column.Visible; if (column.Visible) { gridColumn.VisibleIndex = MainView.Columns.Count; } MainView.Columns.Add(gridColumn); }