guestbook_reply.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.Data.OleDb;

public partial class admin_guestBook_guestBook_reply : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        Server.Execute("../incs/checkPurview.aspx");  // 此处用户权限验证

    }
    protected void btnButton1_Click(object sender, EventArgs e)
    {
        string guestType = Request.QueryString["id"];

        //通过验证控件的验证
        if (Page.IsValid)
        {

            string sguestName = guestName.Text;
            string sguestFrom = guestFrom.Text;
            string sguestTitle = "";//guestTitle.Text; //回复没有标题
            string sguestContent = guestContent.Text;
            string sguestFace = ""; // guestFace.Text; //回复没有头像
            string sguestQQ = guestQQ.Text;
            string sguestMSN = guestMSN.Text;
            string sguestHomePage = guestHomePage.Text;
            string sguestEmail = guestEmail.Text;
            string sguestTel = guestTel.Text;
            string sguestDatetime = System.DateTime.Now.ToString();
            //string sguestIP = Request.ServerVariables["REMOTE_ADDR"];//Page.Request.UserHostAddress.ToString();
            string sguestIP = Page.Request.UserHostAddress;
            int guestIsPassed = 1;   //0 不显示 1 显示  可设置,经管理员审核后才能显示

            string strConnection = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
            OleDbConnection objConnection = new OleDbConnection(strConnection);

            objConnection.Open();
            //string strsql = "Insert Into tGuestBook(guestName,guestFrom,guestContent,guestIP,guestType)Values('" + sguestName + "','" + sguestFrom + "','" + sguestContent + "','"+Page.Request.UserHostAddress+"','" + guestType + "' )";
            string strsql = "Insert Into tGuestBook(guestName,guestFrom,guestTitle,guestContent,guestFace,guestQQ,guestMSN,guestHomePage,guestEmail,guestTel,guestDatetime,guestIP,guestType,guestIsPassed)Values('"
    + sguestName + "','" + sguestFrom + "','" + sguestTitle + "','" + sguestContent + "','" + sguestFace + "','" + sguestQQ + "','" + sguestMSN + "','" + sguestHomePage + "','" + sguestEmail + "','" + sguestTel + "','" + sguestDatetime + "','" + sguestIP + "'," + guestType + "," + guestIsPassed + " )";


            OleDbCommand objCommand = new OleDbCommand(strsql, objConnection);
            int ok = objCommand.ExecuteNonQuery();
            if (ok > 0)
            {
                addOK.Text = "添加回复成功";
            }
            objConnection.Close();



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