/// <summary>
/// 用户获取信息列表
/// </summary>
/// <returns>成功返回用户信息,失败返回Null.</returns>
public ReturnItem <List <RetUserMessageRel> > GetAllMessageToUser(UserMessageRelModel parameter, string GetUserID)
{
ReturnItem <List <RetUserMessageRel> > r = new ReturnItem <List <RetUserMessageRel> >();
List <RetUserMessageRel> listinfo = new List <RetUserMessageRel>();
using (UserEntities user = new UserEntities())
{
try
{
var getuserid = Convert.ToInt32(GetUserID);
var messageList = user.U_Message.Join(user.U_UserMessageRel, x => x.ID, x => x.MessageID, (a, b) => new { a, b }).Where(x => x.b.UserID == getuserid).AsQueryable();
if (parameter.Status != null && !"".Equals(parameter.Status))
{
messageList = messageList.Where(x => x.b.Status == parameter.Status);
}
if (!"".Equals(parameter.Type) && parameter.Type != null)
{
messageList = messageList.Where(x => x.a.Type == parameter.Type.ToString());
}
messageList = messageList.OrderByDescending(x => x.a.CreateTime);
if (messageList == null)
{
r.Data = null;
r.Code = -1;
r.Msg = "没有数据";
return(r);
}
if (messageList != null)
{
var list = messageList.ToList();
r.Count = messageList.Count();
r.Msg = "消息列表获取成功";
r.Code = 0;
foreach (var item in list)
{
var info = new RetUserMessageRel();
info.ID = item.a.ID;
info.Type = item.a.Type;
info.Tittle = item.a.Tittle;
info.Text = item.a.Text;
info.CreateTime = item.a.CreateTime;
info.CreateUserID = item.a.CreateUserID;
info.Status = item.b.Status;
listinfo.Add(info);
}
r.Data = listinfo;
}
}
catch (Exception e)
{
r.Msg = "内部错误请重试";
log.ErrorFormat("内部错误：{0},{1}", e.Message, e.StackTrace);
r.Code = -1;
return(r);
}
}
return(r);
}
public IHttpActionResult GetAllMessageToUser(UserMessageRelModel model)
{
UserApi api = new UserApi();
var userApi = api.GetUserInfoByToken();
string GetUserID = userApi.Data.UserId;
MessageBLL msg = new MessageBLL();
var get = msg.GetAllMessageToUser(model, GetUserID);
return(InspurJson <List <RetUserMessageRel> >(get));
}
/// <summary>
/// 首页展示获取未读信息列表
/// </summary>
/// <returns>成功返回消息信息,失败返回Null.</returns>
public ReturnItem <List <RetUserMessageRel> > GetAllUnreadMessage(UserMessageRelModel parameter, string GetUserID)
{
ReturnItem <List <RetUserMessageRel> > r = new ReturnItem <List <RetUserMessageRel> >();
List <RetUserMessageRel> listinfo = new List <RetUserMessageRel>();
using (UserEntities user = new UserEntities())
{
try
{
var getuserid = Convert.ToInt32(GetUserID);
var messageList = user.U_Message.Join(user.U_UserMessageRel, x => x.ID, x => x.MessageID, (a, b) => new { a, b })
.Where(x => x.b.UserID == getuserid && x.b.Status == "0").AsQueryable();
messageList = messageList.OrderByDescending(x => x.a.CreateTime);
if (messageList == null)
{
r.Data = null;
r.Code = -1;
r.Msg = "没有数据";
return(r);
}
if (messageList != null)
{
var list = messageList.ToList();
r.Count = messageList.Count();
r.Msg = "消息列表获取成功";
r.Code = 0;
}
}
catch (Exception e)
{
r.Msg = "内部错误请重试";
log.ErrorFormat("内部错误：{0},{1}", e.Message, e.StackTrace);
r.Code = -1;
return(r);
}
}
return(r);
}
