gridview.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 gridview : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

        if (!IsPostBack)
        {
            if (Session["qx"] == null || Session["qx"].ToString() != "0" && Session["qx"].ToString() != "1")
                Response.Redirect("login.aspx");
            GridView1.PageSize = odb.num("adminnum");//设置每页显示的条目数
        }
    }
    protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
    {//鼠标行为
        e.Row.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='#507Ce1'");
        e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c;");
    }
    protected void visddl_SelectedIndexChanged(object sender, EventArgs e)
    {
        foreach (GridViewRow gr in GridView1.Rows)
        {
            int id = Convert.ToInt32(((Label)gr.Cells[0].FindControl("Label4")).Text);
            string vis = ((DropDownList)gr.Cells[3].FindControl("visddl")).SelectedValue.ToString();
            odb.insert("UPDATE guest SET vis = '" + vis + "' WHERE (guest.id = " + id + ")");
        }
    }
    protected void chkall_CheckedChanged(object sender, EventArgs e)
    {
        foreach (GridViewRow gr in GridView1.Rows)
        {
            CheckBox chk = (CheckBox)gr.Cells[5].FindControl("chk");
            if (chk.Checked)
            {
                chk.Checked = false;
            }
            else
            {
                chk.Checked = true;
            }
        }
    }
    protected void Button2_Click(object sender, EventArgs e)
    {//处理审核
        foreach (GridViewRow gr in GridView1.Rows)
        {
            CheckBox chk = (CheckBox)gr.Cells[5].FindControl("chk");
            if (chk.Checked)
            {
                int id = Convert.ToInt32(((Label)gr.Cells[0].FindControl("Label4")).Text);
                string vis = ((DropDownList)gr.Cells[3].FindControl("visddl")).SelectedValue.ToString();
                if(vis=="1")
                odb.insert("UPDATE guest SET vis = '0' WHERE (guest.id = " + id + ")");
            }
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        foreach (GridViewRow gr in GridView1.Rows)
        {
            CheckBox chk = (CheckBox)gr.Cells[5].FindControl("chk");
            if (chk.Checked)
            {
                int id = Convert.ToInt32(((Label)gr.Cells[0].FindControl("Label4")).Text);
                odb.insert("DELETE FROM [guest] WHERE id = " + id + "");//删除所有选中的留言
                odb.insert("DELETE FROM [read] WHERE lid = " + id + "");//删除本留言的所有回复
            }
        }
    }
}