protected virtual ASPxLabel CreateSummaryItemControl(ASPxSummaryItem item, ASPxGridView grid) { var value = grid.GetTotalSummaryValue(item); var text = item.GetTotalFooterDisplayText(grid.DataColumns[item.FieldName], value); var label = new ASPxLabel(); label.EnableClientSideAPI = true; label.ID = string.Format("SummaryItemControl_{0}_{1}", item.FieldName, item.ShowInColumn); label.Text = text; label.Init += (s, e) => { SummaryTexts[label.ClientID] = label.Text; }; return(label); }
public ASPxSummaryItem komorkaSumujaca(string text, string nazwaPola) { string idPola = nazwaPola; ASPxSummaryItem _komorkaSumujaca = new ASPxSummaryItem() { FieldName = idPola, ShowInColumn = idPola, SummaryType = SummaryItemType.Count, DisplayFormat = text }; return(_komorkaSumujaca); }
protected void grid_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e) { ASPxSummaryItem summary = e.Item as ASPxSummaryItem; if (summary.FieldName != "UnitsInStock") { return; } if (e.IsTotalSummary) { int totalValue = 0; foreach (object value in grid.GetSelectedFieldValues("UnitsInStock")) { totalValue += Convert.ToInt32(value); } e.TotalValue = totalValue; e.TotalValueReady = true; } }
protected override void OnViewControlsCreated() { base.OnViewControlsCreated(); IModelListViewExtender modelListView = View.Model as IModelListViewExtender; if (modelListView != null && modelListView.IsGroupFooterVisible) { ASPxGridListEditor gridListEditor = View.Editor as ASPxGridListEditor; if (gridListEditor != null) { ASPxGridView gridView = gridListEditor.Grid; gridView.Settings.ShowGroupFooter = GridViewGroupFooterMode.VisibleAlways; foreach (IModelColumn modelColumn in View.Model.Columns) { IModelColumnExtender modelColumnExtender = modelColumn as IModelColumnExtender; if (modelColumnExtender != null && modelColumnExtender.GroupFooterSummaryType != SummaryItemType.None) { string fieldName = modelColumn.ModelMember.MemberInfo.BindingName.ToUpper(); ASPxSummaryItem summaryItem = null; foreach (ASPxSummaryItem currentItem in gridView.GroupSummary) { if (currentItem.FieldName == fieldName) { currentItem.ShowInGroupFooterColumn = modelColumn.Caption.ToUpper(); summaryItem = currentItem; break; } } if (summaryItem == null) { summaryItem = new ASPxSummaryItem( fieldName, modelColumnExtender.GroupFooterSummaryType); summaryItem.ShowInGroupFooterColumn = modelColumn.Caption.ToUpper(); gridView.GroupSummary.Add(summaryItem); } } } } } }
/// <summary> /// 页面载入事件。 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { wipInstance.ProId = Server.UrlDecode(Request.QueryString["proid"].ToString()); wipInstance.FactoryRoomKey = Server.UrlDecode(Request.QueryString["Factory"].ToString()); wipInstance.WorkOrderNumberKey = Server.UrlDecode(Request.QueryString["WorkOrderNumberKey"].ToString()); wipInstance.Hours = Convert.ToInt32(Request.QueryString["Hours"]); wipInstance.OnLineHours = Convert.ToInt32(Request.QueryString["OnlineHours"]); wipInstance.Oprline = Server.UrlDecode(Request.QueryString["Oprline"].ToString()); string stepName = Server.UrlDecode(Request.QueryString["RouteID"].ToString()); string status = Server.UrlDecode(Request.QueryString["status"].ToString()); string partNumber = Server.UrlDecode(Request.QueryString["partNumber"].ToString()); if (stepName.Equals("合计")) { stepName = string.Empty; } DataTable dt = wipInstance.GetWIPDetail(stepName, status, partNumber); this.gvResults.DataSource = dt; this.gvResults.DataBind(); ViewState["dt"] = dt; gvResults.TotalSummary.Clear(); ASPxSummaryItem lotCount = new ASPxSummaryItem(); lotCount.FieldName = "序列号"; lotCount.ShowInColumn = "序列号"; lotCount.DisplayFormat = "数量合计:{0}"; lotCount.SummaryType = SummaryItemType.Count; gvResults.TotalSummary.Add(lotCount); ASPxSummaryItem inSummary = new ASPxSummaryItem(); inSummary.FieldName = "电池片数量"; inSummary.ShowInColumn = "电池片数量"; inSummary.DisplayFormat = "数量合计:{0}"; inSummary.SummaryType = SummaryItemType.Sum; gvResults.TotalSummary.Add(inSummary); } }
private void BindGvAndChart() { try { DataSet dsReturn = FragmentationRateData.QueryPatchDataDtl(sType, sName, locationkey, shiftName, stime, etime); DataTable dtGv = LoadColumnsResource(dsReturn.Tables[0]); ViewState["grid"] = dtGv; ASPxSummaryItem item = new ASPxSummaryItem(); item.FieldName = "PATCH_QUANTITY"; item.SummaryType = SummaryItemType.Sum; item.DisplayFormat = "不良总计:{0}"; this.grid.TotalSummary.Add(item); this.grid.Settings.ShowFooter = true; this.grid.DataSource = dtGv; //this.grid.SummaryText = "PATCH_QUANTITY"; this.grid.DataBind(); } catch (Exception ex) { } }
public object GetTotalSummaryValue(ASPxSummaryItem item) { return(this.HostedASPxGridView.GetTotalSummaryValue(item)); }
public object GetGroupSummaryValue(int visibleIndex, ASPxSummaryItem item) { return(this.HostedASPxGridView.GetGroupSummaryValue(visibleIndex, item)); }
protected void Suma(object sender, DevExpress.Data.CustomSummaryEventArgs e) { ASPxSummaryItem sumItem = (ASPxSummaryItem)e.Item; }
public List<ASPxSummaryItem> SummaryCalculatorOnGview(string fieldname, string fieldtext, string SummaryCalculator, ASPxGridView gridViewName) { try { if (SummaryCalculator != string.Empty) { SummaryCalculator = SummaryCalculator.Substring(1, SummaryCalculator.Length - 2); Dictionary<string, string> values = JsonConvert.DeserializeObject<Dictionary<string, string>>(SummaryCalculator); string sumType = values["sumType"]; bool isFooter = false; bool isGroup = false; string formatgroup = values["formatgroup"]; string formatfooter = values["formatfooter"]; try { isFooter = values["isFooter"] != "False"; isGroup = values["isGroup"] != "False"; } catch (Exception) { } gridViewName.Settings.ShowFooter = true; ASPxSummaryItem groupitem = new ASPxSummaryItem(); ASPxSummaryItem footeritem = new ASPxSummaryItem(); if (isGroup) groupitem.FieldName = fieldname; if (isFooter) footeritem.FieldName = fieldname; switch (sumType) { case "SUM": { if (isFooter) footeritem.SummaryType = DevExpress.Data.SummaryItemType.Sum; groupitem.SummaryType = DevExpress.Data.SummaryItemType.Sum; if (isFooter) footeritem.DisplayFormat = "Tổng:{0:N0}"; groupitem.DisplayFormat = "Tổng:{0:N0}"; if (isFooter) { footeritem.ShowInColumn = fieldname; footeritem.DisplayFormat = formatfooter == "" ? "Tổng:{0:N0}" : formatfooter; } if (isGroup) { groupitem.ShowInGroupFooterColumn = fieldname; groupitem.DisplayFormat = formatgroup == "" ? "Tổng:{0:N0}" : formatgroup; } break; } case "COUNT": { if (isFooter) footeritem.SummaryType = DevExpress.Data.SummaryItemType.Count; if (isGroup) groupitem.SummaryType = DevExpress.Data.SummaryItemType.Count; if (isFooter) footeritem.DisplayFormat = "SL:{0:N0}"; if (isGroup) groupitem.DisplayFormat = "SL:{0:N0}"; if (isFooter) { footeritem.ShowInColumn = fieldname; footeritem.DisplayFormat = formatfooter == "" ? "SL:{0:N0}" : formatfooter; } if (isGroup) { groupitem.ShowInGroupFooterColumn = fieldname; groupitem.DisplayFormat = formatgroup == "" ? "SL:{0:N0}" : formatgroup; } break; } case "AVERAGE": { if (isFooter) footeritem.SummaryType = DevExpress.Data.SummaryItemType.Average; if (isGroup) groupitem.SummaryType = DevExpress.Data.SummaryItemType.Average; if (isFooter) footeritem.DisplayFormat = "TB:{0:N0}"; if (isGroup) groupitem.DisplayFormat = "TB:{0:N0}"; if (isFooter) { footeritem.ShowInColumn = fieldname; footeritem.DisplayFormat = formatfooter == "" ? "TB:{0:N0}" : formatfooter; } if (isGroup) { groupitem.ShowInGroupFooterColumn = fieldname; groupitem.DisplayFormat = formatgroup == "" ? "TB:{0:N0}" : formatgroup; } break; } case "MAX": { footeritem.SummaryType = DevExpress.Data.SummaryItemType.Max; groupitem.SummaryType = DevExpress.Data.SummaryItemType.Max; footeritem.DisplayFormat = "Max:{0:N0}"; groupitem.DisplayFormat = "Max:{0:N0}"; if (isFooter) { footeritem.ShowInColumn = fieldname; footeritem.DisplayFormat = formatfooter == "" ? "Max:{0:N0}" : formatfooter; } if (isGroup) { groupitem.ShowInGroupFooterColumn = fieldname; groupitem.DisplayFormat = formatgroup == "" ? "Max:{0:N0}" : formatgroup; } break; } case "MIN": { footeritem.SummaryType = DevExpress.Data.SummaryItemType.Min; groupitem.SummaryType = DevExpress.Data.SummaryItemType.Min; footeritem.DisplayFormat = "Min:{0:N0}"; groupitem.DisplayFormat = "Min:{0:N0}"; if (isFooter) { footeritem.ShowInColumn = fieldname; footeritem.DisplayFormat = formatfooter == "" ? "Min:{0:N0}" : formatfooter; } if (isGroup) { groupitem.ShowInGroupFooterColumn = fieldname; groupitem.DisplayFormat = formatgroup == "" ? "Min:{0:N0}" : formatgroup; } break; } } List<ASPxSummaryItem> mylistsummary = new List<ASPxSummaryItem>(); if (isGroup) gridViewName.GroupSummary.Add(groupitem); if (isFooter) gridViewName.TotalSummary.Add(footeritem); if (isGroup) mylistsummary.Add(groupitem); if (isFooter) mylistsummary.Add(footeritem); return mylistsummary; } else return null; } catch (Exception ex) { SiAuto.Main.LogColored(System.Drawing.Color.Red, ex.ToString()); return null; } }
private void View_ControlsCreated(object sender, EventArgs e) { ASPxGridListEditor listEditor = ((ListView)View).Editor as ASPxGridListEditor; if (listEditor != null) { ASPxGridView gridControl = (ASPxGridView)listEditor.Grid; if (gridControl != null) { if (View.ObjectTypeInfo.GetType()==typeof(WeekReportData)) new ASPxGridViewCellMerger(gridControl); //gridControl.SettingsText.CommandCancel = "Bỏ qua"; //gridControl.SettingsText.CommandClearFilter = "Xóa điều kiện lọc"; //gridControl.SettingsText.CommandEdit = "Chỉnh sửa"; //gridControl.SettingsText.CommandNew = "Tạo mới"; //gridControl.SettingsText.FilterControlPopupCaption = "Tạo điều kiện lọc"; //gridControl.SettingsText.EmptyDataRow = "Không có dữ liệu"; //gridControl.SettingsText.FilterBarClear = "Xóa điều kiện lọc"; //gridControl.SettingsText.FilterBarCreateFilter = "Tạo điều kiện lọc"; //gridControl.SettingsText.GroupPanel = "Kéo thả tiêu đề cột vào đây để nhóm lại"; //gridControl.SettingsText.HeaderFilterShowAll = "Hiện tất cả"; //gridControl.SettingsText.HeaderFilterShowBlanks = "Hiện dòng không có dữ liệu (blank)"; //gridControl.SettingsText.HeaderFilterShowNonBlanks = "Hiện dòng có dữ liệu"; gridControl.SettingsBehavior.ColumnResizeMode = ColumnResizeMode.NextColumn; gridControl.SettingsBehavior.AutoExpandAllGroups = true; //gridControl.SettingsLoadingPanel.Text = "Đang tải …"; //gridControl.SettingsPager.Summary.Text = "Trang {0}/{1} ({2} dòng dữ liệu)"; //gridControl.Settings.ShowStatusBar = GridViewStatusBarMode.Auto; //gridControl.Settings.ShowGroupedColumns = true; gridControl.Settings.ShowFooter = true; gridControl.Settings.ShowGroupFooter = GridViewGroupFooterMode.VisibleAlways; gridControl.Styles.AlternatingRow.Enabled = DevExpress.Web.ASPxClasses.DefaultBoolean.True; //gridControl.Settings.ShowHorizontalScrollBar = true; foreach (ASPxSummaryItem sumItem in gridControl.TotalSummary) { if (sumItem.SummaryType == DevExpress.Data.SummaryItemType.Count) sumItem.DisplayFormat = "Số lượng = {0:0,0}"; if (sumItem.SummaryType == DevExpress.Data.SummaryItemType.Sum) sumItem.DisplayFormat = "Tổng = {0:0,0}"; } gridControl.GroupSummary.Clear(); foreach (ASPxSummaryItem totalItem in gridControl.TotalSummary) { ASPxSummaryItem groupItem = new ASPxSummaryItem(); groupItem.FieldName = totalItem.FieldName; groupItem.DisplayFormat = totalItem.DisplayFormat; groupItem.SummaryType = totalItem.SummaryType; groupItem.ShowInGroupFooterColumn = totalItem.FieldName; gridControl.GroupSummary.Add(groupItem); } GridViewDataColumn hyperLinkColum = gridControl.Columns["HyperLink"] as GridViewDataColumn; if (hyperLinkColum != null) { hyperLinkColum.DataItemTemplate = new HyperLinkTemplate(); } hyperLinkColum = gridControl.Columns["Link"] as GridViewDataColumn; if (hyperLinkColum != null) { hyperLinkColum.DataItemTemplate = new HyperLinkTemplate(); } hyperLinkColum = gridControl.Columns["ResultLink"] as GridViewDataColumn; if (hyperLinkColum != null) { hyperLinkColum.DataItemTemplate = new HyperLinkTemplate(); } } } }
protected object GetTotalSummaryValue() { ASPxSummaryItem summaryItem = Grid.TotalSummary.First(i => i.Tag == "C2_Sum"); return(Grid.GetTotalSummaryValue(summaryItem)); }
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); }
protected object GetTotalGroupSummaryValue(int index) { ASPxSummaryItem summaryItem = Grid.GroupSummary.First(i => i.Tag == "C2_SumGroup"); return(Grid.GetGroupSummaryValue(index, summaryItem)); }