<%@ Page Language="C#" MasterPageFile="MasterPage.master" AutoEventWireup="true" CodeFile="ZpList.aspx.cs" Inherits="ZpList" Title="无标题页" %>
<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>
<asp:Content ID="Content1" ContentPlaceHolderID="headHide" Runat="Server">
<link href="css/list.css" rel="stylesheet" type="text/css" />
<link href="css/css.css" rel="stylesheet" type="text/css" />
<script type="text/javascript">
function ClickDel(vid)
{
if(confirm("确定要删除吗?"))
{
window.location.href="ZpDel.aspx?id="+vid;
}
}
</script>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentHide" Runat="Server">
<div class="main">
<h3>企业招聘列表</h3>
<div>
<table width="100%" cellpadding="10px" cellspacing="2px">
<tr style="height:20px"><td><h4>招聘职位</h4></td><td><h4>招聘人数</h4></td><td><h4>发布时间</h4></td><td><h4>操作</h4></td></tr>
<asp:Repeater ID="RepList" runat="server">
<ItemTemplate>
<tr style="height:20px"><td><%# GetLb(Eval("PositionTitle").ToString())%> -> <%# GetLb(Eval("PositionTitle1").ToString())%></td><td><%# Eval("PeopleNumber")%></td><td><%# Convert.ToDateTime(Eval("PostDate")).ToShortDateString()%></td><td><a href="ZpEdit.aspx?id=<%#Eval("id")%>">编辑</a> | <a οnclick="ClickDel(<%#Eval("id")%>)">删除</a></td></tr>
</ItemTemplate>
</asp:Repeater>
</table>
</div>
<div style="clear:both"></div>
<div style="height:20px"></div>
<webdiyer:AspNetPager ID="AspNetPager1" runat="server" AlwaysShow="True" Font-Size="12px"
PageSize="15" CustomInfoHTML="第%CurrentPageIndex%页,共%PageCount%页,每页%PageSize%条"
ShowPageIndex="false" PageIndexBoxType="DropDownList" OnPageChanged="AspNetPager1_PageChanged"
ShowCustomInfoSection="Left" ShowPageIndexBox="Always" NextPageText="下一页"
PrevPageText="上一页" ShowNavigationToolTip="false" SubmitButtonText="Go"
TextAfterPageIndexBox="页" TextBeforePageIndexBox="转到" FirstPageText="首页"
LastPageText="尾页">
</webdiyer:AspNetPager>
<div style="clear:both"></div>
</div>
</asp:Content>
public partial class ZpList : System.Web.UI.Page
{
protected int zpCount;//总记录数
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
zpCount = ZpInfoBLL.Countzp();//总记录
GetList();//分页绑定
}
}
protected void GetList()
{
if (zpCount != 0)
{
if (Convert.ToString(Request.QueryString["IntPageIndex"]) != null)
{
AspNetPager1.CurrentPageIndex = Convert.ToInt32(this.Request["IntPageIndex"].ToString());//当前页
}
AspNetPager1.RecordCount = zpCount; //总记录
this.RepList.DataSource = ZpInfoBLL.GetZpList( AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize);
this.RepList.DataBind();
}
}
protected void AspNetPager1_PageChanged(object sender, EventArgs e)
{
GetList();
}
}
类:
/// <summary>
/// 分页记录总数
/// </summary>
/// <returns></returns>
public static int CountLb()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(*) from lb");
Object[] objectvalues = new Object[] {};
return Convert.ToInt32(SqlHelper.ExecuteScalar(strSql.ToString(), objectvalues));
}
/// <summary>
/// 分页
/// </summary>
/// <param name="UserId"></param>
/// <param name="startRecord"></param>
/// <param name="maxrecords"></param>
/// <returns></returns>
public static DataSet GetLbList(int startRecord, int maxrecords)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select *");
strSql.Append(" from lb");
strSql.Append(" order by id desc");
Object[] objectvalues = new Object[] { };
return SqlHelper.Fill(startRecord, maxrecords, "aa", strSql.ToString(), objectvalues);
}