62,047
社区成员
发帖
与我相关
我的任务
分享
/****** Object: Table [dbo].[DJ_Qxmoban] Script Date: 11/13/2011 16:44:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DJ_Qxmoban](
[PID] [int] IDENTITY(1,1) NOT NULL,
[ProjectName] [nvarchar](50) NOT NULL,
[ProjectType] [int] NOT NULL,
[ProjectOrder] [int] NOT NULL,
CONSTRAINT [PK_DJ_POWER] PRIMARY KEY CLUSTERED
(
[PID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Default [DF_DJ_Qxmoban_ProjectType] Script Date: 11/13/2011 16:44:38 ******/
ALTER TABLE [dbo].[DJ_Qxmoban] ADD CONSTRAINT [DF_DJ_Qxmoban_ProjectType] DEFAULT ((0)) FOR [ProjectType]
GO
/****** Object: Default [DF_DJ_Qxmoban_ProjectOrder] Script Date: 11/13/2011 16:44:38 ******/
ALTER TABLE [dbo].[DJ_Qxmoban] ADD CONSTRAINT [DF_DJ_Qxmoban_ProjectOrder] DEFAULT ((0)) FOR [ProjectOrder]
GO
INSERT [dbo].[DJ_Qxmoban] ([PID], [ProjectName], [ProjectType], [ProjectOrder]) VALUES (83, N'文章管理', 0, 0)
INSERT [dbo].[DJ_Qxmoban] ([PID], [ProjectName], [ProjectType], [ProjectOrder]) VALUES (84, N'文章添加', 83, 1)
INSERT [dbo].[DJ_Qxmoban] ([PID], [ProjectName], [ProjectType], [ProjectOrder]) VALUES (85, N'管理', 0, 1)
INSERT [dbo].[DJ_Qxmoban] ([PID], [ProjectName], [ProjectType], [ProjectOrder]) VALUES (86, N'管理1', 85, 1)
INSERT [dbo].[DJ_Qxmoban] ([PID], [ProjectName], [ProjectType], [ProjectOrder]) VALUES (87, N'333', 1, 0)
INSERT [dbo].[DJ_Qxmoban] ([PID], [ProjectName], [ProjectType], [ProjectOrder]) VALUES (88, N'文章删除', 83, 2)
INSERT [dbo].[DJ_Qxmoban] ([PID], [ProjectName], [ProjectType], [ProjectOrder]) VALUES (89, N'新闻管理', 0, 2)
INSERT [dbo].[DJ_Qxmoban] ([PID], [ProjectName], [ProjectType], [ProjectOrder]) VALUES (90, N'新闻编辑', 89, 1)
INSERT [dbo].[DJ_Qxmoban] ([PID], [ProjectName], [ProjectType], [ProjectOrder]) VALUES (92, N'新闻添加', 89, 2)
INSERT [dbo].[DJ_Qxmoban] ([PID], [ProjectName], [ProjectType], [ProjectOrder]) VALUES (93, N'新闻删除', 89, 3)
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>
<!DOCTYPE html>
<html>
<head runat="server">
<title></title>
<style type="text/css">
ul,li{ list-style-type:none; line-height:24px;}
.ulrr{ float:left; width:150px;}
.ulrr li{ float:left; margin-left:5px; width: 32px; }
.tt{ width:150px; float:left; overflow:hidden;}
dl { width: 100px; float: left; overflow: hidden; }
dt { float: left; clear: both; }
dd { float: left; }
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<ul class="tt">
<asp:Repeater ID="Repeater1" runat="server"
onitemdatabound="Repeater1_ItemDataBound">
<ItemTemplate>
<li><%#Eval("ProjectName")%>
<asp:Literal ID="ltId" Text='<%#Eval("PId") %>' Visible="false" runat="server"></asp:Literal>
<ul class="ulrr">
<asp:Repeater ID="Repeater2" runat="server">
<ItemTemplate>
<li><%#Eval("ProjectName")%></li>
</ItemTemplate>
</asp:Repeater>
</ul>
</li>
</ItemTemplate>
</asp:Repeater>
</ul>
</div>
</form>
</body>
</html>
protected void Page_Load(object sender, EventArgs e)
{
Bind();
}
private void Bind()
{
//第一次绑定ProjectType=0的数据
DataTable dt = new DataTable();
Repeater1.DataSource = dt;
Repeater1.DataBind();
}
protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
Literal ltId = (Literal)e.Item.FindControl("ltId");//找到绑定ID的控件
Repeater rep2 = (Repeater)e.Item.FindControl("Repeater2");//找到Repeater2
//第二次绑定
//获取ProjectType=ltId.Text 的数据
DataTable dt = new DataTable();
Repeater1.DataSource = dt;
Repeater1.DataBind();
}
<%#(int)Eval("IsOK") == 1 ? "testok" : "hid"%>
<div>
<%if(HasPower){%><a href="Add.aspx?id=<%=id%>">修改</a><% }%>
<a href="List.aspx">返回</a>
</div>
<%#gettype(Eval("type"))%>