//获得用户的未读留言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;
}
