显示:
#region 返回 相应国家的省 IEnumerable + getShengList(string id)
public IEnumerable<SelectListItem> getShengList(string id)
{
classDBOP dbop = new classDBOP();
string Swhere = "CTUCountry=" + id + " and CityType='省'";
DataTable dt = dbop.SchDataDT("CTUCity", "CTUID,CityType,Name,CTUCountry", Swhere, 4);
if (dt != null)
{
IEnumerable<SelectListItem> listItem = (from c in dt.AsEnumerable().ToList()
//where c["CityType"].ToString().Trim() == "省"
//&& c["CTUCountry"].ToString().Trim()==id
select c).ToList()
.Select(c => new SelectListItem { Value = c["CTUID"].ToString(), Text = c["Name"].ToString() });
return listItem;
}
return null;
}
#endregion
#region 初始加载页面获得国家列表+ Create()
// GET: /Marked/Create
public ActionResult Create()
{
ClassArea area = new ClassArea();
ViewBag.Sheng = area.getShengList("100");
return View();
}
#endregion
@Html.DropDownList("ShengList", ViewBag.Sheng as IEnumerable<SelectListItem>)