void grid_AutoGeneratedColumns(object sender, RoutedEventArgs e)
{
grid.Bands[0].Fixed = FixedStyle.Left;
GridControlBand band = new GridControlBand()
{
Header = "Total", Fixed = FixedStyle.Right
};
band.Columns.Add(new GridColumn()
{
FieldName = "Total", UnboundType = UnboundColumnType.Decimal, ReadOnly = true
});
grid.Bands.Add(band);
grid.BeginDataUpdate();
SpinEditSettings editSettings = new SpinEditSettings()
{
MaskType = MaskType.Numeric, Mask = "c", MaskCulture = new CultureInfo("en-US"),
MaskUseAsDisplayFormat = true, HorizontalContentAlignment = EditSettingsHorizontalAlignment.Right
};
foreach (GridColumn column in grid.Columns)
{
if (column.FieldName != "Employee")
{
grid.TotalSummary.Add(new GridSummaryItem()
{
FieldName = column.FieldName, SummaryType = SummaryItemType.Sum
});
column.EditSettings = editSettings;
}
}
grid.EndDataUpdate();
}
public FmCurrencySpinEditGridColumn()
{
EditSettings = new SpinEditSettings
{
Mask = "###,###,###,###,##0.00 ریال"
};
}
static SpinEditSettings CreateSpinEditSettings(int minValue, int maxValue, int increment)
{
SpinEditSettings settings = new SpinEditSettings();
settings.MinValue = minValue;
settings.MaxValue = maxValue;
settings.Increment = increment;
settings.IsFloatValue = false;
return(settings);
}
private void spreadsheetControl1_CustomCellEdit(object sender, SpreadsheetCustomCellEditEventArgs e)
{
// Specify a type of the custom editor assigned to cells of the "Quantity" table column.
// To identify the custom editor, use a value of ValueObject associated with it.
if (e.ValueObject.IsText && e.ValueObject.TextValue == "MySpinEdit")
{
// Create a SpinEdit in-place editor and assign it to a cell.
SpinEditSettings settings = new SpinEditSettings();
settings.MinValue = 1;
settings.MaxValue = 1000;
settings.IsFloatValue = false;
e.EditSettings = settings;
}
}
/// <summary>
/// Устанавливает настройки по-умолчанию для редактора чисел.
/// </summary>
/// <param name="settings">Настройки.</param>
/// <param name="token">Токен безорпасности.</param>
/// <param name="isDecimal">Признак числа с плавающей точкой.</param>
public static void SetDefaultSettings(this SpinEditSettings settings, SecurityToken token, bool isDecimal = false)
{
settings.Width = Unit.Percentage(100);
settings.Properties.ValidationSettings.ErrorDisplayMode = ErrorDisplayMode.ImageWithTooltip;
settings.ShowModelErrors = true;
settings.Properties.SpinButtons.ShowLargeIncrementButtons = false;
settings.Properties.SpinButtons.ShowIncrementButtons = false;
if (isDecimal)
{
settings.Properties.NumberType = SpinEditNumberType.Float;
settings.Properties.DisplayFormatString = "f2";
}
settings.Properties.ClearButton.DisplayMode = ClearButtonDisplayMode.OnHover;
}
private void DateinitGridControl()
{
StatisData.Columns.Clear();
SpinEditSettings editSettings1 = new SpinEditSettings()
{
HorizontalContentAlignment = EditSettingsHorizontalAlignment.Center
};
StatisData.Columns.Add(new GridColumn()
{
FieldName = "日期", HorizontalHeaderContentAlignment = HorizontalAlignment.Center, Width = 130
});
StatisData.Columns.Add(new GridColumn()
{
FieldName = "次数", HorizontalHeaderContentAlignment = HorizontalAlignment.Center, Width = 100
});
StatisData.Columns["日期"].EditSettings = editSettings1;
StatisData.Columns["次数"].EditSettings = editSettings1;
}
public void InitGridControl()
{
UserData.Columns.Clear();
SpinEditSettings editSettings1 = new SpinEditSettings()
{
HorizontalContentAlignment = EditSettingsHorizontalAlignment.Center
};
UserData.Columns.Add(new GridColumn()
{
FieldName = "用户ID", HorizontalHeaderContentAlignment = HorizontalAlignment.Center
});
UserData.Columns.Add(new GridColumn()
{
FieldName = "用户名", HorizontalHeaderContentAlignment = HorizontalAlignment.Center
});
UserData.Columns.Add(new GridColumn()
{
FieldName = "用户权限", HorizontalHeaderContentAlignment = HorizontalAlignment.Center
});
UserData.Columns["用户ID"].EditSettings = editSettings1;
UserData.Columns["用户名"].EditSettings = editSettings1;
UserData.Columns["用户权限"].EditSettings = editSettings1;
}
public FmSpinEditGridColumn()
{
EditSettings = new SpinEditSettings();
}
public FmPercentageSpinEditGridColumn()
{
EditSettings = new SpinEditSettings {
Mask = "p"
};
}
public void InitGridControl()
{
LogData.Columns.Clear();
SpinEditSettings editSettings1 = new SpinEditSettings()
{
DisplayFormat = "yyyy-MM-dd HH:mm:ss",
HorizontalContentAlignment = EditSettingsHorizontalAlignment.Center
};
SpinEditSettings editSettings2 = new SpinEditSettings()
{
HorizontalContentAlignment = EditSettingsHorizontalAlignment.Center
};
LogData.Columns.Add(new GridColumn()
{
FieldName = "时间", HorizontalHeaderContentAlignment = HorizontalAlignment.Center, Width = 130
});
LogData.Columns.Add(new GridColumn()
{
FieldName = "防火墙MAC", HorizontalHeaderContentAlignment = HorizontalAlignment.Center, Width = 180
});
LogData.Columns.Add(new GridColumn()
{
FieldName = "源IP地址", HorizontalHeaderContentAlignment = HorizontalAlignment.Center, Width = 130
});
LogData.Columns.Add(new GridColumn()
{
FieldName = "目标IP地址", HorizontalHeaderContentAlignment = HorizontalAlignment.Center, Width = 130
});
LogData.Columns.Add(new GridColumn()
{
FieldName = "承载数据的总长度", HorizontalHeaderContentAlignment = HorizontalAlignment.Center, Width = 130
});
LogData.Columns.Add(new GridColumn()
{
FieldName = "IP包头内的服务类型", HorizontalHeaderContentAlignment = HorizontalAlignment.Center, Width = 130
});
LogData.Columns.Add(new GridColumn()
{
FieldName = "服务类型的优先级", HorizontalHeaderContentAlignment = HorizontalAlignment.Center, Width = 130
});
LogData.Columns.Add(new GridColumn()
{
FieldName = "IP数据包标示", HorizontalHeaderContentAlignment = HorizontalAlignment.Center, Width = 130
});
LogData.Columns.Add(new GridColumn()
{
FieldName = "传输层协议类型", HorizontalHeaderContentAlignment = HorizontalAlignment.Center, Width = 130
});
LogData.Columns.Add(new GridColumn()
{
FieldName = "源端口号", HorizontalHeaderContentAlignment = HorizontalAlignment.Center, Width = 130
});
LogData.Columns.Add(new GridColumn()
{
FieldName = "目标端口号", HorizontalHeaderContentAlignment = HorizontalAlignment.Center, Width = 130
});
LogData.Columns.Add(new GridColumn()
{
FieldName = "处理状态", HorizontalHeaderContentAlignment = HorizontalAlignment.Center, Width = 130
});
LogData.Columns["时间"].EditSettings = editSettings1;
LogData.Columns["防火墙MAC"].EditSettings = editSettings2;
LogData.Columns["源IP地址"].EditSettings = editSettings2;
LogData.Columns["目标IP地址"].EditSettings = editSettings2;
LogData.Columns["承载数据的总长度"].EditSettings = editSettings2;
LogData.Columns["IP包头内的服务类型"].EditSettings = editSettings2;
LogData.Columns["服务类型的优先级"].EditSettings = editSettings2;
LogData.Columns["IP数据包标示"].EditSettings = editSettings2;
LogData.Columns["传输层协议类型"].EditSettings = editSettings2;
LogData.Columns["源端口号"].EditSettings = editSettings2;
LogData.Columns["目标端口号"].EditSettings = editSettings2;
LogData.Columns["处理状态"].EditSettings = editSettings2;
}
public object Convert(object value, Type targetType, object parameter, CultureInfo culture)
{
if (value == null)
{
return(null);
}
var column = (GridColumnVm)value;
object editor = null;
switch (column.GridColumnType)
{
case GridColumnType.String:
var editorTextEdit = new TextEditSettings();
editorTextEdit.TextWrapping = System.Windows.TextWrapping.WrapWithOverflow;
ReflectionUtils.SetProperty(editorTextEdit, "HorizontalContentAlignment", EditSettingsHorizontalAlignment.Center);
editor = editorTextEdit;
break;
case GridColumnType.Int:
case GridColumnType.Decimal:
var columnSetting = column.ColumnSetting as SpinColumnSetting;
var editor1 = new SpinEditSettings();
ReflectionUtils.SetProperty(editor1, "HorizontalContentAlignment", EditSettingsHorizontalAlignment.Right);
if (columnSetting != null)
{
editor1.Mask = columnSetting.Mask;
}
NumericMaskOptions.SetAlwaysShowDecimalSeparator(editor1, false);
editor1.MaskUseAsDisplayFormat = true;
editor = editor1;
break;
case GridColumnType.Date:
break;
case GridColumnType.DateTime:
var dateColumnSetting = column.ColumnSetting as DateColumnSetting;
var dateEditor = new DateEditSettings();
if (dateColumnSetting == null)
{
dateColumnSetting = new DateColumnSetting();
if (column.GridColumnType == GridColumnType.Date)
{
dateColumnSetting.Mask = "yyyy-MM-dd";
}
else
{
dateColumnSetting.Mask = "yyyy-MM-dd HH:mm:ss";
}
}
dateEditor.Mask = dateColumnSetting.Mask;
dateEditor.MaskUseAsDisplayFormat = true;
ReflectionUtils.SetProperty(dateEditor, "HorizontalContentAlignment", EditSettingsHorizontalAlignment.Left);
editor = dateEditor;
break;
case GridColumnType.Enum:
case GridColumnType.Combo:
var comboColumnSetting = column.ColumnSetting as ComboBoxColumnSetting;
if (comboColumnSetting == null)
{
editor = new TextEditSettings();
break;
}
var enumEditor = new ComboBoxEditSettings();
var comboBoxEditSettings = new ComboBoxEditSettings();
comboBoxEditSettings.ItemsSource = comboColumnSetting.ItemsSource;
comboBoxEditSettings.HorizontalContentAlignment = EditSettingsHorizontalAlignment.Center;
if (!string.IsNullOrWhiteSpace(comboBoxEditSettings.ValueMember))
{
comboBoxEditSettings.ValueMember = comboColumnSetting.ValueMember;
}
if (!string.IsNullOrWhiteSpace(comboBoxEditSettings.DisplayMember))
{
comboBoxEditSettings.DisplayMember = comboColumnSetting.DisplayMember;
}
editor = comboBoxEditSettings;
break;
case GridColumnType.Bool:
editor = new CheckEditSettings {
IsThreeState = false, NullValue = false
};
break;
default:
throw new ArgumentOutOfRangeException();
}
return(editor);
}
public FmIntSpinEditGridColumn()
{
EditSettings = new SpinEditSettings {
Mask = "N0"
};
}
