项目中Ajax调用ashx页面中的Function的实战
前台页面：
使用几个display=none的空间存储DropdownList中的值，点击Search Button后刷新页面再次给DropdownList赋值使用
<%@ Page Language="c#" CodeBehind="MallListCAM.aspx.cs" AutoEventWireup="True" Inherits="PRCSales_internal.Mall.MallListCAM" EnableEventValidation="false" %> <%@ Implements Interface="Idunno.AntiCsrf.ISuppressCsrfCheck" %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" > <html> <head> <title>MallList</title> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1"> <meta name="CODE_LANGUAGE" content="C#"> <meta name="vs_defaultClientScript" content="JavaScript"> <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5"> <link href="../css/Styles_1.css" type="text/css" rel="stylesheet"> <script language="javascript" src="../js/jquery-1.8.2.js"></script> <script language="javascript" src="../js/locationFilter.js"></script> <script language="javascript"> function Popup(url, width, height) { var left = (window.screen.width - width) / 2; var top = (window.screen.height - height) / 2; window.open(url, '_blank', 'top=' + top + ',left=' + left + ',resizable=no,toolbar=no,width=' + width + ',height=' + height); //window.open(url,'_blank','top=190,left=170,resizable=no,toolbar=no,width='+width+',height='+height); //window.showModalDialog(url,window,'status=0;dialogWidth='+width+'px;dialogHeight='+height+'px;'); } function Refresh() { document.Form1.btnSubmit.click(); } function Remove() { if (confirm("Are you sure to remove selected Mall?")) { return true; } else { return false; } } </script> </head> <body ms_positioning="GridLayout"> <form id="Form1" method="post" runat="server"> <table cellspacing="0" cellpadding="0" width="100%"> <tr> <td class="pagetitle"> <asp:Label ID="lblTitle" Style="z-index: 101; position: relative" runat="server"></asp:Label> </td> </tr> <tr> <td> <table width="100%"> <tr> <td class="fieldtitle" width="50%" colspan="2"> Mall information </td> <td class="fieldtitle" width="50%" colspan="2"> <font color="#993333"> <asp:Label ID="lblComplete" runat="server"></asp:Label></font> </td> </tr> <tr style="height: 1px; background-color: #3366ff"> <td colspan="4"> </td> </tr> <tr> <td class="fieldtitle" width="50%" colspan="2"> Mall search </td> <td align="right" width="50%" colspan="2"> <asp:Button ID="btnSubmit" runat="server" Text="Search" CssClass="fieldButton" OnClick="btnSubmit_Click"> </asp:Button> </td> </tr> <tr> <td class="fieldtitle" width="20%"> Region/SubRegion/Grid/Prefecture/City/County/Town/Village: </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> <asp:TextBox ID="txtRegion" runat="server" Style="display: none"></asp:TextBox> <asp:TextBox ID="txtSubRegion" runat="server" Style="display: none"></asp:TextBox> <asp:TextBox ID="txtGrid" runat="server" Style="display: none"></asp:TextBox> <asp:TextBox ID="txtPref" runat="server" Style="display: none"></asp:TextBox> <asp:TextBox ID="txtCity" runat="server" Style="display: none"></asp:TextBox> <asp:TextBox ID="txtCounty" runat="server" Style="display: none"></asp:TextBox> <asp:TextBox ID="txtTown" runat="server" Style="display: none"></asp:TextBox> <asp:TextBox ID="txtVillage" runat="server" Style="display: none"></asp:TextBox> </td> </tr> <tr> <td class="fieldtitle" width="25%"> Type: </td> <td class="fieldtitle" width="25%"> <asp:DropDownList ID="dplType" runat="server" CssClass="fieldList" AutoPostBack="True" OnSelectedIndexChanged="dplType_SelectedIndexChanged"> </asp:DropDownList> </td> <td class="fieldtitle" width="25%"> Branding: </td> <td class="fieldtitle" width="25%"> <asp:DropDownList ID="dplBrd" runat="server" CssClass="fieldList"> </asp:DropDownList> </td> </tr> <tr style="height: 1px; background-color: #3366ff"> <td colspan="4"> </td> </tr> <tr> <td class="fieldtitle" width="25%"> Mall list <asp:Label ID="lblCount" runat="server" CssClass="fieldList"></asp:Label> </td> <td align="right" colspan="3"> <asp:Button ID="btnAdd" runat="server" CssClass="fieldButton" Text="Add" Width="60px"> </asp:Button> <asp:Button ID="btnExport" runat="server" Visible="False" Text="Export" CssClass="fieldButton" Width="60px" OnClick="btnExport_Click"> </asp:Button> </td> </tr> <tr> <td colspan="4"> <asp:DataGrid ID="dg" Style="z-index: 101; position: relative" runat="server" Width="96%" AutoGenerateColumns="False" PageSize="60" AllowPaging="True" AllowSorting="True"> <AlternatingItemStyle CssClass="datagridAlternating"></AlternatingItemStyle> <HeaderStyle CssClass="tableHead"></HeaderStyle> <Columns> <asp:BoundColumn Visible="False" DataField="mall_id"></asp:BoundColumn> <asp:BoundColumn DataField="grid_cd" HeaderText="Grid" SortExpression="grid_cd"> <ItemStyle HorizontalAlign="Center" Width="5%"></ItemStyle> </asp:BoundColumn> <asp:BoundColumn DataField="pref_nm" HeaderText="Prefecture" SortExpression="pref_nm"> <ItemStyle HorizontalAlign="Center" Width="7%"></ItemStyle> </asp:BoundColumn> <asp:BoundColumn DataField="city_std_loc_nm" HeaderText="City" SortExpression="city_std_loc_nm"> <ItemStyle HorizontalAlign="Center" Width="7%"></ItemStyle> </asp:BoundColumn> <asp:BoundColumn DataField="county_nm" HeaderText="County Name" SortExpression="county_nm"> <ItemStyle HorizontalAlign="Center" Width="7%"></ItemStyle> </asp:BoundColumn> <asp:BoundColumn DataField="town_nm" HeaderText="Town Name" SortExpression="town_nm"> <ItemStyle HorizontalAlign="Center" Width="7%"></ItemStyle> </asp:BoundColumn> <asp:BoundColumn DataField="village_nm" HeaderText="Village Name" SortExpression="village_nm"> <ItemStyle HorizontalAlign="Center" Width="7%"></ItemStyle> </asp:BoundColumn> <asp:BoundColumn DataField="mall_type_nm" HeaderText="Mall Type" SortExpression="mall_type_nm"> <ItemStyle HorizontalAlign="Center" Width="5%"></ItemStyle> </asp:BoundColumn> <asp:BoundColumn DataField="mall_brnd_nm" HeaderText="Mall Branding" SortExpression="mall_brnd_nm"> <ItemStyle HorizontalAlign="Center" Width="5%"></ItemStyle> </asp:BoundColumn> <asp:BoundColumn DataField="mall_nm" HeaderText="Mall Name" SortExpression="mall_nm"> <ItemStyle HorizontalAlign="Left" Width="23%"></ItemStyle> </asp:BoundColumn> <asp:BoundColumn DataField="mall_addr" HeaderText="Address" SortExpression="mall_addr"> <ItemStyle HorizontalAlign="Left" Width="23%"></ItemStyle> </asp:BoundColumn> <asp:BoundColumn DataField="last_upd_dtm" HeaderText="Last Updated at" DataFormatString="{0:M/d/yyyy}" SortExpression="last_upd_dtm"> <ItemStyle HorizontalAlign="Center" Width="10%"></ItemStyle> </asp:BoundColumn> <asp:BoundColumn DataField="last_upd_usr_nm" HeaderText="Last Updated by" SortExpression="last_upd_usr_nm"> <ItemStyle HorizontalAlign="Center" Width="5%"></ItemStyle> </asp:BoundColumn> <asp:TemplateColumn HeaderText="Action"> <ItemStyle HorizontalAlign="Center" Width="5%"></ItemStyle> <ItemTemplate> <a href="javascript:Popup('MallProfile.aspx?action=edit&mall_id=<%# DataBinder.Eval(Container, "DataItem.mall_id") %>','850','600');void(0);"> Edit</a> </ItemTemplate> </asp:TemplateColumn> <asp:TemplateColumn HeaderText=""> <ItemStyle HorizontalAlign="Center" Width="5%"></ItemStyle> <ItemTemplate> <asp:LinkButton ID="btn_Delete" CssClass="Command" Text='Delete' CommandName="delete" CommandArgument='<%# DataBinder.Eval(Container.DataItem, "mall_id") %>' runat="server"> </asp:LinkButton> </ItemTemplate> </asp:TemplateColumn> </Columns> <PagerStyle Position="TopAndBottom" Mode="NumericPages"></PagerStyle> </asp:DataGrid> </td> </tr> </table> </td> </tr> </table> </form> </body> </html>
JS代码：
注意在Ajax中调用ashx页面中的function的方式。
$(document).ready(function () { 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: "../LocationFilter.ashx", 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) { $("#ddlRegion").append($("<option value='ALL'>ALL</option>")); $.each(data, function (i, item) { $("#ddlRegion").append($("<option value='" + item.rgn_cd + "'>" + item.rgn_nm + "</option>")); }) //alert($("#txtRegion").val()); $("#ddlRegion option[value='" + $("#txtRegion").val() + "']").attr("selected", true); }, error: function (err) { //alert("请等待Filter数据加载完毕再进行查询！"); } }); updateData("subregion"); updateData("grid"); updateData("pref"); updateData("city"); updateData("county"); }) 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: "../LocationFilter.ashx", 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) { if (type == "subregion") { $("#txtRegion").val(Rgn_cd); updateData("grid"); updateData("pref"); updateData("city"); updateData("county"); $.each(data, function (i, item) { $("#ddlSubRegion").append($("<option value='" + item.subrgn_cd + "'>" + item.subrgn_nm + "</option>")); }) } else if (type == "grid") { $("#txtSubRegion").val(Subrgn_cd); updateData("pref"); updateData("city"); updateData("county"); $.each(data, function (i, item) { $("#ddlGrid").append($("<option value='" + item.grid_cd + "'>" + item.grid_nm + "</option>")); }) } else if (type == "pref") { $("#txtGrid").val(Grid_cd); updateData("city"); updateData("county"); $.each(data, function (i, item) { $("#ddlPref").append($("<option value='" + item.pref_cd + "'>" + item.pref_nm + "</option>")); }) } else if (type == "city") { $("#txtPref").val(Pref_cd); updateData("county"); $.each(data, function (i, item) { $("#ddlCity").append($("<option value='" + item.city_id + "'>" + item.name + "</option>")); }) } else if (type == "county") { $("#txtCity").val(City_id); updateData("town"); updateData("village"); $.each(data, function (i, item) { $("#ddlCounty").append($("<option value='" + item.county_city_id + "'>" + item.county_name + "</option>")); }) } else if (type == "town") { $("#txtCounty").val(County_id); $.each(data, function (i, item) { $("#ddlTown").append($("<option value='" + item.town_city_id + "'>" + item.town_name + "</option>")); }) } else if (type == "village") { $("#txtTown").val(Town_id); updateData("village"); $("#ddlVillage").empty(); $("#ddlVillage").append($("<option value='ALL'>ALL</option>")); $.each(data, function (i, item) { $("#ddlVillage").append($("<option value='" + item.village_city_id + "'>" + item.village_city_id + "</option>")); }) } }, error: function (err) { //alert("err:" + err); //alert("请等待Filter数据加载完毕再进行查询！"); } }); } function updateData(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(); if (type == "subregion" && $("#txtRegion").val() != "") { Rgn_cd = $("#txtRegion").val(); } if (type == "grid" && $("#txtSubRegion").val() != "") { Subrgn_cd = $("#txtSubRegion").val(); } if (type == "pref" && $("#txtGrid").val() != "") { Grid_cd = $("#txtGrid").val(); } if (type == "city" && $("#txtPref").val() != "") { Pref_cd = $("#txtPref").val(); } if (type == "county" && $("#txtCity").val() != "") { City_id = $("#txtCity").val(); } $.ajax({ type: "POST", contentType: "application/json; charset=utf-8", dataType: "json", url: "../LocationFilter.ashx", 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) { if (type == "subregion") { $.each(data, function (i, item) { if (item.subrgn_cd == $("#txtSubRegion").val()) { $("#ddlSubRegion").append($("<option value='" + item.subrgn_cd + "' selected = 'selected'>" + item.subrgn_nm + "</option>")); } else { $("#ddlSubRegion").append($("<option value='" + item.subrgn_cd + "'>" + item.subrgn_nm + "</option>")); } //$("#ddlSubRegion").append($("<option value='" + item.subrgn_cd + "'>" + item.subrgn_nm + "</option>")); }) } else if (type == "grid") { $.each(data, function (i, item) { if (item.grid_cd == $("#txtGrid").val()) { $("#ddlGrid").append($("<option value='" + item.grid_cd + "' selected = 'selected'>" + item.grid_nm + "</option>")); } else { $("#ddlGrid").append($("<option value='" + item.grid_cd + "'>" + item.grid_nm + "</option>")); } //$("#ddlGrid").append($("<option value='" + item.grid_cd + "'>" + item.grid_nm + "</option>")); }) } else if (type == "pref") { $.each(data, function (i, item) { if (item.pref_cd == $("#txtPref").val()) { $("#ddlPref").append($("<option value='" + item.pref_cd + "' selected = 'selected'>" + item.pref_nm + "</option>")); } else { $("#ddlPref").append($("<option value='" + item.pref_cd + "'>" + item.pref_nm + "</option>")); } //$("#ddlPref").append($("<option value='" + item.pref_cd + "'>" + item.pref_nm + "</option>")); }) } else if (type == "city") { $.each(data, function (i, item) { if (item.city_id == $("#txtCity").val()) { $("#ddlCity").append($("<option value='" + item.city_id + "' selected = 'selected'>" + item.name + "</option>")); } else { $("#ddlCity").append($("<option value='" + item.city_id + "'>" + item.name + "</option>")); } //$("#ddlCity").append($("<option value='" + item.city_id + "'>" + item.name + "</option>")); }) } else if (type == "county") { $.each(data, function (i, item) { if (item.county_city_id == $("#txtCounty").val()) { $("#ddlCounty").append($("<option value='" + item.county_city_id + "' selected = 'selected'>" + item.county_name + "</option>")); } else { $("#ddlCounty").append($("<option value='" + item.county_city_id + "'>" + item.county_name + "</option>")); } //$("#ddlCounty").append($("<option value='" + item.county_city_id + "'>" + item.county_name + "</option>")); }) } else if (type == "town") { $.each(data, function (i, item) { if (item.town_city_id == $("#txtTown").val()) { $("#ddlTown").append($("<option value='" + item.town_city_id + "' selected = 'selected'>" + item.town_name + "</option>")); } else { $("#ddlTown").append($("<option value='" + item.town_city_id + "'>" + item.town_name + "</option>")); } //$("#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(data, function (i, item) { if (item.village_city_id == $("#txtVillage").val()) { $("#ddlVillage").append($("<option value='" + item.village_city_id + "' selected = 'selected'>" + item.village_city_id + "</option>")); } else { $("#ddlVillage").append($("<option value='" + item.village_city_id + "'>" + item.village_city_id + "</option>")); } //$("#ddlVillage").append($("<option value='" + item.village_city_id + "'>" + item.village_city_id + "</option>")); }) } }, error: function (err) { //alert("err:" + err); //alert("请等待Filter数据加载完毕再进行查询！"); } }); } 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>")); } }
ashx页面代码：
由于前面JS中Get的为Json数据，在ProcessRequest中设置：context.Response.ContentType = "text/json";
using System; using System.Web; using System.Data; using System.Data.SqlClient; using Intel.PRCSMS.Common; using Newtonsoft.Json; using System.IO; using System.Web.Script.Serialization; using System.Collections.Generic; namespace PRCSales_internal { /// <summary> /// Summary description for LocationFilter /// </summary> public class LocationFilter : IHttpHandler { public void ProcessRequest(HttpContext context) { HttpResponse res = context.Response; res.ContentType = "text/json"; Dictionary<String, Object> dicParameter = GetParameter(context); string rgn_cd = dicParameter["rgn_cd"].ToString(); string subrgn_cd = dicParameter["subrgn_cd"].ToString(); string grid_cd = dicParameter["grid_cd"].ToString(); string pref_cd = dicParameter["pref_cd"].ToString(); string city_id = dicParameter["city_id"].ToString(); string county_id = dicParameter["county_id"].ToString(); string town_id = dicParameter["town_id"].ToString(); string village_id = dicParameter["village_id"].ToString(); string type = dicParameter["type"].ToString(); string WWID = dicParameter["WWID"].ToString(); 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");// WWID SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; DataTable dt = new DataTable(); conn.Open(); da.Fill(dt); conn.Close(); da.Dispose(); cmd.Dispose(); res.Write(JsonConvert.SerializeObject(dt).ToString()); res.End(); } private Dictionary<String, Object> GetParameter(HttpContext context) { StreamReader reader = new StreamReader(context.Request.InputStream); String strJson = HttpUtility.UrlDecode(reader.ReadToEnd()); JavaScriptSerializer jss = new JavaScriptSerializer(); Dictionary<String, Object> dicParameter = jss.Deserialize<Dictionary<String, Object>>(strJson); return dicParameter; } public bool IsReusable { get { return false; } } } }
