replypage.aspx.cs

visual studio 2005开发环境下采用C#语言开发的简单留言本源码

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;

public partial class ReplyPage : System.Web.UI.Page
{
    public int id = 0;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.Cookies["user"] == null || Request.Cookies["user"]["name"].ToString().Trim() == "")
        {
            Response.Redirect("index.aspx");
            return;
        }
        if (Request.QueryString["id"] == null)
        {
            Response.Redirect("ViewMessage.aspx");
            return;
        }
        id = int.Parse(Request.QueryString["id"].ToString().Trim());
        if (!IsPostBack)
        {
            if (SqlDB.IsNumeric(id.ToString()))
            {
                bind(id);
                bindinfo(id);
            }
            else
            {
                Response.Redirect("ViewMessage.aspx");
            }
        }
    }
    private void bindinfo(int i)
    {
        DataSet ds = SqlDB.getdataset("select * from Newpost where PostID =" + i);
        TextBox1.Text = "RE:" + ds.Tables[0].Rows[0]["title"].ToString();
    }
    private void bind(int i)
    {
        string sql = "select * from Newpost where PostID =" + i + "or ParentID = "+i;
        sql += " order by PostID";
        //dlt_ad.DataSource = AccessDB.myDataSet(sql);
        //dlt_ad.DataBind();
        DataSet ds = SqlDB.getdataset(sql);
            lblAllCount.Text = "0";
        if (ds != null)
        {
            lblAllCount.Text = ds.Tables[0].Rows.Count.ToString();
        }
        if (lblAllCount.Text == "0")
        {
            lblPage.Text = "0";
            lblAllPage.Text = "0";
            first.Enabled = false;
            up.Enabled = false;
            down.Enabled = false;
            last.Enabled = false;
            dlt_ad.DataSource = ds;
            dlt_ad.DataBind();
        }
        else
        {
            //设置分页
            int currentPageIndex = int.Parse(lblPage.Text);

            PagedDataSource objds = new PagedDataSource();
            objds.DataSource = ds.Tables[0].DefaultView;
            objds.AllowPaging = true;
            objds.PageSize = 30;
            objds.CurrentPageIndex = currentPageIndex - 1;

            dlt_ad.DataSource = objds;
            dlt_ad.DataBind();

            int pageCount = objds.PageCount;

            first.Enabled = true;
            up.Enabled = true;
            down.Enabled = true;
            last.Enabled = true;

            if (currentPageIndex <= 1)
            {
                first.Enabled = false;
                up.Enabled = false;
            }
            if (currentPageIndex >= pageCount)
            {
                down.Enabled = false;
                last.Enabled = false;
            }
            lblPage.Text = currentPageIndex.ToString();
            lblAllPage.Text = pageCount.ToString();
        }
    }
    protected void first_Click(object sender, EventArgs e)
    {
        lblPage.Text = "1";
        bind(id);
    }
    protected void last_Click(object sender, EventArgs e)
    {
        lblPage.Text = lblAllPage.Text;
        bind(id);
    }
    protected void up_Click(object sender, EventArgs e)
    {
        lblPage.Text = Convert.ToString(int.Parse(lblPage.Text) - 1);
        bind(id);
    }
    protected void down_Click(object sender, EventArgs e)
    {
        lblPage.Text = Convert.ToString(int.Parse(lblPage.Text) + 1);
        bind(id);
    }

    protected void btnLogin_Click(object sender, EventArgs e)
    {
        Label1.Text = "";
        if (TextBox1.Text.Trim() == "")
        {
            Label1.Text = "标题不能为空";
            TextBox1.Focus();
            return;
        }
        if (TextBox2.Text.Trim() == "")
        {
            Label1.Text = "标题不能为空";
            TextBox2.Focus();
            return;
        }
        if (SqlDB.runsql("insert into Newpost(title,content,addUser,ParentID) values('" + TextBox1.Text.Trim() + "','" + TextBox2.Text.Trim() + "','" + Request.Cookies["user"]["name"].ToString() + "',"+id+")") > 0)
        {
            Response.Write("<script>alert(\"回复已经提交，谢谢！\");</script>");
            bind(id);
            TextBox2.Text = "";
        }
        else
        {
            Label1.Text = "对不起，提交失败！";
        }

    }

    protected void dlt_ad_ItemCommand(object source, DataListCommandEventArgs e)
    {
        if (e.CommandName == "del")
        {
            int delid = int.Parse(dlt_ad.DataKeys[e.Item.ItemIndex].ToString());
            if (delid != id)
            {
                if (SqlDB.runsql("delete from Newpost where PostID =" + delid) > 0)
                {
                    Response.Write("<script>alert(\"删除成功！\");</script>");
                }
                else
                {
                    Response.Write("<script>alert(\"删除失败！\");</script>");
                }
            }
            else
            {
                if (SqlDB.runsql("delete from Newpost where PostID =" + delid + "or ParentID = " + delid) > 0)
                {
                    Response.Write("<script>alert(\"删除成功！\");location.href=\"ViewMessage.aspx\";</script>");
                }
                else
                {
                    Response.Write("<script>alert(\"删除失败！\");</script>");
                }
            }         
            bind(id);   
        }
       
    }
    protected void dlt_ad_ItemDataBound(object sender, DataListItemEventArgs e)
    {
        if (Request.Cookies["user"] != null && Request.Cookies["user"]["isAdmin"].ToString().Trim() == "1")
        {
            if(e.Item.ItemType==ListItemType.Item||e.Item.ItemType==ListItemType.AlternatingItem)
            {
                LinkButton del = (LinkButton)e.Item.FindControl("del");
                del.CommandName = "del";
                del.CommandArgument = e.Item.ItemIndex.ToString();
                del.Visible = true;
            }
        }
    }
    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        Response.Redirect("ViewMessage.aspx");
    }
    protected void LinkButton2_Click(object sender, EventArgs e)
    {
        Response.Redirect("WriteMessage.aspx");
    }
}