ajax调用aspx.cs中的WebMethod
前台：
<script language="javascript" src="../js/jquery-1.8.2.js"></script> <script language="javascript" src="../js/locationFilter.js"></script> <tr> <td class="fieldtitle" width="20%"> Test Filter: </td> <td class="fieldtitle" colspan="3"> <asp:DropDownList ID="ddlRegion" runat="server" CssClass="fieldList" onchange="initData('subregion')"> </asp:DropDownList> <asp:DropDownList ID="ddlSubRegion" runat="server" CssClass="fieldList" onchange="initData('grid')"> </asp:DropDownList> <asp:DropDownList ID="ddlGrid" runat="server" CssClass="fieldList" onchange="initData('pref')"> </asp:DropDownList> <asp:DropDownList ID="ddlPref" runat="server" CssClass="fieldList" onchange="initData('city')"> </asp:DropDownList> <asp:DropDownList ID="ddlCity" runat="server" CssClass="fieldList" onchange="initData('county')"> </asp:DropDownList> <asp:DropDownList ID="ddlCounty" runat="server" CssClass="fieldList" onchange="initData('town')"> </asp:DropDownList> <asp:DropDownList ID="ddlTown" runat="server" CssClass="fieldList" onchange="initData('village')"> </asp:DropDownList> <asp:DropDownList ID="ddlVillage" runat="server" CssClass="fieldList"> </asp:DropDownList> </td> <td> <asp:TextBox ID="txtWWID" runat="server" Style="display: none"></asp:TextBox> </td> </tr>
Js文件： locationFilter.js
$(document).ready(function () { alert(1); var Rgn_cd = ""; var Subrgn_cd = ""; var Grid_cd = ""; var Pref_cd = ""; var City_id = ""; var County_id = ""; var Town_id = ""; var Village_id = ""; var Type = "region"; var WWID = $("#txtWWID").val(); $.ajax({ type: "POST", contentType: "application/json; charset=utf-8", dataType: "json", //url: "MallListCAM.aspx/initData", url: "../Mall/MallListCAM.aspx/initData", data: "{rgn_cd:'" + Rgn_cd + "', subrgn_cd:'" + Subrgn_cd + "',grid_cd:'" + Grid_cd + "',pref_cd:'" + Pref_cd + "',city_id:'" + City_id + "',county_id:'" + County_id + "',town_id:'" + Town_id + "',village_id:'" + Village_id + "',type:'" + Type + "',WWID:'" + WWID + "'}", success: function (data) { var result = JSON.parse(data.d); $("#ddlRegion").append($("<option value='ALL'>ALL</option>")); $("#ddlSubRegion").append($("<option value='ALL'>ALL</option>")); $("#ddlGrid").append($("<option value='ALL'>ALL</option>")); $("#ddlPref").append($("<option value='ALL'>ALL</option>")); $("#ddlCity").append($("<option value='ALL'>ALL</option>")); $("#ddlCounty").append($("<option value='ALL'>ALL</option>")); $("#ddlTown").append($("<option value='ALL'>ALL</option>")); $("#ddlVillage").append($("<option value='ALL'>ALL</option>")); //clearData("region"); $.each(result, function (i, item) { $("#ddlRegion").append($("<option value='" + item.rgn_cd + "'>" + item.rgn_nm + "</option>")); }) }, error: function (err) { alert("err:" + err); } }); }) function initData(type) { if (type == "subregion") { clearData("subregion"); } else if (type == "grid") { clearData("grid"); } else if (type == "pref") { clearData("pref"); } else if (type == "city") { clearData("city"); } else if (type == "county") { clearData("county"); } else if (type == "town") { clearData("town"); } var Rgn_cd = $("#ddlRegion").val(); var Subrgn_cd = $("#ddlSubRegion").val(); var Grid_cd = $("#ddlGrid").val(); var Pref_cd = $("#ddlPref").val(); var City_id = $("#ddlCity").val(); var County_id = $("#ddlCounty").val(); var Town_id = $("#ddlTown").val(); var Village_id = $("#ddlVillage").val(); var Type = type; var WWID = $("#txtWWID").val(); $.ajax({ type: "POST", contentType: "application/json; charset=utf-8", dataType: "json", url: "../Mall/MallListCAM.aspx/initData", data: "{rgn_cd:'" + Rgn_cd + "', subrgn_cd:'" + Subrgn_cd + "',grid_cd:'" + Grid_cd + "',pref_cd:'" + Pref_cd + "',city_id:'" + City_id + "',county_id:'" + County_id + "',town_id:'" + Town_id + "',village_id:'" + Village_id + "',type:'" + Type + "',WWID:'" + WWID + "'}", success: function (data) { var result = JSON.parse(data.d); if (type == "subregion") { $.each(result, function (i, item) { $("#ddlSubRegion").append($("<option value='" + item.subrgn_cd + "'>" + item.subrgn_nm + "</option>")); }) } else if (type == "grid") { $.each(result, function (i, item) { $("#ddlGrid").append($("<option value='" + item.grid_cd + "'>" + item.grid_nm + "</option>")); }) } else if (type == "pref") { $.each(result, function (i, item) { $("#ddlPref").append($("<option value='" + item.pref_cd + "'>" + item.pref_nm + "</option>")); }) } else if (type == "city") { $.each(result, function (i, item) { $("#ddlCity").append($("<option value='" + item.city_id + "'>" + item.name + "</option>")); }) } else if (type == "county") { $.each(result, function (i, item) { $("#ddlCounty").append($("<option value='" + item.county_city_id + "'>" + item.county_name + "</option>")); }) } else if (type == "town") { $.each(result, function (i, item) { $("#ddlTown").append($("<option value='" + item.town_city_id + "'>" + item.town_name + "</option>")); }) } else if (type == "village") { $("#ddlVillage").empty(); $("#ddlVillage").append($("<option value='ALL'>ALL</option>")); $.each(result, function (i, item) { $("#ddlVillage").append($("<option value='" + item.village_city_id + "'>" + item.village_city_id + "</option>")); }) } }, error: function (err) { alert("err:" + err); } }); } function clearData(type) { if (type == "subregion") { $("#ddlSubRegion").empty(); $("#ddlSubRegion").append($("<option value='ALL'>ALL</option>")); $("#ddlGrid").empty(); $("#ddlGrid").append($("<option value='ALL'>ALL</option>")); $("#ddlPref").empty(); $("#ddlPref").append($("<option value='ALL'>ALL</option>")); $("#ddlCity").empty(); $("#ddlCity").append($("<option value='ALL'>ALL</option>")); $("#ddlCounty").empty(); $("#ddlCounty").append($("<option value='ALL'>ALL</option>")); $("#ddlTown").empty(); $("#ddlTown").append($("<option value='ALL'>ALL</option>")); $("#ddlVillage").empty(); $("#ddlVillage").append($("<option value='ALL'>ALL</option>")); } else if (type == "grid") { $("#ddlGrid").empty(); $("#ddlGrid").append($("<option value='ALL'>ALL</option>")); $("#ddlPref").empty(); $("#ddlPref").append($("<option value='ALL'>ALL</option>")); $("#ddlCity").empty(); $("#ddlCity").append($("<option value='ALL'>ALL</option>")); $("#ddlCounty").empty(); $("#ddlCounty").append($("<option value='ALL'>ALL</option>")); $("#ddlTown").empty(); $("#ddlTown").append($("<option value='ALL'>ALL</option>")); $("#ddlVillage").empty(); $("#ddlVillage").append($("<option value='ALL'>ALL</option>")); } else if (type == "pref") { $("#ddlPref").empty(); $("#ddlPref").append($("<option value='ALL'>ALL</option>")); $("#ddlCity").empty(); $("#ddlCity").append($("<option value='ALL'>ALL</option>")); $("#ddlCounty").empty(); $("#ddlCounty").append($("<option value='ALL'>ALL</option>")); $("#ddlTown").empty(); $("#ddlTown").append($("<option value='ALL'>ALL</option>")); $("#ddlVillage").empty(); $("#ddlVillage").append($("<option value='ALL'>ALL</option>")); } else if (type == "city") { $("#ddlCity").empty(); $("#ddlCity").append($("<option value='ALL'>ALL</option>")); $("#ddlCounty").empty(); $("#ddlCounty").append($("<option value='ALL'>ALL</option>")); $("#ddlTown").empty(); $("#ddlTown").append($("<option value='ALL'>ALL</option>")); $("#ddlVillage").empty(); $("#ddlVillage").append($("<option value='ALL'>ALL</option>")); } else if (type == "county") { $("#ddlCounty").empty(); $("#ddlCounty").append($("<option value='ALL'>ALL</option>")); $("#ddlTown").empty(); $("#ddlTown").append($("<option value='ALL'>ALL</option>")); $("#ddlVillage").empty(); $("#ddlVillage").append($("<option value='ALL'>ALL</option>")); } else if (type == "town") { $("#ddlTown").empty(); $("#ddlTown").append($("<option value='ALL'>ALL</option>")); $("#ddlVillage").empty(); $("#ddlVillage").append($("<option value='ALL'>ALL</option>")); } }
后台代码：
[System.Web.Services.WebMethod] public static string initData(string rgn_cd, string subrgn_cd, string grid_cd, string pref_cd, string city_id, string county_id, string town_id, string village_id, string type, string WWID) { //string rgn_cd,string subrgn_cd,string grid_cd,string pref_cd,string city_id,string county_id,string town_id,string village_id, SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["DSN"].DecodeBase64()); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "region_subregion_grid_pref_city_county_town_village_by_wwid"; cmd.Connection = conn; if (string.IsNullOrEmpty(rgn_cd) || rgn_cd == "null" || rgn_cd == "ALL") { cmd.Parameters.AddWithValue("@rgn_cd", DBNull.Value); } else { cmd.Parameters.AddWithValue("@rgn_cd", rgn_cd); } if (string.IsNullOrEmpty(subrgn_cd) || subrgn_cd == "null" || subrgn_cd == "ALL") { cmd.Parameters.AddWithValue("@subrgn_cd", DBNull.Value); } else { cmd.Parameters.AddWithValue("@subrgn_cd", subrgn_cd); } if (string.IsNullOrEmpty(grid_cd) || grid_cd == "null" || grid_cd == "ALL") { cmd.Parameters.AddWithValue("@grid_cd", DBNull.Value); } else { cmd.Parameters.AddWithValue("@grid_cd", grid_cd); } if (string.IsNullOrEmpty(pref_cd) || pref_cd == "null" || pref_cd == "ALL") { cmd.Parameters.AddWithValue("@pref_cd", DBNull.Value); } else { cmd.Parameters.AddWithValue("@pref_cd", pref_cd); } if (string.IsNullOrEmpty(city_id) || city_id == "null" || city_id == "ALL") { cmd.Parameters.AddWithValue("@city_id", DBNull.Value); } else { cmd.Parameters.AddWithValue("@city_id", city_id); } if (string.IsNullOrEmpty(county_id) || county_id == "null" || county_id == "ALL") { cmd.Parameters.AddWithValue("@county_id", DBNull.Value); } else { cmd.Parameters.AddWithValue("@county_id", city_id); } if (string.IsNullOrEmpty(town_id) || town_id == "null" || town_id == "ALL") { cmd.Parameters.AddWithValue("@town_id", DBNull.Value); } else { cmd.Parameters.AddWithValue("@town_id", town_id); } if (string.IsNullOrEmpty(village_id) || village_id == "null" || village_id == "ALL") { cmd.Parameters.AddWithValue("@village_id", DBNull.Value); } else { cmd.Parameters.AddWithValue("@village_id", village_id); } cmd.Parameters.AddWithValue("@type", type); cmd.Parameters.AddWithValue("@wwid", "10651923");//((AccessControler)this.Session["_accessctrl"]).GetWWID()); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; DataTable dt = new DataTable(); conn.Open(); da.Fill(dt); //this.HiddenRegion.Text = JsonConvert.SerializeObject(dt); conn.Close(); da.Dispose(); cmd.Dispose(); return JsonConvert.SerializeObject(dt); }
