有什么方法在Linq.JS中用SUM过滤吗?
我的尝试:
var query = Enumerable
.From(self.data())
.Where("$$.Sum($.percent) > 100")
.ToArray();错误:
linq.js: Uncaught:$$.Sum不是一个函数
发布于 2016-12-23 17:44:50
下面是我使用并解决的代码:
self.validatePercentualSumOfItens = () => {
const sumOfGroupedItens = Enumerable
.From(self.dadosCobranca().configuracoes())
.Where("$.idAgrupadorRateio != null && $.idAgrupadorRateio != -1")
.GroupBy("{ idAgrupadorRegra: $.idAgrupadorRegra,
idAgrupadorRateio: $.idAgrupadorRateio
}",
"parseFloat($.percentualRateio)",
"{ idAgrupadorRegra: $.idAgrupadorRegra,
idAgrupadorRateio: $.idAgrupadorRateio,
total: parseFloat($$.Sum()).toFixed(2)
}",
"$.idAgrupadorRegra + '-' + $.idAgrupadorRateio")
.ToArray();
const itensThatNotMatchAHundred = Enumerable
.From(sumOfGroupedItens)
.Where("$.total < 100 || $.total > 100")
.ToArray();
return itensThatNotMatchAHundred.length;
};https://stackoverflow.com/questions/41268190
复制相似问题