XmlAndJson.cs 2.1 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465
  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. XmlDocument xmldoc = new XmlDocument();
  19. xmldoc.LoadXml(str);
  20. XmlNode node = xmldoc.SelectSingleNode(nodename);
  21. string result = System.Text.Json.JsonSerializer.Serialize(node);
  22. return result;
  23. }
  24. public static string Json2XML(string str)
  25. {
  26. XmlDocument xml = System.Text.Json.JsonSerializer.Deserialize<XmlDocument>(str);
  27. string result = xml.OuterXml;
  28. return result;
  29. }
  30. public static string GetCustomItemSpecifics(string str)
  31. {
  32. DataTable dt = JsonConvert.DeserializeObject<DataTable>(str);
  33. List<Json2Xml.NameValueListType> nvl = new List<Json2Xml.NameValueListType>();
  34. foreach (DataRow dr in dt.Rows)
  35. {
  36. Json2Xml.NameValueListType nv = new Json2Xml.NameValueListType();
  37. string sName = dr["Name"].ToString();
  38. string sValue = dr["Value"].ToString();
  39. if (sName != string.Empty && sValue != string.Empty)
  40. {
  41. nv.Name = sName;
  42. nv.Value = new string[] { sValue };
  43. nvl.Add(nv);
  44. }
  45. }
  46. if (nvl.Count == 0)
  47. {
  48. return string.Empty;
  49. }
  50. else
  51. {
  52. Json2Xml.CustomItemSpecifics t = new Json2Xml.CustomItemSpecifics();
  53. t.ItemSpecifics = nvl.ToArray();
  54. return Json2Xml.ObjectToText(t, typeof(Json2Xml.CustomItemSpecifics));
  55. }
  56. }
  57. }
  58. }