?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;

public partial class user_manage_reply : System.Web.UI.Page
{
    //需要校驗(yàn)reply表中的bloguserid(此篇回復(fù)針對(duì)誰(shuí)的blog)
    //字段是否和 當(dāng)前的 session中的userid 一樣
    //只有一樣，才有刪除權(quán)限

   SqlDataReader dr;
    int   replyid,blogid,userid ,pagesize=10;
    string title, add_date;
    string action;


    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["userid"] == null)
            Response.Redirect("~/user/userLogin.aspx?url="+Server .HtmlEncode(Request .RawUrl ));
        else
            userid = Convert.ToInt32(Session["userid"].ToString());
        
        if (!IsPostBack)
        {
            pageNavigate();
            readReply(1);
            ViewState["currentPage"] = 1;
        }

        if (Request.QueryString["action"] != null)
            this.action = Request.QueryString["action"].ToString();
        if (this.action == "delete")   deleteReply();
    }

    private void deleteReply()
    {
        string strconn = ConfigurationManager.ConnectionStrings["dsn"].ToString();

        SqlConnection cn = new SqlConnection(strconn);
        cn.Open();
        SqlCommand cm = new SqlCommand("delReply", cn);
        cm.CommandType = CommandType.StoredProcedure;
        
        cm.Parameters.Add("@userid", SqlDbType.Int);
        cm.Parameters.Add("@blogid", SqlDbType.Int);
        cm.Parameters.Add("@replyid", SqlDbType.Int);

        cm.Parameters["@userid"].Value = this.userid;
        cm.Parameters["@blogid"].Value = Convert.ToInt32(Request.QueryString["blogid"]);
        cm.Parameters["@replyid"].Value = Convert.ToInt32(Request.QueryString["replyid"]);

        try
        { 
            cm.ExecuteNonQuery();
            Response.Redirect("user_manage_reply.aspx");
        }
        catch (SqlException ex)
        {
            displayJavaMsg(ex.Message);
        }
        finally
        {
            cn.Close();
        }
    }

    //顯示彈出窗口的消息
    private void displayJavaMsg(string str)
    {
        javaMsg.InnerHtml  = "<script type='text/javascript'>alert('" + str + "');</script>";
    }

//生成總頁(yè)數(shù)，根據(jù)每頁(yè)顯示多少條記錄得出頁(yè)數(shù)
    private void pageNavigate()
    {
        string strconn = ConfigurationManager.ConnectionStrings["dsn"].ToString();
        SqlConnection cn = new SqlConnection(strconn);
        cn.Open();

        string mysql = "select count(replyid) from reply where bloguserid="+userid  ;
        SqlCommand cm = new SqlCommand(mysql, cn);

        SqlDataReader sumdr = cm.ExecuteReader();
        if(sumdr.Read ())
        ViewState["sumPage"] = Convert .ToInt32 (sumdr[0].ToString())/pagesize +1;
        lb_sum_page.Text  =ViewState["sumPage"].ToString ();
        cn.Close();
    }

    //根據(jù)用戶的userid，和當(dāng)前狀態(tài)視圖中存儲(chǔ)的頁(yè)碼 讀取指定條數(shù)的數(shù)據(jù)記錄并顯示
    private string readReply(int pageindex)
    {
        string strconn = ConfigurationManager.ConnectionStrings["dsn"].ToString();

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

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

        cm.Parameters["@userid"].Value = this.userid ;
        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();
        }      
    }
    //輸出html文本，輸出的是一個(gè)表格，輸出到了預(yù)先定義的span （message） 中
    private void displayData()
    {
        string head,data="";
        head  = "<table><tr class=firstrow>";
        head += "<td class=col1>編號(hào)</td>";
        head += "<td class=col4>標(biāo)題</td>";
        head += "<td class=col3>日期</td>";
        head += "<td class=col1>修改</td>";
        head += "<td class=col1>刪除</td></tr>";

        while  (this.dr.Read())
        {
            this.replyid = Convert.ToInt32(dr["replyid"].ToString());
            this.blogid =Convert.ToInt32(dr["blogid"].ToString());
            this.title =dr["title"].ToString();
            this.add_date =dr["add_date"].ToString();
            string  bloguserid = dr["bloguserid"].ToString();

            data += "<tr class=datarow>";
            data += "<td>" + replyid  + "</td>";
            data += "<td><a title="+title +" href=../article.aspx?userid=" + bloguserid + "&blogid=" + blogid;
            data += ">"+ title + "</a></td>";
            data += "<td>" + add_date   + "</td>";
            data += "<td><a href=user_edit_reply.aspx?replyid="+replyid +"&userid="+userid +">修改</td>";
            data += "<td><a href=user_manage_reply.aspx?action=delete&replyid="+replyid+"&blogid="+blogid;
            data += ">刪除</a></td>";
            data += "</tr>";
        }
        string all =head + data + "</table>";
        message.InnerHtml = all;
    }
    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;
        readReply(x);
    }
    protected void lb_previous_Click(object sender, EventArgs e)
    {
        int x = Convert.ToInt32(ViewState["currentPage"].ToString ()) - 1;
        if (x < 1) x = 1;
        readReply(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 ;
        readReply(x);
    }


}