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