public async Task LeaveGroup(UserMessageData userMessageData)
{
await Groups.RemoveAsync(Context.ConnectionId, userMessageData.GroupName);
await Clients.OthersInGroup(userMessageData.GroupName).SendAsync("sendDisconnectNoticeToGroup", userMessageData);
await Clients.Client(Context.ConnectionId).SendAsync("okToStopConnection");
}
public async Task JoinGroup(UserMessageData userMessageData)
{
userMessageData.ID = Context.ConnectionId;
await Groups.AddAsync(Context.ConnectionId, userMessageData.GroupName);
await Clients.Client(userMessageData.ID).SendAsync("sendConnectionNoticeToSelf", userMessageData);
await Clients.OthersInGroup(userMessageData.GroupName).SendAsync("sendConnectionNoticeToGroup", userMessageData);
}
/// <summary>
/// 加载消息条数
/// </summary>
/// <param name="userId"></param>
/// <param name="state"></param>
private void LoadTotalOrders(int userId, string state)
{
DBHelper mdb = new DBHelper();
mdb.Connect();
int msgCount = UserMessageData.GetMsgNum(userId, state, mdb.GetConn);
AspNetPager.RecordCount = msgCount;
mdb.Disconnect();
LoadMsg(userId, state); // 加载用户消息
}
/// <summary>
/// 加载消息
/// </summary>
/// <param name="userId"></param>
/// <param name="state"></param>
private void LoadMsg(int userId, string state)
{
int startIndex = AspNetPager.StartRecordIndex; // 表的起始位置
int endIndex = AspNetPager.EndRecordIndex; // 表的结束位置
DBHelper mdb = new DBHelper();
mdb.Connect();
// 加载用户消息并绑定到Repeater
Repeater_MyMsg.DataSource = UserMessageData.GetMyMsgByUserID(userId, endIndex - startIndex + 1, endIndex, state, mdb.GetConn);
Repeater_MyMsg.DataBind();
mdb.Disconnect();
}
/// <summary>
/// 执行提交评论业务，将评论信息存入数据库
/// </summary>
/// <param name="comment"></param>
/// <param name="msg"></param>
/// <returns></returns>
public static bool CommitComment(Comment comment, UserMessage msg)
{
bool result = false;
lock (mLockObj)
{
mdb.Connect();
result = CommentData.InsertNewCommentForArticle(comment, mdb.GetConn);
result = UserMessageData.InsertNewMessage(msg, mdb.GetConn);
mdb.Disconnect();
}
return(result);
}
