//获得用户的未读留言7 OK public List<Message> GetUserUreadPublicMessages(String UserID) { List<Message> PublicMessagesList = new List<Message>(); //数据访存器 DatabaseAccess.DataClasses1DataContext DBAccessor = new DataClasses1DataContext(); try { ISingleResult<getUnreadPublicMessageByUserResult> resultList = DBAccessor.getUnreadPublicMessageByUser(UserID); //获得留言列表 foreach (getUnreadPublicMessageByUserResult result in resultList) { Message message = new Message(); message.ID = result.id; message.messageType = MessageType.publicMessage; message.content = result.content; message.state = MessageState.Unread; //发留言的用户的信息 message.userFrom.UserName = result.userfrom; //发留言户的信息 ISingleResult<getUserByUserNameResult> UserInfoList = DBAccessor.getUserByUserName(result.userfrom); foreach (getUserByUserNameResult UserInfo in UserInfoList) { message.userFrom.NickName = UserInfo.nickname; message.userFrom.Phone = UserInfo.phone; message.userFrom.Address = UserInfo.address; message.userFrom.Email = UserInfo.email; message.userFrom.City = UserInfo.city; message.userFrom.Portrait = UserInfo.portraitPath; } PublicMessagesList.Add(message); } } catch (Exception e) { } return PublicMessagesList; }
//获得用户的评论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; }
//获得用户所有未读的站内信5 Ok public List<Message> GetUserUreadPrivateSiteMessages(String UserID) { List<Message> PrivateSiteMessageList = new List<Message>(); //数据访存器 DatabaseAccess.DataClasses1DataContext DBAccessor = new DataClasses1DataContext(); ISingleResult<getUnreadPrivateMessageByUserResult> resultList = DBAccessor.getUnreadPrivateMessageByUser(UserID); foreach (getUnreadPrivateMessageByUserResult result in resultList) { Message PrivateSiteMessage = new Message(); PrivateSiteMessage.ID = result.id; PrivateSiteMessage.messageType = MessageType.PrivateMessage; PrivateSiteMessage.state = MessageState.Unread; PrivateSiteMessage.content = result.content; PrivateSiteMessage.userFrom.UserName = result.userfrom;//发信用户 //发信用户的信息 ISingleResult<getUserByUserNameResult> UserInfoList = DBAccessor.getUserByUserName(result.userfrom); foreach (getUserByUserNameResult UserInfo in UserInfoList) { PrivateSiteMessage.userFrom.NickName = UserInfo.nickname; PrivateSiteMessage.userFrom.Phone = UserInfo.phone; PrivateSiteMessage.userFrom.Address = UserInfo.address; PrivateSiteMessage.userFrom.Email = UserInfo.email; PrivateSiteMessage.userFrom.City = UserInfo.city; PrivateSiteMessage.userFrom.School = UserInfo.school; PrivateSiteMessage.userFrom.Portrait = UserInfo.portraitPath; } PrivateSiteMessageList.Add(PrivateSiteMessage); } return PrivateSiteMessageList; }
//获得发向用户的订单8 ok public List<Order> GetOreders(String UserID) { List<Order> OrderList = new List<Order>(); //数据访存器 DatabaseAccess.DataClasses1DataContext DBAccessor = new DataClasses1DataContext(); try { ISingleResult<getOrderByUsertoResult> resultList = DBAccessor.getOrderByUserto(UserID); foreach (getOrderByUsertoResult result in resultList) { Order order = new Order(); order.ID = result.id; order.userTo.UserName = result.userto; //下面获得发订单的用户 order.userFrom.UserName = result.userfrom; //发订单用户的信息 ISingleResult<getUserByUserNameResult> UserInfoList = DBAccessor.getUserByUserName(result.userfrom); foreach (getUserByUserNameResult UserInfo in UserInfoList) { order.userFrom.NickName = UserInfo.nickname; order.userFrom.Phone = UserInfo.phone; order.userFrom.Address = UserInfo.address; order.userFrom.Email = UserInfo.email; order.userFrom.City = UserInfo.city; order.userFrom.Portrait = UserInfo.portraitPath; } //查找次订单所对应的所有商品 ISingleResult<getCommodityByOrederResult> commmodityListresult = DBAccessor.getCommodityByOreder(result.id); //获得订单所对应的商品列表 foreach (getCommodityByOrederResult commmodityResult in commmodityListresult) { Commodity commodity = new Commodity(); commodity.ID = commmodityResult.id; commodity.Name = commmodityResult.name; commodity.UserName = commmodityResult.userfrom; commodity.kind = (CommodityKind)(int)commodity.kind; commodity.StartTime = (DateTime)commmodityResult.starttime; commodity.EndTime = (DateTime)commmodityResult.endtime; commodity.description = commmodityResult.discription; commodity.ImageUrl = commmodityResult.picturepath; commodity.Price = (int)commmodityResult.price; //获得商品的tag列表 ISingleResult<getTagByCommodityResult> tagResultList = DBAccessor.getTagByCommodity(commmodityResult.id); foreach (getTagByCommodityResult tagResult in tagResultList) { Tag tag = new Tag(); tag.name = tagResult.id; tag.popularity = (int)tagResult.popularity; //加入商品的Tag列表 commodity.tagList.Add(tag); } //把商品加入订单的商品列表 order.commodityList.Add(commodity); } //订单加入订单列表 OrderList.Add(order); } } catch (Exception e) { } return OrderList; }