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);
}
