C# WebService 发送XML数据

1.编写SQL查询数据库

  sSql = "select * from 表名 where pushstate =0 and id='" + id + "' ";//条件
  DataTable dt = dal.Session.Query(sSql.ToString()).Tables[0];

2.拼接XML

  if (dt.Rows.Count > 0)
  {
    StringBuilder sendXml = new StringBuilder();
    
    //XML固定头部
    sendXml.Append("<soapenv:Envelope xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:jour=\"http://tbea/oracle/apps/ws/Journal.wsdl\" xmlns:typ=\"http://tbea/oracle/apps/ws/Journal.wsdl/types/\">");
    sendXml.AppendFormat("<soapenv:Header/>");
    sendXml.AppendFormat("<soapenv:Body>");
    sendXml.AppendFormat("<jour:glJournalMain>");
    //循环数据生成XML
    for (int i = 0; i < dt.Rows.Count; i++)
    {
        sendXmlM.AppendFormat("<typ:User>");
        sendXmlM.AppendFormat("<typ:head>{0}</typ:head>", dt.Rows[0]["header"].ToString());
        sendXmlM.AppendFormat("<typ:sourceTrx>{0}</typ:sourceTrx>", dt.Rows[0]["source"].ToString());
        sendXmlM.AppendFormat("</typ:User>");
    }
    sendXml.AppendFormat("</jour:glJournalMain>");
    sendXml.AppendFormat("</soapenv:Body>");
    sendXml.AppendFormat("</soapenv:Envelope>");
    //输出日志
    RecorderLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "发送XML：" + sendXml.ToString());
    string url = "发送地址";//url
    string reponseXml = Send_XML(url, sendXml.ToString());
    RecorderLog(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "返回XML：" + reponseXml);

 3.发送XML,Url获取返回信息

        //发送url
        public string Send_XML(string url, string sendXml)
        {
            string result = "";
            byte[] bytes = Encoding.UTF8.GetBytes(sendXml);

            HttpWebRequest httpWebRequest = (HttpWebRequest)WebRequest.Create(url);
            httpWebRequest.Method = "POST";
            httpWebRequest.ContentLength = (long)bytes.Length;
            httpWebRequest.ContentType = "text/xml;charset=UTF-8";
            httpWebRequest.Headers.Add("content", "text/xml;charset=utf8");

            try
            {
                Stream writer = httpWebRequest.GetRequestStream();
                writer.Write(bytes, 0, bytes.Length);
                //关闭请求流  
                writer.Close();
            }
            catch (Exception ex)
            {
                return ex.Message;
            }
            finally
            {
                //streamWriter.Close();
            }
            HttpWebResponse httpWebResponse = (HttpWebResponse)httpWebRequest.GetResponse();
            using (StreamReader streamReader = new StreamReader(httpWebResponse.GetResponseStream()))
            {
                result = streamReader.ReadToEnd();
                streamReader.Close();
            }
            return result;
        }