webservice.cs

这一个能预报天气的软件

using System;
using System.Web;
using System.Collections;
using System.Web.Services;
using System.Web.Services.Protocols;
using AjaxControlToolkit;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Collections.Specialized;
/// <summary>
/// WebService 的摘要说明
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.Web.Script.Services.ScriptService]
public class WebService : System.Web.Services.WebService
{

    public WebService()
    {

        //如果使用设计的组件，请取消注释以下行 
        //InitializeComponent(); 
    }

    [WebMethod]
    public CascadingDropDownNameValue[] GetCapital(string knownCategoryValues, string category)
    {
        List<CascadingDropDownNameValue> provinceList = new List<CascadingDropDownNameValue>();

        string connectionString = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];

        SqlConnection sqlConn = new SqlConnection(connectionString);

        sqlConn.Open();

        string strSql = "Select * From Capital order by CapitalID";

        SqlCommand sqlCmd = new SqlCommand(strSql, sqlConn);

        SqlDataReader dtrProvince = sqlCmd.ExecuteReader();

        while (dtrProvince.Read())
        {
            provinceList.Add(new CascadingDropDownNameValue(dtrProvince["CapitalName"].ToString(), dtrProvince["CapitalCode"].ToString()));
        }

        dtrProvince.Close();

        sqlConn.Close();

        return provinceList.ToArray();
    }
    [WebMethod]
    public CascadingDropDownNameValue[] GetCity(string knownCategoryValues, string category)
    {
        StringDictionary provinceList = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);

        string connectionString = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];

        SqlConnection sqlConn = new SqlConnection(connectionString);

        sqlConn.Open();

        string strSql = "Select * From City Where DomainID='" + provinceList["Capital"] + "'";

        SqlCommand sqlCmd = new SqlCommand(strSql, sqlConn);

        SqlDataReader dtrCity = sqlCmd.ExecuteReader();

        List<CascadingDropDownNameValue> cityList = new List<CascadingDropDownNameValue>();

        while (dtrCity.Read())
        {
            cityList.Add(new CascadingDropDownNameValue(dtrCity["CityName"].ToString(), dtrCity["CityCode"].ToString()));
        }

        dtrCity.Close();

        return cityList.ToArray();
    }
}