public void SearchProvinceByTree()
{
string name = (Request["name"] == null ? "" : Request["name"]); //查询过滤条件
string where = "";
if (!string.IsNullOrEmpty(name.Trim()))
{
where += "(Name like '%" + name.Trim() + "%' or Code like '%" + name.Trim() + "%')";
}
DataSet ds = new BllSysHatProvince().GetTreeList(where);
List <jsonSysBusinessCircle> list = new FunTreeCommon().GetJsonTree(ds);
WriteJsonToPage(new JavaScriptSerializer().Serialize(list));
}
public void comProvince(string code)
{
//默认添加
if (string.IsNullOrEmpty(code))
{
List <ModSysHatProvince> list = new BllSysHatProvince().QueryToAll();
WriteJsonToPage(JsonHelper.ToJson(list));
}
else
{
List <ModSysHatProvince> list = new BllSysHatProvince().QueryToAll().Where(p => p.Code == code).ToList();
WriteJsonToPage(JsonHelper.ToJson(list));
}
}
public JsonResult GetArea(string companyId)
{
Hashtable table = new Hashtable();
DataSet ds = new BllSysHatProvince().GetArea(companyId);
if (ds.Tables[0].Rows.Count > 0)
{
table.Add("Province", ds.Tables[0].Rows[0]["Province"].ToString());
table.Add("CityId", ds.Tables[0].Rows[0]["CityId"].ToString());
table.Add("AreaId", ds.Tables[0].Rows[0]["AreaId"].ToString());
table.Add("ProvinceName", ds.Tables[0].Rows[0]["ProvinceName"].ToString());
table.Add("CityName", ds.Tables[0].Rows[0]["CityName"].ToString());
table.Add("AreaName", ds.Tables[0].Rows[0]["AreaName"].ToString());
}
return(Json(new { data = table }, JsonRequestBehavior.AllowGet));
}
