service1.asmx.cs

来自「利用ajax和WebService实现的无刷新地域三级联动源码 使用微软」· CS 代码 · 共 114 行

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.Web;
using System.Web.Services;
using System.Data.SqlClient;
namespace WebApplication1
{
	//该源码下载自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)

	/// <summary>
	/// Summary description for Service1.
	/// </summary>
	public class Service1 : System.Web.Services.WebService
	{
		public static string ConnectionString=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
		SqlConnection conn=new SqlConnection(ConnectionString);

		public Service1()
		{
			//CODEGEN: This call is required by the ASP.NET Web Services Designer
			InitializeComponent();
		}

		#region Component Designer generated code
		
		//Required by the Web Services Designer 
		private IContainer components = null;
				
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{
		}

		/// <summary>
		/// Clean up any resources being used.
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if(disposing && components != null)
			{
				components.Dispose();
			}
			base.Dispose(disposing);		
		}
		
		#endregion
		
		#region getProvince
		[WebMethod(true)]
		public string getProvince()
		{
			string sql="select * from province";
			SqlCommand cmd=new SqlCommand(sql,conn); 

			cmd.Connection.Open();
			SqlDataReader dr=cmd.ExecuteReader();

			string s="";
			while(dr.Read())
			{
				s += "," + dr["provinceID"].ToString() + "|" + dr["province"].ToString();
			}
			return s;
		}

		#endregion

		#region getCity
		[WebMethod(true)]
		public string getCity(string provinceid)
		{
			string str="select * from city where father = '"+provinceid+"'";
			SqlCommand cmd=new SqlCommand(str,conn); 

			cmd.Connection.Open();
			SqlDataReader dr=cmd.ExecuteReader();

			string s="";
			while(dr.Read())
			{
				s += "," + dr["cityID"].ToString() + "|" + dr["city"].ToString();
			}
			return s;
		}

		#endregion

		#region getArea
		[WebMethod(true)]
		public string getArea(string cityid)
		{
			string str="select * from area where father='"+cityid+"'";
			SqlCommand cmd=new SqlCommand(str,conn); 

			cmd.Connection.Open();
			SqlDataReader dr=cmd.ExecuteReader();

			string s="";
			while(dr.Read())
			{
				s += "," + dr["areaID"].ToString() + "|" + dr["area"].ToString();
			}
			return s;
		}
		#endregion
	}
}