//获得用户的评论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;
}