boris_WebService

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Xml;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Configuration;

namespace WebService2
{
    /// <summary>
    /// boris_WebService 的摘要说明
    /// </summary>
    [WebService(Namespace = "http://tempuri.org/")]
    [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
    [System.ComponentModel.ToolboxItem(false)]
    // 若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务，请取消对下行的注释。
    // [System.Web.Script.Services.ScriptService]
    public class boris_WebService : System.Web.Services.WebService
    {
        [WebMethod(Description = "一张表输出学生信息XML格式(XmlDataDocument)")]

        public XmlDataDocument xdd_GetInfo()
        {
            string ConnStr = System.Configuration.ConfigurationManager.AppSettings["testconnStr"];
            SqlConnection MyConn = new SqlConnection(ConnStr);


            string SelectStr = "select Sname, Sage, Ssex from dbo.Student";


            DataSet ds_GetInfo = new DataSet();
            SqlDataAdapter sda_GetInfo = new SqlDataAdapter(SelectStr, ConnStr);
            sda_GetInfo.Fill(ds_GetInfo);
            XmlDataDocument xdd = new XmlDataDocument(ds_GetInfo);

            return xdd;
        }

        [WebMethod(Description = "一张表输出学生信息XML格式（xmldocument）")]
        public XmlDocument xd_Info()
        {
            string MyConnStr = System.Configuration.ConfigurationManager.AppSettings["testconnStr"];
            SqlConnection MyConn = new SqlConnection(MyConnStr);
            string MySelectStr = "select Sname, Sage, Ssex from dbo.Student";
            DataSet ds = new DataSet();
            SqlDataAdapter sda = new SqlDataAdapter(MySelectStr, MyConn);
            sda.Fill(ds);
            Stream s = new MemoryStream();
            ds.WriteXml(s);
            s.Seek(0, SeekOrigin.Begin);
            //转换成XmlDocument对象
            XmlDocument xd = new XmlDocument();
            xd.Load(s);
            return xd;
        }

        [WebMethod(Description = "两张表输出学生成绩XML格式（Auto模式）")]

        public XmlDataDocument xdd_Score()
        {
            string ConnStr = System.Configuration.ConfigurationManager.AppSettings["testconnStr"];
            SqlConnection MyConn = new SqlConnection(ConnStr);


            string SelectStr = "select s.*,m.Course,m.score from dbo.Student s ,Mid_score m where s.sname=m.name for xml auto";


            DataSet ds_GetInfo = new DataSet();
            SqlDataAdapter sda_GetInfo = new SqlDataAdapter(SelectStr, ConnStr);
            sda_GetInfo.Fill(ds_GetInfo);
            XmlDataDocument xdd = new XmlDataDocument(ds_GetInfo);

            return xdd;
        }
        [WebMethod(Description = "两张表输出学生成绩XML格式（Path模式）")]

        public XmlDataDocument xdd_SScore()
        {
            string ConnStr = System.Configuration.ConfigurationManager.AppSettings["testconnStr"];
            SqlConnection MyConn = new SqlConnection(ConnStr);


            string SelectStr = "select distinct 1 as tag, null as parent,Sname[Student!1!Sname], Sage[Student!1!Sage], Ssex[Student!1!Ssex],null as[Mid_score!2!Course!xml],null as[Mid_score!2!Score!xml] from  Student union all select  2 as tag, 1 as parent,Sname,Sage,Ssex,m.Course,m.Score  from dbo.Student s,Mid_score m where s.Sname =m.Name ORDER BY [Student!1!Sname],[Mid_score!2!Course!xml] FOR XML EXPLICIT";


            DataSet ds_GetInfo = new DataSet();
            SqlDataAdapter sda_GetInfo = new SqlDataAdapter(SelectStr, ConnStr);
            sda_GetInfo.Fill(ds_GetInfo);
            XmlDataDocument xdd = new XmlDataDocument(ds_GetInfo);

            return xdd;
        }

        [WebMethod(Description = "三张表输出学生成绩XML格式（Explicit模式）")]
        
        public XmlDataDocument xdd_GetScore()
        {
            string ConnStr = System.Configuration.ConfigurationManager.AppSettings["testconnStr"];
            SqlConnection MyConn = new SqlConnection(ConnStr);


            string SelectStr = "  select distinct 1 as tag, null as parent,Sname[Student!1!Sname], Sage[Student!1!Sage], Ssex[Student!1!Ssex],null as[Mid_score!2!Course!xml],null as[Mid_score!2!Score!xml], null as[High_score!3!Course!xml],null as [High_score!3!Score!xml]from dbo.Student union all select 2 as tag, 1 as arent,Sname,Sage,Ssex,m.Course,m.Score,null,null from dbo.Student s,Mid_score m where s.Sname =m.Name union all select  3 as tag, 1 as parent,Sname,Sage,Ssex,null,null,h.Course,h.Score from dbo.Student s,dbo.High_score h where s.Sname =h.Name order by [Student!1!Sname],tag FOR XML explicit";


            DataSet ds_GetInfo = new DataSet();
            SqlDataAdapter sda_GetInfo = new SqlDataAdapter(SelectStr, ConnStr);
            sda_GetInfo.Fill(ds_GetInfo);
            XmlDataDocument xdd = new XmlDataDocument(ds_GetInfo);

            return xdd;
        }

          [WebMethod(Description = "一张表输出学生信息XML格式（string）")]
        public string str_Info()
        {
            string MyConnStr = System.Configuration.ConfigurationManager.AppSettings["testconnStr"];
            SqlConnection MyConn = new SqlConnection(MyConnStr);
            string MySelectStr = "select Sname, Ssex, Sage from dbo.Student";
            DataSet ds = new DataSet();
            SqlDataAdapter sda = new SqlDataAdapter(MySelectStr, MyConn);
            sda.Fill(ds);
            Stream s = new MemoryStream();
            ds.WriteXml(s);
            s.Seek(0, SeekOrigin.Begin);
            //转换为字符串
            StreamReader r = new StreamReader(s);
            string xml = r.ReadToEnd();
            return xml;
        }
    }
}