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