日期:2014-05-17 浏览次数:20519 次
public int AddUInfo(string P_Str_Name, bool P_Bl_Sex, string P_Str_Password, string P_Str_TrueName, string P_Str_Questions, string P_Str_Answers, string P_Str_Phonecode, string P_Str_Emails, string P_Str_City, string P_Str_Address, string P_Str_PostCode) { SqlConnection myConn = dbObj.GetConnection(); SqlCommand myCmd = new SqlCommand("Proc_InsertUInfo", myConn); myCmd.CommandType = CommandType.StoredProcedure; //添加参数 SqlParameter Name = new SqlParameter("@Name", SqlDbType.VarChar, 50); Name.Value = P_Str_Name; myCmd.Parameters.Add(Name); //添加参数 SqlParameter sex = new SqlParameter("@sex", SqlDbType.Bit,1); sex.Value = P_Bl_Sex; myCmd.Parameters.Add(sex); //添加参数 SqlParameter Password = new SqlParameter("@Password", SqlDbType.VarChar, 50); Password.Value = P_Str_Password; myCmd.Parameters.Add(Password); //添加参数 SqlParameter TrueName = new SqlParameter("@TrueName", SqlDbType.VarChar, 50); TrueName.Value = P_Str_TrueName; myCmd.Parameters.Add(TrueName); //添加参数 SqlParameter Questions = new SqlParameter("@Questions", SqlDbType.VarChar, 50); Questions.Value = P_Str_Questions; myCmd.Parameters.Add(Questions); //添加参数 SqlParameter Answers = new SqlParameter("@Answers", SqlDbType.VarChar, 50); Answers.Value = P_Str_Answers; myCmd.Parameters.Add(Answers); //添加参数 SqlParameter Phonecode = new SqlParameter("@Phonecode", SqlDbType.VarChar, 20); Phonecode.Value = P_Str_Phonecode; myCmd.Parameters.Add(Phonecode); //添加参数 SqlParameter Emails = new SqlParameter("@Emails", SqlDbType.VarChar, 50); Emails.Value = P_Str_Emails; myCmd.Parameters.Add(Emails); //添加参数 SqlParameter City = new SqlParameter("@City", SqlDbType.VarChar, 50); City.Value = P_Str_City; myCmd.Parameters.Add(City); //添加参数 SqlParameter Address = new SqlParameter("@Address", SqlDbType.VarChar, 200); Address.Value = P_Str_Address; myCmd.Parameters.Add(Address); //添加参数 SqlParameter PostCode = new SqlParameter("@PostCode", SqlDbType.Char, 10); PostCode.Value = P_Str_PostCode; myCmd.Parameters.Add(PostCode); //添加参数 SqlParameter MemberId = myCmd.Parameters.Add("@MemberId",SqlDbType.BigInt,8); MemberId.Direction = ParameterDirection.Output; //执行过程 myConn.Open(); try { myCmd.ExecuteNonQuery(); } catch (Exception ex) { throw(ex); } finally { myCmd.Dispose(); myConn.Close(); } return Convert.ToInt32(MemberId.Value.ToString());//错误消息提示这行出错 }
public partial class 前台_Register : System.Web.UI.Page { UserInfoClass ucObj = new UserInfoClass(); public static int G_Int_CustomerID; protected void Page_Load(object sender, EventArgs e) { } protected void btnSave_Click(object sender, EventArgs e) { if (txtPostCode.Text.Trim() == "" && txtPassword.Text.Trim() == "") { Response.Write("<script>alert('请输入完整信息!');location='javascript:history.go(-1)';</script>"); } else { bool P_BI_Sex; if (Convert.ToInt32(ddlSex.SelectedItem