62,072
社区成员
发帖
与我相关
我的任务
分享
public DataSet GetList(string strWhere)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select [gid],cname,GongCheng.gclass,[gname],[gbody],[gtime],[gflag] FROM GongCheng ");
strSql.Append(" left join dbo.gclass on GongCheng.Gclass=Gclass.Cid ");
if(strWhere.Trim()!="")
{
strSql.Append(" where "+strWhere);
}
return SqlHelper.ExecuteDataset(SqlHelper.CONNSTR,CommandType.Text,strSql.ToString());
}
protected void Gclass_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
DAL_GongCheng dal=new DAL_GongCheng();
Repeater rpColumnNews = (Repeater)e.Item.FindControl("GCList");
Label gid = (Label)e.Item.FindControl("cid");
DataSet ds = dal.GetList("gclass=" + gid.Text);
rpColumnNews.DataSource = ds;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Response.Write(ds.Tables[0].Rows[i][2].ToString());
}
rpColumnNews.DataBind();
}
<asp:Repeater ID="Gclass" runat="server" OnItemDataBound="Gclass_ItemDataBound">
<ItemTemplate>
<div class="listbox">
<div class="gongctitle"><span id="xq"><%#Eval("cname") %></span></div>
<img src="userfiles/<%#Eval("imgurl") %>" alt="<%#Eval("cname") %>" />
<asp:Label ID="cid" runat="server" Text='<%#Eval("cid")%>' Visible="false"></asp:Label>
<asp:Repeater id="GCList" runat="server">
<ItemTemplate>
<li><a href='Detalis.aspx?gid=<%#Eval("gid") %>'><%#Eval("gname") %></a></li>
</ItemTemplate>
<FooterTemplate>
<li class="more"><a href='projectmore.aspx?id=<%#Eval("gclass") %>'>更多>></a></li></div>
</FooterTemplate> </asp:Repeater>
</ItemTemplate>
</asp:Repeater>
<li class="more"><a href='projectmore.aspx?id=<%#Eval("gclass") %>'><%#Eval("gclass") %>更多>></a></li></div>
<div class="listbox">
<div class="gongctitle"><span id="xq">小区 </span></div>
<img src="userfiles/200931751303224.bmp" alt="小区 " />
<li><a href='Detalis.aspx?gid=1'>asdfatest</a></li>
<li><a href='Detalis.aspx?gid=4'>asdfasdfaa2342</a></li>
<li><a href='Detalis.aspx?gid=7'>添加工程案例添加工程案例添加工程案例</a></li>
<li><a href='Detalis.aspx?gid=8'>添加工程案例添加工程案例添加工程案例</a></li>
<li class="more"><a href='projectmore.aspx?id='>更多>></a></li></div>
其中一段
<a href='<%# "projectmore.aspx?id="+ Eval("gclass").ToString() %>'>