liuyan.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 tongxue_liuyan : System.Web.UI.Page
    {
        int pagesize = 5;
        int userid, cid;
        SqlDataReader dr;
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Session["userid"] != null)
            {
                this.userid = Convert.ToInt32(Session["userid"].ToString());
            }
            else
                Response.Redirect("userLogin.aspx?url=" + Server.HtmlEncode(Request.RawUrl));
            if (Request.QueryString["cid"] != null)
                cid = Convert.ToInt32(Request.QueryString["cid"]);

            if (Request.QueryString["action"] != null)
                delete();
            if (!IsPostBack)
            {
                readLiuYan(1);
                pageNavigate();
            }
        }
        private void delete()
        {
            if (isAdmin())
            {
                int id = Convert.ToInt32(Request.QueryString["id"]);
                string sql = "delete from tliuyan where id=" + id + " and cid=" + this.cid;
                openDb o1 = new openDb(sql);
                o1.update();
                Response.Redirect("liuyan.aspx");
            }
        }
        private void pageNavigate()
        {
            string mysql = "select count(id) from tliuyan where cid=" + this.cid;
            pageHtml p1 = new pageHtml(mysql);
            ViewState["sumPage"] = p1.pageNavigate(this.pagesize);
            spage.InnerText = ViewState["sumPage"].ToString();
            if (ViewState["sumPage"].ToString() == "1")
                navigator.InnerHtml = "";
        }

        private void readLiuYan(int pageindex)
        {
            string strconn = ConfigurationManager.ConnectionStrings["dsn"].ToString();
            SqlConnection cn = new SqlConnection(strconn);
            cn.Open();

            SqlCommand cm = new SqlCommand("tpageliuyan", cn);
            cm.CommandType = CommandType.StoredProcedure;

            cm.Parameters.Add("@cid", SqlDbType.Int);
            cm.Parameters.Add("@pagesize", SqlDbType.Int);
            cm.Parameters.Add("@pageindex", SqlDbType.Int);

            cm.Parameters["@cid"].Value = this.cid;
            cm.Parameters["@pagesize"].Value = this.pagesize;
            cm.Parameters["@pageindex"].Value = pageindex;

            this.dr = cm.ExecuteReader();
            DisplayLiuYan();
            ViewState["currentPage"] = pageindex;
            cpage.InnerHtml = ViewState["currentPage"].ToString();
            cn.Close();
        }
        private void DisplayLiuYan()
        {
            string str;
            str = "<div class=liuyantitle>班级留言</div>";
            while (dr.Read())
            {
                string realname = dr["realname"].ToString();
                string text = dr["say"].ToString();
                string add_date = dr["add_date"].ToString();

                str += "<div class=tliuyan><div class=tsay>" + text + "</div>";
                if (isAdmin())
                    str += "<div class=tname><a href=liuyan.aspx?action=delete&cid=" + this.cid + "&id=" + dr["id"].ToString() + ">删除</a></div>";

                str += "<div class=tname>" + realname + "     发表于    " + add_date + "</div></div>";
            }
            liuyan.InnerHtml = str;
        }
        private bool isAdmin()
        {
            string sql = "select * from tbanji where cid=" + this.cid + " and adminuserid=" + this.userid;
            openDb o1 = new openDb(sql);
            return o1.haveRows();
        }

        //页面直接跳转
        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;
            readLiuYan(x);
        }

        //上一页
        protected void lb_previous_Click(object sender, EventArgs e)
        {
            int x = Convert.ToInt32(ViewState["currentPage"].ToString()) - 1;
            if (x < 1) x = 1;
            readLiuYan(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;
            readLiuYan(x);
        }

        protected void btnLiuyan_Click(object sender, EventArgs e)
        {
            decode d1 = new decode(Server.HtmlEncode(tbLiuyan.Text));
            string say = d1.outstr();
            string addip = Request.UserHostAddress;
            DateTime add_date = DateTime.Now;

            string sql = "insert into tliuyan(cid,say,tid,addip,add_date) values(";
            sql += cid + ",'" + say + "'," + this.userid + ",'" + addip + "','" + add_date + "')";

            openDb o1 = new openDb(sql);
            o1.update();
            readLiuYan(1);
            pageNavigate();

        }
    }