void grid_CustomSummary(object sender, DevExpress.Data.CustomSummaryEventArgs e) { switch (e.SummaryProcess) { case CustomSummaryProcess.Start: this.sum = 0; break; case CustomSummaryProcess.Calculate: if (grid.SelectionMode != MultiSelectMode.None) { if (Grid.IsItemSelected(e.RowHandle)) { this.sum += (decimal)e.FieldValue; } } else { this.sum += (decimal)e.FieldValue; } break; case CustomSummaryProcess.Finalize: e.TotalValue = this.sum; break; default: break; } }
private void Purchases_CustomSummary(object sender, DevExpress.Data.CustomSummaryEventArgs e) { if (((GridSummaryItem)e.Item).FieldName == "总价") { if (e.IsTotalSummary) { if (e.SummaryProcess == CustomSummaryProcess.Start) { zongjia_sum = 0; } if (e.SummaryProcess == CustomSummaryProcess.Calculate) { if (e.FieldValue != null) { zongjia_sum += double.Parse(e.FieldValue.ToString()); } e.TotalValue = zongjia_sum; } if (e.SummaryProcess == CustomSummaryProcess.Finalize) { ((PurchaseViewModel)this.DataContext).应收 = zongjia_sum; } } } }
private void gridView1_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e) { if (e.Item is GridColumnSummaryItem) { GridView currentView = sender as GridView; GridColumnSummaryItem summaryItem = e.Item as GridColumnSummaryItem; // Initialization if (e.SummaryProcess == CustomSummaryProcess.Start) { summaryCache[summaryItem.FieldName] = 0; } // Calculation if (e.SummaryProcess == CustomSummaryProcess.Calculate) { bool needsToCalulate = (bool)currentView.GetRowCellValue(e.RowHandle, currentView.Columns["Selected"]); if (needsToCalulate) { summaryCache[summaryItem.FieldName] += Convert.ToInt32(e.FieldValue); } } // Finalization if (e.SummaryProcess == CustomSummaryProcess.Finalize) { e.TotalValue = summaryCache[summaryItem.FieldName]; } } }
private void WaybillDetOutGridView_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e) { if (e.SummaryProcess == CustomSummaryProcess.Finalize) { var def_m = DBHelper.MeasuresList.FirstOrDefault(w => w.Def == 1); GridSummaryItem item = e.Item as GridSummaryItem; if (item.FieldName == "MsrName") { e.TotalValue = def_m.ShortName; } if (item.FieldName == "Amount") { var amount_sum = _db.WaybillDet.Where(w => w.WbillId == _wbill_id && w.Materials.MId == def_m.MId).ToList().Sum(s => s.Amount); var ext_sum = _db.WaybillDet.Where(w => w.WbillId == _wbill_id && w.Materials.MId != def_m.MId) .Select(s => new { MaterialMeasures = s.Materials.MaterialMeasures.Where(f => f.MId == def_m.MId), s.Amount }).ToList() .SelectMany(sm => sm.MaterialMeasures, (k, n) => new { k.Amount, MeasureAmount = n.Amount }).Sum(su => su.MeasureAmount * su.Amount); e.TotalValue = Math.Round(amount_sum + ext_sum, 2); } } }
private void dgProjectBudgetLinePageGrid_CustomSummary(object sender, DevExpress.Data.CustomSummaryEventArgs e) { var fieldName = ((GridSummaryItem)e.Item).FieldName; switch (e.SummaryProcess) { case CustomSummaryProcess.Start: sumMargin = sumSales = 0d; break; case CustomSummaryProcess.Calculate: var row = e.Row as ProjectBudgetLineLocal; if (row != null) { sumSales += row.Sales; sumMargin += row.Margin; } break; case CustomSummaryProcess.Finalize: if (fieldName == "MarginRatio" && sumSales > 0) { sumMarginRatio = 100 * sumMargin / sumSales; e.TotalValue = sumMarginRatio; } break; } }
private void DgInvTransGrid_CustomSummary(object sender, DevExpress.Data.CustomSummaryEventArgs e) { var fieldName = ((GridSummaryItem)e.Item).FieldName; switch (e.SummaryProcess) { case CustomSummaryProcess.Start: sumMargin = sumSales = 0d; break; case CustomSummaryProcess.Calculate: var row = e.Row as InvTransClient; sumSales += row.SalesPrice; sumMargin += row.Margin; break; case CustomSummaryProcess.Finalize: if (fieldName == "MarginRatio" && sumSales > 0) { sumMarginRatio = 100 * sumMargin / sumSales; e.TotalValue = sumMarginRatio; } break; } }
private void grvListado_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e) { try { GridView grvGeneral = sender as GridView; // Initialization if (e.SummaryProcess == CustomSummaryProcess.Start) { varSubtotal = 0; varImpuesto = 0; varTotal = 0; } // Calculation if (e.SummaryProcess == CustomSummaryProcess.Calculate) { if (((DevExpress.XtraGrid.GridSummaryItem)(e.Item)).FieldName.Equals("DetTotal")) { switch (((DevExpress.XtraGrid.GridSummaryItem)(e.Item)).Index) { case 0: varSubtotal = varSubtotal + decimal.Parse(e.FieldValue.ToString()); break; case 1: varImpuesto = varImpuesto + (grvGeneral.GetRowCellValue(e.RowHandle, colTaxCodeAP).ToString().Equals("IVA") ? (decimal.Parse(e.FieldValue.ToString()) * (decimal)(varIVA / 100)) : 0); break; case 2: varTotal = varTotal + decimal.Parse(e.FieldValue.ToString()) + (grvGeneral.GetRowCellValue(e.RowHandle, colTaxCodeAP).ToString().Equals("IVA") ? (decimal.Parse(e.FieldValue.ToString()) * (decimal)(varIVA / 100)) : 0); break; } } } // Finalization if (e.SummaryProcess == CustomSummaryProcess.Finalize) { if (((DevExpress.XtraGrid.GridSummaryItem)(e.Item)).FieldName.Equals("DetTotal")) { switch (((DevExpress.XtraGrid.GridSummaryItem)(e.Item)).Index) { case 0: e.TotalValue = varSubtotal; break; case 1: e.TotalValue = varImpuesto; break; case 2: e.TotalValue = varTotal; break; } } } } catch (Exception ex) { XtraMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void depoQryGCgridView_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e) { // Get the summary ID. int summaryID = Convert.ToInt32((e.Item as GridSummaryItem).Tag); string summaryFN = (e.Item as GridSummaryItem).FieldName; // Initialization if (e.SummaryProcess == CustomSummaryProcess.Start) { if (summaryFN == "GIRMIK") { dicGirMik.Clear(); topGirMik = 0; } else if (summaryFN == "GIRSGRDGR") { dicSgrDgr.Clear(); topSgrDgr = 0; } } // Calculation if (e.SummaryProcess == CustomSummaryProcess.Calculate) { id = (int)depoQryGCgridView.GetRowCellValue(e.RowHandle, colGIRID); if (summaryFN == "GIRMIK" && !dicGirMik.ContainsKey(id)) { dicGirMik.Add(id, Convert.IsDBNull(e.FieldValue) ? 0 : Convert.ToInt32(e.FieldValue)); } else if (summaryFN == "GIRSGRDGR" && !dicSgrDgr.ContainsKey(id)) { dicSgrDgr.Add(id, Convert.IsDBNull(e.FieldValue) ? 0.0m : Convert.ToDecimal(e.FieldValue)); } } // Finalization if (e.SummaryProcess == CustomSummaryProcess.Finalize) { switch (summaryFN) { case "GIRMIK": foreach (var g in dicGirMik) { topGirMik += g.Value; } e.TotalValue = topGirMik; break; case "GIRSGRDGR": // sgrDgr foreach (var s in dicSgrDgr) { topSgrDgr += s.Value; } e.TotalValue = topSgrDgr; break; } } }
private void gridView1_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e) { if (e.IsTotalSummary && e.SummaryProcess == CustomSummaryProcess.Finalize) { GridView view = sender as GridView; if (e.Item == view.Columns["UnitPrice"].SummaryItem) { e.TotalValue = CustomSummaryHelper.GetWeightedAverage(view, "Quantity", "UnitPrice"); } } }
private void grid_CustomSummary(object sender, DevExpress.Data.CustomSummaryEventArgs e) { if (e.SummaryProcess == CustomSummaryProcess.Start) { totalPrice = 0; } if (e.SummaryProcess == CustomSummaryProcess.Calculate) { double price = (double)e.FieldValue; int quantity = (int)e.GetValue("Quantity"); totalPrice += price * quantity; e.TotalValue = totalPrice; } }
protected void GridView_Pagos_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e) { try { if (e.SummaryProcess == CustomSummaryProcess.Start) { TotalCordobas = 0; TotalDolares = 0; } else if (e.SummaryProcess == CustomSummaryProcess.Calculate) { if (((ASPxSummaryItem)e.Item).Tag == "Cordobas") { if (e.GetValue("Moneda").ToString() == "Córdobas") { TotalCordobas += Convert.ToDecimal(e.FieldValue); } } if (((ASPxSummaryItem)e.Item).Tag == "Dolares") { if (e.GetValue("Moneda").ToString() == "Dólares") { TotalDolares += Convert.ToDecimal(e.FieldValue); } } } else if (e.SummaryProcess == CustomSummaryProcess.Finalize) { if (((ASPxSummaryItem)e.Item).Tag == "Cordobas") { e.TotalValue = TotalCordobas; } if (((ASPxSummaryItem)e.Item).Tag == "Dolares") { e.TotalValue = TotalDolares; } e.TotalValueReady = true; } } catch (Exception Ex) { FG.Controlador_Error(Ex, Page.Response); } }
private void grdVwEx2_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e) { if (e.SummaryProcess == CustomSummaryProcess.Start) { subTotalTimeSpan = new TimeSpan(); totalTimeSpan = new TimeSpan(); } if (e.SummaryProcess == CustomSummaryProcess.Calculate) { if (e.FieldValue != null && e.FieldValue != DBNull.Value) { TimeSpan timeSpan = ((DateTime)e.FieldValue).TimeOfDay; if (e.IsGroupSummary) { if (timeSpan < subTotalTimeSpan) { subTotalTimeSpan = subTotalTimeSpan.Subtract(timeSpan); } else { subTotalTimeSpan = timeSpan.Subtract(subTotalTimeSpan); } } if (e.IsTotalSummary) { if (timeSpan < totalTimeSpan) { totalTimeSpan = totalTimeSpan.Subtract(timeSpan); } else { totalTimeSpan = timeSpan.Subtract(totalTimeSpan); } } } if (e.IsGroupSummary) { e.TotalValue = subTotalTimeSpan; } if (e.IsTotalSummary) { e.TotalValue = totalTimeSpan; } } }
private void DgInvLines_CustomSummary(object sender, DevExpress.Data.CustomSummaryEventArgs e) { var fieldName = ((GridSummaryItem)e.Item).FieldName; if (e.SummaryProcess == CustomSummaryProcess.Start) { sumMargin = sumSales = 0d; } if (e.SummaryProcess == CustomSummaryProcess.Calculate) { var row = e.Row as DebtorInvoiceLines; sumSales += row.SalesPrice; sumMargin += row.Margin; switch (fieldName) { case "MarginRatio": sumMarginRatio = 100 * sumMargin / sumSales; e.TotalValue = sumMarginRatio; break; } } }
protected void UiVistaFacturasVencidas_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e) { if (e.SummaryProcess != CustomSummaryProcess.Finalize) { return; } if (((ASPxSummaryItem)e.Item).FieldName == "DOC_DATE") { ASPxGridView gv = (ASPxGridView)sender; decimal totalInicioDeInventario = 0; decimal totalEgresoInventario = 0; if (e.IsTotalSummary) { totalInicioDeInventario = Convert.ToDecimal(gv.GetTotalSummaryValue(gv.TotalSummary["DOC_TOTAL"]) ?? 0); totalEgresoInventario = Convert.ToDecimal(gv.GetTotalSummaryValue(gv.TotalSummary["PAID_TO_DATE"]) ?? 0); e.TotalValue = totalInicioDeInventario - totalEgresoInventario; } } }
/// <summary> /// 自定义汇总 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgvEntity_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e) { if (e.SummaryProcess == CustomSummaryProcess.Start) { totalQuantum = 0; } if (e.SummaryProcess == CustomSummaryProcess.Calculate) { bool included = Convert.ToBoolean(this.dgvEntity.GetRowCellValue(e.RowHandle, "Included")); if (included) { var item = e.Item as GridSummaryItem; if (item.FieldName == "Quantum") { totalQuantum += Convert.ToDecimal(e.FieldValue); } } } if (e.SummaryProcess == CustomSummaryProcess.Finalize) { var item = e.Item as GridSummaryItem; if (item.FieldName == "colIncrease") { decimal totalRefQuantum = Convert.ToDecimal(this.colRefQuantum.SummaryItem.SummaryValue); decimal totalQuantum = Convert.ToDecimal(this.colQuantum.SummaryItem.SummaryValue); if (totalRefQuantum == 0) { e.TotalValue = 1; } else { e.TotalValue = (totalQuantum - totalRefQuantum) / totalRefQuantum; } } if (item.FieldName == "Quantum") { e.TotalValue = totalQuantum; } } }
private void grdVwEx1_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e) { if (e.SummaryProcess == CustomSummaryProcess.Calculate) { List <MyClassx> lista = grdVwEx3.GridControl.DataSource as List <MyClassx>; if (e.IsGroupSummary) { e.TotalValue = lista .Where(w => w.Tipo1 == (int)e.FieldValue) .Sum(s => s.Valor1); } if (e.IsTotalSummary) { e.TotalValue = lista.Sum(s => s.Valor2 / 3); } } }
private void bandedGridView1_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e) { if (e.SummaryProcess == CustomSummaryProcess.Start) { //InitStartValue(); } if (e.SummaryProcess == CustomSummaryProcess.Calculate) { try { GridColumnSummaryItem _obj = e.Item as GridColumnSummaryItem; string _fName = _obj.FieldName; e.TotalValue = CurrentValues[_fName]; } catch { e.TotalValue = ""; } } }
private void grid_CustomSummary(object sender, DevExpress.Data.CustomSummaryEventArgs e) { if (object.Equals(e.SummaryProcess, CustomSummaryProcess.Start)) { sum = 0; } if (e.SummaryProcess == CustomSummaryProcess.Calculate) { if ((grid != null) && (grid.View != null)) { if (grid.View.IsRowSelected(e.RowHandle)) { sum += (decimal)e.FieldValue; } } } if (e.SummaryProcess == CustomSummaryProcess.Finalize) { e.TotalValue = sum; } }
private void gridView1_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e) { if (e.SummaryProcess == CustomSummaryProcess.Start) { customSum = new PaymentTypeSum(); } if (e.SummaryProcess == CustomSummaryProcess.Calculate) { LoanPayment payment = gridView1.GetRow(e.RowHandle) as LoanPayment; if (payment != null && e.IsTotalSummary) { customSum.AddToSum(payment.Interest, payment.Principal); } } if (e.SummaryProcess == CustomSummaryProcess.Finalize) { if (e.IsTotalSummary) { e.TotalValue = customSum; } } }
protected void grid_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e) { if (!e.IsTotalSummary) { return; } ASPxGridView g = sender as ASPxGridView; if ((e.SummaryProcess == CustomSummaryProcess.Finalize)) { decimal totalValue = 0; CollectGorups(); foreach (int groupRowIndex in groupRowIndexes) { decimal uisCount = (decimal)g.GetGroupSummaryValue(groupRowIndex, grid.GroupSummary["UnitsInStock"]); decimal uioCount = (decimal)g.GetGroupSummaryValue(groupRowIndex, grid.GroupSummary["UnitsOnOrder"]); totalValue += uisCount - uioCount; } e.TotalValue = totalValue; } }
private void grid_CustomSummary(object sender, DevExpress.Data.CustomSummaryEventArgs e) { if (((GridSummaryItem)e.Item).FieldName != "Number") { return; } if (e.IsTotalSummary) { if (e.SummaryProcess == CustomSummaryProcess.Start) { emptyCellsTotalCount = 0; } if (e.SummaryProcess == CustomSummaryProcess.Calculate) { int?val = (int?)e.FieldValue; if (!val.HasValue) { emptyCellsTotalCount++; } e.TotalValue = emptyCellsTotalCount; } } }
private void grid_CustomSummary(object sender, DevExpress.Data.CustomSummaryEventArgs e) { if (object.Equals(e.SummaryProcess, CustomSummaryProcess.Start)) { min = decimal.MinValue; } if (e.SummaryProcess == CustomSummaryProcess.Calculate) { decimal value = (decimal)e.FieldValue; if (min == decimal.MinValue) { min = max = value; } else { max = Math.Max(max, value); min = Math.Min(min, value); } } if (e.SummaryProcess == CustomSummaryProcess.Finalize) { e.TotalValue = (min + max) / 2; } }
void grid_CustomSummary(object sender, DevExpress.Data.CustomSummaryEventArgs e) { if (object.Equals(e.SummaryProcess, CustomSummaryProcess.Start)) { sum = 0; } if (e.SummaryProcess == CustomSummaryProcess.Calculate) { if (grid.View != null) { if (!checkEdit.IsChecked.Value || view.IsCellSelected(e.RowHandle, grid.Columns[((GridSummaryItem)e.Item).FieldName])) { if (e.FieldValue != DBNull.Value && e.FieldValue != null) { sum += (int)e.FieldValue; } } } } if (e.SummaryProcess == CustomSummaryProcess.Finalize) { e.TotalValue = sum; } }
private void gridView1_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e) { if (!e.IsGroupSummary) { return; } if (e.SummaryProcess == CustomSummaryProcess.Start) { ivalue = 0; dvalue = 0; counter = 0; } if (e.SummaryProcess == CustomSummaryProcess.Calculate) { if (((GridGroupSummaryItem)e.Item).FieldName == "HP") { if (e.GroupRowHandle % 2 == 0) { ivalue += (Int16)e.FieldValue; } else { ivalue += 1; } } if (((GridGroupSummaryItem)e.Item).FieldName == "Liter") { if (e.GroupRowHandle % 2 == 0) { dvalue = Math.Max(dvalue, (double)e.FieldValue); } else { dvalue += (double)e.FieldValue; counter++; } } } if (e.SummaryProcess == CustomSummaryProcess.Finalize) { if (((GridGroupSummaryItem)e.Item).FieldName == "HP") { if (e.GroupRowHandle % 2 == 0) { e.TotalValue = ivalue; } else { e.TotalValue = ivalue; } } if (((GridGroupSummaryItem)e.Item).FieldName == "Liter") { if (e.GroupRowHandle % 2 == 0) { e.TotalValue = dvalue; } else { e.TotalValue = dvalue / counter; } } } }
private void KAgentAdjustmentDetGridView_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e) { if (e.SummaryProcess == CustomSummaryProcess.Finalize) { GridSummaryItem item = e.Item as GridSummaryItem; if (item.FieldName == "Saldo") { e.TotalValue = e.FieldValue; } } }
private void dgProjectTransCategorySum_CustomSummary(object sender, DevExpress.Data.CustomSummaryEventArgs e) { var fieldName = ((GridSummaryItem)e.Item).FieldName; switch (e.SummaryProcess) { case CustomSummaryProcess.Start: Set0(); OnlySum = true; break; case CustomSummaryProcess.Calculate: var row = e.Row as ProjectTransCategorySumClientLocal; if (row == null) { break; } if (row._CatType != CategoryType.Sum) { if (OnlySum) { OnlySum = false; Set0(); } } else if (!OnlySum) { break; } double val = (double)e.FieldValue; switch (fieldName) { case "Qty": sumQty += val; break; case "Cost": sumCost += val; break; case "Sales": sumSales += val; break; case "Margin": sumMargin += val; break; case "BudgetQty": sumBudgetQty += val; break; case "BudgetCost": sumBudgetCost += val; break; case "BudgetSales": sumBudgetSales += val; break; case "Invoiced": sumInvoiced += val; break; case "BudgetInvoiced": sumBudgetInvoiced += val; break; case "InvoicedQty": sumInvoicedQty += val; break; case "BudgetInvoicedQty": sumBudgetInvoicedQty += val; break; } sumSalesValue += row.Sales; sumMarginValue += row.Margin; break; case CustomSummaryProcess.Finalize: switch (fieldName) { case "Qty": e.TotalValue = sumQty; break; case "Cost": e.TotalValue = sumCost; break; case "Sales": e.TotalValue = sumSales; break; case "Margin": e.TotalValue = sumMargin; break; case "BudgetQty": e.TotalValue = sumBudgetQty; break; case "BudgetCost": e.TotalValue = sumBudgetCost; break; case "BudgetSales": e.TotalValue = sumBudgetSales; break; case "Invoiced": e.TotalValue = sumInvoiced; break; case "BudgetInvoiced": e.TotalValue = sumBudgetInvoiced; break; case "InvoicedQty": e.TotalValue = sumInvoicedQty; break; case "BudgetInvoicedQty": e.TotalValue = sumBudgetInvoicedQty; break; } if (fieldName == "MarginRatio" && sumSalesValue > 0) { sumMarginRatio = 100 * sumMarginValue / sumSalesValue; e.TotalValue = sumMarginRatio; } break; } }