OATest/New/NewsInfo.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 NS_DBOP;
using System.Data.SqlClient;

public partial class sysManage_NewsInfo : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if(!Page.IsPostBack)
        {
           
            DataSet ds = new DBoperate().ExecuteQuery("select * from NewsType", 0, 0, "table1");
            foreach (DataRow dr in ds.Tables["table1"].Rows)
            {
                this.drpNewType.Items.Add(new ListItem(dr["Type"].ToString(), dr["NTID"].ToString()));
            }
            this.drpNewType.Items.Insert(0, "全部");
            Bind();
        }
        
    }

    public void Bind()
    {
        //string strSql = "select News.Title,NewsType.Type,News.Pubdate from News,NewsType where News.TypeId=NewsType.NTID";
        DataSet ds = new DBoperate().ExecuteQuery("select * from News", 0, 0, "news");
        this.lblCount.Text = ds.Tables[0].Rows.Count.ToString();
        DataView dv = ds.Tables[0].DefaultView;
        PagedDataSource pds = new PagedDataSource();
        AspNetPager1.RecordCount = dv.Count;
        pds.DataSource = dv;
        pds.AllowPaging = true;
        pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
        pds.PageSize = AspNetPager1.PageSize;
        this.GridView1.DataSource = pds;
        this.GridView1.DataBind();
    }

protected void  btnSel_Click(object sender, System.EventArgs e)
{
    
    string title = this.txtTitle.Text.Trim();
    DateTime Fd = Convert.ToDateTime(this.TextBox1.Text);
    DateTime Ed = Convert.ToDateTime(this.TextBox2.Text);
    string strSql = "select News from News where 1=1";
    string type = this.drpNewType.SelectedItem.Value.ToString();
    if (this.drpNewType.SelectedItem.Text=="全部")
    {
        if (Fd.Equals("") && Ed.Equals(""))
        {
            this.RequiredFieldValidator1.Enabled = false;