public static GridViewSettings GetExportSettings(string itemsNames) { GridViewSettings gridVieewSettings = GetExportSettings(); if (!string.IsNullOrEmpty(itemsNames)) { string[] names = itemsNames.Split(';'); gridVieewSettings.SettingsExport.BeforeExport = (sender, e) => { MVCxGridView gridView = sender as MVCxGridView; if (sender == null) { return; } gridView.Columns.Clear(); foreach (var name in names) { if (string.IsNullOrEmpty(name)) { continue; } gridView.Columns.Add(new MVCxGridViewColumn(name)); } }; } return(gridVieewSettings); }
public GridViewSettings CreateAirGridViewSettings() { GridViewSettings settings = new GridViewSettings(); settings.Name = "All"; settings.Columns.Add("Master"); settings.Columns.Add("FileNo"); settings.Columns.Add("House"); settings.Columns.Add("Shipper"); settings.Columns.Add("Consignee"); settings.Columns.Add("Agent"); settings.Columns.Add("Carrier"); settings.Columns.Add("Origin"); settings.Columns.Add("Destination"); settings.Columns.Add("Quantity").PropertiesEdit.DisplayFormatString = "n"; settings.Columns.Add("Date").PropertiesEdit.DisplayFormatString = "d"; settings.Columns.Add(column => { column.FieldName = "Gros_Wt"; column.SetHeaderCaptionTemplateContent("Gros WT."); }); settings.Columns.Add("ChargeableWeight"); settings.Columns.Add(column => { column.FieldName = "ChargeableWeight"; column.SetHeaderCaptionTemplateContent("Chargeable WT."); }); settings.Columns.Add(column => { column.FieldName = "Freight_Charge"; column.SetHeaderCaptionTemplateContent("Freight Charge"); column.PropertiesEdit.DisplayFormatString = "c"; }); settings.Columns.Add(column => { column.FieldName = "Other_Charge"; column.SetHeaderCaptionTemplateContent("Other Charge"); column.PropertiesEdit.DisplayFormatString = "c"; }); settings.Settings.ShowFooter = true; settings.TotalSummary.Add(DevExpress.Data.SummaryItemType.Sum, "Gros_Wt"); settings.TotalSummary.Add(DevExpress.Data.SummaryItemType.Sum, "ChargeableWeight"); settings.TotalSummary.Add(DevExpress.Data.SummaryItemType.Sum, "Freight_Charge"); settings.TotalSummary.Add(DevExpress.Data.SummaryItemType.Sum, "Other_Charge"); settings.DataBound = (sender, e) => { MVCxGridView grid = (MVCxGridView)sender; string KeyFieldName = (string)Session["KeyFieldName"]; grid.GroupBy(grid.Columns[KeyFieldName]); }; return(settings); }
public static void SetHeaderColumnData(object sender, EventArgs e, string controller) { MVCxGridView gv = sender as MVCxGridView; gv.Visible = (gv.VisibleRowCount > 0); //CRM.Business.DAL.ListadoRepository listadoRepository = new CRM.Business.DAL.ListadoRepository(); //CRM.Business.DAL.PropiedadNavegacionListadoRepository propiedadNavegacionRepository = new CRM.Business.DAL.PropiedadNavegacionListadoRepository(); CRM.Business.Entities.Listado listado = AppSession.Listados.Where(x => x.Nombre.ToUpper().StartsWith(controller.ToUpper())).FirstOrDefault(); //listadoRepository.GetFiltered(x => x.Nombre.ToUpper().StartsWith(controller.ToUpper())).FirstOrDefault(); foreach (GridViewColumn column in gv.Columns) { var dataColumn = column as GridViewDataColumn; if (dataColumn != null && listado != null) { dataColumn.Settings.AutoFilterCondition = AutoFilterCondition.Contains; //if (propiedadNavegacionRepository.GetFiltered(x => x.Listado_Id == listado.Id && x.CampoFK.ToUpper().Equals(dataColumn.FieldName.ToUpper())).Any()) if (AppSession.PropiedadesNavegacion.Where(x => x.Listado_Id == listado.Id && x.CampoFK.ToUpper().Equals(dataColumn.FieldName.ToUpper())).Any()) { if (dataColumn.FieldName.ToUpper() == "CODIGOCLIENTE") { column.Caption = "Cliente"; } if (dataColumn.FieldName.ToUpper() == "PRO_COD") { column.Caption = "Producto"; } } } } }
public override void Configure(GridViewSettings settings, HtmlHelper html, ViewContext viewContext) { InitializeGridData(html, viewContext, AuditGridData, "CreateAudit", "UpdateAudits", "DeleteAudits"); // Popup form customization settings.SettingsPopup.EditForm.Modal = true; settings.SettingsPopup.EditForm.HorizontalAlign = PopupHorizontalAlign.Center; settings.SettingsPopup.EditForm.VerticalAlign = PopupVerticalAlign.WindowCenter; settings.SettingsPopup.EditForm.CloseOnEscape = AutoBoolean.True; settings.SettingsText.PopupEditFormCaption = "Add " + AuditName; //Master Grid Specific configurations settings.KeyFieldName = AuditGridData.Key; settings.Name = $"{AuditGridData.Name}"; settings.SettingsDetail.ShowDetailRow = false; settings.SettingsDetail.AllowOnlyOneMasterRowExpanded = false; settings.ClientSideEvents.BeginCallback = "function(s,e) {OnBeginCallback(s,e);}"; settings.ClientSideEvents.EndCallback = "function(s,e) {OnEndCallback(s,e);}"; //settings.ClientSideEvents.ToolbarItemClick = "function(s,e){e.processOnServer = false;}"; //Generic configurations AuditGridData.Title = Translate(AuditGridData.Title); settings.Styles.AlternatingRow.BackColor = System.Drawing.Color.Red; settings.Configure(AuditGridData, html, viewContext); var column = settings.Columns["Description"] as MVCxGridViewColumn; if (column != null) { column.EditorProperties().Memo(m => { m.Width = Unit.Percentage(100); m.Rows = 5; }); } settings.SettingsExport.BeforeExport = (sender, e) => { MVCxGridView gridView = sender as MVCxGridView; if (sender == null) { return; } gridView.Columns["OwnerId"].Visible = false; }; settings.CellEditorInitialize = (s, e) => { e.Editor.ReadOnly = false; }; settings.CommandColumn.Visible = false; SelectRow((int)(ViewData[AuditId] ?? 0), (string)(ViewData[AuditName] ?? string.Empty), ref settings); }
public static void SetCellData(object sender, ASPxGridViewTableDataCellEventArgs e, string controller) { MVCxGridView gv = sender as MVCxGridView; gv.Visible = (gv.VisibleRowCount > 0); //ListadoRepository listadoRepository = new ListadoRepository(); //PropiedadNavegacionListadoRepository propiedadNavegacionRepository = new PropiedadNavegacionListadoRepository(); Listado listado = AppSession.Listados.Where(x => x.Nombre.ToUpper().StartsWith(controller.ToUpper())).FirstOrDefault();//listadoRepository.GetFiltered(x => x.Nombre.ToUpper().StartsWith(controller.ToUpper())).FirstOrDefault(); vClientes vClientes = new Business.Views.vClientes(); foreach (GridViewColumn column in gv.Columns) { var dataColumn = column as GridViewDataColumn; if (dataColumn != null && listado != null) { //if (propiedadNavegacionRepository.GetFiltered(x => x.Listado_Id == listado.Id && x.CampoFK.ToUpper().Equals(e.DataColumn.FieldName.ToUpper())).Any()) if (AppSession.PropiedadesNavegacion.Where(x => x.Listado_Id == listado.Id && x.CampoFK.ToUpper().Equals(e.DataColumn.FieldName.ToUpper())).Any()) { if (e.DataColumn.FieldName.ToUpper() == "CODIGOCLIENTE") { int idCliente = Convert.ToInt32(e.CellValue); DataTable data = vClientes.GetByID(idCliente); if (data.Rows.Count > 0) { e.Cell.Text = "<a href='/Cliente/View/" + idCliente + "' title='Ver Cliente'>" + data.Rows[0]["Descripcion"].ToString() + "</a>"; } else { e.Cell.Text = "Cliente Inexistente"; } } if (e.DataColumn.FieldName.ToUpper() == "PRO_COD") { vProductos vProductos = new Business.Views.vProductos(); vProductos.Datos = vProductos.GetEmpyViewModel(); string idProducto = e.CellValue.ToString(); DataTable data = vProductos.GetByID(idProducto); if (data.Rows.Count > 0) { e.Cell.Text = "<a href='/Producto/View/" + idProducto + "' title='Ver Producto'>" + data.Rows[0]["Descripcion"].ToString() + "</a>"; } else { e.Cell.Text = "Producto Inexistente"; } } } } } }
public MVCxGridViewState(MVCxGridView gridView) { Columns = new GridViewDataColumnStateCollection(gridView.VisibleColumns); GroupedColumns = new GridViewDataColumnStateCollection(gridView.GetGroupedColumns()); TotalSummary = new System.Collections.ObjectModel.Collection <MVCxSummaryItemState>(); foreach (ASPxSummaryItem item in gridView.TotalSummary) { TotalSummary.Add(new MVCxSummaryItemState(item)); } FilterExpression = gridView.FilterExpression; }
public static void Grid_ClientLayout(object s, ASPxClientLayoutArgs e) { MVCxGridView grid = (MVCxGridView)s; var viewModel = GetModelFromSession(grid); if (e.LayoutMode == ClientLayoutMode.Saving && viewModel != null) { bool bSortChanged = false; foreach (GridViewColumn column in grid.AllColumns) { if (column is MVCxGridViewColumn) { MVCxGridViewColumn MVCcolumn = (MVCxGridViewColumn)column; var col = viewModel.ViewHeader.GetColumnByOriginalName(MVCcolumn.FieldName); if (col != null) { col.IsVisible = MVCcolumn.Visible; if ((!col.SortOrder.HasValue && MVCcolumn.SortIndex != -1) || (col.SortOrder.HasValue && col.SortOrder.Value != MVCcolumn.SortIndex) || (col.SortOrder.HasValue && col.IsSortAscending == (MVCcolumn.SortOrder == ColumnSortOrder.Descending)) ) { bSortChanged = true; } col.SortOrder = MVCcolumn.SortIndex; col.IsSortAscending = !(MVCcolumn.SortOrder == ColumnSortOrder.Descending); col.ColumnFilter = ((GridViewDataColumn)MVCcolumn).FilterExpression; col.ColumnWidth = MVCcolumn.Width.IsEmpty ? AvrView.DefaultFieldWidth : (int)MVCcolumn.Width.Value; } } else if (column is MVCxGridViewBandColumn) { MVCxGridViewBandColumn MVCband = (MVCxGridViewBandColumn)column; var band = viewModel.ViewHeader.GetBandByOriginalName(MVCband.Name); if (band != null) { band.IsVisible = MVCband.Visible; } } } if (bSortChanged) { viewModel.ViewHeader.GetAggregateColumnsList().ForEach(c => AggregateCasheWeb.FillAggregateColumn(viewModel.ViewData, c, viewModel.ViewHeader.GetSortExpression())); } } else { } }
public override void Configure(GridViewSettings settings, HtmlHelper html, ViewContext viewContext) { InitializeRigChecklistGridData(html, viewContext, GridDataChecklist, "CreateRigChecklist", "UpdateRigChecklist", "DeleteRigChecklist"); // Popup form customization settings.SettingsPopup.EditForm.Modal = true; settings.SettingsPopup.EditForm.HorizontalAlign = PopupHorizontalAlign.Center; settings.SettingsPopup.EditForm.VerticalAlign = PopupVerticalAlign.WindowCenter; settings.SettingsPopup.EditForm.CloseOnEscape = AutoBoolean.True; settings.SettingsText.PopupEditFormCaption = "Add " + RigChecklistName; //Master Grid Specific configurations settings.KeyFieldName = GridDataChecklist.Key; settings.Name = $"{GridDataChecklist.Name}"; settings.SettingsDetail.ShowDetailRow = false; settings.SettingsDetail.AllowOnlyOneMasterRowExpanded = false; //Generic configurations GridDataChecklist.Title = Translate(GridDataChecklist.Title); settings.Configure(GridDataChecklist, html, viewContext); var column = settings.Columns["Description"] as MVCxGridViewColumn; if (column != null) { column.EditorProperties().Memo(m => { m.Width = Unit.Percentage(100); m.Rows = 5; }); } settings.SettingsExport.BeforeExport = (sender, e) => { MVCxGridView gridView = sender as MVCxGridView; if (sender == null) { return; } gridView.Columns["OwnerId"].Visible = false; }; settings.CellEditorInitialize = (s, e) => { e.Editor.ReadOnly = false; }; settings.CommandColumn.Visible = false; SelectRow((int)(ViewData[RigChecklistId] ?? 0), (string)(ViewData[RigChecklistName] ?? string.Empty), ref settings); }
public override void Configure(GridViewSettings settings, HtmlHelper html, ViewContext viewContext) { InitializeRigChecklistGridData(html, viewContext, GridDataChecklist, "CreateProtocol", "UpdateProtocol", "DeleteProtocol"); //Master Grid Specific configurations settings.KeyFieldName = GridDataChecklist.Key; settings.Name = $"{GridDataChecklist.Name}"; settings.SettingsDetail.ShowDetailRow = false; settings.SettingsDetail.AllowOnlyOneMasterRowExpanded = false; if (!(bool)Session["isAuditIdClick"]) { GridDataChecklist.CallBackRoute = new { Area = "cOap", Controller = "OapProtocolsToAudit", Action = "DisplayProtocols", aId = ViewData["SelectedAuditId"] } } ; if ((bool)Session["isAuditIdClick"]) { settings.ClientSideEvents.EndCallback = "function (s,e){ refreshProtocolAssessorGrid(s,e);}"; } //Generic configurations GridDataChecklist.Title = Translate(GridDataChecklist.Title); settings.Configure(GridDataChecklist, html, viewContext); settings.CommandColumn.Visible = false; // Popup form customization settings.SettingsPopup.EditForm.Modal = true; settings.SettingsPopup.EditForm.HorizontalAlign = PopupHorizontalAlign.Center; settings.SettingsPopup.EditForm.VerticalAlign = PopupVerticalAlign.WindowCenter; settings.SettingsPopup.EditForm.CloseOnEscape = AutoBoolean.True; settings.SettingsText.PopupEditFormCaption = "Add Protocols To Audit"; settings.CellEditorInitialize = (s, e) => { e.Editor.ReadOnly = false; }; settings.SettingsExport.BeforeExport = (sender, e) => { MVCxGridView gridView = sender as MVCxGridView; if (sender == null) { return; } gridView.Columns["OwnerId"].Visible = false; }; }
public override void Configure(GridViewSettings settings, HtmlHelper html, ViewContext viewContext) { base.Configure(settings, html, viewContext); settings.CommandButtonInitialize = (sender, e) => { MVCxGridView gridView = (MVCxGridView)sender; bool.TryParse(gridView.GetRowValues(e.VisibleIndex, "IsAutoScheduled")?.ToString(), out bool isAutoScheduled); if (e.ButtonType == ColumnCommandButtonType.Delete && isAutoScheduled) { e.Visible = false; } }; }
public static void MakeColumnReadOnlyWhileEditing(object sender, ASPxGridViewEditorEventArgs e, string fieldName) { MVCxGridView grid = sender as MVCxGridView; if (grid.IsNewRowEditing) { return; } if (grid.IsEditing) { if (e.Column.FieldName.Equals(fieldName, StringComparison.OrdinalIgnoreCase) && (long)e.KeyValue > 0) { e.Editor.ClientEnabled = false; } } }
public GridViewSettings CreatePNLGridViewSettings() { GridViewSettings settings = new GridViewSettings(); settings.Name = "grid"; settings.SettingsPager.PageSize = 30; settings.Columns.Add("Customer_Name", "Customer").GroupIndex = GetGroupIndex("Customer_Name"); settings.Columns.Add("ImportExport", "Import/Export").GroupIndex = GetGroupIndex("ImportExport"); settings.Columns.Add("AirOcean", "Air/Ocean").GroupIndex = GetGroupIndex("AirOcean"); settings.Columns.Add("MBL_NUM", "MAWB/MBOL").GroupIndex = GetGroupIndex("MBL_NUM"); settings.Columns.Add("HBL_NUM", "HAWB/HBOL").GroupIndex = GetGroupIndex("HBL_NUM"); settings.Columns.Add("Date").GroupIndex = GetGroupIndex("Date"); settings.Columns.Add("Description", "Item").GroupIndex = GetGroupIndex("Description"); settings.Columns.Add("ORIGIN", "Origination").GroupIndex = GetGroupIndex("ORIGIN"); settings.Columns.Add("DEST", "Destination").GroupIndex = GetGroupIndex("DEST"); settings.Columns.Add("Revenue"); settings.Columns.Add("Expense"); settings.Columns.Add("Profit"); settings.Settings.ShowFooter = true; settings.TotalSummary.Add(DevExpress.Data.SummaryItemType.Sum, "Revenue"); settings.TotalSummary.Add(DevExpress.Data.SummaryItemType.Sum, "Expense"); settings.TotalSummary.Add(DevExpress.Data.SummaryItemType.Sum, "Profit"); settings.GroupSummary.Add(DevExpress.Data.SummaryItemType.Sum, "Revenue"); settings.GroupSummary.Add(DevExpress.Data.SummaryItemType.Sum, "Expense"); settings.GroupSummary.Add(DevExpress.Data.SummaryItemType.Sum, "Profit"); settings.Settings.ShowGroupPanel = true; settings.DataBound = (sender, e) => { MVCxGridView grid = (MVCxGridView)sender; ArrayList PNLGropuing = GetPNLGrouping(); for (int i = 0; i < PNLGropuing.Count; i++) { grid.GroupBy(grid.Columns[PNLGropuing[i].ToString()]); } grid.ExpandAll(); }; return(settings); }
public ActionResult GVFilterItemsCustomPartial(string Action, string FieldID) { var settings = GetGVFilterItemsSettings(); CustomFilterItem[] model = null; if (Action == "Close") { Session["GridDataSource"] = null; } else if (Action == "Show" && !string.IsNullOrEmpty(FieldID)) { model = ((Dictionary <string, CustomFilterItem[]>)Session["pivotFilterValues"])[FieldID]; Session["GridDataSource"] = model; settings.BeforeGetCallbackResult = (s, e) => { MVCxGridView gv = (MVCxGridView)s; gv.Selection.BeginSelection(); foreach (var item in model) { gv.Selection.SetSelectionByKey(item.Value, item.Selected); } gv.Selection.EndSelection(); gv.JSProperties["cpFieldID"] = FieldID; }; } else if (Action == "Invert") { model = (CustomFilterItem[])Session["GridDataSource"]; settings.BeforeGetCallbackResult = (s, e) => { MVCxGridView gv = (MVCxGridView)s; List <object> selectedValues = gv.GetSelectedFieldValues(new string[] { "Value" }); gv.Selection.SelectAll(); foreach (object val in selectedValues) { gv.Selection.UnselectRowByKey(val); } }; } ViewBag.GVFilterItemsSettings = settings; return(PartialView("_GridViewPartial", model)); }
public override void ConfigureExecution(GridViewSettings settings, HtmlHelper html, ViewContext viewContext) { base.ConfigureExecution(settings, html, viewContext); settings.SettingsBehavior.AllowSelectSingleRowOnly = true; settings.Settings.ShowGroupFooter = DevExpress.Web.GridViewGroupFooterMode.VisibleAlways; settings.SetGroupFooterRowTemplateContent(c => { var isPlanMonitoring = (bool)DataBinder.Eval(c.DataItem, "IsPlantMonitoring"); var subGroupText = (string)DataBinder.Eval(c.DataItem, "SubGroup"); var content = string.Empty; if (isPlanMonitoring) { var groupId = (int)DataBinder.Eval(c.DataItem, "GroupId"); html.RenderPartial("BarrierAuthorityRenderAssetsPartial", RigChecklist.Assets.ToGroupAssetModels(groupId, GetClient <OapChecklistAssetDataManagementClient>())); } }); settings.HtmlRowCreated = (sender, e) => { var isPlantMonitoringRow = (bool)(e.GetValue("IsPlantMonitoring") ?? false); if (e.RowType == DevExpress.Web.GridViewRowType.GroupFooter) { e.Row.Visible = isPlantMonitoringRow; } }; settings.BeforeGetCallbackResult = (sender, e) => { MVCxGridView grid = (MVCxGridView)sender; grid.ClearSort(); var i = grid.GroupCount; grid.GroupBy(grid.Columns["Group"]); grid.GroupBy(grid.Columns["SubGroup"]); }; }
public static GridViewSettings GetSettingExportWithoutId(IEnumerable <CRM.Business.Views.BaseViews.BaseViewString.DynObject> model, string controllerName) { GridViewSettings settings = new GridViewSettings(); settings.Name = "grid_" + controllerName; settings.CallbackRouteValues = new { Controller = controllerName, Action = "GridViewAllPartial" }; settings.Width = System.Web.UI.WebControls.Unit.Percentage(100); settings.SettingsSearchPanel.Visible = true; settings.SettingsBehavior.AllowFixedGroups = true; settings.SettingsBehavior.AllowDragDrop = true; settings.SettingsBehavior.AllowSort = true; settings.SettingsCookies.StoreFiltering = true; settings.SettingsCookies.StoreGroupingAndSorting = true; settings.SettingsCookies.StorePaging = true; settings.SettingsCookies.Enabled = true; settings.CustomJSProperties = (s, e) => { MVCxGridView gridView = (MVCxGridView)s; e.Properties["cpClientLayout"] = gridView.SaveClientLayout(); }; settings.CommandColumn.Visible = true; settings.Settings.UseFixedTableLayout = true; settings.CommandColumn.Width = 50; settings.CommandColumn.ShowClearFilterButton = true; //CheckBox en cada fila y checkbox general settings.CommandColumn.ShowSelectCheckbox = true; settings.CommandColumn.SelectAllCheckboxMode = GridViewSelectAllCheckBoxMode.Page; settings.CommandColumn.HeaderStyle.BackColor = System.Drawing.Color.Orange; settings.SettingsBehavior.ColumnResizeMode = ColumnResizeMode.Control; settings.Settings.ShowGroupPanel = true; settings.Settings.VerticalScrollBarMode = ScrollBarMode.Visible; settings.Settings.VerticalScrollableHeight = 300; settings.SettingsPager.Mode = GridViewPagerMode.ShowAllRecords; settings.SettingsPager.FirstPageButton.Visible = true; settings.SettingsPager.LastPageButton.Visible = true; settings.SettingsPager.PageSizeItemSettings.Visible = true; settings.SettingsPager.PageSizeItemSettings.Items = new string[] { "10", "20", "50" }; AddColumnsSettingViewData(settings.Columns, model); //AddColumnsSettingViewData(settings.Columns, model, null); settings.Settings.ShowFilterRow = true; settings.Settings.ShowFilterRowMenu = false; settings.DataBound = (sender, e) => { MVCxGridView gv = sender as MVCxGridView; gv.Visible = (gv.VisibleRowCount > 0); foreach (GridViewColumn column in gv.Columns) { var dataColumn = column as GridViewDataColumn; if (dataColumn != null) { dataColumn.Settings.AutoFilterCondition = AutoFilterCondition.Contains; } } }; settings.PreRender = (s, e) => { MVCxGridView grid = s as MVCxGridView; if (grid != null) { grid.ExpandAll(); } }; settings.SettingsDetail.ExportMode = GridViewDetailExportMode.Expanded; return(settings); }
public static void SetFilterRowVisibility(MVCxGridView grid, bool visible) { grid.Settings.ShowFilterRow = visible; }
public GridViewSettings CreateOceanGridViewSettings() { GridViewSettings settings = new GridViewSettings(); settings.Name = "All"; settings.Columns.Add("FileNo", "File#"); settings.Columns.Add("Master", "MBOL#"); settings.Columns.Add("House", "HBOL#"); settings.Columns.Add("Shipper"); settings.Columns.Add("Consignee"); settings.Columns.Add("Agent"); settings.Columns.Add("Carrier"); settings.Columns.Add("Origin"); settings.Columns.Add("Destination"); settings.Columns.Add("Date", "ETD"); settings.Columns.Add("Sale_Rep", "Sales Rep."); settings.Columns.Add("Processed_By", "Processed By"); settings.Columns.Add("Processed_By", "Processed By"); settings.Columns.Add(c => { c.FieldName = "Quantity"; c.Caption = ""; ((MVCxGridViewColumn)c).CellStyle.CssClass = "numeric"; }); settings.Columns.Add(c => { c.FieldName = "Gros_Wt"; c.Caption = "Gros Wt."; ((MVCxGridViewColumn)c).CellStyle.CssClass = "numeric"; }); settings.Columns.Add(c => { c.FieldName = "Measurement"; c.Caption = "Measurement (CBM)"; ((MVCxGridViewColumn)c).CellStyle.CssClass = "numeric"; }); settings.Columns.Add(c => { c.FieldName = "Freight_Charge"; c.Caption = "Freight Charge"; ((MVCxGridViewColumn)c).CellStyle.CssClass = "numeric"; }); settings.Columns.Add(c => { c.FieldName = "Other_Charge"; c.Caption = "Other Charge"; ((MVCxGridViewColumn)c).CellStyle.CssClass = "numeric"; }); settings.DataBound = (sender, e) => { MVCxGridView grid = (MVCxGridView)sender; string KeyFieldName = (string)Session["KeyFieldName"]; grid.GroupBy(grid.Columns[KeyFieldName]); }; return(settings); }
private static GridViewSettings GetSettingExport() { GridViewSettings settings = new GridViewSettings(); settings.Name = "grid_acontecimientos"; settings.CallbackRouteValues = new { Controller = "Acontecimientos", Action = "GridViewAllPartial" }; settings.Width = System.Web.UI.WebControls.Unit.Percentage(100); settings.SettingsSearchPanel.Visible = true; settings.SettingsBehavior.AllowFixedGroups = true; settings.SettingsBehavior.AllowDragDrop = true; settings.SettingsBehavior.AllowSort = true; settings.SettingsCookies.StoreFiltering = true; settings.SettingsCookies.StoreGroupingAndSorting = true; settings.SettingsCookies.StorePaging = true; settings.SettingsCookies.Enabled = true; settings.CustomJSProperties = (s, e) => { MVCxGridView gridView = (MVCxGridView)s; e.Properties["cpClientLayout"] = gridView.SaveClientLayout(); }; settings.CommandColumn.Visible = true; settings.Settings.UseFixedTableLayout = true; settings.CommandColumn.Width = 50; settings.CommandColumn.ShowClearFilterButton = true; //CheckBox en cada fila y checkbox general settings.CommandColumn.ShowSelectCheckbox = true; settings.CommandColumn.SelectAllCheckboxMode = GridViewSelectAllCheckBoxMode.Page; settings.CommandColumn.HeaderStyle.BackColor = System.Drawing.Color.Orange; //settings.SettingsBehavior.ColumnResizeMode = ColumnResizeMode.Control; settings.SettingsResizing.ColumnResizeMode = ColumnResizeMode.Control; settings.Settings.ShowGroupPanel = true; settings.Settings.VerticalScrollBarMode = ScrollBarMode.Visible; settings.Settings.VerticalScrollableHeight = 300; settings.SettingsPager.Mode = GridViewPagerMode.ShowAllRecords; settings.SettingsPager.FirstPageButton.Visible = true; settings.SettingsPager.LastPageButton.Visible = true; settings.SettingsPager.PageSizeItemSettings.Visible = true; settings.SettingsPager.PageSizeItemSettings.Items = new string[] { "10", "20", "50" }; settings.KeyFieldName = "Id"; settings.Columns.Add("Id"); settings.Columns.Add("Fecha Acont."); settings.Columns.Add("Descripcion"); settings.Columns.Add("TipoAcontecimiento"); settings.Columns.Add("Fecha Apertura "); settings.Columns.Add("Fecha Ocurrencia "); settings.Columns.Add("Fecha Implementacion "); settings.Columns.Add("Estado");; //Fila de filtros settings.Settings.ShowFilterRow = true; //Icono del menu del filtrado settings.Settings.ShowFilterRowMenu = false; //Setear por defecto la condicion de filtrado //de todas las columnas a Contains settings.DataBound = (sender, e) => { MVCxGridView gv = sender as MVCxGridView; gv.Visible = (gv.VisibleRowCount > 0); foreach (GridViewColumn column in gv.Columns) { var dataColumn = column as GridViewDataColumn; if (dataColumn != null) { dataColumn.Settings.AutoFilterCondition = AutoFilterCondition.Contains; } } }; settings.PreRender = (s, e) => { MVCxGridView grid = s as MVCxGridView; if (grid != null) { grid.ExpandAll(); } }; settings.SettingsDetail.ExportMode = GridViewDetailExportMode.Expanded; return(settings); }
public static GridViewSettings <TModel> GetGridViewReportSetting <TModel>(ECOM.Models.GridViewConfig gridConfig, bool IsExportData = true) { var gridViewSettings = new GridViewSettings <TModel>(); gridViewSettings.Name = gridConfig.GridViewName; gridViewSettings.KeyFieldName = gridConfig.KeyFieldName; gridViewSettings.SettingsPager.PageSize = gridConfig.PageSize; gridViewSettings.CallbackRouteValues = gridConfig.CallbackRouteValues; gridViewSettings.CustomActionRouteValues = gridConfig.CustomActionRouteValues; gridViewSettings.SettingsPager.Position = System.Web.UI.WebControls.PagerPosition.TopAndBottom; gridViewSettings.SettingsPager.FirstPageButton.Visible = true; gridViewSettings.SettingsPager.LastPageButton.Visible = true; gridViewSettings.SettingsPager.PageSizeItemSettings.Visible = true; gridViewSettings.Width = System.Web.UI.WebControls.Unit.Percentage(100); gridViewSettings.Height = System.Web.UI.WebControls.Unit.Percentage(100); gridViewSettings.SettingsBehavior.ColumnResizeMode = ColumnResizeMode.Control; gridViewSettings.CommandColumn.ShowClearFilterButton = true; gridViewSettings.Settings.ShowFilterRow = true; gridViewSettings.Settings.ShowFilterRowMenu = true; gridViewSettings.SettingsPager.PageSizeItemSettings.Items = new string[] { "10", "25", "50", "100" }; gridViewSettings.SettingsBehavior.AllowFocusedRow = true; //Selected Row gridViewSettings.Settings.HorizontalScrollBarMode = ScrollBarMode.Visible; gridViewSettings.ControlStyle.CssClass = "grid-view-custom"; //Menu Context Setting gridViewSettings.SettingsContextMenu.Enabled = true; gridViewSettings.SettingsBehavior.EnableCustomizationWindow = true; gridViewSettings.SettingsContextMenu.EnableRowMenu = DefaultBoolean.False; gridViewSettings.SettingsContextMenu.EnableFooterMenu = DefaultBoolean.False; gridViewSettings.SettingsContextMenu.EnableGroupPanelMenu = DefaultBoolean.False; gridViewSettings.SettingsPopup.CustomizationWindow.HorizontalAlign = PopupHorizontalAlign.LeftSides; gridViewSettings.SettingsPopup.CustomizationWindow.VerticalAlign = PopupVerticalAlign.Below; gridViewSettings.ContextMenuItemVisibility = (sender, e) => { // Custom menu context Item if (e.MenuType == GridViewContextMenuType.Columns) { foreach (var item in e.Items) { GridViewContextMenuItem menuItemDelete = item as GridViewContextMenuItem; if (menuItemDelete.Name == "GroupByColumn" || menuItemDelete.Name == "ShowGroupPanel" || menuItemDelete.Name == "ShowSearchPanel" || menuItemDelete.Name == "ShowFilterRow" || menuItemDelete.Name == "ShowFilterRowMenu" || menuItemDelete.Name == "ShowFooter" ) { e.SetVisible(menuItemDelete, false); } } } }; gridViewSettings.SettingsBehavior.EnableCustomizationWindow = true; gridViewSettings.CustomJSProperties = (sender, e) => { string separator = ","; string fieldNames = string.Empty; MVCxGridView grid = (MVCxGridView)sender; foreach (DevExpress.Web.GridViewColumn column in grid.VisibleColumns) { if (column is GridViewDataColumn) { GridViewDataColumn dataColumn = (GridViewDataColumn)column; if (!string.IsNullOrEmpty(dataColumn.FieldName) && dataColumn.Visible) { fieldNames += dataColumn.FieldName + ","; } } } fieldNames = fieldNames.TrimEnd(separator.ToCharArray()); e.Properties["cpFieldNames"] = fieldNames; }; //End menu context setting if (IsExportData == false) { gridViewSettings.Columns.Add(c => { c.UnboundType = DevExpress.Data.UnboundColumnType.String; c.Caption = ECOM.Resources.ECOMResource.Number; c.Settings.AllowAutoFilter = DefaultBoolean.False; c.Settings.AllowDragDrop = DefaultBoolean.False; c.Settings.AllowSort = DefaultBoolean.False; c.Width = 30; }); gridViewSettings.CustomColumnDisplayText = (s, e) => { if (e.Column.Caption == ECOM.Resources.ECOMResource.Number) { e.DisplayText = (e.VisibleRowIndex + 1).ToString(); } }; } foreach (var item in gridConfig.Columns.Where(x => x.Enable == true)) { MVCxGridViewColumn column = gridViewSettings.Columns.Add(); column.FieldName = item.ColumnName; column.Caption = item.DisplayText; //column.Visible = item.Enable; column.Visible = true; if (item.ColumnType == "System.DateTime" || item.ColumnType == "System.Date" || item.ColumnType.Contains("System.DateTime")) { if (!string.IsNullOrEmpty(item.ColumnFormat)) { column.PropertiesEdit.DisplayFormatString = item.ColumnFormat; } else { //Default is DateTime format column.PropertiesEdit.DisplayFormatString = ECOM.Resources.ECOMResource.ResourceManager.GetString("DefaultDateFormat"); } } if (item.ColumnType == "System.Decimal") { column.PropertiesEdit.DisplayFormatString = "N2"; } } return(gridViewSettings); }
static GridViewSettings CreateStationGridSettings() { EssoEntities DB2 = new EssoEntities(); GridViewSettings settings = new GridViewSettings(); settings.Name = "gvStation"; settings.KeyFieldName = "ID"; settings.CallbackRouteValues = new { Controller = "Station", Action = "GridStationPartial" }; settings.Width = Unit.Percentage(100); settings.InitNewRow += grid_InitNewRow; settings.SettingsEditing.Mode = GridViewEditingMode.EditForm; settings.SettingsEditing.AddNewRowRouteValues = new { Controller = "Station", Action = "SaveStation" }; settings.SettingsEditing.UpdateRowRouteValues = new { Controller = "Station", Action = "UpdateStation" }; settings.SettingsEditing.DeleteRowRouteValues = new { Controller = "Station", Action = "DeleteStation" }; settings.SettingsBehavior.ConfirmDelete = true; settings.SettingsBehavior.AllowGroup = true; settings.SettingsBehavior.AllowSort = true; settings.Settings.VerticalScrollBarMode = ScrollBarMode.Visible; settings.Settings.VerticalScrollableHeight = 500; settings.SettingsPager.PageSize = 20; settings.SettingsPager.Position = PagerPosition.Bottom; //settings.SettingsPager.FirstPageButton.Visible = true; //settings.SettingsPager.LastPageButton.Visible = true; //settings.SettingsPager.PageSizeItemSettings.Visible = true; //settings.SettingsPager.PageSizeItemSettings.Items = new string[] { "10", "20", "50" }; settings.Settings.ShowFilterRow = true; settings.Settings.ShowFilterRowMenu = true; settings.ClientSideEvents.BeginCallback = "OnStationBeginCallback"; //settings.Columns.Add(c => //{ // c.FieldName = "PHOTO"; // c.EditorProperties().BinaryImage(p => // { // p.ImageHeight = 170; // p.ImageWidth = 160; // p.EnableServerResize = true; // p.ImageSizeMode = ImageSizeMode.FitProportional; // p.CallbackRouteValues = new { Action = "BinaryImageColumnPhotoUpdate", Controller = "Station" }; // p.EditingSettings.Enabled = true; // p.EditingSettings.UploadSettings.UploadValidationSettings.MaxFileSize = 4194304; // }); //}); settings.Columns.Add(c => { c.FieldName = "NAME"; c.Caption = "Plant Name"; }); settings.Columns.Add(c => { c.FieldName = "SIZE"; c.Caption = "Size"; c.Width = Unit.Pixel(150); }); //settings.Columns.Add(c => //{ // c.FieldName = "NAME"; // c.Caption = "Group Name"; // c.Visible = false; // c.GroupIndex = 0; // c.EditFormSettings.Visible = DefaultBoolean.False; // c.EditorProperties().ComboBox(p => // { // p.BindList(DB2.StationGroups.Where(x => x.IS_DELETED == false).Select(x => x.NAME).ToList()); // }); //}); settings.Columns.Add(column => { column.FieldName = "GROUP_ID"; column.Caption = "Grup"; column.EditorProperties().ComboBox(p => { p.TextField = "NAME"; p.ValueField = "ID"; p.ValueType = typeof(int); p.DataSource = DB2.StationGroups.Where(x => x.IS_DELETED == false).Select(x => new { x.NAME, x.ID }).ToList(); }); }); //settings.Columns.Add(column => //{ // column.FieldName = "GROUP_ID"; // column.Caption = "Group"; // //column.GroupIndex = 0; // //column.EditFormSettings.Visible = DefaultBoolean.False; // //column.EditorProperties().ComboBox(p => // //{ // // p.BindList(DB2.StationGroups.Where(x => x.IS_DELETED == false).Select(x => x.NAME).ToList()); // //}); //}); settings.Columns.Add(column => { column.FieldName = "USERS"; column.Caption = "Users"; column.EditFormSettings.Visible = DefaultBoolean.False; }); settings.Columns.Add(column => { column.FieldName = "IP_ADDRESS"; column.Caption = "Ip Address"; }); settings.Columns.Add(column => { column.FieldName = "PORT"; column.Caption = "PORT"; }); settings.Columns.Add(column => { column.FieldName = "ALARM_TEMP_ID"; column.Caption = "Alarm Tipi"; column.Visible = false; column.EditFormSettings.Visible = DefaultBoolean.True; }); settings.Columns.Add(column => { column.FieldName = "IS_ACTIVE"; column.Caption = "Active"; column.Width = Unit.Pixel(50); column.ColumnType = MVCxGridViewColumnType.CheckBox; }); settings.Columns.Add(column => { column.FieldName = "IS_LOCKED"; column.Caption = "Locked"; column.Width = Unit.Pixel(50); column.ColumnType = MVCxGridViewColumnType.CheckBox; }); settings.Columns.Add(c => { c.FieldName = "INSTALL_DATE"; c.Caption = "Installation Date"; c.Width = Unit.Pixel(200); }); settings.Columns.Add(c => { c.FieldName = "CREATED_DATE"; c.Caption = "Inserted Date"; c.Width = Unit.Pixel(200); }); //"CREATED_DATE").SortOrder = DevExpress.Data.ColumnSortOrder.Ascending; settings.Columns.Add(column => { column.FieldName = "ADDRESS"; column.Caption = "Address"; column.EditFormSettings.Visible = DefaultBoolean.False; column.Visible = false; }); settings.Columns.Add(column => { column.FieldName = "DESCRIPTION"; column.Caption = "Desription"; column.EditFormSettings.Visible = DefaultBoolean.False; column.Visible = false; }); settings.Columns.Add(column => { column.FieldName = "PLC_INTERFACE"; column.Caption = "PLC INTERFACE"; column.EditFormSettings.Visible = DefaultBoolean.False; column.Visible = false; }); settings.Columns.Add(column => { column.FieldName = "EKK_INTERFACE"; column.Caption = "EKK INTERFACE"; column.EditFormSettings.Visible = DefaultBoolean.False; column.Visible = false; }); settings.Columns.Add(column => { column.FieldName = "IRRADIATION_SCALE"; column.Caption = "Irradiation Scale(%)"; column.EditFormSettings.Visible = DefaultBoolean.False; column.Visible = false; }); settings.BeforeGetCallbackResult = (sender, e) => { MVCxGridView grid = (MVCxGridView)sender; grid.GroupBy(grid.Columns["GROUP_ID"]); }; settings.PreRender = (sender, e) => { ASPxGridView grid = (ASPxGridView)sender; grid.ExpandRow(0); }; return(settings); }