public static void AddColumnsSettingViewDataContacto(MVCxGridViewColumnCollection Columns, IEnumerable <CRM.Business.Views.BaseViews.BaseView.DynObject> model, HtmlHelper Html) { if (model.Count() == 0) { return; } foreach (var property in model.First().GetDynamicMemberNames()) { if (property.ToUpper().Trim() == "ID" || property.ToUpper().Trim() == "CODIGOCLIENTE" || property.ToUpper().Trim() == "ESTADO") { continue; } if (property.ToUpper().Trim() == "CODCLIENTE") { Columns.Add(column => { column.Caption = property; column.SetDataItemTemplateContent(container => { Html.DevExpress().HyperLink(hyperlink => { var visibleIndex = container.VisibleIndex; var keyValue = container.KeyValue; var lastName = DataBinder.Eval(container.DataItem, "CodCliente"); var codCliente = DataBinder.Eval(container.DataItem, "CodigoCliente"); hyperlink.Name = "hl" + keyValue.ToString(); hyperlink.Properties.Text = lastName.ToString(); hyperlink.NavigateUrl = DevExpressHelper.GetUrl(new { Controller = "Cliente", Action = "View", id = codCliente }); }).Render(); }); }); //var style = new DevExpress.Web.GridViewHeaderStyle(); // style.BackColor = System.Drawing.Color.LightGray; Columns[property].HeaderStyle.BackColor = System.Drawing.Color.LightGray; Columns[property].HeaderStyle.Font.Bold = true; ((MVCxGridViewColumn)Columns[property]).Settings.AutoFilterCondition = AutoFilterCondition.Contains; } else { Columns.Add(property); //var style = new DevExpress.Web.GridViewHeaderStyle(); // style.BackColor = System.Drawing.Color.LightGray; Columns[property].HeaderStyle.BackColor = System.Drawing.Color.LightGray; Columns[property].HeaderStyle.Font.Bold = true; ((MVCxGridViewColumn)Columns[property]).Settings.AutoFilterCondition = AutoFilterCondition.Contains; } //Columns.Add(property); } }
public static void AddModelToGrid <T>( this MVCxGridViewColumnCollection devExpCollection) { // you just need the T parameter, not a list typeof(T).GetProperties().ToList().ForEach((prop) => { DisplayAttribute displayName = null; var attributes = prop.GetCustomAttributes(true); foreach (var attribute in attributes) { if (attribute is DisplayAttribute) { displayName = (DisplayAttribute)attribute; } } string name = null; if (displayName != null) { name = displayName.Name; } else { name = prop.Name; } devExpCollection.Add(prop.Name, name); }); }
// create in grid(control) the child - column of current band private static void AddToGrid(AvrViewColumn obj, MVCxGridViewColumnCollection Columns, PdfExportHelper pdfHelper) { Columns.Add(column => { LayoutViewHelper.SetNewColumn(column, obj, pdfHelper); }); }
/// <summary> /// A traves del tipo de un viewModel se obtienen las propiedades y se las agregada a Columns /// solo aquellas que no tengan el decorador Invisible y a las agregadas se les cambiara el nombre /// si existe otro decorador que lo indique /// </summary> /// <param name="Columns"></param> /// <param name="type"></param> public static void AddColumnsSetting(MVCxGridViewColumnCollection Columns, Type type) { Type modelType = null; if (IsEntity(type)) { modelType = type; } else { modelType = type.GetGenericArguments().Where(t => t.BaseType.IsEquivalentTo(typeof(Business.Entities.BaseEntities.BaseEntity)) || (t.BaseType.BaseType != null && t.BaseType.BaseType.IsEquivalentTo(typeof(Business.Entities.BaseEntities.BaseEntity)))).FirstOrDefault(); } if (modelType == null) { return; } foreach (var property in modelType.GetProperties()) { if (modelType.Name == "Novedad" && property.Name == "NombreTipoNovedad") { continue; } // Si se configuro el modelo para descartar propiedades a agregar al gridview var attr = property.GetCustomAttributesData().FirstOrDefault(a => a.AttributeType.Name.Equals("InvisibleAttribute")); if (property.Name == "Id" || attr != null) { continue; } //attr = property.GetCustomAttributesData().FirstOrDefault(a => a.AttributeType.Name.Equals("ColumnNameGridViewAttribute")); if (!IsPropertyForRendered(property.Name)) { continue; } Columns.Add(property.Name); var style = new DevExpress.Web.GridViewHeaderStyle(); // style.BackColor = System.Drawing.Color.LightGray; Columns[property.Name].HeaderStyle.BackColor = System.Drawing.Color.LightGray; Columns[property.Name].HeaderStyle.Font.Bold = true; ((MVCxGridViewColumn)Columns[property.Name]).Settings.AutoFilterCondition = AutoFilterCondition.Contains; // Si se configuro el modelo para cambiar el nombre de la columna agregada attr = property.GetCustomAttributesData().FirstOrDefault(a => a.AttributeType.Name.Equals("ColumnNameGridViewAttribute")); if (attr != null) { var nameColumn = attr.NamedArguments.FirstOrDefault(a => a.MemberName.Equals("Name")).TypedValue.Value.ToString(); Columns[property.Name].Caption = nameColumn; } } }
static MVCxGridViewColumnCollection CreateExportedColumns() { var columns = new MVCxGridViewColumnCollection(); columns.Add("ProductCode"); columns.Add("Name"); columns.Add( c => { c.FieldName = "Price"; c.EditorProperties().SpinEdit(p => { p.DisplayFormatString = "c"; p.DisplayFormatInEditMode = true; }); }); columns.Add(c => { c.FieldName = "UnitID"; c.Caption = "Unit"; c.EditorProperties().ComboBox(p => { p.TextField = "Name"; p.ValueField = "UnitID"; p.ValueType = typeof(int); p.BindList(_unitService.GetAll()); }); }); columns.Add("Tax"); columns.Add("Description"); return(columns); }
public static void AddColumnsSettingViewData(MVCxGridViewColumnCollection Columns, IEnumerable <CRM.Business.Views.BaseViews.BaseViewString.DynObject> model) { if (model.Count() > 0) { foreach (var property in model.First().GetDynamicMemberNames()) { if (property.ToUpper().Trim() == "ID" || property.ToUpper().Trim() == "ESTADO") { continue; } if (property.ToUpper().Trim().Contains("FECHA")) { Columns.Add(column => { column.FieldName = property; column.Caption = property; column.ColumnType = MVCxGridViewColumnType.DateEdit; }); } else { Columns.Add(property); } if (property.ToUpper().Trim() == "DESCRIPCION") { Columns[property].Width = 350; } var style = new DevExpress.Web.GridViewHeaderStyle(); // style.BackColor = System.Drawing.Color.LightGray; Columns[property].HeaderStyle.BackColor = System.Drawing.Color.LightGray; Columns[property].HeaderStyle.Font.Bold = true; ((MVCxGridViewColumn)Columns[property]).Settings.AutoFilterCondition = AutoFilterCondition.Contains; } } }
public static void AddColumnsSettingViewDataPDF(MVCxGridViewColumnCollection Columns, IEnumerable <CRM.Business.Views.BaseViews.BaseViewString.DynObject> model, bool Export) { if (model.Count() > 0) { foreach (var property in model.First().GetDynamicMemberNames()) { if (property.ToUpper().Trim() == "ID") { continue; } if (Export) { if (!(property.Trim() == "Observaciones" || property.Trim() == "Cg_Cli" || property.Trim() == "Des_Cli")) { Columns.Add(property); var style = new DevExpress.Web.GridViewHeaderStyle(); // style.BackColor = System.Drawing.Color.LightGray; Columns[property].HeaderStyle.BackColor = System.Drawing.Color.LightGray; Columns[property].HeaderStyle.Font.Bold = true; if (property.Trim() == "CantidadPedida") { Columns[property].Caption = "Cant.\n Pedida"; } if (property.Trim() == "CantidadRecibida") { Columns[property].Caption = "Cant.\n Recibida"; } if (property.Trim() == "UnidadFac") { Columns[property].Caption = "Unidad\nFac"; } ((MVCxGridViewColumn)Columns[property]).Settings.AutoFilterCondition = AutoFilterCondition.Contains; } } } } }
public static void AddColumnsSettingViewData(MVCxGridViewColumnCollection Columns, IEnumerable <CRM.Business.Views.BaseViews.BaseView.DynObject> model) { if (model.Count() == 0) { return; } foreach (var property in model.First().GetDynamicMemberNames()) { if (property.ToUpper().Trim() == "ID" || property.ToUpper().Trim() == "ESTADO") { continue; } Columns.Add(property); var style = new DevExpress.Web.GridViewHeaderStyle(); // style.BackColor = System.Drawing.Color.LightGray; Columns[property].HeaderStyle.BackColor = System.Drawing.Color.LightGray; Columns[property].HeaderStyle.Font.Bold = true; ((MVCxGridViewColumn)Columns[property]).Settings.AutoFilterCondition = AutoFilterCondition.Contains; } }
public static void AddCustomColumnsSettingViewData(MVCxGridViewColumnCollection Columns, IEnumerable <CRM.Business.Views.BaseViews.BaseViewString.DynObject> model, HtmlHelper Html, bool IsAdminOperador) { if (model.Count() == 0) { return; } foreach (var property in model.First().GetDynamicMemberNames()) { if (property.ToUpper().Trim() == "ID" || property.ToUpper().Trim() == "DEVOL" || property.ToUpper().Trim() == "ESTADO" || property.ToUpper().Trim() == "HEXACOLOR" || property.ToUpper().Trim() == "DESCESTADO") { continue; } if (property.ToUpper().Trim() == "FECHASOLICITADARECEPCION" || property.ToUpper().Trim() == "FECHARECEPCION" || property.ToUpper().Trim() == "CONF_FECHA" || property.ToUpper().Trim() == "FE_RETIRO" || property.ToUpper().Trim() == "FECHAFINPRODUCCION") { Columns.Add(property).PropertiesEdit.DisplayFormatString = "dd/MM/yyyy"; /* Columns(property).FieldName = "AdmissionDate"; * Columns.Caption = "Admission Date"; * Columns.EditFormSettings.Visible = DefaultBoolean.True; * column.ColumnType = MVCxGridViewColumnType.DateEdit; * var dateProperties = column.PropertiesEdit as DateEditProperties; * dateProperties.AllowMouseWheel = true; * dateProperties.AllowUserInput = true; * dateProperties.ValidationSettings.ErrorDisplayMode = ErrorDisplayMode.ImageWithTooltip; */ } else { if (property.ToUpper().Trim() == "FECHAAUTORIZADARECEPCION") { if (IsAdminOperador) { Columns.Add(column => { column.FieldName = property; column.Caption = "Fecha Autorizada Recepcion"; column.ColumnType = MVCxGridViewColumnType.DateEdit; int count = 0; column.SetDataItemTemplateContent(container => { Html.DevExpress().DateEdit(settings => { var visibleIndex = container.VisibleIndex; //var keyValue = container.KeyValue; var keyValue = DataBinder.Eval(container.DataItem, "ID"); var fecha = DataBinder.Eval(container.DataItem, "FechaAutorizadaRecepcion"); settings.Width = System.Web.UI.WebControls.Unit.Pixel(90); settings.Name = "date" + keyValue.ToString() + count; if (fecha.ToString() != string.Empty) { settings.Date = Convert.ToDateTime(fecha); } settings.Properties.DisplayFormatString = "d"; settings.Properties.NullText = "dd/MM/yyyy"; settings.Properties.EditFormat = EditFormat.Custom; settings.Properties.EditFormatString = "dd/MM/yyyy"; settings.Properties.DisplayFormatString = "dd/MM/yyyy"; settings.Properties.ClientSideEvents.DateChanged = String.Format("function (s, e) {{ UpdatePedido(s, {0}); }}", Convert.ToInt32(keyValue)); count++; }).Render(); }); }); var style = new DevExpress.Web.GridViewHeaderStyle(); Columns[property].HeaderStyle.BackColor = System.Drawing.Color.LightGray; Columns[property].HeaderStyle.Font.Bold = true; } else { Columns.Add(property); } } else { if (property.ToUpper().Trim() == "CANTIDADENTREGADA" || property.ToUpper().Trim() == "CANTIDADRECIBIDA") { Columns.Add(property).PropertiesEdit.DisplayFormatString = "N0"; } else { Columns.Add(property); } } } Columns[property].CellStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center; Columns[property].HeaderStyle.BackColor = System.Drawing.Color.LightGray; Columns[property].HeaderStyle.Font.Bold = true; } }