readsubject.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 System.IO;
using lalablog;
public partial class readSubject : System.Web.UI.Page
{
    SqlDataReader dr;

    int userid,subjectid=0, pagesize = 10;

    protected void Page_PreInit()
    {
        if (Request.QueryString["userid"] != null)
            this.userid = Convert.ToInt32(Request.QueryString["userid"]);

        LoadTitle();
    }

    private void LoadTitle()
    {
        bloguser newuser = new bloguser(this.userid);
        string[] setting = new string[5];
        setting = newuser.getSetting();

        this.pagesize = Convert.ToInt32(setting[2]);

        theme usertheme = new theme(Convert.ToInt32(setting[0]));
        Page.Theme = usertheme.getName();
        if (Page.Theme == "")
        {
            string themePath = Server.MapPath("~/app_themes/");
            themePath += "\\usertheme" + this.userid;
            if (Directory.Exists(themePath))
                Page.Theme = "usertheme" + this.userid;
            else
                Page.Theme = "pusu";
        }

        Page.Title = setting[1] + "的日志";
        toptitle.InnerHtml = "<a id=topurl href=read.aspx?userid=" + userid + " > " + Page.Title + "</a>";
    }
    
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.QueryString["subjectid"] != null)
            subjectid = Convert.ToInt32(Request.QueryString["subjectid"]);
        else subjectid = 1;

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

    //根据用户的userid，和当前状态视图中存储的页码 读取指定条数的数据记录并显示
    private string readblog(int pageindex)
    {
        string strconn = ConfigurationManager.ConnectionStrings["dsn"].ToString();

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

        cm.Parameters.Add("@userid", SqlDbType.Int);
        cm.Parameters.Add("@subjectid", SqlDbType.Int);

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

        cm.Parameters["@userid"].Value = this.userid;
        cm.Parameters["@subjectid"].Value = this.subjectid;
        cm.Parameters["@PageSize"].Value = pagesize;
        cm.Parameters["@PageIndex"].Value = pageindex;
        if (Session["userid"] != null)
        {
            if (Session["userid"].ToString() == this.userid.ToString())
            {
                cm.Parameters.Add("@text_folder", SqlDbType.Int);
                cm.Parameters["@text_folder"].Value = 5;
            }
        }

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

        }
        catch (SqlException ex)
        {
            return ex.Message;
        }
        finally
        {
            cn.Close();
        }
    }
    //输出html文本，输出的是一个表格，输出到了预先定义的span （message） 中
    private void displayData()
    {
        string data = "";

        while (this.dr.Read())
        {
            int blogid = Convert.ToInt32(dr["blogid"].ToString());
            data += "<div class='readblog'>";
            data += "<div class='title'>" + dr["title"].ToString() + "</div>";
            data += "<div class='head'>作者:" + dr["username"].ToString();
            data += "发表日期:" + dr["add_date"].ToString() + "</div>";
            data += "<div class='content'>" + dr["content"].ToString() + "</div>";
            data += "<br><br><a href=article.aspx?userid=" + userid + "&blogid=" + blogid + ">阅读全文……</a>";
            data += "<div class='foot'>阅读次数[" + dr["read_count"].ToString() + "]";
            data += "回复次数[" + dr["reply_count"].ToString() + "]</div>";
            data += "</div><p>";


        }
        mainblog.InnerHtml = data;
    }

    //生成总页数，根据每页显示多少条记录得出页数
    private void pageNavigate()
    {
        string mysql = "select count(blogid) from blog where subjectid="+subjectid+" and userid=" + userid;
        pageHtml p1 = new pageHtml(mysql);
        ViewState["sumPage"] = p1.pageNavigate(pagesize);
        spage.InnerText = 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);
    }

    private void loadLeft()
    {
        String path = Server.MapPath("~/user/face/");
        path = path + userid + ".jpg";
        if (File.Exists(path))
            Image1.ImageUrl = "~/user/face/" + userid + ".jpg";
        else
            Image1.Visible = false;
        myfunc m1 = new myfunc(this.userid);

        intro.InnerHtml = m1.loadIntro();
        subject.InnerHtml = m1.loadSubject();
        newblog.InnerHtml = m1.loadNewBlog();
        newreply.InnerHtml = m1.loadNewReply();
        friendlink.InnerHtml = m1.loadFriendLink();
        userinfo.InnerHtml = m1.loadUserInfo();
    }
}