剑道网格不读取json数据

本文关键字:json 数据 读取 网格 | 更新日期: 2023-09-27 17:50:53

这是我的javascript代码,我用来执行crud上的剑道记住我使用api调用,在测试中我必须只使用json数据

  document.onreadystatechange = function () {

var viewModel = kendo.observable({
    products: new kendo.data.DataSource({

        transport: {
            read: {
              type: "GET",
                url: "/api/Companies/GetAllCompanies2",
                dataType: "json"
            },
            create: {
                 type: "PUT",
                    url: "/api/Companies/UpdateDefCompny",
                  contentType: "application/json; charset=utf-8",
                    dataType: "json",
                async: false
            },
            update: {
                url:"/api/Companies/SaveDefCompny",
                async: false,
                contentType: "application/json",
                dataType: "json",
                type: "POST"
                 // here you need correct api url
            },
            destroy: {
                url: "/api/Companies/Delete", // here you need correct api url
                dataType: "json"
            },

            parameterMap: function (data, operation) {
                if (operation !== "read" && data) {
                    return JSON.stringify(data.models[0]);
                }
            }
        },
        serverPaging: true,
        serverFiltering: true,
        pageSize: 10,
        schema: {
            //data:"Data",
            total: "Count",
            model: {
                id: "Id",
                fields: {
                    Id: { type: "int" },
                    CurrentCurrencyCode: { editable: true, type: "int" },
                    ShortName: { editable: true, type: "string" },
                    FullName: { editable: true, type: "string" },
                    ContactPerson: { editable: true, type: "string" },
                    Address1: { editable: true, type: "string" },
                    CompanyCity: { editable: true, type: "string" },
                    CompanyState: { editable: true, type: "string" },
                    CompanyCountry: { editable: true, type: "string" },
                    ZipPostCode: { editable: true, type: "string" },
                    TelArea: { editable: true, type: "string" }
                }
            }
        },
        batch: true,

    }) 

});

   kendo.bind(document.getElementById("example"), viewModel);
  }

这是我的服务器端代码返回json数据,我已经测试过了,它成功返回json数据,我需要它,因为它是

   [HttpGet]
    public string GetAllCompanies2()
    {
        List<object> myCo = DefCompany.AllDefCompany2;

        object json = JsonConvert.SerializeObject(myCo);
        return json.ToString();
    }
网格代码:

  <div id="example">
    <div id="kendoGrid"
         data-role="grid"
         data-pageable=" true"
         data-sortable=" true"
         data-filterable="true"
         data-toolbar="['create','save', 'cancel']"
         data-editable="inline"
         data-columns="[
      { 'field': 'Id', 'width': 100 },
           { 'field': 'CurrentCurrencyCode', 'width': 100 },
              { 'field': 'ShortName', 'width': 100 },
          { 'field': 'FullName', 'width': 100 },
       { 'field': 'ContactPerson', 'width': 100 },
         { 'field': 'Address1', 'width': 100 },
       { 'field': 'CompanyCity', 'width': 100 },
         { 'field': 'CompanyState', 'width': 100 },
          { 'field': 'CompanyCountry', 'width': 100 },
          { 'field': 'ZipPostCode', 'width': 100 },
      { 'field': 'TelArea', 'width': 100 },
      { command: ['edit'], title: 'Actions', width: '250px' },
     ]"
         data-bind="source: products"
         style=" height :500px"></div>
</div>
<div>



</div>

这里的问题是为什么kendo grid不填充json数据它只填充当我反序列化或返回对象,但我必须填充json?

剑道网格不读取json数据

在global.aspx.cs文件

     using System.Data.Entity;
  namespace RpManticSolAPI
  {
  public class WebApiApplication : System.Web.HttpApplication
{
    protected void Application_Start()
    {
        GlobalConfiguration.Configure(WebApiConfig.Register);
        GlobalConfiguration.Configuration.Formatters.JsonFormatter.SerializerSettings.ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore;
        GlobalConfiguration.Configuration.Formatters.Remove(GlobalConfiguration.Configuration.Formatters.XmlFormatter);          
    }
}
   }

而不是:

[HttpGet]
public string GetAllCompanies2()
{
    List<object> myCo = DefCompany.AllDefCompany2;

    object json = JsonConvert.SerializeObject(myCo);
    return json.ToString();
}

这样做:

[HttpGet]
public List<object> GetAllCompanies2()
{
    List<object> myCo = DefCompany.AllDefCompany2;
    return myCo;
}

你的数据将返回为纯json,不需要解析。