本文整理汇总了C#中XPCollection.Sum方法的典型用法代码示例。如果您正苦于以下问题：C# XPCollection.Sum方法的具体用法？C# XPCollection.Sum怎么用？C# XPCollection.Sum使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类XPCollection的用法示例。
在下文中一共展示了XPCollection.Sum方法的3个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetCost
public decimal GetCost(int year, Supplier supplier)
{
try
{
DateTime minValue = new DateTime(year, 1, 1);
DateTime maxValue = new DateTime(year, 12, 31);
var cost = new XPCollection<Cost>(uow, Cost.Fields.tas_TNR_SUPPLIER == supplier
& Cost.Fields.Date >= minValue & Cost.Fields.Date <= maxValue);
return cost.Sum(q => q.PurchaseAmount);
}
catch (Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
}示例2: GetAverageTurnOverMonthByYearBySupplier
public decimal GetAverageTurnOverMonthByYearBySupplier(int year, Supplier supplier)
{
Decimal cost = 0;
try
{
DateTime minValue = new DateTime(year, 1, 1);
DateTime maxValue = new DateTime(year, 12, 31);
XPCollection<Cost> costs = new XPCollection<Cost>(uow, Cost.Fields.tas_TNR_SUPPLIER == supplier
& Cost.Fields.Date >= minValue & Cost.Fields.Date <= maxValue);
decimal months = 1;
if (minValue.Year == DateTime.Now.Year)
months = Math.Round(Convert.ToDecimal(System.DateTime.Now.Subtract(minValue).TotalDays) / Convert.ToDecimal(30.5), 0);
else
months = 12;
cost = costs.Sum(q => q.PurchaseAmount) / months;
}
catch (Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
return cost;
}示例3: GetAverageTurnOverMonthGreaterThanDateBySupplier
public decimal GetAverageTurnOverMonthGreaterThanDateBySupplier(DateTime date, Supplier supplier)
{
Decimal cost = 0;
try
{
XPCollection<Cost> costs = new XPCollection<Cost>(uow, Cost.Fields.tas_TNR_SUPPLIER == supplier
& Cost.Fields.Date >= date);
decimal months = Math.Round(Convert.ToDecimal(System.DateTime.Now.Subtract(date).TotalDays) / Convert.ToDecimal(30.5), 0);
cost = costs.Sum(q => q.PurchaseAmount) / months;
}
catch (Exception exception1)
{
Exception innerException = exception1;
throw new Exception(MethodBase.GetCurrentMethod().Name, innerException);
}
return cost;
}