Author:太平盛世
–>
<script src=”jquery1.3.2.js”> </script>
<script src=”area.js”></script>
<script>
</script>
<script>
//上面的代码贴过来即可
</script>
</HEAD>
<BODY>
地区:
<select name=”province” id=”province”></select>
<select name=”city” id=”city”>
<option value=””>请选择</option>
</select>
</BODY>
</HTML>
接下来就是.NET代码数据json啦，
/// <summary>
/// 输出json数据
/// </summary>
/// <remarks>
/// <para>Date:2011-07-01</para>
/// <para>Author:太平盛世</para>
/// </remarks>
/// <returns></returns>
public string WriteJson()
{
//取数据库里面的所有的数据
Ilist<AreaTye> areaList = GetAreaTypeListAll();
//取省级集合，AT_ParentId=1的
//var provNameParentId = from area in areaList where area.AT_ParentId == 1 select area;
//所有的数据
var areaLinq = from area in areaList select area;
//筛选，筛选出省级集合，筛选调整 AT_ParentId == 0
var areaWhereParentId = areaLinq.Where(m => m.AT_ParentId == 0).ToList();
//省级名称 格式:”湖南省,浙江省,北京市,…”
string provName = string.Join(“,”, areaWhereParentId.Select(m => m.AT_Name).ToArray());
//省级编号 格式:”1,2,3,…”
string provCode = string.Join(“,”, areaWhereParentId.Select(m => m.AT_Id).ToArray());
//省级数量
int num = areaWhereParentId.Count();
var jsonstr = new StringBuilder();
jsonstr.Append(“{“);
var areaCityList = new List<AreaType>();
for(var i=0;i<num;i++)
{
var areaType = new AreaType();
areaType = areaWhereParentId[i] ;
int id = areaType.AT_Id;
areaCityList = areaLinq.Where(m => m.AT_ParentId == id).ToList();
var cityName = string.Join(“,”, areaCityList.Select(m => m.AT_Name).ToArray());
var cityCode = string.Join(“,”, areaCityList.Select(m => m.AT_Id).ToArray());
jsonstr.Append(“””);
jsonstr.Append(“city”);
jsonstr.Append(areaType.AT_Id);
jsonstr.Append(“””);
jsonstr.Append(“:”);
jsonstr.Append(“””);
jsonstr.Append(cityName);
jsonstr.Append(“””);
jsonstr.Append(“,”);
jsonstr.Append(“””);
jsonstr.Append(“code”);
jsonstr.Append(areaType.AT_Id);
jsonstr.Append(“””);
jsonstr.Append(“:”);
jsonstr.Append(“””);
jsonstr.Append(cityCode);
jsonstr.Append(“””);
jsonstr.Append(“,”);
