62,254
社区成员
发帖
与我相关
我的任务
分享

//这个是cid 为2的也就是各省直辖市的链接
<asp:Repeater ID="Psite2" runat="server">
<HeaderTemplate>
<table border="0" cellspacing="0" cellpadding="0" class="policy_list">
<tr style="color: Green" align="left">
各省、直辖市、自治区
</tr>
</HeaderTemplate>
<ItemTemplate>
<%#Container.ItemIndex==0?" <tr>":""%>
<td>
<%#string.Format("<a href={0} target='_blank'>{1}</a>",Eval("url"),Eval("name")) %>
</td>
<%#(Container.ItemIndex + 1) % 5 == 0 ? " </tr>" : ""%>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
<webdiyer:AspNetPager ID="AspNetPager1_2" runat="server" Width="100%" UrlPaging="true"
ShowPageIndexBox="Always" PageIndexBoxType="DropDownList" TextBeforePageIndexBox="跳转到页面: "
HorizontalAlign="right" PageSize="10" AlwaysShow="true" OnPageChanged="AspNetPager1_2_PageChanged">
</webdiyer:AspNetPager>
CREATE PROCEDURE P_GetPagedProfessinalSite2
(
@startIndex INT,
@endIndex INT
)
AS
SET NOCOUNT ON
DECLARE @indextable TABLE(id int identity(1,1),nid int)
set rowcount @endIndex
insert into @indextable(nid) SELECT [lid] FROM [xskj_links] WHERE [Fid]=1 and [cid]=2 order by [lid] DESC
SELECT [lid], [name],[url], [fid], [show],[cid]
FROM [xskj_links] A inner join @indextable t on A.[lid]=t.[nid]
WHERE t.[id] between @startIndex and @endIndex and A.[Fid]=1 and A.[cid]=2 order by a.[lid] desc
set nocount off
RETURN
GO
void bindData_2()
{
Psite2.DataSource = SqlHelper.ExecuteReader(SqlStr.xskjConnectString, CommandType.StoredProcedure, "P_GetPagedProfessinalSite2",
new SqlParameter("@startIndex", AspNetPager1_2.StartRecordIndex),
new SqlParameter("@endIndex", AspNetPager1_2.EndRecordIndex));
Psite2.DataBind();
}
protected void AspNetPager1_2_PageChanged(object sender, EventArgs e)
{
bindData_2();
}
int total_2 = (int)SqlHelper.ExecuteScalar(SqlStr.xskjConnectString, CommandType.StoredProcedure, "P_GetProfessinalSiteNumber2");
AspNetPager1_2.RecordCount = total;
