ExamList.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class ExamList : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!this.IsPostBack)
        {
            if (Request["keywords"] != null)
            {
                HiddenField1.Value = " and mingcheng like '%" + Request["keywords"].ToString() + "%'";
                searchtxt.Value = Request["keywords"].ToString();
            }
            bind();
        }
    }

    void bind()
    {
        AspNetPager1.RecordCount = int.Parse(DBUtility.DbHelperSQL.GetSingle("select count(*) from gangwei where flag = '审核通过' "+HiddenField1.Value).ToString());
        Literal1.Text = AspNetPager1.RecordCount.ToString();
        Repeater1.DataSource = DBUtility.DbHelperSQL.Query("select *,(select gongsimingcheng from gongsi where gongsi.ID = gangwei.gongsiID) as gsname,(select pic from gongsi where gongsi.ID = gangwei.gongsiID) as gspic from gangwei where flag = '审核通过' "+HiddenField1.Value+" order by Times desc", AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize).Tables[0];
        Repeater1.DataBind();
    }
    protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
    {
        AspNetPager1.CurrentPageIndex = e.NewPageIndex;
        bind();
    }

}