public static GridViewDataSpinEditColumn ApplyScheme(this GridViewDataSpinEditColumn source, ASPxSpinEditSceme spinEditSceme)
{
source.PropertiesSpinEdit.MinValue = 0;
source.PropertiesSpinEdit.Increment = 1;
source.PropertiesSpinEdit.NumberType = SpinEditNumberType.Float;
source.PropertiesSpinEdit.NumberFormat = SpinEditNumberFormat.Number;
source.PropertiesSpinEdit.DecimalPlaces = 2;
source.PropertiesSpinEdit.DisplayFormatInEditMode = true;
switch (spinEditSceme)
{
case ASPxSpinEditSceme.Numeric:
source.PropertiesSpinEdit.MaxValue = int.MaxValue;
source.PropertiesSpinEdit.LargeIncrement = 1000;
source.PropertiesSpinEdit.DisplayFormatString = "{0:n2}";
break;
case ASPxSpinEditSceme.Percent:
source.PropertiesSpinEdit.MaxValue = 100;
source.PropertiesSpinEdit.LargeIncrement = 10;
source.PropertiesSpinEdit.DisplayFormatString = "{0:n2}%";
break;
}
return(source);
}
private void CreateDateColumns(DateTime startDate, DateTime endDate)
{
DateTime currentDate = startDate;
while (currentDate <= endDate)
{
var yearBand = FindYearBandColumn(Grid.Columns, currentDate);
var monthBand = FindMonthBandColumn(yearBand.Columns, currentDate);
GridViewDataSpinEditColumn dayColumn = new GridViewDataSpinEditColumn()
{
FieldName = string.Format("{0}_{1}_{2}", currentDate.Year, currentDate.Month, currentDate.Day),
Caption = currentDate.Day.ToString(),
UnboundType = DevExpress.Data.UnboundColumnType.Decimal,
Width = Unit.Pixel(50)
};
monthBand.Columns.Add(dayColumn);
currentDate = currentDate.AddDays(1);
}
}
public void CrearColumnas(string strTipoDato, string strColumna, ASPxGridView grvGrilla, bool bolVisible, DataTable dtbCombo,
string strCampoClave, string strCampoTexto, string srEtiqueta, string strFormato)
{
switch (strTipoDato)
{
case "String":
// columna normal
GridViewDataTextColumn colText = new GridViewDataTextColumn();
colText.FieldName = strColumna;
colText.Visible = bolVisible;
//colText.Caption = srEtiqueta;
grvGrilla.Columns.Add(colText);
break;
case "Int32":
// columna normal
if (!bolVisible)
{
GridViewDataTextColumn colInt = new GridViewDataTextColumn();
colInt.FieldName = strColumna;
//colInt.Caption = srEtiqueta;
colInt.Visible = false;
grvGrilla.Columns.Add(colInt);
}
else
{
GridViewDataSpinEditColumn colInt1 = new GridViewDataSpinEditColumn();
colInt1.FieldName = strColumna;
//colInt1.Caption = srEtiqueta;
colInt1.Visible = bolVisible;
colInt1.PropertiesSpinEdit.SpinButtons.ShowIncrementButtons = false;
colInt1.PropertiesEdit.DisplayFormatString = "N0";
grvGrilla.Columns.Add(colInt1);
}
break;
case "Double":
GridViewDataSpinEditColumn colDouble = new GridViewDataSpinEditColumn();
colDouble.FieldName = strColumna;
//colDouble.Caption = srEtiqueta;
colDouble.Visible = bolVisible;
colDouble.PropertiesSpinEdit.SpinButtons.ShowIncrementButtons = false;
colDouble.PropertiesEdit.DisplayFormatString = "N4";
grvGrilla.Columns.Add(colDouble);
break;
case "Time":
GridViewDataTimeEditColumn colTime = new GridViewDataTimeEditColumn();
colTime.FieldName = strColumna;
//colTime.Caption = srEtiqueta;
colTime.Visible = bolVisible;
colTime.PropertiesTimeEdit.DisplayFormatString = "HH:mm";
colTime.PropertiesTimeEdit.EditFormat = EditFormat.Custom;
colTime.PropertiesTimeEdit.EditFormatString = "HH:mm";
colTime.PropertiesTimeEdit.SpinButtons.ShowIncrementButtons = false;
colTime.PropertiesTimeEdit.DisplayFormatInEditMode = true;
grvGrilla.Columns.Add(colTime);
break;
case "Date":
// columna normal
GridViewDataDateColumn colDate = new GridViewDataDateColumn();
colDate.FieldName = strColumna;
//colDate.Caption = srEtiqueta;
colDate.Visible = bolVisible;
colDate.PropertiesDateEdit.DisplayFormatString = "dd-MM-yyyy";
//colDate.PropertiesDateEdit.ValidationSettings.RequiredField.IsRequired = ValidationSettings.;
grvGrilla.Columns.Add(colDate);
break;
case "DateTime":
// columna normal
GridViewDataDateColumn colDateTime = new GridViewDataDateColumn();
colDateTime.FieldName = strColumna;
//colDateTime.Caption = srEtiqueta;
colDateTime.Visible = bolVisible;
colDateTime.PropertiesDateEdit.DisplayFormatString = "dd-MM-yyyy HH:mm";
grvGrilla.Columns.Add(colDateTime);
break;
case "ComboBox":
GridViewDataComboBoxColumn colCbo = new GridViewDataComboBoxColumn();
colCbo.FieldName = strColumna;
//colCbo.Caption = srEtiqueta;
colCbo.PropertiesComboBox.ValueType = typeof(int);
colCbo.PropertiesComboBox.ValueField = strCampoClave;
colCbo.PropertiesComboBox.TextField = strCampoTexto;
colCbo.PropertiesComboBox.TextFormatString = "{0}"; // imprime la columna con indice 0
//colCbo.PropertiesComboBox.EnableSynchronization = DevExpress.Utils.DefaultBoolean.True;
colCbo.PropertiesComboBox.DataSource = dtbCombo;
grvGrilla.Columns.Add(colCbo);
break;
}
}
