protected void btnSubmit_Click(object sender, EventArgs e)
{
//:todo 数据校验
string userMoblie = userMobile.Text.Trim();
string userPwdStr = userPwd.Text.Trim();
string payPwdStr = payPwd.Text.Trim();
string secretQuesStr = secretQuestion.Text.Trim();
string secretAnswerStr = secretAnswer.Text.Trim();
string email = userEmail.Text.Trim();
//检察用户是否已存在
bool checkUserExist = _userDataAccess.CheckExistByUserName(userMoblie);
if (checkUserExist)
{
ClientScript.RegisterClientScriptBlock(GetType(), "alert", "<script>alert('用户已存在！');</script>");
return;
}
FrontUser frontUser = new FrontUser();
frontUser.UserName = userMoblie;
//用户昵称名，暂用帐户名
frontUser.UserRoleName = userMoblie;
frontUser.UserStatus = UserStatus.Normal;
frontUser.Email = email;
frontUser.Mobile = userMoblie;
frontUser.Password = userPwdStr;
frontUser.PayPassword = payPwdStr;
frontUser.SecretAnswer = secretAnswerStr;
frontUser.SecretQuestion = secretQuesStr;
var res = _userDataAccess.Add(frontUser);
if (res > 0)
{
ClientScript.RegisterClientScriptBlock(GetType(), "alert", "<script>alert('注册成功！');</script>");
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add( FrontUser model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into FrontUser(");
strSql.Append("UserStatus,CreateDate,Account,UserName,Password,PayPassword,SecretQuestion,SecretAnswer,Email,Mobile,UserRoleName");
strSql.Append(") values (");
strSql.Append("@UserStatus,@CreateDate,@Account,@UserName,@Password,@PayPassword,@SecretQuestion,@SecretAnswer,@Email,@Mobile,@UserRoleName");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@UserStatus", SqlDbType.Int,4) ,
new SqlParameter("@CreateDate", SqlDbType.DateTime) ,
new SqlParameter("@Account", SqlDbType.Decimal,9) ,
new SqlParameter("@UserName", SqlDbType.VarChar,255) ,
new SqlParameter("@Password", SqlDbType.VarChar,255) ,
new SqlParameter("@PayPassword", SqlDbType.VarChar,255) ,
new SqlParameter("@SecretQuestion", SqlDbType.VarChar,255) ,
new SqlParameter("@SecretAnswer", SqlDbType.VarChar,255) ,
new SqlParameter("@Email", SqlDbType.VarChar,255) ,
new SqlParameter("@Mobile", SqlDbType.VarChar,255) ,
new SqlParameter("@UserRoleName", SqlDbType.VarChar,255)
};
parameters[0].Value = model.UserStatus;
parameters[1].Value = DateTime.Now;
parameters[2].Value = model.Account;
parameters[3].Value = model.UserName;
parameters[4].Value = model.Password;
parameters[5].Value = model.PayPassword;
parameters[6].Value = model.SecretQuestion;
parameters[7].Value = model.SecretAnswer;
parameters[8].Value = model.Email;
parameters[9].Value = model.Mobile;
parameters[10].Value = model.UserRoleName;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update( FrontUser model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update User set ");
strSql.Append(" UserStatus = @UserStatus , ");
strSql.Append(" CreateDate = @CreateDate , ");
strSql.Append(" Account = @Account , ");
strSql.Append(" UserName = @UserName , ");
strSql.Append(" Password = @Password , ");
strSql.Append(" PayPassword = @PayPassword , ");
strSql.Append(" SecretQuestion = @SecretQuestion , ");
strSql.Append(" SecretAnswer = @SecretAnswer , ");
strSql.Append(" Email = @Email , ");
strSql.Append(" Mobile = @Mobile , ");
strSql.Append(" UserRoleName = @UserRoleName ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4) ,
new SqlParameter("@UserStatus", SqlDbType.Int,4) ,
new SqlParameter("@CreateDate", SqlDbType.DateTime) ,
new SqlParameter("@Account", SqlDbType.Decimal,9) ,
new SqlParameter("@UserName", SqlDbType.VarChar,255) ,
new SqlParameter("@Password", SqlDbType.VarChar,255) ,
new SqlParameter("@PayPassword", SqlDbType.VarChar,255) ,
new SqlParameter("@SecretQuestion", SqlDbType.VarChar,255) ,
new SqlParameter("@SecretAnswer", SqlDbType.VarChar,255) ,
new SqlParameter("@Email", SqlDbType.VarChar,255) ,
new SqlParameter("@Mobile", SqlDbType.VarChar,255) ,
new SqlParameter("@UserRoleName", SqlDbType.VarChar,255)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.UserStatus;
parameters[2].Value = model.CreateDate;
parameters[3].Value = model.Account;
parameters[4].Value = model.UserName;
parameters[5].Value = model.Password;
parameters[6].Value = model.PayPassword;
parameters[7].Value = model.SecretQuestion;
parameters[8].Value = model.SecretAnswer;
parameters[9].Value = model.Email;
parameters[10].Value = model.Mobile;
parameters[11].Value = model.UserRoleName;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
