XmlAndJson.cs 2.2 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667
  1. using Newtonsoft.Json;
  2. using System;
  3. using System.Collections.Generic;
  4. using System.Data;
  5. using System.Text;
  6. using System.Xml;
  7. namespace TEAMModelOS.SDK.Helper.Common.XmlHelper
  8. {
  9. public class XmlAndJson
  10. { /// <summary>
  11. /// 返回指定节点下信息的JSON格式字符串
  12. /// </summary>
  13. /// <param name="str">xml字符串</param>
  14. /// <param name="nodename">节点名称,应从根节点开始</param>
  15. /// <returns></returns>
  16. public static string XML2Json(string str, string nodename)
  17. {
  18. string result = null;
  19. XmlDocument xmldoc = new XmlDocument();
  20. xmldoc.LoadXml(str);
  21. XmlNode node = xmldoc.SelectSingleNode(nodename);
  22. result = Newtonsoft.Json.JsonConvert.SerializeXmlNode(node);
  23. return result;
  24. }
  25. public static string Json2XML(string str)
  26. {
  27. string result = null;
  28. XmlDocument xml = Newtonsoft.Json.JsonConvert.DeserializeXmlNode(str);
  29. result = xml.OuterXml;
  30. return result;
  31. }
  32. public static string GetCustomItemSpecifics(string str)
  33. {
  34. DataTable dt = JsonConvert.DeserializeObject<DataTable>(str);
  35. List<Json2Xml.NameValueListType> nvl = new List<Json2Xml.NameValueListType>();
  36. foreach (DataRow dr in dt.Rows)
  37. {
  38. Json2Xml.NameValueListType nv = new Json2Xml.NameValueListType();
  39. string sName = dr["Name"].ToString();
  40. string sValue = dr["Value"].ToString();
  41. if (sName != string.Empty && sValue != string.Empty)
  42. {
  43. nv.Name = sName;
  44. nv.Value = new string[] { sValue };
  45. nvl.Add(nv);
  46. }
  47. }
  48. if (nvl.Count == 0)
  49. {
  50. return string.Empty;
  51. }
  52. else
  53. {
  54. Json2Xml.CustomItemSpecifics t = new Json2Xml.CustomItemSpecifics();
  55. t.ItemSpecifics = nvl.ToArray();
  56. return Json2Xml.ObjectToText(t, typeof(Json2Xml.CustomItemSpecifics));
  57. }
  58. }
  59. }
  60. }