1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Collections;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.WebControls;
 9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11using System.Data.SqlClient;
12
13public partial class addsell : System.Web.UI.Page
14...{
15    SqlConnection cn;
16    protected void Page_Load(object sender, EventArgs e)
17    ...{
18        if (Session["branch"].ToString() == "0" || Session["branch"].ToString() == "1")
19        ...{
20            
21        }
22        else
23        ...{
24            Response.Write("您不是合法用户，请登入后再操作，<a href='default.aspx'>返回登录</a>");
25            Page.Response.End();
26        }
27        string strconn = ConfigurationSettings.AppSettings["ConnectionString"];
28        cn = new SqlConnection(strconn);
29    }
30    protected void Btn_ok_Click(object sender, EventArgs e)
31    ...{
32        SqlCommand cm = new SqlCommand("Addsell", cn);
33
34        cm.CommandType = CommandType.StoredProcedure;
35
36        cm.Parameters.Add(new SqlParameter("@Compact_id", SqlDbType.VarChar, 20));
37        cm.Parameters.Add(new SqlParameter("@Product_id ", SqlDbType.VarChar, 20));
38        cm.Parameters.Add(new SqlParameter("@Product_num", SqlDbType.Int, 4));
39        cm.Parameters.Add(new SqlParameter("@Product_send", SqlDbType.Int, 4));
40        cm.Parameters.Add(new SqlParameter("@price", SqlDbType.Money, 8));
41
42
43        cm.Parameters["@compact_id"].Value = DropDownList2.SelectedItem.Value;
44        cm.Parameters["@Product_id "].Value = DropDownList1.SelectedItem.Value;
45        cm.Parameters["@Product_num"].Value = Product_num.Text;
46        cm.Parameters["@Product_send"].Value = Product_send.Text;
47        cm.Parameters["@price"].Value = Product_price.Text;
48
49        cm.Connection.Open();
50        try
51        ...{
52            cm.ExecuteNonQuery();
53            Response.Redirect("editsell.aspx");
54
55        }
56        catch (SqlException)
57        ...{
58            Lbl_note.Text = "添加失败";
59            Lbl_note.Style["color"] = "red";
60        }
61        cm.Connection.Close();
62    }
63    protected void Btn_cancel_Click(object sender, EventArgs e)
64    ...{
65        Page.Response.Redirect("addsell.aspx");
66    }
67}
68