1.下载数据表后导入到数据库中
链接:https://pan.baidu.com/s/1aLCHco45Ky6BS_aSdZQFiw
提取码:qqdn
2.修改字段类型为
3.编写处理程序-可根据需要修改sql语句和level判断获取指定区域的任意层级json数据
class Program
{
static void Main(string[] args)
{
string sql = "SELECT * FROM area_code_2019 WHERE pcode='0'";
LocalTree lt = new LocalTree();
lt.value = "全国";
lt.label = "";
lt.children = new List<LocalTree>();
LocalTree dt = ExceuteQuery(sql, lt);
string res = JsonConvert.SerializeObject(dt);
FileStream myFs = new FileStream(@"D:\LocalJson.txt", FileMode.OpenOrCreate);
StreamWriter mySw = new StreamWriter(myFs, Encoding.Default);
mySw.WriteLine(res);
mySw.Close();
myFs.Close();
}
/// <summary>
/// 递归赋值实体类
/// </summary>
/// <param name="sql"></param>
/// <param name="lt"></param>
/// <returns></returns>
public static LocalTree ExceuteQuery(string sql, LocalTree lt)
{
string