private void dgProjInvProposedLineGrid_CustomSummary(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
var fieldName = ((GridSummaryItem)e.Item).FieldName;
switch (e.SummaryProcess)
{
case DevExpress.Data.CustomSummaryProcess.Start:
sumMargin = sumSales = 0d;
break;
case DevExpress.Data.CustomSummaryProcess.Calculate:
var row = e.Row as ProjectInvoiceProposalLineClient;
sumSales += row.SalesValue;
sumMargin += row.Margin;
break;
case DevExpress.Data.CustomSummaryProcess.Finalize:
if (fieldName == "MarginRatio" && sumSales > 0)
{
sumMarginRatio = 100 * sumMargin / sumSales;
e.TotalValue = sumMarginRatio;
}
break;
}
}
private void grdViewCamp_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
int lCount = 0;
double Tot = 0;
if (((DevExpress.XtraGrid.GridSummaryItem)e.Item).FieldName == "Amount")
{
if (grdViewCamp.RowCount > 0)
{
for (lCount = 0; lCount < grdViewCamp.RowCount; lCount++)
{
if (grdViewCamp.GetRowCellValue(lCount, "Amount") != DBNull.Value && grdViewCamp.GetRowCellValue(lCount, "Description") != null)
{
if (grdViewCamp.GetRowCellValue(lCount, "Flag").ToString() == "+")
{
Tot = (Tot + Convert.ToDouble(grdViewCamp.GetRowCellValue(lCount, "Amount")));
}
else
{
Tot = (Tot - Convert.ToDouble(grdViewCamp.GetRowCellValue(lCount, "Amount")));
}
}
}
}
e.TotalValue = Tot + Convert.ToDouble(m_dBaseAmt);
}
}
private void gridView_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
var item = e.Item as GridColumnSummaryItem;
var view = sender as GridView;
if (item != null && Equals("summary", item.Tag))
{
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Start)
{
_resSumm = 0;
}
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Calculate)
{
try
{
dynamic prc = double.Parse(view.GetRowCellValue(e.RowHandle, "Price").ToString());
dynamic qty = view.GetRowCellValue(e.RowHandle, "QuantityRet");
dynamic ret = prc * qty;
_resSumm += ret;
}
catch (Exception)
{
_resSumm = 0;
}
}
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Finalize)
{
e.TotalValue = _resSumm;
e.TotalValueReady = true;
}
}
}
private void gridView1_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Finalize && ((GridGroupSummaryItem)e.Item).Tag.Equals(1))
{
e.TotalValue = (sender as GridView).GetGroupRowValue(e.RowHandle);
}
}
protected void grid_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Start)
{
totalSumUnitPrice = 0;
totalSumUnitsInStock = 0;
}
else
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Calculate)
{
totalSumUnitPrice += Convert.ToDecimal(e.GetValue("UnitPrice"));
totalSumUnitsInStock += Convert.ToDecimal(e.GetValue("UnitsInStock"));
}
else
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Finalize)
{
if (totalSumUnitPrice != 0)
{
e.TotalValue = (totalSumUnitPrice - totalSumUnitsInStock) / totalSumUnitPrice;
}
else
{
e.TotalValue = 0;
}
}
}
private void grdview_list_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e) // timespan türündeki konuşma süresini hesaplar
{
GridView view = sender as GridView;
int summaryID = Convert.ToInt32((e.Item as GridSummaryItem).Tag);
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Start)
{
topsure = new TimeSpan(0, 0, 0);
topsuregrup = new TimeSpan(0, 0, 0);
topsuregrup4avg_dk = 0;
sayigrup4avg = 0;
}
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Calculate)
{
switch (summaryID)
{
case 1:
topsure += (TimeSpan)e.FieldValue;
//int abc = Convert.ToInt32(view.GetRowCellValue(e.RowHandle, "CAG_ID")); //başka bir kolonla işlem yapmak için böyle alabilirsin.
break;
case 2:
topsuregrup += (TimeSpan)e.FieldValue;
break;
case 3:
topsuregrup4avg_dk += ((TimeSpan)e.FieldValue).TotalMinutes;
sayigrup4avg += 1;
break;
default:
break;
}
}
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Finalize)
{
switch (summaryID)
{
case 1:
e.TotalValue = topsure;
break;
case 2:
e.TotalValue = topsuregrup;
break;
case 3:
//e.TotalValue = new TimeSpan(0,Convert.ToInt32(topsuregrup4avg / sayigrup4avg), 0) + " Dk.";
ortalama_sn = topsuregrup4avg_dk * 60 / sayigrup4avg;
e.TotalValue = new TimeSpan(0, Convert.ToInt32(ortalama_sn) / 60, Convert.ToInt32(ortalama_sn % 60)); //dakikada; division için "/" sayı integer olunca küsüratı görmeden tam bölmeyi verdiği için Convert.ToInt32(ortalama_sn)/60 şeklinde yazdım.
break;
default:
break;
}
}
}
//AppearanceDefault amountCostTempSumAppr = new AppearanceDefault(Color.Black, Color.Empty, new Font(AppearanceObject.DefaultFont, FontStyle.Bold));
//Rectangle amountCostSummaryBound;
//string amountCostSummaryText;
//private void orderDetailGridView_CustomDrawFooterCell(object sender, DevExpress.XtraGrid.Views.Grid.FooterCellCustomDrawEventArgs e)
//{
//}
private void orderDetailGridView_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
GridColumnSummaryItem customSummaryItem = e.Item as GridColumnSummaryItem;
vp100kgInWIR = currentOrder.OilPrice * currentOrder.WIRFactor;
vp100kgInWIR = Math.Round(vp100kgInWIR, 2, MidpointRounding.AwayFromZero);
//vp100kgInWIR = vp100kgInWIR + GetOrderDetailsPrice();
//if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Calculate)
//{
// //amountCostTemp = parentOrder.OilPrice + GetOrderDetailPrice();
//}
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Finalize)
{
//summary column 1
if (customSummaryItem.FieldName == OilOrderDetailSummaryColumnCategory.Col1Row1.Key)
{
currentOrder.AdditionalCosts = Convert.ToDecimal(e.TotalValue);
currentOrder.Total2CashPrice = currentOrder.Total2CashPrice + currentOrder.AdditionalCosts + +currentOrder.UnloadCost;
e.TotalValue = GetOrderDetailsPrice();
}
else if (customSummaryItem.FieldName == OilOrderDetailSummaryColumnCategory.Col1Row2.Key)
{
e.TotalValue = GetUnloadPlaceCost();
}
else if (customSummaryItem.FieldName == OilOrderDetailSummaryColumnCategory.Col1Row3.Key)
{
e.TotalValue = vp100kgInWIR;
}
else if (customSummaryItem.FieldName == OilOrderDetailSummaryColumnCategory.Col1Row4.Key)
{
e.TotalValue = currentOrder.OilPrice;
}
//summary column2
if (customSummaryItem.FieldName == OilOrderDetailSummaryColumnCategory.Col2Row1.Key)
{
currentOrder.Total1Price = GetTotalIPrice();
currentOrder.Total2CashPrice = GetTotalIIPrice() + GetUnloadPlaceCost() + currentOrder.AdditionalCosts;
e.TotalValue = currentOrder.Total1Price + currentOrder.Total2CashPrice;
}
else if (customSummaryItem.FieldName == OilOrderDetailSummaryColumnCategory.Col2Row2.Key)
{
e.TotalValue = (GetTotalIPrice() + (GetTotalIIPrice() + GetUnloadPlaceCost() + currentOrder.AdditionalCosts)) / 2;
}
else if (customSummaryItem.FieldName == OilOrderDetailSummaryColumnCategory.Col2Row3.Key)
{
e.TotalValue = GetTotalIIPrice() + GetUnloadPlaceCost() + currentOrder.AdditionalCosts;
}
else if (customSummaryItem.FieldName == OilOrderDetailSummaryColumnCategory.Col2Row4.Key)
{
e.TotalValue = GetTotalIPrice();
}
}
}
protected void ASPxGridView1_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
ASPxSummaryItem incomeSummary = (sender as ASPxGridView).TotalSummary["Income"];
ASPxSummaryItem expenseSummary = (sender as ASPxGridView).TotalSummary["Expense"];
Decimal income = Convert.ToDecimal(((ASPxGridView)sender).GetTotalSummaryValue(incomeSummary));
Decimal expense = Convert.ToDecimal(((ASPxGridView)sender).GetTotalSummaryValue(expenseSummary));
e.TotalValue = income - expense;
}
protected void ASPxCardView1_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
ASPxCardViewSummaryItem orderedUnits = (sender as ASPxCardView).TotalSummary["UnitsOnOrder"];
ASPxCardViewSummaryItem averagePrice = (sender as ASPxCardView).TotalSummary["UnitPrice"];
Int32 intOrderedUnits = Convert.ToInt32(((ASPxCardView)sender).GetTotalSummaryValue(orderedUnits));
Int32 intAveragePrice = Convert.ToInt32(((ASPxCardView)sender).GetTotalSummaryValue(averagePrice));
e.TotalValue = intOrderedUnits * intAveragePrice;
}
private void gridView1_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
if (e.IsTotalSummary)
{
decimal _total = Convert.ToDecimal(gridView1.Columns["total"].SummaryItem.SummaryValue);
e.TotalValue = _total;
e.TotalValueReady = true;
txt_total.Text = e.TotalValue.ToString();
calculating_value();
}
}
private void DgInvBomclientGrid_CustomSummary(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
switch (e.SummaryProcess)
{
case DevExpress.Data.CustomSummaryProcess.Start:
sumQty = sumCostValue = sumSalesValue = sumCartons = sumWeight = sumVolume = 0d;
break;
case DevExpress.Data.CustomSummaryProcess.Calculate:
var row = e.Row as InvBOMClient;
if (row._ItemType <= Uniconta.DataModel.ItemType.Service)
{
sumQty += row.Qty;
sumCostValue += row.CostValue;
sumSalesValue += row.SalesValue;
sumCartons += row.Cartons;
sumWeight += row.Weight;
sumVolume += row.Volume;
}
break;
case DevExpress.Data.CustomSummaryProcess.Finalize:
var fieldName = ((GridSummaryItem)e.Item).FieldName;
switch (fieldName)
{
case "Qty":
e.TotalValue = sumQty;
break;
case "CostValue":
e.TotalValue = sumCostValue;
break;
case "SalesValue":
e.TotalValue = sumSalesValue;
break;
case "Cartons":
e.TotalValue = sumCartons;
break;
case "Weight":
e.TotalValue = sumWeight;
break;
case "Volume":
e.TotalValue = sumVolume;
break;
}
break;
}
}
private void UiVistaPrincipal_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Start)
{
e.TotalValue = TimeSpan.Zero;
}
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Calculate)
{
var ts = TimeSpan.Parse(e.FieldValue.ToString());
e.TotalValue = ts + (TimeSpan)e.TotalValue;
}
}
private void gridView2_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
GridColumnSummaryItem customSummaryItem = e.Item as GridColumnSummaryItem;
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Finalize)
{
//summary column 1
if (customSummaryItem.FieldName == "Col1Row1")
{
e.TotalValue = _MarginCalculation.GetMarginSummarize(_Model);
}
}
}
private void GridView_SalaryProcess_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
GridView view = sender as GridView;
if (e.IsTotalSummary && (e.Item as GridSummaryItem).FieldName == "EmpSalary")
{
GridSummaryItem item = e.Item as GridSummaryItem;
if (item.FieldName == "EmpSalary")
{
//e.TotalValue = ConvertTo.MinutesToHours(view.Columns["EmpSalary"].SummaryText);
}
}
}
protected void ASPxGridView1_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
decimal totalPrice = 0;
int startIndex = ((ASPxGridView)sender).PageIndex * ((ASPxGridView)sender).SettingsPager.PageSize;
int endIndex = startIndex + ((ASPxGridView)sender).SettingsPager.PageSize;
for (int i = startIndex; i < endIndex; i++)
{
decimal currentPrice = Convert.ToDecimal(((ASPxGridView)sender).GetRowValues(i, "UnitPrice"));
totalPrice = totalPrice + currentPrice;
}
e.TotalValue = totalPrice;
}
private void GridView_AttendanceData_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
GridView view = sender as GridView;
if (e.IsTotalSummary && (e.Item as GridSummaryItem).FieldName == "OverTime")
{
GridSummaryItem item = e.Item as GridSummaryItem;
if (item.FieldName == "OverTime")
{
e.TotalValue = ConvertTo.MinutesToHours(view.Columns["OverTime_1"].SummaryText);
}
}
}
private void grvItems_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
if (!DesignMode)
{
if (((DevExpress.XtraGrid.GridColumnSummaryItem)e.Item).FieldName == colTotal.FieldName)
{
if (ResultItem != null)
{
e.TotalValue = Total + (ResultItem.UnitAverage * ((DB.ITM_BOM_Recipe)BindingSource.DataSource).QuantityResult);
}
}
}
}
private void grid_CustomSummary(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Start)
{
e.TotalValue = 0;
}
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Calculate)
{
if ((bool)e.GetValue("Selected"))
{
e.TotalValue = Convert.ToDecimal(e.TotalValue) +
Convert.ToDecimal(e.GetValue("UnitPrice"));
}
}
}
//비가동시간 summary
private void gridView1_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
try
{
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Start)
{
e.TotalValue = TimeSpan.Zero;
}
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Calculate)
{
TimeSpan ts = TimeSpan.Parse(e.FieldValue.ToString());
e.TotalValue = ts + (TimeSpan)e.TotalValue;
}
}
catch { }
}
/// <summary>
/// Calculates the total field
/// </summary>
private void gvTender_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
switch (e.SummaryProcess)
{
case DevExpress.Data.CustomSummaryProcess.Start:
e.TotalValueReady = true;
break;
case DevExpress.Data.CustomSummaryProcess.Finalize:
e.TotalValue = Dialog.InternalApplication.Services.Rounding.RoundForDisplay(total, true, true);
break;
default:
break;
}
}
public void to_time_span(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
DevExpress.XtraGrid.Views.Grid.GridView grid = sender as DevExpress.XtraGrid.Views.Grid.GridView;
int summaryID = Convert.ToInt32((e.Item as DevExpress.XtraGrid.GridSummaryItem).Tag);
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Start)
{
ts = new TimeSpan(00, 00, 00);
}
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Calculate)
{
//int until = (grid.GetRowCellValue(e.RowHandle, "time_span"));
ts += TimeSpan.Parse(grid.GetRowCellValue(e.RowHandle, "time_span").ToString());
}
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Finalize)
{
var strin_f = ts.TotalHours.ToString();
string itog;
if (strin_f.Contains(','))
{
var len = strin_f.IndexOf(',', 0);
if (ts.Minutes.ToString().Length > 1)
{
itog = strin_f.Substring(0, len) + ":" + ts.Minutes;
e.TotalValue = itog;
}
else
{
itog = strin_f.Substring(0, len) + ":0" + ts.Minutes;
e.TotalValue = itog;
}
}
else
{
if (ts.Minutes.ToString().Length > 1)
{
itog = strin_f + ":" + ts.Minutes;
e.TotalValue = itog;
}
else
{
itog = strin_f + ":0" + ts.Minutes;
e.TotalValue = itog;
}
}
}
}
private void gridView1_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
GridView view = sender as GridView;
if (e.Item != titleItem)
{
return;
}
if (e.SummaryProcess != DevExpress.Data.CustomSummaryProcess.Finalize)
{
return;
}
GridColumn col = view.GroupedColumns[e.GroupLevel];
object value = view.GetGroupRowValue(e.GroupRowHandle);
e.TotalValue = string.Format("Totale {0} {1}", col.GetCaption(), value);
}
private void gridViewStockTaking_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
var item = e.Item as GridColumnSummaryItem;
if (item.FieldName == "DifferenceQty")
{
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Start)
{
diffCount = 0;
}
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Calculate)
{
if (e.FieldValue != null)
{
diffCount += Math.Abs(int.Parse(e.FieldValue.ToString()));
}
}
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Finalize)
{
e.TotalValue = diffCount;
}
}
if (item.FieldName == "DiffAmount")
{
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Start)
{
diffAmount = 0;
}
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Calculate)
{
if (e.FieldValue != null)
{
diffAmount += Math.Abs(double.Parse(e.FieldValue.ToString()));
}
}
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Finalize)
{
e.TotalValue = diffAmount;
}
}
}
private void grvItems_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
if (!DesignMode)
{
if (((DevExpress.XtraGrid.GridColumnSummaryItem)e.Item).FieldName == colTotalAmount.FieldName)
{
if ((DocumentType == BL.SYS.SYS_DOC_Type.SalesOrder || DocumentType == BL.SYS.SYS_DOC_Type.TAXInvoice || DocumentType == BL.SYS.SYS_DOC_Type.Quote) && Doc_Header.ORG_TRX_Header.Rounding != 0)
{
e.TotalValue = TotalIncl + Doc_Header.ORG_TRX_Header.Rounding;
}
else
{
e.TotalValue = TotalIncl;
}
}
}
}
private void gridControl1_CustomSummary(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{//自定义计划合计
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Start)
{
totalImpressions = totalClick = totalPaycount = 0;
totalCost = totalPay = 0D;
}
else if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Calculate)
{
long impressions = Convert.ToInt64(e.GetValue("impressions"));
totalImpressions += impressions;
long click = Convert.ToInt64(e.GetValue("click"));
totalClick += click;
double cost = Convert.ToDouble(e.GetValue("cost"));
totalCost += cost;
double pay = Convert.ToDouble(e.GetValue("totalpay"));
totalPay += pay;
int paycount = Convert.ToInt32(e.GetValue("totalpaycount"));
totalPaycount += paycount;
}
else if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Finalize)
{
DevExpress.Xpf.Grid.GridSummaryItem item = e.Item as DevExpress.Xpf.Grid.GridSummaryItem;
if (totalImpressions != 0 && item.FieldName == "ctr")
{
e.TotalValue = string.Format("平均={0}%", Math.Round(totalClick * 100.0 / totalImpressions, 2));
}
else if (totalClick != 0 && item.FieldName == "cpc")
{
e.TotalValue = string.Format("平均={0}", Math.Round(totalCost / totalClick, 2));
}
else if (totalCost != 0 && item.FieldName == "roi")
{
e.TotalValue = string.Format("平均={0}", Math.Round(totalPay / totalCost, 2));
}
else if (totalClick != 0 && item.FieldName == "rate")
{
e.TotalValue = string.Format("平均={0}%", Math.Round(totalPaycount * 100.0 / totalClick, 2));
}
else
{
e.TotalValue = "平均=0.00%";
}
}
}
/// <summary>
/// Calculate the focused views summary information
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void grvItems_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
DevExpress.XtraGrid.Views.Grid.GridView currentChildGrid = (sender as DevExpress.XtraGrid.Views.Grid.GridView);
if (currentChildGrid.DataSource == null)
{
e.TotalValue = 0;
}
else
{
e.TotalValue = (currentChildGrid.DataSource as System.Collections.Generic.List <BulkPaymentItem>).Where(n => n.Checked).Sum(s => s.Balance)
- (
((BulkPaymentEntry)(grvEntries.GetFocusedRow())).Amount
+
((BulkPaymentEntry)(grvEntries.GetFocusedRow())).Settlement
);
}
}
protected void ASPxGridView1_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
switch (e.SummaryProcess)
{
case DevExpress.Data.CustomSummaryProcess.Start: summary = 0; break;
case DevExpress.Data.CustomSummaryProcess.Calculate:
if (e.GroupLevel == 1 || (bool)e.GetValue("Discontinued"))
{
summary += Convert.ToInt32(e.GetValue("UnitsInStock"));
}
break;
case DevExpress.Data.CustomSummaryProcess.Finalize:
e.TotalValue = summary;
e.TotalValueReady = true;
break;
}
}
//List<Object> listToSummary = new List<Object>();
private void gridViewTaiSan_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
//try
//{
// if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Calculate)
// listToSummary.Add(e.FieldValue);
// else
// {
// List<Object> tmp = listToSummary.Distinct().ToList();
// tmp.Remove("");
// e.TotalValue = tmp.Count();
// listToSummary.Clear();
// }
//}
//catch (Exception ex)
//{
// Debug.WriteLine(this.Name + "->gridViewTaiSan_CustomSummaryCalculate:" + ex.Message);
//}
}
private void gvProjects_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
GridView View = sender as GridView;
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Start)
{
count = 0;
}
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Calculate)
{
if (ConvertSafe.ToBoolean(View.GetDataRow(e.RowHandle).Item("ProjectIsActived")) == true)
{
count = count + 1;
}
e.TotalValue = count;
}
if (e.SummaryProcess == DevExpress.Data.CustomSummaryProcess.Finalize)
{
}
}
private void grdViewSOA_CustomSummaryCalculate(object sender, DevExpress.Data.CustomSummaryEventArgs e)
{
int lCount = 0;
decimal Tot = 0;
if (((DevExpress.XtraGrid.GridSummaryItem)e.Item).FieldName == "CumulativeAmount")
{
if (grdViewSOA.RowCount > 0)
{
for (lCount = 0; lCount < grdViewSOA.RowCount; lCount++)
{
if (grdViewSOA.GetRowCellValue(lCount, "Balance") != DBNull.Value)
{
Tot = (Tot + Convert.ToDecimal(grdViewSOA.GetRowCellValue(lCount, "Balance")));
}
}
}
e.TotalValue = Tot;
}
}
