将DataSet 对象转换为Json 对象
public static string JsonConvert(DataSet ds)
{
StringBuilder sb = new StringBuilder();
sb.Append("[");
for (int i=0;i<ds.Tables[0].Rows.Count;i++)
{
sb.Append("{");
for (int j = 0; j < ds.Tables[0].Columns.Count; j++)
{
sb.Append("");
sb.Append(ds.Tables[0].Columns[j].ColumnName);
sb.Append(":\"");
sb.Append(ds.Tables[0].Rows[i][j].ToString().Trim());
sb.Append("\",");
}
sb.Remove(sb.Length-1,1);
sb.Append("},");
}
sb.Remove(sb.Length-1,1);
sb.Append("]");
return sb.ToString();
}
Ilist 转为json 数据格式
/// <summary>
/// 将Ilist转成json格式
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public static string JsonConvert(IList<TransBody> list)
{
try
{
System.Runtime.Serialization.Json.DataContractJsonSerializer seializer = new System.Runtime.Serialization.Json.DataContractJsonSerializer(list.GetType());
using (MemoryStream ms = new MemoryStream())
{
seializer.WriteObject(ms, list);
return Encoding.UTF8.GetString(ms.ToArray());
}
}
catch
{
return null;
}
}
通用类型转换为Json 数据格式
public static object ConvertJson(string json ,Type t)
{
try
{
System.Runtime.Serialization.Json.DataContractJsonSerializer serializer = new System.Runtime.Serialization.Json.DataContractJsonSerializer(t);
using (MemoryStream ms = new MemoryStream(Encoding.UTF8.GetBytes(json)))
{
return serializer.ReadObject(ms);
}
}
catch
{
return null;
}
}
实体类转换为json 数据格式
public static string ComPriceJsonConvert(CompanyPrice ComP《实体类对象》)
{
StringBuilder sb = new StringBuilder();
if (ComP.MD001 == null || ComP.MD001 == "")
{
sb.Append("{}");
}
else
{
sb.Append("{");
sb.Append("MD000:\"" + ComP.MD000.ToString() + "\",");
sb.Append("MD001:\"" + ComP.MD001.ToString() + "\",");
sb.Append("MD002:\"" + ComP.MD002.ToString() + "\",");
sb.Append("MD004:\"" + ComP.MD004.ToString() + "\",");
sb.Append("MD009:\"" + ComP.MD009.ToString() + "\",");
sb.Append("MD010:\"" + ComP.MD010.ToString() + "\",");
sb.Append("MD011:\"" + ComP.MD011.ToString() + "\"");
sb.Append("}");
}
return sb.ToString();
}
扩展阅读:
Json 官网:http://www.json.org/