Exemple #1
0
        // GFUser註冊
        public int EasyRegister(GFUser viewresult)
        {
            string sql = @"INSERT INTO HelpUser(
                                    UserID,User_Password,Nickname,Phone,Gender,Email)
                                    VALUES(
                                     @UserID,@User_Password,@Nickname,@Phone,@Gender,@Email
                                )";
            int    Id;

            using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString()))
            {
                conn.Open();
                SqlCommand cmd = new SqlCommand(sql, conn);
                cmd.Parameters.Add(new SqlParameter("@UserID", viewresult.UserID));
                cmd.Parameters.Add(new SqlParameter("@User_Password", viewresult.User_Password));
                cmd.Parameters.Add(new SqlParameter("@Nickname", viewresult.Nickname));
                cmd.Parameters.Add(new SqlParameter("@Phone", viewresult.Phone));
                cmd.Parameters.Add(new SqlParameter("@Gender", viewresult.Gender));
                cmd.Parameters.Add(new SqlParameter("@Email", viewresult.Email));
                SqlDataAdapter sqlAdapter = new SqlDataAdapter(cmd);
                Id = Convert.ToInt32(cmd.ExecuteNonQuery());
                conn.Close();
            }
            return(Id);
        }
 public JsonResult EasyRegister(GFUser data)
 {
     return(this.Json(lbService.EasyRegister(data)));
 }
Exemple #3
0
 public int EasyRegister(GFUser viewresult)
 {
     return(lbDao.EasyRegister(viewresult));
 }