public ActionResult Index() { var user = CurrentUser; var messages = _messageService.GetUserMessages(user.Id, 0, MessageType.All).ToList(); var mcm = new MessageCenterModel { InfoMessages = messages.Where(n => n.MessageType == MessageType.Weibo && n.FromUserId != CurrentUser.Id).ToList(), User = user }; foreach (var infoMessage in mcm.InfoMessages) { infoMessage.Question = _questionService.GetByGuid(infoMessage.RelateGuid); } //我的好友 var fs = _firendService.GetAllFirends(user.Id); IList <Message> pm = new List <Message>(); foreach (var f in fs) { var mes = _messageService.GetLastMessage(user.Id, f.FirendId); if (mes != null) { pm.Add(mes); } } mcm.PrivateMessage = pm; //获取 未读的总条数 var rewards = _messageService.GetAllMessages(0, user.Id, MessageType.Reward); var rewarded = _messageService.GetAllMessages(0, user.Id, MessageType.SystemInfo); mcm.SystemMessage.AddRange(rewarded); mcm.SystemMessage.AddRange(rewards); mcm.SystemMessage.AddRange(_messageService.GetAllMessages(0, user.Id, MessageType.ReChange)); mcm.SystemMessage.AddRange(_messageService.GetAllMessages(0, user.Id, MessageType.BuyInfo)); return(View(mcm)); }
public List <MessageCenterModel> GetMessageListDetails(Hashtable listingsCriteria) { var _db = new DBUtility(); var token = new List <MessageCenterModel>(); var _dt = new DataTable(); _cmd = new SqlCommand(); _cmd.CommandType = CommandType.StoredProcedure; _cmd.CommandText = "GP_SP_GetMessageCenterListing"; if (string.IsNullOrWhiteSpace(Convert.ToString(listingsCriteria["UserID"]))) { _cmd.Parameters.AddWithValue("@UserId", DBNull.Value); } else { _cmd.Parameters.AddWithValue("@UserId", Convert.ToString(listingsCriteria["UserID"]).Trim()); } _dt = _db.FillDataTable(_cmd, _dt); if (_dt.Rows.Count > 0) { foreach (DataRow dr in _dt.Rows) { var temp = new MessageCenterModel(); temp.ID = Convert.ToInt64(dr["ID"]); temp.Subject = Convert.ToString(dr["CommentSubject"]); temp.MessageBody = Convert.ToString(dr["MessageBody"]); temp.IsRead = Convert.ToBoolean(dr["IsRead"]); temp.ProfileImage = Convert.ToString(dr["ProfileImage"]); temp.ToUser = Convert.ToString(dr["ToUser"]); temp.FromUser = Convert.ToString(dr["FromUser"]); temp.Duration = Convert.ToString(dr["Duration"]); temp.Sender = Convert.ToInt64(dr["Sender"]); temp.ListingDetailsID = Convert.ToInt64(dr["ListingDetailsID"]); temp.IsArchived = Convert.ToBoolean(dr["IsArchived"]); token.Add(temp); } } return(token); }