话不多说,上代码
```csharp
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
namespace WebApplicationService
{
public class JsonHelper
{
public static string Boole(string Temprature)
{
try
{
JObject jsonObj = JObject.Parse(Temprature);
JArray brokenArray = null, dataArray = null;
if (jsonObj.ToString().Contains("brokenArray"))
{
brokenArray = JArray.Parse(jsonObj["brokenArray"].ToString());
dataArray = JArray.Parse(jsonObj["dataArray"].ToString());
}
else
{
dataArray = JArray.Parse(jsonObj["dataArray"].ToString());
}
if (brokenArray != null)
{
for (int i = 0; i < brokenArray.Count; i++)
{
DateTime flag=DateTime.Parse(brokenArray[i]["brokenTime"].ToString());
flag = DateTime.Parse(brokenArray[i]["connectTime"].ToString());
}
}
if (dataArray != null)
{
for (int i = 0; i < dataArray.Count; i++)
{
DateTime flag = DateTime.Parse(dataArray[i]["timeString"].ToString());
int flag1 = int.Parse(dataArray[i]["temperature"].ToString());
int flag2 = int.Parse(dataArray[i]["resistance"].ToString());
int flag3 = int.Parse(dataArray[i]["dropString"].ToString());
}
}
return "正常";
}
catch (Exception e)
{
WebOxygenService.LogHelper.WriteLog("JsonHelper错误提示:", "JsonHelper.Boole方法出错:" + e.ToString());
throw;
}
}
}
}
楼主测试的json格式的数据是这样的:
{ "brokenArray": [{
"brokenTime": "2019-10-09 20:09:14",
"connectTime": "2017-10-09 20:09:14"
}, {
"brokenTime": "2019-10-09 20:09:14",
"connectTime": "2018-10-09 20:09:14"
}],
"dataArray": [{
"temperature": 20,
"resistance": 100,
"dropString": "0",
"timeString": "2019-10-09 20:09:12" }, {
"timeString": "2019-10-09 20:09:14",
"temperature": 30,
"dropString": "0",
"resistance": 200
}]}
建立完这个类之后我是这样使用的
if (JsonHelper.Boole(Temprature) != "正常")
return null;
核心逻辑是判断传进来的json格式的数据是否存在键brokenArray,没有的话就判断dataArray,再判断其中的字段类型是否是符合预期的,
比如时间格式的是否是时间,数字型且没有小数的是否是int型
开发出这个帮助类的目的是因为手机端开发担心可能会存在乱码,不希望数据库中进入乱码,导致手机端闪退什么的,并且维持数据库结构一致