guestbook_ispassed.aspx.cs

【程序主要功能】 1、精简的增删改查

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.OleDb;

public partial class admin_guestBook_guestBook_isPassed : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        Server.Execute("../incs/checkPurview.aspx");  // 此处用户权限验证
        
        string id = Request.QueryString["id"];
        string isPassed = Request.QueryString["isPassed"];

        if (id!=null && isPassed !=null){
            if ("0".Equals(isPassed))
            {
                isPassed = "1";
            }
            else {
                isPassed = "0";
            }
            string strConnection = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
            OleDbConnection objConnection = new OleDbConnection(strConnection);

            objConnection.Open();
            string strsql = "update tGuestBook set guestIsPassed=" + isPassed + " where guest_ID="+id;

            OleDbCommand objCommand = new OleDbCommand(strsql, objConnection);
            int ok = objCommand.ExecuteNonQuery();
            if (ok > 0)
            {
                //审核设置成功
                // Page.RegisterClientScriptBlock("js", "<script>alert('审核设置成功')</script>");
                //Response.Write("<script>window.alert('审核设置成功');window.location='guestBook.aspx'</script>");
            }
            objConnection.Close();


        }

        //重定向到留言页面
        Response.Redirect("guestBook_Manage.aspx");
    }
}