一丶webservice执行存储过程

返回值组合：

json返回

 StringBuilder sb = new StringBuilder();

 sb.Append("{");

 sb.Append("\"Status\":\"" + 123 + "\"");

 sb.Append("}");

json数组

StringBuilder sb = new StringBuilder();

sb.Append("[");

for (int i = ; i < ; i++)

{

     sb.Append("{");

     sb.Append("\"name\":\"" + i + "\",");

     sb.Append("\"name1\":\"" + (i+) + "\"");

     sb.Append("},");

}

sb.Remove(sb.ToString().LastIndexOf(','), );

sb.Append("]");

案例1：

 public void GetClass(string name, string id)

         {

             try

             {

                 string connectString = System.Configuration.ConfigurationSettings.AppSettings["connStr"];

                 SqlConnection conn = new SqlConnection(connectString);

                 conn.Open();

                 SqlCommand comm = new SqlCommand();

                 comm.Connection = conn;

                 comm.CommandText = "PROC_ChoicePersonnel";

                 comm.CommandType = System.Data.CommandType.StoredProcedure;

                 //传值以及赋值

                 SqlParameter[] sps = new SqlParameter[] {

                     new SqlParameter("@ClassName",name),

                     new SqlParameter("@id",id),

                     new SqlParameter("@flag","class")

                   };

                 comm.Parameters.AddRange(sps);

                 SqlDataAdapter sdap = new SqlDataAdapter();

                 sdap.SelectCommand = comm;

                 DataTable dt = new DataTable();

                 sdap.Fill(dt);

                 conn.Close();

                 StringBuilder sb = new StringBuilder();

                 sb.Append("[");

                 for (int i = ; i < dt.Rows.Count; i++)

                 {

                     sb.Append("{");

                     sb.Append("\"id\":\"" + dt.Rows[i]["id"].ToString() + "\",");

                     sb.Append("\"name\":\"" + dt.Rows[i]["name"].ToString() + "\"");

                     sb.Append("},");

                 }

                 sb.Remove(sb.ToString().LastIndexOf(','), );

                 sb.Append("]");

                 Result(sb);

             }

             catch (Exception ex)

             {

             }

         }    

       private void Result(StringBuilder sb)

         {

             Context.Response.Charset = "UTF-8"; //设置字符集类型

             Context.Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8");

             Context.Response.ContentType = "text/plain";

             Context.Response.Write(sb.ToString());

             Context.Response.End();

         }

C#后台调用HTTP外网接口

1.get方法调用接口获取json文件内容

 public void GetFunction()

         {

             string serviceAddress = "http://...?aaa=111";

             HttpWebRequest request = (HttpWebRequest)WebRequest.Create(serviceAddress);

             request.Method = "GET";

             request.ContentType = "text/html;charset=UTF-8";

             HttpWebResponse response = (HttpWebResponse)request.GetResponse();

             Stream myResponseStream = response.GetResponseStream();

             StreamReader myStreamReader = new StreamReader(myResponseStream, Encoding.UTF8);

             string retString = myStreamReader.ReadToEnd();

             myStreamReader.Close();

             myResponseStream.Close();

             Response.Write(retString);

         }

2.post方法调用接口获取json文件内容

 public void PostFunction()

         {

             string serviceAddress = "http://...";

             HttpWebRequest request = (HttpWebRequest)WebRequest.Create(serviceAddress);

             request.Method = "POST";

             request.ContentType = "application/json";

             string strContent = @"{ ""a"": ""1"",""b"": ""2"",""c"": ""3""}";

             using (StreamWriter dataStream = new StreamWriter(request.GetRequestStream()))

             {

                 dataStream.Write(strContent);

                 dataStream.Close();

             }

             HttpWebResponse response = (HttpWebResponse)request.GetResponse();

             string encoding = response.ContentEncoding;

             if (encoding == null || encoding.Length < )

             {

                 encoding = "UTF-8"; //默认编码

             }

             StreamReader reader = new StreamReader(response.GetResponseStream(), Encoding.GetEncoding(encoding));

             string retString = reader.ReadToEnd();

             //解析josn

             JObject jo = JObject.Parse(retString);

             Response.Write(jo["message"]["mmmm"].ToString());

         }

        [WebMethod]

         public void tt()

         {

             //地址

             string url = "http://...";

             string a = "";

             string b = "";

             string c = "";

             string d = "";

             //传的参数

             //string datastr1 = "id=" + System.Web.HttpUtility.UrlEncode(ids);

             string datastr1 = "a=" + a + "&b=" + b + "&c=" + c + "&d=" + d+ "&e=";

             //转成字节

             byte[] bytearray1 = Encoding.UTF8.GetBytes(datastr1);

             //创建WebRequest

             HttpWebRequest webrequest = (HttpWebRequest)WebRequest.Create(url);

             //POST方式

             webrequest.Method = "POST";

             // <form encType=””>中默认的encType，form表单数据被编码为key/value格式发送到服务器（表单默认的提交数据的格式）

             webrequest.ContentType = "application/x-www-form-urlencoded";

             //获取字节数

             webrequest.ContentLength = Encoding.UTF8.GetByteCount(datastr1);

             //获取用于写入请求数据的 System.IO.Stream 对象

             Stream webstream = webrequest.GetRequestStream();

             //向当前流中写入字节序列，并将此流中的当前位置提升写入的字节数。

             webstream.Write(bytearray1, , bytearray1.Length);

             //获取返回数据

             HttpWebResponse response = (HttpWebResponse)webrequest.GetResponse();

             //转码

             StreamReader sr = new StreamReader(response.GetResponseStream(), Encoding.UTF8);

             //返回的结果

             string ret = sr.ReadToEnd();

         }

巴特西

一丶webservice执行存储过程

1.get方法调用接口获取json文件内容

最新文章

热门文章