idea.aspx.cs

一个较小的采购系统,一些比较实际的代码,可以用来参考

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Data.SqlClient;
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 idea : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["name"] == null)
        {
            Response.Redirect("Default.aspx");
        }
    }
    protected void imgsuggest_Click(object sender, ImageClickEventArgs e)
    {
        if (this.txtsuggest.Text != "" && this.txtcontent.Text != "")
        {
            insert(this.txtsuggest.Text, this.txtcontent.Text);
            this.txtcontent.Text = "";
            this.txtsuggest.Text = "";
            Response.Write("<script>发送成功!</script>");
        }
        else
        {
            Response.Write("<script>alert('标题和内容必需填写')</script>");
        }
    }
    private void insert(string strtitle,string strcontent)
    {
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"];
        conn.Open();
        SqlCommand cmd = new SqlCommand("insertsuggest", conn);
        cmd.CommandType = CommandType.StoredProcedure;


        SqlParameter paratitle= new SqlParameter("@suggest_title", SqlDbType.NVarChar, 50);
        paratitle.Value = strtitle;
        cmd.Parameters.Add(paratitle);

        SqlParameter paracontent = new SqlParameter("@suggest_content", SqlDbType.Text);
        paracontent.Value = strcontent;
        cmd.Parameters.Add(paracontent);

        SqlParameter paraSession = new SqlParameter("@suggest_session", SqlDbType.NVarChar, 50);
        paraSession.Value = Session["name"].ToString();
        cmd.Parameters.Add(paraSession);

        cmd.ExecuteNonQuery();
        conn.Close();
        conn.Dispose();
    }
}