writemessage.ascx.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 WebUserControl_WriteMessage : System.Web.UI.UserControl
{
    public string VirtualPath = "";
    

    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request["ID"] != null)
        {
            this.HiddenID.Value = Request["ID"].ToString();
        }
        else
        {
            this.HiddenID.Value  = "-1";
        }
    }

    protected void Submit1_ServerClick(object sender, EventArgs e)
    {
        if (Name.Text.Trim() != "" && Email.Text.Trim() != "" && content.Text.Trim() != "" && this.Title.Text.Trim() != "")
        {
            DataSet ds = new DataSet();
            DAL.boBusiness bo = new DAL.boBusiness();
            DAL.MakeConnection Conn = new DAL.MakeConnection();
            DAL.clsDBConnkey ConnKey = new DAL.clsDBConnkey();
            ConnKey = bo.loadkey();//得到config数据库连接


            string ip = Request.ServerVariables["REMOTE_ADDR"];
            string myLeavewordTime = System.DateTime.Now.ToString();
            string strTitle = this.Title.Text.ToString();


            //string WebUserID = this.WebUserID.Value;
            string sql = "INSERT INTO messageboard (WebUser,ArticleID,email,ip,content,LeavewordTime,Title,IsRevert,IsNominate) VALUES ";
            sql += " ('" + this.Name.Text + "','" + Convert.ToUInt32(this.HiddenID.Value) + "','" + Email.Text.ToString() + "', '" + ip + "', '" + content.Text.ToString() + "','" + myLeavewordTime + "','" + strTitle + "',0,0)";
            try
            {
                if (sql != "")
                {
                    Conn.MakeConnectionMethod(sql, ConnKey, DAL.executeMethod.execute_NoneQuery, DAL.
                        EnumDBType.Sql, VirtualPath);
                }
            }
            catch (System.Exception ex)
            {
                throw ex;
            }
            this.Name.Text = "";
            this.Email.Text = "";
            this.content.Text = "";
            this.Title.Text = "";
            Response.Write("<script language='javascript'>window.setTimeout(\"alert('提交成功！')\",100);</script>");
            //Response.Redirect("Index.aspx");
        }
        else
        {
            Response.Write("<script language='javascript'>window.setTimeout(\"alert('字段填写不完整，请重新填写！')\",100);</script>");

        }
    }

}