Web API

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Mvc;
using System.Net.Http;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using MyERP;
using System.Data;
using System.Data.SqlClient;
using System.Text.RegularExpressions;

namespace WebApplication1.Controllers
{

    /*
    1.安装
    Microsoft.AspNetCore.Mvc.WebApiCompatShim
    2.Startup.cs
    public void ConfigureServices(IServiceCollection services)
    {
        services.AddMvc().AddWebApiConventions();      
    }
    */
    public class ValuesController : Controller
    {
        [Route("xiaoxiao/Get")]
        [HttpGet]
        public int Get(int id,string t)
        {
            return id * id;
        }

        [Route("xiaoxiao/Query")]
        [HttpPost]
        public HttpResponseMessage Query([FromBody]JObject postin)
        {
            object a = postin["dict_key"];
            object b = postin["detail_name"];
            string sql =string.Format( @"SELECT * FROM dbo.y_dict where dict_key={0} or detail_name='{1}'",a,b);
 
            JObject rlt = new JObject();
            try
            {
                dDataBase db = new dDataBase();
                DataTable dt = db.GetDataTable(sql);
                JArray arr = JArray.FromObject(dt);
                
                int errid = 0;
                rlt.Add("errid", errid);
                rlt.Add("errmsg", "");
                rlt.Add("result", arr);
            }
            catch (Exception exp)
            {
                rlt.Add("errid", -1);
                rlt.Add("errmsg", exp.Message);
                rlt.Add("result", "");

            }

            string result = JsonConvert.SerializeObject(rlt);
            return new HttpResponseMessage { Content = new StringContent(result, System.Text.Encoding.GetEncoding("UTF-8"), "application/json") };
           

        }
 
    }
}