//获得用户的评论6 OK public List<Comment> GetUserAllComments(String UserID) { List<Comment> CommentList = new List<Comment>(); //数据访存器 DatabaseAccess.DataClasses1DataContext DBAccessor = new DataClasses1DataContext(); try { //调用存储过程,获得未读评论 ISingleResult<getCommentByUserResult> resultList = DBAccessor.getCommentByUser(UserID); foreach (getCommentByUserResult result in resultList) { Comment comment = new Comment(); comment.ID = result.id; comment.messageType = MessageType.comment; comment.content = result.content; comment.commodityId = (Guid)result.commodityid;//评论的商品 comment.registedUserID = UserID;//商品所属商家,即接受评论的商家 comment.userFrom = new RegistedUser(); comment.userFrom.UserName = result.userfrom;//发表留言的用户 //发评论用户的信息 ISingleResult<getUserByUserNameResult> UserInfoList = DBAccessor.getUserByUserName(result.userfrom); foreach (getUserByUserNameResult UserInfo in UserInfoList) { comment.userFrom.NickName = UserInfo.nickname; comment.userFrom.Phone = UserInfo.phone; comment.userFrom.Address = UserInfo.address; comment.userFrom.Email = UserInfo.email; comment.userFrom.City = UserInfo.city; comment.userFrom.Portrait = UserInfo.portraitPath; } CommentList.Add(comment); } } catch (Exception e) { } return CommentList; }