public static void RepositoryItemSpinEdit(RepositoryItemSpinEdit se, string _format)
{
se.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
se.DisplayFormat.FormatString = _format;
se.EditFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
se.EditFormat.FormatString = _format;
}
protected override RepositoryItem OnCreateRepositoryItem(Type objectType)
{
var edit = new RepositoryItemSpinEdit();
WinFormPublic.AddClearButton(edit);
return(edit);
}
/// <summary>
/// 数值类型
/// </summary>
/// <param name="dateElement"></param>
/// <returns></returns>
private RepositoryItemSpinEdit SetRepositoryItemSpinEdit(DataElementEntity dateElement)
{
try
{
RepositoryItemSpinEdit repositoryItemSpinEdit = new RepositoryItemSpinEdit();
Dictionary <string, string> dicStrList = DataElementEntity.GetMaxMinDefStr(dateElement.ElementRange);
if (dicStrList == null || !dicStrList.ContainsKey("MaxValue") || !dicStrList.ContainsKey("MinValue"))
{
return(repositoryItemSpinEdit);
}
decimal maxValue;
decimal minValue;
bool ismax = Decimal.TryParse(dicStrList["MaxValue"], out maxValue);
bool ismin = Decimal.TryParse(dicStrList["MinValue"], out minValue);
if (ismax && ismin)
{
repositoryItemSpinEdit.MaxValue = maxValue;
repositoryItemSpinEdit.MinValue = minValue;
}
return(repositoryItemSpinEdit);
}
catch (Exception ex)
{
throw ex;
}
}
public static void AddSpinEditColumn(
this GridView gridView,
string fieldName,
string caption,
int width,
bool isAllowEdit = true,
string formatString = "#,###0",
SummaryItemType summaryType = SummaryItemType.None,
string summaryFormat = "",
KeyEventHandler keyDown = null)
{
RepositoryItemSpinEdit itemCtrl = new RepositoryItemSpinEdit();
itemCtrl.DisplayFormat.FormatString = formatString;
itemCtrl.DisplayFormat.FormatType = FormatType.Custom;
itemCtrl.EditFormat.FormatString = formatString;
itemCtrl.EditFormat.FormatType = FormatType.Custom;
itemCtrl.EditMask = formatString;
GridColumnSummaryItem summaryItem = new GridColumnSummaryItem();
if (summaryType != SummaryItemType.None)
{
summaryFormat = string.IsNullOrEmpty(summaryFormat) ? "{0: " + formatString + "}" : summaryFormat;
summaryItem = new GridColumnSummaryItem(summaryType, fieldName, summaryFormat);
}
if (keyDown != null)
{
itemCtrl.KeyDown += new KeyEventHandler(keyDown);
}
gridView.AddColumn(fieldName, caption, width, isAllowEdit, itemCtrl: itemCtrl, summaryItem: summaryItem);
}
private void EditableProgressBar()
{
editorForDisplay = new RepositoryItemProgressBar();
editorForEditing = new RepositoryItemSpinEdit();
gridView1.GridControl.RepositoryItems.AddRange(
new RepositoryItem[] { editorForDisplay, editorForEditing });
gridView1.Columns["Score"].ColumnEdit = editorForDisplay;
}
RepositoryItem IInplaceEditSupport.CreateRepositoryItem()
{
RepositoryItemSpinEdit item = new RepositoryItemSpinEdit();
item.MinValue = 0;
item.MaxValue = 5;
item.Mask.EditMask = "0";
return(item);
}
void InitialiseSpinEdit()
{
_itemSpinEdit = new RepositoryItemSpinEdit();
_itemSpinEdit.EditMask = "n2";
_itemSpinEdit.Mask.BeepOnError = true;
_itemSpinEdit.MinValue = 0m;
_itemSpinEdit.MaxValue = decimal.MaxValue;
_itemSpinEdit.Buttons.Clear();
_itemSpinEdit.BorderStyle = BorderStyles.NoBorder;
}
public test3()
{
InitializeComponent();
inplaceEditors = new RepositoryItem[] { riSpinEdit, riTextEdit, riCalcEdit };
editorForDisplay = new RepositoryItemProgressBar();
editorForEditing = new RepositoryItemSpinEdit();
gridView1.GridControl.RepositoryItems.AddRange(
new RepositoryItem[] { editorForDisplay, editorForEditing });
}
public MenuSpinCommand(string label)
{
this.repositoryItemSpinEdit = new RepositoryItemSpinEdit();
this.codon = null;
this.caller = null;
base.Edit = this.repositoryItemSpinEdit;
base.Name = this.codon.Id;
this.Width = 80;
this.Caption = StringParser.Parse(label);
this.repositoryItemSpinEdit.EditValueChanged += new EventHandler(repositoryItemSpinEdit_EditValueChanged);
}
public Main()
{
InitializeComponent();
recordBindingSource.DataSource = DataHelper.GetData(100, 10);
spinEdit = new RepositoryItemSpinEdit();
spinEdit.IsFloatValue = false;
gridView1.QueryCustomFunctions += OnQueryCustomFunctions;
gridView1.FilterEditorCreated += OnFilterEditorCreated;
gridView1.OptionsView.FilterCriteriaDisplayStyle = DevExpress.XtraEditors.FilterCriteriaDisplayStyle.Visual;
gridView1.OptionsFilter.DefaultFilterEditorView = DevExpress.XtraEditors.FilterEditorViewMode.TextAndVisual;
}
public void AddSpinEdit(string string_2, object object_0, bool bool_0, double double_0, double double_1)
{
this.repositoryItemSpinEdit_0 = new RepositoryItemSpinEdit();
this.gridEditorCollection_0.Add(this.repositoryItemSpinEdit_0, string_2, object_0);
this.repositoryItemSpinEdit_0.AutoHeight = false;
this.repositoryItemSpinEdit_0.BorderStyle = BorderStyles.NoBorder;
this.repositoryItemSpinEdit_0.Mask.MaskType = MaskType.Numeric;
this.repositoryItemSpinEdit_0.Name = "repositoryItemSpinEdit";
this.repositoryItemSpinEdit_0.ReadOnly = bool_0;
this.repositoryItemSpinEdit_0.MaxValue = (decimal)double_1;
this.repositoryItemSpinEdit_0.MinValue = (decimal)double_0;
}
/// <summary>
/// SpinEdit Cell을 만듭니다.(CustomRowCellEditForEditing Event에서만 사용합니다.)
/// </summary>
/// <returns></returns>
public static RepositoryItem MakeSpinEditCell()
{
RepositoryItemSpinEdit edit = new RepositoryItemSpinEdit();
edit.Appearance.Font = ControlConfig.DEFAULTFONT;
edit.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
//edit.Mask.EditMask = "n" + decimalPlace;
//edit.MaxLength = maxLength;
edit.Mask.UseMaskAsDisplayFormat = false;
return(edit);
}
public static RepositoryItemSpinEdit CreateTreeSpinEdit(this TreeListColumn treeColumn)
{
RepositoryItemSpinEdit repositoryItem = new RepositoryItemSpinEdit
{
Increment = decimal.One,
AutoHeight = false
};
treeColumn.TreeList.RepositoryItems.Add(repositoryItem);
treeColumn.ColumnEdit = repositoryItem;
return(repositoryItem);
}
/// <summary>
/// 创建GridView的列编辑为SpinEdit
/// </summary>
/// <param name="gridColumn">GridColumn列对象</param>
/// <returns></returns>
public static RepositoryItemSpinEdit CreateSpinEdit(this GridColumn gridColumn)
{
RepositoryItemSpinEdit repositoryItem = new RepositoryItemSpinEdit
{
Increment = decimal.One,
AutoHeight = false
};
gridColumn.View.GridControl.RepositoryItems.Add(repositoryItem);
gridColumn.ColumnEdit = repositoryItem;
return(repositoryItem);
}
RepositoryItemSpinEdit CreateSpinEdit(int minValue, int maxValue, int increment)
{
RepositoryItemSpinEdit editor = new RepositoryItemSpinEdit();
editor.AutoHeight = false;
editor.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.NoBorder;
editor.MinValue = minValue;
editor.MaxValue = maxValue;
editor.Increment = increment;
editor.IsFloatValue = false;
return(editor);
}
protected override void OnViewControlsCreated()
{
base.OnViewControlsCreated();
foreach (var pivotGridControl in GetPivotGridControl())
{
var repositoryItemSpinEdit = new RepositoryItemSpinEdit();
_repositoryItemSpinEdits.Add(pivotGridControl, repositoryItemSpinEdit);
pivotGridControl.RepositoryItems.Add(repositoryItemSpinEdit);
pivotGridControl.FieldAreaChanged += _pivotGridControl_FieldAreaChanged;
pivotGridControl.ShowingEditor += _pivotGridControl_ShowingEditor;
pivotGridControl.EditValueChanged += _pivotGridControl_EditValueChanged;
}
}
protected override void OnViewControlsCreated()
{
base.OnViewControlsCreated();
foreach (var pivotGridControl in GetPivotGridControl())
{
var repositoryItemSpinEdit = new RepositoryItemSpinEdit();
_repositoryItemSpinEdits.Add(pivotGridControl, repositoryItemSpinEdit);
pivotGridControl.RepositoryItems.Add(repositoryItemSpinEdit);
pivotGridControl.FieldAreaChanged += _pivotGridControl_FieldAreaChanged;
pivotGridControl.ShowingEditor += _pivotGridControl_ShowingEditor;
pivotGridControl.EditValueChanged += _pivotGridControl_EditValueChanged;
}
}
public RepositoryItemSpinEdit GetRepositoryItemSpinEdit(int precision)
{
var item = new RepositoryItemSpinEdit()
{
EditMask = (precision == 0) ? "D" : string.Format("F{0}", precision),
AllowFocused = true
};
item.DisplayFormat.FormatType = FormatType.Numeric;
item.DisplayFormat.FormatString = (precision == 0) ? "D" : string.Format("F{0}", precision);
item.AllowFocused = true;
return(item);
}
RepositoryItemSpinEdit GetSpinEdit(int minValue, int maxValue, int increment = 1)
{
var spinEdit = new RepositoryItemSpinEdit
{
IsFloatValue = false,
TextEditStyle = TextEditStyles.DisableTextEditor,
Increment = increment,
MinValue = minValue,
MaxValue = maxValue
};
return(spinEdit);
}
protected override void OnAnalysisEditorCreated(AnalysisEditorBase analysisEditorBase) {
base.OnAnalysisEditorCreated(analysisEditorBase);
var analysisEditorWin = ((AnalysisEditorWin)analysisEditorBase);
var pivotGridControl = analysisEditorWin.Control.PivotGrid;
_pivotGridControls.Add(pivotGridControl);
var repositoryItemSpinEdit = new RepositoryItemSpinEdit();
if (!_repositoryItemSpinEdits.ContainsKey(pivotGridControl))
_repositoryItemSpinEdits.Add(pivotGridControl, repositoryItemSpinEdit);
pivotGridControl.RepositoryItems.Add(repositoryItemSpinEdit);
pivotGridControl.FieldAreaChanged += _pivotGridControl_FieldAreaChanged;
pivotGridControl.ShowingEditor += _pivotGridControl_ShowingEditor;
pivotGridControl.CustomCellEditForEditing+=PivotGridControlOnCustomCellEditForEditing;
pivotGridControl.EditValueChanged += _pivotGridControl_EditValueChanged;
}
void PivotGridControlOnCustomCellEditForEditing(object sender, PivotCustomCellEditEventArgs e)
{
var focusedCell = ((PivotGridControl)sender).Cells.FocusedCell;
var modelRepositoryItemSpinEdits = _ruleCollector.RepositoryItems(focusedCell).ToArray();
if (modelRepositoryItemSpinEdits.Any())
{
var repositoryItemSpinEdit = new RepositoryItemSpinEdit();
e.RepositoryItem = repositoryItemSpinEdit;
foreach (var modelRepositoryItemSpinEdit in modelRepositoryItemSpinEdits)
{
new PivotDataFieldRepositoryItemSpinEditSynchronizer(repositoryItemSpinEdit, modelRepositoryItemSpinEdit).ApplyModel();
}
}
}
public MenuSpinCommand(Codon codon, object caller, bool createCommand)
{
this.repositoryItemSpinEdit = new RepositoryItemSpinEdit();
this.caller = caller;
this.codon = codon;
this.Width = 80;
base.Edit = this.repositoryItemSpinEdit;
base.Name = codon.Id;
this.repositoryItemSpinEdit.EditValueChanged += new EventHandler(repositoryItemSpinEdit_EditValueChanged);
this.UpdateText();
if (createCommand)
{
this.CreateCommand();
}
}
private void InitEditors()
{
RepositoryItemPictureEdit itemPictureEdit = new RepositoryItemPictureEdit();
RepositoryItemRadioGroup itemRadioGroup = new RepositoryItemRadioGroup();
RepositoryItemSpinEdit itemSpinEdit = new RepositoryItemSpinEdit();
RepositoryItemCalcEdit itemCalcEdit = new RepositoryItemCalcEdit();
RepositoryItemImageComboBox itemImageComboBox = new RepositoryItemImageComboBox();
itemPictureEdit.Name = "repositoryItemPictureEdit1";
itemSpinEdit.Name = "repositoryItemSpinEdit1";
itemCalcEdit.Name = "repositoryItemCalcEdit1";
itemRadioGroup.Name = "repositoryItemRadioGroup1";
itemImageComboBox.Name = "repositoryItemImageComboBox1";
itemImageComboBox.Items.AddRange(new object[] { new DevExpress.XtraEditors.Controls.ImageComboBoxItem("Sports", "SPORTS", -1), new DevExpress.XtraEditors.Controls.ImageComboBoxItem("Saloon", "SALOON", -1), new DevExpress.XtraEditors.Controls.ImageComboBoxItem("Truck", "TRUCK", -1)});
itemRadioGroup.Items.AddRange(new DevExpress.XtraEditors.Controls.RadioGroupItem[] { new DevExpress.XtraEditors.Controls.RadioGroupItem("Yes", "Yes"), new DevExpress.XtraEditors.Controls.RadioGroupItem("No", "No")});
this.gridControl1.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] { itemPictureEdit, itemRadioGroup, itemSpinEdit, itemCalcEdit, itemImageComboBox});
}
public PluginSettingsForm()
{
InitializeComponent();
textEditor = new RepositoryItemTextEdit();
boolEditor = new RepositoryItemCheckEdit();
decimalEditor = new RepositoryItemCalcEdit();
integerEditor = new RepositoryItemSpinEdit()
{
MinValue = 1, MaxValue = 10, IsFloatValue = false, EditMask = "D"
};
integerEditor.ParseEditValue += IntegerEditor_ParseEditValue;
colorEditor = new RepositoryItemColorPickEdit();
dateEditor = new RepositoryItemDateEdit();
gcSettings.RepositoryItems.AddRange(new RepositoryItem[] { textEditor, boolEditor, decimalEditor, integerEditor, colorEditor, dateEditor });
gvSettings.Columns["Value"].ColumnEdit = textEditor;
}
//스핀에디터 데이터 바인딩
private DevExpress.XtraEditors.Repository.RepositoryItemSpinEdit SetRepositoryItemSpinEditBindData(DevExpress.XtraGrid.GridControl gridControl, string fieldName, int maxValue)
{
string repositoryItemName = "repositoryItemSpinEdit";
RepositoryItemSpinEdit repositoryItemSpinEdit = gridControl.RepositoryItems[repositoryItemName + fieldName] as RepositoryItemSpinEdit;
//gridControl.BeginUpdate();
repositoryItemSpinEdit.MaxValue = maxValue;
repositoryItemSpinEdit.MinValue = 0;
repositoryItemSpinEdit.Increment = 1;
repositoryItemSpinEdit.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
//gridControl.EndUpdate();
return(repositoryItemSpinEdit);
}
void SpreadsheetControl_CustomCellEdit(object sender, XtraSpreadsheet.SpreadsheetCustomCellEditEventArgs e)
{
if (!e.ValueObject.IsText)
{
return;
}
var editorInfo = CellsHelper.FindEditor(e.ValueObject.TextValue);
if (editorInfo != null && e.RepositoryItem is RepositoryItemSpinEdit)
{
RepositoryItemSpinEdit repositoryItemSpinEdit = e.RepositoryItem as RepositoryItemSpinEdit;
repositoryItemSpinEdit.MinValue = editorInfo.MinValue;
repositoryItemSpinEdit.MaxValue = editorInfo.MaxValue;
repositoryItemSpinEdit.Increment = editorInfo.Increment;
repositoryItemSpinEdit.IsFloatValue = false;
}
}
private void spreadsheetControl1_CustomCellEdit(object sender, DevExpress.XtraSpreadsheet.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 repository item corresponding to a SpinEdit control and specify its settings.
RepositoryItemSpinEdit repository = new RepositoryItemSpinEdit();
repository.AutoHeight = false;
repository.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.NoBorder;
repository.MinValue = 1;
repository.MaxValue = 1000;
repository.IsFloatValue = false;
// Assign the SpinEdit editor to a cell.
e.RepositoryItem = repository;
}
}
public void ChangeItem(int int_0, ColumnAttribute columnAttribute_0, object object_0, double double_0,
double double_1)
{
GridEditorItem item = this.gridEditorCollection_0[int_0];
RepositoryItem repositoryItem = item.RepositoryItem;
if (columnAttribute_0 == ColumnAttribute.CA_COMBOBOX)
{
this.repositoryItemComboBox_0 = new RepositoryItemComboBox();
this.repositoryItemComboBox_0.AutoHeight = false;
this.repositoryItemComboBox_0.BorderStyle = BorderStyles.NoBorder;
for (int i = 0; i < ((IList)object_0).Count; i++)
{
this.repositoryItemComboBox_0.Items.Add(((IList)object_0)[i]);
}
this.repositoryItemComboBox_0.Name = "repositoryItemComboBox";
this.repositoryItemComboBox_0.ReadOnly = repositoryItem.ReadOnly;
item.RepositoryItem = this.repositoryItemComboBox_0;
}
else if (repositoryItem is RepositoryItemComboBox)
{
if (columnAttribute_0 == ColumnAttribute.CA_TEXTEDIT)
{
this.repositoryItemTextEdit_0 = new RepositoryItemTextEdit();
this.repositoryItemTextEdit_0.AutoHeight = false;
this.repositoryItemTextEdit_0.BorderStyle = BorderStyles.NoBorder;
this.repositoryItemTextEdit_0.Name = "repositoryItemTextEdit";
this.repositoryItemTextEdit_0.ReadOnly = repositoryItem.ReadOnly;
item.RepositoryItem = this.repositoryItemTextEdit_0;
}
else if (columnAttribute_0 == ColumnAttribute.CA_SPINEDIT)
{
this.repositoryItemSpinEdit_0 = new RepositoryItemSpinEdit();
this.repositoryItemSpinEdit_0.AutoHeight = false;
this.repositoryItemSpinEdit_0.BorderStyle = BorderStyles.NoBorder;
this.repositoryItemSpinEdit_0.Mask.MaskType = MaskType.Numeric;
this.repositoryItemSpinEdit_0.Name = "repositoryItemSpinEdit";
this.repositoryItemSpinEdit_0.ReadOnly = repositoryItem.ReadOnly;
this.repositoryItemSpinEdit_0.MaxValue = (decimal)double_1;
this.repositoryItemSpinEdit_0.MinValue = (decimal)double_0;
item.RepositoryItem = this.repositoryItemSpinEdit_0;
}
}
}
protected override void OnAnalysisEditorCreated(AnalysisEditorBase analysisEditorBase)
{
base.OnAnalysisEditorCreated(analysisEditorBase);
var analysisEditorWin = ((AnalysisEditorWin)analysisEditorBase);
var pivotGridControl = analysisEditorWin.Control.PivotGrid;
_pivotGridControls.Add(pivotGridControl);
var repositoryItemSpinEdit = new RepositoryItemSpinEdit();
if (!_repositoryItemSpinEdits.ContainsKey(pivotGridControl))
{
_repositoryItemSpinEdits.Add(pivotGridControl, repositoryItemSpinEdit);
}
pivotGridControl.RepositoryItems.Add(repositoryItemSpinEdit);
pivotGridControl.FieldAreaChanged += _pivotGridControl_FieldAreaChanged;
pivotGridControl.ShowingEditor += _pivotGridControl_ShowingEditor;
pivotGridControl.CustomCellEditForEditing += PivotGridControlOnCustomCellEditForEditing;
pivotGridControl.EditValueChanged += _pivotGridControl_EditValueChanged;
}
public static void Format(this RepositoryItemSpinEdit rspnMain, int DecimalScale = 0, bool LeftAlight = true, bool NotNegative = true)
{
rspnMain.Buttons.Clear();
rspnMain.Mask.UseMaskAsDisplayFormat = true;
rspnMain.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
rspnMain.AppearanceReadOnly.TextOptions.HAlignment = rspnMain.AppearanceFocused.TextOptions.HAlignment = rspnMain.Appearance.TextOptions.HAlignment = LeftAlight ? HorzAlignment.Near : HorzAlignment.Far;
rspnMain.Mask.EditMask = rspnMain.DisplayFormat.FormatString = rspnMain.EditFormat.FormatString = "N" + DecimalScale.ToString();
if (NotNegative)
{
rspnMain.KeyPress += NotNegative_KeyPress;
if (rspnMain.MinValue == rspnMain.MaxValue)
{
rspnMain.MaxValue = decimal.MaxValue;
}
if (rspnMain.MinValue < 0)
{
rspnMain.MinValue = 0;
}
}
}
public RepositoryItemSpinEdit GetRepositoryItemSpinEdit(int precision, int?bestFitWidth = null)
{
var formatString = (precision == 0) ? "D" : string.Format("F{0}", precision);
var edit = new RepositoryItemSpinEdit()
{
EditMask = formatString,
AllowFocused = true
};
edit.Appearance.TextOptions.HAlignment = HorzAlignment.Far;
edit.DisplayFormat.FormatType = FormatType.Numeric;
edit.DisplayFormat.FormatString = formatString;
edit.EditFormat.FormatType = FormatType.Numeric;
edit.EditFormat.FormatString = formatString;
edit.Mask.UseMaskAsDisplayFormat = true;
if (bestFitWidth != null)
{
edit.BestFitWidth = (int)bestFitWidth;
}
return(edit);
}
public RepositoryItemSpinEdit GetEmptyRepositoryItemSpinEdit()
{
var formatString = "N0";
var edit = new RepositoryItemSpinEdit()
{
EditMask = formatString,
AllowFocused = false,
ReadOnly = true
};
edit.Appearance.TextOptions.HAlignment = HorzAlignment.Far;
edit.DisplayFormat.FormatType = FormatType.Numeric;
edit.DisplayFormat.FormatString = formatString;
edit.EditFormat.FormatType = FormatType.Numeric;
edit.EditFormat.FormatString = formatString;
edit.Mask.UseMaskAsDisplayFormat = true;
edit.Buttons.Clear();
return(edit);
}
private void LoadView()
{
//BandedGridView view = bandedGridView1 as BandedGridView;
List<string> ValueFrom4 = GetValueFrom4();
List<string> ValueFrom3 = GetValueFrom3();
if (ValueFrom4 != null)
{
bandedGridView1.BeginUpdate(); //开始视图的编辑，防止触发其他事件
bandedGridView1.BeginDataUpdate(); //开始数据的编辑
bandedGridView1.Bands.Clear();
#region 修改附加选项
bandedGridView1.OptionsView.ShowColumnHeaders = false; //因为有Band列了，所以把ColumnHeader隐藏
bandedGridView1.OptionsView.ShowGroupPanel = false; //如果没必要分组，就把它去掉
bandedGridView1.OptionsView.EnableAppearanceEvenRow = false; //是否启用偶数行外观
bandedGridView1.OptionsView.EnableAppearanceOddRow = true; //是否启用奇数行外观
bandedGridView1.OptionsView.ShowFilterPanelMode = ShowFilterPanelMode.Never; //是否显示过滤面板
bandedGridView1.OptionsCustomization.AllowColumnMoving = false; //是否允许移动列
bandedGridView1.OptionsCustomization.AllowColumnResizing = false; //是否允许调整列宽
bandedGridView1.OptionsCustomization.AllowGroup = false; //是否允许分组
bandedGridView1.OptionsCustomization.AllowFilter = false; //是否允许过滤
bandedGridView1.OptionsCustomization.AllowSort = true; //是否允许排序
bandedGridView1.OptionsSelection.EnableAppearanceFocusedCell = true; //???
bandedGridView1.OptionsBehavior.Editable = true; //是否允许用户编辑单元格
//bandedGridView1.OptionsView.AllowCellMerge = true;
#endregion
#region 添加列标题
GridBand bandID = bandedGridView1.Bands.AddBand("ID");
bandID.Visible = false; //隐藏ID列
GridBand bandName = bandedGridView1.Bands.AddBand("需求项");
GridBand bandSystem1 = bandedGridView1.Bands.AddBand("第一系统/pcm");
GridBand bandSystem2 = bandedGridView1.Bands.AddBand("第二系统/pcm");
GridBand bandSystem3 = bandedGridView1.Bands.AddBand("非能动棒/pcm");
GridBand bandValue1 = bandSystem1.Children.AddBand("计算值");
GridBand bandError1 = bandSystem1.Children.AddBand("考虑的计算误差");
GridBand bandValue2 = bandSystem2.Children.AddBand("计算值");
GridBand bandError2 = bandSystem2.Children.AddBand("考虑的计算误差");
GridBand bandValue3 = bandSystem3.Children.AddBand("计算值");
GridBand bandError3 = bandSystem3.Children.AddBand("考虑的计算误差");
GridBand bandErrer = bandedGridView1.Bands.AddBand("最大计算误差");
#endregion
#region 列标题对齐方式
bandName.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandSystem1.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandSystem2.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandSystem3.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandValue1.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandError1.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandValue2.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandError2.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandValue3.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandError3.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
#endregion
List<Idata> datas = new List<Idata>();
datas.Add(new Idata(1, "温度效应(冷态到热态的反应性亏损)", ValueFrom4[0], "", "", "", "0", "0", "15%"));
datas.Add(new Idata(2, "功率效应", ValueFrom4[1], "", "", "", "", "", "25%"));
datas.Add(new Idata(3, "燃料循环后备反应性", ValueFrom4[2], "", "0", "0", "0", "0", "10%"));
datas.Add(new Idata(4, "超功率效应", (Convert.ToDouble(ValueFrom4[1]) * 0.1).ToString(), "0", "", "0", "0", "0", ""));
datas.Add(new Idata(5, "反应性引入事故", (Convert.ToDouble(ValueFrom4[3]) * 0.5).ToString(), "", "", "", "0", "0", "15%"));
datas.Add(new Idata(6, "临界和裂变材料装量不确定性相关的反应性", ValueFrom3[0], "0", "0", "0", "0", "0", ""));
double total6 = SubTotal(datas);
datas.Add(new Idata(7, "停堆深度要求", ValueFrom3[1], "0", "1000", "0", "0", "0", ""));
double total8 = SubTotal(datas);
datas.Add(new Idata(8, "合计（未考虑控制棒计算误差）", total8.ToString(), "", "", "", "", "", "15%"));
datas.Add(new Idata(9, "卡棒准则下停堆深度要求", ValueFrom3[2], "0", ValueFrom3[2], "0", "空", "空", ""));
double total10 = total6 + Convert.ToDouble(ValueFrom3[2]);
datas.Add(new Idata(10, "卡棒准则下合计（未考虑控制棒计算误差）", total10.ToString(), "", "", "", "空", "空", "15%"));
datas.Add(new Idata(11, "反应性价值最低要求（考虑控制棒计算误差）", (total8 / (1 - 0.15)).ToString(), (total8 / (1 - 0.15)).ToString(), "", "", "", "", ""));
datas.Add(new Idata(12, "卡棒准则下反应性价值最低要求（考虑控制棒计算误差）", (total10 / (1 - 0.15)).ToString(), (total10 / (1 - 0.15)).ToString(), "", "", "空", "空", ""));
this.gridControl1.DataSource = datas;
this.gridControl1.MainView.PopulateColumns();
#region 将标题列和数据列对应
bandedGridView1.Columns["Id"].OwnerBand = bandID;
bandedGridView1.Columns["Name"].OwnerBand = bandName;
bandedGridView1.Columns["Value1"].OwnerBand = bandValue1;
bandedGridView1.Columns["Error1"].OwnerBand = bandError1;
bandedGridView1.Columns["Value2"].OwnerBand = bandValue2;
bandedGridView1.Columns["Error2"].OwnerBand = bandError2;
bandedGridView1.Columns["Value3"].OwnerBand = bandValue3;
bandedGridView1.Columns["Error3"].OwnerBand = bandError3;
bandedGridView1.Columns["ErrorMax"].OwnerBand = bandErrer;
#endregion
#region 设置除最后一列之外的列都不可编辑
bandedGridView1.Columns["Name"].OptionsColumn.AllowEdit = false;
bandedGridView1.Columns["Value1"].OptionsColumn.AllowEdit = false;
bandedGridView1.Columns["Error1"].OptionsColumn.AllowEdit = false;
bandedGridView1.Columns["Value2"].OptionsColumn.AllowEdit = false;
bandedGridView1.Columns["Error2"].OptionsColumn.AllowEdit = false;
bandedGridView1.Columns["Value3"].OptionsColumn.AllowEdit = false;
bandedGridView1.Columns["Error3"].OptionsColumn.AllowEdit = false;
#endregion
bandedGridView1.EndDataUpdate();//结束数据的编辑
bandedGridView1.EndUpdate(); //结束视图的编辑
#region 绑定数据格式
RepositoryItemSpinEdit riSpin = new RepositoryItemSpinEdit();
RepositoryItemTextEdit riText = new RepositoryItemTextEdit();
gridControl1.RepositoryItems.Add(riSpin);
gridControl1.RepositoryItems.Add(riText);
bandedGridView1.Columns["Id"].ColumnEdit = riSpin;
bandedGridView1.Columns["Name"].ColumnEdit = riSpin;
bandedGridView1.Columns["Value1"].ColumnEdit = riSpin;
bandedGridView1.Columns["Error1"].ColumnEdit = riSpin;
bandedGridView1.Columns["Value2"].ColumnEdit = riSpin;
bandedGridView1.Columns["Error2"].ColumnEdit = riSpin;
bandedGridView1.Columns["Value3"].ColumnEdit = riSpin;
bandedGridView1.Columns["Error3"].ColumnEdit = riSpin;
bandedGridView1.Columns["ErrorMax"].ColumnEdit = riText;
#endregion
}
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit repositoryItemCheckEdit2;
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(FormNewMemberCreditPackageUsage));
DevExpress.XtraEditors.Repository.RepositoryItemTextEdit repositoryItemTextEdit1;
this.lkpEdtPackageCode = new DevExpress.XtraEditors.LookUpEdit();
this.label1 = new System.Windows.Forms.Label();
this.simpleButtonCancel = new DevExpress.XtraEditors.SimpleButton();
this.simpleButtonOK = new DevExpress.XtraEditors.SimpleButton();
this.label3 = new System.Windows.Forms.Label();
this.gridControl1 = new DevExpress.XtraGrid.GridControl();
this.gridView1 = new DevExpress.XtraGrid.Views.Grid.GridView();
this.gridColumn4 = new DevExpress.XtraGrid.Columns.GridColumn();
this.gridColumn1 = new DevExpress.XtraGrid.Columns.GridColumn();
this.Quantity = new DevExpress.XtraGrid.Columns.GridColumn();
this.repositoryItemSpinEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemSpinEdit();
this.gridColumn2 = new DevExpress.XtraGrid.Columns.GridColumn();
this.gridColumn3 = new DevExpress.XtraGrid.Columns.GridColumn();
this.gridView2 = new DevExpress.XtraGrid.Views.Grid.GridView();
this.checkedComboBoxEdit1 = new DevExpress.XtraEditors.CheckedComboBoxEdit();
repositoryItemCheckEdit2 = new DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit();
repositoryItemTextEdit1 = new DevExpress.XtraEditors.Repository.RepositoryItemTextEdit();
((System.ComponentModel.ISupportInitialize)(repositoryItemCheckEdit2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(repositoryItemTextEdit1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.lkpEdtPackageCode.Properties)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.gridControl1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.gridView1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemSpinEdit1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.gridView2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.checkedComboBoxEdit1.Properties)).BeginInit();
this.SuspendLayout();
//
// repositoryItemCheckEdit2
//
resources.ApplyResources(repositoryItemCheckEdit2, "repositoryItemCheckEdit2");
repositoryItemCheckEdit2.Name = "repositoryItemCheckEdit2";
//
// repositoryItemTextEdit1
//
resources.ApplyResources(repositoryItemTextEdit1, "repositoryItemTextEdit1");
repositoryItemTextEdit1.Name = "repositoryItemTextEdit1";
//
// lkpEdtPackageCode
//
resources.ApplyResources(this.lkpEdtPackageCode, "lkpEdtPackageCode");
this.lkpEdtPackageCode.Name = "lkpEdtPackageCode";
this.lkpEdtPackageCode.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton(((DevExpress.XtraEditors.Controls.ButtonPredefines)(resources.GetObject("lkpEdtPackageCode.Properties.Buttons"))))});
this.lkpEdtPackageCode.EditValueChanged += new System.EventHandler(this.lkpEdtPackageCode_EditValueChanged);
//
// label1
//
resources.ApplyResources(this.label1, "label1");
this.label1.Name = "label1";
//
// simpleButtonCancel
//
this.simpleButtonCancel.DialogResult = System.Windows.Forms.DialogResult.Cancel;
resources.ApplyResources(this.simpleButtonCancel, "simpleButtonCancel");
this.simpleButtonCancel.Name = "simpleButtonCancel";
//
// simpleButtonOK
//
this.simpleButtonOK.DialogResult = System.Windows.Forms.DialogResult.OK;
resources.ApplyResources(this.simpleButtonOK, "simpleButtonOK");
this.simpleButtonOK.Name = "simpleButtonOK";
this.simpleButtonOK.Click += new System.EventHandler(this.simpleButtonOK_Click);
//
// label3
//
resources.ApplyResources(this.label3, "label3");
this.label3.Name = "label3";
//
// gridControl1
//
resources.ApplyResources(this.gridControl1, "gridControl1");
this.gridControl1.MainView = this.gridView1;
this.gridControl1.Name = "gridControl1";
this.gridControl1.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] {
repositoryItemCheckEdit2,
repositoryItemTextEdit1,
this.repositoryItemSpinEdit1});
this.gridControl1.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] {
this.gridView1,
this.gridView2});
//
// gridView1
//
this.gridView1.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] {
this.gridColumn4,
this.gridColumn1,
this.Quantity,
this.gridColumn2,
this.gridColumn3});
this.gridView1.GridControl = this.gridControl1;
this.gridView1.Name = "gridView1";
this.gridView1.FocusedRowChanged += new DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventHandler(this.gridView1_FocusedRowChanged);
//
// gridColumn4
//
resources.ApplyResources(this.gridColumn4, "gridColumn4");
this.gridColumn4.ColumnEdit = repositoryItemCheckEdit2;
this.gridColumn4.FieldName = "Tick";
this.gridColumn4.Name = "gridColumn4";
//
// gridColumn1
//
resources.ApplyResources(this.gridColumn1, "gridColumn1");
this.gridColumn1.FieldName = "strPackageCode";
this.gridColumn1.Name = "gridColumn1";
this.gridColumn1.OptionsColumn.AllowEdit = false;
//
// Quantity
//
resources.ApplyResources(this.Quantity, "Quantity");
this.Quantity.ColumnEdit = this.repositoryItemSpinEdit1;
this.Quantity.FieldName = "nQuantity";
this.Quantity.Name = "Quantity";
//
// repositoryItemSpinEdit1
//
this.repositoryItemSpinEdit1.AllowNullInput = DevExpress.Utils.DefaultBoolean.False;
resources.ApplyResources(this.repositoryItemSpinEdit1, "repositoryItemSpinEdit1");
this.repositoryItemSpinEdit1.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton()});
this.repositoryItemSpinEdit1.IsFloatValue = false;
this.repositoryItemSpinEdit1.Mask.EditMask = resources.GetString("repositoryItemSpinEdit1.Mask.EditMask");
this.repositoryItemSpinEdit1.MaxValue = new decimal(new int[] {
100,
0,
0,
0});
this.repositoryItemSpinEdit1.MinValue = new decimal(new int[] {
1,
0,
0,
0});
this.repositoryItemSpinEdit1.Name = "repositoryItemSpinEdit1";
//
// gridColumn2
//
resources.ApplyResources(this.gridColumn2, "gridColumn2");
this.gridColumn2.FieldName = "strDescription";
this.gridColumn2.Name = "gridColumn2";
this.gridColumn2.OptionsColumn.AllowEdit = false;
//
// gridColumn3
//
resources.ApplyResources(this.gridColumn3, "gridColumn3");
this.gridColumn3.FieldName = "dtValidEnd";
this.gridColumn3.Name = "gridColumn3";
this.gridColumn3.OptionsColumn.AllowEdit = false;
//
// gridView2
//
this.gridView2.GridControl = this.gridControl1;
this.gridView2.Name = "gridView2";
//
// checkedComboBoxEdit1
//
resources.ApplyResources(this.checkedComboBoxEdit1, "checkedComboBoxEdit1");
this.checkedComboBoxEdit1.Name = "checkedComboBoxEdit1";
this.checkedComboBoxEdit1.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
new DevExpress.XtraEditors.Controls.EditorButton(((DevExpress.XtraEditors.Controls.ButtonPredefines)(resources.GetObject("checkedComboBoxEdit1.Properties.Buttons"))))});
//
// FormNewMemberCreditPackageUsage
//
this.AcceptButton = this.simpleButtonOK;
resources.ApplyResources(this, "$this");
this.CancelButton = this.simpleButtonCancel;
this.Controls.Add(this.checkedComboBoxEdit1);
this.Controls.Add(this.gridControl1);
this.Controls.Add(this.label3);
this.Controls.Add(this.simpleButtonCancel);
this.Controls.Add(this.simpleButtonOK);
this.Controls.Add(this.label1);
this.Controls.Add(this.lkpEdtPackageCode);
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedDialog;
this.MaximizeBox = false;
this.MinimizeBox = false;
this.Name = "FormNewMemberCreditPackageUsage";
this.ShowInTaskbar = false;
((System.ComponentModel.ISupportInitialize)(repositoryItemCheckEdit2)).EndInit();
((System.ComponentModel.ISupportInitialize)(repositoryItemTextEdit1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.lkpEdtPackageCode.Properties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.gridControl1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.gridView1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.repositoryItemSpinEdit1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.gridView2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.checkedComboBoxEdit1.Properties)).EndInit();
this.ResumeLayout(false);
}
static RepositoryItemSpinEdit SpinEdit()
{
RepositoryItemSpinEdit spinEdit = new RepositoryItemSpinEdit();
spinEdit.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
return spinEdit;
}
void grvParams_CustomRowCellEdit(object sender, DevExpress.XtraGrid.Views.Grid.CustomRowCellEditEventArgs e)
{
if (e.Column.FieldName != "Value") return;
var dr = this.grvParams.GetDataRow(e.RowHandle) as DataRow;
int iControlType = 0;
int.TryParse(dr["ControlType"].ToStringEx(), out iControlType);
var controlType = (ViewParameterControlType)iControlType;
RepositoryItem item = new RepositoryItemTextEdit();
switch (controlType)
{
case ViewParameterControlType.CheckEdit:
var temp = new RepositoryItemCheckEdit() { AllowGrayed = false };
item = temp;
break;
case ViewParameterControlType.ComboboxEdit:
item = new RepositoryItemGridSearchEdit();
break;
case ViewParameterControlType.FloatEdit:
item = new RepositoryItemSpinEdit() { IsFloatValue = true };
break;
case ViewParameterControlType.IntEdit:
item = new RepositoryItemSpinEdit() { IsFloatValue = false };
break;
case ViewParameterControlType.RichTextEdit:
item = new RepositoryItemMemoExEdit() { ShowIcon = false };
break;
case ViewParameterControlType.TextEdit:
item = new RepositoryItemTextEdit();
break;
default:
item = new RepositoryItemTextEdit();
break;
}
e.RepositoryItem = item;
}
//SoThapPhan = -1 Cho so nguyen
public static RepositoryItemSpinEdit GetSpinEdit(int SoThapPhan)
{
RepositoryItemSpinEdit _spinEdit = new RepositoryItemSpinEdit();
ApplyFormatAction.applyElement(_spinEdit, SoThapPhan);
return _spinEdit;
}
