監(jiān)理公司管理系統(tǒng) | 工程企業(yè)管理系統(tǒng) | OA系統(tǒng) | ERP系統(tǒng) | 造價(jià)咨詢管理系統(tǒng) | 工程設(shè)計(jì)管理系統(tǒng) | 甲方項(xiàng)目管理系統(tǒng) | 簽約案例 | 客戶案例 | 在線試用
X 關(guān)閉

一個(gè)用webservice behavior實(shí)現(xiàn)的三級(jí)聯(lián)動(dòng)下拉列表框

申請免費(fèi)試用、咨詢電話：400-8352-114

AMTeam.org

一個(gè)用webservice behavior實(shí)現(xiàn)的三級(jí)聯(lián)動(dòng)下拉列表框


 
我做了一個(gè)三級(jí)聯(lián)動(dòng)的下拉列表框，后臺(tái)用webservice,前臺(tái)用webservice behavior與后臺(tái)通訊。請高手們多提改進(jìn)意見。

server端：（service1.asmx.cs)

using System;

using System.Text;

using System.Configuration;

using System.Collections;

using System.ComponentModel;

using System.Data;

using System.Data.SqlClient;

using System.Diagnostics;

using System.Web;

using System.Web.Services;

namespace WebService1

{

/// <summary>

/// Summary description for Service1.

/// </summary>

public class Service1 : System.Web.Services.WebService

{

SqlConnection con;

public Service1()
{


//CODEGEN: This call is required by the ASP.NET Web Services Designer

InitializeComponent();

}

#region Component Designer generated code

/// <summary>

/// Required method for Designer support - do not modify

/// the contents of this method with the code editor.

/// </summary>

private void InitializeComponent()

{

string dsn = ConfigurationSettings.AppSettings["yitong"];

con=new SqlConnection(dsn);

}

#endregion


/// <summary>

/// Clean up any resources being used.

/// </summary>

protected override void Dispose( bool disposing )

{

}

[WebMethod]

public string fenlei()

{

string str="select distinct substring(code,1,3) as fenlei from jinan ";

SqlCommand cmd=new SqlCommand(str,con);

cmd.Connection.Open();

SqlDataReader dr=cmd.ExecuteReader();

string s="請選擇：";

while(dr.Read())

{

s += ","+dr["fenlei"].ToString();

}

return s;

}

[WebMethod]

public string leixing(string q)

{

string str="select distinct type from jinan where code like '"+q+"%'";

SqlCommand cmd=new SqlCommand(str,con);

cmd.Connection.Open();

SqlDataReader dr=cmd.ExecuteReader();

string s="請選擇：";

while(dr.Read())

{

s += ","+dr["type"].ToString();

}

return s;

}

[WebMethod]

public string haoduan(string q)

{

string str="select distinct substring(code,4,4) as haoduan from jinan where type='"+q+"'";

SqlCommand cmd=new SqlCommand(str,con);

cmd.Connection.Open();

SqlDataReader dr=cmd.ExecuteReader();

string s="請選擇：";

while(dr.Read())

{

s += ","+dr["type"].ToString();

}

return s;

}

client端(htmlpage1.htm)

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >

<HTML>

<HEAD>

<META NAME="GENERATOR" Content="Microsoft Visual Studio 7.0">

<TITLE></TITLE>

<script id="clientEventHandlersJS" language="javascript">

<!--

var icallid;

var icallid1;

var icallid2;

function window_onload() {

service.useService("/service1.asmx?WSDL","myselect");

icallid=service.myselect.callService(fenlei,"fenlei");

}

function fenlei(result)

{

var m=result.value;

var a=m.split(",")

for(var i=0;i<a.length;i++)

{

window.s1.options=new Option(a,a);

}

}

function s1_onchange() {

var x=s1.value;

icallid1=service.myselect.callService(leixing,"leixing",x);
}

function s2_onchange() {

var x=s2.value;

icallid2=service.myselect.callService(haoduan,"haoduan",x);

}

function leixing(result){

var m=result.value;

var a=m.split(",")

window.s2.length=0;

for(var i=0;i<a.length;i++)

{

window.s2.options=new Option(a,a);

}

}

function haoduan(result){

var m=result.value;

var a=m.split(",")

window.s3.length=0;

for(var i=0;i<a.length;i++)

{

window.s3.options=new Option(a,a);

}

}

//-->

</script>

</HEAD>

<BODY onload="return window_onload()">

<div id="service" style="behavior:url(webservice.htc)">

</div>

<select id="s1" onchange="return s1_onchange()"> </select><select id="s2" onchange="return s2_onchange()"></select>

<select id="s3"></select>

</HTML>

發(fā)布：2007-03-24 18:00    編輯：泛普軟件 · xiaona    [打印此頁]    [關(guān)閉]
相關(guān)文章：
上海OA系統(tǒng)
聯(lián)系方式

成都公司：成都市成華區(qū)建設(shè)南路160號(hào)1層9號(hào)

重慶公司：重慶市江北區(qū)紅旗河溝華創(chuàng)商務(wù)大廈18樓

咨詢：400-8352-114

加微信，免費(fèi)獲取試用系統(tǒng)

QQ在線咨詢