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