62,266
社区成员
发帖
与我相关
我的任务
分享<asp:TreeView ID="TreeView1" runat="server" ImageSet="XPFileExplorer" NodeIndent="15"
ontreenodepopulate="TreeView1_TreeNodePopulate" MaxDataBindDepth="5"
ExpandDepth="2" Font-Bold="True" onselectednodechanged="tree_select">
<ParentNodeStyle Font-Bold="False" />
<HoverNodeStyle Font-Underline="True" ForeColor="#6666AA" />
<SelectedNodeStyle Font-Underline="False" HorizontalPadding="0px"
VerticalPadding="0px" BackColor="#B5B5B5" />
<Nodes>
<asp:TreeNode Value="电机事业部" PopulateOnDemand="True" Text="电机事业部" SelectAction="Expand"></asp:TreeNode>
</Nodes>
<NodeStyle Font-Names="Tahoma" Font-Size="8pt" ForeColor="Black"
HorizontalPadding="2px" NodeSpacing="0px" VerticalPadding="2px" />
</asp:TreeView> protected void TreeView1_TreeNodePopulate(object sender, TreeNodeEventArgs e)
{
if (e.Node.ChildNodes.Count == 0)
{
switch (e.Node.Depth)
{
case 0:
Populateyear(e.Node);
break;
case 1:
Populatemonth(e.Node);
break;
case 2:
Populatedw(e.Node);
break;
case 3:
Populateweek(e.Node);
break;
}
}
}
//年节点
void Populateyear(TreeNode node)
{
string sqlQuery = "Select distinct year(time) time From zhoubao order by time desc ";
DataSet resultSet;
PMS.Common.DataAccess data = new PMS.Common.DataAccess();
resultSet = data.CreateDataSet(sqlQuery);
if (resultSet.Tables.Count > 0)
{
foreach (DataRow row in resultSet.Tables[0].Rows)
{
TreeNode NewNode = new TreeNode();
NewNode.Value = row["time"].ToString().Trim();
NewNode.Text = row["time"].ToString().Trim() + "年";
NewNode.PopulateOnDemand = true;
NewNode.SelectAction = TreeNodeSelectAction.Expand;
node.ChildNodes.Add(NewNode);
}
}
}
//月节点
void Populatemonth(TreeNode node)
{
string sqlQuery = "Select distinct month(time) time From zhoubao Where year(time)='" + node.Value + "' order by time desc";
PMS.Common.DataAccess data = new PMS.Common.DataAccess();
DataSet ResultSet = data.CreateDataSet(sqlQuery);
if (ResultSet.Tables.Count > 0)
{
foreach (DataRow row in ResultSet.Tables[0].Rows)
{
TreeNode NewNode = new
TreeNode(row["time"].ToString() + "月", "year(time)='" + node.Value + "' and month(time)='" + row["time"].ToString().Trim() + "' ");
//TreeNode(row["time"].ToString(),row["time"].ToString());
//NewNode.Text = row["bz"].ToString().Trim();
//NewNode.Value = "Select users From users Where dw='"+node.Value+"' and bz='"+row["bz"].ToString().Trim()+"' ";
NewNode.PopulateOnDemand = true;
NewNode.SelectAction = TreeNodeSelectAction.Expand;
node.ChildNodes.Add(NewNode);
}
}
}
//部门节点
void Populatedw(TreeNode node)
{
string sqlQuery = "select distinct dw dw from zhoubao";
PMS.Common.DataAccess data = new PMS.Common.DataAccess();
DataSet ResultSet = data.CreateDataSet(sqlQuery);
if (ResultSet.Tables.Count > 0)
{
foreach (DataRow row in ResultSet.Tables[0].Rows)
{
//string url = "~/admin/sd.aspx?Users=" + row["users"].ToString().Trim() + "";
string str = "" + node.Value + " and dw='" + row["dw"].ToString().Trim() + "'";
TreeNode NewNode = new
//TreeNode(row["dw"].ToString(), "", "", "" + url + "", "");
TreeNode(row["dw"].ToString(), "" + node.Value + " and dw='" + row["dw"].ToString().Trim() + "'");
NewNode.PopulateOnDemand = true;
NewNode.SelectAction = TreeNodeSelectAction.Expand;
node.ChildNodes.Add(NewNode);
}
}
}
//周节点
void Populateweek(TreeNode node)
{
string sqlQuery = node.Value;
sqlQuery = "select week,lr from zhoubao where " + node.Value + " order by id";
PMS.Common.DataAccess data = new PMS.Common.DataAccess();
DataSet ResultSet = data.CreateDataSet(sqlQuery);
if (ResultSet.Tables.Count > 0)
{
foreach (DataRow row in ResultSet.Tables[0].Rows)
{
string url = "~/zhoubao.aspx?lr=" + row["lr"].ToString().Trim() + "";
TreeNode NewNode = new
//TreeNode(row["week"].ToString(),row["lr"].ToString().Trim(), "", "" + url + "", "");
TreeNode(row["week"].ToString(), row["lr"].ToString().Trim());
NewNode.PopulateOnDemand = false;
NewNode.SelectAction = TreeNodeSelectAction.Select;
node.ChildNodes.Add(NewNode);
}
}
}
protected void tree_select(object sender, EventArgs e)
{
string path1 = TreeView1.SelectedNode.Value.ToString().Trim();
path = "/zhoubaoflash/" + path1 + "";
}