private void OnTwoColorsCustomClick(object sender, EventArgs e)
{
CustomFormatRule fm = new CustomFormatRule(EnumConditionalFormatType.TwoColorsRange);
fm.ShowDialog();
if (fm.DialogResult == DialogResult.OK)
{
OutlookGridColumn col = internalColumns.FindFromColumnIndex(colSelected);
ConditionalFormatting format = formatConditions.Where(x => x.ColumnName == col.Name).FirstOrDefault();
if (format == null)
{
ConditionalFormatting newformat = new Formatting.ConditionalFormatting(col.DataGridViewColumn.Name, EnumConditionalFormatType.TwoColorsRange, new TwoColorsParams(fm.colMin, fm.colMax));
formatConditions.Add(newformat);
}
else
{
format.FormatType = EnumConditionalFormatType.TwoColorsRange;
format.FormatParams = new TwoColorsParams(fm.colMin, fm.colMax);
}
Fill();
}
fm.Dispose();
}
/// <summary>
/// Loads the default configuration.
/// </summary>
/// <param name="Grid">The grid.</param>
private void LoadDefaultConfiguration(JDHSoftware.Krypton.Toolkit.KryptonOutlookGrid.KryptonOutlookGrid Grid)
{
Grid.ClearEverything();
Grid.GroupBox.Visible = true;
Grid.HideColumnOnGrouping = false;
Grid.FillMode = FillMode.GroupsAndNodes; //treemode enabled;
Grid.ShowLines = true;
activeColumns = new SandBoxGridColumn[] {
SandBoxGridColumn.ColumnCustomerID,
SandBoxGridColumn.ColumnCustomerName,
SandBoxGridColumn.ColumnAddress,
SandBoxGridColumn.ColumnCity,
SandBoxGridColumn.ColumnCountry,
SandBoxGridColumn.ColumnOrderDate,
SandBoxGridColumn.ColumnProduct,
SandBoxGridColumn.ColumnPrice,
SandBoxGridColumn.SatisfactionColumn,
SandBoxGridColumn.ColumnToken
};
DataGridViewColumn[] columnsToAdd = new DataGridViewColumn[10]
{
SetupColumn(SandBoxGridColumn.ColumnCustomerID),
SetupColumn(SandBoxGridColumn.ColumnCustomerName),
SetupColumn(SandBoxGridColumn.ColumnAddress),
SetupColumn(SandBoxGridColumn.ColumnCity),
SetupColumn(SandBoxGridColumn.ColumnCountry),
SetupColumn(SandBoxGridColumn.ColumnOrderDate),
SetupColumn(SandBoxGridColumn.ColumnProduct),
SetupColumn(SandBoxGridColumn.ColumnPrice),
SetupColumn(SandBoxGridColumn.SatisfactionColumn),
SetupColumn(SandBoxGridColumn.ColumnToken)
};
Grid.Columns.AddRange(columnsToAdd);
//Define the columns for a possible grouping
Grid.AddInternalColumn(columnsToAdd[0], new OutlookGridDefaultGroup(null), SortOrder.None, -1, -1);
Grid.AddInternalColumn(columnsToAdd[1], new OutlookGridAlphabeticGroup(null), SortOrder.None, -1, -1);
Grid.AddInternalColumn(columnsToAdd[2], new OutlookGridDefaultGroup(null), SortOrder.None, -1, -1);
Grid.AddInternalColumn(columnsToAdd[3], new OutlookGridDefaultGroup(null), SortOrder.None, -1, -1);
Grid.AddInternalColumn(columnsToAdd[4], new OutlookGridDefaultGroup(null), SortOrder.None, -1, -1);
Grid.AddInternalColumn(columnsToAdd[5], new OutlookGridDateTimeGroup(null), SortOrder.None, -1, -1);
Grid.AddInternalColumn(columnsToAdd[6], new OutlookGridDefaultGroup(null) { OneItemText = "1 product", XXXItemsText = " products" }, SortOrder.None, -1, -1);
Grid.AddInternalColumn(columnsToAdd[7], new OutlookGridPriceGroup(null), SortOrder.None, -1, -1);
Grid.AddInternalColumn(columnsToAdd[8], new OutlookGridDefaultGroup(null), SortOrder.None, -1, -1);
Grid.AddInternalColumn(columnsToAdd[9], new OutlookGridDefaultGroup(null), SortOrder.None, -1, -1);
//Add a default conditionnal formatting
ConditionalFormatting cond = new ConditionalFormatting();
cond.ColumnName = SandBoxGridColumn.ColumnPrice.ToString();
cond.FormatType = EnumConditionalFormatType.TwoColorsRange;
cond.FormatParams = new TwoColorsParams(Color.White, Color.FromArgb(255, 255, 58, 61));
Grid.ConditionalFormatting.Add(cond);
}
