c# - 在 SQL 中进行乘法运算

Question

我要做一个搜索来返回一个值，我要做的是将两个字段相乘的总和。我有以下代码:

internal double TotalRes(long Id)
{
     double total = 0;
     Reserve rAlias = null;
     var query = Session.QueryOver<Item>();
     query = query.JoinAlias(e => e.Reserve, () => rAlias);
     query = query.Where(() => rAlias.Id == Id);
     query = query.Select(Projections.Sum<Item>(acct => acct.Ammount * acct.Wight));
     object result = query.UnderlyingCriteria.UniqueResult();
     if (result != null)
         total = Convert.ToDouble(result);
     return total;
}

出现以下错误:

the variable 'acct' type 'tem' is referenced in scope '', but it is not set

如何返回这个值？

Answer 1

尝试使用公式在映射中做这样的事情。

Map(c => c.total).formula("(select sum(Ammount * Wight) from acct)");