62,041
社区成员
发帖
与我相关
我的任务
分享
#region 省级目录树形成
/************************省级用户目录树的形成开始*******************/
/// <summary>
/// 省级用户添加根节点
/// </summary>
private void AddProvinceRoot()
{
DataSet ds = dm.getMenuByLevel(ROOT.ToString());
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
TreeNode NewNode = new TreeNode();
string strSQL = "select * from V_AHSK_SK where 所在市 = '" + ds.Tables[0].Rows[i]["Menu_Name"] + "' ";
DataSet ds2 = dm2.getsql(strSQL);
NewNode.Text = "<FONT face='微软雅黑' color='white' size='2'>" + ds.Tables[0].Rows[i]["Menu_Name"].ToString() + "</FONT><font face='微软雅黑' color='red' size='2'>共(" + ds2.Tables[0].Rows.Count + ")座</font>";
TreeView1.Nodes.Add(NewNode);
NewNode.Expanded = false;
}
}
/// <summary>
/// 省级用户添加子节点
/// </summary>
private void AddProvinceSubMenu()
{
DataSet ds;
ds = dm.getMenuByLevel(ROOT.ToString());
for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
{
InitTreeProvinceChildNode(TreeView1.Nodes[j], ds.Tables[0].Rows[j]["Menu_ID"].ToString());
}
}
/// <summary>
/// 省级用户的初始化TreeView 的 ChildNodes
/// </summary>
private void InitTreeProvinceChildNode(TreeNode PNode, string classParentID)
{
DataSet ds, ds2;
ds = dm.getMenuByLevel(classParentID);
DataView dataView = new DataView();
dataView = ds.Tables[0].DefaultView;
foreach (DataRowView drv in dataView)
{
string id = drv["Menu_ID"].ToString();
string name = drv["Menu_Name"].ToString();
TreeNode NewNode = new TreeNode();
//将所属县的水库列表添加到各个县的节点下面
ds2 = dm.getSKByLevel(name);
NewNode.Text = "<FONT face='微软雅黑' color='white' size='2'>" + name + "</FONT><font face='微软雅黑' color='red' size='2'>(" + ds2.Tables[0].Rows.Count + ")座</font>";
foreach (DataRowView drv2 in ds2.Tables[0].DefaultView)
{
string id2 = drv2["水库ID"].ToString();
string name2 = drv2["水库名称"].ToString();
TreeNode SubNode = new TreeNode();
SubNode.Text = "<FONT face='微软雅黑' color='white' size='2'>" + name2 + "</FONT>";
SubNode.NavigateUrl = "center.aspx?SKID=" + drv2["水库ID"].ToString();
SubNode.Target = "center";
NewNode.ChildNodes.Add(SubNode);
SubNode.Expanded = false;
}
PNode.ChildNodes.Add(NewNode);
InitTreeProvinceChildNode(NewNode, id);
}
}
/************************省级用户目录树的形成开始*******************/