public async Task <IHttpActionResult> vGroupUser()
{
object db_Result = null;
using (var db = new ModelAC())
{
db_Result = db.Im_UserGroup
.OrderBy(p => p.IM_Group_Id)
.ThenByDescending(p => p.CreateTime)
.Take(100)
.Select(p => new
{
Id = p.Id,
IM_Group_Id = p.IM_Group_Id,
GroupId = p.IM_Group.GroupId,
GroupName = p.IM_Group.GroupName,
IM_User_Id = p.IM_User_Id,
UserId = p.IM_User.UserId,
Name = p.IM_User.Name,
GroupPosition = p.GroupPosition,
CreateTime = p.CreateTime,
}).ToList();
}
return(Ok(db_Result));
}
public async Task <IHttpActionResult> vChatterActorBySingle()
{
object db_Result = null;
using (var db = new ModelAC())
{
db_Result = db.IM_ChatterActor
.Where(p => p.IM_Chatter.ChatType == IM_ChatType.Single)
.OrderBy(p => p.ChatterId)
.Take(10)
.Select(p => new
{
Id = p.Id,
App_Id = p.App_Id,
Single_A_IM_User = p.IM_Chatter.Single_A_IM_User.UserId,
Single_B_IM_User = p.IM_Chatter.Single_B_IM_User.UserId,
UserId = p.IM_User.UserId,
Name = p.IM_User.Name,
Last_MsgId = p.Last_MsgId,
UnreadMsgCount = p.UnreadMsgCount,
ChatterTime = p.ChatterTime,
IsCleared = p.IsCleared,
}).ToList();
}
return(Ok(db_Result));
}
public async Task <IHttpActionResult> vMsgSingle()
{
object db_Result = null;
using (var db = new ModelAC())
{
db_Result = db.IM_MsgSingle
.OrderByDescending(p => p.MsgTime)
.Take(10)
.Select(p => new
{
Id = p.Id,
App_Id = p.App_Id,
MsgClientId = p.MsgClientId,
MsgTime = p.MsgTime,
MsgType = p.MsgType,
MsgBody = p.MsgBody,
From_UserId = p.From_IM_User.UserId,
From_Name = p.From_IM_User.Name,
To_UserId = p.To_IM_User.UserId,
To_Name = p.To_IM_User.Name
}).ToList();
}
return(Ok(db_Result));
}
/// <summary>
/// 获取-单聊记录（分页）
/// </summary>
public object His_SingleHistory(IHis_SingleHistory model)
{
var user = LOGIN_USER;
List <OSingle_SendText> db_Result = new List <OSingle_SendText>();
using (var db = new ModelAC())
{
var userB = db.IM_User.SingleOrDefault(p => p.App_Id == APP_GUID && p.UserId == model.ChatId);
#region 数据查询
if (model.MsgId == null)
{//获取最新5条消息
db_Result = db.IM_MsgSingle
.Where(p => (p.From_UserId == user.Id && p.To_UserId == userB.Id) || (p.From_UserId == userB.Id && p.To_UserId == user.Id))
.OrderByDescending(p => p.SortId)
.Take(5)
.Select(p => new OSingle_SendText
{
#region 输出
Id = p.Id.ToString(),
MsgClientId = p.MsgClientId,
From_UserId = p.From_UserId == user.Id ? user.UserId : userB.UserId,
To_UserId = p.From_UserId == user.Id ? user.UserId : userB.UserId,
MsgTime = p.MsgTime,
IsRead = p.IsRead,
MsgType = p.MsgType,
MsgBody = p.MsgBody,
#endregion
})
.ToList();
}
else
{//获取MsgId之前5条消息
var msg = db.IM_MsgSingle.SingleOrDefault(p => p.App_Id == APP_GUID && p.Id == model.MsgId);
db_Result = db.IM_MsgSingle
.Where(p => p.SortId < msg.SortId)
.Where(p => (p.From_UserId == user.Id && p.To_UserId == userB.Id) || (p.From_UserId == userB.Id && p.To_UserId == user.Id))
.OrderByDescending(p => p.SortId)
.Take(5)
.Select(p => new OSingle_SendText
{
#region 输出
Id = p.Id.ToString(),
MsgClientId = p.MsgClientId,
From_UserId = p.From_UserId == user.Id ? user.UserId : userB.UserId,
To_UserId = p.From_UserId == user.Id ? user.UserId : userB.UserId,
MsgTime = p.MsgTime,
IsRead = p.IsRead,
MsgType = p.MsgType,
MsgBody = p.MsgBody,
#endregion
})
.ToList();
}
#endregion
}
var jsonResult = CommonJson.camelObject(db_Result);
return(jsonResult);
}
public async Task <IHttpActionResult> Login(string appKey, string account)
{
var user = new IM_User();
using (var db = new ModelAC())
{
user = db.IM_User.SingleOrDefault(p => p.App_Id == new Guid(appKey) && p.UserId == account);
}
if (user != null)
{
var userInfo = new
{
Account = user.UserId,
Name = user.Name,
Img = getSITE_URL() + "/content/useravatar/mine_001.png"
};
var loginResult = new LoginResult {
Status = true, Msg = "验证通过.", User = userInfo
};
return(Ok(loginResult));
}
else
{
var loginResult = new LoginResult {
Status = false, Msg = "没有账户信息."
};
return(Ok(loginResult));
}
}
/// <summary>
/// 发送-图片消息
/// </summary>
/// <returns></returns>
public object Group_SendPicture(IGroup_SendText model)
{
var user = LOGIN_USER;
var msg = new IM_MsgGroup();
var db_result = 0;
using (var db = new ModelAC())
{
#region db
msg.App_Id = APP_GUID;
msg.MsgClientId = model.MsgClientId;
msg.From_UserId = user.Id;
msg.To_GroupId =
db.IM_Group.SingleOrDefault(p => p.App_Id == APP_GUID && p.GroupId == model.To_GroupId).Id;
msg.MsgTime = DateTime.Now;
msg.IsFullRead = false;
msg.MsgType = model.MsgType;
msg.MsgBody = model.MsgBody;
db.IM_MsgGroup.Add(msg);
db_result = db.SaveChanges();
#endregion
}
var session_result = Group_updateSession(msg);
if (db_result == 1)
{
var mOGroup_SendText = new OGroup_SendText()
{
#region 输出
Id = msg.Id.ToString(),
MsgClientId = msg.MsgClientId,
From_UserId = model.From_UserId,
//From_UserImg = SITE_URL + user.PortraitUri,
To_GroupId = model.To_GroupId,
MsgTime = msg.MsgTime,
IsFullRead = msg.IsFullRead,
MsgType = msg.MsgType,
MsgBody = msg.MsgBody,
#endregion
};
var jsonResult = CommonJson.camelObject(mOGroup_SendText);
#region 消息分发
Clients.OthersInGroup(msg.To_GroupId.ToString()).Group_SendPicture(jsonResult);
#endregion
return(jsonResult);
}
else
{
return(null);
}
}
/// <summary>
/// 群主-加人
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public object GM_AddUsers(IGM_AddUsers model)
{
var mOGM_AddUsers = new OGM_AddUsers();
var group = new IM_Group();
var users_add = new List <IM_User>();
var db_result = 0;
using (var db = new ModelAC())
{
#region db
group = db.IM_Group.SingleOrDefault(p => p.App_Id == APP_GUID && p.GroupId == model.GroupId);
users_add = db.IM_User.Where(p => p.App_Id == APP_GUID && model.Accounts.Contains(p.UserId)).ToList();
foreach (var user in users_add)
{
var mIm_UserGroup = new Im_UserGroup();
mIm_UserGroup.IM_User_Id = user.Id;
mIm_UserGroup.IM_Group_Id = group.Id;
mIm_UserGroup.GroupPosition = IM_GroupPosition.Memeber;
db.Im_UserGroup.Add(mIm_UserGroup);
}
db_result = db.SaveChanges();
#endregion
}
if (db_result > 0)
{
mOGM_AddUsers.Success = true;
mOGM_AddUsers.Msg = "添加群成员成功!";
#region 连接组维护
var app_accounts = users_add.Select(p => HubKey.App__Account(app: APP, account: p.UserId)).ToList();
var connectionIDs = Base_GetConnectionIds(app_accounts);
foreach (var connectionId in connectionIDs)
{
//将连接添加到指定的组
Groups.Add(connectionId, group.Id.ToString());
}
#endregion
#region 更新相关群组聊表信息-发送系统通知
Update_GM_AddUsers(group);
#endregion
return(CommonJson.camelObject(mOGM_AddUsers));
}
else
{
mOGM_AddUsers.Success = false;
mOGM_AddUsers.Msg = "添加群成员失败!";
return(CommonJson.camelObject(mOGM_AddUsers));
}
}
/// <summary>
/// 是否存在群聊
/// </summary>
/// <param name="groupId">群聊编号</param>
/// <returns></returns>
private bool ImGroupExists(string groupId)
{
var db_result = 0;
using (var db = new ModelAC())
{
db_result = db.IM_Group.Count(e => e.App_Id == APP_GUID && e.GroupId == groupId);
}
return(db_result > 0);
}
/// <summary>
/// 群主-创建群
/// </summary>
public object GM_Create(IGM_Create model)
{
var mOGM_Create = new OGM_Create();
if (ImGroupExists(model.GroupId))
{
mOGM_Create.Success = false;
mOGM_Create.Msg = "已存在该群组编号";
return(CommonJson.camelObject(mOGM_Create));
}
var user = LOGIN_USER;
var group = new IM_Group();
var mIm_UserGroup = new Im_UserGroup();
var db_result = 0;
using (var db = new ModelAC())
{
#region db
group.App_Id = APP_GUID;
group.GroupId = model.GroupId;
group.GroupName = model.GroupName;
mIm_UserGroup.IM_User_Id = user.Id;
mIm_UserGroup.IM_Group_Id = group.Id;
mIm_UserGroup.GroupPosition = IM_GroupPosition.Founder;
db.IM_Group.Add(group);
db.Im_UserGroup.Add(mIm_UserGroup);
db_result = db.SaveChanges();
#endregion
}
if (db_result > 0)
{
mOGM_Create.Success = true;
mOGM_Create.Msg = "群聊创建成功!";
//将连接添加到指定的组
Groups.Add(Context.ConnectionId, group.Id.ToString());
return(CommonJson.camelObject(mOGM_Create));
}
else
{
mOGM_Create.Success = false;
mOGM_Create.Msg = "服务器错误!";
return(CommonJson.camelObject(mOGM_Create));
}
}
/// <summary>
/// 获取-好友
/// </summary>
/// <returns></returns>
public object FG_GetFriends()
{
List <OFG_GetFriends> resFriends = null;
using (var db = new ModelAC())
{
var friends = db.IM_User.Where(p => p.App_Id == APP_GUID && p.UserId != ACCOUNT).OrderBy(p => p.Name);
resFriends = friends.Select(p => new OFG_GetFriends
{
Account = p.UserId,
Name = p.Name,
Img = SITE_URL + p.PortraitUri
}).ToList();
}
return(CommonJson.camelObject(resFriends));
}
/// <summary>
/// 会话-重置未读消息数
/// </summary>
/// <returns></returns>
public object Chatter_ResetUnreadMsg(IChatter_ResetUnreadMsg model)
{
var user = LOGIN_USER;
IM_ChatterActor chatterActor = null;
var db_result = 0;
using (var db = new ModelAC())
{
if (model.SessionType == IM_ChatType.Single)
{
var userB = db.IM_User.SingleOrDefault(p => p.App_Id == APP_GUID && p.UserId == model.ChatId);
chatterActor = db.IM_ChatterActor
.SingleOrDefault(p => p.App_Id == APP_GUID && p.IM_Chatter.ChatType == IM_ChatType.Single && p.UserId == user.Id &&
((p.IM_Chatter.Single_A_UserId == user.Id && p.IM_Chatter.Single_B_UserId == userB.Id) ||
(p.IM_Chatter.Single_A_UserId == userB.Id && p.IM_Chatter.Single_B_UserId == user.Id)));
chatterActor.UnreadMsgCount = 0;
db_result = db.SaveChanges();
}
else if (model.SessionType == IM_ChatType.Group)
{
var group = db.IM_Group.SingleOrDefault(p => p.App_Id == APP_GUID && p.GroupId == model.ChatId);
chatterActor = db.IM_ChatterActor
.SingleOrDefault(p => p.App_Id == APP_GUID && p.IM_Chatter.ChatType == IM_ChatType.Group && p.UserId == user.Id && p.IM_Chatter.Group_GroupId == group.Id);
chatterActor.UnreadMsgCount = 0;
db_result = db.SaveChanges();
}
}
if (db_result == 1)
{
var jsonResult = CommonJson.camelObject(new OChatter_ResetUnreadMsg
{
ChatId = model.ChatId,
SessionId = chatterActor.ChatterId.ToString(),
SessionType = model.SessionType,
UnreadMsgCount = chatterActor.UnreadMsgCount
});
return(jsonResult);
}
else
{
return(null);
}
}
/// <summary>
/// 获取群组成员列表
/// </summary>
/// <param name="groupId"></param>
private List <OGM_GroupInfo> Get_GroupMembers(string groupId)
{
var resMembers = new List <OGM_GroupInfo>();
using (var db = new ModelAC())
{
var group = db.IM_Group.SingleOrDefault(p => p.App_Id == APP_GUID && p.GroupId == groupId);
resMembers = db.Im_UserGroup
.Where(p => p.IM_Group_Id == group.Id)
.Select(p => new OGM_GroupInfo
{
GroupPosition = p.GroupPosition,
Account = p.IM_User.UserId,
Name = p.IM_User.Name,
Img = SITE_URL + p.IM_User.PortraitUri,
}).ToList();
}
return(resMembers);
}
/// <summary>
/// 获取群组集合
/// </summary>
private IList <OFG_GetGroups> Base_GetGroups()
{
var user = LOGIN_USER;
List <OFG_GetGroups> resGroups = null;
using (var db = new ModelAC())
{
resGroups = db.Im_UserGroup
.Where(p => p.IM_User_Id == user.Id)
.Select(p => new OFG_GetGroups
{
Id = p.IM_Group_Id.ToString(),
GroupId = p.IM_Group.GroupId,
GroupName = p.IM_Group.GroupName,
GroupPosition = p.GroupPosition
}).ToList();
}
return(resGroups);
}
/// <summary>
/// 发送-图片消息
/// </summary>
/// <returns></returns>
public object Single_SendPicture(ISingle_SendText model)
{
var msg = new IM_MsgSingle();
var db_result = 0;
using (var db = new ModelAC())
{
#region db
msg.App_Id = APP_GUID;
msg.MsgClientId = model.MsgClientId;
msg.From_UserId =
db.IM_User.SingleOrDefault(p => p.App_Id == APP_GUID && p.UserId == model.From_UserId).Id;
msg.To_UserId =
db.IM_User.SingleOrDefault(p => p.App_Id == APP_GUID && p.UserId == model.To_UserId).Id;
msg.MsgTime = DateTime.Now;
msg.IsRead = false;
msg.MsgType = model.MsgType;
msg.MsgBody = model.MsgBody;
db.IM_MsgSingle.Add(msg);
db_result = db.SaveChanges();
#endregion
}
var session_result = Single_updateSession(msg);
if (db_result == 1)
{
var mOSingle_SendText = new OSingle_SendText()
{
#region 输出
Id = msg.Id.ToString(),
MsgClientId = msg.MsgClientId,
From_UserId = model.From_UserId,
To_UserId = model.To_UserId,
MsgTime = msg.MsgTime,
IsRead = msg.IsRead,
MsgType = msg.MsgType,
MsgBody = msg.MsgBody,
#endregion
};
var jsonResult = CommonJson.camelObject(mOSingle_SendText);
#region 消息分发
string to__Account = HubKey.App__Account(app: APP, account: model.To_UserId);
using (var db = new SignalR_MapUsersModel())
{
var connections = db.Connections.Where(p => p.User_UserName == to__Account && p.Connected == true).ToList();
for (int i = 0; i < connections.Count(); i++)
{
Clients.Client(connections[i].ConnectionID).Single_SendPicture(jsonResult);
}
}
#endregion
return(jsonResult);
}
else
{
return(null);
}
}
/// <summary>
/// 更新会话
/// 单聊
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
private bool Single_updateSession(IM_MsgSingle msg)
{
var user = LOGIN_USER;
var db_result = 0;
using (var db = new ModelAC())
{
var session = db.IM_Chatter.SingleOrDefault(p => p.App_Id == APP_GUID && p.ChatType == IM_ChatType.Single &&
((p.Single_A_UserId == msg.From_UserId && p.Single_B_UserId == msg.To_UserId) ||
(p.Single_A_UserId == msg.To_UserId && p.Single_B_UserId == msg.From_UserId))
);
if (session == null)
{
#region 新增会话
var newSession = new IM_Chatter()
{
App_Id = APP_GUID,
ChatType = IM_ChatType.Single,
Single_A_UserId = msg.From_UserId,
Single_B_UserId = msg.To_UserId,
Group_GroupId = null,
};
newSession.IM_ChatterActors.Add(new IM_ChatterActor()
{//消息发送者
App_Id = APP_GUID,
ChatterId = newSession.Id,
UserId = msg.From_UserId,
Last_MsgId = msg.Id,
UnreadMsgCount = 0,
ChatterTime = DateTime.Now,
IsCleared = false,
});
newSession.IM_ChatterActors.Add(new IM_ChatterActor()
{//消息接收者
App_Id = APP_GUID,
ChatterId = newSession.Id,
UserId = msg.To_UserId,
Last_MsgId = msg.Id,
UnreadMsgCount = 1,
ChatterTime = DateTime.Now,
IsCleared = false,
});
db.IM_Chatter.Add(newSession);
db_result = db.SaveChanges();
#endregion
}
else
{
#region 更新会话
foreach (var toActor in session.IM_ChatterActors)
{
toActor.Last_MsgId = msg.Id;
if (toActor.UserId != user.Id)
{//消息接收者
toActor.UnreadMsgCount += 1;
}
toActor.ChatterTime = DateTime.Now;
}
db_result = db.SaveChanges();
#endregion
}
}
return(db_result > 0);
}
/// <summary>
/// 获取-群聊记录（分页）
/// </summary>
public object His_GroupHistory(IHis_GroupHistory model)
{
var user = LOGIN_USER;
List <OGroup_SendText> db_Result = new List <OGroup_SendText>();
using (var db = new ModelAC())
{
var group = db.IM_Group.SingleOrDefault(p => p.App_Id == APP_GUID && p.GroupId == model.ChatId);
#region 数据查询
if (model.MsgId == null)
{//获取最新5条消息
db_Result = db.IM_MsgGroup
.Where(p => p.To_GroupId == group.Id)
.OrderByDescending(p => p.SortId)
.Take(5)
.Select(p => new OGroup_SendText
{
#region 输出
Id = p.Id.ToString(),
MsgClientId = p.MsgClientId,
From_UserId = p.From_IM_User.UserId,
//From_UserImg = SITE_URL + p.From_IM_User.PortraitUri,
To_GroupId = group.GroupId,
MsgTime = p.MsgTime,
IsFullRead = p.IsFullRead,
MsgType = p.MsgType,
MsgBody = p.MsgBody,
#endregion
})
.ToList();
}
else
{//获取MsgId之前5条消息
var msg = db.IM_MsgGroup.SingleOrDefault(p => p.App_Id == APP_GUID && p.Id == model.MsgId);
db_Result = db.IM_MsgGroup
.Where(p => p.SortId < msg.SortId)
.Where(p => p.To_GroupId == group.Id)
.OrderByDescending(p => p.SortId)
.Take(5)
.Select(p => new OGroup_SendText
{
#region 输出
Id = p.Id.ToString(),
MsgClientId = p.MsgClientId,
From_UserId = p.From_IM_User.UserId,
//From_UserImg = SITE_URL + p.From_IM_User.PortraitUri,
To_GroupId = group.GroupId,
MsgTime = p.MsgTime,
IsFullRead = p.IsFullRead,
MsgType = p.MsgType,
MsgBody = p.MsgBody,
#endregion
})
.ToList();
}
#endregion
}
var jsonResult = CommonJson.camelObject(db_Result);
return(jsonResult);
}
/// <summary>
/// 更新会话
/// 群聊
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
private bool Group_updateSession(IM_MsgGroup msg)
{
var user = LOGIN_USER;
//所有群聊成员
var allMembers = new List <Guid>();
var db_result = 0;
using (var db = new ModelAC())
{
allMembers = db.Im_UserGroup.Where(p => p.IM_Group_Id == msg.To_GroupId).Select(p => p.IM_User_Id).ToList();
var session = db.IM_Chatter.SingleOrDefault(p =>
p.App_Id == APP_GUID && p.ChatType == IM_ChatType.Group && p.Group_GroupId == msg.To_GroupId);
if (session == null)
{
#region 新增会话
var newSession = new IM_Chatter()
{
App_Id = APP_GUID,
ChatType = IM_ChatType.Group,
Single_A_UserId = null,
Single_B_UserId = null,
Group_GroupId = msg.To_GroupId,
};
newSession.IM_ChatterActors.Add(new IM_ChatterActor()
{//消息发送者
App_Id = APP_GUID,
ChatterId = newSession.Id,
UserId = msg.From_UserId,
Last_MsgId = msg.Id,
UnreadMsgCount = 0,
ChatterTime = DateTime.Now,
IsCleared = false,
});
allMembers.Remove(msg.From_UserId);
foreach (var memeberId in allMembers)
{//消息接收者
newSession.IM_ChatterActors.Add(new IM_ChatterActor()
{
App_Id = APP_GUID,
ChatterId = newSession.Id,
UserId = memeberId,
Last_MsgId = msg.Id,
UnreadMsgCount = 1,
ChatterTime = DateTime.Now,
IsCleared = false,
});
}
db.IM_Chatter.Add(newSession);
db_result = db.SaveChanges();
#endregion
}
else
{
#region 更新会话
List <Guid> oldIM_ChatterActors = session.IM_ChatterActors.Select(p => p.UserId).ToList();
List <Guid> expectedList = allMembers.Except(oldIM_ChatterActors).ToList();
foreach (var toActor in session.IM_ChatterActors)
{//更新会话参与者
toActor.Last_MsgId = msg.Id;
if (toActor.UserId != user.Id)
{//消息接收者
toActor.UnreadMsgCount += 1;
}
toActor.ChatterTime = DateTime.Now;
}
if (expectedList.Exists(p => p == msg.From_UserId))
{//新增会话参与者-消息发送者
expectedList.Remove(msg.From_UserId);
session.IM_ChatterActors.Add(new IM_ChatterActor()
{
App_Id = APP_GUID,
ChatterId = session.Id,
UserId = msg.From_UserId,
Last_MsgId = msg.Id,
UnreadMsgCount = 0,
ChatterTime = DateTime.Now,
IsCleared = false,
});
}
foreach (var memeberId in expectedList)
{//新增会话参与者-消息接收者
session.IM_ChatterActors.Add(new IM_ChatterActor()
{
App_Id = APP_GUID,
ChatterId = session.Id,
UserId = memeberId,
Last_MsgId = msg.Id,
UnreadMsgCount = 1,
ChatterTime = DateTime.Now,
IsCleared = false,
});
}
db_result = db.SaveChanges();
#endregion
}
}
return(db_result > 0);
}
public async Task <IHttpActionResult> vSessionByUser(Guid APP_GUID, Guid userId)
{
List <OChatter_ChatterInfo> db_Result = new List <OChatter_ChatterInfo>();
using (var db = new ModelAC())
{
List <OChatter_ChatterInfo> sessions = new List <OChatter_ChatterInfo>();
#region 单聊会话
var single = db.IM_ChatterActor
.Where(p => p.App_Id == APP_GUID && p.IM_Chatter.ChatType == IM_ChatType.Single && p.UserId == userId)
.Select(p => new OChatter_ChatterInfo
{
ChatId = p.IM_Chatter.Single_A_UserId == userId ? p.IM_Chatter.Single_B_IM_User.UserId : p.IM_Chatter.Single_A_IM_User.UserId,
ChatName = p.IM_Chatter.Single_A_UserId == userId ? p.IM_Chatter.Single_B_IM_User.Name : p.IM_Chatter.Single_A_IM_User.Name,
ChatImg = string.Empty + p.IM_User.PortraitUri,
SessionId = p.ChatterId.ToString(),
SessionType = p.IM_Chatter.ChatType,
UnreadMsgCount = p.UnreadMsgCount,
ChatterTime = p.ChatterTime,
Messages = new HashSet <object>()
{
db.IM_MsgSingle.Where(s => s.Id == p.Last_MsgId)
.Select(m => new OSingle_SendText {
Id = m.Id.ToString(),
MsgClientId = m.MsgClientId,
From_UserId = m.From_IM_User.UserId,
To_UserId = m.To_IM_User.UserId,
MsgTime = m.MsgTime,
IsRead = m.IsRead,
MsgType = m.MsgType,
MsgBody = m.MsgBody,
}).FirstOrDefault()
},
});
#endregion
#region 群聊会话
var group = db.IM_ChatterActor
.Where(p => p.App_Id == APP_GUID && p.IM_Chatter.ChatType == IM_ChatType.Group && p.UserId == userId)
.Select(p => new OChatter_ChatterInfo
{
ChatId = p.IM_Chatter.Group_IM_Group.GroupId,
ChatName = p.IM_Chatter.Group_IM_Group.GroupName,
ChatImg = null,
SessionId = p.ChatterId.ToString(),
SessionType = p.IM_Chatter.ChatType,
UnreadMsgCount = p.UnreadMsgCount,
ChatterTime = p.ChatterTime,
Messages = new HashSet <object>()
{
db.IM_MsgSingle.Where(s => s.Id == p.Last_MsgId)
.Select(m => new OSingle_SendText {
Id = m.Id.ToString(),
MsgClientId = m.MsgClientId,
From_UserId = m.From_IM_User.UserId,
To_UserId = m.To_IM_User.UserId,
MsgTime = m.MsgTime,
IsRead = m.IsRead,
MsgType = m.MsgType,
MsgBody = m.MsgBody,
}).FirstOrDefault()
},
});
#endregion
sessions.AddRange(single);
sessions.AddRange(group);
db_Result = sessions.OrderByDescending(p => p.ChatterTime).ToList();
}
var jsonResult = CommonJson.camelObject(db_Result);
return(Ok(jsonResult));
}
