加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 百科 > 正文

自己写的输出xml和json的几个方法,和WebService,jquery ajax配

发布时间:2020-12-16 05:56:09 所属栏目:百科 来源:网络整理
导读:using System.Xml;using System.Data.SqlClient;using System.Collections;class pz_xmljson{ public XmlDocument xmlLoad(SqlDataReader sdr,string[] nodeName) { XmlDocument xmlDoc = new XmlDocument(); XmlDeclaration xmlDec = xmlDoc.CreateXmlDecla
using System.Xml;
using System.Data.SqlClient;
using System.Collections;

class pz_xmljson
{
    public XmlDocument xmlLoad(SqlDataReader sdr,string[] nodeName)
    {
        XmlDocument xmlDoc = new XmlDocument();
        XmlDeclaration xmlDec = xmlDoc.CreateXmlDeclaration("1.0","GB2312",null);
        xmlDoc.AppendChild(xmlDec);
        XmlNode xmlNode = xmlDoc.CreateElement("XmlOjects");
        xmlDoc.AppendChild(xmlNode);

        if (sdr.FieldCount == nodeName.Length)
        {
            while (sdr.Read())
            {
                XmlElement node = xmlDoc.CreateElement("XmlObject");
                xmlNode.AppendChild(node);

                for (int i = 0; i < nodeName.Length; i++)
                {
                    XmlElement element = xmlDoc.CreateElement(nodeName[i]);
                    element.InnerText = sdr[i].ToString();
                    node.AppendChild(element);? 
                    }
            }
            sdr.Close();
        }
        return xmlDoc;
    }

    public XmlDocument xmlLoad(SqlDataReader sdr)
    {
        XmlDocument xmlDoc = new XmlDocument();
        XmlDeclaration xmlDec = xmlDoc.CreateXmlDeclaration("1.0",null);
        xmlDoc.AppendChild(xmlDec);
        XmlNode xmlNode = xmlDoc.CreateElement("XmlOjects");
        xmlDoc.AppendChild(xmlNode);

        while (sdr.Read())
        {
            XmlElement node = xmlDoc.CreateElement("XmlObject");
            xmlNode.AppendChild(node);

            for (int i = 0; i < sdr.FieldCount; i++)
            {
                XmlElement element = xmlDoc.CreateElement(sdr.GetName(i));
                element.InnerText = sdr[i].ToString();
                node.AppendChild(element);? 
                    }
        }
        sdr.Close();
        return xmlDoc;
    }

    public XmlDocument xmlReturnValue(bool isSuccess)
    {
        XmlDocument xmlDoc = new XmlDocument();
        XmlDeclaration xmlDec = xmlDoc.CreateXmlDeclaration("1.0",null);
        xmlDoc.AppendChild(xmlDec);
        XmlNode xmlNode = xmlDoc.CreateElement("XmlOjects");
        xmlDoc.AppendChild(xmlNode);
        XmlElement node = xmlDoc.CreateElement("ReturnValue");
        if (isSuccess)
            node.InnerText = "true";
        else
            node.InnerText = "false";
        xmlNode.AppendChild(node);
        return xmlDoc;
    }

    public XmlDocument xmlReturnValue(bool isSuccess,string nodeName)
    {
        XmlDocument xmlDoc = new XmlDocument();
        XmlDeclaration xmlDec = xmlDoc.CreateXmlDeclaration("1.0",null);
        xmlDoc.AppendChild(xmlDec);
        XmlNode xmlNode = xmlDoc.CreateElement("XmlOjects");
        xmlDoc.AppendChild(xmlNode);
        XmlElement node = xmlDoc.CreateElement(nodeName);
        if (isSuccess)
            node.InnerText = "true";
        else
            node.InnerText = "false";
        xmlNode.AppendChild(node);
        return xmlDoc;
    }

    public string jsonLoad(SqlDataReader sdr,string[] nodeName)
    {
        string returnValue = string.Empty;
        if (sdr.FieldCount == nodeName.Length)
        {
            returnValue = "[";
            while (sdr.Read())
            {
                returnValue += "{";
                for (int i = 0; i < nodeName.Length; i++)
                {
                    returnValue += """ + nodeName[i] + "":";
                    returnValue += """ + sdr[i].ToString() + "",";
                }
                returnValue = returnValue.Substring(0,returnValue.Length - 1) + "},";
            }
            returnValue = returnValue.Substring(0,returnValue.Length - 1) + "]";
            sdr.Close();
        }
        return returnValue;
    }

    public string jsonLoad(SqlDataReader sdr)
    {
        string returnValue = string.Empty;
        returnValue = "[";
        while (sdr.Read())
        {
            returnValue += "{";
            for (int i = 0; i < sdr.FieldCount; i++)
            {
                returnValue += """ + sdr.GetName(i) + "":";
                returnValue += """ + sdr[i].ToString() + "",";
        }
        returnValue = returnValue.Substring(0,returnValue.Length - 1) + "]";
        sdr.Close();
        return returnValue;
    }

    public string jsonReturnValue(bool isSuccess)
    {
        string returnValue = string.Empty;
        returnValue = "[{"ReturnValue":";
        if (isSuccess)
            returnValue += ""true"";
        else
            returnValue += ""false"";
        returnValue += "}]";
        return returnValue;
    }

    public string jsonReturnValue(bool isSuccess,string nodeName)
    {
        string returnValue = string.Empty;
        returnValue = "[{"" + nodeName + "":";
        if (isSuccess)
            returnValue += ""true"";
        else
            returnValue += ""false"";
        returnValue += "}]";
        return returnValue;
    }

    public string toJson(string key,string value)
    {
        string returnValue = string.Empty;
        returnValue = "[{"" + key + "":";
        returnValue += """ + value + """;
        returnValue += "}]";
        return returnValue;
    }

    public XmlDocument toXml(string key,string value)
    {
        XmlDocument xmlDoc = new XmlDocument();
        XmlDeclaration xmlDec = xmlDoc.CreateXmlDeclaration("1.0",null);
        xmlDoc.AppendChild(xmlDec);
        XmlNode xmlNode = xmlDoc.CreateElement("XmlOjects");
        xmlDoc.AppendChild(xmlNode);
        XmlElement node = xmlDoc.CreateElement(key);
        node.InnerText = value;
        xmlNode.AppendChild(node);
        return xmlDoc;
    }
}


WebService直接这么输出

-----------------------------------------------------------------------

json: pz_xmljson xj = new pz_xmljson();

             Context.Response.Write(xj.toJson("value",tmp));  //xj.jsonLoad(SqlDataReader sdr)
            Context.Response.End();


jquery ajax这么拿值

-----------------------------------------------------------------------

 $.ajax({
                url: "WebService.asmx/******",type: "POST",data: {
                    receiverid: 。。。。,key: 。。。。

                },dataType: "json",success: function(result) {

                           result[0].value  。。。。。

                         }

 

      多个值的话用

      $.each(result,function(i,n) {

           n.Name。。。。

          n.ID。。。。。

         n.***。。。。。

}

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读