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)); }