!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
html xmlns="http://www.w3.org/1999/xhtml">
head>
title>/title>
script src="Jquery1.7.js" type="text/javascript">/script>
script type="text/javascript">
$(function () {
$.ajax({
type: "post",
contentType: "application/json",
url: "WebService1.asmx/loadprovince",
data: "{}",
success: function (result) {
var ping;
for (var i = 0; i result.d.length; i++) {
ping += "option value=" + result.d[i].provinceID + ">";
ping += result.d[i].provincename;
ping += "/option>";
}
$('#Select1').append(ping);
}
})
$('#Select1').change(function () {
//第二次選時要記得清空市和縣中的內容
$('#Select2 option:gt(0)').remove();
$('#Select3 option:gt(0)').remove();
//在省的改變事件里綁定下一個下來列表（要失掉省的id）
$.ajax({
type: "post",
contentType: "application/json",
url: "WebService1.asmx/loadcity",
data: "{fatherid:'" + $('#Select1 option:selected').val() + "'}",
success: function (result) {
var str2;
for (var i = 0; i result.d.length; i++) {
str2 += "option value=" + result.d[i].cityID + ">";
str2 += result.d[i].cityname;
str2 += "/option>";
}
$('#Select2').append(str2);
}
})
})
$('#Select2').change(function () {
$('#Select3 option:gt(0)').remove();
$.ajax({
type: "post",
contentType: "application/json",
url: "WebService1.asmx/loadarea",
data: "{fatherid:'" + $('#Select2 option:selected').val() + "'}",
success: function (result) {
var str3;
for (var i = 0; i result.d.length; i++) {
str3 += "option value=" + result.d.areaID + ">";
str3 += result.d[i].areaname;
str3 += result.d[i].father;
}
$('#Select3').append(str3);
}
})
})
})
/script>
/head>
body>
省：
select id="Select1">
option>--請選擇--/option>
/select>
市：
select id="Select2">
option>--請選擇--/option>
/select>
縣：
select id="Select3">
option>--請選擇--/option>
/select>
/body>
/html>
[WebMethod]//加載省
public ListModel.province> loadprovince()//為什么要用list因為這里出從前的值不可能一個實例是多個model實例，一個實例就是一條記載這樣做防止字段錯誤
{
BLL.province bp = new BLL.province();
ListModel.province> list=bp.getlistModel();
return list;
}
[WebMethod]//加載市
public ListModel.city> loadcity(string fatherid)
{
BLL.city bc = new BLL.city();
ListModel.city> list = bc.getlistmodel(fatherid);
return list;
}
[WebMethod]//加載縣
public ListModel.area> loadarea(string fatherid)
{
BLL.area ba = new BLL.area();
ListModel.area> list = ba.getlistmodel(fatherid);
return list;
}
}
}
public System.Collections.Generic.ListModel.area> getlistmodel(string fatherid)
{
System.Collections.Generic.ListModel.area> list = new System.Collections.Generic.ListModel.area>();
DataTable dt = GetList("father=" + fatherid + "").Tables[0];
foreach (DataRow row in dt.Rows)
{
Model.area ma = new Model.area();
ma.areaID = row["areaID"].ToString();
ma.areaname = row["areaname"].ToString();
ma.father = row["father"].ToString();
list.Add(ma);
}
return list;
}
public System.Collections.Generic.ListModel.area> getlistmodel(string fatherid)
{
System.Collections.Generic.ListModel.area> list = new System.Collections.Generic.ListModel.area>();
DataTable dt = GetList("father=" + fatherid + "").Tables[0];
foreach (DataRow row in dt.Rows)
{
Model.area ma = new Model.area();
ma.areaID = row["areaID"].ToString();
ma.areaname = row["areaname"].ToString();
ma.father = row["father"].ToString();
list.Add(ma);
}
return list;
}
}
public System.Collections.Generic.ListModel.province> getlistModel()
{
//將要查的內容以實例的方式返回
//這里要做的就是要建立list并將list用model實例填滿，而model要用一個方法失掉數據并添加到model中
//建list實例
System.Collections.Generic.ListModel.province> list = new System.Collections.Generic.ListModel.province>();
//已經有了的失掉數據的方法就不用自己寫了通過調用Getlist的方法操縱數據庫拿到數據
DataTable dt = GetList("").Tables[0];
//拿到數據后就需要將數據添加到model實例中了
foreach (DataRow row in dt.Rows)
{
//每一行都是個實例所以要將model的放在循環里面
Model.province mp = new Model.province();
mp.provinceID = row["provinceID"].ToString();
mp.provincename = row["provincename"].ToString();
list.Add(mp);//沒添加完一個實例都要放到list中
}
return list;
}
