现在的位置: 首页 > 综合 > 正文

Json 与IList 、DataSet 以及实例类对象之间的互转

2013年01月01日 ⁄ 综合 ⁄ 共 2897字 ⁄ 字号 评论关闭

  将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/ 

 

抱歉!评论已关闭.