省市区 【构建对象】转换成json

省市区 构建对象转换成json

using NewOjbect.Models;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Web.Script.Serialization;

namespace NewOjbect.Controllers
{
    public class HomeController : Controller
    {
        salesEntities db = new salesEntities();
        JavaScriptSerializer jsz = new JavaScriptSerializer();
        //
        // GET: /Home/

        public ActionResult Index()
        {
            ViewData["abc"] = Pro_city();
            return View();
        }

        public string Pro_city()
        {
            var list_pro = db.S_Province.ToList(); //省
            var list_city = db.S_City.ToList();  //市
            var list_District = db.S_District.ToList(); //区县


            var result = from f in list_pro //遍历省，构建对象
                         //遍历市，构建对象
                         select new
                         {
                             proName = f.ProvinceName,
                             cities = (from c in list_city
                                       where c.ProvinceID == f.ProvinceID
                                       select new
                                       {
                                           //遍历区县（其实遍历的结果就是一个“区县名”的list集合）
                                           c.CityName,
                                           disName = (from d in list_District where c.CityID == d.CityID select d.DistrictName)
                                       })
                         };

            var s = new { jsonData = result }; //再构建一个自定义对象
            string strJson = jsz.Serialize(s);//将这个对象转换成一个json

            return strJson;
        }

    }
}

省市区三个表

转成的json的结果

上面的构建的对象仅仅是包含省名，市名，区名称。同样我们构建的对象也可以包含三个表所有的数据：如下

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

using NewOjbect.Models;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Web.Script.Serialization;

namespace NewOjbect.Controllers
{
    public class HomeController : Controller
    {
        salesEntities db = new salesEntities();
        JavaScriptSerializer jsz = new JavaScriptSerializer();
        //
        // GET: /Home/

        public ActionResult Index()
        {
            ViewData["abc"] = pro_cityTow();
            return View();
        }

        //上面的构建的对象仅仅是包含省名，市名，区名称。同样我们构建的对象也可以包含三个表所有的数据
        public string pro_cityTow()
        {
            var list_pro = db.S_Province.ToList(); //省
            var list_city = db.S_City.ToList();  //市
            var list_District = db.S_District.ToList(); //区县

            //遍历省
            var result = from f in list_pro
                         //构建对象
                         select new
                         {
                             proName = f,
                             cities = (from c in list_city  //遍历市
                                       where c.ProvinceID == f.ProvinceID
                                       select new //构建对象
                                       {

                                           c,
                                           //遍历区县（其实遍历的结果就是一个“区县”的list集合）
                                           disName = (from d in list_District where c.CityID == d.CityID select d)
                                       })
                         };

            var s = new { jsonData = result }; //再构建一个自定义对象
            string strJson = jsz.Serialize(s);//将这个对象转换成一个json

            return strJson;

        }
    }
}

最终转成的json效果

 public string getCountryDepJson()
        {
            List<CR_BC_PROVINCE> list_Province = db.CR_BC_PROVINCE.ToList();            //省
            List<CR_BC_CITY> list_City = db.CR_BC_CITY.ToList();                        //市
            List<CR_BC_CITY_DISTRICT> list_District = db.CR_BC_CITY_DISTRICT.ToList();  //区
            List<CR_BC_STORE> list_Store = db.CR_BC_STORE.ToList();         //所有门店

            string result = new JObject(
                new JProperty("countryDeps",
                    new JArray(
                        from p in list_Province
                        select new JObject
                            (
                                new JProperty("allDepCount", (
                                    from s in list_Store
                                    join c in list_City on s.CR_BC_CITY_ID equals c.CR_BC_CITY_ID
                                    where c.CR_BC_PROVINCE_ID == p.CR_BC_PROVINCE_ID
                                    select 1
                                    ).Count()),
                                new JProperty("cityCount", (list_City.Where(x => x.CR_BC_PROVINCE_ID == p.CR_BC_PROVINCE_ID).Count())),
                                new JProperty("provinceid", p.CR_BC_PROVINCE_ID),
                                new JProperty("provincename", p.PROVINCE_NAME),
                                new JProperty("provincesimplename", p.PROVINCE_SIMPLE_NAME),
                                new JProperty("cityDeps", new JArray(
                                    from c in list_City
                                    where c.CR_BC_PROVINCE_ID == p.CR_BC_PROVINCE_ID
                                    select new JObject
                                        (
                                            new JProperty("allDistrictCount", 0),   //默认为0
                                            new JProperty("cityenname", c.EN_NAME),
                                            new JProperty("cityid", c.CR_BC_CITY_ID),
                                            new JProperty("cityname", c.CITY_NAME),
                                            new JProperty("depcount", (list_Store.Where(x => x.CR_BC_CITY_ID == c.CR_BC_CITY_ID).Count()))
                                        )
                                    )
                                )
                            )
                        )
                    )
                ,
                new JProperty("municipalityDeps",
                    new JArray(
                        from c in list_City
                        where c.MUNICIPALITY == true
                        select new JObject
                            (
                                new JProperty("allDistrictCount", (list_Store.Where(x => x.CR_BC_CITY_ID == c.CR_BC_CITY_ID).Count())),
                                new JProperty("cityenname", c.EN_NAME),
                                new JProperty("cityid", c.CR_BC_CITY_ID),
                                new JProperty("cityname", c.CITY_NAME),
                                new JProperty("depcount", (list_District.Where(x => x.CR_BC_CITY_ID == c.CR_BC_CITY_ID).Count())),
                                new JProperty("districtDeps", new JArray(
                                    from d in list_District
                                    where c.CR_BC_CITY_ID == d.CR_BC_CITY_ID
                                    select new JObject
                                        (
                                            new JProperty("districtDepcount", (list_Store.Where(x => x.CR_BC_CITY_DISTRICT_ID == d.CR_BC_CITY_DISTRICT_ID).Count())),
                                            new JProperty("districtid", d.CR_BC_CITY_DISTRICT_ID),
                                            new JProperty("districtname", d.CITY_DISTRICT_NAME)
                                        )
                                    )
                                )
                            )
                        )
                    )
                ).ToString();

            return result;
        }