admintongxue.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_adminTongxue : System.Web.UI.Page
{
    int pagesize = 5;
    SqlDataReader dr;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["admin"] == null)
            Response.Redirect("adminLogin.aspx");

        if (Request.QueryString["action"] != null)
            delete();
        if (!IsPostBack)
        {
            readLiuYan(1);
            pageNavigate();
        }
    }
    private void delete()
    {
            int id = Convert.ToInt32(Request.QueryString["id"]);
            string sql = "delete from tliuyan where id=" + id ;
            openDb o1 = new openDb(sql);
            o1.update();
            Response.Redirect("admintongxue.aspx");
    }
    private void pageNavigate()
    {
        string mysql = "select count(id) from tliuyan ";
        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 = 0;
        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 >班级留言</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>";
                str += "<div class=tname><a href=admintongxue.aspx?action=delete&id=" + dr["id"].ToString() + ">删除</a></div>";

            str += "<div class=tname>班级编号   "+dr["cid"].ToString ()+"      "+  realname + "     发表于    " + add_date + "</div></div>";
        }
        liuyan.InnerHtml = str;
    }


    //页面直接跳转
    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 Button1_Click(object sender, EventArgs e)
    {
        string sql = "select * from tbanji where cid=" + Convert.ToInt32(TextBox1.Text);
                string strconn = ConfigurationManager.ConnectionStrings["dsn"].ToString();
        SqlConnection cn = new SqlConnection(strconn);
        cn.Open();

        SqlCommand cm = new SqlCommand(sql, cn);
        SqlDataReader d1=cm.ExecuteReader ();
        if (d1.Read())
            searchBanji.InnerHtml = d1["college"].ToString()+"__"+d1["comeyear"].ToString ()+"__"+d1["classname"].ToString ();
        cn.Close();
    }
}