default.aspx.cs

asp.net 的某物流管理系统 MIS 系统

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

public partial class liuyan_Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
       //验证码
        if (txtYanzheng.Text.ToString() != Session["Checkcode"].ToString())
        {           
            Response.Write("<Script>alert('验证码错误!')</Script>");
            return;
        }
        //留言长度
        if (FreeTextBox1.Text.Length > 2000)
        {
            Response.Write("<Script>alert('留言长度不能超过200字!')</Script>");
            return;
        }
        string name = txtName.Text.ToString();
        string email = txtEmail.Text.ToString();
        string web=txtWeb.Text.ToString();
        string QQ = txtQQ.Text.ToString();
        string headurl = Session["Selecthead"].ToString();
        int ifbaomi = chkHua.Checked == true ? 1 : 0;
        string content = FreeTextBox1.Text.ToString();
        string ip = Request.UserHostAddress;
        int nResult = Savetodate(name, email, web, QQ, headurl, ifbaomi, content, ip);
        Clearcontent();
        Response.Write("<Script>alert('留言成功！')</Script>");
    }
    public int Savetodate(string sName,string sEmail,string sWeb,string sQQ,string sHeadurl,int nBaomi,string sContent,string sIP)
    {
        int nResult=-1;
         string myConnectionString = ConfigurationManager.ConnectionStrings["OLEDBCONNECTIONSTRING1"].ConnectionString + Server.MapPath("~") + ConfigurationManager.ConnectionStrings["OLEDBCONNECTIONSTRING3"].ConnectionString;
         OleDbConnection myConnection = new OleDbConnection(myConnectionString);
         string cmdText = "INSERT INTO mydata(Visitorname,Visitoremail,Visitorweb,VisitorQQ,Headurl,ifBaomi,Content,VisitorIP,Createdate)VALUES(" +
             "'" + sName + "'," +
             "'" + sEmail + "'," +
             "'" + sWeb + "'," +
             "'" + sQQ + "'," +
             "'" + sHeadurl + "'," +
             nBaomi + "," +
             "'" + sContent + "'," +
             "'" + sIP + "'," +
             "Now())";
        OleDbCommand myCommand=new OleDbCommand(cmdText,myConnection);
        try
        {
            myConnection.Open();
            nResult = myCommand.ExecuteNonQuery();
        }
        catch
        {
            Response.Redirect("Error.aspx");           
        }
        finally
        {
            myConnection.Close();
        }
        return nResult;
    }
    //清除留言
    private void Clearcontent()
    {
        txtEmail.Text = "";
        txtQQ.Text = "";
        txtWeb.Text = "";
        txtYanzheng.Text = "";
        FreeTextBox1.Text = "";
        txtWeb.Text = "";
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        Clearcontent();
    }

    
}