server1.asm代码清单如下:
using System;
using System.Data;
using System.Data.SqlClient;
using System.Web;
using System.Collections;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.ComponentModel;
using System.Configuration;
namespace SecurityWebService
{
/// <summary>
/// Service1 的摘要说明
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[ToolboxItem(false)]
public class Service1 : System.Web.Services.WebService
{
[WebMethod]
public int Add(int a,int b)
{
return a + b;
}
[WebMethod]
public string Fdk()
{
return "asd";
}
[WebMethod]
public string HelloWorld()
{
return "Hello World";
}
[WebMethod]
public DataSet GetInfo()
{
return Getds("Select * From MtmCompanyIntro");
}
public DataSet Getds(string sSQL)
{
string sConnection = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;
SqlConnection conn;
conn = new SqlConnection(sConnection);
conn.Open();
SqlCommand myCMD = new SqlCommand(sSQL, conn);
SqlDataAdapter myda = new SqlDataAdapter();
myda.SelectCommand = myCMD;
DataSet myDs = new DataSet();
myda.Fill(myDs, "mds");
conn.Close();
return myDs;
}
}
}