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