c# DotNet.Highcharts switch语句

Question

C# 的新手，在 EF 上苦苦挣扎，并尝试在 foreach 循环中执行 switch/case。我想将查询中的数据从数字更改为字符串。

查询中的数据(键)是 1 2 3。有没有一种可行的方法？

if (selectQuestion.SelectedValue == "1")
                {
                    var data = db.tbl_complaints_data
                        .Where(d => d.organisation_id == o.organisation_id
                        && d.Service == site
                        && d.Date.Month == month
                        && d.Q1 != null)
                        .GroupBy(d => d.Q1)
                        .Select(d => new { q1 = d.Key, total = d.Count() });

                    var segment = new List<object[]>();

                    foreach (var d in data)
                    {
                        segment.Add(new Object[] 
                        { 
                            switch (d.q1.ToString())
                            {
                                case "1":
                                    d.q1.ToString() = "Your care";
                                    break;
                                case "2":
                                    d.q1.ToString() = "Another's care [friend or relative]";
                                    break;
                                case "3":
                                    d.q1.ToString() = "Other type of complaint";
                                    break;
                            }, 
                            d.total
                        });
                    }

                    Render_PieChart(segment);    

如果有任何兴趣，这是饼图。

protected void Render_PieChart(List<object[]> pData)
    {
        DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart")
            .InitChart(new Chart
            {
                DefaultSeriesType = ChartTypes.Pie
            })
            .SetTitle(new Title
            {
                Text = selectQuestion.SelectedItem.Text
            })
            .SetSubtitle(new Subtitle
            {
                Text = selectMonth.SelectedItem.Text
            })
            .SetSeries(new[]
                {
                    new Series 
                    {
                        Data = new DotNet.Highcharts.Helpers.Data(pData.ToArray())
                    }
                })
            .SetCredits(new Credits
            {
                Enabled = false
            });

        ltrChart.Text = chart.ToHtmlString();
    }`

如有任何帮助或建议，我们将不胜感激。

Answer 1

编译器告诉你你的代码是错误的:

1. 不能在 new Object[] init 内部切换 --> Invalid expression term 'switch'
2. 不能将变量分配给 ToString() --> 赋值的左侧必须是变量、属性或索引器<

重写为:

var segment = new List<object[]>();
foreach (var d in data)
{
    string q1String = "Unknown";
    switch (d.q1)
    {
        case 1:
            q1String = "Your care";
            break;
        case 2:
            q1String = "Another's care [friend or relative]";
            break;
        case 3:
            q1String = "Other type of complaint";
            break;
        default:
            break;
    }

    segment.Add(new Object[] 
    { 
        q1String, 
        d.total
    });
}