foreach (TreeNode node in tnc)
{
if (node.ChildNodes.Count != 0)
{
GetAllNodeText(node.ChildNodes);
SqlCommand com = new SqlCommand();
com.Connection = con;
string sqlQuery = "select name from MonitorInfo where status = 0 or online =2";
SqlDataAdapter Adp = new SqlDataAdapter(sqlQuery, con);
DataSet dts = new DataSet();
Adp.Fill(dts, "MonitorInfo");
string meterName;
for (int i = 0; i < dts.Tables[0].Rows.Count; i++)
{
meterName = dts.Tables[0].Rows[i]["name"].ToString();
if (meterName == node.Text)
{
node.ImageUrl = "Images/left2.gif";
}
else
{
switch (node.Depth)
{
case 0:
node.ImageUrl = "Images/icon/base.gif"; //~/Images/icon/base.gif
break;
case 1:
node.ImageUrl = "Images/icon/folder.gif";
break;
case 2:
node.ImageUrl = "Images/right.gif";
break;
default:
node.ImageUrl = "Images/right.gif";
break;
}
}
}
}
switch (node.Depth)
{
case 0:
node.ImageUrl = "Images/icon/base.gif"; //~/Images/icon/base.gif
break;
case 1:
node.ImageUrl = "Images/icon/folder.gif";
break;
case 2:
node.ImageUrl = "Images/right.gif";
break;
default:
node.ImageUrl = "Images/right.gif";
break;
}
{
if (node.ChildNodes.Count != 0)
{
GetAllNodeText(node.ChildNodes);
SqlCommand com = new SqlCommand();
com.Connection = con;
string sqlQuery = "select name from MonitorInfo where status = 0 or online =2";
SqlDataAdapter Adp = new SqlDataAdapter(sqlQuery, con);
DataSet dts = new DataSet();
Adp.Fill(dts, "MonitorInfo");
string meterName;
for (int i = 0; i < dts.Tables[0].Rows.Count; i++)
{
meterName = dts.Tables[0].Rows[i]["name"].ToString();
if (meterName == node.Text)
{
node.ImageUrl = "Images/left2.gif";
}
else
{
switch (node.Depth)
{
case 0:
node.ImageUrl = "Images/icon/base.gif"; //~/Images/icon/base.gif
break;
case 1:
node.ImageUrl = "Images/icon/folder.gif";
break;
case 2:
node.ImageUrl = "Images/right.gif";
break;
default:
node.ImageUrl = "Images/right.gif";
break;
}
}
}
}
switch (node.Depth)
{
case 0:
node.ImageUrl = "Images/icon/base.gif"; //~/Images/icon/base.gif
break;
case 1:
node.ImageUrl = "Images/icon/folder.gif";
break;
case 2:
node.ImageUrl = "Images/right.gif";
break;
default:
node.ImageUrl = "Images/right.gif";
break;
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货