mero.aspx.cs

多种模式留言系统 本留言系统 支持多种模式 一 签写留言模式 二 留言本模式 三 论坛模式 应用了第三的文本编辑器 支持动态更改网站标题 动态添加广告 支持留言头像选择

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 admin_mero : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["qx"] == null || Session["qx"].ToString() != "0" && Session["qx"].ToString() != "1")
            Response.Redirect("login.aspx");
        int id = Convert.ToInt32(Request.QueryString["id"]);
        titletb.Text = "Ra:" + odb.scr("select title from guest where id=" + id + "");
        Page.Title = odb.scr("select title from guest where id=" + id + "");
    }
    protected void FormView1_ItemCreated(object sender, EventArgs e)
    {//处理图标
        int id = Convert.ToInt32(Request.QueryString["id"]);

        Image qq = (Image)FormView1.FindControl("Image2");
        qq.Visible = odb.img("select qq from guest where id=" + id + "");
        //email
        Image email = (Image)FormView1.FindControl("Image3");
        email.Visible = odb.img("select email from guest where id=" + id + "");
        //MSN
        Image msn = (Image)FormView1.FindControl("Image4");
        msn.Visible = odb.img("select msn from guest where id=" + id + "");
        //url
        Image url = (Image)FormView1.FindControl("Image5");
        url.Visible = odb.img("select url from guest where id=" + id + "");

        Label concent = (Label)FormView1.FindControl("Label4");
            concent.Text = Server.HtmlDecode(odb.scr("select concent from guest where id=" + id + "")).ToString();
            if (Convert.ToInt32(odb.scr("select count(*) from [read] where lid=" + id + "")) > 0)
            {//如果有回复的话就把回复panel以及下面的东西都找出来，然后绑上数据，显示出来
                Panel re = (Panel)FormView1.FindControl("Panel1");
                re.Visible = true;
                fill();  
            }
    }
     protected void Button1_Click(object sender, EventArgs e)
    {
        int lid = Convert.ToInt32(Request.QueryString["id"]);
        string name = Server.HtmlEncode(nametb.Text.ToString().Replace("'", "!"));
        string title = Server.HtmlEncode(titletb.Text.ToString().Replace("'", "!"));
        string concent = Server.HtmlEncode(concentdx.Text.ToString().Replace("'", "!"));
        DateTime dtt = DateTime.Now;

        string que = "INSERT INTO [read] ([lid], [name], [title], [concent], [dtt]) VALUES ('" + lid + "','" + name + "','" + title + "','" + concent + "','" + dtt + "')";
        if (odb.insert(que))
        {//调用ＯＤＢ类的插入方法，并把ＳＱＬ语句作为参数传给类，让他帮助完成
            Response.Redirect("../cg.aspx?cg=c&id=" + lid);
        }
    }
    protected void Button2_Click(object sender, EventArgs e)
    {//删除留言
        int id = Convert.ToInt32(Request.QueryString["id"]);
        if (odb.insert("DELETE FROM [guest] WHERE id = " + id + ""))
        {
            odb.insert("DELETE FROM [read] WHERE lid = " + id + "");//删除本留言的所有回复

            Response.Redirect("../cg.aspx?cg=d");
        }
    }
    private void fill()
    {//绑定回复列表的数据，方便页内多次调用
        int id = Convert.ToInt32(Request.QueryString["id"]);
        read.DataSource = odb.ds("select * from [read] where lid=" + id + "");
        read.DataKeyField = "id";
        read.DataBind();
    }
    private DataList read
    {//因为页内要多次使用这个DataList做的回复列表，但是每次都去找难免有点笨笨
        get
        {
            DataList re = (DataList)FormView1.FindControl("DataList2");
            return re;
        }
    }
    protected void DataList2_CancelCommand(object source, DataListCommandEventArgs e)
    {//取消编辑
        read.EditItemIndex = -1;
        fill(); 
    }
    protected void DataList2_DeleteCommand(object source, DataListCommandEventArgs e)
    {//删除回复
        int id = Convert.ToInt32(read.DataKeys[e.Item.ItemIndex]);//找出该回复记录的ID
        if (odb.insert("DELETE FROM [read] WHERE id = " + id + ""))
        {
            fill();
        }
    }
    protected void DataList2_EditCommand(object source, DataListCommandEventArgs e)
    {//进入编辑状态
        read.EditItemIndex = e.Item.ItemIndex;
        fill(); 
    }
    protected void DataList2_UpdateCommand(object source, DataListCommandEventArgs e)
    {//更新当前回复
        int id = Convert.ToInt32(read.DataKeys[e.Item.ItemIndex]);//找出该回复记录的ID
        string title = ((TextBox)read.Items[e.Item.ItemIndex].FindControl("titletb")).Text.ToString();
        string concent = ((TextBox)read.Items[e.Item.ItemIndex].FindControl("concenttb")).Text.ToString();
        string dtt = DateTime.Now.ToString();
        odb.insert("UPDATE  [read] SET  title = '" + title + "', concent = '" + concent + "', dtt ='" + dtt + "' WHERE ([read].id = " + id + ")");
    }
}