DIV CSS 佈局教程網

您现在的位置: DIV+CSS佈局教程網 >> 網頁腳本 >  >> JavaScript入門知識 >> AJAX入門 >> AJAX詳解
用 jQuery + JSON 實作無刷新三級聯動
編輯:AJAX詳解     

本文示範如何以 jQuery 搭配 ashx 回傳的 JSON 資料,實作一個完全無刷新、三層下拉式選單彼此聯動的效果。

頁面控制項

<asp:DropDownList ID="ddl1" runat="server" Width="100px"></asp:DropDownList>
<asp:DropDownList ID="ddl2" runat="server" Width="100px"></asp:DropDownList>
<asp:DropDownList ID="ddl3" runat="server" Width="100px"></asp:DropDownList>

前端 JavaScript

用 getJSON 抓取 ashx 回傳的資料,並依選取值逐層載入下游選單:

<script src="js/jquery-1.4.2.min.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function () {
    GetA();
    $("#ddl1").change(function () { GetB(); });
    $("#ddl2").change(function () { GetC(); });
});

function GetA() {
    $("#ddl1").html("");
    $("#ddl1").append("<option value='-1' selected='selected'>請選擇...</option>");
    var strId = 0;
    $.getJSON("LoadClass.ashx?ddlId=" + strId, function (data) {
        for (var i = 0; i < data.length; i++) {
            $("select[name$=ddl1]").append($("<option></option>").val(data[i].ID).html(data[i].Cname));
        }
        GetB();
    });
}

function GetB() {
    $("#ddl2").html("");
    $("#ddl3").html("");
    var strId = $("#ddl1").attr("value");
    if (strId != 0) {
        $.getJSON("LoadClass.ashx?ddlId=" + strId, function (data) {
            for (var i = 0; i < data.length; i++) {
                $("select[name$=ddl2]").append($("<option></option>").val(data[i].ID).html(data[i].Cname));
            }
            GetC();
        });
    }
}

function GetC() {
    $("#ddl3").html("");
    var strId = $("#ddl2").attr("value");
    if (strId != 0) {
        $.getJSON("LoadClass.ashx?ddlId=" + strId, function (data) {
            for (var i = 0; i < data.length; i++) {
                $("select[name$=ddl3]").append($("<option></option>").val(data[i].ID).html(data[i].Cname));
            }
        });
    }
}
</script>

LoadClass.ashx

ashx 依傳入的 ddlId 查詢子層資料,並以 JSON 格式回傳:

<%@ WebHandler Language="C#" Class="LoadClass" %>
using System;
using System.Web;
using System.Text;
using System.Data;

public class LoadClass : IHttpHandler
{
    public void ProcessRequest(HttpContext context)
    {
        // 回傳範例:[{"ID":"275","Cname":"A1"},{"ID":"319","Cname":"A2"},{"ID":"322","Cname":"A3"}]
        int strId = Convert.ToInt32(context.Request["ddlId"]);
        string strSQL = "select * from Class where parent_Ptr=" + strId + " order by classOrder asc ";
        db d = new db();
        DataTable dt = d.getDT(strSQL);

        StringBuilder strClass = new StringBuilder();
        if (dt != null)
        {
            strClass.Append("[");
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                strClass.Append("{");
                strClass.Append("\"ID\":\"" + dt.Rows[i]["id"].ToString() + "\",");
                strClass.Append("\"Cname\":\"" + dt.Rows[i]["classCname"].ToString() + "\"");
                if (i != dt.Rows.Count - 1) strClass.Append("},");
            }
        }
        strClass.Append("}");
        strClass.Append("]");

        context.Response.ContentType = "application/json";
        context.Response.ContentEncoding = Encoding.UTF8;
        context.Response.Write(strClass.ToString());
        context.Response.End();
    }

    public bool IsReusable { get { return false; } }
}

注意事項與踩坑記錄

後台只能取得下拉選單的 value 值,無法直接取得顯示的文字(text),需透過 JavaScript 或隱藏控制項中轉。例如後台取得的值會是 ID:

Label1.Text = Request.Form[ddl1.UniqueID] + " "
            + Request.Form["ddl2"] + " "
            + Request.Form[ddl3.ClientID.Replace("_", "$")];

若需要取得文字,可用 HiddenField 控制項中轉:

<asp:HiddenField ID="HiddenField1" runat="server" />
<asp:HiddenField ID="HiddenField2" runat="server" />
<asp:HiddenField ID="HiddenField3" runat="server" />

把選中項的值寫入隱藏控制項:

<script type="text/javascript">
var Key1 = $("#ddl1>option:selected").val();
$('#HiddenField1').val(Key1);
var Key2 = $("#ddl2>option:selected").val();
$('#HiddenField2').val(Key2);
var Key3 = $("#ddl3>option:selected").val();
$('#HiddenField3').val(Key3);
</script>

實作過程中遇到的問題是:動態賦值到 HiddenField 控制項的值,有時無法與下拉選單實際選中的值保持同步對應,這點在整合時要特別留意。

XML學習教程| jQuery入門知識| AJAX入門| Dreamweaver教程| Fireworks入門知識| SEO技巧| SEO優化集錦|
Copyright © DIV+CSS佈局教程網 All Rights Reserved