PRotected void btnSend_Click(object sender, EventArgs e)
2: {
3: int temp = -1;
4: int exhibitionID = int.Parse(Request.QueryString["ConList"]);
5: int exhibitorType = 0;
6:
7: int mCustomerID = 0;
8: if (session["UserID"] != null)
9: {
10: ViewState["CID"] = myShare.GetAObject(true, 1, "CustomerID", "Customers", "UserID='" + Session["UserID"].ToString() + "'").ToString();
11: if (!string.IsNullOrEmpty(ViewState["CID"].ToString()))
12: {
13: mCustomerID = Convert.ToInt32(ViewState["CID"].ToString());
14: }
15: }
16: string company = this.txtCompay.Text.Trim();
17: string name = this.txtName.Text;
18: string tel = this.txtTel.Text;
19: string email = this.txtEmail.Text;
20:
21: SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
22:
23: SqlCommand com = new SqlCommand("ExpoApply", con);
24: com.CommandType = CommandType.StoredProcedure;
25:
26: SqlParameter parCustomerID = new SqlParameter("@CustomerID", SqlDbType.Int);
27: parCustomerID.Value = mCustomerID;
28: com.Parameters.Add(parCustomerID);
29:
30: SqlParameter parCompanyName = new SqlParameter("@CompanyName", SqlDbType.NVarChar, 100);
31: parCompanyName.Value = company;
32: com.Parameters.Add(parCompanyName);
33:
34: SqlParameter parContact = new SqlParameter("@Contact", SqlDbType.VarChar, 50);
35: parContact.Value = name;
36: com.Parameters.Add(parContact);
37:
38: SqlParameter parEmail = new SqlParameter("@Email", SqlDbType.VarChar, 50);
39: parEmail.Value = email;
40: com.Parameters.Add(parEmail);
41:
42:
43: SqlParameter parReturnValue = new SqlParameter("@ReturnValue", SqlDbType.Int);
44: parReturnValue.Direction = ParameterDirection.Output;
45: com.Parameters.Add(parReturnValue);
46:
47: try
48: {
49: con.Open();
50: com.ExecuteNonQuery();
51:
52: temp = int.Parse(com.Parameters["@ReturnValue"].Value.ToString());
53:
54: if (temp == -1)
55: {
56: myShare.WebMessageBox(this.Page, "信息发布时出错，请重试！");
57: }
58: else if (temp == 0)
59: {
60: myShare.WebMessageBox(this.Page, "信息发布失败，请重试！");
61: }
62: else
63: {
64: ClientScript.RegisterStartupScript(ClientScript.GetType(), "提示", "<script>alert('信息发布成功！');window.location='DiscountExpoList.aspx'</script>");
65: }
66:
67: }
68: catch (Exception ex)
69: {
70: Response.Write(ex.Message);
71: }
72:
73: }
1: SqlConnection con = null;
2: try
3: {
4: con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
5: SqlCommand com = new SqlCommand();
6: com.Connection = con;
7: com.CommandType = CommandType.StoredProcedure;
8: com.CommandText = "ExpoApply";
9: con.Open();
10: SqlParameter[] sp =
11: {
12: new SqlParameter("@CustomerID",SqlDbType.Int)
13: ,new SqlParameter("@CompanyName",SqlDbType.NVarChar,100)
14: ,new SqlParameter("@Contact",SqlDbType.VarChar,50)
15: ,new SqlParameter("@Email",SqlDbType.VarChar,50)
16: //...
17: ,new SqlParameter("@ReturnValue",SqlDbType.Int)
18:
19: };
20: sp[0].Value = mCustomerID;
21: sp[1].Value = company;
22: sp[2].Value = name;
23: sp[3].Value = email;
24: // ...
25: sp[16].Direction = ParameterDirection.Output;
26: com.Parameters.AddRange(sp);
27: com.ExecuteNonQuery();
28: temp = Convert.ToInt32(com.Parameters["@ReturnValue"].Value);
29: con.Close();
30: }
31:
32: catch (SqlException se)
33: {
34: }
35: finally
36: {
37: con.Close();
38: }
39:
40: if (temp == -1)
41: {
42: myShare.WebMessageBox(this.Page, "信息发布时出错，请重试！");
43: }
44: else if (temp == 0)
45: {
46: myShare.WebMessageBox(this.Page, "信息发布失败，请重试！");
47: }
48: else
49: {
50: ClientScript.RegisterStartupScript(ClientScript.GetType(), "提示", "<script>alert('信息发布成功！');window.location='DiscountExpoList.aspx'</script>");
51: }