在 ASP.NET MVC 中将 JSON 格式化为数组

debugcn 发表于 Dev

冰霜粉红

我很难返回格式化JSON为数组的内容。我当前的代码已经JSON作为数组返回，但我想先去掉这些括号[]以获得我想要的输出。

控制器

public JsonResult GenerateGanttChart()
    {
        SPMS_GanttChartLayers ddl = new SPMS_GanttChartLayers();
        var data = ddl.GenerateGanttChart();
        return Json(data, JsonRequestBehavior.AllowGet);
    }

层

public IEnumerable<SPMS_GanttChartRootModel> GenerateGanttChart()
    {
        List<SPMS_GanttChartModel> child_data = new List<SPMS_GanttChartModel>();
        {
            using (SqlConnection con = new SqlConnection(Conn.MyConn()))
            {
                SqlCommand com = new SqlCommand("dbo.sp_SPMS_GanttChart 7078, 1", con);
                con.Open();
                SqlDataReader reader = com.ExecuteReader();
                while (reader.Read())
                {
                    SPMS_GanttChartModel value = new SPMS_GanttChartModel();
                    value.id = Convert.ToInt32(reader.GetValue(0));
                    value.start_date = Convert.ToString(reader.GetValue(1));
                    value.duration = Convert.ToInt32(reader.GetValue(2));
                    value.text = Convert.ToString(reader.GetValue(3));
                    child_data.Add(value);
                }
            }

        }
        List<SPMS_GanttChartRootModel> array = new List<SPMS_GanttChartRootModel>();
        {
            SPMS_GanttChartRootModel value = new SPMS_GanttChartRootModel();
            value.data = child_data;
            array.Add(value);
        };
        return array;
    }

电流输出

[{
"data": [{
    "id": 1,
    "start_date": "11/07/2017 08:00:00 AM",
    "duration": 23,
    "text": "Project #1"
}, ... ]
}]

期望输出

{
"data": [{
    "id": 1,
    "start_date": "11/07/2017 08:00:00 AM",
    "duration": 23,
    "text": "Project #1"
}, ... ]
}

许久

目前，您正在List<SPMS_GanttChartRootModel>从您的GenerateGanttChart方法中返回 a 。

返回SPMS_GanttChartRootModel对象。

SPMS_GanttChartRootModel value = new SPMS_GanttChartRootModel();
value.data = child_data;
return value;

还要确保您的方法的返回类型SPMS_GanttChartRootModel现在是

public SPMS_GanttChartRootModel  GenerateGanttChart()
{
    var child_data = new List<SPMS_GanttChartModel>();
    {
        //your existing code to populate this collection
    };

     var value = new SPMS_GanttChartRootModel();
     value.data = child_data;
     return value;
}

并在您的操作方法中，将此单个对象传递给该Json方法

public JsonResult GenerateGanttChart()
{
    var ddl = new SPMS_GanttChartLayers();
    var data = ddl.GenerateGanttChart();
    return Json(data, JsonRequestBehavior.AllowGet);
}

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。