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);
}
