AjaxControlToolkit实现级联

最新推荐文章于 2021-01-20 02:44:55 发布

yang651280121

最新推荐文章于 2021-01-20 02:44:55 发布

阅读量810

点赞数

分类专栏： C#编码文章标签： string server asp textbox assembly class

本文链接：https://blog.csdn.net/yang651280121/article/details/7967257

版权

C#编码专栏收录该内容

21 篇文章 0 订阅

订阅专栏

1、首先下载AjaxControlToolkit

2、粘贴到Bin中

3、在.aspx前台的最上面加上引用<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>

4、下面是.aspx中的代码

<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>

</table>

5、.cs中的代码

using AjaxControlToolkit;
using System.Collections.Generic;
using System.Collections.Specialized;

if (!IsPostBack)
        {
            BindInit(); //加载绑定数据
        }

#region 省市级连
    [System.Web.Services.WebMethod]
    [System.Web.Script.Services.ScriptMethod]
    public static CascadingDropDownNameValue[] GetProvince(string knownCategoryValues, string category)
    {
        List<CascadingDropDownNameValue> countryList = new List<CascadingDropDownNameValue>();
        DataTable dt = DiQu.GetProvinceTable();
        foreach (DataRow dr in dt.Rows)
        {
            countryList.Add(new CascadingDropDownNameValue(dr["crcname"].ToString(), dr["crcode"].ToString()));
        }
        return countryList.ToArray();
    }
    [System.Web.Services.WebMethod]
    [System.Web.Script.Services.ScriptMethod]
    public static CascadingDropDownNameValue[] GetCityForProvince(string knownCategoryValues, string category)
    {
        StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);

        List<CascadingDropDownNameValue> countryList = new List<CascadingDropDownNameValue>();
        DataTable dt = DiQu.GetCity(Convert.ToInt32(kv["Province"]));
        foreach (DataRow dr in dt.Rows)
        {
            countryList.Add(new CascadingDropDownNameValue(dr["crcname"].ToString(), dr["crcode"].ToString()));
        }
        return countryList.ToArray();
    }
    [System.Web.Services.WebMethod]
    [System.Web.Script.Services.ScriptMethod]
    public static CascadingDropDownNameValue[] GetAreaForCity(string knownCategoryValues, string category)
    {
        StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);

        List<CascadingDropDownNameValue> countryList = new List<CascadingDropDownNameValue>();
        DataTable dt = DiQu.GetArea(Convert.ToInt32(kv["City"]));
        foreach (DataRow dr in dt.Rows)
        {
            countryList.Add(new CascadingDropDownNameValue(dr["crcname"].ToString(), dr["crcode"].ToString()));

        }
        return countryList.ToArray();
    }

//要初始化

private void BindInit()

{

this.ccdProvince1.SelectedValue = user.Address_ProvinceCode;
            this.ccdCity1.SelectedValue = user.Address_CityCode;
            this.ccdArea1.SelectedValue = user.Address_AreaCode;
}
    #endregion

6、获得地址的类

public class DiQu
    {
        /// <summary>
        /// 返回省数据
        /// </summary>
        /// <param name="Cityid"></param>
        /// <returns></returns>
        public static string GetProvince()
        {
            getDiQu odiqu = new getDiQu();
            odiqu.crclass = 1;
            odiqu.crpcode = 0;
            DataTable oTable = odiqu.ExecDataTable(odiqu.ConnectionStringCustomer);

            StringBuilder buffer = new StringBuilder();
            buffer.Append(" var objProvince='");
            foreach (DataRow oRow in oTable.Rows)
            {
                buffer.Append(oRow["crcode"].ToString() + "," + oRow["crcname"].ToString() + ";");
            }
            string strJs = buffer.ToString().Substring(0, buffer.ToString().Length - 1) + "';\r\n";
            return "<script>\r\n" + strJs + "</script>\r\n";
        }
        /// <summary>
        /// 返回省数据
        /// </summary>
        /// <param name="Cityid"></param>
        /// <returns></returns>
        public static DataTable GetProvinceTable()
        {
            getDiQu odiqu = new getDiQu();
            odiqu.crclass = 1;
            odiqu.crpcode = 0;
            DataTable oTable = odiqu.ExecDataTable(odiqu.ConnectionStringCustomer);
            return oTable;
        }

        /// <summary>
        /// 返回市数据
        /// </summary>
        /// <param name="Cityid"></param>
        /// <returns></returns>
        public static DataTable GetCity(int province)
        {
            getDiQu odiqu = new getDiQu();
            odiqu.crclass = 2;
            odiqu.crpcode = province;
            DataTable oTable = odiqu.ExecDataTable(odiqu.ConnectionStringCustomer);
            return oTable;
        }
        /// <summary>
        /// 返回区数据
        /// </summary>
        /// <param name="Cityid"></param>
        /// <returns></returns>
        public static DataTable GetArea(int city)
        {
            getDiQu odiqu = new getDiQu();
            odiqu.crclass = 3;
            odiqu.crpcode = city;
            DataTable oTable = odiqu.ExecDataTable(odiqu.ConnectionStringCustomer);
            return oTable;
        }

}