예제 #1
0
        // 返回UserID
        public static int AddUser(User user)
        {
            int minLength = 4;

            if (user.Password.Length < minLength)
            {
                return(1);
            }
            else
            {
                int status = DAO.CheckRepeatUserName(user.UserId, user.UserName);
                if (status == 0)
                {
                    SqlConnection conn    = DAO.Connection();
                    string        addUser = "******";
                    addUser = string.Format(addUser, user.UserId, user.UserName, user.Password);
                    //Console.WriteLine(addAccount);
                    try
                    {
                        conn.Open();
                        SqlCommand command = conn.CreateCommand();
                        command.CommandText = addUser;
                        int rows = command.ExecuteNonQuery();
                        if (rows == 1)
                        {
                            return(0);
                        }
                        else
                        {
                            Console.WriteLine("影响行数为{0}", rows);
                            return(-1);
                        }
                    }
                    catch (Exception exception)
                    {
                        Debug.WriteLine(exception.Message.ToString());
                        return(-1);
                    }
                }
                else
                {
                    return(2);
                }
            }
        }
예제 #2
0
        // 返回UserID
        public static int ChangeUserName(string OldUserName, string NewUserName, User user)
        {
            int minLength = 2;

            if (OldUserName == "")
            {
                return(1);
            }
            else
            {
                if (OldUserName != user.UserName)
                {
                    return(2);
                }
                else
                {
                    if (NewUserName.Length < minLength)
                    {
                        return(3);
                    }
                    else
                    {
                        if (OldUserName == NewUserName)
                        {
                            return(4);
                        }
                        else
                        {
                            int status = DAO.CheckRepeatUserName(user.UserId, NewUserName);
                            if (status == 0)
                            {
                                SqlConnection conn           = DAO.Connection();
                                string        updateUserName = "******" + NewUserName + "' WHERE UserID = '" + user.UserId + "'";
                                //Console.WriteLine(updateUserName);
                                try
                                {
                                    conn.Open();
                                    SqlCommand command = conn.CreateCommand();
                                    command.CommandText = updateUserName;
                                    int rows = command.ExecuteNonQuery();
                                    conn.Close();
                                    if (rows > 0)
                                    {
                                        return(0);
                                    }
                                    else
                                    {
                                        return(-1);
                                    }
                                }
                                catch (Exception exception)
                                {
                                    Debug.WriteLine(exception.Message.ToString());
                                    return(-1);
                                }
                            }
                            else if (status == 2)
                            {
                                return(5);
                            }
                            else if (status == 3)
                            {
                                return(6);
                            }
                            else
                            {
                                return(7);
                            }
                        }
                    }
                }
            }
        }