Exemple #1
0
        public Boolean SaveUser(UserModel user)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("INSERT INTO users(");
            strSql.Append("username,password,email,mobile)");
            strSql.Append(" VALUES (");
            strSql.Append("@in_username,@in_password,@in_email,@in_mobile)");
            MySqlParameter[] cmdParms = {
                new MySqlParameter("@in_username",  user.username),
                new MySqlParameter("@in_password",  user.password),
                new MySqlParameter("@in_email",  user.email),
                new MySqlParameter("@in_mobile",  user.tel)};

            return MySqlHelper.ExecuteNonQuery(ConstValues.connStr, strSql.ToString(), cmdParms) == 1 ? true : false;
        }
        private string saveUser(HttpContext context)
        {
            string username = context.Request.Params.Get("username");
            string password = context.Request.Params.Get("password");
            string email = context.Request.Params.Get("email");
            string tel = context.Request.Params.Get("mobile");
            if (StringHelper.IsEmpty(username))
            {
                throw new Exception("用户名不能为空。");
            }

            if (StringHelper.IsEmpty(password))
            {
                throw new Exception("密码不能为空。");
            }

            if (StringHelper.IsEmpty(email))
            {
                throw new Exception("邮箱地址不能为空。");
            }

            if (StringHelper.IsEmpty(tel))
            {
                throw new Exception("手机号不能为空。");
            }

            UserModel user = new UserModel();
            user.username = username;
            user.email = email;
            user.tel = tel;
            user.password = password;

            UserBll userBll = new UserBll();
            if (userBll.SaveUser(user))
            {
                return "ok";
            }
            else
            {
                throw new Exception("数据库异常,新用户保存失败。");
            }
        }