C# 读取json 文件 解析处理并另存

1、代码

// See https://aka.ms/new-console-template for more information
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using System;

namespace Application
{
    class Program
    {
        static void Main(string[] args)
        {
            string jsonPath = "E:/Code/tool/monitor.json";
            string jsonStr = GetJsonStr(jsonPath);
            var monitor = GetJson(jsonStr);

            string jsonPathWS = "E:/Code/tool/ws.json";
            var wsStr = GetJsonStr(jsonPathWS, false);
            var ws = GetJson(wsStr);

            var points = GetListPoint(ws);
            var jArray = (JArray)monitor;
            SetJsonValue(jArray, points);
            Console.WriteLine("Hello World!");
        }

        /***
         * 反序列化成json 对象
         */
        public static object GetJson(string jsonStr)
        {
            return JsonConvert.DeserializeObject(jsonStr);
        }

        /**
         * 获取点坐标
         */
        public static List GetListPoint(object o)
        {
            List points = new List();
            JObject jObj = (JObject)o;
            var fetures = jObj["features"];
            foreach (var item in fetures)
            {
                var p = new Point();
                p.X = double.Parse(item["geometry"]["x"].ToString());
                p.Y = double.Parse(item["geometry"]["y"].ToString());
                p.EXPNO =item["attributes"]["EXPNO"].ToString();
                points.Add(p);

            }
            return points;
        }

        /**
         * 设置json 并保存成新的json 文件
         */
        public static string SetJsonValue(JArray jArray, List points)
        {
            Random random = new Random();
            List<int> listIndex = new List<int>();
            List list = new List();
            foreach (var item in jArray)
            {
                var tmp = item;
                if (tmp["name"]?.ToString() == "窨井水位")
                {
               
                    foreach (var item2 in tmp["list"])
                    {
                        var index = random.Next(points.Count);

                        while (listIndex.Contains(index))
                        {
                            index = random.Next(points.Count);
                        }
                        item2["BMX"] = points[index].X;
                        item2["BMY"] = points[index].Y;
                        item2["EXPNO"]=points[index].EXPNO;
                    }
                }
                else if (tmp["name"]?.ToString() == "流量")
                {
                 
                    foreach (var item2 in tmp["list"])
                    {
                        var index = random.Next(points.Count);

                        while (listIndex.Contains(index))
                        {
                            index = random.Next(points.Count);
                        }
                        item2["BMX"] = points[index].X;
                        item2["BMY"] = points[index].Y;
                    }
                }
                list.Add(tmp);
            }
            SaveJsonFile(JsonConvert.SerializeObject(list));
            return "";
        }

        /**
         * 保存新的文件
         */
        public static void SaveJsonFile(JToken jToken)
        {
            string jsonPath = "E:/Code/tool/monitor" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".json";
            File.WriteAllText(jsonPath, jToken.ToString());
        }

        /**
         * 读取json 文件
         */
        public static string GetJsonStr(string jsonPath, bool isCheck = true)
        {
            string line;
            string res = "";
            using (StreamReader sr = new StreamReader(jsonPath))
            {
                if (isCheck)
                {
                    while ((line = sr.ReadLine()) != null)
                    {
                        //这一行值有问题 存在得时候转换json 失败
                        if (line.ToString().IndexOf("ADDTIME") <= 0)
                            res = res + line.ToString().Trim();
                    }
                }
                else
                {
                    res = sr.ReadToEnd();
                }

            }
            return res;

        }

        public class Point
        {
            public double X { get; set; }
            public double Y { get; set; }

            public string EXPNO { get; set; }
        }
    }
}
						  
					  
						
							


						

							
							
			C							
						



						

						
						


						

						
					
					

					
					

						
相关

						

				
						
			

																
								

										
C# 十六进制八进制前缀或后缀

									
									

								 

        

								

							
							

																
								

										
C#中的Attribute（特性）的使用

									
									

								 

        

								

							
							

																
								

										
c#小灶——9.算术运算符

									
									

								 

        

								

							
							

																
								

										
c#小灶——4.注释和代码规范

									
									

								 

        

								

							
							

																
								

										
c#小灶——3.输出语句

									
									

								 

        

								

							
							

																
								

										
【Luogu3414】SAC#1 - 组合数

									
									

								 

        

								

							
							

																
								

										
[C#] 使用递归将多条路径生成树

									
									

								 

        

								

							
							

																
								

										
C#封装定时执行任务类

									
									

								 

        

								

							
							

																
								

										
【C#进阶系列】30 学习总结

									
									

								 

        

								

							
							

																
								

										
【C#进阶系列】10 属性

									
									

								 

        

								

							
							

																
								

										
【C#进阶系列】18 特性Attribute

									
									

								 

        

								

							
							

																
								

										
C# string 加号与StringBuilder .netCore3.1与 .netCore5.0速度测试

									
									

								 

        

								

							
							
            
            
            
                                    
           
  			
						

					

					
				

				

														
					
					

					
									

					
									   
标签

										

										
    
										

									

										
										

									

					

					
				


			
		
		
		
			


						





	

	
一品网 冀ICP备14022925号-6