User/newslist.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using LYF.SqlHelper;

public partial class User_newslist : System.Web.UI.Page
{
    private SqlHelper shp = new SqlHelper("XS");
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            LoadBind();
        }
    }
    private void LoadBind()
    {
        int pageno = this.NewsPage.CurrentPageIndex;
        int pagesize = this.NewsPage.PageSize;
        string title = this.titleTB.Value;
        string begindate = this.BtimeTB.Value;
        string enddate = this.EtimeTB.Value;
        string sqlstr = "select top "+pagesize+" id,title,date from XS_News where 1=1";
        string sqlstr1 = "select top " + ((pageno - 1) * pagesize) + " id from XS_News where 1=1";
        string selcount="select count(*) from XS_News where 1=1";
        if (title != "")
        {
            sqlstr += " and title like '" + "%" + title + "%" + "'";
            sqlstr1 += " and title like '" + "%" + title + "%" + "'";
            selcount += " and title like '" + "%" + title + "%" + "'";
        }
        if (begindate != "")
        {
            sqlstr += " and date>='" + begindate + "'";
            sqlstr1 += " and date>='" + begindate + "'";
            selcount += " and date>='" + begindate + "'";
        }
        if (enddate != "")
        {
            sqlstr += " and date<='" + enddate + "'";
            sqlstr1 += " and date<='" + enddate + "'";
            selcount += " and date<='" + enddate + "'";
        }
        string sql = sqlstr + " and id not in(" + sqlstr1 + " order by id desc)order by id desc";
        this.NewsRP.DataSource = shp.GetTable(sql, CommandType.Text, null);
        this.NewsRP.DataBind();
        int count = 0;
        using (SqlDataReader dr = shp.ExecuteReader(selcount)) 
        {
            if (dr.Read()) 
            {
                count = Int32.Parse(dr[0].ToString());