日期:2014-05-17 浏览次数:20674 次
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