009-Json解析

using MySQL.Album;
using MySQL.Models.Album;
using Newtonsoft.Json;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace Json.Submit
{
    /// <summary>
    /// Json_Lyric
    /// </summary>
    public class Json_Lyric : IHttpHandler
    {
        ORM_Testing ormTesting = new ORM_Testing();
        public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType = "text/plain";
            int rows = string.IsNullOrEmpty(context.Request["rows"]) ? 10 : Convert.ToInt32(context.Request["rows"]);
            int page = string.IsNullOrEmpty(context.Request["page"]) ? 1 : Convert.ToInt32(context.Request["page"]);
            JsonString js = ormTesting.GetTesting(rows, page);
            string json = JsonConvert.SerializeObject(js, Formatting.Indented);
            context.Response.Write(json);
        }

        public bool IsReusable
        {
            get
            {
                return false;
            }
        }
        public JsonString GetTesting(int rows, int page)
        {
            int sum = Convert.ToInt32(SqlHelper.ExecuteScalar("select count(*) from Testing"));
            int top = rows * page;
            if (sum % rows > 0 && page == Convert.ToInt32((sum / rows)) + 1)
            {
                rows = sum - rows * (page - 1);
            }
            string sql = "select top " + rows + " * from Testing where Id in (select top " + top + " Id from Testing order by Id)order by Id desc;";
            List<Testing> test = MemoryList(SqlHelper.GetTable(sql), new List<Testing>());
            JsonString js = new JsonString()
            {
                total = sum,
                rows = test.ToArray()
            };
            return js;
        }
    }
    public class JsonString
    {
        public int total { get; set; }
        public Array rows { get; set; }
    }
}

namespace ConsoleApplication_Json
{
    class Program
    {
        static void Main(string[] args)
        {
            string json = "{\"ditu\":[{\"hebei\":\"河北\"},{\"shandong\":\"山东\"},{\"qingdao\":\"青岛\"}] }";
            JObject jObj = (JObject)JsonConvert.DeserializeObject(json);
            string obj = jObj["ditu"][2]["qingdao"].ToString();
            Console.WriteLine(obj);
            Console.ReadKey();
            string array = jObj["ditu"].ToString();
            JArray jArr = (JArray)JsonConvert.DeserializeObject(array);
            string arr = jArr[2]["qingdao"].ToString();
            Console.WriteLine(arr);
            Console.ReadKey();
            string strObj = JsonConvert.SerializeObject(jObj, Formatting.Indented);
            string strArr = JsonConvert.SerializeObject(jArr, Formatting.Indented);
            Console.Write(strObj + strArr);
            Console.ReadKey();
        }
    }
}