/// <summary>
/// 根据查询获取树形递归(城市地区商圈模块)
/// </summary>
/// <param name="parDs"></param>
/// <returns></returns>
public List <jsonSysBusinessCircle> GetJsonTree(DataSet parDs)
{
List <jsonSysBusinessCircle> list = new List <jsonSysBusinessCircle>();
if (parDs != null)
{
for (int b = 0; b < parDs.Tables[0].Rows.Count; b++)
{
jsonSysBusinessCircle model = new jsonSysBusinessCircle();
model.id = parDs.Tables[0].Rows[b]["id"].ToString();
model.text = parDs.Tables[0].Rows[b]["text"].ToString();
model.Code = parDs.Tables[0].Rows[b]["Code"].ToString();
model.expanded = true;
model.leaf = true;
model.children = null;
list.Add(model);
}
}
return(list);
}
public void SearchProvinceByTree()
{
string name = (Request["name"] == null ? "" : Request["name"]); //查询过滤条件
string where = "Status=" + (int)StatusEnum.正常 + " and Type=" + Request["Type"];
if (!string.IsNullOrEmpty(name.Trim()))
{
where += "(Name like '%" + name.Trim() + "%')";
}
DataTable mytab = new BllSysDirc().GetTreeList(where).Tables[0]; //获取所有树
List <jsonSysBusinessCircle> list = new List <jsonSysBusinessCircle>();
if (mytab != null)
{
for (int b = 0; b < mytab.Rows.Count; b++)
{
jsonSysBusinessCircle model = new jsonSysBusinessCircle();
model.id = mytab.Rows[b]["id"].ToString();
model.text = mytab.Rows[b]["text"].ToString();
model.Code = "";
model.expanded = true;
model.leaf = true;
model.children = null;
list.Add(model);
}
}
list.Insert(0, new jsonSysBusinessCircle()
{
id = "0",
text = "查询全部",
expanded = true,
leaf = true,
children = null,
});
WriteJsonToPage(new JavaScriptSerializer().Serialize(list));
}
