private static GridViewSettings GetGridViewSettings(string name, DataTable dt) { var s = new GridViewSettings { Name = name }; foreach (DataColumn col in dt.Columns) { s.Columns.Add(col.ColumnName, col.Caption); } s.SettingsExport.RenderBrick = (sender, e) => { if (e.RowType == GridViewRowType.Data && e.VisibleIndex % 2 == 0) e.BrickStyle.BackColor = System.Drawing.Color.FromArgb(0xEE, 0xEE, 0xEE); var col = e.Column as GridViewDataColumn; if (IsDecimalValueColumn(name, col.FieldName)) { if (e.Value != null && e.Value.GetType() != typeof(DBNull)) { e.TextValue = Convert.ToDecimal(e.Value); e.TextValueFormatString = "#,###.00"; } } }; return s; }
public static GridViewSettings GetGridViewSetting() { var settings = new GridViewSettings(); settings.Name = "gvDataBinding"; settings.CallbackRouteValues = new { Controller = "GridDemo", Action = "Grid" }; settings.Width = System.Web.UI.WebControls.Unit.Percentage(100); settings.ClientSideEvents.Init = "grid_Init"; settings.ClientSideEvents.BeginCallback = "grid_BeginCallback"; settings.ClientSideEvents.EndCallback = "grid_EndCallback"; return settings; }
public static GridViewSettings TerminatedEmployeeGridViewExcelExportSettings(string CompanyName) { GridViewSettings gridviewSettings = new GridViewSettings(); gridviewSettings.Name = "TerminatedEmployeeReport"; // gridviewSettings.CallbackRouteValues = new { Controller = "Home", Action = "NewEmployeeReportGridView" }; gridviewSettings.KeyFieldName = "EmployeeId"; gridviewSettings.Columns.Add("EmployeeId").Caption = "Mã Nhân viên"; gridviewSettings.Columns.Add("FullName").Caption = "Họ tên"; gridviewSettings.Columns.Add(col => { col.FieldName = "Gender"; col.Caption = "Giới tính"; col.ColumnType = MVCxGridViewColumnType.ComboBox; ComboBoxProperties comboBoxPro = col.PropertiesEdit as ComboBoxProperties; comboBoxPro.DataSource = new SelectList(new[]{ new SelectListItem{Text = "Nam",Value=HNGHRMS.Model.Enums.Gender.Male.ToString()}, new SelectListItem{Text = "Nữ", Value=HNGHRMS.Model.Enums.Gender.Female.ToString()} }, "Value", "Text"); }); gridviewSettings.Columns.Add("Nationality").Caption = "Quốc tịch"; gridviewSettings.Columns.Add("CompanyName").Caption = "Công ty"; gridviewSettings.Columns.Add("PositionName").Caption = "Chức vụ"; gridviewSettings.Columns.Add("Departement").Caption = "Phòng ban"; gridviewSettings.Columns.Add(col => { col.FieldName = "JoinedDate"; col.Caption = "Ngày vào làm"; col.ColumnType = MVCxGridViewColumnType.DateEdit; col.PropertiesEdit.DisplayFormatString = "dd/MM/yyyy"; }); gridviewSettings.Columns.Add(col => { col.FieldName = "TerminationDate"; col.Caption = "Ngày thôi việc"; col.ColumnType = MVCxGridViewColumnType.DateEdit; col.PropertiesEdit.DisplayFormatString = "dd/MM/yyyy"; }); gridviewSettings.Columns.Add(col => { col.FieldName = "Salary"; col.Caption = "Mức lương"; col.PropertiesEdit.DisplayFormatString = "c0"; }); gridviewSettings.Columns.Add(col => { col.FieldName = "Reason"; col.Caption = "Lý do thôi việc"; }); return gridviewSettings; }
public override void Configure(GridViewSettings settings, HtmlHelper html, ViewContext viewContext) { InitializeGridData(GridData, "CreateChecklistTopic", "UpdateChecklistTopic", "DeleteChecklistTopic"); //Generic configurations settings.Configure(GridData, html, viewContext); settings.SettingsDetail.ShowDetailRow = true; settings.SettingsDetail.AllowOnlyOneMasterRowExpanded = false; settings.SetDetailRowTemplateContent(c => { var loapChecklistTopicName = (string)DataBinder.Eval(c.DataItem, GridData.DisplayColumnName); var loapChecklistTopicId = (int)DataBinder.Eval(c.DataItem, GridData.Key); ChildGridData.ToolBarOptions.SearchName = $"{ChildGridData.ToolBarOptions.SearchName}_{loapChecklistTopicId}"; if (!c.Grid.IsEditing && !c.Grid.IsNewRowEditing) { //Important to use RenderAction and Not Action todisplay the child grid rows html.RenderAction(ChildGridData.Action, ChildGridData.Controller, new { oapChecklistTopicId = loapChecklistTopicId, oapChecklistTopicName = loapChecklistTopicName }); } }); //settings.ClientSideEvents.FocusedRowChanged = "OnFindingsFocusedRowChanged"; int oapChecklistTopicId = (int)(ViewData[CurrentTopicId] ?? 0); string oapChecklistTopicName = (string)(ViewData[CurrentTopicName] ?? string.Empty); //Select the Current Row when it defined. if (oapChecklistTopicId != 0) { settings.Columns.Grid.Selection.SelectRowByKey(oapChecklistTopicId); } }
public static void SettingPaging(this GridViewSettings gridView, GridData gridData, PagerPosition position = PagerPosition.Bottom) { gridView.SettingsPager.Visible = gridData.ShowPager; if (gridData.ShowPager) { gridView.SettingsPager.Position = position; gridView.SettingsPager.FirstPageButton.Visible = true; gridView.SettingsPager.LastPageButton.Visible = true; gridView.SettingsPager.PageSizeItemSettings.Visible = true; gridView.SettingsPager.PageSizeItemSettings.ShowAllItem = true; gridView.SettingsPager.EllipsisMode = PagerEllipsisMode.InsideNumeric; gridView.SettingsPager.PageSizeItemSettings.ShowAllItem = true; gridView.SettingsPager.PageSizeItemSettings.Items = (gridData.PageSizes != null && gridData.PageSizes.Any()) ? gridData.PageSizes : DefaultPageSizeItems; gridView.SettingsPager.AlwaysShowPager = false; } else { gridView.SettingsPager.Mode = GridViewPagerMode.ShowAllRecords; } gridView.SettingsPager.EnableAdaptivity = true; }
public static GridViewSettings AddEditDeleteImportToolbar(this GridViewSettings settings, Action <MVCxGridViewToolbarItem> items) { settings.SettingsBehavior.AllowFocusedRow = true; settings.CommandColumn.ShowEditButton = false; settings.CommandColumn.ShowNewButtonInHeader = false; settings.CommandColumn.ShowDeleteButton = false; settings.CommandColumn.Visible = false; settings.SettingsBehavior.AllowFocusedRow = true; settings.Toolbars.Add(tb => { tb.Enabled = true; tb.Position = GridToolbarPosition.Top; tb.Items.Add(GridViewToolbarCommand.New); tb.Items.Add(GridViewToolbarCommand.Edit); tb.Items.Add(GridViewToolbarCommand.Delete); tb.Items.Add(items); }); return(settings); }
public static void SetSettings(GridViewSettings settings) { settings.SettingsEditing.Mode = GridViewEditingMode.EditFormAndDisplayRow; settings.SettingsBehavior.ConfirmDelete = true; settings.CommandColumn.Visible = true; settings.CommandColumn.ShowNewButton = false; settings.CommandColumn.ShowDeleteButton = true; settings.CommandColumn.ShowEditButton = true; settings.CommandColumn.ShowNewButtonInHeader = true; settings.KeyFieldName = "Id"; settings.SettingsPager.Visible = true; settings.SettingsPager.PageSize = 25; settings.Settings.ShowGroupPanel = false; settings.Settings.ShowFilterRow = false; settings.SettingsBehavior.AllowSelectByRowClick = false; settings.Settings.ShowHeaderFilterButton = true; settings.SettingsPopup.HeaderFilter.Height = 300; settings.SettingsPopup.HeaderFilter.SettingsAdaptivity.MinHeight = 300; settings.SettingsAdaptivity.AdaptivityMode = GridViewAdaptivityMode.Off; settings.SettingsAdaptivity.AdaptiveColumnPosition = GridViewAdaptiveColumnPosition.Right; settings.SettingsAdaptivity.AdaptiveDetailColumnCount = 1; settings.SettingsAdaptivity.AllowOnlyOneAdaptiveDetailExpanded = false; settings.SettingsAdaptivity.HideDataCellsAtWindowInnerWidth = 0; settings.CellEditorInitialize = (s, e) => { ((ASPxEdit)e.Editor).ValidationSettings.Display = Display.Dynamic; ((ASPxEdit)e.Editor).ValidationSettings.ErrorDisplayMode = ErrorDisplayMode.ImageWithText; }; }
public ActionResult ExportToExcel2(string Year, string Month) { var dt = GetData2(Year, Month); var settings = new GridViewSettings(); settings.Name = "GridView2"; settings.Styles.Header.BackColor = System.Drawing.ColorTranslator.FromHtml("#e9e9e9"); settings.Styles.Header.ForeColor = System.Drawing.ColorTranslator.FromHtml("#0076c2"); settings.Columns.Add( column => { column.FieldName = "BA04A_ID"; column.Caption = Resources.Resource.TYP_ID; column.EditorProperties().ComboBox( p => { p.TextField = "key"; p.ValueField = "value"; p.DataSource = ERP_V2.CacheCommonDataModule.GetBA04A(ERP_V2.UserInfo.LanguageType, false); }); }); settings.Columns.Add( column => { column.FieldName = "MonthTotal"; column.Caption = Resources.Resource.TOT_PR; column.EditorProperties().SpinEdit(s => { s.DisplayFormatString = "#,0"; }); }); return(GridViewExtension.ExportToXlsx(settings, dt, Year + Month + Resources.Resource.MonthTypePurchaseRatio, new XlsxExportOptionsEx { ExportType = DevExpress.Export.ExportType.WYSIWYG })); }
public ActionResult ExportTo(int MasterRowKey) { var ps = new PrintingSystemBase(); var link1 = new PrintableComponentLinkBase(ps); GridViewSettings categoriesGridSettings = new GridViewSettings(); categoriesGridSettings.Name = "gvCategories"; categoriesGridSettings.KeyFieldName = "CategoryID"; categoriesGridSettings.Columns.Add("CategoryID"); categoriesGridSettings.Columns.Add("CategoryName"); categoriesGridSettings.Columns.Add("Description"); link1.Component = GridViewExtension.CreatePrintableObject(categoriesGridSettings, MyModel.GetCategories()); var link2 = new PrintableComponentLinkBase(ps); GridViewSettings productsGridSettings = new GridViewSettings(); productsGridSettings.Name = "gvProducts"; productsGridSettings.KeyFieldName = "ProductID"; productsGridSettings.Columns.Add("ProductID"); productsGridSettings.Columns.Add("ProductName"); productsGridSettings.Columns.Add("CategoryID"); productsGridSettings.Columns.Add("UnitPrice"); link2.Component = GridViewExtension.CreatePrintableObject(productsGridSettings, MyModel.GetProducts(MasterRowKey)); var compositeLink = new CompositeLinkBase(ps); compositeLink.Links.AddRange(new object[] { link1, link2 }); compositeLink.CreateDocument(); FileStreamResult result = CreateExcelExportResult(compositeLink); ps.Dispose(); return(result); }
private static GridViewSettings CrearGridViewSettingsExportar(string titulo) { var settings = new GridViewSettings { Name = "Exportar", KeyFieldName = "Id", Caption = Strings.TituloRedesJur, CallbackRouteValues = new { Controller = "RedesJur", Action = "PartialGrid" } }; // Settings settings.SettingsExport.FileName = string.Format("{0}.xlsx", titulo); settings.SettingsExport.Styles.Default.Font.Name = "Segoe UI"; settings.SettingsExport.Styles.Default.Font.Size = 10; settings.SettingsPager.Visible = false; settings.ControlStyle.Paddings.Padding = Unit.Pixel(0); settings.ControlStyle.Border.BorderWidth = Unit.Pixel(0); settings.Styles.Header.HorizontalAlign = HorizontalAlign.Center; // Columnas settings.Columns.Add(col => { col.FieldName = "Dni"; col.Caption = Strings.ColDocumento; }); settings.Columns.Add(col => { col.FieldName = "Apellido"; col.Caption = "Apellido"; }); settings.Columns.Add(col => { col.FieldName = "Nombre"; col.Caption = "Nombre"; }); settings.Columns.Add(col => { col.FieldName = "Concepto"; col.Caption = Strings.ColConcepto; }); settings.Columns.Add(col => { col.FieldName = "Curso"; col.Caption = Strings.ColCurso; }); settings.Columns.Add(col => { col.FieldName = "NroCuota"; col.Caption = Strings.ColNroCuota; }); settings.Columns.Add(col => { col.FieldName = "TotalCuota"; col.Caption = Strings.ColTotalCuota; }); settings.Columns.Add(col => { col.FieldName = "Importe"; col.Caption = Strings.ColImporte; col.PropertiesEdit.DisplayFormatString = "c"; }); settings.Columns.Add(col => { col.FieldName = "fechavto"; col.Caption = Strings.ColFechaVto; col.PropertiesEdit.DisplayFormatString = "d"; }); settings.Columns.Add(col => { col.FieldName = "Importe2"; col.Caption = Strings.ColImporte2; col.PropertiesEdit.DisplayFormatString = "c"; }); settings.Columns.Add(col => { col.FieldName = "fechavto2"; col.Caption = Strings.ColFechaVto2; col.PropertiesEdit.DisplayFormatString = "d"; }); settings.Columns.Add(col => { col.FieldName = "fechaPago"; col.Caption = Strings.ColFechaPago; col.PropertiesEdit.DisplayFormatString = "d"; }); settings.Columns.Add(col => { col.FieldName = "EstadoDescripcion"; col.Caption = Strings.ColEstado; }); settings.Columns.Add(col => { col.FieldName = "fechaBaja"; col.Caption = Strings.ColFechaBaja; col.PropertiesEdit.DisplayFormatString = "d"; }); return(settings); }
public static void Configure(this GridViewSettings gridSettings, GridData gridData, HtmlHelper html, ViewContext viewContext, GridSettingOptions gridSettingOptions = null, params string[] arguments) { gridSettings.Width = Unit.Percentage(100); gridSettings.Height = Unit.Percentage(100); if (gridSettingOptions == null) { gridSettingOptions = new GridSettingOptions(); } gridSettings.Settings.HorizontalScrollBarMode = gridSettingOptions.HorizontalScrollBarMode; gridSettings.Settings.VerticalScrollBarMode = gridSettingOptions.VerticalScrollBarMode; if (gridSettingOptions.VerticalScrollableHeight.HasValue) { gridSettings.Settings.VerticalScrollableHeight = gridSettingOptions.VerticalScrollableHeight.Value; } //Grid Specific configurations gridSettings.KeyFieldName = gridData.Key; gridSettings.Name = $"{gridData.Name}"; gridSettings.Styles.Header.Wrap = DefaultBoolean.True; gridSettings.SettingsExport.EnableClientSideExportAPI = true; gridSettings.SettingsExport.ExcelExportMode = DevExpress.Export.ExportType.DataAware; if (gridSettingOptions.ShowTitle) { gridSettings.Settings.ShowTitlePanel = true; gridSettings.SettingsText.Title = gridData.Title; } else { gridSettings.Caption = gridData.Title; } if (gridData.GroupSetting != null) { gridSettings.SettingsBehavior.AutoExpandAllGroups = gridData.GroupSetting.AutoExpandAllGroups; gridSettings.SettingsBehavior.MergeGroupsMode = gridData.GroupSetting.GroupMode; if (gridData.GroupSetting.GroupFormatForMergedGroup != null) { gridSettings.Settings.GroupFormatForMergedGroup = gridData.GroupSetting.GroupFormatForMergedGroup; } if (gridData.GroupSetting.MergedGroupSeparator != null) { gridSettings.Settings.MergedGroupSeparator = gridData.GroupSetting.MergedGroupSeparator; } } gridSettings.Styles.AlternatingRow.BackColor = gridData.AlternateRowColor; #region Configure Toolbars if (gridData.ToolBarOptions.Show) { gridSettings.AddToolBar(html, viewContext, gridData); } #endregion #region Configure Columns foreach (var col in gridData.DisplayColumns.OrderBy(c => c.Order)) { if (col.ColumnAction != null) { gridSettings.Columns.Add(col.ColumnAction); var lcol = gridSettings.Columns[col.Name] as MVCxGridViewColumn; lcol.Hide(!col.IsVisible); continue; } MVCxGridViewColumn gcol = gridSettings.Columns.Add(col.Name, col.DisplayName, col.ColumnType); gcol.Set(col); } #endregion #region Configure Callback Route if (gridData.CallBackRoute != null) { gridSettings.CallbackRouteValues = gridData.CallBackRoute; } #endregion #region Configure Buttons foreach (var btn in gridData.Buttons) { gridSettings.AddButton(btn.Type, btn.Display); } #endregion if (gridData.ButtonOptions != null) { gridSettings.CommandColumn.Visible = gridData.ButtonOptions.Show; gridSettings.CommandColumn.ShowNewButtonInHeader = gridData.ButtonOptions.DisplayAddButtonInGridHeader; gridSettings.CommandColumn.ShowNewButton = gridData.ButtonOptions.DisplayAddButton; gridSettings.CommandColumn.ShowCancelButton = gridData.ButtonOptions.DisplayCancelButton; gridSettings.CommandColumn.ShowEditButton = gridData.ButtonOptions.DisplayEditButton; gridSettings.CommandColumn.ShowUpdateButton = gridData.ButtonOptions.DisplayUpdateButton; gridSettings.CommandColumn.ShowDeleteButton = gridData.ButtonOptions.DisplayDeleteButton; gridSettings.CommandColumn.Width = Unit.Percentage(gridData.ButtonOptions.Width); } gridSettings.CommandColumn.Width = 70; gridSettings.CommandColumn.Caption = " "; #region Configure Routes foreach (var route in gridData.Routes) { gridSettings.AddRoutes(route.Type, route.Route); } #endregion #region Configure Layout gridSettings.BuildEditLayout(gridData.FormLayout); #endregion gridSettings.SettingsBehavior.ConfirmDelete = true; gridSettings.SettingPaging(gridData); if (gridData.RowInitializeEvent != null) { gridSettings.InitNewRow = gridData.RowInitializeEvent; } if (gridData.RowEditEvent != null) { gridSettings.CellEditorInitialize = gridData.RowEditEvent; } //settings.SetupGlobalGridViewBehavior(); }
public ActionResult ExportToExcel1(string BA02A_ID, string DateBeg, string DateEnd) { DateTime.TryParse(DateBeg, out DateTime dateBeg); DateTime.TryParse(DateEnd, out DateTime dateEnd); var dt = GetData(BA02A_ID, dateBeg.ToString("yyyyMMdd"), dateEnd.ToString("yyyyMMdd")); var settings = new GridViewSettings(); settings.Name = "GridView"; settings.CallbackRouteValues = new { Controller = "RP01V2", Action = "GridView" }; settings.CustomActionRouteValues = new { Controller = "RP01V2", Action = "GridViewRefreshData" }; settings.ClientSideEvents.BeginCallback = "GridViewBegCallback"; settings.Styles.Header.BackColor = System.Drawing.ColorTranslator.FromHtml("#e9e9e9"); settings.Styles.Header.ForeColor = System.Drawing.ColorTranslator.FromHtml("#0076c2"); settings.Columns.Add( column => { column.FieldName = "PUR_NO"; column.Caption = Resources.Resource.TR01A_PUR_NO; }); settings.Columns.Add( column => { column.FieldName = "PUR_DT"; column.Caption = Resources.Resource.TR01A_PUR_DT; }); settings.Columns.Add( column => { column.FieldName = "ITM_NM"; column.Caption = Resources.Resource.BA02A_ITM_NM; }); settings.Columns.Add( column => { column.FieldName = "INC_NM"; column.Caption = Resources.Resource.BA01A_INC_NM; }); settings.Columns.Add( column => { column.FieldName = "PUR_PR"; column.Caption = Resources.Resource.EachPrice; column.EditorProperties().SpinEdit(s => { s.DecimalPlaces = 2; s.DisplayFormatString = "G29"; }); }); settings.Columns.Add( column => { column.FieldName = "Each_PR"; column.Caption = Resources.Resource.ReceiveMY; column.EditorProperties().SpinEdit(s => { s.DecimalPlaces = 2; s.DisplayFormatString = "G29"; }); }); settings.Columns.Add( column => { column.FieldName = "PUR_QT"; column.Caption = Resources.Resource.RP01_PUR_QT; column.EditorProperties().SpinEdit(s => { s.DecimalPlaces = 2; s.DisplayFormatString = "G29"; }); }); settings.Columns.Add( column => { column.FieldName = "TOT_QT"; column.Caption = Resources.Resource.TR01M_ARR_QT; column.EditorProperties().SpinEdit(s => { s.DecimalPlaces = 2; s.DisplayFormatString = "G29"; }); }); settings.Columns.Add( column => { column.FieldName = "DIF_QT"; column.UnboundType = DevExpress.Data.UnboundColumnType.Decimal; //column.UnboundExpression = "[PUR_QT]-[TOT_QT]"; column.Caption = Resources.Resource.NotEnoughQT; column.EditorProperties().SpinEdit(s => { //s.DisplayFormatString = "#,#.#"; s.DisplayFormatString = "G29"; }); }); settings.CustomUnboundColumnData = (s, e) => { if (e.Column.FieldName == "DIF_QT") { decimal PUR_QT = (decimal)e.GetListSourceFieldValue("PUR_QT"); decimal?TOT_QT = e.GetListSourceFieldValue("TOT_QT") as decimal?; if (!TOT_QT.HasValue) { TOT_QT = 0; } e.Value = PUR_QT - TOT_QT; } }; settings.HtmlDataCellPrepared = (s, e) => { if (e.DataColumn.FieldName == "TOT_QT") { var ss = s as MVCxGridView; var cellValue = ss.GetRowValues(e.VisibleIndex, "PUR_QT") as decimal?; var currentCell = e.CellValue as decimal?; if (cellValue.HasValue && currentCell.HasValue) { if (Decimal.Compare(cellValue.Value, currentCell.Value) != 0) { e.Cell.ForeColor = System.Drawing.Color.Red; } } } else if (e.DataColumn.FieldName == "DIF_QT") { var currentCell = e.CellValue as decimal?; if (currentCell.HasValue && currentCell.Value > 0) { e.Cell.ForeColor = System.Drawing.Color.Red; } } else if (e.DataColumn.FieldName == "Each_PR") { var ss = s as MVCxGridView; var cellValue = ss.GetRowValues(e.VisibleIndex, "PUR_PR") as decimal?; var currentCell = e.CellValue as decimal?; if (currentCell.HasValue) { if (Decimal.Compare(cellValue.Value, currentCell.Value) == 0) { e.Cell.ForeColor = System.Drawing.Color.Green; } else { e.Cell.ForeColor = System.Drawing.Color.Red; } } } }; return(GridViewExtension.ExportToXlsx(settings, dt, "商品採購紀錄", new XlsxExportOptionsEx { ExportType = DevExpress.Export.ExportType.WYSIWYG })); }
public static GridViewSettings GetGridSettings() { var settings = new GridViewSettings(); //settings.Name = "GridView"; //settings.CallbackRouteValues = new { Controller = "Home", Action = "OEEGridPartial" }; // Export-specific settings settings.SettingsExport.ExportSelectedRowsOnly = false; settings.SettingsExport.FileName = "OOE(设备综合效率表).xls"; settings.SettingsExport.PaperKind = System.Drawing.Printing.PaperKind.A4; //settings.Settings.ShowFooter = true; //settings.Settings.ShowGroupPanel = true; settings.SettingsExport.EnableClientSideExportAPI = true; settings.SettingsExport.ExcelExportMode = DevExpress.Export.ExportType.WYSIWYG; //settings.KeyFieldName = "ProductID"; //settings.Columns.Add("ProductName"); //settings.Columns.Add("UnitPrice").PropertiesEdit.DisplayFormatString = "c"; //settings.Columns.Add("QuantityPerUnit"); //settings.Columns.Add("Discontinued", MVCxGridViewColumnType.CheckBox); settings.Name = "OOE(设备综合效率表)"; settings.CallbackRouteValues = new { Controller = "Home", Action = "OEEGridPartial" }; settings.Width = Unit.Percentage(100); //settings.Columns.Add("UnitPrice").PropertiesEdit.DisplayFormatString = "c"; //settings.Columns.Add(c => { // c.FieldName = "Total"; // c.UnboundType = DevExpress.Data.UnboundColumnType.Decimal; // c.PropertiesEdit.DisplayFormatString = "c"; //}); settings.Columns.Add("Number", "工序号"); settings.Columns.Add("Equipment.Code", "设备编码"); settings.Columns.Add("Equipment.Name", "设备名称"); settings.Columns.Add(column => { column.FieldName = "FormatProduction"; column.Caption = "日产量"; column.UnboundType = DevExpress.Data.UnboundColumnType.String; }); settings.Columns.Add(column => { column.FieldName = "FormatRejects"; column.Caption = "不合格数量"; column.UnboundType = DevExpress.Data.UnboundColumnType.String; }); settings.Columns.Add("RunTime", "运行时间(秒)"); settings.Columns.Add("PlanHaltTime", "计划停机时间(秒)"); settings.Columns.Add(column => { column.FieldName = "FormatTheoreticallyMeter"; column.Caption = "理论节拍(秒每件)"; column.UnboundType = DevExpress.Data.UnboundColumnType.String; }); settings.Columns.Add("RateOfTimeMovement", "时间稼动率"); settings.Columns.Add("PerformanceYield", "性能稼动率"); settings.Columns.Add("Yield", "合格率"); settings.Columns.Add("GlobalPlantEfficiency", "全局设备效率"); //settings.Toolbars.Add(t => { // t.SettingsAdaptivity.Enabled = true; // t.SettingsAdaptivity.EnableCollapseRootItemsToIcons = true; // t.Items.Add(GridViewToolbarCommand.Refresh).Text = "刷新"; // t.Items.Add(GridViewToolbarCommand.ExportToXlsx).Text = "导出数据/打印"; //}); //settings.TotalSummary.Add(DevExpress.Data.SummaryItemType.Count, "CompanyName"); //settings.TotalSummary.Add(DevExpress.Data.SummaryItemType.Sum, "Total"); //settings.GroupSummary.Add(DevExpress.Data.SummaryItemType.Sum, "Total"); //settings.GroupSummary.Add(DevExpress.Data.SummaryItemType.Count, "CompanyName"); settings.CustomColumnDisplayText = (sender, e) => { if (e.Column.FieldName == "Yield") { e.DisplayText = ((decimal)e.Value).ToString("#.##"); } }; settings.CustomUnboundColumnData = (sender, e) => { if (e.Column.FieldName == "Total") { decimal price = (decimal)e.GetListSourceFieldValue("C"); int quantity = 10; e.Value = price * quantity; } if (e.Column.FieldName == "FormatProduction") { var production = (decimal)e.GetListSourceFieldValue("Production"); var unit = (Acme.Core.EquipmentManagement.Model.Procedure.ExpendUnitType)e.GetListSourceFieldValue("ConsumptionUnit"); var consumption = (decimal)e.GetListSourceFieldValue("Consumption"); e.Value = string.Format("{0:#.#}{1}:{2:#.}", consumption, unit.ToString(), production); } if (e.Column.FieldName == "FormatRejects") { var rejects = (decimal)e.GetListSourceFieldValue("Rejects"); var unit = (Acme.Core.EquipmentManagement.Model.Procedure.ExpendUnitType)e.GetListSourceFieldValue("ConsumptionUnit"); var consumption = (decimal)e.GetListSourceFieldValue("Consumption"); e.Value = string.Format("{0:#.#}{1}:{2:0.#}", consumption, unit.ToString(), rejects); } if (e.Column.FieldName == "FormatTheoreticallyMeter") { var theoreticallyMeter = (decimal)e.GetListSourceFieldValue("TheoreticallyMeter"); var unit = (Acme.Core.EquipmentManagement.Model.Procedure.ExpendUnitType)e.GetListSourceFieldValue("ConsumptionUnit"); var consumption = (decimal)e.GetListSourceFieldValue("Consumption"); e.Value = string.Format("{0:#.#}{1}:{2}", consumption, unit.ToString(), theoreticallyMeter); } }; settings.SettingsExport.RenderBrick = (sender, e) => { if (e.RowType == GridViewRowType.Data && e.VisibleIndex % 2 == 0) { e.BrickStyle.BackColor = System.Drawing.Color.FromArgb(0xEE, 0xEE, 0xEE); } }; settings.PreRender = (sender, e) => { ((MVCxGridView)sender).ExpandAll(); }; settings.EnablePagingGestures = AutoBoolean.False; settings.SettingsPager.EnableAdaptivity = true; settings.SettingsPager.PageSize = 10; settings.Styles.Header.Wrap = DefaultBoolean.True; settings.Styles.GroupPanel.CssClass = "GridNoWrapGroupPanel"; return(settings); }
public ActionResult ExportTo(GridViewSettings settings, object dataObject, bool saveAsFile, XlsxExportOptions exportOptions) { return(View()); }
/// <summary> /// Устанавливает настройки согласно модели данных. /// </summary> /// <param name="settings">Настройки.</param> /// <param name="html">Текущий html хелпер.</param> /// <param name="model">Модель данных.</param> public static void Apply <TGridModel>(this GridViewSettings settings, GridModelBase model, HtmlHelper <TGridModel> html) where TGridModel : GridModelBase { //!Филитры под датам отсюда https://demos.devexpress.com/MVCxGridViewDemos/Filtering/DateRangeHeaderFilter //здесь связь с другими контролами https://demos.devexpress.com/MVCxNavigationAndLayoutDemos/Panel/ResponsiveLayout html.EnableClientValidation(); settings.Name = model.GridName; settings.KeyFieldName = model.KeyFieldName; settings.CallbackRouteValues = new { Controller = model.ControllerName, Action = "GetGrid", parentID = model.ParentId }; //settings.ClientLayout += (sender, args) =>{};//TODO save layout settings.SettingsEditing.AddNewRowRouteValues = new { Controller = model.ControllerName, Action = "EditFormTemplateAddNewPartial", parentID = model.ParentId }; settings.SettingsEditing.UpdateRowRouteValues = new { Controller = model.ControllerName, Action = "EditFormTemplateUpdatePartial", parentID = model.ParentId }; settings.SettingsEditing.DeleteRowRouteValues = new { Controller = model.ControllerName, Action = "EditFormTemplateDeletePartial", entityId = "value", parentID = model.ParentId }; settings.CommandColumn.ButtonRenderMode = GridCommandButtonRenderMode.Link;//Пока оставить ссылкой, т.к. не все кнопки имеют картинку settings.SettingsCommandButton.EditButton.Image.IconID = IconID.EditEdit16x16; settings.SettingsCommandButton.NewButton.Image.IconID = IconID.ActionsNew16x16; settings.SettingsCommandButton.DeleteButton.Image.IconID = IconID.ActionsDelete16x16devav; settings.SettingsEditing.Mode = GridViewEditingMode.EditFormAndDisplayRow; settings.SettingsBehavior.ConfirmDelete = true; settings.Width = Unit.Percentage(100); settings.EnableRowsCache = false; settings.SettingsAdaptivity.AdaptivityMode = GridViewAdaptivityMode.HideDataCells; settings.SettingsAdaptivity.AllowOnlyOneAdaptiveDetailExpanded = true; settings.EditFormLayoutProperties.SettingsAdaptivity.AdaptivityMode = FormLayoutAdaptivityMode.SingleColumnWindowLimit; settings.EditFormLayoutProperties.SettingsAdaptivity.SwitchToSingleColumnAtWindowInnerWidth = 600; settings.CommandColumn.Visible = true; settings.CommandColumn.ShowNewButtonInHeader = true; settings.CommandColumn.ShowDeleteButton = true; settings.CommandColumn.ShowEditButton = true; settings.SettingsPager.Position = PagerPosition.TopAndBottom; 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.ClientLayout = (sender, args) => { if (args.LayoutMode == ClientLayoutMode.Saving) { RemontinkaServer.Instance.EntitiesFacade.SaveUserGridState(model.Token, model.GridName, args.LayoutData); } else if (args.LayoutMode == ClientLayoutMode.Loading) { args.LayoutData = RemontinkaServer.Instance.EntitiesFacade.GetGridUserState(model.Token, model.GridName); } }; settings.SetEditFormTemplateContent(container => { var formId = "editForm" + model.ControllerName; var controller = html.ViewContext.Controller as ICrudController; object objectToBind = container.DataItem; object gridEditModel = null; if (container.Grid.IsNewRowEditing) { objectToBind = controller.CreateNewModel(html.ViewData[model.GridObjectName], model); } else if (container.Grid.IsEditing) { gridEditModel = controller.PrepareUpdateEditModel( html.ViewData[model.GridObjectName] ?? container.DataItem, model); objectToBind = gridEditModel; } using (html.BeginForm("", "", FormMethod.Get, new { id = formId })) { html.DevExpress().FormLayout(formLayoutSettings => { formLayoutSettings.Name = "FormLayout" + model.ControllerName; formLayoutSettings.SetDefaultSettings(model.Token); if (container.Grid.IsNewRowEditing) { model.IsEditing = false; html.ViewContext.Writer.Write(html.Partial(controller.GetCreateViewName(), controller.CreateNewEditSettingsModel(formLayoutSettings, objectToBind, model, html))); } else if (container.Grid.IsEditing) { model.IsEditing = true; formLayoutSettings.Items.Add(item => { item.Name = model.KeyFieldName; item.ClientVisible = false; item.SetNestedContent(() => html.ViewContext.Writer.Write(html.Hidden(model.KeyFieldName).ToHtmlString())); }); html.ViewContext.Writer.Write(html.Partial(controller.GetUpdateViewName(), controller.CreateUpdateEditSettingsModel(formLayoutSettings, gridEditModel, model, html))); html.ViewData[model.GridObjectName] = gridEditModel; } formLayoutSettings.Items.AddEmptyItem(); formLayoutSettings.Items.Add(i => { i.ShowCaption = DefaultBoolean.False; }).SetNestedContent(() => { html.ViewContext.Writer.Write("<div style='float:right'>"); html.DevExpress().Button( btnSettings => { btnSettings.Name = "btnUpdate" + model.ControllerName; btnSettings.Text = "Сохранить"; btnSettings.ControlStyle.CssClass = "button"; btnSettings.ClientSideEvents.Click = string.Format("function(s, e){{ {0}.UpdateEdit(); }}", model.GridName); }).Render(); html.DevExpress().Button( btnSettings => { btnSettings.Name = "btnCancel" + model.ControllerName; btnSettings.Text = "Отменить"; btnSettings.ControlStyle.CssClass = "button"; btnSettings.Style[HtmlTextWriterStyle.MarginLeft] = "5px"; btnSettings.ClientSideEvents.Click = string.Format("function(s, e){{ {0}.CancelEdit(); }}", model.GridName); }).Render(); html.ViewContext.Writer.Write("</div>"); }); }) .Bind(objectToBind) .Render(); } }); }
public static void CancelButton(GridViewSettings settings, UrlHelper urlHelper) { settings.CommandColumn.CancelButton.Visible = true; settings.CommandColumn.CancelButton.Image.Url = urlHelper.Content("~/Content/images/cancel_32.png"); settings.CommandColumn.CancelButton.Image.ToolTip = "Otkaži"; }
public static void LoadMainGridViewSettings(GridViewSettings settings) { settings.Name = "MainGrid"; settings.KeyFieldName = "Id"; settings.Width = Unit.Percentage(100); int pageSize = 50; int.TryParse(Admin.DAL.Settings.Current["MainGrid.SettingsPager.PageSize"], out pageSize); settings.SettingsPager.PageSize = pageSize; settings.Settings.ShowFilterRow = true; settings.Settings.ShowFilterRowMenu = true; settings.CommandColumn.Visible = true; settings.CommandColumn.ClearFilterButton.Visible = true; settings.TotalSummary.Add(new ASPxSummaryItem("Id", SummaryItemType.Count)); settings.CommandColumn.ShowSelectCheckbox = true; settings.HtmlRowCreated += delegate(object sender, ASPxGridViewTableRowEventArgs args) { if (args.RowType == GridViewRowType.Data) { object isDeleted = null; try { isDeleted = args.GetValue("IsDeleted"); } catch { } if (isDeleted is bool && (bool) isDeleted) { args.Row.Style["background-color"] = "#FFFFCC"; args.Row.Attributes["isdeleted"] = "1"; } } }; settings.ClientSideEvents.SelectionChanged += string.Format(@" function SelectionChanged(s, e) {{ $('.dxgvDataRow[isdeleted=""1""]').css('background-color', '#FFFFCC'); }}"); }
private static GridViewSettings CreateExportGridViewSettings() { GridViewSettings settings = new GridViewSettings(); settings.Name = "Пример выгрузки"; settings.CallbackRouteValues = new { Controller = "DevExample", Action = "FilterRowPartial" }; settings.Columns.Add(column => { column.FieldName = "Date"; column.Caption = "Дата"; column.Width = Unit.Pixel(200); column.PropertiesEdit.DisplayFormatString = "d"; }); settings.Columns.Add("SupplierName").Caption = "Поставщик"; settings.Columns.Add(column => { column.FieldName = "CatalogName"; column.Caption = "Товар"; }); settings.Columns.Add("ProducerName").Caption = "Производитель"; settings.Columns.Add(column => { column.FieldName = "Cost"; column.Caption = "Цена"; column.PropertiesEdit.DisplayFormatString = "c"; }); settings.TotalSummary.Add(DevExpress.Data.SummaryItemType.Sum, "Cost").DisplayFormat = "c"; var sp = new ASPxSummaryItem("Cost", DevExpress.Data.SummaryItemType.Sum); sp.ShowInGroupFooterColumn = "Цена"; sp.DisplayFormat = "c"; settings.GroupSummary.Add(sp); settings.Columns.Add(column => { column.FieldName = "Quantity"; column.Caption = "Количество"; }); settings.TotalSummary.Add(DevExpress.Data.SummaryItemType.Sum, "Quantity").ShowInGroupFooterColumn = "Ед."; var sm = new ASPxSummaryItem("Quantity", DevExpress.Data.SummaryItemType.Sum); sm.ShowInGroupFooterColumn = "Приход"; settings.GroupSummary.Add(sm); settings.Settings.ShowGroupFooter = GridViewGroupFooterMode.VisibleAlways; settings.Settings.ShowGroupPanel = true; settings.Settings.ShowFooter = true; settings.Settings.VerticalScrollableHeight = 500; settings.SettingsPager.PageSize = 100; settings.SettingsSearchPanel.Visible = true; settings.SettingsPager.Position = PagerPosition.TopAndBottom; settings.SettingsPager.FirstPageButton.Visible = true; settings.SettingsPager.LastPageButton.Visible = true; settings.SettingsPager.PageSizeItemSettings.Visible = true; settings.SettingsPager.PageSizeItemSettings.Items = new string[] { "10", "20", "50", "100", "150", "200" }; return(settings); }
public ActionResult MBHBillingPeriodCommitAndExport(DateTime period) { var data = repository.GetMHBExportItems(period, null); var s = new GridViewSettings { Name = "gvMBHBilling" }; //s.KeyFieldName = "ID"; s.SettingsBehavior.AllowSort = false; s.SettingsBehavior.AllowGroup = false; s.SettingsBehavior.AllowFocusedRow = false; s.SettingsBehavior.AllowSelectSingleRowOnly = true; s.Settings.ShowFilterRow = false; //s.CallbackRouteValues = new { Action = "PayrollGridCallback" }; s.SettingsExport.ExportSelectedRowsOnly = false; s.SettingsExport.FileName = "MBH-Billing_" + DateTime.Now.ToString("yyyy-MM-dd") + ".xlsx"; s.Columns.Add(col => { col.Name = "colPatientID"; col.FieldName = "PatientID"; col.Caption = "Patient ID"; }); s.Columns.Add(col => { col.Name = "colProviderID"; col.FieldName = "ProviderID"; col.Caption = "Provider ID"; }); s.Columns.Add("AuthorizedProviderID"); s.Columns.Add(col => { col.Name = "colSupervisingBCBAID"; col.FieldName = "SupervisingBCBAID"; col.Caption = "Supervising BCBA ID"; }); s.Columns.Add(col => { col.Name = "colIsBCBATimesheet"; col.FieldName = "IsBCBATimesheet"; col.Caption = "Is BCBA Timesheet"; }); s.Columns.Add(col => { col.Name = "colDateOfService"; col.FieldName = "DateOfService"; col.Caption = "Date Of Service"; }); s.Columns.Add(col => { col.Name = "colStartTime"; col.FieldName = "StartTime"; col.Caption = "Start Time"; col.PropertiesEdit.DisplayFormatString = "t"; }); s.Columns.Add(col => { col.Name = "colEndTime"; col.FieldName = "EndTime"; col.Caption = "End Time"; col.PropertiesEdit.DisplayFormatString = "t"; }); s.Columns.Add(col => { col.Name = "colTotalTime"; col.FieldName = "TotalTime"; col.Caption = "Total Time"; }); s.Columns.Add(col => { col.Name = "colServiceCode"; col.FieldName = "ServiceCode"; col.Caption = "Service Code"; }); s.Columns.Add(col => { col.Name = "colPlaceOfService"; col.FieldName = "PlaceOfService"; col.Caption = "Place Of Service"; }); s.Columns.Add(col => { col.Name = "colPlaceOfServiceID"; col.FieldName = "PlaceOfServiceID"; col.Caption = "Place Of Service ID"; }); repository.CommitMHBPeriodExport(period); try { return(GridViewExtension.ExportToXlsx(s, data)); } catch (Exception e) { Exceptions.Handle(e, Global.GetWebInfo()); throw e; } }
static GridViewSettings CreateCompanyGridSettings() { GridViewSettings settings = new GridViewSettings(); settings.Name = "gvCompany"; settings.KeyFieldName = "ID"; settings.CallbackRouteValues = new { Controller = "Company", Action = "GridCompanyPartial" }; settings.SettingsEditing.AddNewRowRouteValues = new { Controller = "Company", Action = "SaveCompany" }; settings.SettingsEditing.UpdateRowRouteValues = new { Controller = "Company", Action = "UpdateCompany" }; settings.SettingsEditing.DeleteRowRouteValues = new { Controller = "Company", Action = "DeleteCompany" }; settings.SettingsEditing.Mode = GridViewEditingMode.EditFormAndDisplayRow; settings.SettingsBehavior.ConfirmDelete = true; settings.Width = Unit.Percentage(100); settings.SettingsBehavior.AllowFocusedRow = true; //settings.SettingsBehavior.ProcessColumnMoveOnClient = true; //settings.SettingsBehavior.ColumnMoveMode = GridColumnMoveMode.AmongSiblings; settings.SettingsPager.PageSize = 10; 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.Settings.ShowGroupPanel = true; settings.ClientSideEvents.FocusedRowChanged = "OnCompanySelected"; settings.ClientSideEvents.EndCallback = "OnCompanyEndCallBack"; settings.ClientSideEvents.BeginCallback = "OnCompanyBeginCallBack"; settings.Settings.VerticalScrollBarMode = ScrollBarMode.Visible; settings.Settings.VerticalScrollableHeight = 300; //Column info settings.Columns.Add(c => { c.FieldName = "NAME"; c.Caption = "Company Name"; c.EditorProperties().TextBox(t => { t.Width = Unit.Pixel(250); }); }); settings.Columns.Add(c => { c.FieldName = "CREATED_DATE"; c.Caption = "Created Date"; c.Width = Unit.Pixel(200); c.EditFormSettings.Visible = DevExpress.Utils.DefaultBoolean.False; c.SortOrder = DevExpress.Data.ColumnSortOrder.Ascending; }); settings.EditFormLayoutProperties.ColCount = 3; settings.EditFormLayoutProperties.Items.Add("NAME"); return(settings); }
public static void LoadRelatedGridViewSettings(GridViewSettings settings) { settings.Name = "RelatedGrid"; settings.KeyFieldName = "Id"; settings.Width = Unit.Percentage(100); settings.SettingsEditing.Mode = GridViewEditingMode.Inline; settings.SettingsPager.Mode = GridViewPagerMode.ShowAllRecords; settings.CommandColumn.Visible = true; settings.CommandColumn.ClearFilterButton.Visible = false; settings.CommandColumn.ShowSelectCheckbox = false; settings.Settings.ShowFilterRow = true; settings.Settings.ShowFilterRowMenu = true; }
public static void SetupGlobalGridViewBehavior(this GridViewSettings settings) { settings.EnablePagingGestures = AutoBoolean.False; settings.Styles.Header.Wrap = DefaultBoolean.True; //settings.Styles.GroupPanel.CssClass = "GridNoWrapGroupPanel"; }
public static GridViewSettings GetMasterGridSettings() { var settings = new GridViewSettings(); settings.Name = "GridView"; settings.Width = System.Web.UI.WebControls.Unit.Percentage(100); settings.SettingsPager.PageSize = 50; settings.ControlStyle.Paddings.Padding = System.Web.UI.WebControls.Unit.Pixel(0); settings.ControlStyle.Border.BorderWidth = System.Web.UI.WebControls.Unit.Pixel(0); settings.ControlStyle.BorderBottom.BorderWidth = System.Web.UI.WebControls.Unit.Pixel(1); settings.SettingsSearchPanel.Visible = true; settings.Settings.ShowHeaderFilterButton = true; settings.Settings.ShowGroupPanel = true; settings.KeyFieldName = "AZONOSITO"; //// Export-specific settings //settings.SettingsExport.FileName = "Report"; //settings.SettingsExport.PaperKind = System.Drawing.Printing.PaperKind.A4; //settings.SettingsDetail.ShowDetailRow = true; //settings.SettingsDetail.ExportMode = GridViewDetailExportMode.; // This code retrieves data for the detail grid when performing the export. // To retrieve the records for the detail grid when displaying the grid to end-users, // refer to the "GridViewDetailPartial" action method. settings.Columns.Add(column => { column.FieldName = "CIM"; column.Caption = "Cím"; }); settings.Columns.Add(column => { column.FieldName = "KESZULTSEG"; column.Caption = "Készültség"; }); settings.Columns.Add(column => { column.FieldName = "TERVEZETTKEZDETIDO"; column.Caption = "TERVEZETTKEZDETIDO"; }); settings.Columns.Add(column => { column.FieldName = "TERVEZETTVEGIDO"; column.Caption = "TERVEZETTVEGIDO"; }); settings.Columns.Add(column => { column.FieldName = "VEGREHAJTASKEZDETIDO"; column.Caption = "VEGREHAJTASKEZDETIDO"; }); settings.Columns.Add(column => { column.FieldName = "VEGREHAJTASVEGIDO"; column.Caption = "VEGREHAJTASVEGIDO"; }); //settings.Columns.Add("KANORMTEVAZONOSITO"); //settings.Columns.Add("MEGJEGYZES"); //settings.Columns.Add("GEOKODX"); //settings.Columns.Add("GEOKODY"); //settings.Columns.Add("SAPAZONOSITO"); //settings.Columns.Add("KOZTADATAZONOSITO"); //settings.Columns.Add("KOMPLMUNKAAZONOSITO"); //settings.Columns.Add("SORSZAM"); //settings.Columns.Add("KOPRIOAZONOSITO"); //settings.Columns.Add("KORZNEVKORZET"); //settings.Columns.Add("MIRAZONOSITO"); //settings.Columns.Add("MIRKOMPONENS"); //settings.Columns.Add("KOVKOPRIOAZONOSITO"); //settings.Columns.Add("CSOATMERO"); //settings.Columns.Add("CSOANYAG"); //settings.Columns.Add("KESZULTSEG"); //settings.Columns.Add("KOMKFORRASAZONOSITO"); //settings.Columns.Add("FORRASAZONOSITO"); //settings.Columns.Add("FORRASAZONOSITOTXT"); settings.Columns.Add(column => { column.FieldName = "STATUSZ"; column.Caption = "Státusz"; column.ColumnType = MVCxGridViewColumnType.ComboBox; var comboBoxProperties = column.PropertiesEdit as ComboBoxProperties; comboBoxProperties.DataSource = NorthwindDataProvider.GetStatusTable(); comboBoxProperties.TextField = "MEGNEVEZES"; comboBoxProperties.ValueField = "AZONOSITO"; comboBoxProperties.ValueType = typeof(long); }); return settings; }
public static void UpdateButton(GridViewSettings settings, UrlHelper urlHelper) { settings.CommandColumn.UpdateButton.Visible = true; settings.CommandColumn.UpdateButton.Image.Url = urlHelper.Content("~/Content/images/ok_32.png"); settings.CommandColumn.UpdateButton.Image.ToolTip = "Potvrdi"; }
public override void Configure(GridViewSettings settings, HtmlHelper html, ViewContext viewContext) { throw new NotImplementedException(); }
public static void EditButtton(GridViewSettings settings, UrlHelper urlHelper) { settings.CommandColumn.EditButton.Visible = true; settings.CommandColumn.EditButton.Image.Url = urlHelper.Content("~/Content/images/edit.png"); settings.CommandColumn.EditButton.Image.ToolTip = "Izmeni"; }
public static void SetEditRoute(GridViewSettings settings, string controller) { settings.SettingsEditing.AddNewRowRouteValues = new { Controller = controller, Action = "AddNew" }; settings.SettingsEditing.UpdateRowRouteValues = new { Controller = controller, Action = "Update" }; settings.SettingsEditing.DeleteRowRouteValues = new { Controller = controller, Action = "Delete" }; }
public void GridDefaultBehavior(GridViewSettings settings, string gridName, bool hideSearchBar = false, bool showSelectCheckColumn = false, bool trandformHeadersMultiSelection = true, bool override100Width = false, int newWidthForOverride = 0) { settings.Name = gridName; var layoutName = settings.Name + "Layout"; #region current add again // settings.SettingsBehavior.AutoFilterRowInputDelay = 0; settings.Settings.ShowGroupPanel = true; settings.Settings.ShowFilterRow = true; settings.Settings.ShowHeaderFilterButton = true; settings.SettingsBehavior.AllowSelectByRowClick = false; //settings.SettingsBehavior.AllowSelectSingleRowOnly = true; settings.SettingsBehavior.AllowFocusedRow = true; settings.SettingsBehavior.AllowEllipsisInText = true; settings.SettingsResizing.ColumnResizeMode = ColumnResizeMode.Control; settings.SettingsBehavior.AllowDragDrop = true; settings.Width = Unit.Percentage(100); settings.SettingsPager.FirstPageButton.Visible = true; settings.SettingsPager.LastPageButton.Visible = true; settings.SettingsPager.AllButton.Visible = true; //settings.Settings.ShowFooter = true; settings.Settings.ShowFilterRowMenu = true; settings.SettingsBehavior.EnableCustomizationWindow = true; settings.SettingsPager.PageSize = 25; settings.SettingsPager.NumericButtonCount = 6; settings.Styles.Cell.Wrap = DefaultBoolean.False; settings.SettingsBehavior.AllowFocusedRow = true; #endregion // adaptability settings.SettingsAdaptivity.AdaptivityMode = GridViewAdaptivityMode.Off; settings.SettingsAdaptivity.AdaptiveColumnPosition = GridViewAdaptiveColumnPosition.Right; settings.SettingsAdaptivity.AdaptiveDetailColumnCount = 1; settings.SettingsAdaptivity.AllowOnlyOneAdaptiveDetailExpanded = true; settings.SettingsAdaptivity.HideDataCellsAtWindowInnerWidth = 0; if (showSelectCheckColumn == true) { settings.CommandColumn.Visible = true; settings.CommandColumn.ShowSelectCheckbox = true; settings.CommandColumn.Width = 40; } if (trandformHeadersMultiSelection == true) { //transform header filter to check list for multiple selection settings.Settings.ShowHeaderFilterButton = true; settings.SettingsPopup.HeaderFilter.Height = 250; var headerFilterMode = GridHeaderFilterMode.CheckedList; foreach (GridViewDataColumn column in settings.Columns) { column.SettingsHeaderFilter.Mode = headerFilterMode; } } settings.ClientSideEvents.ColumnResized = "HighlightEllipsis"; settings.SettingsBehavior.AllowEllipsisInText = true; settings.SettingsPager.PageSizeItemSettings.Visible = true; settings.SettingsPager.AlwaysShowPager = true; settings.ControlStyle.Wrap = DefaultBoolean.False; if (override100Width == true && newWidthForOverride > 0) { settings.Width = newWidthForOverride; } else { settings.Width = Unit.Percentage(100); } #if !DEBUG settings.ClientLayout = (s, e) => { switch (e.LayoutMode) { case ClientLayoutMode.Loading: //Load Last ClientLayout Via First Load if (Html.ViewContext.TempData[layoutName] != null) { e.LayoutData = Html.ViewContext.TempData[layoutName].ToString(); } break; case ClientLayoutMode.Saving: //Save Last ClientLayout Automatically Html.ViewContext.TempData[layoutName] = e.LayoutData; break; } }; #endif // GRID EXPORTS settings.SettingsExport.EnableClientSideExportAPI = true; settings.SettingsExport.ExcelExportMode = DevExpress.Export.ExportType.WYSIWYG; settings.SettingsExport.RenderBrick = (sender, e) => { if (e.RowType == GridViewRowType.Data && e.VisibleIndex % 2 == 0) { e.BrickStyle.BackColor = System.Drawing.Color.FromArgb(0xEE, 0xEE, 0xEE); } }; settings.Toolbars.Add(toolbar => { toolbar.EnableAdaptivity = true; toolbar.Items.Add(GridViewToolbarCommand.Refresh); toolbar.Items.Add(GridViewToolbarCommand.ClearFilter); toolbar.Items.Add(GridViewToolbarCommand.ClearGrouping); toolbar.Items.Add(GridViewToolbarCommand.ShowSearchPanel); if (gridName != "gvFruitSpecStock") { // toolbar.Items.Add(GridViewToolbarCommand.ExportToPdf); // removed for now toolbar.Items.Add(GridViewToolbarCommand.ExportToXls); // toolbar.Items.Add(GridViewToolbarCommand.ExportToXlsx); //toolbar.Items.Add(GridViewToolbarCommand.ExportToDocx);// removed for now // toolbar.Items.Add(GridViewToolbarCommand.ExportToRtf);// removed for now // toolbar.Items.Add(GridViewToolbarCommand.ExportToCsv);// removed for now } }); }
public void PayrollExportXlxs(DateTime targetDate, bool commit, PayrollFilter filter, out GridViewSettings gridViewSettings, out IEnumerable <PayrollGridItemVM> data) { data = HoursRepository.GetPayablesByPeriod(new DateTime(targetDate.Year, targetDate.Month, 1), filter); gridViewSettings = new GridViewSettings { Name = "gvPayrollOverviewGrid", KeyFieldName = "ID" }; gridViewSettings.SettingsBehavior.AllowSort = false; gridViewSettings.SettingsBehavior.AllowGroup = false; gridViewSettings.SettingsBehavior.AllowFocusedRow = false; gridViewSettings.SettingsBehavior.AllowSelectSingleRowOnly = true; gridViewSettings.Settings.ShowFilterRow = false; gridViewSettings.CallbackRouteValues = new { Action = "PayrollGridCallback" }; gridViewSettings.SettingsExport.ExportSelectedRowsOnly = false; gridViewSettings.SettingsExport.FileName = "Payables_" + DateTime.Now.ToString("yyyy-MM-dd") + ".xlsx"; gridViewSettings.Columns.Add(col => { col.Name = "PayrollID"; col.FieldName = "PayrollID"; col.Caption = "PayrollID"; }); gridViewSettings.Columns.Add(col => { col.Name = "colFirstName"; col.FieldName = "FirstName"; col.Caption = "First Name"; }); gridViewSettings.Columns.Add(col => { col.Name = "colLastName"; col.FieldName = "LastName"; col.Caption = "Last Name"; }); gridViewSettings.Columns.Add(col => { col.Name = "colHours"; col.FieldName = "Hours"; col.Caption = "Hours"; col.Width = 80; }); gridViewSettings.Columns.Add(col => { col.Name = "colEntriesMissingCatalystData"; col.FieldName = "EntriesMissingCatalystData"; col.Caption = "Entries Missing Catalyst Data"; }); try { if (commit) { ReportService.GeneratePayrollReport(targetDate, filter); } return; } catch (Exception e) { Exceptions.Handle(e, Global.GetWebInfo()); throw e; } }
public GridViewSettings GetBillingBillingExportGridViewSettings() { var s = new GridViewSettings(); s.Name = "rptgvBillingBillingExport"; s.SettingsExport.FileName = "MBH-Billing_" + DateTime.Now.ToString("yyyy-MM-dd") + ".xlsx"; var col = s.Columns.Add("colPatientFN"); col.FieldName = "PatientFN"; s.Columns.Add("PatientLN"); s.Columns.Add("ProviderFN"); s.Columns.Add("ProviderLN"); col = s.Columns.Add("colPatientID"); col.FieldName = "PatientID"; col.Caption = "Patient ID"; col = s.Columns.Add("colProviderID"); col.FieldName = "ProviderID"; col.Caption = "Provider ID"; col = s.Columns.Add("AuthorizedProviderID"); col = s.Columns.Add("colSupervisingBCBAID"); col.FieldName = "SupervisingBCBAID"; col.Caption = "Supervising BCBA ID"; col = s.Columns.Add("colIsBCBATimesheet"); col.FieldName = "IsBCBATimesheet"; col.Caption = "Is BCBA Timesheet"; col = s.Columns.Add("colDateOfService"); col.FieldName = "DateOfService"; col.Caption = "Date Of Service"; col = s.Columns.Add("colStartTime"); col.FieldName = "StartTime"; col.Caption = "Start Time"; col.PropertiesEdit.DisplayFormatString = "t"; col = s.Columns.Add("colEndTime"); col.FieldName = "EndTime"; col.Caption = "End Time"; col.PropertiesEdit.DisplayFormatString = "t"; col = s.Columns.Add("colTotalTime"); col.FieldName = "TotalTime"; col.Caption = "Total Time"; col = s.Columns.Add("colServiceCode"); col.FieldName = "ServiceCode"; col.Caption = "Service Code"; col = s.Columns.Add("colPlaceOfService"); col.FieldName = "PlaceOfService"; col.Caption = "Place Of Service"; col = s.Columns.Add("colPlaceOfServiceID"); col.FieldName = "PlaceOfServiceID"; col.Caption = "Place Of Service ID"; return(s); }
public static GridViewSettings CreateGridViewSettings(AvrView Model) { GridViewSettings settings = new GridViewSettings(); var CanUpdate = !Model.IsReadOnly && eidss.model.Core.AvrPermissions.UpdatePermission; settings.Styles.Cell.Wrap = DefaultBoolean.True; settings.Name = "layoutViewGrid"; settings.CallbackRouteValues = new { Controller = "ViewLayout", Action = "ViewGridView", layoutId = Model.LayoutID }; settings.KeyFieldName = "ID"; // Behavior settings.SettingsBehavior.AllowSort = true; settings.SettingsBehavior.EnableCustomizationWindow = CanUpdate; settings.SettingsBehavior.ColumnResizeMode = ColumnResizeMode.Control; settings.SettingsBehavior.AllowDragDrop = CanUpdate; settings.SettingsBehavior.AllowSelectByRowClick = true; settings.SettingsBehavior.AllowSelectSingleRowOnly = false; // Context menu settings.SettingsContextMenu.Enabled = true; settings.SettingsContextMenu.EnableColumnMenu = DevExpress.Utils.DefaultBoolean.True; settings.SettingsContextMenu.EnableRowMenu = DevExpress.Utils.DefaultBoolean.False; settings.ClientSideEvents.ContextMenu = "viewGridForm.grid_OnContextMenu"; /*settings.FillContextMenuItems = (sender, e) => { * e.Items.Add(EidssMessages.Get("RenameColumnBand"), "RenameColumnBand"); * e.Items.Add(EidssMessages.Get("btAddAggregateColumn"), "btAddAggregateColumn"); * // now we can't find which column we clicked - we cant differentiate menu for aggregate columns * ASPxGridView grid = (ASPxGridView)sender; * e.Items.Add(EidssMessages.Get("DeleteAggregateColumn"), "DeleteAggregateColumn"); * };*/ // show settings.Width = Unit.Percentage(100); settings.SettingsPager.Mode = GridViewPagerMode.ShowPager; settings.SettingsPager.PageSize = 15; settings.Settings.HorizontalScrollBarMode = ScrollBarMode.Visible; settings.Styles.Header.Font.Bold = true; settings.Styles.LoadingDiv.CssClass = "center"; settings.SettingsExport.Landscape = true; settings.StylesPager.PageSizeItem.Wrap = DefaultBoolean.True; // filtration settings.Settings.ShowHeaderFilterButton = true; settings.Settings.ShowFilterBar = GridViewStatusBarMode.Hidden; // Aggregate functions //settings.CustomUnboundColumnData = Grid_CustomUnboundColumnData; // Add columns (and bands) AddToGrid(Model, settings.Columns); // Custom filter settings.HeaderFilterFillItems = (sender, e) => { var col = Model.GetColumnByOriginalName(e.Column.FieldName); if (col != null && !string.IsNullOrEmpty(col.ColumnFilter) && !col.ColumnFilter.StartsWith("IsNullOrEmpty") && !col.ColumnFilter.StartsWith("Not IsNullOrEmpty") && !col.ColumnFilter.EndsWith(" Null") && (col.ColumnFilter.Contains(" Or ") || col.ColumnFilter.Contains(" And ") || !col.ColumnFilter.Contains(" = "))) { e.AddValue(col.ColumnFilter.Replace("[" + e.Column.FieldName + "] ", ""), string.Empty, col.ColumnFilter); } }; // Events settings.HtmlDataCellPrepared = (sender, e) => { DisplayAsterisk(Model, e); }; settings.ClientLayout = Grid_ClientLayout; settings.PreRender = Grid_PreRender; settings.ClientSideEvents.CustomizationWindowCloseUp = "viewGridForm.grid_CustomizationWindowCloseUp"; settings.ClientSideEvents.ColumnResized = "viewGridForm.grid_ColumnResized"; settings.ClientSideEvents.ColumnMoving = "viewGridForm.grid_ColumnMoving"; settings.ClientSideEvents.CallbackError = "viewGridForm.grid_CallbackError"; //settings.ClientSideEvents.SelectionChanged = "viewGridForm.grid_SelectionChanged"; settings.Theme = GeneralSettings.Theme; settings.RightToLeft = Cultures.IsRtl ? DefaultBoolean.True : DefaultBoolean.False; Model.GridViewSettings = settings; ResetDisplayTextHandler(); return(settings); }
public override void Configure(GridViewSettings settings, HtmlHelper html, ViewContext viewContext) { base.Configure(settings, html, viewContext); }
public GridViewSettings GetHoursDownloadSettings(IEnumerable <HoursDownloadItem> data, int caseID, DateTime targetDate) { var patientName = _context.Cases.Find(caseID).Patient.CommonName.Replace(' ', '_'); var s = new GridViewSettings { Name = "gvDownloadCurrentHours" }; s.Settings.ShowFilterRow = false; s.SettingsBehavior.AllowSort = false; s.SettingsBehavior.AllowGroup = false; s.SettingsBehavior.AllowFocusedRow = false; s.SettingsBehavior.AllowSelectSingleRowOnly = true; s.SettingsExport.ExportSelectedRowsOnly = false; s.SettingsExport.FileName = "Hours_" + patientName + "_" + targetDate.ToString("yyyy-MM") + ".xlsx"; s.Columns.Add(col => { col.Name = "StatusName"; col.Caption = "Status"; }); s.Columns.Add(col => { col.Name = "HoursDate"; col.Caption = "Date"; }); s.Columns.Add(col => { col.Name = "HoursTimeIn"; col.Caption = "Time In"; }); s.Columns.Add(col => { col.Name = "HoursTimeOut"; col.Caption = "Time Out"; }); s.Columns.Add(col => { col.Name = "HoursTotal"; col.Caption = "Hours Total"; }); s.Columns.Add(col => { col.Name = "ServiceCode"; col.Caption = "Service Code"; }); s.Columns.Add(col => { col.Name = "HoursNotes"; col.Caption = "Notes"; }); s.Columns.Add(col => { col.Name = "ExtendedNotes"; col.Caption = "Extended Notes"; }); return(s); }
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); }
public static void AddToolBar(this GridViewSettings gridView, HtmlHelper html, ViewContext viewContext, GridData gridData) { gridView.Toolbars.Add(toolbar => { toolbar.SetProperties(gridData.ToolBarOptions); if (gridData != null && gridData.ToolbarItems != null && gridData.ToolbarItems.Any()) { gridData.ToolbarItems.ToList().ForEach(t => toolbar.Items.Add(t)); gridView.ClientSideEvents.ToolbarItemClick = "function(s, e){if (typeof onToolbarItemClick === 'function' ) onToolbarItemClick(s, e); else s.AddNewRow() ;}"; } if (gridData.ToolBarOptions.DisplaySearchPanel) { gridView.SettingsSearchPanel.CustomEditorName = "search_" + gridData.Name; toolbar.Items.Add(i => { i.BeginGroup = true; i.SetTemplateContent(c => { html.DevExpress().ButtonEdit(s => { s.Name = "search_" + gridData.Name; s.Properties.NullText = $"{gridData.ToolBarOptions.SearchText}..."; s.Properties.Buttons .Add() .Image.IconID = DevExpress.Web.ASPxThemes.IconID.FindFind16x16gray; }).Render(); }); }); } if (gridData.ToolBarOptions.DisplayRefresh) { toolbar.Items.Add(item => { item.SetProperties(gridData.ToolBarOptions.Width, gridData.ToolBarOptions.Height, GridViewToolbarCommand.Refresh, "~/Images/Refresh.png"); }); } if (gridData.ToolBarOptions.DisplayFilter) { toolbar.Items.Add(item => { item.SetProperties(gridData.ToolBarOptions.Width, gridData.ToolBarOptions.Height, GridViewToolbarCommand.ShowFilterRow, "~/Images/Filter.png"); }); } if (gridData.ToolBarOptions.DisplayClearFilter) { toolbar.Items.Add(item => { item.SetProperties(gridData.ToolBarOptions.Width, gridData.ToolBarOptions.Height, GridViewToolbarCommand.ClearFilter, "~/Images/ClearFilter.png"); }); } if (gridData.ToolBarOptions.DisplayPdfExport) { toolbar.Items.Add(item => { item.SetProperties(gridData.ToolBarOptions.Width, gridData.ToolBarOptions.Height, GridViewToolbarCommand.ExportToPdf, "~/Images/Pdf.png"); }); } if (gridData.ToolBarOptions.DisplayXlsExport) { toolbar.Items.Add(item => { item.SetProperties(gridData.ToolBarOptions.Width, gridData.ToolBarOptions.Height, GridViewToolbarCommand.ExportToXls, "~/Images/Excel.png"); }); } toolbar.Items.Add(item => { item.SetProperties(gridData.ToolBarOptions.Width, gridData.ToolBarOptions.Height, GridViewToolbarCommand.Custom, ""); item.Name = "Space1"; item.SetTemplateContent(c => { viewContext.Writer.Write(" "); }); item.ClientEnabled = false; }); }); }
public static GridViewSettings GetGridSettings(string action, string reportName) { var settings = new GridViewSettings(); settings.Name = "GridView"; settings.CallbackRouteValues = new { Controller = "Home", Action = "_" + action }; settings.Width = System.Web.UI.WebControls.Unit.Percentage(100); // Export-specific settings settings.SettingsExport.ExportSelectedRowsOnly = false; //settings.SettingsExport. = "Report.pdf"; //settings.SettingsExport.PageHeader = new DevExpress.Web.GridViewExporterHeaderFooter; settings.SettingsExport.PageHeader.Center = BusinessLogic.Home.TranslateWord.GetWord(reportName); settings.SettingsExport.PageHeader.Font.Name = "segoe ui"; settings.SettingsExport.PageHeader.Font.Size = 14; // settings.SettingsExport.Landscape = MySession.Current.MySetting.IsPageLandscape; settings.SettingsExport.Styles.Cell.Font.Size = 10; settings.SettingsExport.FileName = DateTime.Now.Day.ToString() + "." + DateTime.Now.Month.ToString() + "." + DateTime.Now.Year.ToString() + ".pdf"; settings.SettingsExport.PaperKind = System.Drawing.Printing.PaperKind.A4; //settings.SettingsPager.Mode = GridViewPagerState.ShowAllRecords; switch (action) { case "GridViewWorks": settings.KeyFieldName = "id"; settings.Columns.Add(nameof(Database.Work.name), "Denumire"); settings.Columns.Add(nameof(Database.Work.date_start), "Data început").PropertiesEdit.DisplayFormatString = Const.DateTimeFormat; settings.Columns.Add(nameof(Database.Work.date_end), "Data finisării").PropertiesEdit.DisplayFormatString = Const.DateTimeFormat; settings.Columns.Add(nameof(Database.Work.surface_work), "Cantitatea"); settings.Columns.Add(c => { c.FieldName = nameof(Database.Work.unit_id); c.Caption = "Unitate"; c.EditorProperties().ComboBox(p => { p.TextField = "Name"; p.ValueField = "Id"; p.ValueType = typeof(int); p.DataSource = MySession.Current.Units; }); }); settings.Columns.Add(nameof(Database.Work.unit_price), "Preț unitate"); MVCxGridViewColumn column = settings.Columns.Add("Total"); column.UnboundType = DevExpress.Data.UnboundColumnType.Decimal; settings.CustomUnboundColumnData = (sender, e) => { if (e.Column.FieldName == "Total") { decimal price = MyConvert.ToDecimal(e.GetListSourceFieldValue(nameof(Database.Work.unit_price_worker)).ToString()); decimal surface = MyConvert.ToDecimal(e.GetListSourceFieldValue(nameof(Database.Work.surface_work)).ToString()); e.Value = price * surface; } }; settings.TotalSummary.Add(DevExpress.Data.SummaryItemType.Sum, "Total"); settings.Settings.ShowFooter = true; break; case "GridViewMaterial": settings.KeyFieldName = "id"; settings.Columns.Add(nameof(Database.ObjectMaterial.material_description), "Denumire material"); settings.Columns.Add(nameof(Database.ObjectMaterial.buyed_date), "Data procurării").PropertiesEdit.DisplayFormatString = Const.DateTimeFormat; settings.Columns.Add(nameof(Database.ObjectMaterial.quantity), "Cantitatea"); MVCxGridViewColumn col = settings.Columns.Add("Preț total"); col.UnboundType = DevExpress.Data.UnboundColumnType.Decimal; settings.CustomUnboundColumnData = (sender, e) => { if (e.Column.FieldName == "Preț total") { decimal price = MyConvert.ToDecimal( e.GetListSourceFieldValue(nameof(Database.ObjectMaterial.unit_price)).ToString()); decimal quantity = MyConvert.ToDecimal( e.GetListSourceFieldValue(nameof(Database.ObjectMaterial.quantity)).ToString()); e.Value = price * quantity; } }; settings.TotalSummary.Add(DevExpress.Data.SummaryItemType.Sum, "Preț total"); settings.Settings.ShowFooter = true; break; case "GridViewExtra": settings.KeyFieldName = "id"; settings.Columns.Add(nameof(Database.ObjectExtra.description), "Descrierea"); settings.Columns.Add(nameof(Database.ObjectExtra.create_date), "Data creării").PropertiesEdit.DisplayFormatString = Const.DateTimeFormat; settings.Columns.Add(nameof(Database.ObjectExtra.price), "Prețul"); settings.TotalSummary.Add(DevExpress.Data.SummaryItemType.Sum, nameof(Database.ObjectExtra.price)); settings.Settings.ShowFooter = true; break; case "GridViewInstrument": settings.KeyFieldName = "id"; settings.Columns.Add(nameof(Database.ObjectInstrument.model), "Model"); settings.Columns.Add(nameof(Database.ObjectInstrument.first_day), "Data împrumut").PropertiesEdit.DisplayFormatString = Const.DateTimeFormat; settings.Columns.Add(nameof(Database.ObjectInstrument.last_day), "Data predării").PropertiesEdit.DisplayFormatString = Const.DateTimeFormat; settings.Columns.Add(nameof(Database.ObjectInstrument.quantity), "Cantitatea"); settings.Columns.Add(nameof(Database.ObjectInstrument.total_price), "Preț total"); settings.Columns.Add(nameof(Database.ObjectInstrument.responsabile_person), "Responsabil"); settings.TotalSummary.Add(DevExpress.Data.SummaryItemType.Sum, nameof(Database.ObjectInstrument.total_price)); settings.Settings.ShowFooter = true; break; case "GridViewPayments": settings.KeyFieldName = nameof(Database.WorkerPayment.id); settings.Columns.Add(nameof(Database.WorkerPayment.payment_date), Const.PaymentDate); settings.Columns.Add(nameof(Database.WorkerPayment.payment_type), Const.PaymentType); settings.Columns.Add(c => { c.FieldName = nameof(Database.WorkerPayment.payment_type); c.Caption = "Tip Achitare"; c.EditorProperties().ComboBox(p => { p.DataSource = MySession.Current.PaymentTypes; p.TextField = "Value"; p.ValueField = "Key"; p.ValueType = typeof(string); }); }); //settings.Columns.Add(nameof(Database.WorkerPayment.work_id), Const.Work); settings.Columns.Add(c => { c.FieldName = nameof(Database.WorkerPayment.work_id); c.Caption = Const.Work; c.EditorProperties().ComboBox(p => { p.TextField = nameof(Database.Work.name); p.ValueField = "Id"; p.ValueType = typeof(int); p.DataSource = MySession.Current.Works; }); }); settings.Columns.Add(nameof(Database.WorkerPayment.amount), Const.Amount); settings.TotalSummary.Add(DevExpress.Data.SummaryItemType.Sum, nameof(Database.WorkerPayment.amount)); settings.Settings.ShowFooter = true; break; } return(settings); }
public static void ConfigurarGridView(GridViewSettings settings, bool isAdmin, string nameSummary, bool ShowFilterRow = true, bool ShowGroupPanel = true, System.Web.Mvc.ViewDataDictionary ViewData = null, int botones = 255, string toolTipBotonEliminar = "Eliminar", bool isMasterGrid = true) { try { settings.SettingsCommandButton.NewButton.ButtonType = GridCommandButtonRenderMode.Image; settings.SettingsCommandButton.NewButton.Image.IconID = DevExpress.Web.ASPxThemes.IconID.EditNew16x16gray; settings.SettingsCommandButton.EditButton.ButtonType = GridCommandButtonRenderMode.Image; settings.SettingsCommandButton.EditButton.Image.IconID = DevExpress.Web.ASPxThemes.IconID.EditEdit16x16gray; settings.SettingsCommandButton.DeleteButton.ButtonType = GridCommandButtonRenderMode.Image; settings.SettingsCommandButton.DeleteButton.Image.IconID = DevExpress.Web.ASPxThemes.IconID.ActionsDeleteitem16x16gray; settings.SettingsCommandButton.UpdateButton.Image.IconID = DevExpress.Web.ASPxThemes.IconID.ActionsSave32x32devav; settings.SettingsCommandButton.CancelButton.Image.IconID = DevExpress.Web.ASPxThemes.IconID.ActionsCancel32x32gray; settings.Settings.VerticalScrollBarMode = ScrollBarMode.Auto; settings.Width = System.Web.UI.WebControls.Unit.Percentage(100); settings.SettingsPager.PageSize = 50; settings.SettingsPager.NumericButtonCount = 6; settings.SettingsPager.EnableAdaptivity = true; settings.CommandColumn.ButtonType = GridCommandButtonRenderMode.Image; settings.CommandColumn.Visible = (isAdmin && botones > 0); settings.CommandColumn.ShowNewButton = false;// (isAdmin && ((botones & (int)EnumBotonesGrid.Add) == (int)EnumBotonesGrid.Add)); settings.CommandColumn.ShowDeleteButton = true; settings.CommandColumn.ShowEditButton = (isAdmin && ((botones & (int)EnumBotonesGrid.Edit) == (int)EnumBotonesGrid.Edit)); settings.SettingsEditing.Mode = GridViewEditingMode.PopupEditForm; settings.SettingsPopup.EditForm.HorizontalAlign = PopupHorizontalAlign.WindowCenter; settings.SettingsPopup.EditForm.VerticalAlign = PopupVerticalAlign.WindowCenter; settings.SettingsPopup.EditForm.Modal = false; settings.SettingsPager.PageSize = 50; //settings.SettingsPager.SEOFriendly = SEOFriendlyMode.Enabled; settings.SettingsPager.PageSizeItemSettings.Visible = true; settings.SettingsPager.PageSizeItemSettings.ShowAllItem = true; settings.SettingsPager.Position = System.Web.UI.WebControls.PagerPosition.TopAndBottom; settings.SettingsPager.FirstPageButton.Visible = true; settings.SettingsPager.LastPageButton.Visible = true; settings.TotalSummary.Add(DevExpress.Data.SummaryItemType.Count, nameSummary); settings.GroupSummary.Add(DevExpress.Data.SummaryItemType.Count, nameSummary); settings.Settings.ShowFooter = true; settings.Settings.ShowHeaderFilterButton = true; settings.SettingsPager.Visible = true; settings.Settings.ShowGroupPanel = ShowGroupPanel; settings.Settings.ShowFilterRow = ShowFilterRow; settings.SettingsBehavior.AllowSelectByRowClick = true; settings.SettingsExport.Landscape = true; foreach (GridViewDataColumn column in settings.Columns) { column.Settings.HeaderFilterMode = HeaderFilterMode.CheckedList; column.Settings.AutoFilterCondition = AutoFilterCondition.Contains; } System.Web.HttpContext.Current.Session[settings.Name] = settings; settings.SettingsExport.TopMargin = 0; settings.SettingsExport.LeftMargin = 0; } catch (Exception ex) { string error = ex.ToString(); } }