remarks.aspx.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;
using System.Data.SqlClient;

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

        if (Session["name"] == null)
        {

            Response.Redirect("blank.htm");
        }
        if (!IsPostBack)
        {
            DataSet ds = bind();
            this.dropsend.DataSource = ds;
            this.dropsend.DataTextField = "send_date";
            this.dropsend.DataBind();
            ds.Dispose();
        }
     }
    private DataSet bind()
    {
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"];

        SqlCommand cmd = new SqlCommand("bindsend", conn);
        cmd.CommandType = CommandType.StoredProcedure;

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

        SqlDataAdapter adpt = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();

        adpt.Fill(ds,"send");
        return ds;
     }
    private void insert(string strtitle, string strcontent)
    {
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"];
        conn.Open();
        SqlCommand cmd = new SqlCommand("insertbeizhu",conn);
        cmd.CommandType = CommandType.StoredProcedure;

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

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

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

        cmd.ExecuteNonQuery();
        conn.Close();
        conn.Dispose();
        
    }
    protected void imgsend_Click(object sender, ImageClickEventArgs e)
    {
        try
        {
            if (this.dropsend.SelectedItem.Text != "" && txtbeizhu.Text != "")
            {
                insert(this.dropsend.SelectedItem.Text, txtbeizhu.Text);
                Response.Write("<script>alert('发送成功')</script>");
                txtbeizhu.Text = "";
            }
            else
            {
                Response.Write("<script>alert('在无表单或无内容情况下无法发送备注')</script>");
            }
        }
        catch (Exception ex)
        {
            Response.Write("<script>alert('在无表单或无内容情况下无法发送备注')</script>");
        }
    }
}