三级联动三层实现

最新推荐文章于 2022-05-09 01:28:48 发布

t1061169865

最新推荐文章于 2022-05-09 01:28:48 发布

阅读量503

点赞数

分类专栏：数据库文章标签：三层

本文链接：https://blog.csdn.net/t1061169865/article/details/8962180

版权

数据库专栏收录该内容

10 篇文章 0 订阅

订阅专栏

前台：

后台：

namespace 三级联动三层
{
    public partial class 三级联动 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                province();
            }
        }
        private void province()
        {
            BLL.province bpro = new BLL.province();
            DataTable dt=bpro.GetList("").Tables[0];
            ddlprovince.DataSource = dt;
            ddlprovince.DataTextField = "provincename";
            ddlprovince.DataValueField = "provinceID";
            ddlprovince.DataBind();
        }

        protected void ddlprovince_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (this.ddlarea.Items.Count>0)
            {
                this.ddlarea.Items.Clear();
            }
            BLL.city bcity = new BLL.city();
            string proid = this.ddlprovince.SelectedItem.Value;
            DataTable dt = bcity.GetList("father='" + proid + "'").Tables[0];
            ddlcity.DataSource = dt;
            ddlcity.DataTextField = "cityname";
            ddlcity.DataValueField = "cityID";
            ddlcity.DataBind();
            //绑定默认显示的市级区划下面所有的县
            string cityid = dt.Rows[0]["cityID"].ToString();
            BLL.area barea = new BLL.area();
            DataTable dt1 = barea.GetList("father='" + cityid + "'").Tables[0];
            ddlarea.DataSource = dt1;
            ddlarea.DataTextField = "areaname";
            ddlarea.DataValueField = "areaID";
            ddlarea.DataBind();
        }

        protected void ddlcity_SelectedIndexChanged(object sender, EventArgs e)
        {
            BLL.area barea = new BLL.area();
            string cityid = this.ddlcity.SelectedItem.Value;
            DataTable dt = barea.GetList("father='" + cityid + "'").Tables[0];
            ddlarea.DataSource = dt;
            ddlarea.DataTextField = "areaname";
            ddlarea.DataValueField = "areaID";
            ddlarea.DataBind();
        }
    }
}

BLL层 province city area

public DataSet GetList(string strWhere)
  {
   return dal.GetList(strWhere);
  }

DAL层 province

public DataSet GetList(string strWhere)
  {
   StringBuilder strSql=new StringBuilder();
   strSql.Append("select id,provinceID,provincename ");
   strSql.Append(" FROM province ");
   if(strWhere.Trim()!="")
   {
    strSql.Append(" where "+strWhere);
   }
   return DbHelperSQL.Query(strSql.ToString());
  }

DAL层 city

public DataSet GetList(string strWhere)
  {
   StringBuilder strSql=new StringBuilder();
   strSql.Append("select id,cityID,cityname,father ");
   strSql.Append(" FROM city ");
   if(strWhere.Trim()!="")
   {
    strSql.Append(" where "+strWhere);
   }
   return DbHelperSQL.Query(strSql.ToString());
  }

DAL层 area

public DataSet GetList(string strWhere)
  {
   StringBuilder strSql=new StringBuilder();
   strSql.Append("select id,areaID,areaname,father ");
   strSql.Append(" FROM area ");
   if(strWhere.Trim()!="")
   {
    strSql.Append(" where "+strWhere);
   }
   return DbHelperSQL.Query(strSql.ToString());
  }