using System.IO;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
#region MyRegion
/// <summary>
/// JSON To Datatable
/// </summary>
public static DataTable CsvToJson()
{
//读取json文件获取代码对应的数据
string jsonfile = "D:/data.json";
StreamReader file = File.OpenText(jsonfile);
JsonTextReader reader = new JsonTextReader(file);
var obj = JToken.ReadFrom(reader).ToList();
Dictionary<string, object> dic;
DataRow dr;
DataTable dt = getDataTable();
foreach (var _obj in obj)
{
dr = dt.NewRow();
dt.Rows.Add(dr);
JObject jo = (JObject)JsonConvert.DeserializeObject(_obj.ToString());
if (jo["CODE"] != null)
{
dr["CODE"] = jo["CODE"].ToString();
}
else
{
dr["CODE"] = "";
}
if (jo["WBS_CODE"] != null)
{
dr["WBS_CODE"] = jo["WBS_CODE"].ToString();
}
else
{
dr["WBS_CODE"] = "";
}
}
return dt;
}
public static DataTable getDataTable()
{
DataTable dt = new DataTable();
dt.Columns.Add("CODE", typeof(System.String));
dt.Columns.Add("WBS_CODE", typeof(System.String));
return dt;
}
#endregion
[
{" ":"1","ID":"247c602b-1037-405a-9585-8daf8ca5714f","WBS_CODE":"0117160093","NAME":"17#-093","CODE":"17#-093"}
,
{" ":"2","ID":"5efd44fc-5b07-41bd-b83e-81a786ea692d","WBS_CODE":"0113160091","NAME":"13#-091","CODE":"13#-091"}
]