adminblog.aspx.cs

本程序基于 asp.net 2.0 +sql server 2

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 lalablog;
public partial class admin_adminBlog : System.Web.UI.Page
{
    SqlDataReader dr;
    string title, add_date;
    int pagesize = 10;

    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["admin"] == null)
            Response.Redirect("adminLogin.aspx");

        if (!IsPostBack)
        {
            pageNavigate();
            readblog(1);
            ViewState["currentPage"] = 1;
        }
    }


    private string readblog(int pageindex)
    {
        string strconn = ConfigurationManager.ConnectionStrings["dsn"].ToString();

        SqlConnection cn = new SqlConnection(strconn);
        cn.Open();
        SqlCommand cm = new SqlCommand("pageManageBlogAdmin", cn);
        cm.CommandType = CommandType.StoredProcedure;

        cm.Parameters.Add("@PageSize", SqlDbType.Int);
        cm.Parameters.Add("@PageIndex", SqlDbType.Int);

        cm.Parameters["@PageSize"].Value = pagesize;
        cm.Parameters["@PageIndex"].Value = pageindex;

        try
        {
            this.dr = cm.ExecuteReader();
            displayData();
            ViewState["currentPage"] = pageindex;
            lb_current_page.Text = pageindex.ToString();
            return "success";

        }
        catch (SqlException ex)
        {
            return ex.Message;
        }
        finally
        {
            cn.Close();
        }
    }
    private void displayData()
    {
        string head, data = "";
        head = "<table><tr class=firstrow>";
        head += "<td class=col1>作者</td>";
        head += "<td class=col3>标题</td>";
        head += "<td class=col3>日期</td>";
        head += "<td class=col1>推荐</td>";
        head += "<td class=col1>编辑­</td>";
        head += "<td class=col1>删除</td></tr>";

        while (this.dr.Read())
        {
            int userid, blogid;

            blogid = Convert.ToInt32(dr["blogid"].ToString());
            userid = Convert.ToInt32(dr["userid"].ToString());
            this.title = dr["title"].ToString();
            this.add_date = dr["add_date"].ToString();
            string isgood;
            int read_level=Convert.ToInt32(dr["read_level"].ToString());

            if (read_level==1 )
                isgood = "取消推荐";
            else
                isgood = "推荐";

            data += "<tr class=datarow>";
            data += "<td>" + dr["username"].ToString () + "</td>";
            data += "<td><a href=../article.aspx?userid=" + userid + "&blogid=" + blogid;
            data += ">" + title + "</a></td>";
            data += "<td>" + add_date + "</td>";
            data += "<td><a href=adminBlogGood.aspx?blogid=";
            data += Convert.ToInt32(blogid)+"&read_level="+read_level ;
            data += ">"+isgood +"</a></td>";
            data += "<td><a href=adminBlogEdit.aspx?blogid=";
            data += Convert.ToInt32(blogid) + "&userid=" + userid;
            data += ">编辑­</a></td>";
            data += "<td><a href=adminBlogDelete.aspx?blogid=";
            data += Convert.ToInt32(blogid);
            data += ">删除</a></td>";
            data += "</tr>";
        }
        string all = head + data + "</table>";
        message.InnerHtml = all;
    }

    private void pageNavigate()
    {
        string mysql = "select count(blogid) from blog ";
        pageHtml p1 = new pageHtml(mysql);
        ViewState["sumPage"] = p1.pageNavigate(pagesize);
        lb_sum_page.Text  = ViewState["sumPage"].ToString();
        if (ViewState["sumPage"].ToString() == "1")
            navigator.InnerHtml = "";
   
    }

    protected void tb_goPage_TextChanged(object sender, EventArgs e)
    {
        int x = Convert.ToInt32(tb_goPage.Text);
        if (x < 1) x = 1;
        int sumpage = Convert.ToInt32(ViewState["sumPage"].ToString());
        if (x > sumpage) x = sumpage;
        readblog(x);
    }

    protected void lb_previous_Click(object sender, EventArgs e)
    {
        int x = Convert.ToInt32(ViewState["currentPage"].ToString()) - 1;
        if (x < 1) x = 1;
        readblog(x);
    }

    protected void lb_next_Click(object sender, EventArgs e)
    {
        int x = Convert.ToInt32(ViewState["currentPage"].ToString()) + 1;
        int sumpage = Convert.ToInt32(ViewState["sumPage"].ToString());
        if (x > sumpage) x = sumpage;
        readblog(x);
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string strconn = ConfigurationManager.ConnectionStrings["dsn"].ToString();
        SqlConnection cn = new SqlConnection(strconn);
        cn.Open();

        string sql = " select blogid,blog.userid,username,add_date,title,read_level from blog,users";

        if (dropSearch.SelectedValue == "blogid")
            sql += " where blogid=" + Convert.ToInt32(tbSearch.Text);
        else if (dropSearch.SelectedValue == "title")
            sql += " where title like '%" + Server.HtmlEncode(tbSearch.Text) + "%'";
        sql += " and users.userid=blog.userid order by blogid desc";

        SqlCommand cm = new SqlCommand(sql, cn);

        try
        {
            this.dr = cm.ExecuteReader();
            displayData();
            navigator.InnerHtml = "";
        }
        catch (SqlException ex)
        {
            ;
        }
        finally
        {
            cn.Close();
        }
    }
}