addsell.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 addsell : System.Web.UI.Page
{
    SqlConnection cn;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["branch"].ToString() == "0" || Session["branch"].ToString() == "1")
        {
            
        }
        else
        {
            Response.Write("您不是合法用户，请登入后再操作，<a href='default.aspx'>返回登录</a>");
            Page.Response.End();
        }
        string strconn = ConfigurationSettings.AppSettings["ConnectionString"];
        cn = new SqlConnection(strconn);
    }
    protected void Btn_ok_Click(object sender, EventArgs e)
    {
        SqlCommand cm = new SqlCommand("Addsell", cn);

        cm.CommandType = CommandType.StoredProcedure;

        cm.Parameters.Add(new SqlParameter("@Compact_id", SqlDbType.VarChar, 20));
        cm.Parameters.Add(new SqlParameter("@Product_id ", SqlDbType.VarChar, 20));
        cm.Parameters.Add(new SqlParameter("@Product_num", SqlDbType.Int, 4));
        cm.Parameters.Add(new SqlParameter("@Product_send", SqlDbType.Int, 4));
        cm.Parameters.Add(new SqlParameter("@price", SqlDbType.Money, 8));


        cm.Parameters["@compact_id"].Value = DropDownList2.SelectedItem.Value;
        cm.Parameters["@Product_id "].Value = DropDownList1.SelectedItem.Value;
        cm.Parameters["@Product_num"].Value = Product_num.Text;
        cm.Parameters["@Product_send"].Value = Product_send.Text;
        cm.Parameters["@price"].Value = Product_price.Text;

        cm.Connection.Open();
        try
        {
            cm.ExecuteNonQuery();
            Response.Redirect("editsell.aspx");

        }
        catch (SqlException)
        {
            Lbl_note.Text = "添加失败";
            Lbl_note.Style["color"] = "red";
        }
        cm.Connection.Close();
    }
    protected void Btn_cancel_Click(object sender, EventArgs e)
    {
        Page.Response.Redirect("addsell.aspx");
    }
}