在我的項目(ASP.net MVC)中,我必須以小寫形式返回函數名稱(我讀入的 CSV 文件)。因為現在我已經對函數進行了分組,并且它返回具有相同名稱的函數(有時是小寫,有時是大寫)。我不知道如何解決這個問題?//HomeControllerpublic List<DescFunctionDataDTO> DescFunctionData(){ Console.WriteLine("DescFunctionData"); var descItemsStamp = db.ChartDatas .GroupBy(x => new { x.Function }); var descItems = descItemsStamp .Select(x => new DescFunctionDataDTO { function = x.Select(b => b.Function).Distinct(), functionavg = Math.Round(x.Average(y => y.Duration), 2), }) .OrderByDescending(x => x.functionavg) .ToList(); return descItems;}//DTOpublic class DescFunctionDataDTO{ public IEnumerable<string> function { get; set; } public double functionavg { get; set; }}//JS-Filefunction showDescDuration() { $.getJSON(`/Home/DescFunctionData`) .then(data => { console.log(data); $('#rankingMax').find("tr:gt(0)").fadeOut().empty(); var i = 1; for (let item of data) { console.log('loop'); $('<tr>').appendTo('#rankingMax') .append($('<td>').html("#"+i)) .append($('<td>').html(item.function)) .append($('<td>').html(item.functionavg + " ms")); i++; } });}
1 回答

ITMISS
TA貢獻1871條經驗 獲得超8個贊
您可以像這樣使用預定義函數 string.ToLower() ,
var descItemsStamp = db.ChartDatas
.GroupBy(x => new { x.Function });
var descItems = descItemsStamp
.Select(x => new DescFunctionDataDTO
{
function = x.Select(b => b.Function.ToLower()).Distinct(),
functionavg = Math.Round(x.Average(y => y.Duration), 2),
})
.OrderByDescending(x => x.functionavg)
.ToList();
return descItems;
- 1 回答
- 0 關注
- 98 瀏覽
添加回答
舉報
0/150
提交
取消