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: }
新闻热点
疑难解答