基于jQuery Ajax实现下拉框无刷新联动

前端之家收集整理的这篇文章主要介绍了基于jQuery Ajax实现下拉框无刷新联动前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

本文实例为大家分享了jQuery Ajax实现下拉框无刷新联动的具体代码,供大家参考,具体内容如下

HTML代码

@using DAL;
@using System.Data;

@{
AreaDal areaDal = new AreaDal();
string areaId = ViewBag.areaId;
DataRow drArea = areaDal.GetArea(areaId);
string countyId = drArea == null ? "-1" : drArea["countyId"].ToString();
DataRow drCounty = areaDal.GetCounty(countyId);
string cityId = drCounty == null ? "-1" : drCounty["cityId"].ToString();
DataRow drCity = areaDal.GetCity(cityId);
string provinceId = drCity == null ? "-1" : drCity["provinceId"].ToString();
}

<!DOCTYPE html>

商<a href="/tag/quanxuan/" target="_blank" class="keywords">圈选</a>择 @H_301_10@

Controller代码

namespace Controllers.Backstage
{
///
/// 行政区划
///

public class AreaController : AdminBaseController
{

region 构造函数及变量

private <a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteHelper.<a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteHelper <a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteHelper;
private AreaDal areaDal;

public AreaController()
{
  <a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteHelper = new <a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteHelper.<a href="/tag/sql/" target="_blank" class="keywords">sql</a>iteHelper();
  areaDal = new AreaDal();
}
#endregion

#region 行政区划商圈级联选择<a href="/tag/yemian/" target="_blank" class="keywords">页面</a>
public ActionResult AreaSelect()
{
  return PartialView();
}
#endregion

#region <a href="/tag/huoqu/" target="_blank" class="keywords">获取</a>全部省
public ActionResult GetProvinces()
{
  DataTable dt = areaDal.GetProvincesAll();

  StringBuilder sbHtml = new StringBuilder();
  sbHtml.Append("<option value='-1'>==请选择==</option>");
  foreach (DataRow dr in dt.Rows)
  {
    sbHtml.AppendFormat("<option value='{0}'>{1}</option>",dr["id"].ToString(),dr["name"].ToString());
  }

  return Content(sbHtml.ToString());
}
#endregion

#region 根据省<a href="/tag/huoqu/" target="_blank" class="keywords">获取</a>市
public ActionResult GetCities(string provinceId)
{
  DataTable dt = areaDal.GetCities(provinceId);

  StringBuilder sbHtml = new StringBuilder();
  sbHtml.Append("<option value='-1'>==请选择==</option>");
  foreach (DataRow dr in dt.Rows)
  {
    sbHtml.AppendFormat("<option value='{0}'>{1}</option>",dr["name"].ToString());
  }

  return Content(sbHtml.ToString());
}
#endregion

#region 根据市<a href="/tag/huoqu/" target="_blank" class="keywords">获取</a>区县
public ActionResult GetCounties(string cityId)
{
  DataTable dt = areaDal.GetCounties(cityId);

  StringBuilder sbHtml = new StringBuilder();
  sbHtml.Append("<option value='-1'>==请选择==</option>");
  foreach (DataRow dr in dt.Rows)
  {
    sbHtml.AppendFormat("<option value='{0}'>{1}</option>",dr["name"].ToString());
  }

  return Content(sbHtml.ToString());
}
#endregion

#region 根据区县<a href="/tag/huoqu/" target="_blank" class="keywords">获取</a>商圈
public ActionResult GetAreas(string countyId)
{
  DataTable dt = areaDal.GetAreas(countyId);

  StringBuilder sbHtml = new StringBuilder();
  sbHtml.Append("<option value='-1'>==请选择==</option>");
  foreach (DataRow dr in dt.Rows)
  {
    sbHtml.AppendFormat("<option value='{0}'>{1}</option>",dr["name"].ToString());
  }

  return Content(sbHtml.ToString());
}
#endregion

}
}

以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持编程之家。

猜你在找的jQuery相关文章