public static bool AddUser(Users user) { #region 注册用户 if (user.UserRoles == null) { user.UserRoles = UserRolesServer.GetUserRolesById(1); } if (user.UserStates == null) { user.UserStates = UserStatesServer.GetUserStatesById(1); } string sql = @"INSERT INTO Users(LoginId,LoginPwd,Name,Address,Phone,Mail,UserRoleId,UserStateId) VALUES(@LoginId,@LoginPwd,@Name,@Address,@Phone,@Mail,@UserRoleId,@UserStateId)"; SqlParameter[] para = { new SqlParameter("@LoginId", user.LoginId), new SqlParameter("@LoginPwd", user.LoginPwd), new SqlParameter("@Address", user.Address), new SqlParameter("@Phone", user.Phone), new SqlParameter("@Mail", user.Mail), new SqlParameter("@Name", user.Name), new SqlParameter("@UserRoleId", user.UserRoles.Id), new SqlParameter("@UserStateId", user.UserStates.Id) }; int count = DbHelp.ExecuteCommand(sql, para); if (count > 0) { return(true); } else { return(false); } #endregion }
public static bool UpdateUser(Users user) { #region 更新用户信息 string sql = @"UPDATE Users SET LoginId=@LoginId,LoginPwd=@LoginPwd,Name=@Name,Address=@Address,Phone=@Phone,Mail=@Mail,UserRoleId=@UserRoleId,UserStateId=@UserStateId WHERE Id=@Id"; SqlParameter[] para = { new SqlParameter("@LoginId", user.LoginId), new SqlParameter("@LoginPwd", user.LoginPwd), new SqlParameter("@Address", user.Address), new SqlParameter("@Phone", user.Phone), new SqlParameter("@Mail", user.Mail), new SqlParameter("@Name", user.Name), new SqlParameter("@UserRoleId", user.UserRoles.Id), new SqlParameter("@UserStateId", user.UserStates.Id), new SqlParameter("@Id", user.ID) }; int count = DbHelp.ExecuteCommand(sql, para); if (count > 0) { return(true); } else { return(false); } #endregion }